https://bugs.documentfoundation.org/show_bug.cgi?id=124723
Bug ID: 124723
Summary: Calc: Paste special/paste special/ values from formula
with or without formatting adds ' to value/result.
Product: LibreOffice
Version: 6.0.7.3 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dal...@hotmail.com
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs