We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how do i copy calc file formatting to another file

asked 2018-06-17 21:33:05 +0200

djc2jr gravatar image

trying to copy calc file formatting including print ranges, footers, cell sizes, etc. to other calc files

edit retag flag offensive close merge delete


Let me clarify my question. I created over 100 Calc files with data in them. Upon printing the files, I changed some merged cells, some borders, added footers, changed some cell sizes, etc. while coming up with the printed copy that I wanted. Instead of opening each of the over 100 files and making the changes that I did on the printed file, can I do something that would take the formatting properties of the printed file to the other files. The data in the cells will remain unchanged.

djc2jr gravatar imagedjc2jr ( 2018-06-18 17:08:02 +0200 )edit

Do not comment your own question. Edit it. Comments are for asking clarifications etc.

Xoristzatziki gravatar imageXoristzatziki ( 2018-06-20 07:53:51 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-06-20 07:54:15 +0200

Xoristzatziki gravatar image

updated 2018-06-20 07:54:56 +0200

This is a very wide question. In case the data use the same cell range you can copy - paste special to the current sheet, unchecking the format.

edit flag offensive delete link more

answered 2018-06-17 22:49:20 +0200

gabix gravatar image

Right click on the file in the file manager -> New.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-06-17 21:33:05 +0200

Seen: 178 times

Last updated: Jun 20 '18