Spire.Spreadsheet is a powerful component to view spreadsheet. As a standalone spreadsheet class library, Spire.Spreadsheet is a companion component to Spire.XLS, which mainly focus on how to display spreadsheet.

Mon May 23, 2016 6:28 am

On 31, March, 2016, E-iceblue released an New Excel viewer component- Spire.Spreadsheet for .NET. Spire.Spreadsheet for .NET is a powerful component to view spreadsheet on .NET platform. It enables developers/programmers to directly read, write, edit and customize spreadsheet for their .NET applications.
http://www.e-iceblue.com/Introduce/spre ... r-net.html

Spire.Spreadsheet Pack(hot fix) Version:3.10.0(2019-10-14)
Adjustment:
Changes the defualt value of the "Locked" property of a cell from false to true.
Bug Fixes:
Fixes the issue that only the last sheet tab is displayed when dragging horizontal bar.
Fixes the issue that all sheet tabs still are not displayed completely when the SpreadSheet window is wide enough.

Spire.Spreadsheet Pack(hot fix) Version:3.9.2(2019-09-04)
New Features:
Adds a method that supports to expand outline to a specific level.
Code: Select all
spreadsheet.ExpandOutlineToLevel(level,isRow);

Adds an event CellDataChanged that is triggered by the changed of a cell value.
Code: Select all
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.

Spire.Spreadsheet Pack(hot fix) Version:3.7.2(2019-07-15)
New Features:
Adds Items property to Cells, Columns and Rows collections in order to view each item in the collection when debugging.
Bug Fixes:
Fixes the issue that the order of the first newly added worksheet was incorrect after applying license.

Spire.Spreadsheet Pack Version:3.7(2019-07-05)
Bug Fixes:
Fixes the issue that some data lost after loading a document.
Fixes the issue that the SetActiveCell didn't take effect after setting freezing.

Spire.Spreadsheet Pack(hot fix) Version:3.6.4(2019-06-11)
New Features:
Implements copying and pasting of multiple areas (including the discontinuous cells with different rows or same rows).
Implements inserting and deleting multiple rows or columns (can be discontinuous).
Adds events to insert and delete rows or columns.
Code: Select all
AfterInsertRow/AfterIndertColumn
AfterDeleteRow/AfterDeleteColumn

Bug Fixes:
Fixes the issue that the data of the folded rows could be copied after grouping rows.

Spire.Spreadsheet Pack(hot fix) Version:3.5.5(2019-05-27)
New Features:
Supports inserting or deleting rows or columns by right-clicking to select the option "Insert" or "Delete".
Adds two events "ColumnGroupButtonClick" and "RowGroupButtonClick";

Spire.Spreadsheet Pack(hot fix) Version:3.3.1(2019-3-22)
New Features:
Supports customizing the language configuration file path.
Code: Select all
spreadsheet.MenuLanguageConfigPath= "D:/SpreadsheetTest/MenuLanguageConfig.xml";

Supports recovery shortcut (Ctrl + Y).
Reduces the width of rounding border when a cell is selected.
Bug Fixes:
Fixes the issue that it threw an ArgumentException when loading an xls document.
Fixes the issue that the minus sign was lost when the negative value was displayed in the SpreadSheet.
Fixes the issue that the right side of the border would move to the right when dragging the scroll bar to the left.

Spire.Spreadsheet Pack(hot fix) Version:3.1.5(2019-1-25)
Bug Fixes:
Fixes the issue that the positions of new added text in cells were not the same.

Spire.Spreadsheet Pack Version:3.1(2019-1-11)
Bug Fixes:
Fixes the issue that the RowHeaderClick event did not be triggered when left clicking and then right clicking the row.

Spire.Spreadsheet (hot fix) Version:2.12.4(2018-12-20)
New Features:
Supports to display the content menu in multiple languages with modifying a configuration file.
Supports the keyboard shortcuts(Ctrl + Z) for undo operation.
Code: Select all
spreadsheet.EnableUndo = true;

Supports to judge the steps for the undo and redo operation.
Code: Select all
spreadsheet.RedoStepsCount;
spreadsheet.UndoStepsCount;

Supports to end the editing status and save the result.
Code: Select all
sreadsheet.EndEdit();

Supports the right click event for the header row.
Bug Fixes:
Fixes the issue that editing the merged cell needs double-clicking.
Fixes the issue of the unreasonable design of the group number background color.
Fixes the issue of the incorrect displaying of the grouping for an Excel document.
Fixes the issue that the displaying of the negative sign and formulas for an Excel document was incorrect.
Fixes the issue of the incorrect displaying of the border for the merged cell after freezing rows.
Fixes the issue that the result was incorrect when using "VerticalScroll.Value" to get the scroll position.
Fixes the issue of the incorrect displaying of the cell content which contains currency symbol.

Spire.Spreadsheet (hot fix) Version:2.10.3(2018-10-30)
New Features:
Supports grouping rows when displaying an Excel worksheet in spreadsheet.
Bug Fixes:
Fixes the issue that the formula result was incorrect when displaying a worksheet containing formulas.

Spire.Spreadsheet (hot fix) Version:2.10.1(2018-10-12)
Bug Fixes:
Fixes the issue that copying the style of XLS cell made no sense
Fixes the issue that caused incorrect scope after grouping
Fixes the issue that the chart in Excel didn't display correctly when pulling down the ScrollBar
Fixes the issue that the formula value didn't display correctly when viewing
Fixes the issue that the sheet bar made no sense after hiding ScrollBar
Fixes the issue that the formula (=SUM(INDIRECT("M4:M"&(ROW()-1)))) showed wrong value.
Fixes the issue that the content didn't display complete when viewing
Fixes the issue that getting the selected address threw exception when mouse cursor is released outside the control

Spire.Spreadsheet (hot fix) Version:2.8.5(2018-08-22)
Bug Fixes:
Fixes the issue that the text was truncated when viewing the Excel files.
Fixes the issue that the cell format of center alignment was wrong when viewing the Excel files.
Fixes the issue that the position of Group plus button was incorrect when viewing the Excel files.

Spire.Spreadsheet (hot fix) Version:2.8.3(2018-08-08)
Bug Fixes:
Fixes the issue that the dotted line displayed incorrectly when viewing an Excel file in spreadsheet.
Fixes the issue that the chart was missing when saving Excel.
Fixes the issue that the chart title was lost when viewing an Excel file in spreadsheet.
Fixes the issue that the cell format was wrong when viewing an Excel file in spreadsheet.
Fixes the issue that the border displayed incorrectly when viewing an Excel file in spreadsheet.

Spire.Spreadsheet (hot fix) Version:2.6.0(2018-06-13)
New features:
Support to undo the action of deleting a row.
Bug Fixes:
Fixes the issue that Chinese characters were truncated when viewing .xls file in spreadsheet.

Spire.Spreadsheet (hot fix) Version:2.5.1(2018-05-24)
New features:
Add a new property "Password" to support the loading of an encrypted Excel, the statement should be before the loading step.
Code: Select all
public string Password { get; set; }

Bug Fixes:
Fixes the issue that the margins of the output document turned out to be incorrect when loading and saving an Excel document.
Fixes the issue that the group content could not completely display when loading an Excel which contains a group.
Fixes the issue that the chart got lost after saving the document.
Fixes the issue that the an pop-up would wrongly appear when clicking a cell which has a hyperlink.
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Return to Spire.Spreadsheet