Skip to main content linkedinfacebooktwittermenuarrow-up

Support auto-fit row heights Completed

In Excel it's possible to set a row to auto-fit the height; from this point, Excel alters the height of the row to fit whatever data is placed in cells in that row, as and when the data is changed.  It would be useful to be able to read out whether or not this feature has been turned on for a row, and save the auto-fit setting to a row, so that it correctly scales to match the data.  (I know there's an 'AutoFit' method which calculates how tall a row should be based on its current contents, but that isn't quite so useful. Firstly it's not possible to read in from a template whether auto-fit has been set on a row, so it's not possible in my use to determine when I should or shouldn't call the AutoFit method, and secondly such rows won't continue to resize if the user manually enters extra text in those rows.)

Official response

Mario at GemBox


In the latest versions of GemBox.Spreadsheet we have added a boolean property named IsAutoFitted in ExcelRow.
Its value indicates whether a row height is automatically fitted.