Hi,
Hi,
Hi Amjad Sahi,
I have tried to use the fix/version you have linked, however I could no compile that fix/version.
Thank you
Hi,
Hi,
The project we're using to do the evaluation is using .Net Framework 3.5 using Aspose.Cells. I have attached the evaluation project as it includes codes to simulate data passed into Aspose.Cells Objects.
NOTE: The code lines used to save the xlsx file and and convert it into a pdf file are between lines 226 - 265 in the "Form1.cs" class.
Also attached are the template xlsx file (Templateexcel3Rowsplu formula.xlsx), the output xlsx file (testFile3.xlsx), and the output pdf file (testFile3.pdf ).
Hi,
Hi,
I'm sorry, I wasn't clear with the problem we were having; I have attached a screenshot highlighting the problem we're getting when we try to convert an xlsx file (created using aspose) into a pdf file without having to open the xlsx file in excel first (The code for saving the xlsx file is in the same method as the code for saving the pdf file).
Additional question: Is there something we're missing/wrong on the way we are saving the xlsx file?
Thank you
Hi,
Amjad Sahi:Also, I did try to use PivotTable.ChangeDataSource method if it works and the pivot charts are updated accordingly, but it does not help much.I have unfortunately tried the changes you suggested, however I couldnt get the pivot chart to update accordingly, I'm assuming you meant the other chart updated accordingly (the normal chart). The top chart from the template is just a normal chart, but the bottom one is a pivot chart (circled red in my last screenshot).Thank you for you help, we hope there will be an update to this in time.
Hi,
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
Please download and try this fix: Aspose.Cells for .NET v7.4.1.1.
Please add this sample code before saving using the latest aspose version
7.4.1.1:
ws.Charts[1].RefreshPivotData();//add
this code
wb.Save(sDialog.FileName,
SaveFormat.Xlsx);//"D:\\Spearson\\Desktop\\New folder\\Result.xlsx",
SaveFormat.Xlsx);
Hi,
I have just tried the fix, it's doing what it's meant to do, which is fantastic. My boss will be happy to know this.
However is another problem found. I will just open different thread for it.
Thank you,
Sandie
Hi,
The issues you have found earlier (filed as CELLSNET-41432) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.