Hi.

Please ...

- open the atttached text file (copy_paste.csv) in a text editor
- select the whole content
- copy to clipboard

- open a blank spreadsheet in OOo Calc
- paste into Calc:

Note that the leading zeros are vanished. This is because there is now way to
tell Calc to treat the second column as text.

In MS Excel a symbol appears after pasting where the user can select a text
import wizard where the columns can be set to text format.

OOo Calc also has such a wizard, but it is used only when opening the csv-file.
This means that such code is already in Calc.

So it should not be a big effort to allow using this wizard also when pasting
from clipboard!

I don't want you to adopt this strange icon of MS Excel where the user can
select format after pasting. There I tink OOo's concept of the drop-down
paste-button is more intuitive.
I think in Calc this wizard should be accessible by a checkbox named "Use text
import wizard" or similar in the "Paste Special"-window that can be accessed
from the "Edit"-menu.

I really think that this is a useful enhancement that should be not too much
work to implement.