<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 - V 6.0.7 or earlier: After opening a CSV file in Cal, all cells appear to be text, but cannot Format $xx.xx Cells to US Currency"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122909">122909</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>V 6.0.7 or earlier: After opening a CSV file in Cal, all cells appear to be text, but cannot Format $xx.xx Cells to US Currency
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.7.3 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>dmnordby@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
After opening a CSV file with CALC, tried to perform calculations example:
=sum(c2:c134) the result is 0. Cells in range appear to be text, but with no
apostrophe in front of the US currency value. After trying to Format Cells to
Currency, all the cells in the range now have an apostrophe inserted! After
manually removing the apostrophes, then the cells behave as numbers/currency.
Steps to Reproduce:
1.With Calc, open CSV file containing column of numbers (US currency)
2.Attempt to calculated sum of cells. [Cells are apparently test format.]
3.Format cells to US Currency
4.Look at cell content and note that each has an embedded "'" apostrophe,
indicating that they are text!!!
Actual Results:
Cannot format apparently text cells to number, even though the cell content
appears to be a number, except the Format Cells Currency has added an
apostrophe ' designating the cell as text!!!
Expected Results:
Should be able to calculate.
Reproducible: Always
User Profile Reset: No
Additional Info:</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>