[Libreoffice-bugs] [Bug 132307] Difference between SUM function and plain addition when part of number is Bolded

[bugzilla-daemon at bugs.documentfoundation.org]

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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

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

--- Comment #3 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Not because SUM with a range doesn't take care of text cells, and number's
bolded become text instead number, comment#1, BTW Erak is a main dev on calc.

Only direct references, but not range references to cells with numbers as text
can be taken as numbers, and there is an options in relation it
Menu/Tools/LibreOffice Calc/Formula/Detailed Calculation Settings - Custom -
Conversion from text to number.

You can use a formula like
 =SUMPRODUCT(IFERROR(VALUE(A1:A2);0))
to get what you like, but being sure that is possible convert the text to
number.

Sorry but it's not a bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200422/b4a9de81/attachment.htm>