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.