Bug 101303 - Allow referencing table cells in formula variable fields (inside and outside tables)
Summary: Allow referencing table cells in formula variable fields (inside and outside ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 152743 156389 (view as bug list)
Depends on:
Blocks: Fields-Cross-Reference Writer-Tables-Formulas
  Show dependency tree / graph
 
Reported: 2016-08-04 16:54 UTC by Gerson
Modified: 2023-07-20 10:01 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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.
Comment 2 Stéphane Guillou (stragu) 2023-07-20 09:48:28 UTC 
*** Bug 156389 has been marked as a duplicate of this bug. ***
Comment 3 Stéphane Guillou (stragu) 2023-07-20 09:51:34 UTC 
*** Bug 152743 has been marked as a duplicate of this bug. ***
Comment 4 Stéphane Guillou (stragu) 2023-07-20 10:01:01 UTC 
Same in OOo 3.3, so inherited.

Same in recent 24.2 alpha build.