Ask Your Question

copy and past numbers in calc [closed]

asked 2016-02-06 06:20:19 +0200

wimmer184 gravatar image

updated 2020-08-11 17:23:12 +0200

Alex Kemp gravatar image

Maybe this has a very simple solution, if so I am sorry. It is driving me nuts. I don't use spreadsheets at all usually, so please forgive if this question is stupid.

The only thing I want to do is copy some numbers from one file to the other. I hit ctrl-c, then ctrl-v and all that is pasted is a picture of a number.

I search and find the paste special. But this offers me only: Source: Unknown source PNG Bitmap Bitmap

even if I want to copy within the same file.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-11 17:24:14.309615


more details: I am using the latest version on ubuntu. the file is a csv file, the numbers are definitely numbers. I can copy a single number by clicking on the field, and copying from the input line. I cannot copy a row or column, which is what I need.

wimmer184 gravatar imagewimmer184 ( 2016-02-10 01:56:07 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-02-09 12:01:24 +0200

pierre-yves samyn gravatar image


You use the right procedure but what you copy is clearly not a number entered into a table cell but a picture of a number. So paste can only generate an image.

Difficult to say more without having the spreadsheet. Are you at the origin of what you copy? Would it not already the result of a copy, from a web page, for example?


edit flag offensive delete link more

answered 2016-02-09 15:32:37 +0200

LKeithJordan gravatar image

updated 2016-02-11 16:13:47 +0200

The procedure you used is correct. I just tried it using LO Version for Windows and it worked fine. I suggest you uninstall the version you have and download a current stable version from the web.

UPDATE: 2016.0211 After your last response, I created a csv file with some numbers and opened it in LO Calc. I then opened a new Calc file and tried numerous combinations of copy and paste. I did not experience the effect you describe.

In my opinion, there are only two possible explanations for the problems you are experiencing: 1) a corrupt csv file; or 2) a corrupt LO install.

Test to see if there is some trash or corruption in the csv file. Try creating a sample csv file and performing some copy and paste tests as I did. If your results are the same as mine, there is something wrong with your original csv file.

If STEP 1 does not point to a resolution, proceed to STEP 2.

Once again, I recommend you uninstall your version of LibreOffice, go to the web, and download and install a stable version of the latest release.

Good luck.

edit flag offensive delete link more


By the way, your question is not stupid. Sometimes things just don't work the way they are supposed to.

LKeithJordan gravatar imageLKeithJordan ( 2016-02-09 15:34:49 +0200 )edit

The question might be stupid, but I am not.

wimmer184 gravatar imagewimmer184 ( 2016-02-10 01:56:12 +0200 )edit

I reiterate, your question is not stupid.

LKeithJordan gravatar imageLKeithJordan ( 2016-02-11 16:15:19 +0200 )edit

Question Tools



Asked: 2016-02-06 06:20:19 +0200

Seen: 143 times

Last updated: Feb 11 '16