Copy and paste part of a column

Discuss the spreadsheet application

Copy and paste part of a column

Postby mukiduk » Sun Apr 28, 2019 11:36 pm

I am trying to copy part of a colume of numbers in my calc spreadsheet so I can add them up but trh resulting pasted list is a photo. That is all the numbers are selected with a border around them so I cannot add them. Can some one tell my why this is happening.
OOo 3.0.X on Ms Windows XP + Ubuntu
mukiduk
 
Posts: 17
Joined: Wed May 20, 2009 9:05 pm

Re: Copy and paste part of a column

Postby FJCC » Sun Apr 28, 2019 11:53 pm

I have only seen that when pasting from Calc to Writer. Are you pasting into the same Calc document, another Calc document or something else? What steps exactly are you taking?
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7229
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Copy and paste part of a column

Postby mukiduk » Mon Apr 29, 2019 12:27 am

i am using oo calc 4.1 on a windows 7 machine and I am copying from a large calc file onto a new calc document so I can all just add these few numbers but when I open the new document there is a ring around all the numbers so they will not add.I am copying if from an excel file because I had trouble with OO calc at the time I made the file which was a few years ago. So I saved it as a xls file. DO you think that if I saved the file as an ODS again, I will be able to add a few entries? I only save my calc files as xls because I belong to a computer club populated with microsoft slaves who will not even try open office.
OOo 3.0.X on Ms Windows XP + Ubuntu
mukiduk
 
Posts: 17
Joined: Wed May 20, 2009 9:05 pm

Re: Copy and paste part of a column

Postby FJCC » Mon Apr 29, 2019 1:27 am

The format a file is saved in should not affect the behavior of OpenOffice once the file is open. I cannot account for the behavior you are seeing. What happens if you make a new Calc file and try to copy from that to another Calc file. If that works, then your problem is associated with your source file. If the problem persists with a new file, then something is wrong with Calc. Please try the experiment and let us know.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7229
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA


Return to Calc

Who is online

Users browsing this forum: No registered users and 26 guests