New features in SpreadsheetGear 2010 include:
- AutoFilter Support Including:
- Top or bottom n items.
- Top or bottom n percent.
- Above or below average.
- Last day, month, quarter, week or year.
- This day, month, quarter, week or year.
- Next day, month, quarter, week or year.
- Specific day, month, year, hour, minute or second.
- Year to date.
- Filter by font color or interior color.
- Custom criteria such as ">50".
- Filter by specific list of values.
- Support for the SUBTOTAL function which works in conjunction with autofilters to return various statistics for filtered items including average, count, max, min, product, standard deviation, sum and variance.
- Autofilter support in many commands including cell formatting, copy & paste, fill, delete and more.
- Charting Features:
- Radar charts.
- Logarithmic scales.
- Date scales.
- Error bars, including error amounts as fixed values, percentage, standard deviation, standard error and custom formulas.
- Trendlines, including linear, logarithmic, exponential, power, polynomial and moving average.
- Series line smoothing based on the Catmull-Rom spline.
- Minor tick and gridline rendering.
- Dashed line style rendering and APIs.
- AxisCrosses.Minimum option.
- Excel 2010 support (limited to fixing compatibility issues due to changes in the way Excel 2010 reads and writes .xls, .xlsx and .xlsm files).
- Reading and writing the macro-enabled Excel 2007 / Excel 2010 Open XML (.xlsm) file format.
- Reading and writing password-protected .xls, .xlsx and .xlsm workbooks.
- Visual Studio 2010 and .NET 4.0 support including support for the new .NET Framework 4 Client Profile.
- Added support for rendering grouped shapes and for reading and writing grouped shapes in Open XML workbooks.
- Added CellBeginEditEventArgs.Reason property which returns CellBeginEditReason enumeration.
- Added support for Alt+Up / Alt+Down arrow keys to data validation drop down.
- Added the ability to autofill up and to the left.