Visit Our Facebook Page
Visit Our Google Plus Page
Visit Our Twitter Page
What's New
ASP.NET, Windows Forms and Silverlight SpreadsheetGear Samples
Purchase SpreadsheetGear
Download SpreadsheetGear

SpreadsheetGear 2017 Beta

Download SpreadsheetGear 2017 Beta
SpreadsheetGear 2017 introduces a new product and a number of frequently-requested features:
  • NEW PRODUCT: SpreadsheetGear for .NET Standard
    Runs on multiple platforms including:
    • Microsoft .NET Framework
    • ASP.NET Core
    • .NET Core
    • Universal Windows Platform
    • Xamarin.iOS
    • Xamarin.Android
    • Xamarin.Forms
    • Mono
    SpreadsheetGear for .NET Standard OS support includes:
    • Windows
    • Windows Server
    • Windows Nano Server
    • Windows Mobile
    • Windows IoT
    • XBox One
    • Linux
    • MacOS
    • iOS
    • Android
    • Google App Engine
    • Samsung Tizen
  • Official support for Excel 2013 and Excel 2016.
  • Support for 50 new Excel 2013 functions as well as the Excel 2010 AGGREGATE function for a total of 449 Excel compatible functions (see list of new functions below).
  • Excel 2016 compatible conditional formatting including:
    • Icon Sets
    • Data Bars
    • Color Scales
    • Highlight Cells
    • Top n / Bottom n Rules
    • More than 3 Rules per cell
    • Advanced Rules
    • Overlapping Rules
  • Autofilter by font color, cell color and conditional format icon.
  • Support for reading, writing, modifying and rendering gradient cell backgrounds as well as API support with the IRange.Interior.Gradient and IRange.Interior.Pattern properties.
  • Support for reading and writing encrypted workbooks with the new Agile Encryption used by Excel 2013 and later including default SHA-512 encryption for workbooks.
  • Support for new Excel 2013 and later workbook structure and worksheet protection passwords.
  • Support for Windows 10 Creators Update and Windows Server 2016 (see SpreadsheetGear for .NET Standard for Windows Nano Server 2016 support) including support for .NET Framework 4.7.
  • Visual Studio 2017 support including Windows Forms and WPF control toolbox integration, IntelliSense and Microsoft Help Viewer 2.3 integration.
  • Added IWorkbookSet.WithLock(Action) and WorkbookView.WithLock(Action) methods to simplify GetLock...try...finally...ReleaseLock sequences (not included in the .NET Framework 2.0 assembly).
  • Enabled multi-threaded recalc for array formulas and worksheet functions which evaluate as arrays (including functions such as SUMPRODUCT).
  • Improved the performance of copying formulas with 3d cell references, 3d name references and / or addin function references.
  • Improved the performance of a number of worksheet functions.
  • Improved the performance of parsing formulas with 3d references which refer to a workbook with a large number of worksheets. This yielded a dramatic performance improvement when reading Open XML workbooks with a significant number of such references.
  • Added support for smooth line rendering in charts for the WPF and Silverlight WorkbookView controls.
  • New workbooks now use Excel 2016 theme.
 

New Excel 2010 and Excel 2013 Compatible Functions

  • ACOT
  • ACOTH
  • AGGREGATE
  • ARABIC
  • BASE
  • BINOM.DIST.RANGE
  • BITAND
  • BITLSHIFT
  • BITOR
  • BITRSHIFT
  • BITXOR
  • CEILING.MATH
  • COMBINA
  • COT
  • COTH
  • CSC
  • CSCH
  • DAYS
  • DECIMAL
  • ENCODEURL
  • FILTERXML
  • FLOOR.MATH
  • GAMMA
  • GAUSS
  • IFNA
  • IMCOSH
  • IMCOT
  • IMCSC
  • IMCSCH
  • IMSEC
  • IMSECH
  • IMSINH
  • IMTAN
  • ISFORMULA
  • ISO.CEILING
  • ISOWEEKNUM
  • MUNIT
  • NUMBERVALUE
  • PDURATION
  • PERMUTATIONA
  • PHI
  • RRI
  • SEC
  • SECH
  • SHEET
  • SHEETS
  • SKEW.P
  • UNICHAR
  • UNICODE
  • WEBSERVICE
  • XOR
Download SpreadsheetGear 2017 Beta