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.