[Solved] Open calc from a particular sheet showing a dialog

[sombindas]

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?

[mgroenescheij]

Hi,

[sombindas]

Thanks for providing your valuable time Martin. Let me clear you my quarry. I want to open worksheet always from sheet 1 range A1: D6 though I closed it previously from another sheet. I also want to show an user form while opening the same. As all the above are possible in Ms Excel, I think its possible too in Ooo.

[mgroenescheij]

Hi,

As said OpenOffice remembers the view when you close the document, as far as I know there are no settings/options to change the behavior.
I have no idea what kind of form there should be opened, you need to give more information on what kind of form and how that form is created.

And don't expect that OpenOffice is an copy of MS Office it's a different beast.

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

[sombindas]

Thanks for your quick reply Martin. Glad to see you so honest to admit that you dont know how to change the default behave. Actually I have an index in sheet 1 which I always wanna show on opening. Its possible in excel and you may have a look at the link below and you may have a look at the user form under "Open Office Basic macro organizer", "Dialogs" http://www.vbaexpress.com/kb/getarticle.php?kb_id=338.

[pitonyak]

To my knowledge, Calc does not use different names for a sheet... In other words, it does not have an internal "code name" and an external "user name". You could test this theory of mine by loading an Excel document into Calc, changing the name of the sheet in question, and then saving it as an Excel sheet. Then, see if the Excel macro continues to function.

Attempting to insert embedded XML user attributes into the sheet might be a partial solution, then you would need to either embed the macros that handled that into OOo or each document of interest. If you did embed user attributes, you would need to architect your solution to insert them at an appropriate time.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php

[sombindas]

Thanks for your kind reply Sir Andrew Pitonyak. As you said, I opened an excel file in Ooo and found that the existing macros not working. Actually I want a simple solution of my quarry as the same is possible in excel through some code. Please forgive me if my quarry is idiotic.

[sombindas]

For further reference I would like to share this document in excel created by me which always open from a particular sheet showing an user form.

[sombindas]

For further reference I would like to share this document in excel created by me which always open from a particular sheet showing an user form. http://www.askwb.com/download/file.php?id=272

[pitonyak]

[sombindas]

Thanks again for your reply Sir Andrew Pitonyak. As we know, necessity is the mother of invention, I tried to learn the matter and found my solution and now its working great. Actually, it will be very helpful if anybody always wants to open an index in a spreadsheet having lotsa sheets. Here is the link http://user.services.openoffice.org/en/forum/viewtopic.php?f=25&t=48484&p=222906#p222906

[pitonyak]

Excellent
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php

[sombindas]

Thanks your your encouragement Sir. Many things to learn from you.