| View previous topic :: View next topic |
| Author |
Message |
Shammat General User

Joined: 22 Jul 2003 Posts: 24
|
Posted: Sun Oct 21, 2007 1:54 am Post subject: Repeat table cell value in "normal" text |
|
|
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 |
|
 |
acknak Moderator


Joined: 13 Aug 2004 Posts: 4295 Location: ~ 40°N,75°W
|
Posted: Sun Oct 21, 2007 8:55 am Post subject: |
|
|
| 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 |
|
 |
keme Moderator


Joined: 30 Aug 2004 Posts: 2732 Location: Egersund, Norway
|
Posted: Sun Oct 21, 2007 10:21 pm Post subject: |
|
|
| 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 |
|
 |
acknak Moderator


Joined: 13 Aug 2004 Posts: 4295 Location: ~ 40°N,75°W
|
Posted: Mon Oct 22, 2007 5:19 am Post subject: |
|
|
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 |
|
 |
Shammat General User

Joined: 22 Jul 2003 Posts: 24
|
Posted: Tue Oct 23, 2007 1:01 pm Post subject: |
|
|
| 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 |
|
 |
|