https://bugs.freedesktop.org/show_bug.cgi?id=63478
Priority: medium
Bug ID: 63478
CC: [email protected]
Assignee: [email protected]
Blocks: 36858
Summary: FILEOPEN does not honour
<table:calculation-settings><table:null-date
table:date-value="1900-01-01"/></table:calculation-set
tings>
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Writer
Product: LibreOffice
Created attachment 77895
--> https://bugs.freedesktop.org/attachment.cgi?id=77895&action=edit
reproduction case
Open attached OpenDocument text document. It contains the setting:
<table:calculation-settings>
<table:null-date table:date-value="1900-01-01"/>
</table:calculation-settings>
and an embedded table which has in particular these two cells:
<table:table-cell table:style-name="ce4"
office:date-value="1899-12-30T00:00:00.0Z" office:value-type="date" />
<table:table-cell table:style-name="ce5"
office:date-value="1899-12-30T00:00:00.0Z" office:value-type="date" />
Where style ce4 has a *date* data-style and ce5 has a *number* data-style.
The cell with style "ce5" should be displayed as "-2" (because the zero date is
set to 1900-01-01), but is displayed as "0".
The Base Report Builder tries to work around that, but it is kludge upon
kludge, which is fragile and each time one case is fixed, another corner case
crops up and breaks. I'd appreciate if this could be fixed cleanly in Writer to
streamline the Base Report Builder.
Thanks in advance!
--
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
