https://bugs.documentfoundation.org/show_bug.cgi?id=104186
Bug ID: 104186
Summary: FILESAVE: XLSX export does break YEAR function
depending on localisation
Product: LibreOffice
Version: 5.2.3.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: vic...@terber.de
Description:
When saving as XLSX document the functions DAY(), MONTH() and YEAR() are
handled differently with respect to localisation.
When the OO-created XSLX-codument is opened in Excel, DAY() and MONTH() seem to
be ok, but YEAR() remains in English while it should be localised.
Steps to Reproduce:
1. Create a blank document with LO calc sheet with LO 5.2.3.3, using German
localisation
2. Use in the document the functions TAG() (German for DAY), MONAT() (German
for MONTH) and JAHR (German for YEAR).
3. Save as XLSX 'Microsoft Excel 2007-2013 XML (.xlsx)'
4. Open the XLSX document with a German version of Microsoft Excel 2016.
5. Observe the cells content: TAG() and MONAT() are correct, but instead of
JAHR() you find YEAR()! Any calculations with this function is obviously
broken.
Actual Results:
Function YEAR() is visible in Excel
Expected Results:
Function JAHR() should be visible in Excel
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101
Firefox/50.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
