Issue 58938 - Data Range changes on sheet insertion
Summary: Data Range changes on sheet insertion
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC (x86_64) Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-12-06 09:32 UTC by bishnoi
Modified: 2013-02-24 21:19 UTC (History)
1 user (show)

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

Attachments
Test-case (2.75 MB, application/vnd.oasis.opendocument.spreadsheet)
2005-12-06 11:18 UTC, bishnoi 		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 bishnoi 2005-12-06 09:32:25 UTC 
I don't know if this affects other systems but I'm using OpenOffice RPM   
release 2.0 on AMD x86_64. To reproduce this issue you have to create a new   
sheet and make a new x-y chart with lines and symbols. Now insert a new sheet   
BEFORE the sheet where you made the chart. The sheet reference in the chart   
changes to one sheet before to where the data is. For example you make a chart   
on Sheet 1 with the data range: $'Sheet 1'.$O$3:$Q$142 . Then you insert a   
Sheet 4 before Sheet 1, the data range changes to: $'Sheet 4'.$O$3:$Q$142   
basically keeping the data range at the same sheet number by order from the   
start rather than in the same sheet.    
 
YOU HAVE TO DO IT ON A NEW FILE TO EASILY REPRODUCE IT. But otherwise it 
happens at random instants. 
   
The same thing also happens sometimes if you move a sheet from after the data   
sheet to before the data sheet. 
   
Please solve this issue since it is very annoying. I have 10s of sheets with   
charts all over them and they change the data range. basically showing the  
wrong data!
Comment 1 kla 2005-12-06 10:47:17 UTC 
Sorry, can't reproduce. Pls attach the Doc and/or give more information. thx
Comment 2 bishnoi 2005-12-06 11:18:52 UTC 
Created attachment 32128 [details]
Test-case
Comment 3 bishnoi 2005-12-06 11:19:31 UTC 
I'm sorry can't reproduce it either now... Don't know if I should be happy or   
worried since it just happens erratically... But what it appeared to be was   
something like a missed variable initialisation or increment!   
   
Now I'm trying it on two different computers but it just isn't happening! I'm   
attaching one of the sheets on which I encountered this first anyway if you  
think it would be worth your while having a look at it!  
  
Thanks!
Comment 4 kla 2005-12-06 13:21:50 UTC 
Invalid
Comment 5 kla 2005-12-06 13:22:11 UTC 
closed