Skip to content

spreadsheet_mergecells_method.md

Latest commit

 

History

History
44 lines (31 loc) · 1.06 KB

spreadsheet_mergecells_method.md

File metadata and controls

44 lines (31 loc) · 1.06 KB
sidebar_label mergeCells()
title mergeCells method
description You can learn about the mergeCells method in the documentation of the DHTMLX JavaScript Spreadsheet library. Browse developer guides and API reference, try out code examples and live demos, and download a free 30-day evaluation version of DHTMLX Spreadsheet.

mergeCells()

Description

@short: merges a range of cells into one or splits merged cells

Usage

mergeCells( 
    cell: string,
    remove?: boolean
);

Parameters

  • cell - (required) a range of cells (for instance, "A1:A5")
  • remove - (optional) defines the action to be done over the cells:
    • false - to merge cells (by default)
    • true - to split cells

Example

const spreadsheet = new dhx.Spreadsheet("spreadsheet", {});
spreadsheet.parse(data);

// merge cells A3, A4, and A5
spreadsheet.mergeCells("A2:A5");

// split cells A3, A4, and A5
spreadsheet.mergeCells("A2:A5", true);

Changelog: Added in v5.0

Related article: Work with cells