Pivot table output to pdf issue[Urgent]

Aspose.Cells Product Family
6

i will send sample application tomorrow but even when i send the sample output xls and try to create pdf it will work.

my issue is that i an sending my template and using aspose.cells filling data into sheet and also in pivot and now i try to save it as pdf that that the output is similar to protected view.
how can i remove this protection before saving the output to pdf?
7

I have also used now the same two liner code.


Dim new1 = New Aspose.Cells.Workbook(“C:\Reports70\temp\main.xlsx”)
new1.Save(“C:\Reports70\temp\out.pdf”)

But getting same wrong output using the latest aspose which you have used.
let me know what i am missing now.
see attached xlsx and output pdf.
one more thing to note that if i just open the main.xlsx file and save it by changing anyting then it works fine.
please let me know what is causing this issue.
please note that i am trying on vb.net
also please see why i am not getting email notifications once you post reply for me.
8

PLease see to this issue as its very urgent.

just take my xlsx file and without making any changes please try to get pdf output.
9

please update me with solution.

10

Hi,


Thanks for the template files.

After an initial test, I observed the issue by converting your new template Excel file (you attached) to PDF. The Pivot report data is not rendered fine in the output PDF. I have logged a ticket with an id “CELLSNET-41758” for your issue. We will look into your issue soon.

Once we have any update on it, we will let you know here.

Thank you.
11

Hi,

Please try the new fix/version: Aspose.Cells for .NET v7.5.0.1

Please write this sample code before saving:

book.Worksheets["mintrdet-78_1"].PivotTables[0].RefreshData();

book.Worksheets["mintrdet-78_1"].PivotTables[0].CalculateData();

Thank you.

12

Hi,


Thanks for the dll this fixed it but still there is some issues.
1. First cell word wrap is not working.
2. Bold in excel is coming at proper row but in pdf its coming on wrong row.
See attached output.


13

Hi,


I tested your case and converted your attached Excel file to PDF, it works fine, I don’t find the issues you mentioned. Please see the attached output file here.

Update: I have removed the attachment on user request.

Thank you.
14

HI Amjad,


Please try to create pdf output directly from the template and not just from the excel output.
i have attached the template which i have used. please try to convert this into pdf and you will see the issue.
again i am not getting emails for this replies and i have to keep checking the forum to see if any reply or solution added for this isuse or not.
please check why i am not getting email on my gmail account.
15

Hi,


Thanks for the template file.

We appreciate if you could create a sample console application (runnable) with your template Excel file (containing smart markers, you may use dynamic data table(s) to set it as data source for the markers for your data) using v7.5.0.x, zip it and post it here to reproduce the issue on our end. We will check your issue soon.

Thank you.
16

Hi Amjad,


unfortunately i have attached the excel files with client logo.
so please delete the files which you have attached in this reply and also other fiiles in other replies.
17

Hi,


Since your thread is already private, so no user (except you and Aspose staff members) can see or download the attachments in this thread.

Anyways, I have removed the attachments in my replies in this thread for your requirements.

Thank you.
18

Hi,


i have tested earlier on using Aspose.Cells7.5.0.1 and this issue was resolved but now i have used Aspose.Cells7.5.0.5 as this has another fixed for me.
Due to this new dll Aspose.Cells7.5.0.5 my old fix is still coming.
Check the attached output using both dlls.
Please ensure when you are fixing one issue not breaking other issue.

i have taken this new dll for my other post.
<a href="https://forum.aspose.com/t/92526

please treat this as urgent issue.

thanks
Rajendra
19

Hi,


Please attach your template Excel file, so that we could evaluate your issue by converting it to PDF with latest version/fix.

Thank you.
20

here is it.

but if it was working then how its broken now.
please check and let me know soon.
21

Hi,


Thanks for the template file.

Well, we cannot evaluate your issue properly based on your template file containing your markers. We appreciate if you could create a sample console application (runnable) with your template Excel file (containing smart markers, you may use some dynamic data table(s) to set it as data source for the markers for your data) using v7.5.0.x, zip it and post it here to reproduce the issue on our end. Also when you save to Excel file format, is it fine or not. Also give us some screen shots to highlight the problematic areas. All this will help to analyze your issue properly so we could fix it soon.

Thank you.
22

Hi Amjad,


Please see the attached screenshot with problematic Area. Few Cells are getting bold and few not.
Also Excel output is coming fine. Issue is with pdf output only.
Also as the issue was fixed earlier but broken with new aspose dll so i dont think i will be able to give sample application for the same.
Please review the attachments again and fix it.
23

Hi,


Thanks for the screen shot.

Please attach your MS Excel output here, it may help us to evaluate the issue accordingly.

Thank you.
24

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

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

Still this is not resolved.

I have again tried and found that even if I send the hard coded pivot
sheets.

When its getting combined using Aspose its having different fonts.


Dim myCombineExcel11 As New Aspose.Cells.Workbook("C:\Reports70\temp\test1.xlsx")

Dim myIndvidualExcelFile11 As New Aspose.Cells.Workbook("C:\Reports70\temp\test2.xlsx")

myCombineExcel11.Combine(myIndvidualExcelFile11)


If File.Exists("C:\Reports70\temp\test3.xlsx") Then File.Delete("C:\Reports70\temp\test3.xlsx")


If myCombineExcel11.Worksheets.Count > 0 Then

myCombineExcel11.Worksheets(0).IsSelected = True

For i As Int32 = 1 To myCombineExcel11.Worksheets.Count - 1

myCombineExcel11.Worksheets(i).IsSelected = False

Next

End If

myCombineExcel11.Save("C:\Reports70\temp\test3.xlsx")

in above code I am combining text1 and test2 and getting result as test3.

In test1 and test2 font size is coming 9 same like template but in test3 its coming 9 on the first tab and 11 on the second tab.

Hope this you can replicate. I am using 7.5.1.0

also make this post public now.