Can you advise how I set this? Please do not just point me to the documentation, I have searched there already.
I need an example of the code to use please, as I cannot see any property in a PivotTable or a PivotTableCollection that allows me to set this!
For example:
// Create Pivot Table
int index = pivotTables.Add(sourceRange, upperLeftCellLocation, myPivotTableName);
PivotTable pivotTable = pivotTables[index];
pivotTable.RowGrand = true;
// Add column
pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Row, 1);
//Add data fields
pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Data, 2);
pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Data, 3);
//Add all data fields as a column field
pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Column, pivotTable.DataField);
pivotTable.??? = PivotTableStyleType.PivotTableStyleLight3;
or
pivotTables.??? = PivotTableStyleType.PivotTableStyleLight3;
Or do I have to set it on a field by field basis??
Many thanks
Hi,
I am so sorry to tell you that currently our product is not supporting this feature. I have logged you requirement with an id CELLSNET-22224. We will work on this request and as soon as this feature is implemented we will let you know accordingly.
Thanks for being a valuable customer for us, please let us know in case of any further support.
Best Regards,
<!–[if gte mso 10]>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman","serif";}
<![endif]–><span style=“font-size: 10pt; font-family: “Microsoft YaHei”,“sans-serif”;”>Hi,
Please try the attached version v5.2.0.3, the feature is supported in it.
Sample Code:
pivotTable.PivotTableStyleType = PivotTableStyleType.PivotTableStyleMedium7;
Thank you.
Worked a treat. Thank you.
The issues you have found earlier (filed as 22224) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.