New features in SpreadsheetGear 2017 include:
- New SpreadsheetGear for .NET Standard product delivered via NuGet which runs on platforms including:
- Microsoft .NET Framework
- ASP.NET Core
- .NET Core
|
- Universal Windows Platform
- Xamarin.iOS
- Xamarin.Android
|
|
- 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.
- 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
|
- Support for 50 new Excel 2013 functions as well as the Excel 2010 AGGREGATE function for a total of 448 Excel compatible functions (see list of new functions below).
- 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 Excel 2016 including default SHA-512 encryption for workbooks.
- Support for new Excel 2013 and Excel 2016 workbook structure and worksheet protection passwords.
- Support for Windows 10 Creators Update and Windows Server 2016 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.
- Improve the performance of workbooks with large numbers of merged cells (8.1.1.100).
- Improve IRange.Copy performance for certain cases of copying a multiple row range to a range with more rows than the source (8.1.1.100).
Improve performance of adding a large number of worksheet specific defined names using INames.Add (8.1.1.100)
- Increase support for unique text cells from approximately 2GB of text to approximately 30GB of text (8.1.1.100).
- Official support for Excel 2019 and Excel for Office 365 (8.2.4.100).
- Added IRange.IsDisposed, ISheet.IsDisposed, IWorkbook.IsDisposed, IWorkbookSet.IsDisposed and IShapeRange.IsDisposed properties (8.3.1.100).
- Added support for Visual Studio 2022 (8.7.1.100).
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
|