New features in SpreadsheetGear 2012 include:
- WPF and Silverlight WorkbookView and FormulaBar controls.
- Support for 64 new Excel 2010 compatible functions (see list below).
- Support for Windows 8, Windows Server 2012, Visual Studio 2012 and .NET 4.5.
- Windows 8.1 and Visual Studio 2013 support were added in SpreadsheetGear 2012 V7.1.
- Windows 10, Visual Studio 2015 and .NET 4.6 support were added in SpreadsheetGear 2012 V7.3.
- Multithreaded recalc and sorting.
- Improved memory efficiency and performance for most workbooks particularly in 64 bit applications.
- Rich text support in cells with the WPF and Silverlight WorkbookView controls.
- Custom row and column text as well as custom styling with XAML Control Templates in the WPF and Silverlight WorkbookView controls.
- Support for saving to Microsoft XML Paper Specification (XPS) Documents with SpreadsheetGear.Windows.Xps.WorkbookXpsDocument.
- New SpreadsheetGear2012.Core.dll assembly with no references to GDI+ or Windows Forms.
- Support for System.Char types in the IRange.Value setter as well as when importing data from a data table.
- WorkbookExplorer.AllowWorkbookDesigner property to disable the Workbook Designer from the Workbook Explorer.
- Added bitmap image rendering support to Silverlight with the SpreadsheetGear.Windows.Media.Image class (7.0.4.110).
- Added SpreadsheetGear.Windows.Printing.WorkbookPrintDocument.Print() method to enable printing without a WorkbookView control (7.1.2.166).
- Added support for reading and writing Open XML workbooks larger than two gigabytes (7.2.1.102).
New Excel 2010 Compatible Functions
- AVERAGEIF
- AVERAGEIFS
- BETA.DIST
- BETA.INV
- BINOM.DIST
- BINOM.INV
- CEILING.PRECISE
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CHISQ.TEST
- CONFIDENCE.NORM
- CONFIDENCE.T
- COUNTIFS
- COVARIANCE.P
- COVARIANCE.S
- ERF.PRECISE
- ERFC.PRECISE
- EXPON.DIST
- F.DIST
- F.DIST.RT
- F.INV
- F.INV.RT
- F.TEST
- FLOOR.PRECISE
- GAMMA.DIST
- GAMMA.INV
- GAMMALN.PRECISE
- HYPGEOM.DIST
- IFERROR
- LOGNORM.DIST
- LOGNORM.INV
- MODE.MULT
- MODE.SNGL
- NEGBINOM.DIST
- NETWORKDAYS.INTL
- NORM.DIST
- NORM.INV
- NORM.S.DIST
- NORM.S.INV
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK.EXC
- PERCENTRANK.INC
- POISSON.DIST
- QUARTILE.EXC
- QUARTILE.INC
- RANK.AVG
- RANK.EQ
- STDEV.P
- STDEV.S
- SUMIFS
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- T.TEST
- VAR.P
- VAR.S
- WEIBULL.DIST
- WORKDAY.INTL
- Z.TEST