https://bugs.documentfoundation.org/show_bug.cgi?id=149722
Bug ID: 149722
Summary: `Macro Selector` should only show macros to Run which
are “not Private” and have “no arguments passed”
Product: LibreOffice
Version: 7.3.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
End users may `Run` macros which were programmed by others. To improve the user
experience, only valid macros should be listed in the `Macro Selector` window.
Actual Results:
Macros which produce errors when run or are private can be access by the `Macro
Selector`.
Expected Results:
Macros which produce errors (i.e. ones with passed arguments) when run or are
private should not be shown in the `Macro Selector`.
Reproducible: Always
User Profile Reset: No
Additional Info:
`Macro Selector` should only show macros to Run which are “not Private” and
have “no arguments passed”
End users may `Run` macros which were programmed by others. To improve the user
experience, only valid macros should be listed in the `Macro Selector` window.
LibreOffice Calc should only showing macros that can be Run in the LO Calc
`Macro Selector`. Screenshot will be attached later.
Macros which are `Private` or are passed arguments should not be show.
Inspiration from MS Excel. Screenshot will be attached later.
Code examples:
```
Private Sub PrivateFunction()
MsgBox "This subroutine should not show in the list of macros to run as it
is private"
End Sub
Sub FunctionWithArguments(intVariable As Integer)
MsgBox "This function should not show in the list of macros to run as it is
passed argument(s)"
End Sub
Sub FunctionNotPrivateNoArguments()
MsgBox "This function should show as it is public and does not get passed
any arguments"
End Sub
```
What do you think?
Thank you
--
You are receiving this mail because:
You are the assignee for the bug.
