https://issues.apache.org/ooo/show_bug.cgi?id=125778
mroe <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from mroe <[email protected]> --- Created attachment 84095 --> https://issues.apache.org/ooo/attachment.cgi?id=84095&action=edit difference between addition and SUM()-function and between multiplication and PRODUCT()-function In my opinion =A1+A2 should provide the same result as =SUM(A1;A2) or =SUM(A1:A2) regardless of the content of the cells A1 and A2. Cells with text content should be ignored in all calculations; treated as 0 for addition and as 1 for multiplication. BTW: In versions _before_ AOO text values in a multiplication was treated as 0 but as 1 in PRODUCT(); for addition and SUM() always as 0. With a number in A1 and text in A2: =A1*A2 result 0 =PRODUCT(A1;A2) result A1 =A1+A2 result A1 =SUM(A1;A2) result A1 -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
