Ask Your Question
0

Formatting calc sheets headers & Footers and Zero values [closed]

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

BigAl gravatar image

updated 2020-07-22 13:18:50 +0200

Alex Kemp gravatar image

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-22 13:19:37.751326

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

Question Tools

1 follower

Stats

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

Seen: 239 times

Last updated: Jun 01 '18