ReoGrid Forum

deaspo

Member

Registered: 2016-01-29

Posts: 11

Edit_AutoAdjustColumnWidth

Hi Jing,

Could we please have this feature in the WorksheetSettings, where the column width adjusts to fit all the length of the data in the cells?

Regards.

alexeyrlx

Moderator

From: CIS

Registered: 2015-07-14

Posts: 36

Website

Re: Edit_AutoAdjustColumnWidth

Perhaps you mean this:

In VB, for column A (0):

ReoGridControl1.CurrentWorksheet.ColumnHeaders(0).FitWidthToCells()

There is a similar method for rowheaders (fitheight...).

Note: These methods do not work if you are using a workbook in memory.

Last edited by alexeyrlx (2016-03-08 10:53:28)

---

My English is perfect! (My version of the English language ;-) )

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: Edit_AutoAdjustColumnWidth

Hi deaspo, Alexey's solution is nice idea.

In addition, the automatic column width feature added in version 1.3 as a worksheet settings, but by default it is disabled. It can be enabled by using the following code:

sheet.EnableSettings(WorksheetSettings.Edit_AutoExpandColumnWidth);

Download available at https://reogrid.net/download/

Last edited by Jingwood (2016-05-26 13:10:41)