Bug 81090 - Pressing Delete in Styles and Formatting Dialog Box deletes cell instead
Summary: Pressing Delete in Styles and Formatting Dialog Box deletes cell instead
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Sidebar-Styles
  Show dependency treegraph
Reported: 2014-07-09 07:56 UTC by helplibreoffice
Modified: 2018-09-19 08:48 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 helplibreoffice 2014-07-09 07:56:34 UTC
Pressing Delete in Styles and Formatting dialog box deletes the current cell when the style is a built-in style.
Comment 1 sophie 2014-07-21 14:26:13 UTC
Hi, the same will happen with custom styles. Even when you highlight a style, the focus/cursor is still in cell, so pressing delete or any other key will affect the content of the cell. This is also why you can chose the content to delete with the backspace key. Closing as Notabug - Sophie
Comment 2 helplibreoffice 2014-07-21 14:51:57 UTC
That is not correct.  Pressing delete in the Styles and Formatting dialog box will delete the style, not the cell.  However, in the case when the style happens to be a built-in style, it erroneously deletes the cell instead of issuing a message that the style cannot be deleted.  There is no way the user can tell visually if a style is built-in or is user defined.  Thus, one cell's worth of data can be lost.  When the focus is in the Styles and Formatting subwindow, and the user presses delete, the functionality of deleting the selected Style is correct.  A message box needs to be added when trying to delete a style that cannot be deleted instead of deleting spreadsheet data content.
Comment 3 Joel Madero 2014-08-04 15:55:20 UTC
REOPENED is reserved for a bug that:

1. a developer has marked as FIXED;
2. a developer is assigned to the bug that is marked as FIXED;

In this case the bug report was never independently confirmed so correct status is UNCONFIRMED. Thanks!
Comment 4 raal 2014-09-11 14:55:22 UTC
I can confirm with version 4.3.1. When I try to delete built-in style in dialog window then cell is deleted. Delete/backspace on built-in style
should trigger warning message or do nothing.
Comment 5 QA Administrators 2015-10-14 19:57:40 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2016-11-08 11:25:14 UTC Comment hidden (obsolete)
Comment 7 Zineta 2017-09-11 08:38:59 UTC
The same behavior in new versions:LO5.2.;LO 6.0.
I agree, when you try to delete not erasable built-in styles 
there should be some kind of warning when Styles and Formatting dialog box is active and not to delete cell content.
Comment 8 Zineta 2017-09-13 11:01:14 UTC
Also in LO 3.3.0 , OO 3.3.0 so I changed it to Inherited from OOo.

Delete Content dialog box  for cell content deleting  exist in OO and it is some kind of help when Styles and Formatting is active
(to figure out that it will affect to content of the cell) and  it will erase the cell content.
There should be some kind of warning like :You can not delete buil-in Styles and not to delete cell content.
Comment 9 QA Administrators 2018-09-14 02:47:21 UTC Comment hidden (obsolete)
Comment 10 Zineta 2018-09-19 08:48:06 UTC
Bug not reproducible in version: (x64)
When I try to delete built-in style in active dialog window Styles, now content of cell is not deleted.