Apache OpenOffice (AOO) Bugzilla – Issue 116999
xlsx: Missing bubbles in a bubble chart
Last modified: 2013-02-24 21:22:23 UTC
Reproduction 1. Start Excel 2007. 2. Prepare data for Scatter chart. 3. Select the data area and insert an Scatter chart. 4. Change chart type from X Y (Scatter) chart to Bubble chart. 5. Confirm series bubble size by choosing Select Data Source - Edit. It should be ={1,1,1, ...} instead of a range like C1:C9. 6. Save the workbook into .xlsx. 7. Open the file with OpenOffiec.org 3.3.0. Expectation Bubbles in the bubble chart appear. Reality Bubbles in the bubble chart are missing.
Created attachment 75858 [details] a bugdoc
Created attachment 75859 [details] a snapshot of Excel 2007
Created attachment 75860 [details] a snapshot of OOo 3.3.0
Created attachment 75861 [details] an internal file of the .xlsx bugdoc
The internal file xl/charts/chart2.xml includes: <c:bubbleSize> <c:numLit> <c:formatCode>General</c:formatCode> <c:ptCount val="12"/> <c:pt idx="0"> <c:v>1</c:v> </c:pt> As seen, the sizes of bubble are an constant value, instead of a range.
Created attachment 75868 [details] a range of bubble size is specified by hand.
1. Download a Perl script odf-ooxml-unzip.pl from https://bitbucket.org/tora/tools/src/tip/odf/odf-ooxml-unzip/odf-ooxml-unzip.pl 2. perl odf-ooxml-unzip.pl bubble-chart-with-constant-bubble-size-2011-02-17-.xlsx bubble-chart-with-constant-bubble-size-2011-02-17-bubble-size-range-specified.xlsx 3. gdiff -r -u bubble-chart-with-constant-bubble-size-2011-02-17-/ bubble-chart-with-constant-bubble-size-2011-02-17-bubble-size-range-specified/ > d.diff --- bubble-chart-with-constant-bubble-size-2011-02-17-/xl/charts/chart2.xml 2011-02-18 05:16:35.377608212 +0900 +++ bubble-chart-with-constant-bubble-size-2011-02-17-bubble-size-range-specified/xl/charts/chart2.xml 2011-02-18 05:16:36.725331645 +0900 @@ -114,46 +114,49 @@ </c:numRef> </c:yVal> <c:bubbleSize> - <c:numLit> - <c:formatCode>General</c:formatCode> - <c:ptCount val="12"/> - <c:pt idx="0"> - <c:v>1</c:v> - </c:pt> ..... + <c:numRef> + <c:f>Sheet1!$B$4:$M$4</c:f> + <c:numCache> + <c:formatCode>General</c:formatCode> + <c:ptCount val="12"/> + <c:pt idx="0"> + <c:v>1</c:v> + </c:pt> I hope this help to devise cool solutions.
Created attachment 75869 [details] output of gdiff -r -u bubble-chart-with-constant-bubble-size-2011-02-17-/ bubble-chart-with-constant-bubble-size-2011-02-17-bubble-size-range-specified/
This is a missing feature already requested in issue 64821. *** This issue has been marked as a duplicate of issue 64821 ***