Bug 158687 - Deleting a formula in a Writer table cell leaves a 0 rather than deleting the content of the cell
Summary: Deleting a formula in a Writer table cell leaves a 0 rather than deleting the...
Status: RESOLVED DUPLICATE of bug 72100
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-12-13 15:11 UTC by William Friedman
Modified: 2023-12-13 15:20 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description William Friedman 2023-12-13 15:11:46 UTC
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
Comment 1 Mike Kaganski 2023-12-13 15:20:07 UTC

*** This bug has been marked as a duplicate of bug 72100 ***