https://bugs.documentfoundation.org/show_bug.cgi?id=124454
Eike Rathke changed:
What|Removed |Added
Status|NEW |ASSIGNED
https://bugs.documentfoundation.org/show_bug.cgi?id=124454
--- Comment #11 from Eike Rathke ---
(In reply to b. from comment #8)
> may be off topic, but astonishing for me ...
> --1 -> -1
That is clearly a bug, though not related to the formula expression behaviour
discussed here otherwise, but
https://bugs.documentfoundation.org/show_bug.cgi?id=124454
b. changed:
What|Removed |Added
CC||newbie...@gmx.de
--- Comment #10 from b.
https://bugs.documentfoundation.org/show_bug.cgi?id=124454
--- Comment #9 from dursoj...@gmail.com ---
It appears Excel & Google Sheets treat "--" differently than Calc.
As others have stated, Since "--" is actually a common way to convert texts to
numbers, and is taught in a lot of "Excel tips
https://bugs.documentfoundation.org/show_bug.cgi?id=124454
--- Comment #8 from b. ---
may be off topic, but astonishing for me ...
1 -> 1
+1 -> 1
=1 -> 1
=+1 -> 1
=++1 -> 1
-1 -> -1
=-1 -> -1
=--1 -> 1
-(-1) -> 1
--1 -> -1
last line conflicts with my 'simple minded user expectations' and with
https://bugs.documentfoundation.org/show_bug.cgi?id=124454
--- Comment #7 from Ming Hua <3429171...@qq.com> ---
(In reply to m.a.riosv from comment #6)
> It is in relation about when LibreOffice does the conversion from text to
> numbers.
>
> Automatic conversion doesn't work with arrays because
https://bugs.documentfoundation.org/show_bug.cgi?id=124454
--- Comment #6 from m.a.riosv ---
It is in relation about when LibreOffice does the conversion from text to
numbers.
Automatic conversion doesn't work with arrays because only direct references to
a cell can get the automatic conversion
https://bugs.documentfoundation.org/show_bug.cgi?id=124454
--- Comment #5 from GerardF ---
Created attachment 150442
--> https://bugs.documentfoundation.org/attachment.cgi?id=150442=edit
simple test
simple test file to demonstrate the bug
--
You are receiving this mail because:
You are the
https://bugs.documentfoundation.org/show_bug.cgi?id=124454
GerardF changed:
What|Removed |Added
Summary|Formula with SUMPRODUCT & |Double negation with text