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

Freeeze Frames/ Sort Ascending

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> Setup and Troubleshooting
View previous topic :: View next topic  
Author Message
Scavy
Newbie
Newbie


Joined: 21 Jul 2012
Posts: 3
Location: GB

PostPosted: Sat Jul 21, 2012 8:41 am    Post subject: Freeeze Frames/ Sort Ascending Reply with quote

When I Freeze Frames (Top Title Row) and then Sort Ascending the content of the spread sheet, the Frozen Top Title Row does not stay on top. It also gets 'sorted'. This did not use to happen, it always stayed on top. Can anyone help me, please.
_________________
Plastered
Back to top
View user's profile Send private message
floris_v
Moderator
Moderator


Joined: 12 Jul 2007
Posts: 4791
Location: Netherlands

PostPosted: Sat Jul 21, 2012 8:59 am    Post subject: Reply with quote

Your version of OOo please; I can't confirm that in AOO 3.4.
_________________
LibreOffice 3.6.3; OOo 3.4.1 on Windows Vista
Join the Official community forum - in several languages, including Nederlandstalig forum
Back to top
View user's profile Send private message
Scavy
Newbie
Newbie


Joined: 21 Jul 2012
Posts: 3
Location: GB

PostPosted: Sat Jul 21, 2012 11:07 am    Post subject: Freeze frames/Sort Ascending Reply with quote

Open office.org3.3.0
OOO330m20 (Build:9567)
_________________
Plastered
Back to top
View user's profile Send private message
thomasjk
Super User
Super User


Joined: 16 Dec 2005
Posts: 2374

PostPosted: Sat Jul 21, 2012 11:36 am    Post subject: Reply with quote

Check Data-->Sort-->Options check "Range contains Column Labels"
Back to top
View user's profile Send private message
Scavy
Newbie
Newbie


Joined: 21 Jul 2012
Posts: 3
Location: GB

PostPosted: Sat Jul 21, 2012 2:13 pm    Post subject: Freeze frames/Sort Ascending Reply with quote

Thanks Floris,
That sort of works (No pun intended) It seems a bit long winded.
As now I have to go Check Data-->Sort criteria--> Sort by (The Column Heading) every time I wish to sort a column by ascending to hold the column title. Where as before it would hold when I clicked on the Sort Ascending Icon.

At lease it works so thanks very much for that, much appreciated.

Best Regards
Scavy
_________________
Plastered
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> Setup and Troubleshooting 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