Ask Your Question
0

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

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

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

Comments

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

2 Answers

Sort by » oldest newest most voted
2

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

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

Comments

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 +0100 )edit
0

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

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

Comments

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 +0100 )edit

Question Tools

2 followers

Stats

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

Seen: 686 times

Last updated: Aug 05 '16