https://bugs.documentfoundation.org/show_bug.cgi?id=150733
Bug ID: 150733
Summary: Incorrect data with FILESAVE to XLSX when using EDATE
function and opened with MSO2016
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
After saving an XLSX file in MSO2016 using the EDATE function, opening the same
file in LibreOffice Calc, saving the file as XLSX again, then opening the file
in MSO2016 results it incorrect data.
Steps to Reproduce:
1.Open a new sheet in MSO2016 Excel
2.Fill cell A1 with =TODAY()
3.Fill cell A2 with =EDATE(A1,-24)
4.Format both cells as Date 3/14/2012 format
5.Save the file in the XLSX file format
6.Open the file with LibreOffice
7.Save the file in the .xlsx file format
7.Open the XLSX file in MSO2016 Excel
Actual Results:
The output in cell A2 shows #NAME?
Clicking on the cell reveals the function has changed to
=com.sun.star.sheet.addin.Analysis.getEdate(A1,-24)
Expected Results:
The output in cell A2 should show today's date minus 2 years.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 7.4.0.3 (x64) / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
Microsoft® Excel® 2016 MSO (Version 2207 Build 16.0.15427.20166) 32-bit
Renderer: AMD Radeon(TM) Graphics
Vendor: ATI Technologies Inc.
Version: 4.6.14800 Core Profile Forward-Compatible Context 22.5.1
30.0.15021.11005
Shading language version: 4.60
--
You are receiving this mail because:
You are the assignee for the bug.
