Bug 41845 - Deleting validated rows does not delete validation circles.
Summary: Deleting validated rows does not delete validation circles.
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.3 release
Hardware: All All
: medium normal
Assignee: Tibor Nagy
Whiteboard: target:7.1.0
Depends on:
Blocks: Cell-Validity
  Show dependency treegraph
Reported: 2011-10-16 15:05 UTC by Allan Jacobs
Modified: 2020-12-30 10:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Input spreadsheet. Rows have not yet been deleted. (9.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-10-16 15:05 UTC, Allan Jacobs
Output, after deletion of rows marked invalid. (9.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-10-16 15:06 UTC, Allan Jacobs
Screenshot. (77.80 KB, image/png)
2011-10-16 15:07 UTC, Allan Jacobs

Note You need to log in before you can comment on or make changes to this bug.
Description Allan Jacobs 2011-10-16 15:05:17 UTC
Created attachment 52393 [details]
Input spreadsheet.  Rows have not yet been deleted.

The Data Detective option to mark invalid cells draws circles around invalid values.  Deletion of rows in a spreadsheet that have been validated this way does not make the circles disappear.


Copy ValidatorDeletionInput.ods to ValidatorDeletionOutput.ods.
Select Range A6:C7
Edit->Delete Cells...
Delete the entire row.
Comment 1 Allan Jacobs 2011-10-16 15:06:03 UTC
Created attachment 52394 [details]
Output, after deletion of rows marked invalid.
Comment 2 Allan Jacobs 2011-10-16 15:07:27 UTC
Created attachment 52395 [details]
Comment 3 tester8 2011-11-13 11:48:20 UTC
Reproduced with

LO 3.4.4
Ubuntu 10.04.3 x86
Linux 2.6.32-35-generic Russian UI
Comment 4 Björn Michaelsen 2011-12-23 12:33:41 UTC Comment hidden (obsolete)
Comment 5 tester8 2011-12-29 15:02:12 UTC
LOdev 3.5.0beta2 
Ubuntu 10.04.3 x86
Linux 2.6.32-37-generic Russian UI

Still reproduced.
Comment 6 QA Administrators 2014-06-25 17:38:01 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2015-07-18 17:42:54 UTC Comment hidden (obsolete)
Comment 8 Buovjaga 2015-10-16 20:08:26 UTC
Still repro.

Win 7 Pro 64-bit Version:
Build ID: 186f32f63434e16ff5776251657f902d5808ed3d
TinderBox: Win-x86@39, Branch:master, Time: 2015-10-16_09:42:47
Locale: en-US (fi_FI)
Comment 9 QA Administrators 2016-11-08 11:14:46 UTC Comment hidden (obsolete)
Comment 10 Thomas Lendo 2018-10-11 22:28:14 UTC
Still reproducible.

Build ID: c8481c8a43ce2544275b2d70ef29a8b0cb157732
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: de-DE (de_DE.UTF-8); Calc: threaded
Comment 11 QA Administrators 2019-10-12 02:45:03 UTC Comment hidden (obsolete)
Comment 12 Commit Notification 2020-11-20 14:22:25 UTC
Tibor Nagy committed a patch related to this issue.
It has been pushed to "master":


tdf#41845 sc: delete row/column with validation circles

It will be available in 7.1.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.
Comment 13 NISZ LibreOffice Team 2020-12-30 10:07:31 UTC
Verified in:

Version: (x64)
Build ID: 368c56144aab5794c39d5bc2082d9b3d6d7cebdb
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded

Thanks for fixing!