- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
-
Features
- Workbook
- Worksheet
- Rows and Columns
- Headers
-
Cells
- Work with Cells
- Cell Types
- Cell Format
- Cell States
- Cell Range
- Get Dirty Status
- Cell Buttons
- Cell Dropdowns
- Cell Comments
- Hyperlink
- Auto Merge Cells
- AutoFit
- Auto Fill Data
- Mask Input
- Shrink to Fit
- Cell Overflow
- Ellipsis or Tips for Cell Overflow
- Cell Alignment and Indentation
- Cell Padding and Label Styles
- Cell Span
- Cell Tags
- Styles
- Cell Decoration
- Cell Colors
- Borders, Gridlines and Diagonal Lines
- Quote Prefix
- Insert Cut or Copied Cells
- Rotate Text In Cells
- Vertical Text Direction
- Text Decoration
- Rich Text
- Wrap Text
- Drag and Drop
- Drag and Merge
- Edit Mode Always
- Watermark
-
Display Zero as Blank
- IME Mode
- Pattern Fill and Gradient Fill
- Paste Options
- Data Binding
- TableSheet
- GanttSheet
- JSON Schema with SpreadJS
- SpreadJS File Format
- Data Validation
- Conditional Formatting
- Sort
- Group
- Formulas
- Serialization
- Keyboard Actions
- Shapes
- Form Controls
- Floating Objects
- Barcodes
- Charts
- Sparklines
- Tables
- Pivot Table
- Slicer
- Theme
- Culture
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
Display Zero as Blank
SpreadJS, by default, displays zero values as "0" in the number type cells.
However, you can display zero values as blank by setting the showZeros option of the worksheet to false.
The following sample code shows how to use the showZeros option to display zero values as blank cells in a worksheet.
sheet.options.showZeros = false;
// input "=1-1" in cell A1, the A1 cell display blank.This option only impacts the display value of a cell and not the actual value. Hence, there is no change in any calculations or charts that involve zero-value cells.
On the contrary, the filter dialog uses display values and hence, shows blank when the showZeros option is set to false.
Similarly, in watermark cells, SpreadJS displays a watermark when a zero value is displayed as blank.
Note: The following cases apply when showZeros option is false.
String "0" is not displayed as blank. Option is applicable to number type cells only.
Cell displays "0" if its value is not 0, but the format result is 0. For example, 0.01 with format #,##0.
The OADATE(0), that is, sheet.setValue(0,0,new Date(1899, 11, 30)); displays as blank.
Zero values display as it is when showFormulas is set to true.
Using Designer
You can also enable this feature through the SpreadJS Designer by checking the "Show Zero Value Cells" checkbox in the Sheet Settings dialog.
