[Solved] Formulae not working on copied data
[Solved] Formulae not working on copied data
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
AOO 4.1.8 Build 9803
- Hagar Delest
- Moderator
- Posts: 32655
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Formulae not working on copied data
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.
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
Re: Formulae not working on copied data
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?
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.
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.
- Hagar Delest
- Moderator
- Posts: 32655
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Formulae not working on copied data
Not an image, an embedded sheet actually.Zizi64 wrote:You have pasted the date a an Image
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: [Solved]Formulae not working on copied data
Thank you!
Windows 7 Pro 64 bit SP1
AOO 4.1.8 Build 9803
AOO 4.1.8 Build 9803
Re: [Solved] Formulae not working on copied data
Ohhh, yes, I see it now!Zizi64 wrote:You have pasted the date a an Image
Not an image, an embedded sheet actually.
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.
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.