Description: The legend shows deleted legend entry too in Excel worksheet opened in LibreOffice 6.5.0.0.alpha0+ (x64). Steps to Reproduce: 1. Create an XLSX spreadsheet in Microsoft Excel. 2. Insert a Pie Chart. 3. Delete the second legend entry. 4. Save the file, and open it with LibreOffice 6.5.0.0.alpha0+ (x64). 5. View the attached screenshot. 6. Notice, that in LibreOffice Calc the deleted legend entry is visible. Actual Results: The deleted legend entry is visible. Expected Results: The deleted legend entry shouldn’t be visible. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 156988 [details] Example file from Excel
Created attachment 156989 [details] Screenshot of the original document side by side in Excel and Calc
@Gábor, Tünde: in fact, this is a duplicate of Bug 129858. I suggest to modify this issue to FILEOPEN/FILESAVE ODS or FILEOPEN DOCX(!), according to the recent solution, the UNO API extension. Code pointer for fixing the DOCX documents with embedded charts: commit 7869b3d6e4b24a0567ad2e492038d74c03b06b7d Author: Markus Mohrhard <markus.mohrhard@googlemail.com> Date: Fri Dec 7 23:28:28 2018 +0100 related tdf#51671, store new "hide legend" feature also in ODF
(In reply to László Németh from comment #3) > @Gábor, Tünde: in fact, this is a duplicate of Bug 129858. Sorry, it's not the same.
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6e847aa817999ab18acd534f9e6a86685bb268fc tdf#129859 XLSX import: don't show deleted legend entries It will be available in 6.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 6.5.0.0.alpha0+ Build ID: cc36c115004cb75037b0e4fdadff09035f765cd5 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded @Tünde Tóth, thanks for fixing this issue!!