Copy cells to new spreadsheet

Discuss the spreadsheet application
Post Reply
dummydecoy
Posts: 21
Joined: Mon Jan 24, 2011 6:27 pm

Copy cells to new spreadsheet

Post by dummydecoy »

Hey guys, I am not a programmer and I don't know much about calc/excel
but can anyone please help me with this?
I have attached the document I am working on and it has a button, and what I would like is that if I click the button called "COPY TABLE", it would copy the entire table of cells (outlined with the red border), open a new spreadsheet and paste it there.
I tried recording a macro but it doesnt work properly. It would only go as far as copy the table and open a new spreadsheet, but it would not paste the data.
Attachments
Untitled 1.ods
document
(14 KiB) Downloaded 193 times
OpenOffice 3.1 on Windows XP
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: copy cells to new spreadsheet

Post by Villeroy »

I answered this half an hour ago on the macro forum :roll:
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
dummydecoy
Posts: 21
Joined: Mon Jan 24, 2011 6:27 pm

Re: Copy cells to new spreadsheet

Post by dummydecoy »

this one? http://user.services.openoffice.org/en/ ... 44#p176244
It's too complex for me :P I wish I knew what to do with the technolingo
can you give me a step by step instruction?
OpenOffice 3.1 on Windows XP
Post Reply