Issue 21875 - Working with multiple worksheets
Summary: Working with multiple worksheets
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL: http://site.voila.fr/arno_web/test_OO...
Keywords:
: 80355 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-10-29 16:49 UTC by Unknown
Modified: 2007-08-06 12:39 UTC (History)
1 user (show)

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

Attachments
Example of the problems I have (OOo spreadsheet) (4.70 KB, application/octet-stream)
2003-10-29 16:54 UTC, Unknown 		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 Unknown 2003-10-29 16:49:56 UTC 
Hi,

I have some problems when working with many sheets :
* concerning formulas : when there are "cross-sheet" formulas (cells on 
different sheets linked by a formula), the copy of the sheet that contain the 
formula seems influenced by the position you at witch put the "copy-sheet". If 
it is copied before the original sheet the formulas are correct, but if copied 
after the formulas are wrong.
Download and look at the example file I propose you in the URL field 
(http://site.voila.fr/arno_web/test_OOo.zip).
There is a formula linking sheets "copysh_source" and "copysh_target". 
Sheet "copysh_target_2" is a copy (right_click>move/copy sheet>...) 
of "copysh_target" : it is copied AFTER "copysh_target" (copy box checked, 
sheet/position after "copysh_target" selected). The formula is WRONG ! 
Sheet "copysh_target_3", that is copied before "copysh_target" has the right 
formula (the formula is the same as in "copysh_source").

* concerning line inserting : in my example I have selected 2 sheets 
("insertlg" and "insertlg_2") and inserted a line on "insertlg" (visible 
sheet), but the line is only inserted on "insertlg". I wish the same things are 
done on all the selected sheets (line inserted also in "insertlg_2")!

Thanks for solving this issue and many thanks for this, overall, gOOod software.

Arnaud
Comment 1 Unknown 2003-10-29 16:54:26 UTC 
Created attachment 10758 [details]
Example of the problems I have (OOo spreadsheet)
Comment 2 frank 2003-10-30 10:41:15 UTC 
Hi,

this is not a bug !

It's simply an Issue of relative / absolute addressing of cells.

Your example shows all relative addressing. So copying a sheet changes
the formula depending on the position the sheet will have. Copying
before the source table results in the same formula as the relative
position is the same as before, just the source table changed the
position to one right. Copying behind the the source sheet will change
the position of the sheet (and the formula) to one right but the
formula itself states that the referenced sheet is just one to the
left, so the reference is changed accordingly.

To makle it absolute, just place a $ in front of the sheet name.
Please have a look at the Help system searching for relativ/absolute
addressing. (Search string is 'relative addresses; tables' without the
quotes).

Frank
Comment 3 frank 2003-10-30 10:41:34 UTC 
closed invalid
Comment 4 frank 2007-08-06 12:39:32 UTC 
*** Issue 80355 has been marked as a duplicate of this issue. ***