Issue 72973 - new Chart: When exporting to the SXC format, the datarange is lost
Summary: new Chart: When exporting to the SXC format, the datarange is lost
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords: new_implementation, oooqa
Depends on:
Blocks:
 
Reported: 2006-12-28 17:08 UTC by tony.galmiche.ooo
Modified: 2013-02-24 21:20 UTC (History)
2 users (show)

See Also:
Issue Type: TASK
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Histogramme_2D.ods (25.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-01-03 11:58 UTC, tony.galmiche.ooo 		no flags Details
Histogramme_2D.sxc (20.07 KB, application/vnd.sun.xml.calc)
2007-01-03 11:59 UTC, tony.galmiche.ooo 		no flags Details
Histogramme_2D.ods (25.16 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-01-03 12:01 UTC, tony.galmiche.ooo 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description tony.galmiche.ooo 2006-12-28 17:08:43 UTC 
When exporting to the SXC format, the datarange is lost, so no diagram is ok.
-> #REF!:$B$7;#REF!:$B$7;#REF!
Comment 1 IngridvdM 2007-01-02 11:57:15 UTC 
Tony, when does the range vanish? In the written file? Or when reloading with
the new chart or reloading with another version? Could you please in addition
attach an ods document that does show the problem when exporting to sxc. Thanks
a lot.
Comment 2 tony.galmiche.ooo 2007-01-03 11:58:56 UTC 
Created attachment 41849 [details]
Histogramme_2D.ods
Comment 3 tony.galmiche.ooo 2007-01-03 11:59:23 UTC 
Created attachment 41850 [details]
Histogramme_2D.sxc
Comment 4 tony.galmiche.ooo 2007-01-03 12:01:32 UTC 
Created attachment 41851 [details]
Histogramme_2D.ods
Comment 5 tony.galmiche.ooo 2007-01-03 12:05:10 UTC 
Sorry, the first attachment is not valide

Open Histogramme_2D.ods with Chart2m10
Save-as .sxc format
Open Histogramme_2D.sxc with OOo 1.1.5
-> the datarange is lost -> #REF!:$B$7;#REF!:$B$7;#REF!
Comment 6 IngridvdM 2007-01-04 15:14:43 UTC 
Thanks Tony. Now I can reproduce.
Comment 7 IngridvdM 2007-01-04 15:16:03 UTC 
->Björn, please take over as you are on the ranges.
Comment 8 IngridvdM 2007-01-18 11:47:25 UTC 
changed target to 2.3
Comment 9 bjoern.milcke 2007-01-29 14:03:52 UTC 
Looks like the files written were correct. However, they do not contain the
proprietary chart:table-number-list attribute. Adding this attribute to the
chart:chart element restores the data in OOo 1.5. The attribute was intended for
binary format use only, but obviously it was also mis-used by the XML import in
OOo 1.5.

Solution suggestion: Export the table-number-list for the old SXC-format.
Comment 10 bjoern.milcke 2007-01-31 14:03:39 UTC 
Quite a heavy one to fix ;-) OOo 1.5 needs the proprietary "table-number-list"
attribute in the file to be able to read it properly. This attribute was
intended for binary format only.

Now, it is written again in the OOo XML format (.sxc), but not in OASIS format
(.ods). This fixes also some problems with binary format (.sdc)

Fixed in Milestone 11.
Comment 11 bjoern.milcke 2007-02-12 10:07:18 UTC 
Please verify in chart2mst3 Milestone 11.
Comment 12 tony.galmiche.ooo 2007-02-13 11:57:59 UTC 
Where is the chart2mst3 Milestone 11 ?

It's not here : 
-> http://graphics.openoffice.org/chart/chart.html
Comment 13 utomo99 2007-02-13 12:22:40 UTC 
I think we need to wait a little while for chart2mst3 Milestone 11 . 
look at 
Current - Milestone10 - Integration Candidate 1 (21th December 2006) 
Previous - Milestone9b - Beta Respin (8th November 2006)
Comment 14 kla 2007-03-05 09:14:11 UTC 
Seen ok in mst 11 -> verified
Comment 15 tony.galmiche.ooo 2007-05-26 13:38:37 UTC 
It's OK for me