<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - (Spreadsheets) XUsedAreaCursor broken: the methods don't accept formatted cells as used."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144085">144085</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>(Spreadsheets) XUsedAreaCursor broken: the methods don't accept formatted cells as used.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.0.4 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>sdk
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jag@psilosoph.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=174535" name="attach_174535" title="The mentioned example">attachment 174535</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=174535&action=edit" title="The mentioned example">[details]</a></span>
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: <a class="bz_bug_link
bz_status_NEW "
title="NEW - gotoEndOfUsedArea doesn't give the correct position number of the Calc cell at the end when its background color is changed from the initial color."
href="show_bug.cgi?id=135203">tdf#135203</a> (?? tdff#137667 ??)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>