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
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
I can confirm with Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 0c3b8792b712e939d2ad524d554f96616b4844be CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: tr-TR (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo but not in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
*** Bug 148229 has been marked as a duplicate of this bug. ***
Note the capital İ U+0130 in the programmatic function name and in a tr-TR locale capital İ U+0130 transliterates to small i U+0069 capital I U+0049 transliterates to small ı U+0131
The odd thing is, I could identify how the upper-casing of the programmatic Add-In functions' names goes wrong, but I could not reproduce that such programmatic name gets saved to the document instead of the English function name, not even when using a tr-TR locale.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/36cb12bce80836a29e5124167b588490b3f7700d Related: tdf#142293 Do not use locale's uppercase for Add-In programmatic name It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/994d517a48f7e092ec57d179abb855ef5a86eacb Related: tdf#142293 Use the same locale to lowercase as was to uppercase It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/9aab475e221e1abee2108b21545f2bdaa48552e6 Related: tdf#142293 tdf#141495 Allow additional symbols in externals map It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
The last commit 9aab475e221e1abee2108b21545f2bdaa48552e6 allows reading and repairing such broken documents, but the cause why those programmatic names were written is unidentified.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/9f7ab29857a552be0f7141a7e49e3dd5291f19a6 Related: tdf#142293 Do not use locale's uppercase for Add-In programmatic name It will be available in 7.4.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/0c44a7b29c7ee393fa209b7fdf4c940cbace0fb5 Related: tdf#142293 Use the same locale to lowercase as was to uppercase It will be available in 7.4.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/e54ec5412d9196fb37979db2865b0305bc3d4ad1 Related: tdf#142293 tdf#141495 Allow additional symbols in externals map It will be available in 7.4.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/5d30e9e101ae8167c33fe24ca12d8d0685f9f8fb tdf#142293, tdf#141495: sc_subsequent_filters_test2: Add unittest It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/909cdd552199d35f7c10be0a8be370158aea0815 Resolves: tdf#142293 No "+ or - may start formula" when editing content It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/34745c2fdc6a9f75512f793310f95e17c72b6267 Resolves: tdf#142293 No "+ or - may start formula" when editing content It will be available in 7.4.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Ignore the last two commits, they should had been tagged with tdf#149589 instead.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/086055b0d7e44d1d07b3f23af55503e6a3924d87 Related: tdf#142293 Consider bAsciiUpper for matching CharClass to lowercase It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/9f3bce835e81dbdf07da9850a5157f4403819417 Related: tdf#142293 Consider bAsciiUpper for matching CharClass to lowercase It will be available in 7.4.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 150733 has been marked as a duplicate of this bug. ***
Created attachment 182130 [details] File saved with excel File working and saved with excel: Microsoft® Excel® para Microsoft 365 MSO (versión 2207 compilación 16.0.15427.20182) de 64 bits
I can finally reproduce the programmatic names of AddIns getting saved, it happens only if an OOXML .xlsx Excel document was loaded before any OOXML save and a FormulaCompiler base class OpCodeMap without AddIn mappings was instantiated and became permanent instead of the derived ScCompiler's final map.
Fwiw, the culprit this time (we had such already with bug 135993 at a different place) was formula::FormulaCompiler::GetOpCodeMap() in TokenStringContext::TokenStringContext(). Eliminating this trap once and for all..
*** Bug 141495 has been marked as a duplicate of this bug. ***
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/603f9ce4f39a59bd84b5c08e3d725e0ee664991f Related: tdf#142293 Introduce a protected FormulaCompiler::GetFinalOpCodeMap() It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b8a83c5c63873faf1a63205b8aad634f351d1a9f Related: tdf#142293 Use FormulaCompiler::GetFinalOpCodeMap() in ScCompiler It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/5aaa0cda74de4170972b7988d8fca16a560b8500 Resolves: tdf#142293 Implement the temporariness of GetOpCodeMap() It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/15acaddb54c3e14a49b0d26d879c4436d34933e1 Related: tdf#142293 Remove temporariness now implemented at GetOpCodeMap() It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/033e98dbe6aafd6719eb83ea4d2fc68110e195c9 Related: tdf#142293 Have ScCompiler::GetOpCodeMap() overwrite It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/c/core/+/139230 for 7-4
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-4": https://git.libreoffice.org/core/commit/ad15930e60b1e175d127022fd99fe71f140cbd88 Resolves: tdf#142293 Implement the temporariness of GetOpCodeMap() It will be available in 7.4.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Confirming the 9/11/22 Dev build does fix the EDATE function when saved in XLSX format and opened in MSO2016.
I very much look forward to this problem being fixed in LO 7.4. I have just encountered this again in 7.3.6.2 when all my EOMONTH formula were again corrupted as I described in bug 141495 (now closed as a duplicate). THis seems to happen "randomly" (i.e not reproducible at will) and the only choice is then to manually edit all the corrupted cells to remove the extra text string. In this particular spreadsheet, which I update weekly for my energy generation from solar panels and for my usage, I have now had to do this several times. At least there is good news that the issue has been isolated by Eike Rathke and a fix is in the pipeline. Thanks