Ask Your Question
0

Formatting calc sheets headers & Footers and Zero values

asked 2017-04-04 15:15:57 +0200

BigAl gravatar image

updated 2017-11-14 16:55:14 +0200

Linux Mint 18.1 Cinnamon 64 bit

Version: 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial1 CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; Locale: en-GB (en_GB.UTF-8); Calc: group2

I have a Calc spreadsheet that has 7 different tabs. I want each sheet to have its own header and footer rather than them all being the same, as they are at present. I also want some of the sheets to display zero values while the other do not.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-05-18 10:41:08 +0200

hjek gravatar image

updated 2018-06-01 18:19:41 +0200

I want each sheet to have its own header and footer

For two sheets to have different headers and footers those two sheets each need their own page style.

I also want some of the sheets to display zero values while the other do not.

To hide zeroes, format the cells so that their number format code is 0;-0;. Read more about number format codes here.

Edit: Fixed format code. Thanks @erAck

edit flag offensive delete link more

Comments

That format code should include a minus sign in the second subformat, otherwise negative numbers are displayed without and look like positive numbers, so 0;-0;

erAck gravatar imageerAck ( 2018-06-01 18:11:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-04 15:15:57 +0200

Seen: 121 times

Last updated: Jun 01