Wrong row height using AutoFitRows with chines and english words

Aspose.Cells Product Family
1
Dear Sir,
I have a problem with the AutoFitRows method of the Aspose.Cells.Worksheet and cells where the value was set to “新加坡元(SGD)”.
Is this a known issue or have I missed something?
The following code open a xls-file, save after call AutoFitRows.

Aspose.Cells.Workbook workbook = new Workbook(@"D:\t2.xls");
//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];
//Get Worksheet Cells Collection
Aspose.Cells.Cells cells = worksheet.Cells;

//Create an object for AutoFitterOptions
AutoFitterOptions options = new AutoFitterOptions();
//Set auto-fit for merged cells
options.AutoFitMergedCells = true;
//Auto-fitting the 3rd row of the worksheet
worksheet.AutoFitRows(options);
//Saving the modified Excel file
workbook.Save(@"D:\t2-out.xls");

I use the latest version of the Aspose.Cells (8.7.1.0).
Attach zip file contains t2.xls and result file t2-out.xls.
Thanks and best regards
2

Hi,


Thanks for providing us template file and sample code.

After an initial test, I observed the issue as you mentioned by using your sample code with the template file. I found wrong row heights using AutoFitRows with AutoFitMergedCells option on for Chinese and English words in the cells.
e.g
Sample code:

Aspose.Cells.Workbook workbook = new Workbook(@“D:\t2.xls”);
//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];
//Get Worksheet Cells Collection
Aspose.Cells.Cells cells = worksheet.Cells;

//Create an object for AutoFitterOptions
AutoFitterOptions options = new AutoFitterOptions();
//Set auto-fit for merged cells
options.AutoFitMergedCells = true;
//Auto-fitting the 3rd row of the worksheet
worksheet.AutoFitRows(options);
//Saving the modified Excel file
workbook.Save(@“D:\t2-out.xls”);

I have logged a ticket with an id “CELLSNET-44341” for your issue. We will look into it soon.

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

Thank you.
3
Hi Sahi,
Thank for your help.
4

Hi,


We have evaluated your issue further.

Please check whether you have installed the font “標楷體” (e.g @ C:\Windows\Fonts), if yes, please share the font (in a zipped archive) here, we will check it soon. We think the issue should not occur if you have installed the font “標楷體” at your system.

Thank you.
5

Hi Amjad,

Sorry for late.
標楷體 have installed at c:\windows\fonts folder.
Attach kaiu.zip is 標楷體 font.
Thank you.

6

Hi again,


Thank you for sharing the font file. We have forwarded it to the concerned member of the product team for further analysis. As soon as we get any updates in this regard, we will post here for your kind reference.
7
Hi,

Please share us the default font of the workbook, it's name is "新細明體". By the way, after installing your shared font "kaiu.ttf", the cell's font "標楷體" still shows not installed, see the attached screenshot for your reference.

Thank you.
8

Hi sir,
Attachment file mingliu.zip is “新細明體” mingliu.ttc.

Thank you.
9

Hi again,


Thank you for sharing the required font file. We have forwarded it to the concerned member of the product team for further review. As soon as we receive further updates, we will post here for your kind reference.
10

Hi,

Thanks for using Aspose.Cells.

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

11
Dear Sir,
Thank you.
12

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
13
It's awesome... Thanks.

14

Hi,

Thanks for your feedback and using Aspose.Cells.

It is good to know that your issue is resolved with the latest version. Let us know if you encounter any other issue, we will be glad to look into it and help you further.