When saving a spread sheet as xslx containing formula cells calculating a date, the formula result (i.e. the date value) is not saved. This makes it impossible to read that spreadsheet, e.g. using Apache POI in a Java application. When the saved spread sheet is opened in Microsoft Office and re-saved the calculated values are available. Some lines from sheet1.xml in a worbook containing a calculated date cell: Saved by LibreOffice (yes, I2 is really a date cell and should be saved as numeric value): <c r="I2" s="3" t="inlineStr"> <f aca="false">D2+1</f> <is> <t></t> </is> </c> Saved by Microsoft Office: <c r="I2" s="2"> <f t="shared" ref="I2:I14" si="3">D2+1</f> <v>39449</v> </c>
Please provide an attachment showing the problem. Marking as NEEDINFO until document is attached. Once it's attached please change back to UNCONFIRMED
Created attachment 64029 [details] xlsx-file with calculated date cell saved by LibreOffice The cell A2 (in sheet1.xml) claims to be of type inlineStr (instead of numeric) and does not hold any value. <c r="A2" s="1" t="inlineStr"> <f aca="false">A1+1</f> <is> <t></t> </is> </c>
Created attachment 64030 [details] xlsx-file with calculated date cell saved by Microsoft Excel The cell A2 correctly hold the formula and the calculated value 36527 <c r="A2" s="1"> <f>A1+1</f> <v>36527</v> </c>
Created attachment 64031 [details] xlsx-file with calculated date cell saved by Microsoft Excel The cell A2 correctly hold the formula and the calculated value 36527 <c r="A2" s="1"> <f>A1+1</f> <v>36527</v> </c>
I do see the issue with 3.6.2.1. Marking as NEW and prioritizing. Marking as: Normal: As it could result in a user not being able to easily create high quality work. Medium: The issue might go missed by the user and result in wrong data in a cell, something which could hurt the end user's professional quality work and make LibO look bad. Thanks for reporting, we'll try to get this one fixed soon
I re-tested this using the 4.2 branch build, and no longer see this problem.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.