Since the very beginning, it's clear that Numbers is designed to behave like a database.
I wropte many times that, from my point of view, it's why we can't sort a single column : it's required to maintain the integrity of rows/records.
I apologize but I don't know any application entitled iWorks.
Some years ago, Apple introduced a package entitled iWork. Maybe it's the one you are writing about.
I already wrote that several times but it seems that you missed that : when we install iWork as a whole or one of its components, we are urged to accept the License/Terms of Use which contain these lines (in uppercase) :
8. Disclaimer of Warranties.
A. YOU EXPRESSLY ACKNOWLEDGE AND AGREE THAT USE OF THE APPLE SOFTWARE AND SERVICES IS AT YOUR SOLE RISK AND THAT THE ENTIRE RISK AS TO SATISFACTORY QUALITY, PERFORMANCE, ACCURACY AND EFFORT IS WITH YOU. EXCEPT FOR THE LIMITED WARRANTY ON MEDIA SET FORTH ABOVE AND TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, THE APPLE SOFTWARE AND SERVICES ARE PROVIDED “AS IS”, WITH ALL FAULTS AND WITHOUT WARRANTY OF ANY KIND, AND APPLE AND APPLE'S LICENSORS (COLLECTIVELY REFERRED TO AS “APPLE” FOR THE PURPOSES OF SECTIONS 8 and 9) HEREBY DISCLAIM ALL WARRANTIES AND CONDITIONS WITH RESPECT TO THE APPLE SOFTWARE AND SERVICES, EITHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES AND/OR CONDITIONS OF MERCHANTABILITY, OF SATISFACTORY QUALITY, OF FITNESS FOR A PARTICULAR PURPOSE, OF ACCURACY, OF QUIET ENJOYMENT, AND NON-INFRINGEMENT OF THIRD PARTY RIGHTS. APPLE DOES NOT WARRANT AGAINST INTERFERENCE WITH YOUR ENJOYMENT OF THE APPLE SOFTWARE OR SERVICES, THAT THE FUNCTIONS CONTAINED IN THE APPLE SOFTWARE OR SERVICES WILL MEET YOUR REQUIREMENTS, THAT THE OPERATION OF THE APPLE SOFTWARE OR SERVICES WILL BE UNINTERRUPTED OR ERROR-FREE, OR THAT DEFECTS IN THE APPLE SOFTWARE OR SERVICES WILL BE CORRECTED. YOU FURTHER ACKNOWLEDGE THAT THE APPLE SOFTWARE AND SERVICES ARE NOT INTENDED OR SUITABLE FOR USE IN SITUATIONS OR ENVIRONMENTS WHERE THE FAILURE OF, OR ERRORS OR INACCURACIES IN THE CONTENT, DATA OR INFORMATION PROVIDED BY, THE APPLE SOFTWARE OR SERVICES COULD LEAD TO DEATH, PERSONAL INJURY, OR SEVERE PHYSICAL OR ENVIRONMENTAL DAMAGE, INCLUDING WITHOUT LIMITATION THE OPERATION OF NUCLEAR FACILITIES, AIRCRAFT NAVIGATION OR COMMUNICATION SYSTEMS, AIR TRAFFIC CONTROL, LIFE SUPPORT OR WEAPONS SYSTEMS.NO ORAL OR WRITTEN INFORMATION OR ADVICE GIVEN BY APPLE OR AN APPLE AUTHORIZED REPRESENTATIVE SHALL CREATE A WARRANTY. SHOULD THE APPLE SOFTWARE OR SERVICES PROVE DEFECTIVE, YOU ASSUME THE ENTIRE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES OR LIMITATIONS ON APPLICABLE STATUTORY RIGHTS OF A CONSUMER, SO THE ABOVE EXCLUSION AND LIMITATIONS MAY NOT APPLY TO YOU.
Of course the License applying to Lion contain the same sentences.
So, it's clear that it's your duty to change your workflow when Apple decide to apply some changes.
I'm an end user like most of those entering this forum. I do my best to help users when they face difficulties.
Since the delivery of Lion, I posted several tools which evolved according to the reactions of some users.
I never wrote (and will never do) a synthetical tutorial. I know that my old scholar English ios too bad for such a task and I'm not here to make the job of professionals.
Here are some references :
(1) Versions as a recovery tool
https://discussions.apple.com/thread/3303794
In this one I delivered two scripts allowing users to extract documents from the hidden folder storing datas gathered by the feature entitled "Versions". They already allowed several users to retrieve an usable document when the standard ne proved to be corrupted/unusable.
(2) Save_As#3 :
https://discussions.apple.com/thread/3504936?answerId=16810268022#16810268022
It's a script allowing users to work upon a document which was never saved. Triggering it from time to time save a replicate of the work in progress. This time, they keep chronological versions of their work without the annoyements due to the fact that iWork apps are so badly coded that Autosave eat every cycles of a processor core so that they must wait to be able to type something.
(3) I described several times (too often according to some ranters) that the easiest way to work with the apps embedding the new features is to store documents with the status of template/stationary.
This way, when we want to create a new document reusing portions of the existing files, we can't destroy accidentally the original contents.
For some applications we do that thru a simple renaming of the documents.
For other we just need to check a checkbox in the well known documents info window.
On 2011/09/08 I delivered a script entitled set_stationery to achieve the conversion of standard docs into template/stationary ones. It's available in some threads. One of them is :
https://discussions.apple.com/thread/3210906?answerId=16118313022#16118313022
I enhanced it on 2012/01/01 and when I will have some free time, I will add the support of documents created with iBooks Author.
If you take time to read the messages posted by : tonza.
This helper is more technology aware than me. He describe very well why Apple intend to achieve with the new features. The ones discussed in this thread as well as the one entitled sandboxing are designed to enhance dramatically the safety of machines running OS X.
Yvan KOENIG (VALLAURIS, France) lundi 13 février 2012
iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3
My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k