https://bugs.documentfoundation.org/show_bug.cgi?id=158687
Bug ID: 158687
Summary: Deleting a formula in a Writer table cell leaves a 0
rather than deleting the content of the cell
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
If one deletes a formula from a cell in a table in Writer, the cell
"recalculates" to 0 rather than deleting the content completely. However, no
formula is displayed if one goes to "edit formula." This happens whether one
selects just the content of the cell or the entire cell. One has to delete the
0 in order to clear the content of the cell completely.
Steps to Reproduce:
1. Create a 2x1 table.
2. Put a numerical value in A1.
3. Tab over to B1. Enter the following formula: =<A1>.
4. The number you entered in A1 should be displayed. Hit backspace.
5. Exit the cell so that it recalculates (e.g., tab to a new cell, click a
different cell). Notice that 0 is now displayed.
6. Return to that cell. Go to "edit formula" (e.g., Table | Edit Formula or
right-click | Edit Formula). Notice that no formula is displayed.
7. Backspace to delete the 0. Go to a different cell. Notice that the cell is
now empty.
8. Return to B1. Enter the formula =<A1>. Select the whole cell (Table | Select
| Cell). Hit delete.
9. Leave the cell. Notice that 0 is displayed.
10. Return the cell and go to "edit formula." Notice that no formula is
displayed.
11. Select the cell. Hit delete. Notice the 0 is finally gone.
Actual Results:
Cell recalculates to 0 after deletion.
Expected Results:
Cell should be empty after deletion.
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.
