https://bugs.documentfoundation.org/show_bug.cgi?id=167175
Bug ID: 167175
Summary: Wrong returned value of
oSheet.GoToEndOfUsedArea(False) in Calc Basic version
25.2.4.3
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Description:
I have function maxsr(sheet) for return last row and column of data on sheet:
GetRangeAddress() in this function return wrong Sheet, line and column only,
regardless of the actual number of rows and columns on sheet.
Bug is in version 25.2.4.3 (Windows and Ubuntu)
Not in versions 25.2.3.2. an lowers, it works correctly here
Steps to Reproduce:
function maxsr(Sheet)
oSheet = Sheet.CreateCursor() ' skip cursor to end of data on sheet
oSheet.GoToEndOfUsedArea(False)
maxsr = oSheet.GetRangeAddress()
End Function
Actual Results:
Returned array is:
Sheet = 38
StartColumn = 38
StartRow = 196
EndColumn = 38
EndRow = 196
Expected Results:
nuber of last row and column on the sheet and Sheet
Reproducible: Always
User Profile Reset: No
Additional Info:
Version 25.2.4.3
https://gerrit.libreoffice.org/gitweb?p=core.git;a=log;h=33e196637044ead23f5c3226cde09b47731f7e27
The same behavior is in the same version on Windows11, but I don't have the
build number available right now
--
You are receiving this mail because:
You are the assignee for the bug.
