https://bugs.documentfoundation.org/show_bug.cgi?id=160310
--- Comment #10 from ady <[email protected]> --- (In reply to Paul Thompson from comment #9) > Not quite, there are now two issues. > > The original issue I tracked down to a bar chart in an xlsx file. If you > open a spreadsheet in Calc that was created in Excel and contains a bar > chart, when you save it in Calc and reopen it in Excel, Excel reports an > error in an image file (the bar chart). That's the _export_ (to xlsx) issue I mentioned. > > The second issue, which I discovered while creating a non-confidential > spreadsheet, is that if you create a pivot table and then a bar chart from > the pivot table in Excel, when you open the file in Calc, the pivot table > has disappeared along with the chart. That's the _import_ (from xlsx) issue I mentioned. FWIW, using GSheets I can also see the difference between the attached files, although there was no error message while opening the file saved by Calc. For someone that has access to both Excel and Calc, it could be interesting to test whether the problem also occurs when the pivot table and its chart are created in the same worksheet as the original data (instead of having them in another worksheet, separated from the data). I'm not even sure that having these in separated worksheets is (correctly) supported. Someone (else) would need to replicate the problem from the start (and compare it with the above attachments): 1. Using Excel, create an xlsx file with a similar Pivot Table and Chart. 2. Open it in Calc > check how it is imported. 3. Save as a new xlsx file and close Calc. 4. Using Excel, open the new xlsx saved by Calc > check how it was exported (i.e. is there some error message in Excel about the file?). By generating a new file from scratch, and comparing the results with those in comments 5,6, the whole procedure is replicated. This would eliminate some particular setting or format in the specific documents and/or in the particular system in which those attachments were created. Since there seem to be 2 issues, once these problems are replicated by someone else, there might be a need to open a second bug report; one for the import and the other for the export. But, before investing more resources, the first question (which its answer IDK) is: Is this case supported by Calc at all? -- You are receiving this mail because: You are the assignee for the bug.
