[Libreoffice-bugs] [Bug 124454] Double negation with text in array context behaves like single -

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #9 from dursojohn at 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 and tricks" kind of books, this
makes using Calc looking like it is calculating (to the norms) but not
calculating to what is expected.

Therefore, either 1) there should be a warning when "--" is used that this
calculates differently than the expected (at least on the first calculation of
the spreadsheet) or 2) Calc should calculate the same as Excel and Google
Sheets.

-- 
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/20190405/9eaac786/attachment.html>