[Solved] Open Calc from a particular sheet showing a Dialog

The Application Programming Interface and the OASIS Open Document Format

[Solved] Open Calc from a particular sheet showing a Dialog

Postby som » Thu Mar 01, 2012 6:08 am

I want to open a worksheet from a particular sheet and range. No matter where I saved it previously. I also want to show an user form at the time of opening the same. Is it possible?
Last edited by som on Fri Mar 09, 2012 8:40 am, edited 1 time in total.
OpenOffice version3.3 and the Operating System Redhat Linux
som
 
Posts: 25
Joined: Sun Jan 22, 2012 4:56 pm

Re: Open spreadsheet from a particular sheet and range showi

Postby som » Fri Mar 09, 2012 8:37 am

No reply for a long :bravo: Self help is the best help :crazy: Here is a sample file created by me which will always open from a particular sheet showing a dialog. It will also show a dialog while closing ;)
Attachments
SOM.ods
(12.46 KiB) Downloaded 404 times
OpenOffice version3.3 and the Operating System Redhat Linux
som
 
Posts: 25
Joined: Sun Jan 22, 2012 4:56 pm

Re: [Solved] Open Calc from a particular sheet showing a Di

Postby idiminnalraj » Fri Aug 10, 2012 8:15 pm

Dear Som,
I also want to open a worksheet from a particular sheet.As a result of my googling I reached your page and downloaded your attached spreadsheet.It is very Nice and Fantastic.I tried to work another calc file by copy paste the macro code START.But failed.I couldn't create such a file.Then I tried to attach sheets to your document.But it was protected.Can you help me?
openoffice 3.2 on ubuntu 10.04
idiminnalraj
 
Posts: 1
Joined: Fri Aug 10, 2012 8:03 pm

Re: [Solved] Open Calc from a particular sheet showing a Di

Postby som » Sat Aug 11, 2012 8:07 am

Hi. I am presently out of my home. Please provide me some time, I shall share an unlocked worksheet at my forum within a week. Its www.askwb.com. Can you put your request there at the excel utility segment?
OpenOffice version3.3 and the Operating System Redhat Linux
som
 
Posts: 25
Joined: Sun Jan 22, 2012 4:56 pm

Re: [Solved] Open Calc from a particular sheet showing a Di

Postby som » Sat Aug 11, 2012 8:39 am

Hi. I have created a new topic there. Please have a look at the link below. http://www.askwb.com/viewtopic.php?f=17 ... 4398#p4398
OpenOffice version3.3 and the Operating System Redhat Linux
som
 
Posts: 25
Joined: Sun Jan 22, 2012 4:56 pm

Re: [Solved] Open Calc from a particular sheet showing a Di

Postby som » Sun Aug 12, 2012 8:36 pm

Hi dear, I have posted the same at our forum http://www.askwb.com. Please "CLICK HERE". for entire guide lines of the same with sample worksheet.
OpenOffice version3.3 and the Operating System Redhat Linux
som
 
Posts: 25
Joined: Sun Jan 22, 2012 4:56 pm


Return to UNO API and ODF

Who is online

Users browsing this forum: No registered users and 3 guests