We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Pivot table option: For empty cell show

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.

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.

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”);

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.