Cellcontent-Bugs in converting file from xls to xlsx

kochchr · August 31, 2018, 11:57am

There are some critical bugs in converting date-fields and also in some number-fields.
As you can see in the pictures, I used your latest Aspose.Cells for .NET Version (18.8) in Visual Studio 2015 Professional (Version 14.0.25431.01 Update 3).
The affected area is highlighted.
123.jpg (382.2 KB)
124.png (74.1 KB)

I could send you the origin file as well as the converted file for further analyses. …just send me a short message and I will do that.

This is the code I´m using for the conversion:
Private Sub xlsconvertaspose(filewithsource As String)
Dim workbook As Workbook = New Workbook(filewithsource)
Dim sheet As Worksheet = workbook.Worksheets.Item(0)
sheet.AutoFitColumns()
workbook.Save(“C:\Users\xxx\Desktop\xlsalt\converted.xlsx”, SaveFormat.Xlsx)
End Sub

amjad.sahi · August 31, 2018, 2:25pm

@kochchr,

Thanks for the sample code and screenshots.

Please provide your template Excel file and output Excel file (you may zip the files prior attaching), we will check it soon.

kochchr · September 3, 2018, 2:58pm

aspose.zip (281 KB)

ahsaniqbalsidiqui · September 3, 2018, 5:58pm

@kochchr,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.
This issue has been logged as

CELLSNET-46322 - Issues in number and date values while calling the AutoFitColumns()

kochchr · September 4, 2018, 7:42am

Could you please give me further information at what time the bug (Release version… 18.9?) will be fixed? I need this information to order a licence. Release Notes - 2018|Documentation
Thank you and BR.

amjad.sahi · September 4, 2018, 8:25am

@kochchr,

Thanks for considering Aspose.

As we logged the ticket some hours ago, so could you spare us a little time (3-5 days or so) for complete evaluation and investigation for your issue. If it is not much complex, you should be receiving the hot fix before the end of next week or even before it. If the issue is complex, it might take a couple of weeks. We do provide hotfixes in the forums for the users, so they don’t have to wait too long for the official releases (on Nuget and Downloads sections). The hot fixes are fully tested (having complete functionality (full fledged)) and are ready for production.

Moreover, we do publish official releases once in a month. The next official release (Aspose.Cells for .NET v18.9) is due in the third or fourth week of September 2018.

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

amjad.sahi · September 5, 2018, 8:32am

@kochchr,

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

ahsaniqbalsidiqui · September 5, 2018, 8:40am

@kochchr,

Please try our latest version/fix: Aspose.Cells for .NET v18.8.5:

Your issue should be fixed in it.

Let us know your feedback.

kochchr · September 5, 2018, 1:25pm

DropBox-Link doesn´t work / Can´t download zip-file.

This site can’t be reached

The webpage at Dropbox - Aspose.Cells For .NET 18.8.5.zip - Simplify your life might be temporarily down or it may have moved permanently to a new web address.

ERR_TUNNEL_CONNECTION_FAILED

8.png (23.7 KB)

ahsaniqbalsidiqui · September 5, 2018, 2:01pm

@kochchr,

I have just tried and it is working fine. However I have attached it here for your reference:

Aspose.Cells18.8.5 For .Net4.0.Zip (4.6 MB)
Aspose.Cells18.8.5 For .Net2_AuthenticodeSigned.Zip (4.6 MB)

kochchr · September 7, 2018, 2:22pm

Hi. It works fine Thank you for your fast Bugfix and support. We will order your dll. BR

amjad.sahi · September 7, 2018, 2:39pm

@kochchr,

Thanks for considering Aspose

Good to know that the new fix figures out your issue now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

kochchr · September 10, 2018, 8:05am

Hi,
unfortunately there is another bug in converting number fields.
Could you please have a look at the files which I have attached below?
Thank you and BR
Christian
Capture.png (165.4 KB)
excel-files.zip (11.6 KB)

amjad.sahi · September 10, 2018, 9:25am

@kochchr,

Thanks for the template file and screenshot.

After an initial test, I observed the issue as the user has mentioned by saving your so called XLS file (which is actually an HTML file) to XLSX file format (I used your original code). I found an issue in number field while calling the Worksheet.AutoFitColumns(). I have logged a separate ticket with an id “CELLSNET-46330” for your issue. We will look into it soon.

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

aspose.notifier · September 17, 2018, 10:26am

The issues you have found earlier (filed as CELLSNET-46322) have been fixed in Aspose.Cells for .NET v18.9. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi