| Summary: | pasting from .csv: % interpreted as plain text | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Nicolò Chieffo <84yelo3> |
| Component: | Calc | Assignee: | Kohei Yoshida <kohei> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 3.3.0 Beta3 | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | csv | ||
Kohei? I bet that the "Detect special numbers" check box was off when you first opened the file into libreoffice. Check that option in the import dialog, and try importing the same file again. That should import the percentage values correctly. Let me know how that goes. Thank you for your tip. That was the problem. Remove infoprovider from closed and resolved bugs. RESOLVED, FIXED or CLOSED bugs cant be KEYWORD NEEDINFO. |
Created attachment 40415 [details] csv 1) Open the attached .csv file with libreoffice 2) select a cell and hit ctrl-c 3) open a new document and hit crtl-v Notice that the cell is now text only, so I can't use it in mathematical operations. NOTE: pasting the same value from microsoft excel to libreoffice works as expected!