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
This looks like a duplicate of bug 157132. Please update your Libreoffice version to the latest 7.6.4.1 *** This bug has been marked as a duplicate of bug 157132 ***
Updated to 7.6.4.1 as directed. The bug still exists. Note that this is an issue of recalculation, not of breaking formulas, so it is not a duplicate of that other bug. Thank you.
I confirm ith with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 40617d867346956588ac023511f31210107217f4 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-GB Calc: CL threaded Additional information Tools -> Update -> Update All works as expected Also in Version: 5.4.7.2 (x64) Build-ID: c838ef25c16710f8838b1faec480ebba495259d0 CPU-Threads: 4; BS: Windows 6.19; UI-Render: GL; Gebietsschema: de-DE (de_DE); Calc: CL
I can confirm it as well with: Version: 7.6.4.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 16; OS: Linux 6.6; UI render: default; VCL: kf5 (cairo+xcb) Locale: es-ES (es_ES.UTF-8); UI: es-ES Calc: threaded