Show zero values as blank cell

XMLWordPrintable

    • Type: New Feature
    • Resolution: Done
    • Priority: Normal
    • 5.4.0
    • Affects Version/s: None
    • Component/s: None
    • None
    • None

      Requirements

      When a cell value is 0, show it as a blank cell. Excel supports this option in View options:

      Workaround

      set a text's color as its background color when it's 0.

        1. zeroCell.jpg
          zeroCell.jpg
          17 kB
        2. zeroAsBlank.jpg
          zeroAsBlank.jpg
          25 kB

            Assignee:
            wenninghsu
            Reporter:
            hawk
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: