Created attachment 197452 [details] Example file from Writer Attached example file contains some simple table formula in the second row, which just refer to the cell above them. If the referenced cell contains only a number, the formula updates when it is changed. If the referenced cell contains another paragraph or some text, the formula is evaluated as 0. In contrast, if the same is done in Word, Word parses the number out of the text+number and updates the cell upon changing the referenced cells value correctly. 1. Open attached file 2. In the table change numeric values in the first row -> only the middle ones change is reflected in the second row. Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9e3803ae438ddcf91ec0e15431be379561d28ba6 CPU threads: 14; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: default
Created attachment 197453 [details] The example file in Writer
Created attachment 197454 [details] Similar file from Word, to demonstrate what is possible
Created attachment 197455 [details] The second example in Word and Writer Word parses out the number from all cells in the first row, but Writer does not, not with this imported docx nor in a native file.
This is reproducible with Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 182140d53ac767f5f31aefb2f00ac1f812245703 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded but I don't understand why Word's behaviour should be correct. In your printscreen the cell A1 is "Content update: Press F9 in 2nd row" and formula =<A1> result is '2'. Why?