[Libreoffice-bugs] [Bug 142293] New: EDATE function problem in a file saved as Excel format

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142293

            Bug ID: 142293
           Summary: EDATE function problem in a file saved as Excel format
           Product: LibreOffice
           Version: 7.1.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: yanfiz at gmail.com

Description:
If you save the spreadsheet as Excel format while your text language is
Turkish, EDATE function will be converted to a function like
com.sun.star.sheet.addİn.analysİs.getedate.

If EDATE is used as an single formula, it will continue to display the correct
date.

https://i.postimg.cc/3wF3JQ1V/Single.png

But, if EDATE is used in a nested formula, it will give #NAME? error.

https://i.postimg.cc/43gJgx6p/Nested.png



(My surmise : Something in LibreOffice text language engines, makes some faults
when converting cases to upper or lower?!)

Steps to Reproduce:
1. Open Calc.
2. Select text language as Turkish from the lowest bar.
3. Make a formula that used EDATE function in it.
4. Save the file as Excel format.
5. Close file and reopen it.

Actual Results:
EDATE turns into com.sun.star.sheet.addİn.analysİs.getedate.

Expected Results:
EDATE should be stay as EDATE.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: tr-TR (en_US); UI: en-US
Calc: CL

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210514/73d10047/attachment-0001.htm>