kev wrote:
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?
Please supply a small example - just a few numbers and the formula you are using in an e-mail. When I try this I find I cannot sort on the "generated" column - nothing happens. If I sort on the "source" column, the generated column gets rearranged appropriately.
Oh, I tried this on OOo 3.1 running on Win XP Pro. What version and OS are you using?
-- Harold Fuchs London, England Please reply *only* to [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
