ASP.NET Spreadsheet - Frozen Columns/Rows, Data Validation and More (Coming soon in v15.2)

ASP.NET Team Blog
13 November 2015

Check out these great new features coming to the powerful DevExpress ASP.NET Spreadsheet in the next release, v15.2.

These features are available for both the ASP.NET WebForms and MVC versions of the Spreadsheet. The new features include:

Frozen Panes (Rows and Columns)

With an Excel inspired Freeze Panes feature, end-users can lock specific rows or columns in one area to keep this area of a worksheet visible while scrolling the worksheet content vertically or horizontally.

DevExpress ASP.NET Spreadsheet - Frozen Columns & Rows

Data Validation

An Excel inspired data validation feature helps prevent end-users from entering invalid data into worksheet cells. This feature allows you to definie restrictions and provide notifications on what data can or should be entered in a cell:

DevExpress ASP.NET Spreadsheet - Data Validation

Because it is difficult to see what validation is added to a cell, in the above image, we've added the green callout box images to highlight the validation in the spreadsheet cells. Those boxes are not part of the spreadspeet.

Table Sorting and Filtering

End-users can now use the Excel inspired AutoFilter feature to filter data by columns and to easily display only rows that meet specific conditions. Three filter types are available (depending upon the column data types): Text, Number, and Date Filters. In addition, the Filter by Values option can be used which allows you to select from column unique values.

DevExpress ASP.NET Spreadsheet - Sorting & AutoFilter

Formula Bar

An Excel-like formula bar shows the contents of the current cell and allows creating and viewing formulas. To start creating a formula, click the mouse cursor in the formula bar and enter an equal sign (=).

DevExpress ASP.NET Spreadsheet - Formulas

Formula AutoComplete

The Formula AutoComplete feature makes it easier to create and edit formulas and minimizes typing and syntax errors. After typing an equal sign (=) and beginning letters into a cell, a dynamic drop-down list of valid functions that match the letters is displayed below the cell.

Document Autosave

The Autosave feature helps reduce the risk of data loss by saving an opened document automatically at predefined but customizable intervals. And you can programmatically handle:

  • autosave operations: like saving to some other custom storage
  • resolve multi-user conflicts (should any arise)

Work Session Hibernation

This feature helps you to save memory (RAM). When enabled, the 'work session hibernation' will automatically free server memory by hibernating inactive open documents in the spreadsheet.

If this feature is enabled, open documents which where idle for a certain time can be released from the server memory and saved to the server file system at a specific path. The hibernation settings (such as a session timeout, server directory) are available through an API exposed by the server DocumentManager object.

This hibernation feature helps if the server fails because when the server is restarted, the spreadsheet control will load the hibernated document and allow you to continue working.

Extended Page Setup Functionality

A new Page Setup dialog helps end-users prepare the document for printing. The dialog helps setup several print-related settings (such as document orientation, paper size, page margins, page order, etc.) and provides the capability to specify header and footer text too.

DevExpress ASP.NET Spreadsheet - Page Setup

Ribbon Improvements

The built-in ribbon is improved by employing the ASPxRibbon control's newly implemented features, such as contextual tabs and one-line mode. Thus, the 'Design' ribbon context tab help with working with tables in a worksheet. One-line ribbon can be used to make navigation more compact within a control and make more room for document editing.

Register for v15.2 webinar

To see all the new features coming out for the v15.2 release, sign up for the "v15.2: What's New for ASP.NET Developers":

Click here to register

Thanks!


Use the best, DevExpress!

Year after year, .NET developers such as yourself consistently vote DevExpress products #1.

Experience the DevExpress difference for yourself and download a free 30-day trial of all our products today: DevExpress.com/trial (free support is included during your evaluation).

3 comment(s)
Mike Webster
Mike Webster

Wow.  That is a lot of great improvements. Really looking forward to using these awesome new features.

Thanks, Mehul and team.  

13 November, 2015
ramana samala
ramana samala

hii harry,

 When I cpy data from open office sheet and paste it in devexpress spread sheet I am not getting data der..instead when paste it in ribbon ..whole data  gets into one column..how can i solve it

3 March, 2017
Mehul Harry (DevExpress)
Mehul Harry (DevExpress)

Hi Ramana,

Could you please report this to our support team so they can investigate it further: https://devexpress.com/support

3 March, 2017

Please login or register to post comments.