https://bz.apache.org/ooo/show_bug.cgi?id=126754

          Issue ID: 126754
        Issue Type: DEFECT
           Summary: Text function not working when combined with Left
           Product: Calc
           Version: 4.1.1
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: formatting
          Assignee: [email protected]
          Reporter: [email protected]

When I try textvalues of 7a-z in 1 row and the following function in the second
row:    'LEFT(TEXT(Cell,1))', I get these results:

(this is a depiction of my file in OOCalc)
row 1   row 2

7a    7
7b    7
7c    7
7d    7
7e    1
7f    7
7g    7
7h    7
7l    7
7j    7
7k    7
7l    7
7m    7
7n    7
7o    7
7p    7
7q    7
7r    7
7s    7
7t    7
7u    7
7v    7
7w    7
7x    7
7y    7
7z    7

Note how only '7e'  is different from all the others. How can this be? This is
very troublesome when working with hexadecimal :(

-- 
You are receiving this mail because:
You are the assignee for the issue.

Reply via email to