[Libreoffice-bugs] [Bug 144085] New: (Spreadsheets) XUsedAreaCursor broken: the methods don't accept formatted cells as used.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144085
           Summary: (Spreadsheets) XUsedAreaCursor broken: the methods
                    don't accept formatted cells as used.
           Product: LibreOffice
           Version: 7.2.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: sdk
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jag at psilosoph.de

Created attachment 174535
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174535&action=edit
The mentioned example

The methods .gotoStartOfUsedArea and .gotEndOfUsedArea no longer regard
formatted cells (directly or by assigning a cell style) as used.  
The previous 7.2.0.2RC also didn't.  
In V7.1.1.2 the methods work as expected in most cases, but do not accept cells
having set text attributes, but not containing a string.  

The example sheet contains a link to the demonstrating Sub created with
=HYPERLINK() in C7. B3 has Bold, Italic, and red text color, but no string.

The Basic module:  

REM  *****  BASIC  *****

Sub showUsedAreaOfActiveSheet()
Dim cellCursor As Object, cCtrl As Object, sheet As Object
  cCtrl = ThisComponent.CurrentController
  sheet = cCtrl.ActiveSheet
  cellCursor = sheet.createCursor()
  cellCursor.gotoStartOfUsedArea(False)
  cellCursor.gotoEndOfUsedArea(True)
  cCtrl.select(cellCursor)
  MsgBox(cellCursor.AbsoluteName)
  REM Expected: "$Sheet1.$B$3:$E$17 (B3 set to Bold....)
  REM With V7.2.0.4 : "$Sheet1.$B$5:$C$10"
  REM With V7.1.1.2 : NEARLY as expected: B5:E17. 
  REM Cell B3 has text attributes, but no string. It sis NOT accepted as usede
in 7.1.1.2
End Sub

Probably related: tdf#135203 (?? tdff#137667 ??)

-- 
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/20210825/b11a6386/attachment-0001.htm>