Ask Your Question

Cell links in CALC headers and footers

asked 2018-11-30 22:00:54 +0100

Nemo2000 gravatar image

updated 2020-10-12 00:15:43 +0100

Alex Kemp gravatar image

My CALC spreadsheet has several 'sheets'. I use the same format of Header and Footer for each sheet when the file is printed. The first sheet has cells which hold the Issue Number and Issue Date.

How can I insert this information into the Header or Footer for each sheet automatically, by linking to the relevant cells? At the moment I have to change it manually on each sheet each time that I update and reprint the file.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-12-01 01:16:16 +0100

m.a.riosv gravatar image

There is no possible to do it (I remember it was in 123).

Maybe be you can solve the situation with Menu/Format/Print ranges/Edit/Rows to repeat.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-11-30 22:00:54 +0100

Seen: 256 times

Last updated: Dec 01 '18