https://bugs.documentfoundation.org/show_bug.cgi?id=158708
Bug ID: 158708
Summary: Empty cell in Writer table with footnote breaks
formulas involving that cell
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: will.fried...@gmail.com
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
--
You are receiving this mail because:
You are the assignee for the bug.
