"I hope the Numbers Gurus will fix it some day.
Don't you thinks it a bit predjudiced to only sort the rows?"
I suspect the 'Numbers Gurus' see no need to 'fix' something that isn't broken. Having Numbers's sorting mimic a database is a design decision, and to my mind, it's a good one, and part of a larger view of what Numbers is and how its documents should be built.
Most spreadsheet applications are based on a single large table per document, and with that model, it makes some sense to provide for sorting only part of the table. Numbers model is based on several independent (but interactive) tables, each used for a single purpose task. Within each table each row is a unit of related data that stays together. With that model, sorting the rows rather than the individual cells makes sense, and anything that needs to be sorted separately from the rest of the row would be better placed in a separate table.
"Prejudiced"? I'm not sure what you mean by the term. Every piece of software (or hardware) involves the judgement of its designers, and much of that judgement has to take place during the development process, which usually occurs prior to the product's release. So, yes, the judgement that sorting by rows is the best route was a 'pre release' judgement. But that's also true of other spreadsheet applications whose developers judged (prior to the release of that product) that sorting only selected columns was the way to go.
I (and several others who were doing the data processing for a regional science fair the year that Apple decided to introduce 'sorting only selected columns' in AppleWorks) spent the better part of a day and night repairing the effects of that unfortunate decision (while the students waited less than patiently for their results)!
That said, if you want changes to the way numbers (or any other Apple application) works, this user-to-user forum isn't the place to make your request. Current Apple applications all have an Application menu (in Numbers, called the 'Numbers' menu) and the ones I've seen all have an item in that menu named "Provide application Feedback." Requests and other feedback provided via that link go directly to Apple, and have resulted in changes to subsequent versions of a number of applications (including Numbers).
Regards,
Barry