Bug 137667 - Calc, API: queryContentCells doesn't correctly evaluate the flag bits 2^5 through 2^8
Summary: Calc, API: queryContentCells doesn't correctly evaluate the flag bits 2^5 thr...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-UNOAPI
  Show dependency treegraph
 
Reported: 2020-10-21 22:56 UTC by Wolfgang Jäger
Modified: 2025-05-07 12:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Demnstrating the reported bug in detail (16.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-10-21 22:56 UTC, Wolfgang Jäger
Details
demo made with V25.2.2.2 (24.35 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-05-06 19:38 UTC, Wolfgang Jäger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Wolfgang Jäger 2020-10-21 22:56:57 UTC
Created attachment 166606 [details]
Demnstrating the reported bug in detail

https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1sheet_1_1CellFlags.html#a54545dc062bc2be2d723d0cc34e8cbd2 defines flags which should be evaluated by the queryContentCells methods (connecting them by OR). 
Bit 5 (value 32) e.g. should, if set, make the query find cells to which a hard attribute was applied. Bit 6 (64) should find cells with an explicitly assigned cell style ...
These and also the "objects" flag don't work.  

Everything should is demonstrated in the attached document. 

BTW: The UsedAreaCursor qualifies cells with hard attributes as used.
Comment 1 Andreas Heinisch 2021-07-07 19:18:24 UTC
Confirmed in:

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 0aea0cee58fe77a9058217dfdfc3d6a02b29ee2a
CPU threads: 6; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (de_DE); UI: en-US
Calc: CL
Comment 2 QA Administrators 2023-07-09 03:16:16 UTC Comment hidden (obsolete)
Comment 3 Wolfgang Jäger 2025-05-06 19:38:27 UTC
Created attachment 200680 [details]
demo made with V25.2.2.2

Bo progress.
New demo made with V 25.2.2.2 is attached.