Description: Despite the much-improved handling of formulas involving Writer table cells with footnotes (I can't find the old bug reports, one of which I filed), there remains a problem: if a cell is empty except for a footnote, it breaks formulas involving that cell, rather than treating it as an empty cell as it should. Steps to Reproduce: 1. Create a 3x1 table. 2. Leave cell A1 empty, enter a number in cell B1, and in cell C1 enter the formula =SUM(<A1:B1>). 3. Note that C1 now says, correctly, whatever number is in B1, as if A1 contains a 0. 4. Return to cell A1. Enter a character (not a number) like dash. Note that C1 still calculates correctly, treating the character in A1 as a 0. 5. Return to cell A1. Insert a footnote after whatever character you inserted. Note that C1 still calculates correctly, treating the character in A1 as a 0. 6. Return to cell A1. Delete the character, leaving only the footnote. 7. Note that C1 now says "** Expression is faulty **". 8. Return to cell A1. Insert a character. Note that C1 now correctly reports the sum. (Note that in all of these steps the recalculation of the formula in C1 requires clicking out of the table and back into it. I'm not sure why it doesn't recalculate immediately, which it does if you change the number in B1 and exit the cell. Perhaps this delayed recalculation is related to the bug, or perhaps it is a different bug. I recall there being recalculation problems with footnotes in cells after the original fix.) Actual Results: ** Expression is faulty ** Expected Results: Continue to treat A1 as an empty cell as if it had 0 in it. 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
Found the old bug about recalculation of cells with footnotes: https://bugs.documentfoundation.org/show_bug.cgi?id=146573 Just realizing that there's a different recalculation issue going on here that has nothing to do with footnotes; opening a new bug about that. The issue here is with footnotes in an empty cell breaking formulas.
I confirm it 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
Can also confirm with this version: 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
Same in OOo 3.3 -> inherited.