There's a hide-zeroes option that applies to the entire sheet.

If you don't want that, apply a format like 0.00;;0.00

Morten


On Thu, Jun 12, 2014 at 3:42 AM, Michael Uplawski
<[email protected]> wrote:
> Good morning,
>
> currently I apply a custom format to make zeros blend in with the
> background, by applying the same color to both.
>
> How do you do it?
>
> As there are spreadsheet-programs which offer a more direct approach to
> suppress zeros in a table, I may have overlooked the function in
> Gnumeric but currently cannot find it or am too dumb to find it. While
> writing this I do actually wonder, if it is worth the effort. Mayby I
> should argument that a change of the background-color or alternating
> background-colors should not oblige me to manipulate my
> format-definition in a special way.
>
> Thank you anyway,
>
> Michael
>
> --
> GnuPG/OpenPGP  4096R/3216CF02 2013-11-15 [expires: 2015-11-15]
> Michael Uplawski (privat) <[email protected]>
> sub   4096R/2751C550 2013-11-15 [expires: 2015-11-15]
>
>
> _______________________________________________
> gnumeric-list mailing list
> [email protected]
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
>
_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list

Reply via email to