| Summary: | Calc: Paste special/paste special/ values from formula with or without formatting adds ' to value/result. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | dalobo |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | gerard.fargeot |
| Priority: | medium | ||
| Version: | 6.0.7.3 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
Results of functions RIGHT, LEFT, TRIM are text. Copying result and pasting don't convert text to numeric value. Use VALUE before copy, (example in H1) : =VALUE(TRIM(G1)) |
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.