<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Wrong Cell Format from Text to Numeric with special format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118097">118097</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Wrong Cell Format from Text to Numeric with special format
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kszosze@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>