Bug 107074 - CHARTS: Sub category display only shows 2 subcats instead of 3
Summary: CHARTS: Sub category display only shows 2 subcats instead of 3
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
5.4.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:5.4.0
Keywords:
Depends on:
Blocks: Chart
  Show dependency treegraph
 
Reported: 2017-04-10 14:59 UTC by bureautiquelibre
Modified: 2020-02-25 10:11 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Sub Categories display KO on X axis (17.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-04-10 14:59 UTC, bureautiquelibre
Details
equally distributed subdivisions (14.16 KB, image/png)
2017-04-11 13:38 UTC, Jacques Guilleron
Details
Aother view form your data pilot under Windows 7 (14.27 KB, image/png)
2017-04-11 13:40 UTC, Jacques Guilleron
Details
Country appears centered not at bottom of legend zone. (17.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-05-05 13:56 UTC, bureautiquelibre
Details
The second example file in Calc 6.3 and 6.4 side by side (164.13 KB, image/png)
2020-02-25 09:27 UTC, NISZ LibreOffice Team
Details
Example document after resizing the chart (54.33 KB, image/png)
2020-02-25 09:31 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
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.