We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose Cells- Autofitcolumns- Subtotal and Thick Box Border

Dear All,

I am evaluating Aspose Cells
Refering to my enclosed XLS, I have 3 questions:

1. why the autofitcolumns seems does not work, D, G, I of Row 18 & 19 (Total and Grand Total),
2. How to set the subtotal of J18 to be (I18/F18)*100
3. How to set Thick Box Border for each header's column?

I need advise


Thanks for your posting and using Aspose.Cells.

We have used the AutofitColumns on your file: aspose cells please help.xls and it was autofit correctly.

Could you provide us your complete code so that we could replicate this issue at our end and log in our database for investigation and a fix.

If you want to apply (I18/F18)*100 formula on J18 cell, then you can use Cell.Formula property for your needs. Please see the following code.


Cell j18 = worksheet.Cells[“J18”];

j18.Formula = “=(I18/F18)*100”;

For applying thick border to a cell, you can create a Style object and then set it with Cell.SetStyle() method.

Please see your other thread for a reference.

( https://forum.aspose.com/t/78205 )