https://bugs.documentfoundation.org/show_bug.cgi?id=118097
Bug ID: 118097
Summary: Wrong Cell Format from Text to Numeric with special
format
Product: LibreOffice
Version: 6.0.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I'm working with csv files that format negative numbers with parenthesis.
Libreoffice support that format also appear in the cell format menu. If I open
the file and choose special numbers option all works as expected, and those
cells are formatted as number. But if the file is opened as text and formatted
manually, choosing which cells are on this specific format a ' is added in
front of the number. Ex
Text cell with (467.56) => '(467.56)
otherwise the expected is
Text cell with (467.56) => -467.56
Steps to Reproduce:
1.Get a csv with negative numbers in between ()
2.Open the file with normal options. All cells will be considered text.
3.Manually format those cells as number with format (1234.12)
Actual Results:
The negative cells will have the format '(#.##0,##0). Still considered Text
cells. That's wrong.
Expected Results:
4.The negative cells will have the format -#.##0,##0. Treated as numbers
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Format the cells as number and consider the content as negatives. Same behavior
if I choose special numbers in the import screen.
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101
Firefox/60.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
