What's new in Bytescout Spreadsheet SDK 4.7.1.2050
Jul 14, 2023
- Minor fixes and improvements.
New in Bytescout Spreadsheet SDK 4.7.0.2034 (Apr 27, 2023)
- Minor fixes and improvements.
New in Bytescout Spreadsheet SDK 4.4.0.1994 (Jan 25, 2022)
- .NET Core min required version is 2.1 now (was 2.0).
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 4.3.0.1981 (Oct 5, 2021)
- Fixed ISO-8601 date parsing.
- Fixed formula parsing.
- Fixed handling of shared formulas.
- Fixed black charts background in XLS format.
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 4.2.0.1959 (May 18, 2021)
- Added support for 'HYPERLINK' function.
- Improved import of CSV with nested quotation and multiline cells.
- Improved data types detection in CSV import.
- Fixed null exceptions during the loading of some SpreadsheetML (XML Spreadsheet) files.
- Fixed CSV export: do not convert numeric strings with leading zeros, like "00123" to numbers.
- Fixed saving of 'PageSetup.Zoom' property in XLS format.
- Fixed column auto-fit when the column contains merged cells.
- Fixed very rare 'temp file exists' conflict.
New in Bytescout Spreadsheet SDK 4.1.0.1943 (Feb 10, 2021)
- WinFormsControl: Added support for touch gestures: panning and inertial scrolling.
- Improved CSV export.
- Improved parsing of formulas.
- Improved support for custom cell formats.
- Improved worksheet splitting and freezing.
- Added missing "COUNTIFS" formula.
- PDF export: fixed crash on empty spreadsheet.
- Fixed loading of SpreadsheetML (XML Spreadsheet) documents from stream.
- = .NET Core build is now Linux-compatible.
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 4.0.0.1910 (Oct 26, 2020)
- Added support for SUBSTITUTE and COUNTBLANK functions.
- Fixed parsing and calculation of the unary plus and minus operators.
- Fixed freezing of rows and columns.
- Fixed saving of named ranges in XLS and XLSX formats.
- Fixed editing of protected worksheets.
- Improved parsing of OpenXML spreadsheets.
- Added informational properties 'Cell.ColIndex' and 'Cell.RowIndex'.
- Fixed 'Row.NumberFormat' and 'Column.NumberFormat' properties.
- Fixed 'Cell.FontColorIndex' property.
- Improved ODF spreadsheet detection when reading from stream.
- Fixed tread-safety issue.
- Other minor fixes and improvements.
- Improved .NET Core compatibility.
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.9.0.1873 (Jul 3, 2020)
- Improved the parsing of formulas.
- Improved handling of protected worksheets.
- 'Workbook.PictureList' now contains collection of all images in the spreadsheet.
- Improved automatic page size when exporting to PDF.
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.8.0.1843 (Mar 20, 2020)
- Conditional formatting was lost when saving.
- Worksheet auto-calculation was not working for some formulas.
- Improved support for worksheet protection.
- Improved .NET Core compatibility.
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.7.0.1832 (Feb 12, 2020)
- Improved export to PDF format.
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.6.0.1814 (Dec 4, 2019)
- Added Worksheet reference to `CustomFunctionsCallback` delegate providing access to worksheet that contains custom function.
- Fixed calculation of custom functions when opening a document.
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.5.0.1870 (Dec 4, 2019)
- XLSX: Added support for Table objects and references.
- Fixed parsing of formulas with omitted arguments.
- Improved parsing of complex headers and footers.
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.4.4.1790 (Oct 2, 2019)
- Improved parsing of Excel functions.
- Minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.4.3.1790 (Sep 2, 2019)
- Minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.4.2.1783 (Aug 7, 2019)
- Minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.4.1.1781 (Jul 2, 2019)
- Accelerated parsing of spreadsheets that contain very large named ranges.
- Minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.4.0.1778 (May 18, 2019)
- Added password parameter to 'SaveAsPDF()' method.
- Improved export to JSON.
- Added new set of properties 'Workbook.WorkbookView' containing visual options for Excel tabs and scroll bars.
- Other minor fixes and improvements.
- Fixed exception when running in Medium Trust web application.
New in Bytescout Spreadsheet SDK 3.3.1.1761 (Mar 13, 2019)
- Improved support of legacy XLS format.
- Fixed crash when loading documents containing print settings.
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.2.0.1743 (Feb 4, 2019)
- Fixed `PageSetup.CenterHorizontally` and `PageSetup.CenterVertically` properties.
- Added `PageSetup.PrintHeadings` property.
- Minor fix in parsing formulas.
- Other minor fixes and improvements.
New in Bytescout Spreadsheet SDK 3.2.0.1725 (Oct 25, 2018)
- Improved support of SpreadsheetML (XML Spreadsheet) input format.
- Improved PDF tables formatting.
- Fixed PDF export of multiline cell values.
- Other minor bug fixes and improvements.
New in Bytescout Spreadsheet SDK 3.1.0.1715 (Jul 19, 2018)
- Added support SpreadsheetML (XML Spreadsheet) input format.
- PDF export: fixed landscape orientation and margins.
- Fixed parsing of text styles in cells containing rich text.
- Other minor bug fixes and improvements.
New in Bytescout Spreadsheet SDK 3.0.0.1699 (Apr 10, 2018)
- Added `CustomFunctionsCallback` allowing to implement custom functions for cell formulas.
- See "Custom Functions" source code example for demonstration.
- Fixed parsing of references of form "'sheetName'!cellAddress:'sheetName'!cellAddress".
- Other minor bug fixes and improvements.
New in Bytescout Spreadsheet SDK 2.9.5.1698 (Jan 24, 2018)
- Improved export to PDF.
- Added property Worksheet.PageSetup.FitToPage.
- Added property Worksheet.PageSetup.PrintGridLines.
- Added properties GridLinesColorEnabled and GridLineColor to Worksheet.ViewOptions.
New in Bytescout Spreadsheet SDK 2.9.0.1677 (Nov 8, 2017)
- Fixed crash on saving XLS document containing `doughnut` chart.
- Fixed bug with saving formulas in XLSX format.
- Fixed crash on saving XLSM with controls.
- Added parameter to force quotation when saving to delimiter-separated formats (CSV, TXT).
- Improved support of ODS format.
- Other minor bug fixes and improvements.
New in Bytescout Spreadsheet SDK 2.8.5.1638 (Jun 2, 2017)
- Improved charts decoration.
- Visual Studio 2017 integration.
- Removed obsolete ClientProfile builds.
- Fixed date datatype reading from ODS files.
- Fixed crash on saving worksheets with a space char in the name.
- Other minor bug fixes and improvements.
New in Bytescout Spreadsheet SDK 2.8.1.1601 (Mar 8, 2017)
- WinFormsControl: Fixed crash on scrolling.
- Other minor bug fixes and improvements.
New in Bytescout Spreadsheet SDK 2.8.0.1583 (Jan 12, 2017)
- Improved conversion to PDF.
- Added Spreadsheet.Options.CSVDetectDataTypes property allowing to disable the automatic data type detection when importing CSV file.
- Added OLE/COM versions of Cell.FillPatternForeColor and Cell.FillPatternBackColor properties to use from VBScript and classic ASP.
- Other minor improvements and bug fixes.
New in Bytescout Spreadsheet SDK 2.7.5.1568 (Nov 28, 2016)
- Improved support for malformed XLS files
- Fixed bug in ODS files loading
- Other minor improvements and bug fixes
New in Bytescout Spreadsheet SDK 2.41.1396 (Apr 22, 2015)
- reading and writing of XLS files improved
- Windows CE and Pocket PC minor issues fixed
- new "Save As PDF" source code sample
- new "Insert Page Break" source code sample
- new "Add Header And Footer" sample
- PHP sample added
- minor bug-fixes and speed improvements
New in Bytescout Spreadsheet SDK 2.40.1358 (Sep 11, 2014)
- improved handling of incorrect formula values while calculating
- CSV to XLS samples updated
- improved XLS format handling
- license updated
- minor fixes
New in Bytescout Spreadsheet SDK 2.40.1346 (Apr 15, 2014)
- read xls, write xls, read csv, read xlsx, write xlsx in .NET and ASP.NET
- .NET 4.50 dlls added
- Visual Studio 2013 support improved
- XLSX and XLS writing improved
- Index Out Of Range error fixed
- Formula calculation improved
- new Worksheet.SaveAsTXT, SaveAsCSV, SaveAsXML methods with encoding selection
- number formatting related issues fixes
- minor bug-fixes
New in Bytescout Spreadsheet SDK 2.40.1314 (Apr 15, 2014)
- read xls, write xls, read xlsx, write xlsx in .NET and ASP.NET
- improved formulas calculation errors handling
- Calculation with OLE links improved
- issues with MAX(), ROUNDUP() functions calculation fixed
- XLSX reading and writing improved
- new sample: Merge Cells and Set Alignment
- PHP source code sample added
- support for CSV with Unicode symbos added
- minor bug-fixes
New in Bytescout Spreadsheet SDK 2.30.1287 (May 14, 2013)
- Read xls and write xls .net better with new version
- Improved xls and xlsx support
- Minor issues fixed
New in Bytescout Spreadsheet SDK 2.30.1283 (Apr 1, 2013)
- Read and write Excel files from .NET with this new version; improved XLSX support
- Simplified licensing: now there are only 2 major type of licenses (for desktop and for web apps)
- Minor issues fixed
New in Bytescout Spreadsheet SDK 2.30.1276 (Feb 28, 2013)
- Improved support for shared formulas in XLSX format
- AutoFit fixes minor issues related to image sizes
- new property: Worksheet.AutoFitRows to enable auto fit for rows
- issue fixed related to unlocked ranges on protected worksheets
- improved Windows 7 and Windows 8 compatibility
New in Bytescout Spreadsheet SDK 2.30.1256 (Nov 1, 2012)
- Reading excel files from .NET improved
- New methods to load data into selected worksheet directly
- XLSX and formula calculation: now library throws exception in case formula can not be parsed for some reason
- Minor bug-fixes
New in Bytescout Spreadsheet SDK 2.30.1237 (Sep 29, 2012)
- Spreadsheet SDK range class improved, now provides .SpecialCells functionality
- Exceptions handling improved
- Adding image to spreadsheet document source code sample fixed
- Fixing issues with some formulas in XLSX format
New in Bytescout Spreadsheet SDK 2.30.1183 (Jun 1, 2012)
- important security update
- minor bug-fixes
New in Bytescout Spreadsheet SDK 2.30.1162 (Jun 1, 2012)
- view spreadsheet in your application: now includes SpreadsheetControl for WinForms to view spreadsheets in WinForms applications!
- RangeSort sample has been added
- View Spreadsheet sample added
- improved support for sandboxed environments
- improved stability
- minor bug-fixes
New in Bytescout Spreadsheet SDK 2.30.1106 (Jun 1, 2012)
- improved speed
- improved memory usage
- minor issues with XLSX format fixed
- improved HTML export
- updated documentation (offline and online), now includes full set of source code samples for the SDK
- minor bug-fixes and improvements
New in Bytescout Spreadsheet SDK 2.30.980 (Oct 5, 2011)
- Read Excel, write to Excel files functionality improved; now with 12 chart types support;
- compatibility with Security-Transparent feature of .NET 4.0;
- export to CSV and TXT speed improved for large sets of data;
- exposed Pictures and PictureShape are available through COM interfaces now.
New in Bytescout Spreadsheet SDK 2.30.832 (May 27, 2011)
- Read Excel, write to Excel files functionality improved;
- .NET 4 and Visual Studio 2010 support added;
- methods to import from and export to 2D arrays, jagged arrays, Data Grids, Data Tables, Lists were added;
- saving to PDF added;
- class ViewOptions (Worksheet.ViewOptions) provides new properties.
New in Bytescout Spreadsheet SDK 2.11.252 (Jul 14, 2009)
- now you can use Spreadsheet SDK component from the Toolbox in WinForms and ASP.NET applications
- minor bug-fixes in CSV export support
- minor improvements in installer
- .NET 2.00 dll can work as ActiveX now as well as .NET 1.10 version of the dll
- documentation updates
New in Bytescout Spreadsheet SDK 2.11.249 (Jul 14, 2009)
- important memory leaks were fixed
New in Bytescout Spreadsheet SDK 2.11.241 (Jul 14, 2009)
- minor bug-fixes in formula calculations engine
- HTML export minor bug-fixes
New in Bytescout Spreadsheet SDK 2.11.237 (Jul 14, 2009)
- bug fixed: handle to the file is not released after the exception
- bug fixed with broken text in some spreadsheets
- CONCATENATE formula function support has been added
- XLSX reading has been improved
- HTML export functionality has been greatly improved
New in Bytescout Spreadsheet SDK 2.11.226 (Jul 14, 2009)
- minor bug-fixes in XLSX reading support
New in Bytescout Spreadsheet SDK 2.11.219 (Jul 14, 2009)
- minor bug-fixes in XLSX support
New in Bytescout Spreadsheet SDK 2.11.213 (May 29, 2009)
- message while opening XLS in Excel fixed
- new Spreadsheet.Options class
- XLS files protection support for worksheets (see Worksheet.Protected, Worksheet.Protect and .UnProtect)
- Bytescout.Spreadsheet.BaseClasses.Gridline renamed into .GridLineColor
- Bytescout.Spreadsheet.BaseClasses.GridLinesColor renamed into .GridLineColorEnabled
- Bytescout.Spreadsheet.Constants.AlignmentHorizontal.CentredSelect renamed into .ÑenteredSelect
- new .RangeSelectionMethod property to control how selection works with merged cells while using .CopyAndPaste and .CopyInto methods
- ActiveX interface support (to use from VBScript, Javascript, Visual Basic 6)
- SDK now comes with the Dashboard
- minor bug-fixes and improvements
- documentation updates and new samples
New in Bytescout Spreadsheet SDK 1.40 (Oct 16, 2008)
- XLSWorkBook.Properties added to work with SummaryInformation structure to write and read XLS document properties
- Cell.NumberFormat property reading support
- Minor bug-fixes in negative values reading
New in Bytescout Spreadsheet SDK 1.32.2 (Jul 26, 2008)
- Advanced samples for VB.NET were added (see /Examples/Advanced Examples/ folder
- Minor bug-fixes
- Minor documentation updates
New in Bytescout Spreadsheet SDK 1.32.1 (Jul 3, 2008)
- Minor bug-fixes in XLS writing support.
- New samples in the documentation.
New in Bytescout Spreadsheet SDK 1.32 (Jun 26, 2008)
- Bug fixed with file blocking while using existing spreadsheet file to read from
- Improved XLS format support (for XLS produced by Open Office)
- Minor bug-fixes
New in Bytescout Spreadsheet SDK 1.30.4 (May 13, 2008)
- New methods for Range, Cell, Column, Row classes
- Worksheet.Active property added to select the worksheet selected by default
- bug with non-selected worksheets while writing XLS fixed
- updated documentation
- XLSX (Excel 2007) handling improved
- CSV and ODS (Open Office) support improved
- minor bug-fixes