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.
Copy cells to new spreadsheet
-
- Posts: 21
- Joined: Mon Jan 24, 2011 6:27 pm
Copy cells to new spreadsheet
- Attachments
-
- Untitled 1.ods
- document
- (14 KiB) Downloaded 193 times
OpenOffice 3.1 on Windows XP
Re: copy cells to new spreadsheet
I answered this half an hour ago on the macro forum
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 21
- Joined: Mon Jan 24, 2011 6:27 pm
Re: Copy cells to new spreadsheet
this one? http://user.services.openoffice.org/en/ ... 44#p176244
It's too complex for me I wish I knew what to do with the technolingo
can you give me a step by step instruction?
It's too complex for me 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