https://bugs.documentfoundation.org/show_bug.cgi?id=145183
Bug ID: 145183
Summary: [1]
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: Other
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I have encountered what seems to be a structural fault in CALC Version: 6.4.7.2
Build ID: 1:6.4.7-0 ubuntu0.20.04.1
- the FIND() function cannot detect a decimal point within a zero field.
Suffixed is an extraction from a database - row 17, columns W to Z.
The command in cell Z17 is =LEFT(W17,FIND(".",W17)-1) and the result is in cell
Z17
Column : W X Y Z
Row 17 : 0.00 18 53 #VALUE!
In other cells in that column the command works correctly and if I change that
decimal point to a comma, then FIND() does find it.
I have tried the same thing in Gnumeric with the same result.
--
You are receiving this mail because:
You are the assignee for the bug.
