When exporting html, the length of the data bar is shorter than that in excel

Aspose.Cells Product Family
, ,
1

Problem 1:
When I export html, the length of the data bar is shorter than that in excel (the data bar is in the G7 cell and it is set to display only the data bar).
The databar in excel: databar_excel.png (7.7 KB)
The databar in html: databar_html.png (1.6 KB)
code show as below：

HtmlSaveOptions options = new HtmlSaveOptions();
options.getExportActiveWorksheetOnly();
	
Workbook workbook = new Workbook(new FileInputStream("test.xlsx"));
workbook.save("test.html", options);

Problem 2:
Also set the conditional format in the G7 cell (remove the only display data bar setting), use DataBar.toImage to get the data bar picture, and it is found that the obtained picture is blank. But there are data bars in excel。
databar.png (87 Bytes)

code show as below：

Workbook workbook = new Workbook(new FileInputStream("test2.xlsx"));
Worksheet worksheet = workbook.getWorksheets().get(0);
Cell cell = worksheet.getCells().get("G7");
DataBar dataBar = cell.getConditionalFormattingResult().getConditionalFormattingDataBar();
ImageOrPrintOptions imgOpts = new ImageOrPrintOptions();
imgOpts.setImageFormat(ImageFormat.getPng());
byte[] data = dataBar.toImage(cell, imgOpts);
// save
try (FileOutputStream out = new FileOutputStream("databar.png");) {
    out.write(data);
}

The excel file in the example：excel_files.zip (51.1 KB)

2

@zhangqi2021,
This issue is reproduced and logged in our database for further analysis. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSJAVA-43635 - When exporting html, the length of the data bar is shorter than that in excel

3

Looking forward to your good news

4

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

5

@zhangqi2021,

Please notice, we logged a separate ticket with an id “CELLSJAVA-43689” for the issue. We will also look into it to figure it out soon.

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

6

@zhangqi2021,
This is to inform you that we have fixed your issue (logged earlier as “CELLSJAVA-43635”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

7

@zhangqi2021,
This is to inform you that we have fixed your issue Id: CELLSJAVA-43689 now. We will provide you the fixed version within the next few days after performing QA and incorporating other enhancements and fixes.

8

@zhangqi2021,
Please try our latest version/fix: Aspose.Cells for Java v21.8.2 (attached)
aspose-cells-21.8.2-java.zip (7.4 MB)

Your issue should be fixed now.
Let us know your feedback.

9

@zhangqi2021

The “Problem 2” issue logged as CELLSJAVA-43689 is also fixed in v21.8.2

10

The issues you have found earlier (filed as CELLSJAVA-43635,CELLSJAVA-43689) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi