[Libreoffice-bugs] [Bug 140337] New: In 7.1.0.3, the Basic macro of calc shows the error "CellAddress method is missing.

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: camper at mac.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210211/ceaadb2c/attachment.htm>