https://bugs.documentfoundation.org/show_bug.cgi?id=152743
Bug ID: 152743
Summary: Table elements not accessible in field formulas and
text field formulas not available in table cells
Product: LibreOffice
Version: 7.3.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Writer
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dav5al...@gmail.com
Description:
Writer 7.3.7.2 build e114eadc50a9ff8d8c8a0567d6da8f454beeb84f; text page with
two tables. When I attempt to include a table cell <Table2.D7>*25 in a text
field calculation the result is "** Expression is faulty **" in gray. If I put
the table cell value in the Formula instead (e.g., .032*25) it shows up
correctly. If I copy and paste the document text line with the Formula field
into a table cell (e.g., A11), the text field value is not accessible for
calculations in another table cell (e.g., C11) example: <A11>*<C10> the result
is "0.00" rather than the correct calculated value. It would seem that
LibreOffice Writer should allow table values to be used in text field Formulas
in the same document and recognize those Formula fields embedded in table cell
text for use in other table cell computations.
Steps to Reproduce:
1.In Writer document Insert new table with two rows and three columns.
2.Populate table column two with non-zero numerical values.
3.Below table enter text "Test text field _ value." and attempt to insert
Formula field with '<Table1.B1>*4*4' where '_' is shown. Note: "faulty" mesg.
4.Right click on text formula field and edit text field formula "<Table1.B1>
replacing with value entered in table cell B1. Note: correct gray value.
5.Highlight and copy (Ctrl-C) entire text line below table and paste (Ctrl-V)
in table cell A2. Note: text shown with gray formula field in table cell.
6.Click on table cell C2 and press F2. Enter formula "=<A2>*<B2>" and press
enter. Note: value in table cell C2 is zero instead of calculated value.
Actual Results:
See above; "** Expression is faulty **" instead of table cell value
calculation.
See above; Table cell "0" instead of correct calculated value.
Expected Results:
Calculated table cell <Table1.B1>*4*4 in gray text formula field.
Calculated text formula field using table cells as selected.
Reproducible: Always
User Profile Reset: No
Additional Info:
Documentation implies table cells can be included in Formulas if enclosed in
angle brackets <>. Can provide TableDoc.odt as attachment. Recognition of
table cells in text formula fields and visa versa would significantly improve
the usefulness of this feature.
--
You are receiving this mail because:
You are the assignee for the bug.
