Hi Aspose team,
I'm using Cells 8.8.1.1 and I have a problem getting column width.
Seems getColumnWidth is returning wrong values - see test case in attchament.
Jean.
Hi,
Thanks for providing us template file and sample code.
I have tested your scenario/ case using your sample code with your template file using v8.8.3.1, it works fine and as expected. I compared the values obtained by Cells.getColumnWidth() method Vs manually checking the width of the cols in MS Excel and both are matched. Here is my console output when running your code segment with v8.8.3.1 for your reference:
row[0]: height=5.25, heightInch=0.07291666666666667, calculated=5.25
row[1]: height=18.75, heightInch=0.2604166666666667, calculated=18.75
row[2]: height=3.0, heightInch=0.041666666666666664, calculated=3.0
row[3]: height=13.5, heightInch=0.1875, calculated=13.5
row[4]: height=13.5, heightInch=0.1875, calculated=13.5
row[5]: height=13.5, heightInch=0.1875, calculated=13.5
row[6]: height=13.5, heightInch=0.1875, calculated=13.5
row[7]: height=13.5, heightInch=0.1875, calculated=13.5
row[8]: height=13.5, heightInch=0.1875, calculated=13.5
row[9]: height=13.5, heightInch=0.1875, calculated=13.5
col[0]: width=0.6666666666666666, widthInch=0.08333333333333333, calculated=6.0
col[1]: width=3.0, widthInch=0.2708333333333333, calculated=19.5
col[2]: width=7.0, widthInch=0.5625, calculated=40.5
col[3]: width=7.0, widthInch=0.5625, calculated=40.5
col[4]: width=7.0, widthInch=0.5625, calculated=40.5
col[5]: width=4.0, widthInch=0.34375, calculated=24.75
col[6]: width=0.75, widthInch=0.09375, calculated=6.75
col[7]: width=0.75, widthInch=0.09375, calculated=6.75
col[8]: width=0.75, widthInch=0.09375, calculated=6.75
col[9]: width=0.75, widthInch=0.09375, calculated=6.75
Please see the values and let us know which values are wrong, so we could evaluate it further.
Thank you.