https://bugs.freedesktop.org/show_bug.cgi?id=82915

Jean-Baptiste Faure <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Hardware|x86 (IA32)                  |All
                 OS|Windows (All)               |All
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WORKSFORME

--- Comment #6 from Jean-Baptiste Faure <[email protected]> ---
For me it's not a workaround, it's the normal behavior. Paste special is
designed to manage the cases where data have to be interpreted before being
copied. It is clearly the case here. Indeed I think you can't avoid passing
through the csv import dialog to choose the field separator. This dialog
remembers your previous choice, and if you do several imports from various
sources, you may have to change the field separator. It was the case for me
when I did my tests for comment #4 because the csv files I use have mainly the
space as separator field.

That said it is very easy to do this paste special with the toolbar and with
the keyboard:
- with the toolbar: click on the small triangle on the right of the paste
button and you will have a dropdown list with the same items as in Paste
special menu.
- with the keyboard: instead on pasting with Ctrl+V, use Maj+Ctrl+V which is
the shortcut for Paste special; the entry Unformatted text is the first and
selected by default, so you have only to press the Enter key to open the csv
dialog import.

Additionally, if you have to do the same copy-paste operation several times
with different data but same field separator, the csv dialog remember your
choices and you can validate immediately.

So closing as WorksForMe.

Best regards. JBF

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to