Urgent excel2pdf conversion problem

dvirP · November 9, 2015, 4:09am

We are post production and came across the following bug. We are due in production which makes this an urgent matter for us.

We created the Excel file using OpenXml and when trying to convert it to PDF we get the following exception:

Test method Leumi.PdfUtilities.Infrastructure.Test.FileConverterTest.ExcelToPdfConversionTester.TestExcelToPdfConversionWithNullParam threw exception:

System.FormatException: Input string was not in a correct format.

Result StackTrace:

at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)

at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)

at ??.

.??(String , ??? )

at ??.

.(String , ??? )

at ?.?
.?(String , String )

at ?.?
.

?(

? )

at ?.?
.[1]?(

? )

at ?.?
.?(

? )

at ?.?
.Read(

? )

at ?.?
.?(‑
, String )

at ?.?
.

?()

at ?.?
.Read()

at ?.?
.(Workbook , LoadOptions )

at Aspose.Cells.Workbook.(Stream , LoadOptions , Boolean )

at Aspose.Cells.Workbook…ctor(Stream stream)

If the file is manually opened with Excel and re-saved from Excel then the conversion succeeds, this is of course not a viable option outside of development.

babar.raza · November 9, 2015, 4:26am

Hi Dvir,

Thank you for contacting Aspose support.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for .NET 8.6.1.2, and we are able to observe the said exception. At the moment we are not sure what could be causing this issue therefore this incident has been logged in our bug tracking system for thorough investigation. The ticket Id for your reference is CELLSNET-44050. You have to spare us some time before we can provide our analysis results as well as ETA for the fix. We will keep you posted with updates in this regard.

dvirP · November 11, 2015, 7:45am

Hi,

Any news? we need this ASAP

babar.raza · November 11, 2015, 8:04am

Hi Dvir,

I am afraid, we currently do not have any updates regarding the ticket CELLSNET-44050. In fact, it is currently pending of analysis and is in the queue with other priority tasks. That said, I have requested the concerned member of the product team to schedule the ticket for investigation at earliest possible. We will share the results here as soon as we have completed the analysis or have any updates for you.

babar.raza · November 12, 2015, 12:11am

Hi again,

This is to update you that the ticket logged earlier as CELLSNET-44050 has been fixed now. We will shortly provide the fix here after ensuring the quality of the build and incorporating other enhancements.

dvirP · November 16, 2015, 12:28am

Hi,

Thank you for the update.

Are there any news concerning the fix? It’s very urgent to us.

Thanks

shakeel.faiz · November 16, 2015, 1:24am

Hi,

Thanks for your posting and using Aspose.Cells.

Hopefully, we will provide you a fix on Wednesday or Friday of this week. If the fix is available earlier than this then we will update you on this thread.

shakeel.faiz · November 17, 2015, 3:00am

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells
for .NET v8.6.1.6 and let us know your feedback.

dvirP · November 18, 2015, 9:47am

the file now opens but the formulas do not calculate

am I missing somthing?

shakeel.faiz · November 18, 2015, 10:03am

Hi,

Thanks for your posting and using Aspose.Cells.

We have tested your issue with the following sample code using the latest version: Aspose.Cells
for .NET v8.6.1.6 and found that generated pdf is good. I have attached the output pdf for your reference. Please download it and let us know if there is any error inside it.

C#
string filePath = @“F:\Shak-Data-RW\Downloads\MessageExample±+Copy.xlsx”;

Workbook workbook = new Workbook(filePath);
workbook.CalculateFormula();

PdfSaveOptions opts = new PdfSaveOptions();
opts.OnePagePerSheet = true;

workbook.Save(filePath + “.out.pdf”, opts);

aspose.notifier · November 20, 2015, 3:26am

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

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

dvirP · November 22, 2015, 6:34am

Hi,

There is one more problem: while converting this excel to pdf, some rows of the chart legend are missing.

Please your check ASAP.

Thanks

shakeel.faiz · November 22, 2015, 9:30am

Hi,

Thanks for your feedback and using Aspose.Cells.

We have tested your issue with the latest version Aspose.Cells for .NET 8.6.2 and the output pdf looks fine. All the chart legends are good. Please download the output pdf and highlight your issues by adding comments inside it. You can also provide us screenshots highlighting the issues with red circles. It will help us look into your issue more precisely and we will update you asap.

C#
string filePath = @“D:\Downloads\MessageExample±+Copy.xlsx”;

Workbook workbook = new Workbook(filePath);
workbook.CalculateFormula();

PdfSaveOptions opts = new PdfSaveOptions();
opts.OnePagePerSheet = true;

workbook.Save(filePath + “.out.pdf”, opts);

dvirP · November 23, 2015, 2:58am

See the problem in the attached example (attached the source excel and result pdf)

babar.raza · November 23, 2015, 3:19am

Hi Dvir,

I am afraid, we are not able to pin point any problem in your generated PDF nor in the PDF we shared earlier in our previous response. That is the reason we asked you to share the PDF after highlighting the problematic areas along with code used for conversion so that we could focus on those areas to assist you further in this regard. If you like, you may also share snapshots of the highlighted problematic areas. Thank you for your understanding and cooperation.

dvirP · November 23, 2015, 3:55am

Attached a snapshot of the problem. The chart contains 5 colors, but the legend contains only 3 rows.

The legend in the source excel is OK (see the file I attached before).

shakeel.faiz · November 23, 2015, 4:05am

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to replicate this issue with the latest version: Aspose.Cells for .NET 8.6.2 and found that some entries of the chart legend get missing while saving to pdf as per your screenshot.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

CELLSNET-44079 - Some entries of the chart legend get missing while saving to pdf

shakeel.faiz · December 6, 2015, 9:10pm

Hi,

Thanks for using Aspose.Cells.

This is to inform you
that we have fixed your issue CELLSNET-44079 now. We will soon provide the fix after
performing QA and including other enhancements and fixes.

amjad.sahi · December 8, 2015, 1:56am

Hi,

Please try our latest version/fix: Aspose.Cells for .NET v8.6.2.4

We have fixed your issue “CELLSNET-44079” now.

Let us know your feedback.

Thank you

aspose.notifier · December 23, 2015, 2:42am

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

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