# Congelar

- Human documentation: [https://docs.univer.ai/es-ES/guides/sheets/features/core/freeze](https://docs.univer.ai/es-ES/guides/sheets/features/core/freeze)

- Agent Markdown: [https://docs.univer.ai/es-ES/guides/sheets/features/core/freeze.md](https://docs.univer.ai/es-ES/guides/sheets/features/core/freeze.md)

- Requested language: `es-ES`

- Content language: `es-ES`

- Documentation version: `1.2.0`

- Source: [sheets/features/core/freeze.es-ES.mdx](https://github.com/dream-num/documentation/blob/dev/content/guides/sheets/features/core/freeze.es-ES.mdx)

---

[`IWorksheetData.freeze`](https://docs.univer.ai/es-ES/guides/sheets/model/workbook-data.md) se puede utilizar para configurar el estado de congelación de una hoja de trabajo. La definición de su interfaz es la siguiente:

```typescript
interface IFreeze {
  /**
   * The number of frozen columns
   */
  xSplit: number
  /**
   * The number of frozen rows
   */
  ySplit: number
  /**
   * The starting row that can be scrolled (the starting row of the main view area)
   */
  startRow: number
  /**
   * The starting column that can be scrolled (the starting column of the main view area)
   */
  startColumn: number
}
```

Por ejemplo, si quiero congelar la columna B y la fila 2, puedo configurarlo así:

```json
{
  "xSplit": 1, // Freeze 1 column, which is column B
  "ySplit": 1, // Freeze 1 row, which is row 2
  "startRow": 2, // The starting row that can be scrolled is row 3
  "startColumn": 2 // The starting column that can be scrolled is column C
}
```



## API de fachada

La clase `FWorksheet` proporciona varios métodos para administrar el estado de congelación de filas y columnas en una hoja de trabajo. Estos métodos le permiten configurar, obtener y cancelar paneles congelados.

### Establecer congelación

```typescript
const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()
worksheet.setFreeze({
  xSplit: 1, // Freeze 1 column, which is column B
  ySplit: 1, // Freeze 1 row, which is row 2
  startRow: 2, // The starting row that can be scrolled is row 3
  startColumn: 2, // The starting column that can be scrolled is column C
})
console.log('The current freeze state:', worksheet.getFreeze())
```

### Establecer columnas congeladas

```typescript
const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()

// Set freeze for columns A-B
worksheet.setFrozenColumns(2)
```

### Establecer filas congeladas

```typescript
const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()

// Set freeze for the first 3 rows
worksheet.setFrozenRows(3)
```

### Obtener estado congelado

```typescript
const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()

const freezeState = worksheet.getFreeze()
```

### Obtener columnas congeladas

```typescript
const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()

const frozenColumns = worksheet.getFrozenColumns()
```

### Obtener filas congeladas

```typescript
const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()

const frozenRows = worksheet.getFrozenRows()
```

### Cancelar congelación

```typescript
const worksheet = univerAPI.getActiveWorkbook().getActiveSheet()

// Cancel all freezes
worksheet.cancelFreeze()
```