Recent

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

dodgex

  • New Member
  • *
  • Posts: 16
 I have set zero values not to be displayed in the EXCEL template. Why does this setting disappear when I open EXCEL?

wp

  • Hero Member
  • *****
  • Posts: 13350
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).

Thaddy

  • Hero Member
  • *****
  • Posts: 18729
  • To Europe: simply sell USA bonds: dollar collapses
@wp
I believe you can set the font color to the background color on a per-cell basis?
That would make it disappear?
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
Sincerely? Simply selecting such a cell would change the backgroundcolor, and the "hidden" content would reappear.

 

TinyPortal © 2005-2018