We recently (summer 2023) purchased a license for Aspose.Cells for Java, and currently using Aspose.Cells for Java version 23.10, and running into an issue with generating screenshot from Excel where sparklines used, in particular with z-index (in Excel sparklines would appear behind text, but in generated image it would be in a foreground), want to check if you might be able to help us.
ImageOrPrint options we’re using to generate an image
// set print options
final ImageOrPrintOptions options = new ImageOrPrintOptions();
options.setOnePagePerSheet(true);
options.setImageType(ImageType.SVG);
options.setHorizontalResolution(1000);
options.setVerticalResolution(900);
options.setTransparent(true);
options.setRenderingHint(RenderingHints.KEY_TEXT_ANTIALIASING, RenderingHints.VALUE_TEXT_ANTIALIAS_ON);
We want to check if we might have some mis-configuration on our part, maybe within our ImageOrPrintOptions, or if it might be a known issue and if there might be an ETA for it, thank you.
@dmitryfAtVena
By using sample files for testing, we can reproduce the issue. A z-index issue was found when generating images.
Test code as follows:
Workbook wb = new Workbook(filePath + "aspose-question-for-sparkline.xlsx");
// set print options
final ImageOrPrintOptions options = new ImageOrPrintOptions();
options.setOnePagePerSheet(true);
options.setImageType(ImageType.SVG);
options.setHorizontalResolution(1000);
options.setVerticalResolution(900);
options.setTransparent(true);
options.setRenderingHint(RenderingHints.KEY_TEXT_ANTIALIASING, RenderingHints.VALUE_TEXT_ANTIALIAS_ON);
SheetRender render = new SheetRender(wb.getWorksheets().get(0), options);
render.toImage(0, filePath + "out_java.svg");
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSJAVA-45706
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
We are pleased to inform you that your issue has been resolved. This fix will be included in the upcoming release of Aspose.Cells v23.12, scheduled for release in the second week of December. You will be notified when a new version is published.