OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

formulas ref-ing prev line not adjusted when pasting

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
tomtul2
Newbie
Newbie


Joined: 14 Jun 2005
Posts: 1
Location: So California

PostPosted: Tue Jun 14, 2005 12:39 pm    Post subject: formulas ref-ing prev line not adjusted when pasting Reply with quote

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
View user's profile Send private message
Dale
Super User
Super User


Joined: 21 Feb 2005
Posts: 1440
Location: Australia

PostPosted: Mon Jun 20, 2005 9:07 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group