Right to Left Problem in Saving as Html or MHT

Aspose.Cells Product Family
1

Hi,

I am using Aspose.Cells 7.4.3 to create excel files and convert them to HTML or PDF. But when the direction of a sheet is right to left, PDF file looks OK but html file shows the table as Left to right. Please help me to solve the problem or if it is a Bug please fix it. this is my sample code:

Workbook wb = new Workbook();

Worksheet sheet = wb.Worksheets[0];
sheet.DisplayRightToLeft = true;
Cell cell = sheet.Cells[“A1”];

cell.PutValue(“Hello World”);

wb.Save(“d:\MyBook.xls”, SaveFormat.Excel97To2003); //OK
wb.Save(“d:\MyBook.pdf”, SaveFormat.Pdf); //OK
wb.Save(“d:\MyBook.mht”, SaveFormat.MHtml); //Shows LTR Table
2

Is there anyone to help me solve this problem?

3
Hi,

Thanks for providing us sample code.

I have tested your code to convert to MHT file format, it works fine, see the attached screen shot for reference.

Sample code:

Workbook wb = new Workbook();

Worksheet sheet = wb.Worksheets[0];
sheet.DisplayRightToLeft = true;
Cell cell = sheet.Cells["A1"];

cell.PutValue("Hello World");


wb.Save("e:\\test2\\MyBook.xls", SaveFormat.Excel97To2003); //OK
wb.Save("e:\\test2\\MyBook.pdf", SaveFormat.Pdf); //OK
wb.Save("e:\\test2\\MyBook.mht", SaveFormat.MHtml); //OK (see screen shot attached here)
wb.Save("e:\\test2\\MyBook.htm", SaveFormat.Html); //OK


I am using latest fix/version of the product: Aspose.Cells for .NET v7.4.3.1

Please try it.

Thank you.
4

Thanks a lot for your quick reply. The Problem shows itself when the file has only one sheet and no tab is generated for it in html file. Please use the sample code with the licensed Aspose.Cell and you can see the problem in generated html file. I said “Licensed” because in this situation the file only has 1 sheet and in the generated html there will be no extra “evaluation sheet” and no tab will be generated for one sheet.

5
Hi,

Thanks for providing further details.

Now, I can notice the issue with a valid license, if I do not use or set license, it works fine though.

Here is my sample code:

Sample code:

Aspose.Cells.License license = new Aspose.Cells.License();
license.SetLicense("e:\\test2\\Aspose.Cells.lic");

Workbook wb = new Workbook();

Worksheet sheet = wb.Worksheets[0];
sheet.DisplayRightToLeft = true;
Cell cell = sheet.Cells["A1"];

cell.PutValue("Hello World");


wb.Save("e:\\test2\\MyBook1.xls", SaveFormat.Excel97To2003); //OK
wb.Save("e:\\test2\\MyBook1.pdf", SaveFormat.Pdf); //OK
wb.Save("e:\\test2\\MyBook1.mht", SaveFormat.MHtml); //Shows RTL Table - Not OK
wb.Save("e:\\test2\\MyBook1.htm", SaveFormat.Html); //Shows RTL Table - Not OK

I have logged a ticket with an id "CELLSNET-41662" for your issue. We will look into your issue soon.

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

Thank you.


6

Hi,

Has the problem been solved in new versions?
I am in a situation of using this component or not for my development. so please answer me and let me choose best option.
7

Hi,


I have checked your issue, it is not resolved yet, may be due to some other urgent tasks/issues to be figured out first. Anyways, I have logged your concerns against your issue id “CELLSNET-41662” into our database. I have also asked the concerned developer if we can provide you the latest update or eta for it.

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

Thank you.
8

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

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