https://bugs.documentfoundation.org/show_bug.cgi?id=115642

Eike Rathke <er...@redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #16 from Eike Rathke <er...@redhat.com> ---
This is not a bug. For SUM and other functions that take a cell range argument
that is defined to be a NumberSequence, cells with content of type Text by
definition are ignored. They are not to produce an error value. This is the
same in every major spreadsheet implementation.

In the case of the attached sample document, only cells A3 and B3 have a
content of type Number (0.0016177), the other cells have content of type Text
so are ignored.

Note that this is not about "invalidly formatted numbers" like the title says,
instead it is about the cell content *type*.

Also note that the behaviour of calculations with operator + and text strings
that look like numbers may depend on the current locale and its separators and
the settings under Tools -> Options -> Calc -> Formula, Detailed Calculation
Settings, conversion of text to numbers. My personal recommendation is to set
that under Custom to "Generate #VALUE! error" to spot data type problems early,
and specifically not use the "Convert also locale dependent" setting.

The leading apostrophe in '0,00456 displayed in the input line indicates that
the cell content is of type Text but could be interpreted as number (in the
current locale). Actually it can be converted to numeric content, for details
see
https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to