Created attachment 76551 [details] Two examples of data labels position Problem by formatting Chart data labels.Values are by placement outside overlapping. The only way to placement the values properly is the option placement "Best fit", but this option place the values inside the chart. If the values inside the chart, there are some problems with the visibility of the values if the background colour of data areas is similar to the font color. This is for us a significant problem because we generate documents over office automation and we have a lot of charts on document.
Hi, Thanks for reporting. I can confirm this improper behavior. As you mention you work a lot with this feature... what do you suggest to do about it? I can't determine "how to do it in a good way"/"what is the best solution"? We can move the labels far away of the chart, but that'll not make it easier to read. Or is the best solution to let them show _inside_ the chart area, and make the colors more visible. Thanks for your feedback and expertise. Kind regards, Joren
(In reply to comment #1) > We can move the labels far away of the chart, but that'll not make it easier > to read. There's enough space in the circle (in most cases...) to move them a bit around maybe ?
(In reply to comment #2) > There's enough space in the circle (in most cases...) to move them a bit > around maybe ? in the circle = 'outside and close to the circle' (of course)
I think the problem is the LibreOffice 4 feature "Automatically rotate chart axis labels if they are overlapping." https://www.libreoffice.org/download/4-0-new-features-and-fixes/ Pie chart value labels are not usable with LibreOffice 4 and small values.
Created attachment 77750 [details] Pie chart with LO3.6 -> ok Pie chart with LO3.6 -> ok
Created attachment 77751 [details] Pie chart with LO3.6 -> ok (pdf) Pie chart with LO3.6 -> ok (pdf)
Created attachment 77752 [details] Pie chart LO3.6 opened in LO4.0 -> not ok (pdf) Pie chart LO3.6 opened in LO4.0 -> not ok (pdf)
Created attachment 77753 [details] Pie chart with placement outside in LO4.0 -> not ok Pie chart with placement outside in LO4.0 -> not ok
Created attachment 77754 [details] Pie chart with placement outside in LO4.0 -> not ok (pdf) Pie chart with placement outside in LO4.0 -> not ok (pdf)
@samuel: thanks for the testing and examples - looks as a regression. @muthu (in cc) can you pls have a look? Thanks!
Thanks for the detailed info. Assigning it to myself.
Can you please confirm if the bug is because of http://cgit.freedesktop.org/libreoffice/core/commit/?id=228ba082d3148f13eed79e9cdd682953cccaab1c I reverted this and checked and the bug is still occurring. (maybe i missed something?) [Did somebody already do a bibisect?]
Debugged this further. The internal labels choice is because of: http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-0&id=fc04a3a9702580902312f5e8d6f3abd52f108663 [And looks like the choice is on purpose - CC'ing kohei] Still trying to find what broke the external placement.
(In reply to comment #13) > Debugged this further. The internal labels choice is because of: > http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4- > 0&id=fc04a3a9702580902312f5e8d6f3abd52f108663 > [And looks like the choice is on purpose - CC'ing kohei] Yes, that's on purpose; the "best fit" should try to fit the label within the pie as best as it can, not outside of it.
We have a lot of "broken" documents with pie charts in the office after upgrade to LibreOffice 4. It would be great if you find a solution for the placement with small values.
Remove bibisect tag (see Comment 13).
so it looks like this problem is in Chart not Writer
yes it is a Chart problem.
Assigning this to kohei for resolution. [I have little knowledge about the reason for the change, unfortunately :( ]
*** Bug 69115 has been marked as a duplicate of this bug. ***
Same problem in LibreOffice 4.2.3.3
*** Bug 66414 has been marked as a duplicate of this bug. ***
*** Bug 79617 has been marked as a duplicate of this bug. ***
(In reply to Jorendc from comment #16) > Remove bibisect tag (see Comment 13). Whiteboard -> bibisectNotNeeded
The commits involved in this have already been identified in comments, so let's call this "bisected"
Migrating Whiteboard tags to Keywords: (bibisected) [NinjaEdit]
*** Bug 99288 has been marked as a duplicate of this bug. ***
Created attachment 124348 [details] Pie in OOo 4.1.2 also unusable To make this type of charts always usable, needed feature of manual anignment labels as in ms office.
Adding Cc: to Kohei Yoshida
Dennis Francis committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8c8edfabdee656ac5a9a0b1106f90baf315f1dd4 tdf#62363: When pie chart sector is too small do "Outside" placement It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Dennis Francis committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=03add51224dff65d2238832d3e1b8abfa5ebcc02&h=libreoffice-5-4 tdf#62363: When pie chart sector is too small do "Outside" placement It will be available in 5.4.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Dennis Francis committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d44e12f1f77514059375e6da3f981a992ff7de7e&h=libreoffice-5-3 tdf#62363: When pie chart sector is too small do "Outside" placement It will be available in 5.3.7. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 6.0.0.0.alpha0+ Build ID: 78960ad06faca055a6d97afbc764c902d5d07f6f CPU threads: 1; OS: Windows 6.1; UI render: default; TinderBox: Win-x86@39, Branch:master, Time: 2017-08-30_06:31:19 Locale: es-ES (es_ES); Calc: group