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

Free Support Forum - aspose.com

SetColumnWidthInch calculates incorrect

Hi,

I call the method SetColumnWidthInch with a value of 0.984375 inch (25mm) but the columnwidth in
the document is 2.65mm. When i call GetColumnWidthInch i get 0.98958333333333337 inch.

Is this a known bug or is te a way to set the columnwith exact?

kind regards

Thorsten

Hi Thorsten,

Thanks for the inquiry.

A difference has been found as indicated by you. We have logged this issue in our Issue Tracking System as 18272.

We will figure it out and update you soon.

Regards

Hi Thorsten,

After further investigation, it is found that it is not an issue with Aspose.Cells.

If the DPI of the machine is set 96, then 0.984375 * 96 = 94.5 (pixel). In MS Excel, the min unit is a pixel, so 95 pixels (which is equal to 0.9895833…) is set.

Regards