Description: When a xlsx with a pivot table is opened in LO all of the pivot table’s cells lose their formatting and revert back to the default cell format. Steps to Reproduce: 1. Create a new xlsx in Excel and create a pivot table withs some data. 2. Give some of the cells formatting. 3. Save the file. 4. Open it in Calc. Actual Results: All of the cells in the pivot table. lose their formatting. Expected Results: They should keep all of their formatting even those that were given automatically by Excel. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 148013 [details] An xlsx with a pivot table with formatted cells.
Created attachment 148014 [details] Screenshot of the original document side by side in Excel and Calc.
Thank you for reporting the bug. I can confirm that the bug is present in Version: 6.3.0.0.alpha0+ Build ID: 3c964980da07892a02d5ac721d80558c459532d0 CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45 Locale: en-US (en_US); UI-Language: en-US Calc: threaded
Also reproduced in Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.15; Render: default; Version: 4.3.0.0.alpha1+ Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
Also reproduced in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Confirmed. Win 10 3.3.0
Created attachment 155302 [details] another sample where the borders are incorrect
repro 7.5+. Also lost on a file round-tripped by Excel 2003.
Confirmed on 7.6.1 and this is the single thing holding me to use libreoffice exclusively.
Created attachment 193685 [details] Screenshot of the example file in Excel 2016 and Calc master Still happens in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: d76f1877f699c91f5e4a020641c6d65064bfb997 CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: default after recent patches to improve xlsx cell formatting import.