https://bugs.documentfoundation.org/show_bug.cgi?id=104186
--- Comment #4 from Victor V. Terber <vic...@terber.de> ---
Updated and corrected description:
Description:
When saving as XLSX document LO functions are handled differently with respect
to localisation if a blank is found between the function keyword and the
following brace.
When the OO-created XSLX-codument is opened in localised Excel, cells formulas
which use a function followed by a blank are not localised. Cells formulas
where a brace follows directly the function keyword are handled and shown
correctly.
Steps to Reproduce:
1. Create a blank calc sheet with LO 5.2.3.3 (German localisation)
2. Set a date in cell A1. Use in B1 the functions "=TAG(A1)", and in C1 "=TAG
(A1)". "TAG" is the German word for "DAY"
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: Cell B1 is ok, containing "=TAG(A1)". Cell C1 is
faulty, containing "=DAY (A1)".
Actual Results:
Cell C1() shows an error in Excel. The cell contains the formula "=DAY (A1)"
Expected Results:
Cell C1() should show the day of cell A1. The cell should contain the
(localised) formula "=TAG (A1)" as found in B1.
Reproducible: Always
User Profile Reset: No
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
