Sizing and Resizing

In this chapter you will learn how to set sizes for different DataTable elements and then change them, if needed.

We will consider 3 elements:

  1. DataTable container;
  2. Column;
  3. Row.

and 3 possible situations (scenarios) for them:

  1. Setting a fixed size;
  2. Autosizing;
  3. Resizing.

Setting Correct Size Values

The width and height of a datatable must be set through number values. The usage of string values is incorrect and will cause breaks in the sizing logic.

webix.ui({
    view:"datatable",
    height:400,
    width:300
});

Setting Fixed Size

DataTable container

By default, DataTable adjusts to the parent container size that gives us 2 ways to set the fixed size for it:

  1. To set the size of the parent 'div' container;
  2. To use the width and height parameters within DataTable constructor.

Setting the fixed size for DataTable

//way 1
<div id="box" style="width:300px;height:400px;"></div> 
 
webix.ui({
    container:"box",
    view:"datatable",
    // datatable configuration
});
//way 2
<div id="box"/>
 
webix.ui({
    container:"box",
    view:"datatable",
    height:400,
    width:300,
    // other config settings
});

Related sample:  Adjusting to the parent container

Related sample:  Sizing through the 'width', 'height' parameters

Column

Fixed column width

By default, datatable columns feature fixed size of 100px. To change it, you should either:

  • use width while configuring the column to set width to a column individually, or
  • use columnWidth while configuring the datatable to set a common width for all the columns. Like the default common width, it can be overridden by an individual width value, or
  • use minWidth property in the column configuration to define minimal width for it. If there's more space initially or after resizing, column width will be increased, but it can never be less than minWidth value, or
  • use minColumnWidth property in datatable configuration to set common minimal width for all columns. It can be overridden by individual minWidth value.

Setting different widths for columns

webix.ui({
    view:"datatable",
    columns:[
        { id:"title", header:"Film title" ,   width:80},
        { id:"title", header:"Release year" , minWidth:50}
    ]
});

Altering common width for all columns

webix.ui({
    view:"datatable",
    columnWidth:200,
    columns:[
        { id:"title", header:"Film title"},
        { id:"title", header:"Release year"}
    ]
});

Relative Sizing

  • adjusting the width of datatable to the parent container

If you set widths for columns and their sum is less than the width of the parent container, you can use the fillspace attribute to force some of columns to widen for filling the unused space.

Using attribute fillspace

webix.ui({
    view:"datatable",
    columns:[
        { id:"title", header:"Film title", fillspace:true},
        // more columns
    ]
});

Related sample:  Adjusting columns to the parent container

  • adjusting the width of a column to other datatable columns

There can be more than one fillspace in the datatable; in this case width will be calculated on the base of a proportion defined by numeric values:

webix.ui({
    view:"datatable",
    columns:[
        { id:"id", header:"ID", fillspace:1},
        { id:"title", header:"Film title", fillspace:4}
    ]
});

In the above code the title column is 4 times bigger than the id column, which is 20 to 80 percent relation.

Adjusting column to its content

If you want to adjust the width of a column to the related content size, you can use attribute adjust. It is defined for the needed column individually and features two modes:

  • "data" - adjusts column width to the content of the widest item in it;
  • "header" - adjusts column width to its header content;
  • true - searches for the widest item among data and header(s) and adjusts column width to its content.

Adjusting the column width to fit the content size

webix.ui({
    view:"datatable",
    columns:[
        { id:"title", header:"Film title", adjust:"data"},
        { id:"rank", header:"Rank", adjust:"header"},
        { id:"votes", header:"Votes", adjust:true}
        // more columns
    ]
})

Related sample:  Adjusting columns to the content

Note that resulting column width after adjusting won't be lesser than minWidth for this column provided that the latter is set.

Row

To set the fixed height for a row, you should use $height while defining the data you will load into DataTable. If you set the height in such a way, it will save its value regardless of any other enabled size parameters (e.g. - autoheight).

Note that you need to provide the fixedRowHeight:false setting for the datatable as well, to avoid breaks in the scroll or editors position.

Setting different heights for rows

webix.ui({
    view:"datatable",
    fixedRowHeight:false,
    data:[
        { $height:20, id:1, title:"The Shawshank Redemption", year:1994},
        { $height:40, id:2, title:"The Godfather",            year:1972},
        // other data fields
    ]
});

Related sample:  Setting custom size for rows

Autosizing

Autosizing to parent container

DataTable automatically adjusts to the size of a parent container provided that no content autosizing is not enabled.

To make the DataTable fill the entire width, you should define fillspace for at least one of its columns:

webix.ui({
    view:"datatable",
    columns:[
        { id:"title", header:"Film title", fillspace:true},
        { id:"year", header:"Year", width:100}
    ]
});

In this case, title column will be calculated as container width - 100.

Autosizing to content

You can enable width, height (or both of them) autosizing to adjust DataTable to the size of its content horizontally or vertically. Autosizing is enabled by the following parameters:

DataTable autosizing

webix.ui({
    view:"datatable",
    autoheight:true,
    autowidth:true
});

Related sample:  Height and width autosizing

Resizing

By resizing we mean 2 possible scenarios:

  • resizing columns, rows by hovering, dragging mouse over some border;
  • setting other sizes for DataTable elements with the help of related API.

Related sample:  Row auto-height

Mouse resizing

To enable the possibility to resize columns (rows) by mouse you should use one of the following parameters (or both of them at once):

Enabling the possibility to resize columns and rows by mouse

webix.ui({
    view:"datatable",
    resizeColumn:true,
    resizeRow:true
});

For these resizing options there exist relevant events onRowResize and onColumnResize.

Related sample:  Column and row resizing

Setting custom size for area where "resize" is detected

You can also define the size of the area where resizing can be activated. You can do this by setting the resizeRow or resizeColumn parameters and passing an object with the size property to them:

webix.ui({
    view:"datatable",
    resizeColumn: {size: 6},
    resizeRow: {size: 6}
});

Related sample:  Size of resize area

Resizing only in the header area

One more resizing possibility is to limit the area allowed for resizing to the datatable header.

It can be achieved by specifying the resizeRow or resizeColumn parameters and passing an object with the headerOnly property set to true to them:

webix.ui({
    view:"datatable",
    resizeColumn: {headerOnly:true},
    resizeRow: {headerOnly:true}
});

Related sample:  Resize within header only

Dynamic resizing

For dynamic resizing of DataTable elements, the library offers the resize() method. When you change size of some element and call this method, child(parent) container of the calling element will adjust to his new size.

Adjusting the parent container to the DataTable size

grid = webix.ui({
    view:"datatable",
    // datatable configuration
})
 
grid.define("width", 700);
grid.resize();

Related sample:  Dynamical adjusting to the parent container

In some situations you may need to adjust an element to the size of the outer parent HTML container. In such the situation you may use method adjust() instead of resize():

Adjusting DataTable to the size of the parent container

grid = webix.ui({
    container:"box",
    view:"datatable",
    // datatable configuration
})
 
webix.toNode("box").style.width = "700px";
grid.adjust();

Related sample:  Dynamical adjusting to the parent container

The resize() and adjust() methods can lead to one and the same effect. For example, you have DataTable placed into a 'div' container, named as 'box'. The initial height of DataTable is 50 px. You want to increase it to 80 px. Possible solutions can look as shown in the table below:

Table 1 Use of adjust() and resize() methods
Image Related code
document.getElementById('box').style.height="80px";
grid.adjust();
grid.define("height", 80);
grid.resize();

You can use events to call the mentioned above methods:

Adjusting DataTable to the size of a window, it’s placed into

webix.event(window, "resize", function(){ grid.adjust(); })

Related sample:   Sizing and events

Dynamic Adjusting of Columns and Rows

To dynamically adjust column width or row height to the size of their content, you can use the corresponding Datatable API.

Adjusting column width

The adjustColumn(id) method adjusts the width of a chosen column specified by its ID.

The method takes two parameters:

  • id - (string,number) the id of a column;
  • mode - (string) optional, the adjustment mode ("header", "data", "all").
datatable.adjustColumn("title");
datatable.adjustColumn("title", "header");

The adjustment modes are:

  • header - adjusts the column to the width of its header;
  • data (default) - adjusts the column to the width of its content;
  • all - combines the above mentioned modes and adjusts the column to the bigger value.

Adjusting row height

The adjustRowHeight(id) method adjusts the height of all rows based on the cell content of a particular column or all columns.

Note that the method can slow down the application.

The method takes two optional parameters:

  • columnId - (string) the id of a column
  • silent - (boolean) apply the method without repainting

Note that you need to set fixedRowHeight to false for your datatable, otherwise the method will not have any visible result.

webix.ui({
    view:"datatable",
    fixedRowHeight:false,
    columns:[
        { id:"title", header:"Film title", fillspace:true},
        { id:"year", header:"Year", width:100}
    ]
});
 
// adjusts the height of each row to 
// the height of the "title" column cells
dtable.adjustRowHeight("title");
 
// adjusts the height of each row to the highest cell in it
dtable.adjustRowHeight();

The row height is adjusted to:

  • the height of the cell in a column, which is defined by the columnId parameter;
  • the height of the "biggest" cell in a row, if columnId is not provided.

If you want to apply auto-sizing just after data loading, you can use the following code:

webix.ui({
    view:"datatable",
    columns:[
        { id:"rank",    width:40,   header:"", css:"rank"},
        { id:"title",   width:380,  header:"Film title" },
        { id:"year",    width:160,  header:"Released"   },
        { id:"votes",   width:120,  header:"Votes"      }
    ], 
    fixedRowHeight:false,
    on:{
        "onresize":webix.once(function(){ 
            this.adjustRowHeight("title", true); 
        })
    }
});

Scrolling

By default, scrolling (vertical and horizontal) is enabled in DataTable. It can be disabled by parameters scrollY, scrollX.

Disabling vertical scrolling

grid = webix.ui({
    view:"datatable",
    scrollY:false
});

You can also force DataTable to be scrolled just by whole rows, i.e. you won't be able to scroll along the full length of rows. The related parameter you should enable is scrollAlignY:

Scrolling DataTable by whole rows

grid = webix.ui({
    scrollAlignY:true
});

Related sample:  Different scrolling behaviours

Back to top
If you have not checked yet, be sure to visit site of our main product Webix javascript framework and page of web datagrid product.