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...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.0.0.alpha0+
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Chart
  Show dependency tree / graph
 
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:

Attachments
Example file (17.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-04-10 08:32 UTC, bureautiquelibre 		Details
Screenshot (145.53 KB, image/png)
2017-04-10 08:39 UTC, bureautiquelibre 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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.

Regards,
Eric
Comment 1 bureautiquelibre 2017-04-10 08:39:28 UTC 
Created attachment 132441 [details]
Screenshot
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: 5.4.0.0.alpha0+ (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