https://bugs.freedesktop.org/show_bug.cgi?id=51438
Bug #: 51438
Summary: FILESAVE as xslx: cached formula result is not saved
for calculated date cells
Classification: Unclassified
Product: LibreOffice
Version: 3.5.4 release
Platform: x86-64 (AMD64)
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
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>
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
