Bug 129054 - FILEOPEN XLSX Pie chart with multiple categories appears smaller
Summary: FILEOPEN XLSX Pie chart with multiple categories appears smaller
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1 all versions
Hardware: All All
: medium normal
Assignee: Balázs Varga
URL:
Whiteboard: target:6.5.0 target:6.4.0.1
Keywords:
Depends on:
Blocks: OOXML-Chart Pie-and-Donut
  Show dependency treegraph
 
Reported: 2019-11-27 09:02 UTC by NISZ LibreOffice Team
Modified: 2024-10-15 21:05 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel (19.90 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-11-27 09:03 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc (160.22 KB, image/png)
2019-11-27 09:03 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-11-27 09:02:28 UTC
Description:
Attached example document has a simple pie chart with labels from a range of two columns set as categories. This opens as a smaller radius pie in Calc than in Excel.

Steps to Reproduce:
1.	Open attached document
2.	Open the Data Ranges window, go to Data series tab and notice it has $Munka1.$A$1:$B$4 set as Categories.


Actual Results:
Pie chart has a lot smaller radius than it has in Excel.

Expected Results:
Same chart radius.


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details:
Version: 6.5.0.0.alpha0+ (x64)
Build ID: 7e09d08807b5ba2fd8b9831557752a415bdad562
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; 
Locale: en-US (hu_HU); UI-Language: en-US
Calc: CL

Also happens in
Version: 5.0.0.5
Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b
Locale: hu-HU (hu_HU)

Verzió: 4.1.0.4
Comment 1 NISZ LibreOffice Team 2019-11-27 09:03:12 UTC
Created attachment 156138 [details]
Example file from Excel
Comment 2 NISZ LibreOffice Team 2019-11-27 09:03:33 UTC
Created attachment 156139 [details]
Screenshot of the original document side by side in Excel and Calc
Comment 3 Balázs Varga 2019-11-27 09:14:12 UTC
Confirmed in:

Version: 6.2.5.2 (x64)
Build ID: 1ec314fa52f458adc18c4f025c545a4e8b22c159
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-US (hu_HU); UI-Language: en-US
Calc:
Comment 4 Xisco Faulí 2019-11-27 17:19:45 UTC
Changing version according to the descrption
Comment 5 Commit Notification 2019-12-02 07:31:27 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/ea97f0926e138712c3800f5274012f0f04fc1c47

tdf#129054 Chart OOXML Import: Fix size of Pie Chart

It will be available in 6.5.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 6 Commit Notification 2019-12-05 08:44:16 UTC
Balazs Varga committed a patch related to this issue.
It has been pushed to "libreoffice-6-4":

https://git.libreoffice.org/core/commit/408d90c89eefedfe487c00bd8c6ba9ee76870bf7

tdf#129054 Chart OOXML Import: Fix size of Pie Chart

It will be available in 6.4.0.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.