https://bugs.documentfoundation.org/show_bug.cgi?id=166914
Telesto <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |UNCONFIRMED Resolution|NOTABUG |--- Keywords|bibisectRequest, regression | Ever confirmed|1 |0 --- Comment #7 from Telesto <[email protected]> --- (In reply to nobu from comment #6) > The detailed behavior of the VALUE function depends on your selected locale. > > https://help.libreoffice.org/latest/en-US/text/scalc/01/func_value.html > https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE > > The wiki shows what works correctly in all locales and (in English) what > works in the US locale. > * Locale-independent behaviors > * Locale-dependent behaviors Thanks for looking that up. https://wiki.documentfoundation.org/Documentation/Calc_Functions/VALUE The other part of the information Tools -> Options -> Language and Locales a field: Data Acceptance Patterns. https://help.libreoffice.org/25.2/en-US/text/shared/optionen/01140000.html?DbPAR=SHARED Adding the Data Acceptance Pattern Y/M/D makes VALUE work properly in the ODS case here. However Fabbian is right about the behaviour of VALUE being inconsistent. Opening a XLSX sheet in LibreOffice without Data Acceptance Pattern Y/M/D isn't showing error 502. Importing the ODS into MSO Calc does also show the value -- You are receiving this mail because: You are the assignee for the bug.
