We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Top and bottom borders for cells are gone

Aspose.Cells Product Family
#1
Export the active sheet to a html, the top and bottom borders for cells are gone.
The code and files are attached for your reference.
Please take a look and advise.
Thanks,
final String dataDir = "C:\\development\\";
final Workbook workbook = new Workbook(dataDir + "sampleBorder.xlsx");
final Worksheet sourceSheet = workbook.getWorksheets().get("sheet1");
if (sourceSheet != null) {
  workbook.getWorksheets().setActiveSheetIndex(sourceSheet.getIndex());
  final HtmlSaveOptions options = new HtmlSaveOptions();
  options.setExportActiveWorksheetOnly(true);
  workbook.save("C:\\development\\sampleBorder.html", options);
}
#2

Hi,


Thanks for your posting and using Aspose.Cells.

We were able to observe this issue and logged it in our database for a fix. Top and bottom borders of the cells are gone when your sample excel file is converted to html.

This issue has been logged as

  • CELLSJAVA-42156 - Top and bottom borders of cells are gone while converting to HTML

I have tested this issue with the latest version: Aspose.Cells for Java 17.1.0 using the following code and also attached the output html for a reference.

Java
String filePath = dirPath + “sampleBorder.xlsx”;

Workbook wb = new Workbook(filePath);
wb.save(filePath + “_out.html”);


#3

Hi,

Thanks for using Aspose.Cells.

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

#4

The issues you have found earlier (filed as CELLSJAVA-42156) have been fixed in Aspose.Cells for Java 17.2.0.

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

Thanks a lot. It is working fine now.

#6

Hi,


Thanks for your feedback.

Good to know that your issue is sorted out by the new fix/version. Feel free to write us back if you have further comments or questions, we will be happy to assist you soon.

Thank you.
#7

Found an issue. Please see the attached image

  • The top and bottom borders on the table are not rendered
  • There is an unexpected border in front of the date (2017-01-13)

Thanks

#8

Hi,


Thanks for your posting and using Aspose.Cells.

We were able to observe this issue and re-opened the ticket. We will look into it and fix the issue if possible. Once, there is some fix or other update for you, we will let you know asap.

#9

Thanks for your feedback.

I got another minor issue. Please see the attached image.

I can see the default vertical cell borders in Excel which are highlighted on the attached image (the left part); However, the exported HTML (the right part) doesn’t show the vertical cell borders. I am not sure that is an expected behavior or a bug.

Please advise, thanks.

#10

Hi again,


Please note that the mentioned behaviour is correct because your sample does not have the borders set for the cells in rows 5, 7, 9, 11 & 13. Moreover, if you manually convert the sample to HTML while using Excel application, you will get the same result as of Aspose.Cells APIs.
#11

Hi,


Thanks for using Aspose.Cells.

We have looked into this issue further and found that for the unexpected border in front of the date, it is not an issue. In fact, the border does exist for the cell, please save the file manually by ms excel and you can see the border in the generated html file too.

For the missing borders of the table’s header and total rows, we are working on it and will give a fix for it later.

#12

Thanks for you response.

#13
Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix: Aspose.Cells for Java v17.02.8 and let us know your feedback.

#14

Thank you! It is working good now.