Setting Pivot Table Option - For Empty Cells Show with Golang via C++

You can set different pivot table options using Aspose.Cells. 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, then 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

Aspose.Cells provides the PivotTable.GetDisplayNullString() and PivotTable.GetNullString() properties to set the “For empty cells show” pivot table option.

Formatting Pivot Table

Pivot Table and Source Data with Golang via C++ Customize Globalization Settings for Pivot Table with Golang via C++

Setting Pivot Table Option - For Empty Cells Show with Golang via C++

Setting Pivot Table Option in Microsoft Excel

Setting Pivot Table Option Using Aspose.Cells

Related Articles