[Sample] Calc & Basic: Sheet, Row/Column, Cell Operations
Forum rules
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
-
- Posts: 67
- Joined: Mon Nov 03, 2014 2:14 pm
[Sample] Calc & Basic: Sheet, Row/Column, Cell Operations
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]
- Attachments
-
- SpreadsheetHandlerTest_1.ods
- ooCALC with ooBASIC Program
- (25.29 KiB) Downloaded 1028 times
OpenOffice 4.1.1 on Windows 10 Home
Re: [Sample] Calc & Basic: Sheet, Row/Column, Cell Operation
I can not see any (new) icon on the left side of the standard toolbar, orThe file has a 'Launch' Icon on the left side of the Standard Toolbar.
elsewhere. Maybe you saved it into the User profile, but not into the attached document...
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 67
- Joined: Mon Nov 03, 2014 2:14 pm
Re: [Sample] Calc & Basic: Sheet, Row/Column, Cell Operation
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
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
OpenOffice 4.1.1 on Windows 10 Home
Re: [Sample] Calc & Basic: Sheet, Row/Column, Cell Operation
Yes, i can launch your macro, and I can assign it to my own icon.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
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.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 67
- Joined: Mon Nov 03, 2014 2:14 pm
Re: [Sample] Calc & Basic: Sheet, Row/Column, Cell Operation
Zizi64, Thanks for the update info. Ralph
OpenOffice 4.1.1 on Windows 10 Home