Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | xlsx: Missing bubbles in a bubble chart | ||
---|---|---|---|
Product: | General | Reporter: | tora3 |
Component: | chart | Assignee: | kla <thomas.klarhoefer> |
Status: | CLOSED DUPLICATE | QA Contact: | issues@graphics <issues> |
Severity: | Trivial | ||
Priority: | P3 | CC: | IngridvdM, issues |
Version: | 3.3.0 or older (OOo) | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- | ||
Attachments: |
Description
tora3
2011-02-17 13:43:00 UTC
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 *** |