https://bugs.documentfoundation.org/show_bug.cgi?id=157287
Bug ID: 157287
Summary: Cross-reference a formula does not work since 7.6x
Product: LibreOffice
Version: 7.6.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
Previously, it was possible to provide the formula in a table cell with a
cross-reference and then retrieve this in the subsequent text. If the result of
the formula changed, the cross-reference in the text also changed.
Now only cross-reference to the cell or formula is possible.
If a cross-reference is setup to a cell with a formula, the formula is deleted
and the result value of the previous calculation is entered - the table cell
then no longer calculates. If an attempt is made to fill the area of a
cross-reference with a formula, the cross-reference is deleted.
For documents created with earlier versions, the cross-reference is deleted
when the formula is recalculated.
Steps to Reproduce:
1.Create a table with 1 column, 3 rows, fill in values in row 1+2
2.create a formula in row 3 (<A3>) that adds values from row 1+2 (= <A1>+<A2>)
3.change values in <A1> and/or <A2>
4.create/set a cross-reference on the formula in cell A3 (content will be
doubled, one as cross-reference field)
5.insert cross-reference field outside the table (using referenced text); value
from <A3> is shown
6. change values in <A1> and/or <A2>
Actual Results:
In step 3, the value in <A3> changes (because of the formula).
In step 6, nothing changes in <A3> nor in the cross-reference outside the
table.
Expected Results:
The formula in <A3> is working and cross referenced, so changes in <A1> and/or
<A2> causing a recalc of <A3> which is shown in <A3> and outside the TAB in the
cross-reference field
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
