HTML Tags are terminating a cells contents

rileyja · January 4, 2017, 1:27pm

The attached document will not properly convert to XLSX.

the cell “Abstract Text Field 1” cuts off at "(MetS)."

the following tag seems to break it. I do not know why. The code below is what I am doing at the simplest to try to get this to work with no success.

var options = new HTMLLoadOptions(LoadFormat.Html);

var wb = new Workbook(fileNameIn, options);

var ws = wb.Worksheets[0];

ws.Cells.StandardHeight = 16;

ws.Cells.Style.HorizontalAlignment = TextAlignmentType.Top;

var style = ws.Cells.Rows[1].Style;

style.Font.IsBold = true;

var sf = new StyleFlag();

sf.FontBold = true;

ws.Cells.Rows[0].ApplyStyle(style,sf );

wb.Save(fileNameOut, SaveFormat.Xlsx);

babar.raza · January 4, 2017, 10:51pm

Hi Jason,

Thank you for sharing the sample.

I have evaluated the presented scenario while using the following piece of code against the latest available version of Aspose.Cells for .NET 16.12.5 (attached). I am afraid, I am not able to see any problem with the contents of the cell F2. Please review the attached resultant spreadsheet and share snapshots of the problem, if any.

rileyja · January 5, 2017, 7:01am

Actually you are seeing the error. in the original attachment (report.xls) cell F2 has FAR More data. open it in Excel and double click the cell to see all the data.

the last line of that cell is (Conclusions:Skipping breakfast has no discernable effect on body weight, most of nutrients intake and metabolic parameters.)

if you look at the report.xls in a text editor you’ll see it is an HTML file, rename it to .html and open it in a browser to see the expected results.

Thanks for looking at this. in the mean time I have written a regular expression to strip all HTML from the cells but I really need Carriage returns and BOLD

babar.raza · January 5, 2017, 7:22am

Hi Jason,

Thank you for the clarification. Let me share what I understand, just to confirm that we are on same page. Please correct me if my understanding of this scenario is not correct. I have checked the input sample (report.xls) in Excel application, and I can see 4 lines of data in cell F2 (also shown in attached snapshot). However, when converting this file to XLSX, only one line of data is retained and all others are trimmed. I have logged this incident as CELLSNET-45033 in our bug tracking system for further analysis and correction. Please spare us little time to properly evaluate the case and revert back with updates in this regard.

rileyja · January 5, 2017, 7:28am

Yes, you are correct. I really need all lines of data. it seems to fail on
tags

Kindest Regards,

Jason

babar.raza · January 5, 2017, 8:02am

Hi Jason,

Thank you for the confirmation. I have shared your concerns at the aforementioned ticket. As soon as we receive any updates from the product team, we will post here for your kind reference.

rileyja · January 5, 2017, 8:16am

actually its a

tag that breaks the cell.

another note.

if my HTML string has THIS IS SOME TEST THIS IS MORE TEXT

the entire cell is converted to bold, not just the text inside the strong tag.

same goes for hyperlines visitfoo.com MORE TEXT

the entire cell is converted to a hyper link, not just inside the tag.

I am not sure how to deal with this.

babar.raza · January 6, 2017, 12:21am

Hi Jason,

Thank you for writing back. I have updated the comments on the ticket CELLSNET-45033 for product team’s review. Regarding your recently shared concerns, please check the following details.

I have tested the scenario related to the tag, and I am able to notice the said problem, that is; entire cell contents become bold when part of it is in between tags. I have raised this incident as CELLSNET-45035 in our bug tracking system for further investigation and correction.
Regarding your concerns about the tags, please note, it is the behaviour of Excel application that when some part of the cell contents are hyperlink then whole cells is considered to be hyperlink. You can test the case by importing the attached HTML file in Excel application. That said, I have noticed that Aspose.Cells APIs trim the contents after the tag which is inconsistent with Excel behaviour, therefore I have logged another ticket with Id CELLSNET-45036 to look further into the issue where cell contents after tag are getting trimmed while importing HTML and converting to XLSX.

rileyja · January 6, 2017, 9:05am

Thank you. If I notice any other inconsistencies with imports I will post them.

babar.raza · January 7, 2017, 2:26am

Hi Jason,

Thank you for writing back. We humbly request you to post distinct problems in separate threads for easy management and tracking of your requests.

amjad.sahi · January 19, 2017, 3:22am

Hi,

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

Once the fix is available for public use, we will share the Download link here.

Thank you.

shakeel.faiz · January 19, 2017, 3:25am

Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.1.4 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.1.4 (.NET 4.0) compiled in .NET Framework 4.0.

and let us know your feedback.

It fixes the following issues

CELLSNET-45036 - Contents after tag are trimmed while importing HTML and converting to XLSX
CELLSNET-45035 - Entire cell contents become bold when part of it is in between tags

shakeel.faiz · February 4, 2017, 3:53am

Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.1.8 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.1.8 (.NET 4.0) compiled in .NET Framework 4.0.

and let us know your feedback.

It fixes the following issue.

CELLSNET-45033 - Cell contents are trimmed while importing HTML

aspose.notifier · February 16, 2017, 7:18am

The issues you have found earlier (filed as CELLSNET-45036;CELLSNET-45035;CELLSNET-45033) have been fixed in Aspose.Cells for .NET 17.2.0.

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