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

Forum rules
No question in this forum please
For any question related to a topic, create a new thread in the relevant section.

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

Postby ralphhosmer » Sun Jan 25, 2015 8:34 pm

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]
Attachments
SpreadsheetHandlerTest_1.ods
ooCALC with ooBASIC Program
(25.29 KiB) Downloaded 327 times
OpenOffice 4.1.1 on Windows 10 Home
ralphhosmer
 
Posts: 61
Joined: Mon Nov 03, 2014 2:14 pm

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

Postby Zizi64 » Sun Feb 01, 2015 11:01 am

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...
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.0.4 and AOO4.1.5
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.
User avatar
Zizi64
Volunteer
 
Posts: 6703
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby ralphhosmer » Sun Feb 01, 2015 3:50 pm

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
OpenOffice 4.1.1 on Windows 10 Home
ralphhosmer
 
Posts: 61
Joined: Mon Nov 03, 2014 2:14 pm

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

Postby Zizi64 » Sun Feb 01, 2015 4:18 pm

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 3709 times


newtoolbar2.png
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.0.4 and AOO4.1.5
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.
User avatar
Zizi64
Volunteer
 
Posts: 6703
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby ralphhosmer » Sun Feb 01, 2015 7:00 pm

Zizi64, Thanks for the update info. Ralph
OpenOffice 4.1.1 on Windows 10 Home
ralphhosmer
 
Posts: 61
Joined: Mon Nov 03, 2014 2:14 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 1 guest