https://bugs.documentfoundation.org/show_bug.cgi?id=140337
Bug ID: 140337
Summary: In 7.1.0.3, the Basic macro of calc shows the error
"CellAddress method is missing.
Product: LibreOffice
Version: 7.1.0.3 release
Hardware: x86 (IA32)
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Description:
This is about a macro in Calc. I have a Calc Basic macro that I set up about
three years ago, and it worked fine until 7.0.4. But in 7.1.0.3, it doesn't
work anymore.
The error dialog looks like this BASIC Runtime Error. The following property or
method was not found: CellAddress.
The macro, which is assigned to a button and deletes the row with the selected
cell, looks like this
Sub delete_Click()
Dim oSheet As Object
oSheet = ThisComponent.CurrentController.ActiveSheet
dim oActiveCell As Object
dim currRowNum As Long
oActiveCell = ThisComponent.CurrentSelection
currRowNum = oActiveCell.CellAddress.Row
oSheet.Rows.removeByIndex(currRowNum, 1)
End Sub
Steps to Reproduce:
1. Create a Calc file
2. Put text in some cells
3. Set up a button and assign the macro above.
4. Select one of the cells and then press the button.
Actual Results:
error "CellAddress method is missing.
Expected Results:
The row with the selected cell will be deleted.
Reproducible: Always
User Profile Reset: No
Additional Info:
When I run it with 7.0.4 on the same machine, it works fine.
Both 7.0.4 and 7.1.0.3 have been converted to Japanese by installing the
Language pack.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
