It is possible to open/save an xlsx file that contains a deleted pie chart legend entry.
It is not possible to save this setting to ods format, since there is no export option yet. In bug #51671 a similar feature was implemented for data series, however bar chart has only data points.
Steps to Reproduce:
1. Open attached xlsx file in Calc and save it as ods.
The legend entry for data point “2” is deleted on opening the xlsx, but not deleted after saving and reopening the file as ods.
The deleted legend entry stays deleted after ods save & reopen.
User Profile Reset: No
Created attachment 157456 [details]
Example file from Excel
Created attachment 157457 [details]
The original file saved by Calc as ods
Created attachment 157458 [details]
Screenshot of the original and exported document side by side in Calc
Build ID: aef7feb3e695ecf6d411f0777196dcc4281e201a
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
In previous versions, the hidden legends are displayed at import time ( fixed by https://cgit.freedesktop.org/libreoffice/core/commit/?id=6e847aa817999ab18acd534f9e6a86685bb268fc )
Tünde Tóth committed a patch related to this issue.
It has been pushed to "master":
tdf#130225 implement ODF export of deleted legend entries of pie charts
It will be available in 7.0.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.