| Summary: | FILEOPEN XLSX, Pivot table’s cells lose all their formatting in LO | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | NISZ LibreOffice Team <libreoffice> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | normal | CC: | aron.budea, erenoglu, ilmari.lauhakangas, kelemeng, marc, nemeth, quikee, xiscofauli |
| Priority: | medium | Keywords: | filter:xlsx |
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=41645 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 112416, 128382 | ||
| Attachments: |
An xlsx with a pivot table with formatted cells.
Screenshot of the original document side by side in Excel and Calc. another sample where the borders are incorrect Screenshot of the example file in Excel 2016 and Calc master |
||
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. |
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: