Page 1 of 1

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

Posted: Sun Jan 25, 2015 8:34 pm
by ralphhosmer
I'm relatively new to ooCALC, so the enclosed .ods file represents my excursion thru: https://wiki.openoffice.org/wiki/Docume ... _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]

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

Posted: Sun Feb 01, 2015 11:01 am
by 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...

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

Posted: Sun Feb 01, 2015 3:50 pm
by 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

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

Posted: Sun Feb 01, 2015 4:18 pm
by 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
Newtoolbar.png (14.88 KiB) Viewed 13077 times
newtoolbar2.png

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

Posted: Sun Feb 01, 2015 7:00 pm
by ralphhosmer
Zizi64, Thanks for the update info. Ralph