Created attachment 181493 [details] Source spreadsheet to reproduce the issue I’m not sure if I’m using the correct terms here, as I’m on the German version. So for several years now I’m having this issue which bugs me quite a lot now. When copying a diagram that displays values as % from Calc to Writer, the numbers get reformatted to decimal. In labels for data series as well as the axis. I can easily change the first series’ format by picking “Show as percent” from the firs level of settings. (Right click series, change data label formats or the like). But when I try that for an incomplete series where at least one label has been deleted, it’s messed up. All format checkboxes are in intermediate state, selecting one does not change its state, but only enables the config button next to it, if it has one (number format, percent format). When I choose percent format, disable usage of the source format, and pick a format, this will have no effect. Only choosing number format, disabling usage of the source format, and picking a percent format in the advanced dialog will take effect. So while preserving number formats from Calc to Writer would be nice as well, there is something messed up with the format options. Version: 7.3.4.2 Build ID: 30(Build:2) CPU threads: 4; OS: Linux 5.18; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Calc: threaded
Created attachment 181494 [details] Screencast of the issue I’m trying to add the screencast. On Gnome it only shows some frames, but I believe the video itself is intact.
Confirm with Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: c4f7043c593823b8c5605e779371ff430659eb20 CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded but I can check checkboxes in vclplugin=gen. Adding Caolán to CC. @Andy, you can try it with env variable SAL_USE_VCLPLUGIN=gen, see https://wiki.documentfoundation.org/Development/Environment_variables SAL_USE_VCLPLUGIN=gen soffice
Thanks for the fast feedback. Indeed, with gen UI it’s different: * Initially, all checkboxes are in intermediate state. * One can check “Value as percentage” and uncheck “Value as number” * When confirming the dialog, the format is applied directly * **But** the formerly deleted data point is re-created
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/730f6dac9eaad5b3ffda3032c184a671a9a16f72 Related: tdf#150196 can't change away from "indeterminate" state It will be available in 7.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.