Sheet not rendering correctly using SheetRender.toImage()

Aspose.Cells Product Family
1

Hi,


We have a sheet where gradient fills are not being correctly rendered.
Also, there is a text box that doesn’t render.

I’ve attached the affected sheet along with screenshots and code snippet:

Workbook book = new Workbook(“c:\temp\weight.xls”);

ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.setImageFormat(ImageFormat.getPng());
imgOptions.setVerticalResolution(200);
imgOptions.setHorizontalResolution(200);

WorksheetCollection sheets = book.getWorksheets();
for (int i = 0; i < sheets.getCount(); i++)
{
Worksheet sheet = sheets.get(i);
SheetRender sr = new SheetRender(sheet, imgOptions);
for (int j = 0; j < sr.getPageCount(); j++)
{
sr.toImage(j, “c:\temp\weight_” + j + “.png”);
}
}


This was reproduced using cells java version 8.4.0


2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue. Normally such issues are resolved by calling Workbook.calculateFormula() method but it is also throwing exception so this issue could not be resolved.

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

  • CELLSJAVA-41250 - Sheet not rendering correctly using SheetRender.toImage()

3

Hi,


Has there been any progress on this issue?
4

Hi,

Thanks for your posting and using Aspose.Cells.

We are afraid, there is no update for you regarding this issue. However, we have logged your comment in our database against this issue and requested the product team to provide some fix or ETA for this issue. Once, there is some news for you, we will let you know asap.

I have checked this issue with the latest version: Aspose.Cells
for Java v8.5.2.3 but the issue is still present there. I have also attached the screenshot highlighting this issue for a reference.

5

Hi,

Thanks for using Aspose.Cells.

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

6

Hi,

Thanks for using Aspose.Cells.

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

The data bar gradient fills issue is fixed.

For a text box is not rendered, it is not a issue. The textbox is not printable (see highlight in the attachment).

You can also check in Excel’s PrintPreview, the textbox is not printed.

7

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

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

Hi,


Thanks for the fix. This looks to be working OK now
9

Hi,


Good to know that your issue is figured out by the new version/fix. 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.

Thank you.
10

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan