Bug 72100 - EDITING: Deleting contents of cells with formulas in TABLE gives 0 in some cells, and doesn't change other cells in multiple selection
Summary: EDITING: Deleting contents of cells with formulas in TABLE gives 0 in some ce...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Writer-Tables-Formulas
  Show dependency treegraph
Reported: 2013-11-28 06:22 UTC by Mike Kaganski
Modified: 2021-12-30 06:15 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2013-11-28 06:22:16 UTC
When a table cell contain a formula, deleting the whole cell content gives zero in the cell.

Steps to reproduce:
1. Create a text document
2. Add a table 2x1
3. Put some formulas in the cells, say, "=1" in A1 and "=2" in B1.
4. Select both cells at once, and press "Del".

Expected: both cells should be empty.

Actual result: the cells contain character "0". Actually, the cell that holds the focus may be initially empty, but if you click outside of it, the zero appears.

And if the formulas reference other cells, things become worse.

1. Create a table 1x3.
2. Put "=1" into the first cell (A1), "=<A1>+1" into the second (B1), "=<B1>+1" into the third (C1).
3. Select all three cells, press "Del".

Expected: all cells empty.
Actual result: A1 now contain character "0" (no formula), cells B1 and C1 both still contain the unchanged formulas (but the result is changed, of course).
Deleting the three cells again removes zero from the A1, and the formula from B1, but now B1 holds zero, and C1 still contain the formula.

This makes deleting multiple formulas very difficult task.

Tested with, and AOO4.0 under Win7x64, and under Ubuntu 13.10 x64.
Comment 1 sasha.libreoffice 2013-11-28 09:43:23 UTC
Thanks for reporting this bug
Reproduced in on Fedora (RFR) 64 bit

Possible workaround:
Select any empty table cell and press Ctrl-C. Then place text cursor into cell where formula should be deleted and press Ctrl-V. It deletes formula from first attempt and undo works correctly. Pasting into multiple selection deletes formulas from all selection.
Comment 2 Joel Madero 2015-05-02 15:42:25 UTC Comment hidden (obsolete)
Comment 3 Mike Kaganski 2015-05-02 17:36:12 UTC
Still reproducible with Version:
Build ID: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Locale: ru_RU
under Win7x64
Comment 4 QA Administrators 2016-09-20 09:38:13 UTC Comment hidden (obsolete)
Comment 5 Mike Kaganski 2016-09-20 15:46:19 UTC
Still reproducible with Version: (x64)
Build ID: 3c2231d4aa4c68281f28ad35a100c092cff84f5d
Comment 6 QA Administrators 2018-01-17 03:29:37 UTC Comment hidden (obsolete)
Comment 7 Mike Kaganski 2018-01-17 04:36:48 UTC
Yes, still present in Version: (x64)
Build ID: b97a0df0f3234b4c1140ba1418d4b96a592afa4a
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: ru-RU (ru_RU); Calc: CL
Comment 8 AndreasHobbs 2020-01-29 12:29:36 UTC Comment hidden (spam)
Comment 9 Jeniifer 2020-03-07 04:06:26 UTC Comment hidden (spam)
Comment 10 Gore Krylov 2020-10-20 06:34:33 UTC Comment hidden (spam)
Comment 11 Gore Krylov 2020-10-20 06:35:14 UTC Comment hidden (spam)
Comment 12 mackayrealtynetwork6 2020-10-31 17:25:53 UTC Comment hidden (spam)
Comment 13 mackayrealtynetwork6 2020-11-01 06:51:08 UTC Comment hidden (spam)
Comment 14 leeqeen 2021-01-28 06:40:09 UTC Comment hidden (spam)
Comment 15 leeqeen 2021-01-28 10:03:57 UTC Comment hidden (spam)
Comment 16 Tyler Worgan 2021-02-04 08:02:53 UTC Comment hidden (spam)
Comment 17 Stéphane Guillou (stragu) 2021-12-30 06:15:01 UTC
Still reproducible exactly as described in:

Version: / LibreOffice Community
Build ID: 7fe2ce55ab86cc7a32850fdf504e368c535949c3
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded