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

Repeat table cell value in "normal" text

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer
View previous topic :: View next topic  
Author Message
Shammat
General User
General User


Joined: 22 Jul 2003
Posts: 25

PostPosted: Sun Oct 21, 2007 1:54 am    Post subject: Repeat table cell value in "normal" text Reply with quote

Hello,

I have a simple table in my Writer document. The table sums up some values.

Now I would like to repeat the value of the sum in the normal text inside the document.
Is that possible so that the value in the text is automatically updated, when the table changes?

Something like this:

Bla bla bla 42 bla bla

Code:

Column1 Column2
Text1   Value1
Text2   Value2
Text3   Value3
        sum(above)


And the sum(above) will yield 42. Now when I add a new row, the sum will change and that should automatically update the 42 in the regular text.

Thanks in advance
Back to top
View user's profile Send private message
acknak
Moderator
Moderator


Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W

PostPosted: Sun Oct 21, 2007 8:55 am    Post subject: Reply with quote

I was fairly sure there is a way to refer to table cells from outside the table--but it seems I was thinking of referring to cells between tables. For some bizarre reason, it seems you can only refer to table cells from within a table.
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Sun Oct 21, 2007 10:21 pm    Post subject: Reply with quote

Bookmark the sum, then insert a reference to that bookmark. Works for me in OOo 2.3 on WinXP. It even updates automatically.
Back to top
View user's profile Send private message
acknak
Moderator
Moderator


Joined: 13 Aug 2004
Posts: 4295
Location: ~ 40°N,75°W

PostPosted: Mon Oct 22, 2007 5:19 am    Post subject: Reply with quote

Wow, great catch!

But holy cow: a bookmark works, when a formula field does not? A formula can refer to a table cell from a different table, but not from normal text? I even tried setting a variable inside the table, and that "works" but gives the wrong answer (always zero).

I am constantly astounded at how messed up Writer's various fields are, for anything beyond the simplest uses. It's embarrassing.
Back to top
View user's profile Send private message
Shammat
General User
General User


Joined: 22 Jul 2003
Posts: 25

PostPosted: Tue Oct 23, 2007 1:01 pm    Post subject: Reply with quote

keme wrote:
Bookmark the sum, then insert a reference to that bookmark. Works for me in OOo 2.3 on WinXP. It even updates automatically.
Thanks, works fine.
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 Writer 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