Ask Your Question

[Writer] How can I show the sum of a table's column on the main text? [closed]

asked 2016-08-04 14:55:58 +0200

GersonJFerreira gravatar image

I have a few tables with numbers. I can sum a column of a Table and keep the total at the last line. Or I can sum the content of one table and keep the total on a cell of another table.

But it seems that I cannot use the content of a table cell on the main text of writer. On the main text, I would like to refer to the sum of a table's column using a formula to keep the number updated.

Is it possible?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-10 09:46:49.155700


Mike Kaganski gravatar imageMike Kaganski ( 2019-04-29 13:27:23 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-08-04 15:43:52 +0200

paul1149 gravatar image

You can place the data in a one-cell table, which if inserted into a frame can be set to flow with surrounding, wrapped text.

edit flag offensive delete link more


That's a messy workaround. I'll avoid that. If there's no other way, I'll update manually for now.

I can use formulas on the main text, but I don't understand why I can't refer to table cells there. I'll try to suggest as a new feature.

GersonJFerreira gravatar imageGersonJFerreira ( 2016-08-04 17:52:06 +0200 )edit

answered 2016-08-05 08:22:15 +0200

ajlittoz gravatar image
  1. Select the text in the total cell.
  2. Insert->Bookmark..., give a name like total, click OK.
  3. Click in your text where you want the total included.
  4. Insert->Cross-reference..., Type: Bookmark, Insert reference to: Reference, Selection:the name you gave to the bookmark, click OK.

You're done.

If this answers your question, please tick the grey checkmark to the left (and up it if it has value for you).

edit flag offensive delete link more


This way you cannot sum two tables totals, for example. And the unnecessary (for this case) link is added.

ivangretsky gravatar imageivangretsky ( 2020-03-18 11:57:52 +0200 )edit

Question Tools



Asked: 2016-08-04 14:55:58 +0200

Seen: 707 times

Last updated: Aug 05 '16