Spreadsheet is a control for viewing and editing Microsoft Excel files in a familiar Excel-like interface. It combines some of our most popular components, like our grid control, ribbon control, formula engine, and more, to create a first of its kind offering for Silverlight for viewing and editing Excel files.
Spreadsheet allows you to import the contents of a Microsoft Excel (.xls or .xlsx) file, and it allows you to edit and save the Excel file. All the worksheets are imported and visualized in an interface that is identical to that of Excel’s tabbed interface. You can open protected worksheets and workbooks, and also encrypt them with passwords, if you want to. The following Excel versions are supported:
Excel 97, 2000, 2002, 2003 (.xls) Excel 2007, 2010 (.xlsx) Spreadsheet gives you all of this in a great Excel-like user interface, complete with Office-style ribbons and tabbed worksheets, even without Excel installed. The interactive UI allows you to edit or delete columns and rows at run time, add or remove sheets, access context menus, and more.
Styles and formats defined in an Excel file are automatically imported and applied on the cells, rows, and columns. End users can also apply these settings to the cells during run time.
Embedded elements like charts, sparklines, rich text content, and images defined in the Excel document can be shown in the spreadsheet.
The familiar, Excel-like ribbon toolbar gives your end users a wealth of command items that they can easily invoke in a familiar interface. It is fully customizable and you can easily add or remove items from it.
Each worksheet is presented in a familiar Excel-like tabbed user interface. You can freeze panes so that specified columns and rows are always visible even while scrolling. Bookmarks and hyperlinks (to bookmarks) are also imported and presented to end users.
You can edit the contents of cells inline, including cells containing formulas. Solutions are not only calculated using the formulas already defined in the .xls file, but you can also define new formulas, save them in the .xls file, and calculate solutions with them. You can even specify cross-worksheet formulas. Validation rules specified in .xls files are automatically imported and end users can add to or edit the existing rules in familiar built-in dialog boxes. Comments for specific cells can be edited and also shown in smart tags that are identical to those used in Excel.
The named ranges feature allows you to assign a name to a particular cell or range of cells. Named ranges are mainly used in formulas. They help you to easily identify the cell or range of cell references used in the formulas. Spreadsheet automatically imports the named ranges defined in Excel. Spreadsheet has a name manager that displays the existing named ranges in the workbook and also allows the end user to create, edit, and delete the named ranges.
Spreadsheet provides full support for all the clipboard operations like cut, copy, and paste. In the case of formula cells, you can either paste the cell values or the formulas. Also the formula values get adjusted based on the relative cell references.
Spreadsheet allows you to manage the worksheets in a workbook. That is, you can show/hide the worksheets to easily navigate between them when the workbook has many worksheets. It allows the end user to insert, delete, and rename the worksheet. When the end user renames the worksheet, spreadsheet automatically updates all the formulas that have the old sheet name with the modified sheet name. You can protect worksheets to prevent unwanted changes from the end user. Spreadsheet can also import worksheets that are protected in Excel and allow you to unprotect them using the same password.
The spreadsheet control allows you to zoom in to get a close-up view of the cells, and allows you to zoom out to view more cells at once, by setting the zoom scale for the grid.
The control comes with support for several built-in locales and also allows you to add custom locales if necessary.