Recent

« previous next »
Pages: [1]

Author Topic: set zero values not to be displayed in the EXCEL template but disappear  (Read 435 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: 13433
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: 18797
  • Glad to be alive.
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
Recovered from removal of tumor in tongue following tongue reconstruction with a part from my leg.

wp

  • Hero Member
  • *****
  • Posts: 13433
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