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 SpreadsheetGear2023.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