https://bz.apache.org/ooo/show_bug.cgi?id=82849
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CONFIRMED |RESOLVED Latest|--- |4.2.0-dev Confirmation in| | Resolution|--- |FIXED Summary|Excel XML filter loses |SpreadsheetML ss:DateTime |dates |cell value is loaded as | |either only a date or a | |time --- Comment #16 from [email protected] --- Fixed by: commit 0db4a4f44da1c0fb06154ba61c960a18427e751b Author: Damjan Jovanovic Date: Fri Jan 13 18:27:50 2023 +0200 Dates and times are loaded wrongly from SpreadsheetML files, because the filter loads only the date or time portion of the ss:DateTime based on the cell's style. Rather always load the ss:DateTime as our ODF office:date-value in the XMLSchema-2 dateTime format, with both its date and time part, and then rely on formatting to display only the date or time as desired. Fixes: #82849 - SpreadsheetML ss:DateTime cell value is loaded as either only a date or a time Patch by: Philip J. Turmel <[email protected]> Reviewed by: me -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue.
