Bug 142293 - EDATE function problem in a file saved as Excel format
Summary: EDATE function problem in a file saved as Excel format
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2021-05-14 23:54 UTC by Yan Fiz
Modified: 2021-05-15 16:06 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Yan Fiz 2021-05-14 23:54:08 UTC
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
Comment 1 Roman Kuznetsov 2021-05-15 16:06:07 UTC
no repro for RU locale

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: dbd4110cc36011042c98549d997daa79e8065aba
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL