Bug 46444 - Calc doesn't filter any comments
Summary: Calc doesn't filter any comments
Status: NEW
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: Calc-Comments
  Show dependency treegraph
Reported: 2012-02-22 05:36 UTC by Juanjo Marin
Modified: 2021-12-17 12:45 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:

mini spreadsheet with comments for testing (8.40 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-02-22 05:36 UTC, Juanjo Marin

Note You need to log in before you can comment on or make changes to this bug.
Description Juanjo Marin 2012-02-22 05:36:25 UTC
Created attachment 57457 [details]
mini spreadsheet with comments for testing

When I apply any filter in a spreadsheet, all the comments are always shown. The expected behaviour is showing only the comments of the cells returned from the filter.
Comment 1 sasha.libreoffice 2012-05-23 04:02:53 UTC
Thanks for bugreport
reproduced in 3.3.4 and 3.5.3 on Fedora 64 bit and in 3.5.2 on Windows 7 32 bit
Comments always shown in Calc

What is interesting: in msExcel 2007 comments not shown when cells with them are filtered out
Comment 2 A (Andy) 2014-11-28 22:32:28 UTC
Reproducible with LO and, Win 8.1
Comment 3 QA Administrators 2015-12-20 16:09:52 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2019-05-14 02:54:40 UTC Comment hidden (obsolete)
Comment 5 Timur 2019-05-15 10:04:16 UTC
Repro 6.3+
Comment 6 Adam 2020-05-08 20:32:07 UTC

Version: (x64)
Windows 10.0 Build 18363

Version: (x64)
Windows 10.0 Build 18363
Comment 7 Buovjaga 2021-12-17 12:45:10 UTC
Still repro

Arch Linux 64-bit
Version: / LibreOffice Community
Build ID: b58dbb862296b63f3f2395c59d30fba40fa5f59f
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 17 December 2021