[Libreoffice-bugs] [Bug 124723] New: Calc: Paste special/paste special/ values from formula with or without formatting adds ' to value/result.

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: dalobo at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190413/a8546710/attachment.html>