Bug 158687

Summary: Deleting a formula in a Writer table cell leaves a 0 rather than deleting the content of the cell
Product: LibreOffice Reporter: William Friedman <will.friedman>
Component: WriterAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: medium    
Version: 7.6.2.1 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

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 ***