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

            Bug ID: 133588
           Summary: calc:The function SUM() does not produce the same
                    result as the '+' operator
           Product: LibreOffice
           Version: 6.0.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: sebastien.kr...@wanadoo.fr

Description:
The function SUM() does not produce the same result as the '+' operator in
certain situations. I have the feeling this should not be.

Steps to Reproduce:
1. enter "'1" in cell A1 (without the ")
2. enter "'2" in cell B1 (without the ")
3. enter "=sum(a1:b1)" in cell C1 (without the ")
4. enter "=a1+b1" in cell D1 (without the ")
5. watch


Actual Results:
the two cells C1 and D1 do not contain the same value

Expected Results:
The two cells C1 and D1 should contain the same value (either 0 or 3, I have no
definitive answer on that point). I assume that when using the '+' operator, an
automatic conversion to numerical values is done. If so, then why isn't that
conversion also done when using SUM() ? This is odd.


Reproducible: Always


User Profile Reset: No



Additional Info:
The numerical values in A1 and B1 are in fact imported from another tool that
(who knows why) exports them as strings, thus they are prefixed with "'"

If you feel this is not a bug but a "feature", could you give me a link on
where that behavior is documented? Thank you.

Version: 6.0.6.2
Build ID: 1:6.0.6-0ubuntu0.14.04.1
CPU threads: 8; OS: Linux 4.4; UI render: default; VCL: gtk2; 
Locale: fr-FR (en_US.UTF-8); Calc: group

-- 
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