<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 - Calc: Paste special/paste special/ values from formula with or without formatting adds ' to value/result."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124723">124723</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc: Paste special/paste special/ values from formula with or without formatting adds ' to value/result.
</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>Linux (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>dalobo@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I created a series of formulas to lean how to do this stuff in Libre, since i
only know Excel. Pasting a formula as a value with or without formatting adds a
' to the value, breaking it when using SUM, not to mention it should NOT be
there.
(A1) Remnux , 30 Gig (C1) =FIND(",",A1,1) (D1) =LEN(A1) (E1) =RIGHT(A1, D1-C1)
(F1) =TRIM(E1) (G1) =LEFT(F1,3) (H1) =TRIM(G1)
Copy the final formula, and paste in as a value, and I get '30 NOT 30.
Note, B1 is my hand value of 30, and is not used in my formulas.
It does not matter if you choose keep formatting or not. I choose just numbers
too, and it did not resolve the issue.
In the main spreadsheet: I forced all cells to numbers, which they already
were. Did not help.
I am running this on a new laptop running Ubuntu 18.04 (all software updated)
(Dell XPS 13).
Steps to Reproduce:
1. Put in my values and formulas above.
2. Copy the 30 in G1 (which is still a formula)
3. Right click and paste special/paste special/values
Actual Results:
'30
Expected Results:
30
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Copied the value of the formula, which was just the value 30.
I did this on a series of info, not just the one example I gave you. All failed
by adding the ' to the value
I copied as unformatted text, and it pasted in just the values, the way copy
values should have worked.</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>