Description: If a number is formatted using number formatting, Writer stops recognizing it as a number for the purposes of formulas. Steps to Reproduce: 1. Create a 3x6 table, with the cells in the last column containing "Hours", "1.75", "0.25", "2", "2.75", and the formula `=SUM(<C2:C5>)`. 2. Observe the correct total 6.75 3. Select cells C2 through C6. 4. Table -> Number Format..., then enter the format `0.??`. 5. Edit the cell containing "2" (now formatted as "2. ") to change the digit "2" to "3". 6. Observe that the total is now 4.75, ignoring that cell entirely. Actual Results: Incorrect total, because numbers are not recognized as numbers. Expected Results: Correct total, numbers recognized as numbers. Reproducible: Always User Profile Reset: No Additional Info: Version: 25.8.3.2 (X86_64) / LibreOffice Community Build ID: 580(Build:2) CPU threads: 12; OS: Linux 6.17; UI render: default; VCL: gtk3 Locale: en-US (C.UTF-8); UI: en-US Debian package version: 4:25.8.3-1+b1 Calc: threaded
I can confirm with Version: 26.8.0.0.alpha0+ (X86_64) Build ID: 7cbc16bf6e115d2aaabe9b9b20edd66a5c597571 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)