Double read of Carriage Return Line Feeds

Aspose.Cells Product Family
1

Hi,

xlsLic.SetLicense(“Aspose.Total.lic”);

Workbook wb = new Workbook(“Example vbCrLF and vbCR.xlsx”);

string resultA2 = wb.Worksheets[0].Cells[“A2”].StringValue;
string resultA8 = wb.Worksheets[0].Cells[“A8”].StringValue;

Int32 resultA2Length = resultA2.Length;
Int32 resultA8Length = resultA2.Length;

Please compare the length of the strings above with the length in Excel sheet.

It seems that Chr(10) will be read out as CarriageReturnLinefeed ( Chr(13)&Chr(10)) and not as single Chr(10).

But that means a Chr(13)&Chr(10) in Excel will read out as Chr(13)&Chr(13)&Chr(10).

Kind regards,


Guido

2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing your sample code with the latest version: Aspose.Cells
for .NET v8.5.2.2. There are double carriage return characters in the read string.

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-43876 - Double read of Carriage Return Line Feeds

3

Hi,


This is to inform you that we have fixed your issue logged earlier as “CELLSNET-43876”. We will soon provide the fix after performing QA and incorporating other enhancements and fixes.

Once we have the fix for public use, we will let you know here.

Thank you.
4

Hi,

Thanks for your using Aspose.Cells.

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

5

Hi,


Thanks for your feedback.

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

Thank you.
6

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

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