(Showing Draft Content)

SpreadJS provides the option to automatically add the row and column outlines to cell ranges containing formulas. You can access the "Auto Outline" option in Data > Group ribbon button.

1

If outlines already exist in a worksheet, then a confirmation dialog pops up.

2

If selected "OK", all the existing outlines are removed and new outlines are created according to the current formulas.

Behavior of Automatic Outlines

You can observe the following behavior while applying automatic outlines.

Behavior	Example
The outline direction follows the formula cell position.	image.png
If a row or column range has a different outline direction than the other, the latter will be missed.	image.png
If the row or column ranges intersect, only the first outline is grouped.	image.png
If a formula cell's range also contains a formula. all the legal cells are merged.	image.png
If multiple cells are combined into a legal cell range, an outline is added.	image.png

Illegal Cell Ranges

The following cell ranges are illegal in terms of adding an outline.

Cell Range	Example
Single cell	image.png
Multiple rows and multiple columns	image.png
A misplaced row or column	image.png
Cross sheet range	image.png
Circular reference	image.png

Clear Outlines

You can clear all outlines in the active sheet by using "Clear Outline" in the Data > Ungroup ribbon button.

3

Note: Auto Outlines and Clear Outline options do not support undo operation.