[]
        
(Showing Draft Content)

Automatic Outline

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.




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




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.



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