Issue 106944 - Problem with the sum in OpenOffice Calc
Summary: Problem with the sum in OpenOffice Calc
Status: CLOSED DUPLICATE of issue 5658
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-11-16 12:59 UTC by bruno_alves
Modified: 2009-11-16 15:57 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Error: Sum of cells and text values (7.96 KB, image/png)
2009-11-16 13:01 UTC, bruno_alves
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bruno_alves 2009-11-16 12:59:17 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
Comment 1 bruno_alves 2009-11-16 13:01:28 UTC
Created attachment 66137 [details]
Error: Sum of cells and text values
Comment 2 frank 2009-11-16 15:56:47 UTC
double to fixed Issue 5658

*** This issue has been marked as a duplicate of 5658 ***
Comment 3 frank 2009-11-16 15:57:11 UTC
closed double