Pivot table option: For empty cell show

Aspose.Cells Product Family
1

Hello,


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.

2

Hi,


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.

Thank you.
3

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells
for .NET v8.0.2.1.

Please see the following sample code for your reference.

C#


Workbook wb = new Workbook(“a.xlsx”);

PivotTable pt = wb.Worksheets[0].PivotTables[0];

//indicating if or not display the empty cell value

pt.DisplayNullString = true;

//indicating the null string

pt.NullString = “bb”;

pt.CalculateData();

pt.RefreshDataOnOpeningFile = false;

wb.Save(dir + “out.xlsx”);


4

The issues you have found earlier (filed as CELLSNET-42117) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.