Bug 107074

Summary: CHARTS: Sub category display only shows 2 subcats instead of 3
Product: LibreOffice Reporter: bureautiquelibre
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: jalojo, quikee, varga.balazs3, xiscofauli
Priority: medium    
Version: 5.4.0.0.alpha0+   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=127304
Whiteboard: target:5.4.0
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 90486    
Attachments: Sub Categories display KO on X axis
equally distributed subdivisions
Aother view form your data pilot under Windows 7
Country appears centered not at bottom of legend zone.
The second example file in Calc 6.3 and 6.4 side by side
Example document after resizing the chart

Description bureautiquelibre 2017-04-10 14:59:29 UTC
Created attachment 132456 [details]
Sub Categories display KO on X axis

Visible upon loading of included file.

Type subdivision not shown.

Seems to do so with that particular order of Row fields.
Changing their order in the pivot table gives good display.
Comment 1 Jacques Guilleron 2017-04-11 13:35:52 UTC
Hello,

Works when subdivisions are equally distributed, if I remove Liverpool from the data pilot, per example. I get else another display of the chart under Windows 7.

Jacques
Comment 2 Jacques Guilleron 2017-04-11 13:38:43 UTC
Created attachment 132473 [details]
equally distributed subdivisions
Comment 3 Jacques Guilleron 2017-04-11 13:40:15 UTC
Created attachment 132474 [details]
Aother view form your data pilot under Windows 7
Comment 4 Jacques Guilleron 2017-04-11 13:45:38 UTC
Images and comments in attachments have to be reversed.
Comment 5 Xisco Faulí 2017-04-11 21:27:35 UTC
Confirmed in

Version: 5.4.0.0.alpha0+
Build ID: 7635e0c1c7f821a1081f8e3868f641ae74a172d6
CPU threads: 4; OS: Linux 4.8; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group
Comment 6 Commit Notification 2017-05-01 18:38:15 UTC
Tomaž Vajngerl committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=23c0b3e13f88d6d71d528777d4f86f50c0766672

tdf#107074 uncommenting createLabels for the axis fixes the issue

It will be available in 5.4.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.
Comment 7 bureautiquelibre 2017-05-05 13:55:31 UTC
Hi,

Adding a new test file.

Country categories appear which is better than before, but they should be placed below city information, not centered in the X axis legend area which is not good for readability.

I reopened the bug but maybe it's a new one?

Regards,
Eric
Comment 8 bureautiquelibre 2017-05-05 13:56:25 UTC
Created attachment 133093 [details]
Country appears centered not at bottom of legend zone.
Comment 9 bureautiquelibre 2017-05-05 13:56:59 UTC
Version info:

Version: 5.4.0.0.alpha1+ (x64)
Build ID: 2514e38f8ebb95f51783ce321a84d6c55bba1de4
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2017-05-04_01:23:21
Locale: fr-FR (fr_FR); Calc: group
Comment 10 Miklos Vajna 2017-05-15 14:20:01 UTC
Moving to the chart tracker as discussed with Eric.
Comment 11 Xisco Faulí 2019-09-05 10:05:02 UTC
@Balázs Varga, Since you fixed bug 127304, I thought you might be interested in this issue...
Comment 12 NISZ LibreOffice Team 2020-02-25 09:27:19 UTC
Created attachment 158171 [details]
The second example file in Calc 6.3 and 6.4 side by side

This got a lot better in:

Verzió: 6.4.0.3 (x86)
Build az.: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU szálak: 4; OS: Windows 6.3 Build 9600; Felületmegjelenítés: alapértelmezett; VCL: win; 
Területi beállítások: hu-HU (hu_HU); Felület nyelve: hu-HU
Calc: CL

Still the Li-ver-pool string does not push the EN category down enough so they slip together, even after playing with the chart area size.
Comment 13 NISZ LibreOffice Team 2020-02-25 09:31:43 UTC
Created attachment 158172 [details]
Example document after resizing the chart

Making the chart slightly larger - so that city names don't need hyphenation - makes the strings readable.