[Libreoffice-bugs] [Bug 141495] CONFIGURATION = EOMONTH function corruption

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from Peter Johnson <info at pgnj.net> ---
Created attachment 174866
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174866&action=edit
Test files showing error

Here's a simple test that shows the issue.

My previous comment about syncing with Sharepoint or another user editing was
incorrect.  How I created the file:

Enter start value in cell A5 and EOMONTH formulae in B5:L5 and A7:L7. I didn't
format the dates to remove formatting as a possible factor.

Save with .xlsx format.

Open in Excel.

The start value displays but the formulae show a #NAME? error. To recover, it
is necessary to Find/Replace the value
'@com.sun.star.sheet.addin.Analysis.getEomonth' in all formulae in the workbook
in Excel and save. Then it is OK in Excel.

I am uploading a zip with two files:
'Test eomonth convert LO.xlsx' is the original file saved by LO 7.2.0.4
'Test eomonth convert EXCEL.xlsx' is the above file after the find/replace
step, and saved by Excel 16.52.

The files look identical in LO, but are the not the same in Excel.

-- 
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/20210907/bd00125f/attachment.htm>