| View previous topic :: View next topic |
| Author |
Message |
tomtul2
Newbie
Joined: 14 Jun 2005
Posts: 1
Location: So California
|
 Posted: Tue Jun 14, 2005 12:39 pm Post subject: formulas ref-ing prev line not adjusted when pasting |
 |
|
Calc does not adjust formulas sometimes when I do Paste Special Shift cells down. The forulas are those that reference the previous line. Formulas referencing the same line are adjusted correctly.
It does not adjust them when I Insert Row either. It inserts a blank line with no formulas, and the next line (the old one which shifted down) has not been adjusted.
I have to copy row with formulas into new row AND NEXT (old) ROW.
using 1.1.4 on Windows XP SP2 |
|
| Back to top |
|
 |
Dale
Super User
Joined: 21 Feb 2005
Posts: 1440
Location: Australia
|
| Posted: Mon Jun 20, 2005 9:07 pm Post subject: |
|
|
Pls post an example of your formulas before and after the insert/paste. Together with a detailed descrition of exactly what you do between "before" and "after." With luck, someone will then be able to respond constructuvely.
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!
OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos |
|
| Back to top |
|
|
|
