You do have the opportunity to Undo Sort in the Edit menu, but that's not terribly useful in this case as Undo is done step by step in reverse order as you would have deleted the blank rowsĪfter doing the sort, you would have to Undo that deletion before Undo Sort became available. "Sort" rearranges the rows in order using the contents of one or more columns as the key for the sort. I thought uncategorize would return the blank rows to their original position. I'm guessing the easiest way for me to eliminate the blank rows is sort by a column which contains data in all the rows, then delete blank rows, then uncategorize. As Barry so kindly pointed out, I can't even speak the "language of the application". Well, I am very grateful for the elaborate fixes, but I must admit the last few were quite over my level of expertise. Question : Am'I the only one receiving spams for viagra or similar products in a mac.com mailbox ? It's a pity to be dropped by what I feel to be the best design ever issued by Apple. I forgot to say thank you for your condolences. May his older brother continue to live on and prosper. I would like to pay my respects to the fallen Mac. Yvan KOENIG ( VALLAURIS, France ) jeudi 2 septembre 2010 22:34:58 Most of the time, I don't explain why I choose this or that soluce. I know that mine is not perfect, my preferred one would be with the formula in column A so that adding new column wouldn't change its behaviour but I quickly thought that it wouldn't be clean in the tables.Īs aspect is an important feature of Numbers, I choose to put the formula in the "Far East".
Only the user know exactly which is the one matching its needs. It checks that the result of the concatenation of every cells on the left of the formula is a value whose length is zero. No, if you take that with the often used meaning : blank or contain a string whose length is zero.įor such a test, I felt that the second acception (which I don't like) may be valid. Yes if you take "empty" cell at its true meaning. Yvan KOENIG (VALLAURIS, France, 2 21:11:36) Happily its older 'brother', a Powermac G4 is always alive so I will be able to run some oldies under Classic. It's really pitiful : I never got an Apple product with so short life. So, a lot of my custom tools will not be available making me less efficient. My datas from the forum are on its internal HDs (they don't match the definition “important datas”) so I will unable to reach them until next week when I will receive enclosures in which I will put the devices. My Powermac G5 bought at end of 2005 died : motherboard dead. I have a lot ot table with nothing in cells of column A but values in other columns. I think that my formula is more complete but of course it depends of which kind of datas are stored in the table. I choose to check that every cells of a row (before the one in which is the test formula) are empty. This somewhat simpler expression seems to do the same thing.
0 kommentar(er)
