In this example I have two sheets. On of them contains data, and this sheet is also used for adding more data. It's like a database, at the moment it has 22 rows plus a header row. The second sheet is a "copy" of the first, and I use it for sorting the data without affecting the original order of the rows (those on sheet 1, called "Customers").
Therefore A2, for example, on sheet 2, called "Sorted" contains this formula, before "Sorted" is sorted: =IF(Customers.A2="";"";Customers.A2) B2 contains =IF(Customers.A2="";"";Customers.A2) and so on. The first 1000 rows contains those formulas, which will be enough for a while. When sorting "Sorted", I do the usual way, selecting Sort in the Tools menu and so on. I do that without selecting anything first, which makes calc selecting the right cells automatically, which I find convenient. The result of this now makes me point out two Calc bugs (if you ask me): 1. Calc doesn't automatically sense recognize the first line as a header, I have to check that one manually. I guess the reason is that I didn't use styles in this simple example, but if one row has a bigger font, shouldn't Calc be able to at least guess that this might be a header? 2. The first 978 rows (headers not counted) now show "" (nothing) and all the data are located at the end of the table. This means that the content "empty string" seems to be moved above cells that contain alphanumerics. It would be really nice if those empty cells were sorted to the end of the list no matter the sorting direction. I intend to report these issues as bugs if no one convince me not to. Any comments to this? Johnny Rosenberg
