2007/2/20, Walter Hildebrandt <[EMAIL PROTECTED]>:
Thank you for the help. I have learned that when adding up a column of many cells with the SUM command, the colon : uses all the cells to get the total while the semi-colon used just the first and last cells in the column. Whether the numbers are negative or not does not does not matter. Since the difference between a colon and a semi-colon can be very confusing, I think this is a weakness of OOo.
So how would you like it to be instead? I don't think that the "difference between colon and semi-colon" is confusing at all. The rules about this is rather simple. Also, when typing a letter, colon and semi-colon means different things and few people (as far as I know) get confused by that. When programming in, for example C/C++, colon and semi-colon means different things. Nothing confusing about that. Or maybe I totally misunderstood what you were saying. Johnny Andersson
