OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

New User Word file with imbedded SSheet (readonly)

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer
View previous topic :: View next topic  
Author Message
Muzzta1
Newbie
Newbie


Joined: 14 Aug 2007
Posts: 2

PostPosted: Tue Aug 14, 2007 6:06 pm    Post subject: New User Word file with imbedded SSheet (readonly) Reply with quote

Hi,
Hope this is simple. I need to use some word files that have a simple imbedded spread sheet. I can display the document and spreadsheet but when I try to edit the imbedded section it opens in readonly mode. Can I open it in edit mode? How?

Thanks

Muzza
Back to top
View user's profile Send private message
bobharvey
Super User
Super User


Joined: 23 Apr 2004
Posts: 1075
Location: Lincolnshire

PostPosted: Wed Aug 15, 2007 12:40 am    Post subject: Reply with quote

Hmm.
This doesn't sound like the sort of function I have found in any office suite. Sounds like you might be better off using web pages rather than distributing documents.

But I have found two ways to nearly do it - you could even combine them. one depends on the sheet being a linked OLE object in the document, so it might get a bit hairy with very large sheets working out what you are going to display. Don't forget that you will have to distribute both files together (or have the spreadsheet on a server whose network address appears exactly the same for everyone opening it).

1. Create your spread sheet.
2. Create your document.
3. To insert the sheet, use insert-object-ole object. Select "create from file" and tick the "link to file" then select the file.

First protection method: mark the spreadsheet as read-only (in M$) or remove Write access (in *nix). When someone clicks into the spreadsheet, they will get a dialogue saying that it was opened read-only. They can still scroll around the sheet but cannot edit it. It will revert next time the document is loaded.

Second protection method:
Right-click on the embedded sheet and select "object". In the options tab there are three protection tick boxes. One of them will prevent people clicking into the object at all. (This technique will be the same if the object is truly embedded, not linked)

(Third protection method):
You could combine this with protecting the spreadsheet internally with its own tools. I didn't bother to test this, but it will be useful if you need a password

Snags:
With the second technique, they can turn it off just as easily as you can.
With the first technique, they can click into the sheet, scroll it out the way, and then print the document with a blank bit where the sheet should be. The sheet has to be distributed with or accessible to the document.

The first technique would work best if the sheet was in a shared location, owned by someone else, and with read-only access to your users (e.g. rw-r--r-- . I think that windows protections can be similarly set if sensible groups have been created). It looks more elegant if combined with the second technique - casual clicking will be ignored, and if they get into the control and turn off the protection, only then they will get told off by the dialogue box.

If this is a problem you think will be more widespread, you could submit an enhancement request on the qa project for passwords on the object properties. I can't see this taking off, however.
Back to top
View user's profile Send private message
foxcole
Super User
Super User


Joined: 19 Jan 2006
Posts: 2771
Location: Minneapolis, Minnesota

PostPosted: Wed Aug 15, 2007 5:46 am    Post subject: Reply with quote

bobharvey wrote:
Hmm.
This doesn't sound like the sort of function I have found in any office suite. Sounds like you might be better off using web pages rather than distributing documents.

I think, Bob, you may have perhaps misunderstood the question. Wink The problem is that the spreadsheets are already "protected"--they're opening as read-only, but Muzza needs to edit them.

Muzza, did the documents you're working with originate in MS Office (so, Word and Excel), or are they documents you or someone created in Writer and Calc?
_________________
Cheers!
---Fox

WinXP Pro SP2, OOo Portable 2.3.1, OOo local 2.4 RC4
New OpenOffice forum: http://user.services.openoffice.org/en/forum/
Manuals: http://documentation.openoffice.org/manuals/index.html
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
Muzzta1
Newbie
Newbie


Joined: 14 Aug 2007
Posts: 2

PostPosted: Wed Aug 15, 2007 11:31 am    Post subject: Reply with quote

Sorry If I was a little misleading. The Doc is an invoice used for years in MS Office.
It has a very simple series of calculations and a couple of if functions.

I guess i could recreate it howeverIt seems to function perfectly apart from the imbedded spreadsheet being read only.

Muzza
Back to top
View user's profile Send private message
bobharvey
Super User
Super User


Joined: 23 Apr 2004
Posts: 1075
Location: Lincolnshire

PostPosted: Wed Aug 15, 2007 12:51 pm    Post subject: Reply with quote

Apologies for misreading the query.

When I double click in a fully-embedded spreadsheet in a document, the menus for the spreadsheet replace those for the document. That includes tools-protect document.

If that doens't help, then I'm stuck, I'm afraid
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group