[Libreoffice-bugs] [Bug 125055] New: XLSX export: a pivot table based on column having times with 1 s difference produces errors and is dropped when imported to Excel

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125055

            Bug ID: 125055
           Summary: XLSX export: a pivot table based on column having
                    times with 1 s difference produces errors and is
                    dropped when imported to Excel
           Product: LibreOffice
           Version: 6.0.0.0.alpha0+
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com

Created attachment 151103
  --> https://bugs.documentfoundation.org/attachment.cgi?id=151103&action=edit
A pivot table based on two close datetimes (1 s difference)

Opening the attached spreadsheet, and re-saving as XLSX, then opening in Excel,
produces warning about "found a problem with some content", then "Removed
Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part
(PivotTable view); Removed Records: Workbook properties from /xl/workbook.xml
part (Workbook)". The pivot table is dropped (replaces with static content).

Since commit
https://git.libreoffice.org/core/+/baed960b8ce55370a040d0c0f49bd3fdc16bdf84.

Not a regression: the said commit introduced saving datetime fields to pivot
tables; previous to that, such fields weren't stored properly at all
(implementation defect).

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190501/eaa8828a/attachment.html>