[Libreoffice-bugs] [Bug 125800] New: Properties .ConditionalFormat, .ConditionalFormatXML, .ConditionalFormatLocal of a SheetCellRange wrongly show .Count=0

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125800

            Bug ID: 125800
           Summary: Properties .ConditionalFormat, .ConditionalFormatXML,
                    .ConditionalFormatLocal of a SheetCellRange wrongly
                    show .Count=0
           Product: LibreOffice
           Version: 6.3.0.0.beta1+
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jag at psilosoph.de

Created attachment 152048
  --> https://bugs.documentfoundation.org/attachment.cgi?id=152048&action=edit
The demo annonced in the report

There are (at least?) 3 properties (see subject) of any SheetCellRange in Calc
representing in different ways the conditional formatting set for the range.
The mentioned properties have a .Count property each. 

Using code that worked as expected in V 6.2.3.2 release, the 6.3.0.0.beta1
wrongly shows .Count=0 in a case where one CF is defined and correctly working. 
Trying to access one of the CF properties by index 0 nontheless, throws an
error.

A Sub creating a CF for another range anew is correctly processed, the CF is
working, but the same Sub does neither show it (.Count=0) nor allow to access
it. 

(I experienced this bug in pursuit of this question in the "official" askbot
site:
https://ask.libreoffice.org/en/question/196788/ . The attached example also was
created as an attachment to my answer there.)

Steps to verify the bug:
1. Load the attachment with V 67.2.2.2 or older.
2. Run the Sub 'look' stepwise and check the mentioned properties in the watch
panel of the Basic IDE.
3. Run thge Sub 'doItForThisSheetindexThisRange' and inspect the results in the
sheet and in the IDE again.
4. Quit without saving.
5. Load the attachment with V 6.3.0.0.beta1.
6. Try to run both Sub as before and verify my claims insofar.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190608/5e1f8da1/attachment.html>