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

freezing cell contents before sorting

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


Joined: 17 Jul 2004
Posts: 2

PostPosted: Sun Apr 08, 2007 10:43 am    Post subject: freezing cell contents before sorting Reply with quote

I want to use a formula to quickly populate a bunch of cells with related data (ie, serial numbers or such), but then convert those numbers to hard data so they never change again. Is there a simple way to do this?

One of the motivations for this is that I frequently sort the whole sheet by various columns and sorting seems to break relative cell references. I can turn off auto recalculation, but then I still have the danger if I recalculate that the cells will get incorrect data.

Saving to CSV, of course, locks all the data in, which is what I'm doing now. But there really has to be a better way, right?

-- Mario
Back to top
View user's profile Send private message
Warrick Nelson
OOo Advocate
OOo Advocate


Joined: 04 May 2004
Posts: 203
Location: Christchurch, New Zealand

PostPosted: Sun Apr 08, 2007 12:32 pm    Post subject: Reply with quote

I do this often - for similar purposes.

Select the cells, copy and paste special as numbers only.

Sorting does not break relative references. If all relative references are relative only to the same row, then sorting in columns will not show any changes. However, references to outside the sorted range, or to cells in a different row will be affected by sorting. The safest is to convert to numbers.
Back to top
View user's profile Send private message Visit poster's website
TerryE
Super User
Super User


Joined: 16 Jul 2006
Posts: 550
Location: UK

PostPosted: Sun Apr 08, 2007 1:25 pm    Post subject: Reply with quote

A quick way of doing Paste Special is with the CTL-SHIFT-V shortcut.
_________________
Terry
WinXPSP3, OOo 2.4.1, Ubunto 8.04 for development
Also try the Official OOo Community Forum where I mainly post now.
Back to top
View user's profile Send private message Visit poster's website
jagmarz
Newbie
Newbie


Joined: 17 Jul 2004
Posts: 2

PostPosted: Sun Apr 08, 2007 10:20 pm    Post subject: Reply with quote

This is perfect! Thanks!
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 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