Ask Your Question
0

copy and past numbers in calc

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

wimmer184 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 close merge delete

Comments

more details: I am using the latest version 5.0.4.2 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
0

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

pierre-yves samyn gravatar image

Hi

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?

Regards

edit flag offensive delete link more
0

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 5.0.4.2 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.

STEP 1:
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.

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

Comments

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
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 84 times

Last updated: Feb 11 '16