Bug 107061 - PIVOT CHARTS: issue with display of Category / Sub category in column graph when "Total" is present
Summary: PIVOT CHARTS: issue with display of Category / Sub category in column graph w...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Pivot-Chart
  Show dependency treegraph
Reported: 2017-04-10 08:32 UTC by bureautiquelibre
Modified: 2017-04-11 14:39 UTC (History)
0 users

See Also:
Crash report or crash signature:
Regression By:

Example file (17.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-04-10 08:32 UTC, bureautiquelibre
Screenshot (145.53 KB, image/png)
2017-04-10 08:39 UTC, bureautiquelibre

Note You need to log in before you can comment on or make changes to this bug.
Description bureautiquelibre 2017-04-10 08:32:55 UTC
Created attachment 132440 [details]
Example file

Display of Sub category in the last item not aligned properly in pivot chart when Total is present.

See example file + screenshot.

Comment 1 bureautiquelibre 2017-04-10 08:39:28 UTC
Created attachment 132441 [details]
Comment 2 bureautiquelibre 2017-04-10 08:39:58 UTC
Paris sub category should be centered in its lane.
Comment 3 Tomaz Vajngerl 2017-04-10 08:55:02 UTC
This is probably because there is an additional "Total Result" column, which shouldn't be there. All grand totals and subtotals should be ignored, but I fixed this with [1] after I merged the code so it is not in the daily builds yet.

[1] https://cgit.freedesktop.org/libreoffice/core/commit/?id=abd8c3646e1295e68fe317bc1a02148a1b5f41a4
Comment 4 bureautiquelibre 2017-04-11 14:39:04 UTC
Fixed (Total data removed as per specification).

Version: (x64)
Build ID: eefe13c77d01be37c911e75af191717a944fedb3
CPU threads: 4; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2017-04-10_23:47:07
Locale: fr-FR (fr_FR); Calc: group