Setting Pivot Table Option - For Empty Cells Show

You can set different pivot table options using Aspose.Cells for Node.js via C++. One such option is “For empty cells show”. By setting this option, all empty cells in a pivot table are displayed as a specified string.

Setting Pivot Table Option in Microsoft Excel

To find and set this option in Microsoft Excel:

Select a pivot table and right-click.
Select PivotTable Options.
Select the Layout & Format tab.
Select the For empty cells show option and specify a string.

Setting Pivot Table Option Using Aspose.Cells for Node.js via C++

Aspose.Cells for Node.js via C++ provides the PivotTable.setDisplayNullString and PivotTable.setNullString properties for setting the “For empty cells show” pivot table option.

Formatting Pivot Table

Pivot Table and Source Data Customize Globalization Settings for Pivot Table with Node.js via C++

Setting Pivot Table Option - For Empty Cells Show

Setting Pivot Table Option in Microsoft Excel

Setting Pivot Table Option Using Aspose.Cells for Node.js via C++

Related Articles