https://bugs.documentfoundation.org/show_bug.cgi?id=158709
Bug ID: 158709
Summary: Formula involving Writer table cell with character
does not recalculate immediately
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
If a formula involves a Writer table cell, and the content is replaced by a
non-number, the formula does not recalculate until one clicks out of the table
and back into it.
Steps to Reproduce:
1. Create a 3x1 table.
2. In A1, enter 1; in B1, enter 2; in C1, enter =SUM(<A1:B1>).
3. Go to A1. Change it to 2. Exit the cell. Notice that the formula in C1
updates immediately.
4. Go to A1. Delete the number. Go to cell B1. Note that the formula is not
updated. Go to cell C1. Note that the formula is not updated. Keep clicking
randomly on different cells. Note that the formula is never updated.
5. Click out of the table. Note that the formula is not updated.
6. Click back into the table. Note that formula is finally updated.
7. Repeat these steps but in step 4, rather than deleting the number, replace
it with any non-numeric character. Note that the same update problem happens.
Actual Results:
Formula isn't updated until clicking out of the table and back into it.
Expected Results:
Formula should be updated as soon as one leaves the changed cell.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
