Converting Excel containing macros to PDF

Aspose.Total Product Family
1

Hi,

  1. While I am converting excel to PDF were excel document contains macros, it converts all the hidden content which is used by macros. For example I have a excel document which contains 3 pages, when it converts to PDF total of 10 pages with macros contents are converted along with the original content.
  2. Excel document which contains numbers(1,2,....) in the first row are converted as # in the PDF document

Can you suggest us to resolve the above issue asap.

Thanks

2

Hi,


I am a representative of Aspose.Cells team.

Could you attach your input Excel file and output PDF file here, we will check your issue soon.

Thank you.
3

Hi,

I have attached the sample source excel and output PDF file here. Can you look into it and let us kown your feedback.

Thanks

4
Hi,

Thanks for the template file.

After an initial test, I can notice the following two issues when converting your template file to PDF:

1) MS Excel Print Preview has 2 pages but the output PDF (by Aspose.Cells) file has 3 pages.
2) The numbered list i.e., 1, 2, 3..... of Excel sheet is rendered as "#".

I have logged a ticket with an id: CELLSNET-40603. We will soon look into it.

Thank you.
5

Hi,

Thanks for you reply. When can we expect the solution.

Thanks

6

Hi,


You can expect a solution within 2-4 working days. If it is more complex, then it may take a week or two. Once we fix the issue, we will let you know here with a fix.

Thank you.
7

Hi,

Thanks for your reply. We are facing another issue on converting ECEL to PDF.

I have a dropdown box in my excel worksheet it contains Yes / No values. If either or is selected and kept blank. After converting to PDF the value for the empty dropdown is 0. Can you go through my attached excel file in my previous post. It has the dropdown with nothing is selected and kept blank.

Thanks

8

Hi,


I could not find drop downs in your template file in your previously attached archive in your previous post. Please attach the input Excel file and output PDF file here. Also attach a screen shot of the problematic areas comparing the original Excel file vs output PDF. I will check it soon.

Thank you.

9

Hi,

We are wating for you reply regarding issue posted above. As the error comes in production environment we cannot able to provide you the excel file.

Attached screen shot contains the conversion of EXCEL to PDF in three different ways.

The macro content in excel is not consistent in converting to PDF

Below are the different conversion of excel to PDF for a drop down box

  • The drop down in excel which contains macros is converted to PDF, but only the values in the drop down is displayed without any box.
  • Next is the same drop down is converted as the original in the excel file
  • Third is the after converting excel to pdf the drop values are dispalyed inside a rectangle box.

Please consider this as a high priority as we are nearing production deployment.

Thanks

10
Hi,

In fact it is hard for us to figure the issue out without the source file. If we are provided the source code file, we can compare the source and the resultant PDF file to get the difference for your mentioned issues.

You may check “Keep this post private” check box while replying to this post thus, now only you and Aspose Staff will be able to see your thread.
Alternately, you can also send us your sample file(s) via email. Please follow the below mentioned steps to send us the file via email.

1: Click the Contact button in the Post.
2: In the drop down list options click "Send Amjad Sahi an Email”.
3: Zip you file(s), attach the attachment and send it.
4: Once you have done it, kindly confirm us on this thread.

Thank you.
11

Hi,

Please find the attached document containing the sample source excel sheet for your reference.

1. The drop down in the section 6 is empty when converted to PDF value is 0.

2. All the drop downs are not consistent after conversion, refer my previous post image attachment

Please verify it and let us know your feedback.

Thanks

T Paramasivam

12

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v7.2.0.5 it works fine.

For your issues:

“1. The drop down in the section 6 is empty when converted to PDF value is 0.”
If you could open your template file into MS Excel and take the print preview of the sheet, you will notice the “0” value in the drop down, so Aspose.Cells for .NET provides the same look n feel of the sheet as taken in Excel’s print preview.

“2. All the drop downs are not consistent after conversion, refer my previous post image attachment”

I could not find the issue with v7.2.0.5, it works fine

13

Hi,

Thanks your comments on both the items,

I will try the second line item by downloading the v7.2.05 and let you know the feedback.

Thanks,

T Paramasivam

14

Hi,

We have looked into this issue and found that Aspose.Cells is working fine.

We convert workbook to 3 pages, because there are 2 worksheets needed to be converted

When using Microsoft Excel 2007, it also converts the whole workbook to pdf and there are also 3 pages

So if you want 2 pages, then you need to hide the second worksheet.