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.
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
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;