[Sample] Calc & Basic: Sheet, Row/Column, Cell Operations

[ralphhosmer]

I'm relatively new to ooCALC, so the enclosed .ods file represents my excursion thru: https://wiki.openoffice.org/wiki/Documentation/BASIC_Guide/Formatting_Spreadsheet_Documents. The file has a 'Launch' Icon on the left side of the Standard Toolbar. Also, the MsgBox use includes an 'Excape from Program' mechanism [End]. Feel free to use/modify the file. Ralph Hosmer, Harlingen, TX [retired for 10 years]

[Zizi64]

The file has a 'Launch' Icon on the left side of the Standard Toolbar.

I can not see any (new) icon on the left side of the standard toolbar, or
elsewhere. Maybe you saved it into the User profile, but not into the attached document...

[ralphhosmer]

To Zizi64:
The 'icon' in my document is a square shaped icon on the left side of the Standard Toolbar. If it's there, mouse-over the icon and you should see help text: 'Test Calc1'.
If the icon is not on your copy of the document, I'm not familiar with the 'User Profile', but if you use: 'Tools > Macros > Organize Macros > Open Office Basic', you can then use the dialog 'Assign' button to set up your own launch icon. The other option is to use the 'Edit' button and use Run when you are in the Editor.
I hope this helps, Ralph

[Zizi64]

If the icon is not on your copy of the document, I'm not familiar with the 'User Profile', but if you use: 'Tools > Macros > Organize Macros > Open Office Basic', you can then use the dialog 'Assign' button to set up your own launch icon. The other option is to use the 'Edit' button and use Run when you are in the Editor.
I hope this helps, Ralph

Yes, i can launch your macro, and I can assign it to my own icon.

But, maybe not all of Users can to do it. When you create a new toolbar, you can choose where you want to save it: Into the actual document, or into the OpenOffice/LibreOffice Calc.

Newtoolbar.png (14.88 KiB) Viewed 6342 times

[ralphhosmer]

Zizi64, Thanks for the update info. Ralph