Hi all, I read on the help of OOo 3.0 that starting from OOo 3.0 the handling on empty cells in calc is changed.
The result of =A1="" is true if A1 is empty. That works very well. So I expect that if I use sumif(A1:A5;"";B1:B5) should sum values in B1:B5 only if the corresponding cells in column A is empty. This is not true. The sum is not right. I searched some issues on internet, but everyone is for version prior to 3.0 and tells that it is as is by design. Now I think it should be different. This is a problem using excel sheet Tnx Ambrogio --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
