[Libreoffice-bugs] [Bug 134224] Pie chart data rounding error
https://bugs.documentfoundation.org/show_bug.cgi?id=134224 Heiko Tietze changed: What|Removed |Added CC|libreoffice-ux-advise@lists |heiko.tietze@documentfounda |.freedesktop.org|tion.org Keywords|needsUXEval | --- Comment #5 from Heiko Tietze --- 1.4+1.4+1.4 = 4.2 ~ 4 = 1+1+1 = 3 1.6+1.6+1.6 = 4.8 ~ 5 = 2+2+2 = 6 Usually the individual values are rounded but the last which takes up the remaining portion to 100. 1.4+1.4+1.4 = 4.2 ~ 4 = 1+1+2 = 4 # rnd(4.2)-(1+1)=2 1.6+1.6+1.6 = 4.8 ~ 5 = 2+2+1 = 5 # rnd(4.8)-(2+2)=1 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134224] Pie chart data rounding error
https://bugs.documentfoundation.org/show_bug.cgi?id=134224 NISZ LibreOffice Team changed: What|Removed |Added Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org --- Comment #4 from NISZ LibreOffice Team --- (In reply to Leyan from comment #3) > The rounding of each percentage is correct, the fact that the sum is 101 is > just an artifact of the insufficient precision displayed. So the question is > whether it is better to have less precise individual values and a nicer > total or whether the current behavior should be kept? > Hi Thanks for your comment. Yes this is exactly the question here. Adding UX-advise list for help to decide :). (snip) > This simple algorithm can lead to pie charts displaying different > percentages even if the underlying value is the same, which is not great in > my opinion. For example, with a pie chart with 3 identical parts, the > percentages displayed will be 34%, 33%, 33%. Just like in Excel. My hunch is that our users would prefer it this way, so that on papers printed from Excel/Calc would be no difference. But this behavior might be made configurable, so that (enterprise) users/sysadmins could centrally configure Excel-like behavior. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134224] Pie chart data rounding error
https://bugs.documentfoundation.org/show_bug.cgi?id=134224 Leyan changed: What|Removed |Added CC||ouyang.le...@hotmail.com --- Comment #3 from Leyan --- The rounding of each percentage is correct, the fact that the sum is 101 is just an artifact of the insufficient precision displayed. So the question is whether it is better to have less precise individual values and a nicer total or whether the current behavior should be kept? I played a bit with it in Excel, this is only applied for integer percentage values, not when there is additional precision displayed. A pie chart with three identical parts will sum to 100% when the display format is 0% but 99.9% when it is 0.0%. For these integer percentage values, the algorithm used seems to be to change the displayed value by 1 for as many labels as necessary, starting with the labels closest to 0.5. This simple algorithm can lead to pie charts displaying different percentages even if the underlying value is the same, which is not great in my opinion. For example, with a pie chart with 3 identical parts, the percentages displayed will be 34%, 33%, 33%. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134224] Pie chart data rounding error
https://bugs.documentfoundation.org/show_bug.cgi?id=134224 Xisco Faulí changed: What|Removed |Added Ever confirmed|0 |1 CC||xiscofa...@libreoffice.org Status|UNCONFIRMED |NEW --- Comment #2 from Xisco Faulí --- Reproduced in Version: 7.1.0.0.alpha0+ Build ID: 70479e1f4cb3c120f46239a648e65f035af2922d CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 134224] Pie chart data rounding error
https://bugs.documentfoundation.org/show_bug.cgi?id=134224 --- Comment #1 from NISZ LibreOffice Team --- Created attachment 162298 --> https://bugs.documentfoundation.org/attachment.cgi?id=162298=edit Screenshot of the original document side by side in Word and Writer -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
