[Solved] Formulae not working on copied data

Discuss the spreadsheet application
Post Reply
dobrphi
Posts: 16
Joined: Fri Apr 30, 2010 11:53 pm

[Solved] Formulae not working on copied data

Post by dobrphi »

I built a spreadsheet that successfully gave me what I needed. I wanted to use that same sheet with different input data. I made a copy of the original and deleted everything from the cells except the formuale. I did a copy and paste of three columns of data from another spreadsheet. I'm not seeing any of the formulae being executed. I entered a line of data manualy below that which I had copied and the formulae worked. l haven't tried this before. Am I trying to do something that can't be done or what am I doing wrong? Thanks.
Attachments
Electric rate comparison 1.ods
Added green tick [RoryOF, Moderator]
(17.1 KiB) Downloaded 95 times
Last edited by dobrphi on Sat Jun 12, 2021 7:30 pm, edited 1 time in total.
Windows 7 Pro 64 bit SP1
AOO 4.1.8 Build 9803
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Formulae not working on copied data

Post by Hagar Delest »

You have pasted as an object. Click the area and you'll see.
Double click it, copy the content, exit by clicking outside, delete the area and paste.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Formulae not working on copied data

Post by Zizi64 »

You have pasted the date a an Image, but not as some numeric data.

What source the data was copied from? What a special paste method did you use?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Formulae not working on copied data

Post by Hagar Delest »

Zizi64 wrote:You have pasted the date a an Image
Not an image, an embedded sheet actually.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
dobrphi
Posts: 16
Joined: Fri Apr 30, 2010 11:53 pm

Re: [Solved]Formulae not working on copied data

Post by dobrphi »

Thank you!
Windows 7 Pro 64 bit SP1
AOO 4.1.8 Build 9803
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: [Solved] Formulae not working on copied data

Post by Zizi64 »

Zizi64 wrote:
You have pasted the date a an Image

Not an image, an embedded sheet actually.
Ohhh, yes, I see it now!
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply