I’m looking for the option in your API for setting the property “For empty cell show”.
The screenshot is attached.
Could you please let me know whether it’s supported.
Thanks for the screen shot.
I think your requested API for the feature/option (Pivot table’s option: “For empty cells show”) is not supported at the moment. For the sake of investigation, I have logged a ticket with an id “CELLSNET-42117” for your requirements/issue. We will look into it to figure it out soon.
Thanks for using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells
for .NET v184.108.40.206.
Please see the following sample code for your reference.
Workbook wb = new Workbook(“a.xlsx”);
PivotTable pt = wb.Worksheets.PivotTables;
//indicating if or not display the empty cell value
pt.DisplayNullString = true;
//indicating the null string
pt.NullString = “bb”;
pt.RefreshDataOnOpeningFile = false;
wb.Save(dir + “out.xlsx”);