Recent

« previous next »
Pages: [1]

Author Topic: set zero values not to be displayed in the EXCEL template but disappear  (Read 370 times)

dodgex

  • New Member
  • *
  • Posts: 16
set zero values not to be displayed in the EXCEL template but disappear
« on: January 12, 2026, 03:11:02 am »
 I have set zero values not to be displayed in the EXCEL template. Why does this setting disappear when I open EXCEL?
Logged

wp

  • Hero Member
  • *****
  • Posts: 13350
Re: set zero values not to be displayed in the EXCEL template but disappear
« Reply #1 on: January 12, 2026, 06:25:48 pm »
FPSpreadsheet does not support the option to hide zero values (in my eyes this is a misleading feature: 0 is a valid value while a blank cell means: no data available here).
Logged

Thaddy

  • Hero Member
  • *****
  • Posts: 18729
  • To Europe: simply sell USA bonds: dollar collapses
Re: set zero values not to be displayed in the EXCEL template but disappear
« Reply #2 on: January 13, 2026, 01:18:38 pm »
@wp
I believe you can set the font color to the background color on a per-cell basis?
That would make it disappear?
Logged
If Europe sells their USA bonds the USD will collapse. Europe can affort that given average state debts. The USA can't affort that. Just an advice...

wp

  • Hero Member
  • *****
  • Posts: 13350
Re: set zero values not to be displayed in the EXCEL template but disappear
« Reply #3 on: January 13, 2026, 05:58:41 pm »
Sincerely? Simply selecting such a cell would change the backgroundcolor, and the "hidden" content would reappear.
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018