Pivot table issues

Aspose.Cells Product Family
1

Dear Aspose Team,

I am facing few issues in the aspose pivot table and charts.Please find the below issue for your reference: Please let me know how to achieve this feature.

S.No Tittle Description
1 Pivot Table Issue :Opening Excel in MS Excel 2003 I tried to open the generated excel file from the "Open" button of the IE. The excel has been generated by reading an excel template. While I am clicking the Open button it is opening and at the same time it is popping up an error message saying "Cannot open Pivot Table Source file.....".But when I am saving the generated excel file using the "Save" button and opening it from the file from the saved path it is opening properly without any error. eg: we use the following line in our application: workbook.Save(fileName + ".xls", FileFormatType.Default,SaveType.OpenInExcel , System.Web.HttpContext.Current.Response); Note: Already receive the reference from your end on this, any update version on this? :http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/pivot-table-issue.html we have the requirement needs to open the excel file directly without saving in local machine.could you please advice on this.
2 Pivot Table Alignment
i) Pivot Header and data: font size,font type and bold
ii) Pivot Header and data alignment
iii) Pivot Header: Background color ,fore color
Refer the screen shot 2
3 Arrow line in Clustred column chart
How to achieve the arrow line in a column chart by dynamic way (starting and ending point of arrow line)
Refer the screen shot 3
4 100% stack Bar chart data label
How to achieve the data label in 100% stack bar chart
Refer the screen shot 4
5 Chart tittle i) how to achieve legend on top right of the chart
ii) line chart specif color for each series
Refer the screen shot 5

Thanks

Saravanan

2

Hi Saravanan,

Thanks for your inquiries with screenshots.

1) Please confirm that URL doest no append any params, it should be simple as test.aspx. And, please use workbook.Save(fileName + ".xls", FileFormatType.Default,SaveType.OpenInBrowser, System.Web.HttpContext.Current.Response);

2) We we have fixed some issues of reading style of the pivot table from the template file. Please try the new fix 4.7.1.22 (attached).

3), 4), 5) We do not support to operate the pivot chart now because we do not support to calculate the data of the pivot table,we could not know how many series there are in the chart.

Please post your sample project and template file(s), we will check whether we can fix some issues.

By the way, currently, we are working on reading the pivot from the template file and calculate the data of the pivot table.

Thank you.