Apache OpenOffice (AOO) Bugzilla – Issue 106944
Problem with the sum in OpenOffice Calc
Last modified: 2009-11-16 15:57:11 UTC
Hi, My name is Bruno and I am a User of OpenOffice.org in Brazil, which is known as BROffice here. There is a basic problem in the sum of numbers. He recognizes as text when typed some monetary value out of the default, but if we add this text to a sum of values, it does not acknowledge error. For example: E48 K48 M48 'R$217,00 R$ 50,00 R$ 90,00 R$ 90,00 R$ 80,00 R$ 5,00 Q49 R$ 5,00 =SOMA(M48:K49)+E48+K48 R$ 420,00 The value of E48 is a text, but the OpenOffice Calc does not recognize the sum as a mistake. This creates a problem in the final sum, because it has an incorrect value. A tag error "# VALUE!" as that already exists in Microsoft Office Excel could be the solution to this problem. Thanks, Bruno Alves
Created attachment 66137 [details] Error: Sum of cells and text values
double to fixed Issue 5658 *** This issue has been marked as a duplicate of 5658 ***
closed double