[Libreoffice-bugs] [Bug 42990] EDITING: Inconsistencies in Calculations; No error for SUM function as it skips text fields.

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=42990

Jean-Baptiste Faure <jbf.faure at orange.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |jbf.faure at orange.fr
     Ever Confirmed|0                           |1

--- Comment #1 from Jean-Baptiste Faure <jbf.faure at orange.fr> 2011-11-16 21:47:17 PST ---
Reproducible with LibreOffice 3.4.4 under Ubuntu 10.04 x86_64 but not exactly
as described. In my case, column H shows several error codes #VALUE!. It is for
values in column A less than 1 if I interpret these values as decimal numbers
(nothing before the dot). For rows 5 and 10 the values seems to be interpreted
as dates and column H make the product of a date by something else. I don't see
what that can be meaning.

The case of SUM is clear and consistent for me: it ignores all text values. You
can easily identify text which looks like numbers if you check the option
"Value highlighting" in Tools > Options > LibreOffice Calc > View.
More, if you clear direct formatting in column A, you can see that the
"numbers" with decimal dot are shifted to the left side of the cell. That means
they are interpreted by Calc as text not as numbers. 

Best regards. JBF

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.