Free Support Forum - aspose.com

DisplayRightToLeft problem

Hi,


In the attached image, the sheet has the DisplayRightToLeft property set to true but it renders left to right.
Does SheetRender.toImage() honour this property or do I need to set something else?

This was produced using cells 7.3.1

Regards,
Henrick Blake
Hi,

Thanks for the file and code.

I can notice the issue as you have mentioned by running your code with your template file. It still renders LeftToRight (by default) for the output image.

Sample code:

// Instantiate a new workbook with excel file path
Workbook book = new Workbook("hebrew.xlsx");

// Create an object for ImageOptions
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();

// Set the format type of the image
imgOptions.setImageFormat(ImageFormat.getPng());

WorksheetCollection sheets = book.getWorksheets();
for (int i = 0; i < sheets.getCount(); i++)
{
// Get the next worksheet
Worksheet sheet = sheets.get(i);
System.out.println("\nSheet " + i + ": " + sheet.getName());

System.out.println("DisplayRightToLeft: " + sheet.getDisplayRightToLeft());

// Create a SheetRender object with respect to your desired sheet
SheetRender sr = new SheetRender(sheet, imgOptions);
for (int j = 0; j < sr.getPageCount(); j++)
{
// This needs to work too
// float[] wh = sr.getPageSize(0); // in points
// BufferedImage image = new BufferedImage((int) Math.ceil(wh[0] / 72f * 96f), (int) Math.ceil(wh[1] / 72f * 96f), BufferedImage.TYPE_INT_RGB);
// sr.toImage(0, image.createGraphics());

sr.toImage(j, "sheetimg_" + j + ".png");
}
}

I have logged a ticket with an id: CELLSJAVA-40312. We will look into your issue soon.

Thank you.

Hi,


Have you been able to make any progress on this issue? We have customers waiting for a fix.

Regards,
Henrick Blake

Hi,

Thanks for using Aspose.Cells for Java.

I am afraid, there is no update for you at the moment.

Normally, the easier issues are fixed in 2~3 working days. However, I
think, this issue is difficult, so it will take much more time. It could
take couple of weeks more.

However, I have added your comments against the issue id: CELLSJAVA-40312

Once this issue is fixed later or earlier, we will update you asap.

Hi,


Has there been any progress on this issue? We have customers waiting for a solution.

Regards,
Henrick Blake

Hi,


I am afraid, the issue is not resolved yet.

However, I have asked the relevant developer to provide an eta if possible. Once we have any update on it, we will let you know here.

We are sorry for any inconvenience caused!

Thank you.

Hi,


Has there been any progress on this issue yet?
It has been over 2 months now and we need a solution.

Regards,
Henrick Blake

Hi,

Thanks for your posting and using Aspose.Cells for Java.

I am afraid, there is no update for you. Probably, this issue is not going to be fixed any time sooner and it might take even more months.

However, I have added your comments against the issue id: CELLSJAVA-40312

Once, there is some update for you, we will let you know asap.

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


This message was posted using Notification2Forum from Downloads module by aspose.notifier.