Table of Contents
Chart in spreadsheet
This is scenario for a simple bar chart in a spreadsheet (calculate the value of a savings account with 2% interest rate)
Steps
- Create a new spreadsheet
- Add the value 1.02 in A1
- Add the value 1000 in B1
- In B2, enter Sum of B1*A1
- In B3, enter Sum of B2*A1
- Add a 2D bar chart next to these values
- Set the minimum value on Y-axis to 900
- Set the maximum value on Y-axis to 1100
- Save it
- Open it in another implementation
- Change the value in A1 to 1.03
- Check if the values are recalculated and the chart is updated
Files
Original
Tracker
A list of known issues. Implementations not listed here may or may not work as expected. Results may vary depending on user settings and computer environment. Use at your own risk.
| Nr | Status | Write | Read | Comment | |
|---|---|---|---|---|---|
| 001 | OK | OOo 3.01 (Ubuntu) | Symphony 1.3 (Win) | OK | |
| 002 | Open | Symphony 1.3 | OOo 3.01 | See nr 7, same issue | |
| 003 | OK | Symphony 1.3 (Win) | OOo 3.01 (Win) | OK | |
| 004 | Open | Symphony 1.3 | OOo 3.1 | Chart in Document from Symphony looks not as expected in OOo 3.1 | |
| 005 | Open | GoogleDocs | EuroOffice 2010 | no chart (see analysis) | |
| 006 | Open | GoogleDocs | Symphony 1.3 | No charts seen when loading Google document (see analysis) | |
| 007 | Open | Symphony 1.3 | EuroOffice 2008 | sheet-chart-symphony.ods bars stop around 985 sheet-chart-symphony-ooo301.pdf (see analysis) | |
| 008 | Open | MS-Office 2007sp2 | EuroOffice 2008 | no chart, ole window only, see also 23 | |
| 009 | Open | MS-Office 2007sp2 | Symphony 1.3 | Charts missing | |
| 010 | Open | MS-Office 2007sp2 | Symphony 1.3 | Formulas not working | |
| 011 | Open | ODF-OOXML 3.0 | EuroOffice 2008 | openxml-odf_translator_3.0.ods: chart will not change with cell A1 | |
| 012 | Open | MS-Office 2007sp2 | EuroOffice 2008 | excel2007sp2odf3plugin.ods: chart will not change with cell A1 | |
| 013 | Open | MS-Office 2007sp2 | KOffice 2.1 trunk | triggers an assert bug report (fixed) Chart is at the wrong position bug report | |
| 014 | Open | Symphony 1.3 | MS-Office 2007sp2 | Chart from Symphony 1.3 does not show in Excel, still investigating why this happens | |
| 015 | Open | GoogleDocs | KOffice 2.1 trunk | no chart (see analysis) | |
| 016 | Open | Symphony 1.3 | KOffice 2.1 trunk | Chart is at the wrong position bug report , bars at wrong positon bug report , bar not recalculated bug report | |
| 017 | OK | Symphony 1.3 | Gnumeric 1.9.9 | OK | |
| 018 | OK | OOo 3.01 | Gnumeric 1.9.9 | OK | |
| 019 | Resolved | MS-Office 2007sp2 | Gnumeric 1.9.10 | OK (didn't work in 1.9.9, fixed for 1.9.10) | |
| 020 | Open | GoogleDocs | Gnumeric 1.9.9 | no chart (Google does not export it) | |
| 021 | Open | Gnumeric 1.9.10 | OOo 3.01 | Fails to show the graph when opened Fails to display chart on import | |
| 022 | OK | EuroOffice 2008 | Gnumeric 1.9.9 | OK | |
| 023 | Resolved | MS-Office 2007sp2 | OOo 3.1 | no chart, "ole" only and bars won't appear when changing xlink:href, fixed in dev-tree | |
| 024 | Resolved | MS-Office 2007sp2 | Gnumeric 1.9.10 Win32 | Loading file takes 2 - 3 minutes / 100% CPU (fixed in dev tree) | |
| 025 | Open | Gnumeric 1.9.10 | ODF-OOXML 3.0 | Unexpected error when opening file, supposedly: “Fixed in CWS chart41.” | |
| 026 | Open | Gnumeric 1.9.10 | MS-Office 2007sp2 | chart not displayed: “Excel found unreadable content” | |
| 027 | Open | OOo 3.1 | OOo 3.1 | Preview in GDI/VCLMTF format instead of SVG/PNG | |
Analysis
- Retest may be required: 3 contradicts 4
- GoogleDocs doesn't seem to export charts to ods — Bart Hanssens 2009/06/21 00:55
OOo and chart
For OpenOffice.org 3.1 (restricted data range) the OOo 3.1 GUI shows the values X 6.88 cm and Y 0.10 cm the file contains:
<draw:frame table:end-cell-address=“Sheet1.G16” table:end-x=“1.326cm” table:end-y=“0.325cm” draw:z-index=“0” draw:style-name=“gr1” svg:width=“7.999cm” svg:height=“6.999cm” svg:x=“0.101cm” svg:y=“0.1cm”><draw:object draw:notify-on-update-of-ranges=“Sheet1.B1:Sheet1.B3” xlink:href=”./Object 1” xlink:type=“simple” xlink:show=“embed” xlink:actuate=“onLoad”/><draw:image xlink:href=”./ObjectReplacements/Object 1” xlink:type=“simple” xlink:show=“embed” xlink:actuate=“onLoad”/></draw:frame>
The values in the file don't match the ones in the GUI and the position where the chart is shown. Can someone explain how this comes or point me at something I'm missing? — Sven Langkamp 2009/06/22 00:40
Apparently, the values in the OOo GUI are calculated, using the table:end-cell-address as starting point, offsetting it with table:end-x / table:end-y (ODF 1.1 part 9.2.16). Perhaps someone from the OOo team could confirm this ? — Bart Hanssens 2009/06/22 01:22
href to embedded object
- embedded object is saved with xlink:href=“Object 1/” in the MS Office file and with xlink:href=”./Object 1” in OOo/Symphony — Sven Langkamp 2009/06/22 18:20
cell value ranges on plot-area and series
See also ODF 1.1 part 10.1
Apparently, MS-Office 2007 doesn't set the (optional) table:cell-range-address attribute on chart:plot-area, while OOo relies on it.
Symphony does set the table:cell-range-address on chart:plot-area, but it apparently doesn't set chart:values-cell-range-address on chart:series (and it seems that MS-Office needs this)
(to be verified)
| chart:plot-area table:cell-range-address | chart:series chart:values-cell-range-address | href | |
|---|---|---|---|
| MS-Office 2007 | no | yes | Object 1/ |
| OpenOffice.org 3.1 | yes | yes | ./Object 1 |
| Lotus Symphony 1.3 | yes | no | ./Object 1 |
Additional analysis by OOo team
info on the OIC lists by Daniel Rentz(Sun) — Bart Hanssens 2009/06/30 10:55
origin of an axis
By default, Symphony explicitly saves a chart:origin (close to chart:minimum), while MS-Office and OOo do not. This is another case of writing out all attribute values vs relying on sensible implementation defaults.
ODT Export
