Description: Data label takes bad format in percent stacked chart. It displays a percent format with two decimals instead of source format. Steps to Reproduce: 1. Click on a cell value in Calc. (See attachments) 2. Click on "Insert Chart" button and select "Column" or "Bar" chart type. 3. Select "Percent Stacked" 4. Right click on columns and select "Insert Data Label" Actual Results: In attachment "test_number", data label has incoherent formatting (800.00% instead of 8 for example). In attachment "test_percent", data label is formatted as percent with two decimals (7.61% instead of 7.6% for example). Expected Results: Data label format should be the same as source, like "Normal" or "Stacked" chart type. Reproducible: Always User Profile Reset: No Additional Info: In source code, data label format are defined according to Y axis. In percent stacked chart, we shouldn't consider this axis but source. User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:55.0) Gecko/20100101 Firefox/55.0
Created attachment 135684 [details] Test file with number values
Created attachment 135685 [details] Test file with percent values
Yes, the "source" setting for format does not work, see bug 95425. *** This bug has been marked as a duplicate of bug 95425 ***
I agree that bug 95425 describes a very similar problem. But, I am pretty sure we should not consider this one as a duplicate. Indeed, steps to reproduce and expected result are different than bug 95425. I am speaking about the default data label of stacked percent chart type, not reformatting when we open in data label edition window. Please, consider this bug as "unconfirmed" awaiting validation of someone else. Regards
Reproduced. Works OK in 3.6 (with both files). Arch Linux 64-bit, KDE Plasma 5 Version: 6.0.0.0.alpha0+ Build ID: 4082b5874adddedf8332fe977b6bb47b6949b302 CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on August 31st 2017 Arch Linux 64-bit Version 3.6.7.2 (Build ID: e183d5b)
OK in 4.2.0.4, not OK in 4.3.0.4, adjusting version field.
Can someone can review the submitted patch https://gerrit.libreoffice.org/41424 so, hopefully, it can be merged Thanks for your time.
Bisected (against test_number) with Linux 44max to: commit 9135b8b04a9f2ff33d1500876e48c6d2d42ecae0 Author: Matthew Francis <mjay.francis@gmail.com> Date: Sat Mar 14 21:46:04 2015 +0800 source-hash-1d38cb365543924f9c50014e6b2227e77de1d0c9 commit 1d38cb365543924f9c50014e6b2227e77de1d0c9 Author: Kohei Yoshida <kohei.yoshida@collabora.com> AuthorDate: Fri Jun 13 11:12:50 2014 -0400 Commit: Kohei Yoshida <kohei.yoshida@collabora.com> CommitDate: Thu Jun 19 14:46:56 2014 -0400 fdo#71076, fdo#71767: Preserve number formats when charts are copied. I noticed with this commit, test_percent gives labels like 454% instead of ones with decimals. It gives decimals in older ones, a mix of ,00 and ,0. But there are difficulties in investigating, because some builds create a blank chart.
Please retest after the fix for Bug 105236 has been merged. At least in my tests it seems to be fixed. If this is not yet fixed I might need more detailed steps how to reproduce the bug.
(In reply to Markus Mohrhard from comment #9) > Please retest after the fix for Bug 105236 has been merged. At least in my > tests it seems to be fixed. > > If this is not yet fixed I might need more detailed steps how to reproduce > the bug. Thanks, both cases from Dimitri produce the expected result now! The other report had a somewhat different topic, so I will not close as dupe. Arch Linux 64-bit Version: 6.3.0.0.alpha0+ Build ID: 9059457a1a8385cb80b5dd2c797cee77af4222a9 CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3_kde5; Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US Calc: threaded Built on 30 November 2018