https://bugs.documentfoundation.org/show_bug.cgi?id=115642
--- Comment #14 from Kevin Suo <suokunl...@126.com> ---
> Invalidly formatted numbers fail to trigger #VALUE! in formula
But how to reproduce this? Do you have steps?
For me, my locale decimal separator is ".", so:
A1: 1,2345
A2: 2,4567
A3: 1.1111
A4: =SUM(A1:A3) --> 1.1111
A5: =A1+A2+A3 --> #VALUE!
As you can see, A1 and A2 are invalid numbers (for my locale). So:
1. SUM(A1:A3) results 1.1111, this is correct. I think MS Excel will get the
same result.
2. A1+A2+A3 results #VALUE!. This may also be correct and is expected.
The above will be the same if you type
a
b
1
and then you will get:
SUM(A1:A3) = 1
and
A1+A2+A3 = #VALUE!
Version: 6.0.1.1
Build ID：60bfb1526849283ce2491346ed2aa51c465abfe6
CPU 线程：2; 操作系统：Linux 4.14; UI 渲染：默认; VCL: gtk2;
区域语言：zh-CN (zh_CN.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
