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

cell references

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


Joined: 21 May 2004
Posts: 66

PostPosted: Tue Feb 02, 2010 1:09 pm    Post subject: cell references Reply with quote

Trying to reference cells from one workbook to another. When the formulas are inserted into the second workbook (using click and drag so as to head off typos in the formulas) it seems to work fine.

Two things trigger problems. One.. if I try to change the cell addresses to absolute cell references they recalculate and give a wrong total.

Second.. I noticed if I left the addresses alone and as long as it was working okay, once I get out and back into the spreadsheet, the totals also go out of whack. All the formulas would appear to have the same total.. they shouldn't.

Could there be a bug with referencing cells between workbooks? What started this was worksheets I had not trouble with in the past now don't calculate correctly. I don't think anything about the formulas has changed so want to blame it on an upgrade.. using version 3.1.1 and Linux.

here is an example of the formula
=SUM('file://path'#$SHEET1.B3:E3)

won't let me change to
=SUM('file://path'#$SHEET1.$B$3:$E$3)


Confused
_________________
suz
Back to top
View user's profile Send private message
BigAndy
OOo Enthusiast
OOo Enthusiast


Joined: 03 Jan 2010
Posts: 150

PostPosted: Tue Feb 02, 2010 1:22 pm    Post subject: Reply with quote

Are you work in Database or in Calc???
What kind of workbook you want find in base? Question
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Tue Feb 02, 2010 1:32 pm    Post subject: Reply with quote

Moved from the Base to the Calc section.
Back to top
View user's profile Send private message
suz
Power User
Power User


Joined: 21 May 2004
Posts: 66

PostPosted: Tue Feb 02, 2010 1:41 pm    Post subject: Reply with quote

you are correct.. this is a Calc question...
thanks!
_________________
suz
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