paste special problem

users
#1

on my opensuse 12.3 and libreoffice Version 4.0:build-305 and also with Version: 4.1.1.2 paste special doesn't works any more.
if I select a group of cells with formulas, move in another position and I perform paste special, a "paste special" window appear with only:
source: unknown source
selection: unformatted text
and the buttons OK CANCEL HELP

the classical paste special dialog box with the classical choices like "text", "numbers", "formulas", "transpose".... doesn't appear.

how can I get the paste special works???
thanks, :slight_smile: ciao :slight_smile: pier

#2

I have been having serious problems with 'Paste Special' working, then not working, then working again, on many different spreadsheets (most if not all created a long time ago, some as old as Openoffice 1.x)...

It is extremely annoying, and sometimes even prevents me from getting something done.

Been meaning to post a bug, but the problem is, I have not found a reliable way to reproduce it...

#3

now for me is extremely reproducible, it never works....:slight_smile: :slight_smile: :slight_smile: :slight_smile:
now "paste special" and alsoo "simple paste" doesn't works, they paste only values, not formula or other....
I don't know how to come back to a working situation.
may be it could be some config file to delete, but I cannot find it,
in my /home I found a ./libreoffice folder, I renamed it but nothing change....:slight_smile: :slight_smile: :slight_smile:

#4

The very first thing I tried was deleting the .config and letting LO create a new one... no joy...

#5

In Windows, I have had a different but probably connected problem. I copy from an application to paste in LO Calc, but the menu is greyed. That is, like when I have not copy anithing yet, but in reality the copy was done.

What works me is close and reload LO. Then, I can copy and paste again.

#6

Hi. I found on linux the clip board settings can affect pasting. I don't have it completely figured. I had it at one time that ctl-V would paste the formula the first time and then the text value the next paste. Now it pastes formula each time.
Steve