https://bugs.documentfoundation.org/show_bug.cgi?id=141495
--- Comment #10 from Peter Johnson <[email protected]> --- 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.
