[Libreoffice-bugs] [Bug 129780] Bug / Feature ?? Input of (7) into calc cell results in -7 , , if cell is not preformatted as text

[bugzilla-daemon at bugs.documentfoundation.org]

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

Kevin Suo <suokunlong at 126.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |suokunlong at 126.com
         Resolution|---                         |NOTABUG

--- Comment #1 from Kevin Suo <suokunlong at 126.com> ---
I don't think this is a bug.

Numbers enclosed within Parentheses is a valid default negative number format.
You can observe this on Format > Cells > Numbers, category "Numbers", and
select "English (United States" in the language dropdown list.

This is no difference compared with typing "123,456" in the cell, in which case
the input is recognized as a number rather than a string, as the comma "," is a
number format string. Or, it is recognized as a date (stored as a number
actually) if you type in "2020-1-1".

Expressing negative numbers by enclosing the numeber with parentheses is very
common especially in finance. You may see that many companies represent their
financial statements showing negative numbers in parentheses. This means that,
if you copy-paste a this kind of numbers into Calc, it is correctly recognized
as negative numbers rather than string.

See also
https://support.office.com/en-ie/article/negative-numbers-aren-t-showing-with-parentheses-in-excel-682a1cc5-701a-4ce7-92db-cc9eebc5ffa0

-- 
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/20200104/71dea91d/attachment-0001.htm>