Issue 59297 - Wrong Range String in File if saving copied charts
Summary: Wrong Range String in File if saving copied charts
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: jogi
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-12-13 16:24 UTC by IngridvdM
Modified: 2013-02-24 21:21 UTC (History)
2 users (show)

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

Attachments
test case (6.47 KB, text/html)
2007-05-08 11:15 UTC, jogi 		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 IngridvdM 2005-12-13 16:24:26 UTC 
1) Open a spreadsheet and create a chart from spreadsheet data.
2) Create a Writer, Impress or Clac document.
2b) If you created a calc put some data in the cell range which was used for
chart in the starting  document.
3) Copy the Chart from document 1 and paste it into the new Writer, Impress or
Calc document. In Writer and Impress the chart now seems to have own data, which
it should. If copied to the calc document the chart comes into an invalid state.
It is not possible to open the own data dialog and the chart does not react to
changes of data in the calc range.
4) Save the new document with the pasted chart.
-> At the plot-area elemenet the cell-range-address contains the range from the
original spreadsheet. This is wrong. The range should be empty or point to local
table data.
Comment 1 bjoern.milcke 2005-12-14 09:31:11 UTC 
accepted
Comment 2 bjoern.milcke 2005-12-20 12:43:11 UTC 
Will not be fixed for OOo 2.0.2

Files created with OOo 2.0 or OOo 2.0.1 and saved with OOo 2.0.2 will get
corrupted due to a missing working fileformat versioning.  When a file is
created with OOo 2.0 and loaded with a version containing these fixes and saved
again, the files will get corrupted, because the OLE objects are just copied as
they are (saved with OOo 2.0), but the parent document is re-saved with the new
version.  As OLE objects have no own meta information, they inherit it from
their parent which in this case (the default) is wrong.
Comment 3 bjoern.milcke 2006-06-23 14:04:53 UTC 
Changed Target to 2.x
Comment 4 bjoern.milcke 2007-01-11 15:20:22 UTC 
This is fixed in the new chart (Milestone 10). For old charts we have to be able
to deal with this anyway, so I see no reason to fix this for OOo 2.1

Set to TASK, as this was fixed by the reimplementation
Comment 5 bjoern.milcke 2007-01-11 15:23:03 UTC 
->JSI: Please verify, that the plot-area does not contain a
table:cell-range-address attribute in the chart contained in Impress after the
described creation via the clipboard. You test this kind of things, right? If
not, send it back or to someone else for verification.
Comment 6 IngridvdM 2007-01-18 11:51:05 UTC 
changed target to 2.3
Comment 7 IngridvdM 2007-02-12 14:56:37 UTC 
changed issue type to defect
Comment 8 jogi 2007-05-08 11:15:44 UTC 
Created attachment 44926 [details]
test case
Comment 9 jogi 2007-05-08 11:17:52 UTC 
I have validated the behaviour. see test case.
Also the Impress chart does not have a "table:cell-range-address" tag.
Comment 10 jogi 2007-05-08 11:21:25 UTC 
the chart includes a table:cell-range-address="local-table.$A$2:.$A$4" and not a
spreadsheet address.
Comment 11 p9w.vu.31122010 2008-02-06 10:37:57 UTC 
Verified fixed in OOH680_m5; closing