[Libreoffice-bugs] [Bug 42990] New: EDITING: Inconsistencies in Calculations; No error for SUM function as it skips text fields.
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Wed Nov 16 15:09:41 CET 2011
https://bugs.freedesktop.org/show_bug.cgi?id=42990
Bug #: 42990
Summary: EDITING: Inconsistencies in Calculations; No error for
SUM function as it skips text fields.
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs at lists.freedesktop.org
ReportedBy: webmeister at axteleats.com
Created attachment 53601
--> https://bugs.freedesktop.org/attachment.cgi?id=53601
ODS File with calculations with numbers as 'Text' but skipped for SUM function
Problem description: Numbers which the user may not know are formatted as
'Text' can be used in calculations. Yet, the SUM function skips them without
any warnings or error messages. This could lead to miscalculations without the
user's knowledge.
Steps to reproduce:
1. In the attached file, you see in cell A19 a SUM of 8. This is supposed to
be a sum of the cells above and is clearly wrong.
2. If you look to the right, in column H, all the fields from column A are used
in calculations without any issues, though some of them in column A are
formatted as 'Text.' This is inconsistent.
3. How do we know when the SUM function is working properly?
Current behavior: Inconsistency in dealing with numbers as text.
Expected behavior: Warnings/errors
Platform (if different from the browser):
Browser: Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.4; fr; rv:1.9.0.19)
Gecko/2011091218 Camino/2.0.9 (MultiLang) (like Firefox/3.0.19)
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Libreoffice-bugs
mailing list