The legend shows deleted legend entry too in Excel worksheet opened in LibreOffice 220.127.116.11.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 18.104.22.168.alpha0+ (x64).
5. View the attached screenshot.
6. Notice, that in LibreOffice Calc the deleted legend entry is visible.
The deleted legend entry is visible.
The deleted legend entry shouldn’t be visible.
User Profile Reset: No
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:
Author: Markus Mohrhard <email@example.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":
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:
Affected users are encouraged to test the fix and report feedback.
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
@Tünde Tóth, thanks for fixing this issue!!