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

Sorting protected sheets

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
jml3310
General User
General User


Joined: 08 Oct 2007
Posts: 26

PostPosted: Tue Oct 09, 2007 3:01 am    Post subject: Sorting protected sheets Reply with quote

I have certain columns,but not all columns, in a spreadsheet that I don't want to allow modification. I have protected those columns and have protected the sheet, but am not able to sort the data in the sheet.

Is it possible to protect certain columns and still allow sorting?
Back to top
View user's profile Send private message
huwg
Super User
Super User


Joined: 14 Feb 2007
Posts: 890

PostPosted: Wed Oct 10, 2007 12:26 am    Post subject: Reply with quote

I've never found a way. It would be handy, and so would filtering of protected cells.
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Wed Oct 10, 2007 5:27 am    Post subject: Re: Sorting protected sheets Reply with quote

Sorting is a form of modification. If sorting was allowed, the user could sort on a column other than the one you choose. It seems you can't have your cake and eat it.

David.
Back to top
View user's profile Send private message
B Marcelly
Super User
Super User


Joined: 12 May 2004
Posts: 1453
Location: France

PostPosted: Wed Oct 10, 2007 8:06 am    Post subject: Reply with quote

Hi,
You may copy the zone of cells you are interested in, then go to another (empty) sheet and Paste special. It allows you to paste numbers instead of formulas.

Now you can sort the result as you want.
______
Bernard
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc 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