I'm not sure if this is a bug or what, but it's unexpected behavior. Say you make a uniform table, and one of the columns is a formula with references to other cells in the row, and those cells might be blank. If you now sort by the formula column, the cell references in each formula cell may now refer to the cells in other rows (where the blanks were) instead of the row where they are now located. If you simply insert a dummy value into those empty cells, the formula references will be preserved correctly, but filling in the blanks can be tedious. Is this a bug or is there a way to work around it?
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
