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: libreoffice-bugs@lists.freedesktop.org Reporter: ke...@keithsayers.id.au 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.