freeze-columns.md

icon	description
sidebar	Freeze columns in excel and editor to better view data while editing and adding records

Freeze Columns

Three ways to freeze columns

We can freeze columns in many ways. Here is how,

i. Freeze the column while adding a new one

1. Click on the + button to add a new column.
2. Provide column Name, Key name and rest of the values based on your choice.
3. Check Frozen? checkbox for the column.

Freezing column while adding new one

ii. Freezing already created column

1. Click on the Pencil (Edit) icon for any created column.
2. Check the Frozen? checkbox.
3. Click on Save.

Editing the column to mark it as freeze

iii. Freezing column with Runtime Schema

We can freeze the column while providing a custom schema too with the isFrozen flag in our frontend code.

showWidget({
  schema: [
    {
      key: 'email',
      name: 'Email',
      type: 'Email',
      isFrozen: true
    }
  ]
});

Effects on Sample File Generation

The generated sample file will have specified columns freeze on the left side. So they won't gets hidden if we scroll to the right.

Excel view of freezed columns

Effects on Spreadsheet Editor

While importing data spreadsheet editor freezes two default Checkbox and Sr. No. Columns. Other mentioned columns get frozen as per schema.

Freezing 2 default and 2 mentioned columns in editor

{% include "../.gitbook/includes/your-feedback-is-crucial-in....md" %}