Description: 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. Actual Results: The legend entry for data point “2” is deleted on opening the xlsx, but not deleted after saving and reopening the file as ods. Expected Results: The deleted legend entry stays deleted after ods save & reopen. Reproducible: Always User Profile Reset: No Additional Info:
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
Reproduced in Version: 7.0.0.0.alpha0+ 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 Calc: threaded 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": https://git.libreoffice.org/core/commit/a96ec04a07c35338f5f9a0cb361b9322e5ca9cec 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.