Download it now!
Bug 101303 - Refer to table cells when adding formulas to the main text
Summary: Refer to table cells when adding formulas to the main text
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Fields-Cross-Reference Writer-Tables-Formulas
  Show dependency treegraph
 
Reported: 2016-08-04 16:54 UTC by Gerson
Modified: 2019-01-16 13:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Gerson 2016-08-04 16:54:43 UTC
For instance, I have to file a report, where I list some numbers in tables. I can easily sum up a column and keep the sum updated in a table cell using formulas. I can even create formulas mixing cells from different tables:

=sum(C2:C10)

=<Table1.C11>+<Table2.C20>

...

But I can only do that in tables!

My suggestion is to allow us to refer to the table cells in formulas included in the main text. Anywhere. 

In my case, on the main text of the report I want to refer to total sum of some tables, and I would like to keep the numbers automatically updated in the main text.

Related: https://ask.libreoffice.org/en/question/74568/writer-how-can-i-show-the-sum-of-a-tables-column-on-the-main-text/
Comment 1 Buovjaga 2016-08-07 15:58:38 UTC
Sounds reasonable -> NEW.