https://bugs.documentfoundation.org/show_bug.cgi?id=104186
Victor V. Terber <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|FILESAVE: XLSX export does |FILESAVE: XLSX export does
|break YEAR function |break localised functions
|depending on localisation |if a blank is found before
| |function brace
--- Comment #3 from Victor V. Terber <[email protected]> ---
My original (implicit) analysis was wrong:
The real trigger is not any specific function, but the fact that a blank is
found the LO formula between the function keyword and the following brace. The
original finding (that a specific function was wrongly translated into XLSX
format) was pure coincidence.
In fact, a cell with such a function is exported correctly and shown correctly
in a localized Excel sheet:
=YEAR(A1)
This translates correctly in a German Excel sheet into '=JAHR(A1)'
But following cell is shown incorrectly after saved as an XLSX:
=YEAR (A1)
This translates wrongly in a German Excel sheet into '=YEAR (A1)'
The provided test cases are therefore still valid.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
