Spire.Spreadsheet 3.9.2 adds a method to expand outline to a specific level

We're pleased to announce the release of Spire.Spreadsheet 3.9.2. This version adds a method that supports to expend outline to specific level, and an event that will be triggered by the change of a cell value. Besides, this update also inludes several bug fixes. More details are as follows.

New Features:

• Adds a method that supports to expand outline to a specific level.

spreadsheet.ExpandOutlineToLevel(level,isRow);

• Adds an event CellDataChanged that is triggered by the changed of a cell value.

private void CellDataChanged(object sender, Spire.Spreadsheet.Forms.CellEventArgs e)
{
    MessageBox.Show(Convert.ToString("CellDataChangedEvent"));
}

Bug Fixes:

• Fixes the issue that hiding sheet bar didn't work.
• Fixes the issue that columns could still be inserted and deleted when the worksheet was protected.
• Fixes the issue that the formulas couldn’t be calculated correctly when there were rows or columns inserted.

Adjustment:

• Adjusts the appearance of the group icon.