What's new in Spire.XLS 14.3.3 Hotfix
Mar 18, 2024
- New feature
- Supports PivotTable grouping function.
- Supports adding FindAll() method to CellRange.
- Supports setting "Repeat All Item Labels" for PivotTable.
- Bug:
- Fixes the issue that the content was incorrect after saving Excel files.
- Fixes the issue that the sheet content exported using ExportDataTable was incorrect.
- Fixes the issue that formula values were incorrect when converting Excel to PDF.
- Fixes the issue that the program threw "Size of image is too large" exception when converting Excel to images.
- Fixes the issue that the PivotTable column names were inconsistent when converting Excel to pictures.
- Fixes the issue that there were some extra blank comments in result files after using CellRange.Comment.Text.
- Fixes the issue that the styles were incorrect when converting Excel to PDF.
- Fixes the issue that the program threw "ArgumentNullException" exception when loading files.
- Fixed the issue that the program threw "NullReferenceException" exception when splitting a document.
New in Spire.XLS 14.2.1 Hotfix (Feb 5, 2024)
- New feature:
- Supports setting the clipping position of header and footer images.
- Bug:
- Fixes the issue that the comments in the resulting document were not displayed in Office365 after calling the cellRange.ClearContents() method.
- Fixes the issue that when the sheet name contained the special character t, the t was read as x0009.
- Fixes the issue that the content was incorrect when converting XLSX documents to PDF documents.
- Fixes the issue that the application threw "System.ArgumentException" when converting XLSX documents to PDF documents
- Fixes the issue that the text content was overlapped when converting XLSX documents to images.
- Fixes the issue that the "Operation is not supported on this platform" exception occurred when deploying the .netstand2.0 dlls on the .NET7.0 platform.
New in Spire.XLS 14.1 (Jan 5, 2024)
- Bug SPIREXLS-4838 Fixes the issue that it threw System.IndexOutOfRangeException and System.NullReferenceException exceptions when converting worksheets to HTML documents in multi-threaded parallel.
- Bug SPIREXLS-4899 Fixes the issue that the VLOOKUP function was parsed incorrectly.
- Bug SPIREXLS-4969 Fixes the issue that the obtained transparency value of cell color was incorrect.
- Bug SPIREXLS-4972 Fixes the issue that the contents were overlapped after converting Excel to PDF.
- Bug SPIREXLS-4974 Fixes the issue that the program threw System.ArgumentNullException when loading documents.
- Bug SPIREXLS-4980 Fixes the issue that the program threw "Shape failing to render!" exception when converting Excel to PDF.
- Bug SPIREXLS-4993 Fixes the issue that the program threw System.NullReferenceException when merging excel documents.
- Bug SPIREXLS-4998 Fixes the issue that filling MarkerDesigner templates with data failed.
- Bug SPIREXLS-5000 Fixes the issue that the program threw System.ArgumentOutOfRangeException when verifying the validity of data after deleting rows.
- Bug SPIREXLS-5004 Fixes the issue that the calculation of some formulas failed.
- Bug SPIREXLS-5005 Fixes the issue that the signature time of the added digital signature was 8 hours later than the actual time.
- Bug SPIREXLS-5009 Fixes the issue that the reading of CLEAN formulas failed.
- Bug SPIREXLS-5015 Fixes the issue that the program threw System.FormatException exception when loading a document.
- Bug SPIREXLS-5019 Fixes the issue that the program threw "Cannot read that as a ZipFile" exception when reading HTML documents.
New in Spire.XLS 13.12 (Dec 12, 2023)
- We are delighted to announce the release of Spire.XLS 13.12. This version enhances the conversion from Excel to PDF. Besides, many known issues are fixed in this version, such as the issue that the calculation of some formulas failed.
New in Spire.XLS 13.10.1 Hotfix (Nov 24, 2023)
- We are excited to announce the release of Spire.XLS 13.10.1. This version improves the efficiency of Excel to PDF conversion and supports customizing the names of pivot table fields. It also enhances the conversion from Excel to HTML. Moreover, some known issues are fixed in this version, such as the issue that deleted annotations were not removed successfully from the document
New in Spire.XLS 13.8.9 Hotfix (Aug 25, 2023)
- New feature:
- Supports customizing the paper size without scaling the content during printing.
- Supports adding Signature Line.
- Supports getting shapes in sheets.
- Bug:
- Fixes the issue that the program threw an exception when creating HIPERVINCULO formulas in a Spanish environment.
- Fixes the issue that the program threw a "NullReferenceException" when loading an Excel document created by the new version of WPS.
- Fixes the issue that the slicer was lost after saving Excel.
- Fixes the issue that after splitting Excel documents, the generated file prompted the message that the content has error when opening in Microsoft Excel.
- Fixes the issue that the program threw "NullReferenceException" when loading Excel documents.
New in Spire.XLS 13.8.0 Hotfix (Aug 2, 2023)
- Supports setting paper size to DIN A0.
- Supports grayscale printing.
- Optimized performance for converting xlsx to HTML with long processing time and high memory consumption.
- Fixes the issue that the charts were missing when converting Excel to images.
- Fixes the issue that the content was incorrect when converting shapes to images.
- Fixes the issue that the application threw System.Security.Cryptography.CryptographicException: "Invalid algorithm specified" when performing digital signature.
- Fixes the issue that involved failed font replacement.
- Fixes the issue that the style changed after modifying text in a shape.
- Fixes the issue that the borders were changed after setting number formats for multiple cells.
- Fixes the issue that the week calculation was incorrect when converting Excel to PDF.
- Fixes the issue that the PrstGeomShapes collection was not updated after removing shapes.
- Fixes the issue that there was an extra top border in the converted Excel to PDF.
- Fixes the issue that the conditional formatting for cells failed to retrieve.
- Fixes the issue that the content was inconsistent when converting Excel to PDF.
New in Spire.XLS 13.7.0 Hotfix (Jul 4, 2023)
- Supports NETWORKDAYS.INTL function.
- Fixed the issue that the added numbers were displayed as date format.
- Fixed the issue that the content was incorrect after converting a chart to an image.
- Fixed the issue that the top border of cells at page breaks was not printed.
- Fixed the issue that the program threw "ArgumentOutOfRangeException" exception when deleting shapes.
- Fixed the issue that it didn't work when changing the font color of a specific row in a pivot table.
- Fixed the issue that changing the font in a pivot table didn't work.
- Fixed the issue that dashed lines missed after converting Excel to HTML.
- Fixed the issue that the program threw "NullReferenceException" when executing the CalculateAllValue() method.
- Fixed the issue that the filter button didn’t work after adding a filter to the merged cells.
- Fixed the issue that the number of remaining rows was incorrect after deleting rows.
- Fixed the issue that the format was incorrect when exporting data using worksheet.ExportDataTable() method.
New in Spire.XLS 13.6.0 Hotfix (Jun 6, 2023)
- Adds two methods to realize the movement of chartsheets and worksheets between positions.
- Adds the method to optimize the speed of deleting rows.
- Fixes the issue that the pivot table fields were displayed as "Column Labels" after converting a sheet to images.
- Fixes the issue that the chart data was not refreshed when converting an XLSX document to PDF.
- Fixes the issue that the setting on top function does not take effect when adding a text box.
- Fixes the issue that the table styles were incorrect when converting an XLSX document to PDF.
- Fixes the issue that the application threw” Syste.OverflowException” when loading an XLS document.
- Fixes the issue that the data format of retrieved cells was incorrect.
- Fixes the issue that the application threw "System.FormatException” when adding HTML content.
- Fixes the issue that the chartsheets could not be obtained after calling the MoveWorksheet method twice.
- Fixes the issue that the text exceeds the cell after setting AutoFitColumns when the cell contains Chinese characters.
- Fixes the issue that the background colors were inconsistent when converting an XLSX document to HTML.
- Fixes the issue that the program reported an error "This structured storage version is not supported." when loading an XLS document.
- Fixes the issue that the style of an added HTML strong tag was not recognized.
New in Spire.XLS 13.5.6 Hotfix (May 31, 2023)
- Supports EVALUATE function in WPS.
- Fixed the issue that System.ArgumentException exception was thrown in concurrent conversion of worksheets to HTML program.
- Fixed the issue that when filling some cells with color, other cells are also filled.
- Fixed the issue that it failed to copy some cells.
- Fixed the issue that System.OutOfMemoryException exception was thrown when converting Excel to HTML.
- Fixed the issue that System.IndexOutOfRangeException exception was thrown when loading Excel files.
- Fixed the issue that function area of the menu bar was incorrect after saving the document.
- Fixed the issue that many blank columns were generated after deleting hidden rows.
- Fixed the issue that the content was incorrect when using .Net Standard package to convert sheets to images.
- Supports WORKDAY.INTL function.
- Supports ISO.CEILING function.
New in Spire.XLS 13.4.0 Hotfix (Apr 10, 2023)
- Fixes the issue that the content format was incorrect after converting Excel to HTML.
- Fixes the issue that it failed to get text of checkbox.
- Fixes the issue that the legend order was incorrect after converting chart to image.
- Fixes the issue that the format of dropdown box was incorrect after converting Excel to ODS.
- Fixes the issue that getting the FirstColumn returned incorrect value.
- Fixes the issue that the date format was incorrect after converting Xml to Excel.
- Fixes the issue that it failed to clear the "inconsistent formula" error prompt.
- Fixes the issue that the shape was lost after converting Excel to PDF.
- Fixes the issue that the effect was incorrect after setting the border style.
- Fixes the issue that the application threw an exception when loading an Excel in which the sheet name contains the character "#".
- Fixes the issue that using the method (firstSheet.PageSetup.DifferentFirst = 0) to cancel different header on the first page didn't take effect.
- Fixes the issue that it failed to autofit row height.
New in Spire.XLS 13.2.4 Hotfix (Feb 16, 2023)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 13.1.1 Hotfix (Jan 17, 2023)
- Bug SPIREXLS-1105 Fixes the issue that the program threw “Maximum number of extended formats exceeded”when using sheet1.CopyFrom(sheet2) method to copy the content of sheets.
- Bug SPIREXLS-4310 Fixes the issue that the program threw System.ArgumentException when loading an HTML file with UTF8.
- Bug SPIREXLS-4320 Fixes the issue that the bar charts protruded from the left of the axis when converting charts to images.
- Bug SPIREXLS-4334 Fixes the issue that the program threw System.Xml.XmlException when converting XLS files to XLSX files.
- Bug SPIREXLS-4338 Fixes the issue that CopyRangeOptions copyOptions = CopyRangeOptions.OnlyCopyFormulaValue; didn't work.
- Bug SPIREXLS-4358 Fixes the issue that the program threw System.ArgumentOutOfRangeException when deleting sheets.
- Bug SPIREXLS-4365 Fixes the issue that macros lost after loading and saving an XLSM file.
- Bug SPIREXLS-4373 Fixes the issue that the menu functions were incorrect after protecting document.
- Bug SPIREXLS-4375 Fixes the issue that calculating the formulas failed.
- Bug SPIREXLS-4381 Fixes the issue that the calculated formulas' value was incorrect.
- Bug SPIREXLS-4384 Fixes the issue that the date format was incorrect when converting Excel to PDF.
New in Spire.XLS 12.12.3 Hotfix (Dec 23, 2022)
- New feature:
- Supports CEILING.MATH formula.
- Supports BITOR formula.
- Supports BITAND formula.
- Supports BITLSHIFT formula.
- Supports BITLSHIFT formula.
- Supports BITRSHIFT formula.
- Supports grouping shape.
- Supports "SHA-512" encryption scheme.
- Supports setting the layout pattern of the entire pivot table.
- Bug:
- Fixes the issue that the border and the style of table lost after converting HTML to Excel.
- Fixes the issue that the program threw System.NullReferenceException when getting the color of conditional formatting.
- Fixes the issue that the content had an extra comma after converting chart to images.
- Fixes the issue that the program did not throw an error when decrypting excel file with a wrong password.
- Fixes the issue that there were blank columns after deleting hidden columns.
- Fixes the issue that the content of the result document was different from that of the original document after the document was loaded and saved.
- Fixes the issue that the double quotation marks were incorrect after converting Excel to CSV.
- Fixes the issue that the result of the cell range calculation was incorrect.
- Fixes the issue that the program threw an error "Unknown font" when getting RTF text of cell range.
- Fixes the issue that the program threw an error "Shapes fail to be rendered" when converting Excel to PDF.
- Fixes the issue that the program threw System.OutOfMemoryException when converting Excel to PDF.
- Fixes the issue that the format was inconsistent after converting HTML to Excel.
- Fixes the issue that the slicers lost after saving files as stream.
- Fixes the issue that there was a prompt of content error when opening the saved document after OS language area was changed.
- Fixes the issue that the program threw System.NullReferenceException when copying sheets.
New in Spire.XLS 12.9.2 Hotfix (Sep 23, 2022)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 12.8.1 Hotfix (Aug 16, 2022)
- Supports setting whether to keep the number format of the data when exporting to DataTable.
- 1ExportTableOptions options = new ExportTableOptions();
- 2options.KeepDataFormat = false;
- 3DataTable table = sheet.ExportDataTable(1, 1, sheet.LastDataRow, sheet.LastDataColumn, options);
- Supports calculating "UNICODE" formulas.
- Fixes the issue that the column names of the pivot table were offset after converting Excel to PDF.
- Fixes the issue that "System.FormatException: Input string was not in a correct format" was thrown when loading HTML files
- Fixes the issue that "System.FormatException: Input string was not in a correct format" was thrown when loading HTML files
- Fixes the issue that "CellRange.DisplayedText" property getting incorrect value.
- Fixes the issue that "System.FormatException: The string is not recognized as a valid DateTime" exception was thrown when converting Excel to PDF.
- Fixes an issue that the application threw a null pointer exception when getting the name manager for a non-contiguous range.
New in Spire.XLS 12.7.1 Hotfix (Jul 13, 2022)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 12.6.1 Hotfix (Jun 13, 2022)
- Provides an overload of InsertArray method, which supports setting whether to automatically convert date string to datetime format when inserting arrays into Excel document.
- InsertArray(object[,] objectArray, int firstRow, int firstColumn, bool needConvert);
- Fixes an issue that the application threw "Invalid file format" when loading XML.
- Fixes an issue that after inserting a picture with remote address into Excel and converting to PDF, the picture was lost.
- Fixes an issue that caused incorrect scaling ratio after inserting a picture into Excel.
- Fixes an issue that the obtained number value of cell in new version was incorrect.
- Fixes an issue that the application threw "Value was either too large or too small for a Double" when converting Excel to PDF.
New in Spire.XLS 12.5.3 Hotfix (May 26, 2022)
- New feature:
- IPrstGeomShape Implements the style of centered text.
- Bugs fixed:
- Optimizes the time and amount of memory used to format cell numbers.
- Fixed an issue that the chart content was incorrect when converting Excel to PDF.
- Fixed an issue that the grid lines' style changed from solid to dotted when converting Excel to PDF.
- Fixed an issue that the application threw System.ArgumentException when converting Excel to HTML.
- Fixed an issue that the formatting of content was incorrect when converting Excel to PDF.
- Fixed an issue that the double quotes were added to text when converting Excel to CSV.
- Fixed an issue that the data was not correct when transferring Excel data to a data table.
- Fixed an issue that the data was incorrect when adding data using sheet.insertarrayList method.
- Fixed an issue that the application threw InvalidOperationException when loading an xlsx file.
- Fixed an issue that the application threw an error "object reference not set to an instance of object" when loading an xlsx file.
- Fixed an issue that the application threw an error "different formulas in the copied rows" when calling workbook.ActiveSheet.ReparseFormula().
- Fixed an issue that the value obtained was incorrect.
New in Spire.XLS 12.5.1 Hotfix (May 16, 2022)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 12.4.1 Hotfix (Apr 15, 2022)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 12.3.8 Hotfix (Mar 23, 2022)
- New feature:
- Supported that setting content to fit page width when converting Excel to PDF.
- Bug:
- Fixed the incorrect pagination issue when printing Excel.
- Fixed the issue that the program threw NullReferenceException when setting the active cell (sheet.SetActiveCell(cell)).
- Fixed the issue that it was inconsistent between converted date format and system settings when converting Excel to PDF.
- Fixed the issue that the program threw IndexOutOfRangeException when assigning a value to a cell.
- Fixed the issue that there were extra blank lines in cell when converting Excel to PDF.
New in Spire.XLS 12.3.2 Hotfix (Mar 4, 2022)
- Bug:
- Fixes the issue that the lines were thicker after converting Excel to PDF.
- Fixes the issue that the font size and borders were changed after converting Excel to PDF.
- Fixes the issue that the content was incorrect after converting Excel to PDF.
- Fixes the issue that the application was interrupted even it catched the “NullReferenceException”
- Fixes the issue that some text did not apply the set default font and size.
- Fixes the issue that it failed to add DataValidation for a .xlsb file.
- Fixes the issue that the application threw "Object reference not set to an instance of an object" when converting XLSX to PDF with multithreading.
- Fixes the issue that the data label of Pie chart was incorrect after converting Excel to PDF.
- Optimizes the memory consumption when setting styles for cell range.
- Fixes the issue that the chart position was incorrect after converting Excel to Html.
- Fixes the issue that the separator of CSV file was different when invoking the CurrentCulture setting code at different position.
- Fixes the issue that it were not take effect to set the wrap text and auto fit rows for the columns merged cells.
- Fixes the issue that the formula calculation was failed.
- Fixes the issue that the application printed out the extra '0' character when converting Excel to PDF.
- Fixes the issue that the application threw "System.FormatException" when loading an Excel file.
New in Spire.XLS 12.1 (Jan 24, 2022)
- New feature:
- SPIREXLS-1845:
- Workbook workbook = new Workbook();
- workbook.LoadFromFile(@"input.xlsx");
- Worksheet sheet = workbook.Worksheets[0];
- sheet.Range["A1"].HtmlString = "<div>xxxx<br>yyyy</div>";
- SPIREXLS-3586:
- Supports setting Html string for cell range:
- Workbook workbook = new Workbook();
- workbook.LoadFromFile(@"input.xlsx");
- Worksheet worksheet = workbook.Worksheets[0];
- PivotTable table = worksheet.PivotTables[0] as PivotTable;
- PivotConditionalFormatCollection pcfs = table.PivotConditionalFormats;
- PivotConditionalFormat pc = pcfs.AddPivotConditionalFormat();
- IConditionalFormat cf = pc.AddCondition();
- cf.FormatType = ConditionalFormatType.ContainsBlanks;
- cf.FillPattern = ExcelPatternType.Solid;
- cf.BackColor = Color.Red;
- SPIREXLS-3598:
- Supports adding file stream to IsPasswordProtected():
- bool havepwd = Workbook.IsPasswordProtected(File.OpenRead(inputFile));
- var docBytes = File.ReadAllBytes(inputFile);
- MemoryStream ms = new MemoryStream(docBytes);
- bool havepwd = Workbook.IsPasswordProtected(ms);
- SPIREXLS-3614:
- Supports getting the linked cell name of IPrstGeomShape:
- Workbook book = new Workbook();
- book.LoadFromFile("input.xlsx");
- Worksheet sheet = book.Worksheets["sheet1"];
- PrstGeomShapeCollection prstGeomShapeCollection = sheet.PrstGeomShapes;
- IPrstGeomShape shape = prstGeomShapeCollection["a"];
- shape.LinkedCell.RangeAddressLocal;
- SPIREXLS-3630:
- Supports calculating a single sheet or a cell range:
- Workbook workbook = new Workbook();
- workbook.LoadFromFile("input.xlsx");
- workbook.Worksheets[0].CalculateAllValue();
- workbook.Worksheets[0].Range["A1：C3"].CalculateAllValue();
- Bug:
- SPIREXLS-3199, SPIREXLS-3217, SPIREXLS-3573:
- Fixes the issue that the content was incorrect after saving chart to image.
- SPIREXLS-3330:
- Fixes the issue that the content format was incorrect when converting html file to excel.
- SPIREXLS-3489, SPIREXLS-3601, SPIREXLS-3619, SPIREXLS-3643:
- Fixes the issue that the content was incorrect after converting excel file to PDF.
- SPIREXLS-3546:
- Fixes the issue that the result file has opening error after copying a pivot table sheet to another sheet
- SPIREXLS-3551:
- Fixes the issue that the boder lost after converting excel file to ODF.
- SPIREXLS-3552:
- Optimizes the time consumption when saving chart to image.
- SPIREXLS-3558:
- Fixes the issue that the content was incorrect after saving sheet to Html.
- SPIREXLS-3559:
- Fixes the issue that the application threw "System.FormatException" when converting Excel file to PDF.
- SPIREXLS-3572:
- Fixes the issue that the result file was blank after converting Html to Excel.
- SPIREXLS-3577:
- Fixes the issue that the table column width setting didn't take effect when converting Excel to PDF.
- SPIREXLS-3588:
- Fixes the issue that the row height changed after merged the cells that have been set a row height.
- SPIREXLS-3589:
- Fixes the issue that the content was incorrect after converting Excel to Html.
- SPIREXLS-3597:
- Fixes the issue that the application threw an Exception when converting Excel file to PDF in multi-threading.
- SPIREXLS-3603:
- Fixes the issue that the content format was incorrect after converting Excel to Html.
- SPIREXLS-3606:
- Fixes the issue that the application hung a long time when adding two subtotal for worksheet.
- SPIREXLS-3610:
- Fixes the issue that the application threw "System.ArgumentOutOfRangeException" when adding SparklineGroup.
- SPIREXLS-3613:
- Fixes the issue that only the last signature remained after doing multiple signatures.
- SPIREXLS-3615:
- Fixes the issue that the application threw "IOException" when using IsPasswordProtected().
- SPIREXLS-3616:
- Fixes the issue that the obtained value of IPrstGeomShape was incorrect.
New in Spire.XLS 11.12.2 Hotfix (Dec 17, 2021)
- New feature:
- Supports setting the border of IPrstGeomShape
- PrstGeomShape triangle = sheet.PrstGeomShapes.AddPrstGeomShape(2, 2, 100, 100, PrstGeomShapeType.Triangle);
- Bug:
- ixes the issue that it didn't take effect after setting IsWrapText () for a PivotTable cell.
- Fixes the issue that the effect was incorrect after adding an oval shape to the chart.
- Fixes the issue that the errorbar position was incorrect when converting excel file to PDF.
- Fixes the issue that the font changed when converting excel file to PDF.
- Fixes the issue that it didn't take effect when using AutoFitRows().
- Fixes the issue that the text wrap was incorrect when converting excel file to PDF.
- Fixes the issue that the application threw "System.OutOfMemoryException" when converting excel file to PDF.
- Fixes the issue that the content format was incorrect when converting excel file to PDF.
- Fixes the issue that the application threw an exception when converting excel file to PDF.
- Fixes the issue that the content was lost when converting excel file to PDF.
- Fixes the issue that the application threw "System.StackOverflowException" when using CalculateAllValue().
- Fixes the issue that the content of generated xls file was incorrect after using InsertArray() to fill data.
New in Spire.XLS 11.11.2 Hotfix (Nov 25, 2021)
- Supports to set border for data bar of chart.
- XlsConditionalFormats cfs = sheet.ConditionalFormats[0];
- IConditionalFormat cf = cfs[0];
- Spire.Xls.DataBar dataBar1 = cf.DataBar;
- DataBar1.BarBorder.Type = Spire.Xls.Core.Spreadsheet.ConditionalFormatting.DataBarBorderType.DataBarBorderSolid;
- DataBar1.BarBorder.Color = Color.GreenYellow;
- Supports to set drop lines for line chart and area chart.
- Chart.Series[0].HasDroplines = true;
- Supports to set the customized page size when converting an excel file to pdf.
- Workbook.Worksheets[0].PageSetup.SetCustomPaperSize(width, height)
- Fixes the issue that the location of picture was incorrect when converting an excel file to html
- Fixes the issue that the content was clipped when converting an excel file to pdf file
- Fixes the issue that the content was incorrect when converting a combination chart to image
- Fixes the issue that the application hung when loading an ods file
- Fixes the issue that the content was incorrect when converting an excel file to pdf
- Fixes the issue that MS Excel failed to open the saved xlsx file
New in Spire.XLS 11.10.5 Hotfix (Oct 27, 2021)
- Fixes the issue that the content was incorrect when converting Excel to PDF.
- Fixes the issue that the application threw an error "Invalid LegendPositionType string val" when loading an .xlsx file.
- Fixes the issue that the combination chart type was not got incorrectly.
- Fixes the issue that the application threw the System.ArgumentOutOfRangeException when copying worksheets.
- Fixes the issue that the lines lost when converting Excel to PDF.
- Fixes the issue that the application hanged when loading an .xls file.
- Fixes the issue that setting the end of the chart's error line did not work.
- Fixes the issue that the application threw an error "Cannot read that as a ZipFile" when loading an HTML file.
- Fixes the issue that the application threw an error "You cannot Write() data for an entry that is a directory" when saving to an .xlsm file.
- Fxies the issue that the application threw an error 'Invalid MsoLineDashStyle string val' when loading an .xlsx file.
- Fixes the issue that some characters lost when converting an .xlsx to PDF.
- Fixes the issue that that the application threw an error "Object reference is not set to an instance of an object." when converting an .xlsx to PDF.
- Fixes the issue that the max rows and columns obtained were wrong after adding some new data.
- Fixes the issue that the application hanged when loading an .ods file.
- Fixes the issue that setting the transparent background color of the cell did not take effect
New in Spire.XLS 11.10.4 Hotfix (Oct 25, 2021)
- Bug:
- Fixes the issue that the content was incorrect when converting Excel to PDF.
- Fixes the issue that the application threw an error "Invalid LegendPositionType string val" when loading an .xlsx file.
- Fixes the issue that the combination chart type was not got incorrectly.
- Fixes the issue that the application threw the System.ArgumentOutOfRangeException when copying worksheets.
- Fixes the issue that the lines lost when converting Excel to PDF.
- Fixes the issue that the application hanged when loading an .xls file.
- Fixes the issue that setting the end of the chart's error line did not work.
- Fixes the issue that the application threw an error "Cannot read that as a ZipFile" when loading an HTML file.
- Fixes the issue that the application threw an error "You cannot Write() data for an entry that is a directory" when saving to an .xlsm file.
- Fxies the issue that the application threw an error 'Invalid MsoLineDashStyle string val' when loading an .xlsx file.
- Fixes the issue that some characters lost when converting an .xlsx to PDF.
- Fixes the issue that that the application threw an error "Object reference is not set to an instance of an object." when converting an .xlsx to PDF.
- Fixes the issue that the max rows and columns obtained were wrong after adding some new data.
- Fixes the issue that the application hanged when loading an .ods file.
- Fixes the issue that setting the transparent background color of the cell did not take effect
New in Spire.XLS 11.9.3 Hotfix (Sep 16, 2021)
- Supports converting Excel to UOS
- Supports converting Excel to OFD
New in Spire.XLS 11.9.2 Hotfix (Sep 14, 2021)
- New feature:
- Setting the "Values" field generated by the pivot table in Excel as a row label.
- Supports converting group pictures/charts into an image.
- Bugs:
- Fixes the issue that the content in the chart was incorrect after converting Excel to SVG files or images.
- Fixes the issue that the generated image was incomplete after converting Excel to SVG files.
- Optimizes the content layout of converting HTML to Excel.
- Fixes the issue that the generated image was incorrect after converting charts in Excel to images.
- Fixes the issue that the generated image was incorrect after converting charts in Excel to images.
- Fixes the issue that the program threw an exception when converting Excel to EMF streams.
- Fixes the issue that the IsPasswordProtected() method only returned "true" after converting .XLSX files to .XLS formats.
- Fixes the issue that the program threw an exception when using the CalculateAllValue() method.
- Fixes the issue that the vertical page breaks in the generated file was incorrect after converting Excel to PDF.
- Fixes the issue that the fonts used in the generated file was different with the original file after converting Excel to PDF.
- Fixes the issue that the program threw an exception when getting the data range of the chart in Excel files.
- Fixes the issue that the filter of the pivot table in Excel did not take effect after changing it.
- Fixes the issue that the program threw an exception when converting Excel to PDF.
New in Spire.XLS 11.8.0 Hotfix (Aug 6, 2021)
- New feature:
- Supports converting SmartArt/shapes to images.
- Supports loading and saving files in et/ett formats.
- Bug:
- Fixes the issue that the chart was incorrect after converting XLSX to PDF.
- Fixes the issue that the pagination was incorrect after converting XLS to PDF.
- Fixes the issue that the application threw the error "ArgumentExcep" when creating multiple Workbook instances through multiple threads.
- Fixes the issue that the content was incorrect after updating the PivotTable and then converting to PDF.
- Fixes the issue that there were large spacing between paragraphs after converting Excel to PDF.
- Fixes the issue that the formulas were not calculated correctly after converting XLS to PDF.
- Fixes the issue that the application threw the error "Can't delete row because it's in array" when deleting rows.
- Fixes the issue that there were garbled characters after converting HTML to XLSX.
- Fixes the issue that the method CopyTheme did not copy the theme fonts.
- Fixes the issue that the application threw the error "Input string was not in a correct format" when loading the XLSX file.
- Fixes the issue that the content was incorrect after converting HTML to Excel.
- Fixes the issue that the image was missing after converting XLS to PDF.
- Fixes the issue that the application threw the error "Cannot read that as a ZpiFile" when loading the file.
- Optimizes the time for inserting DataTable.
New in Spire.XLS 11.7.0 Hotfix (Jul 8, 2021)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 11.6 (Jun 3, 2021)
- Optimization:
- Optimizes the speed of converting Excel to HTML.
- New feature:
- Supports calculating newly added CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN of MS Excel2019.
- Supports the function of not displaying the title of bubble chart.
- Supports the function of removing the borders of pictures.
- Supports the function of converting shape to picture.
- Supports the function of compressing pictures in Excel.
- Bug:
- Fixes the issue that getting the chart title failed.
- Fixes the issue that the date data was incorrectly wrapped when converting Excel to PDF.
- Fixes the issue that the application threw System.OverflowException when loading file.
- Fixes the issue that the application threw System.ArgumentOutOfRangeException when loading and saving files.
- Fixes the issue that the data bar of the conditional format was not displayed correctly when converting Excel to PDF.
- Fixes the issue that creating a pivot table failed in the environment with Win10 64-bit and Italy region setting.
- Fixes the issue that the text boxes could not be copied correctly.
- Fixes the issue that the text font indentation was changed from condensed to standard when copying cell content.
- Fixes the issue that the application hung when converting Excel to Html.
- Fixes the issue that the format of date data was incorrect when importing sheet data to data table.
- Fixes the issue that inserting and deleting rows took a long time.
- Fixes the issue that the data of the category label in the chart was incorrect when saving the chart to images.
- Fixes the issue that the characters were garbled when converting CSV file with Turkish ISO-8859-9 encoding to xlsx file.
New in Spire.XLS 11.4.6 Hotfix (May 1, 2021)
- New feature:
- Supports getting printer customized paper size and setting it to worksheets.
- Bug fixes:
- Fixes the issue that the program threw an exception "Unhandled Exception" when converting Excel to PDF in xamarin android applications.
- Fixes the issue that the program threw an exception "Invalid pivot table data source" when converting Excel to PDF
- Fixes the issue that there were multiple lines of spaces in the data after calling Filter().
- Fixes the issue that copying formula to cell range failed to take effect.
- Fixes the issue that the converted PDF content was not displayed correctly after embeding the IDAutomationHC39M font
- Fixes the issue that the program threw an exception "System.NullReferenceException" when calling "chart.PrimaryCategoryAxis.IsAutoMin = false".
- Fixes the issue that the x-axis coordinate arrangement wasn't correct in the created Chart.
- Fixes the issue that the formula changed after loading and saving an Excel document.
New in Spire.XLS 11.4.0 (Apr 6, 2021)
- New Feature:
- Supports setting the shape order.
- Wb.Worksheets[0].Pictures[0].ChangeLayer(ShapeLayerChangeType.BringForward);
- Wb.Worksheets[1].Pictures[0].ChangeLayer(ShapeLayerChangeType.BringToFront);
- Wb.Worksheets[2].Pictures[1].ChangeLayer(ShapeLayerChangeType.SendBackward);
- Wb.Worksheets[3].Pictures[1].ChangeLayer(ShapeLayerChangeType.SendToBack);
- Supports operating the theme of Workbook.
- //copy the theme from Excel
- workbook.CopyTheme(srcWorkbook);
- //set theme color
- workbook.SetThemeColor(ThemeColorType.Accent1, Color.Blue);
- //get theme color
- Color color = workbook.GetThemeColor(ThemeColorType.Accent2);
- //set style as theme color
- style.SetThemeColor(ThemeColorType.Lt1, 0.1);
- /get theme color of style
- bool isThemeColor = style.GetThemeColor(out themeType, out tint);
- Supports getting the range of freeze panes.
- sheet.GetFreezePanes(out rowIndex, out colIndex);
- Bug:
- Fixes the issue that the content was incorrect after converting Excel to Image.
- Fixes the issue that the font format was incorrect after converting Excel to PDF.
- Fixes the issue that the pagination was incorrect after converting Excel to PDF.
- Fixes the issue that the chart format was incorrect after saving it.
- Fixes the issue that the color of pie chart was incorrect.
New in Spire.XLS 11.3.4 (Mar 12, 2021)
- New Feature:
- Supports setting the shape order.
- Supports operating the theme of Workbook.
- Supports getting the range of freeze panes.
- Bugfixes:
- Fixes the issue that the content was incorrect after converting Excel to Image.
- Fixes the issue that the font format was incorrect after converting Excel to PDF.
- Fixes the issue that the pagination was incorrect after converting Excel to PDF.
- Fixes the issue that the chart format was incorrect after saving it.
- Fixes the issue that the color of pie chart was incorrect.
New in Spire.XLS 11.2.6 (Feb 23, 2021)
- New Feature:
- Supports changing data source in Pivot Table.
- var pivotTable = sheet.PivotTables[0];
- ((Spire.Xls.PivotTable)pivotTable).ChangeDataSource(sheet.Range["A1:C9"])
- Bug:
- Fixes the issue that getting series data in discontinuous areas failed.
- Fixes the issue that the corresponding data was incorrect when setting PlotArea to create a chart.
- Fixes the issue that the date formula conversion failed when converting Excel to PDF.
- Fixes the issue that the application threw "Exception Unhandled" when converting Excel to PDF.
- Fixes the issue that setting HasMajorGridLines as "true" did not work when creating a new chart.
- Fixes the issue that the application threw "System.NullReferenceException" when loading an XLSM file and threw "System.ArgumentOutOfRangeException" when converting an XLSM file to HTML.
- Fixes the issue that the recognition of date format data was incorrect.
- Fixes the issue that the barcode of output PDF was displayed incorrectly when converting XLSX to PDF.
- Fixes the issue of the chart being updated incorrectly.
New in Spire.XLS 11.2.3 (Feb 8, 2021)
- Fixes the issue that only the first sheet worked when changing the background color of multiple sheets and converting the sheets to images.
- Fixes the issue that opening output files failed after adding char code data to cell
- Fixes the issue that the application threw System.NullReferenceException when copying charts.
- Fixes the issue that the application threw System.StackOverflowException when converting Excel to PDF.
- Fixes the issue that the application threw System.NullReferenceException when loading an XLSX file.
- Fixes the issue that the application threw System.ArgumentNullException when loading an XLSX file.
- Fixes the issue that the line breaks were inconsistent when converting Excel to PDF.
- Fixes the issue that the application threw System.ArgumentException when calculating PivotTable data.
- Fixes the issue that the retrieved data type of cell was incorrect.
- Fixes the issue that the size of the converted PDF from Excel increased to 20 times.
- Fixes the issue that the text did not wrap and thus resulted in incomplete text display when converting text with vertical layout and auto-wrap to PDF/Images.
- Fixes the issue that the content displayed incompletely when converting Excel to PDF.
- Fixes the issue that the layout of the chart in the generated .ods document was incorrect.
- Fixes the issue that the center alignment style of text with vertical layout was lost when converting Excel to PDF/Images.
- Fixes the issue that the color of the background image went black after saving files.
- Fixes the issue that the content was incorrect when converting XLSM to PDF.
- Fixes the issue that copying the drop-down list failed.
New in Spire.XLS 11.1 (Jan 22, 2021)
- Optimization:
- Optimizes the speed of converting Excel to HTML.
- New feature:
- Supports calculating newly added CONCAT, IFS, MAXIFS, MINIFS, SWITCH, TEXTJOIN of MS Excel2019.
- Supports the function of not displaying the title of bubble chart.
- NSupports the function of removing the borders of pictures.
- Supports the function of converting shape to picture.
- Supports the function of compressing pictures in Excel.
- Bug:
- Fixes the issue that getting the chart title failed.
- Fixes the issue that the date data was incorrectly wrapped when converting Excel to PDF.
- Fixes the issue that the application threw System.OverflowException when loading file.
- Fixes the issue that the application threw System.ArgumentOutOfRangeException when loading and saving files.
- Fixes the issue that the data bar of the conditional format was not displayed correctly when converting Excel to PDF.
- Fixes the issue that creating a pivot table failed in the environment with Win10 64-bit and Italy region setting.
- Fixes the issue that the text boxes could not be copied correctly.
- Fixes the issue that the text font indentation was changed from condensed to standard when copying cell content.
- Fixes the issue that the application hung when converting Excel to Html.
- Fixes the issue that the format of date data was incorrect when importing sheet data to data table.
- Fixes the issue that inserting and deleting rows took a long time.
- Fixes the issue that the data of the category label in the chart was incorrect when saving the chart to images.
- Fixes the issue that the characters were garbled when converting CSV file with Turkish ISO-8859-9 encoding to xlsx file.
New in Spire.XLS 10.12.0 Hotfix (Dec 3, 2020)
- New featyure:
- Supports adjusting the polyline position of the elebow arrow.
- GeomertyAdjustValue ad = line.ShapeAdjustValues.AddAdjustValue(GeomertyAdjustValueFormulaType.LiteralValue);
- // x is the position of the middle point. When it is less than 0, it is on the left side of the left point. When it is equal to 0, it is the same as the left point. When it is equal to 50, it is in the middle of the graph. When it is 100, it is the same as the right point.
- Ad.SetFormulaParameter(x);
- Bugs:
- Fixes the issue that the row height was incorrect after invoking the AutoFitRows method.
- Fixes the issue that the font of the text box text was changed after converting XLS to XLSX.
- Fixes the issue that the application hung when saving the Excel file.
- Fixes the issue that the created line chart for pivot table was incorrect.
- Fixes the issue that the content was incorrect after converting the chart to image.
- Fixes the issue that the content was incorrect after converting XLS to PDF.
- Fixes the issue that the obtained trend line equation was incorrect.
- Fixes the issue that the method WorkBook.GetOleSize returned a wrong value.
- Fixes the issue that the application threw the error “Object reference not set to an instance of an object” when converting XLS to PDF.
- Fixes the issue that the calculation result was incorrect after invoking the CalculateAllValue method.
- Fixes the issue that the content was changed after copying the sheet.
- Fixes the issue that the application threw the error “The max length of the sheet name is 31“ when converting CSV to PDF.
- Fixes the issue that the position of the inserted line was incorrect.
- Fixes the issue that an error prompted when opening the result file after loading and saving the document twice.
New in Spire.XLS 10.11.7 Hotfix (Nov 18, 2020)
- New Feature:
- Supports adding Subtotal functionality:
- Workbook workbook = new Workbook();
- workbook.LoadFromFile(input);
- Worksheet sheet = workbook.Worksheets[0];
- CellRange range = sheet.Range["A5:D20"];
- sheet.Subtotal(range, 0, cols.ToArray(), SubtotalTypes.Sum, true, false, true);
- workbook.SaveToFile(output,FileFormat.Version2013);
- Supports setting bubble size of Bubble Chart:
- chart.Series[0].Format.Options.BubbleScale = x;
- Supports adding lines through two points:
- //1)Relative location
- Workbook workbook = new Workbook();
- Worksheet worksheet = workbook.Worksheets[0];
- XlsLineShape line = worksheet.TypedLines.AddLine() as XlsLineShape;
- line.LeftColumn = 10; //The column index of the starting point
- line.LeftColumnOffset = 10; //The amount of column deviation from the starting point
- line.TopRow = 10; //The row index of the starting point
- line.TopRowOffset = 10; //The amount of row deviation from the starting point
- line.RightColumn = 17; //The column index of the end point
- line.RightColumnOffset = 10; //The amount of column deviation from the end point
- line.BottomRow = 18; //The row index of the end point
- line.BottomRowOffset = 10; //The amount of row deviation from the end point
- workbook.SaveToFile("result.xlsx", ExcelVersion.Version2013);
- workbook.Dispose();
- //2)Absolute location in pixels
- Workbook workbook1 = new Workbook();
- Worksheet worksheet1 = workbook1.Worksheets[0];
- XlsLineShape line1 = worksheet1.TypedLines.AddLine() as XlsLineShape;
- line1.StartPoint = new Point(20, 30);
- line1.EndPoint = new Point(20, 50);
- workbook1.SaveToFile("result2.xlsx", ExcelVersion.Version2013);
- workbook1.Dispose();
- Bug:
- Fixes the issue that the content was inconsistent when converting Excel to PDF.
- Fixes the issue that the pivottable's data was incorrectly updated when converting Excel to PDF.
- Fixes the issue that the text alignment was changed when converting Excel to PDF.
- Fixes the issue that the application threw "Remote service access error: (502) the wrong gateway" when loading Excel document.
- Fixes the issue that the application threw "System.ArgumentOutOfRangeException" when loading Excel.
- Fixes the issue that the color format was lost when converting Excel to HTML.
- Fixes the issue that the application threw "System.ArgumentException" when converting xls to xlsx.
- Fixes the issue that it reported an error when opening the document with MS Excel after adding special symbols.
- Fixes the issue that the application threw "System.FormateException" when loading xlsm files.
- Fixes the issue that there was an error when calculating XLOOKUP formula.
- Fixes the issue that a picture was missing when converting Excel to PDF.
- Fixes the issue that the legend was changed after modifying the data label.
- Fixes the issue that the value in the chart was changed after the Excel file generated by Spire.XLS was opened and saved as MS Excel.
- Fixes the issue that the result Excel document failed to open when using the value "#N/A" to create a chart.
- Fixes the issue that row height was not automatically adjusted by AutoFitRow() when Excel file has hidden content.
- Fixes the issue that the application threw "System.StackOverflowException" when converting Excel to Image.
- Fixes the issue that data was lost when converting charts to pictures.
New in Spire.XLS 10.11.2 Hotfix (Nov 6, 2020)
- New Feature:
- Supports adding/deleting digital signature function for Excel.
- Supports Track Changes function.
- Supports mathematical formulas when converting Excel to PDF
New in Spire.XLS 10.10.6 Hotfix (Oct 15, 2020)
- New Feature:
- Supports converting Excel to PDF A/1B.
- Supports calculating XLOOKUP formula in Office365 document.
- Bug:
- Fixes the issue that the content was reduced when printing Excel by a needle printer.
- Fixes the issue that circular reference error occurred after adding a document custom property.
- Fixes the issue that font color and font style of chart was changed after loading and saving Excel files.
- Fixes the issue that AutoFitRow setting did not work.
- Fixes the issue that chart data was not updated correctly after modifying data source.
- Fixes the issue that SUM formula update failed.
- Fixes the issue that the shape of the line was changed when converting Excel to PDF.
- Fixes the issue that the number format was inconsistent when converting sheet to HTML.
- Fixes the issue that the Ole object could be not opened successfully when inserting a Word Ole object containing Chinese name.
- Fixes the issue that the application threw an error"xl/drawings/_rels/vmlDrawingHF1.vml.rels does not exist or is empty" when converting Excel to PDF.
New in Spire.XLS 10.9.0 Hotfix (Sep 2, 2020)
- Bug Fixes:
- Fixes the issue that incorrect content format was caused after converting Excel to HTML.
- Fixes the issue that the application threw an exception when converting an Excel which contains formulas to PDF.
- Fixes the issue that incorrect content was caused after copying a sheet which contains named ranges.
- Fixes the issue that the application threw an exception "offset and length beyond the array bounds..." when loading Excel.
- Fixed the issue that after creating a chart using an array with an empty first value, the generated Excel prompted an error when opening.
- Fixes the issue that getting the formula of trendline returned incorrect data.
- Fixes the issue that incorrect color was caused after converting .XLT to .XLS.
- Fixes the issue that an exception "The ' [ '- unterminated [] set is being analyzed" was caused when converting Excel to PDF.
New in Spire.XLS 10.8.3 Hotfix (Aug 11, 2020)
- We're pleased to announce the release of Spire.XLS 10.8.3. This update mainly fixes some issues that occurred when converting Excel to PDF and saving files. More details are listed below.
- Bug:
- Fixes the issue that a content error appeared when Excel opens the file after updating PivotTable.
- Fixes the issue that a content error appeared when Excel opens the file after loading an .xlsx file and then saving to new file.
- Fixes the issue that the application threw an error "Error in calculating cell B2 in Worksheet Sheet1" when converting Excel to PDF.
- Fixes the issue that the application threw "InvalidCastException" when saving to an .xls file.
- Fixes the issue that the number format was incorrect when converting Excel to PDF in German system.
- Fixes the issue that the formula value was incorrect when converting Excel to PDF.
New in Spire.XLS 10.7.2 Hotfix (Jul 7, 2020)
- Adds the LoadFromHtml and LoadFromMHtml methods that support converting HTML to Excel.
- Fixes the issue that the picture went black when converting Excel to PDF.
- Fixes the issue that the application threw an error "ArgumentOutOfRangeException.".
- Fixes the issue that the application threw an error "FormatException.".
- Fixes the issue that the right margin was incorrect when converting Excel to PDF.
- Fixes the issue that line feed of text was incorrect when converting Excel to PDF.
- Fixes the issue that the style of pivotTable was missing when converting Excel to HTML.
- Bug SPIREXLS-2270
- SPIREXLS-2321 Fixes the issue that the data of chart created from the PivotTable was not updated correctly when converting Excel to PDF.
- Fixes the issue that the grid lost when converting XML to Excel.
- Fixes the issue that the content was narrowed down when printing Excel using customized printing size.
- Fixes the issue that the content was incorrect when converting XLTX to PDF.
- Fixes the issue that the application threw an error "NullReferenceException.".
- Fixes the issue that the border style was changed when converting Excel to PDF.
- Fixes the issue that the application threw an error "ArgumentNullException.".
New in Spire.XLS 10.5.7 Hotfix (May 21, 2020)
- New Feature:
- Adds the LoadFromHtml and LoadFromMHtml methods that support converting HTML to Excel.
- Workbook.LoadFromHtml(string fileName);
- Workbook.LoadFromHtml(Stream stream);
- Workbook.LoadFromMHtml(string fileName);
- Workbook.LoadFromMHtml(Stream stream);
- Bugs:
- Fixes the issue that the picture went black when converting Excel to PDF.
- Fixes the issue that the application threw an error "ArgumentOutOfRangeException.".
- Fixes the issue that the application threw an error "FormatException.".
- Fixes the issue that the right margin was incorrect when converting Excel to PDF.
- Fixes the issue that line feed of text was incorrect when converting Excel to PDF.
- Fixes the issue that the style of pivotTable was missing when converting Excel to HTML.
- Fixes the issue that the data of chart created from the PivotTable was not updated correctly when converting Excel to PDF.
- Fixes the issue that the grid lost when converting XML to Excel.
- Fixes the issue that the content was narrowed down when printing Excel using customized printing size.
- Fixes the issue that the content was incorrect when converting XLTX to PDF.
- Fixes the issue that the application threw an error "NullReferenceException.".
- Fixes the issue that the border style was changed when converting Excel to PDF.
- Fixes the issue that the application threw an error "ArgumentNullException.".
New in Spire.XLS 10.4.9 Hotfix (Apr 22, 2020)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 10.3.8 Hotfix (Mar 26, 2020)
- Bug Fixes:
- Fixes the issue that the text color of data label was not set successfully.
- Fixes the issue that it failed to get trend line formula.
- Fixes the issue that the cell width was inconsistent when converting XLS to HTML.
- Fixes the issue that application threw NullReferenceException when loading CSV document.
- Fixes the issue that it failed to get the value of formula.
- Fixes the issue that the brackets were not formatted correctly when converting XLS to PDF.
New in Spire.XLS 10.1.8 Hotfix (Jan 21, 2020)
- New Features:
- Support formatting the data of the trend line.
- trendLine.DataLabel.NumberFormat = "#, ## 0.000";
- Bug Fixes:
- Fixes the issue that adding a hyperlink to a cell failed.
- Fixes the issue that the formula was missing when adding a trend line to a chart.
- Fixes the issue that the application threw “ArgumentOutOfRangeException” when loading an .xlsm document.
- Fixes the issue that the content was incorrect when converting an .xlsx document to PDF.
- Fixes the issue that the text in generated .xlsx document was wrapped.
New in Spire.XLS 10.1.7 Beta(Hotfix) (Jan 21, 2020)
- Bug Fixes:
- Fixes the issue that the application threw an exception when converting an Excel file which contains Pivot Table to PDF or HTML.
- Fixes the issue that the number format and the rules of conditional formatting were wrong after converting an Excel file which contains Pivot Table to PDF or HTML.
- Fixes the issue that the application threw XmlException when loading an Excel file.
- Fixes the issue that the links placed in the pictures were missing after converting Excel to PDF.
- Fixes the issue that there were extra blank columns after converting .xlt to .xlsx file.
- Fixes the issue that the application threw OverflowException when loading a .xlsm file.
New in Spire.XLS 10.1 (Jan 9, 2020)
- New Features:
- Supports applying external font file to chart, such as axis labels and data labels. Note: embedding the font in Excel file is not supported, but it is supported when converting to PDF.
- Supports specifying EmfType in ToEMFStream method.
- Bug Fixes:
- Fixes the issue that incorrect content format was caused after converting Excel to HTML.
- Fixes the issue that the application threw an exception when converting an Excel which contains formulas to PDF.
- Fixes the issue that incorrect content was caused after copying a sheet which contains named ranges.
- Fixes the issue that the application threw an exception "offset and length beyond the array bounds..." when loading Excel.
- Fixed the issue that after creating a chart using an array with an empty first value, the generated Excel prompted an error when opening.
- Fixes the issue that getting the formula of trendline returned incorrect data.
- Fixes the issue that incorrect color was caused after converting .XLT to .XLS.
- Fixes the issue that an exception "The ' [ '- unterminated [] set is being analyzed" was caused when converting Excel to PDF.
New in Spire.XLS 10.1.1 Hotfix (Jan 7, 2020)
- New Features:
- Supports retaining the filtered stream data when converting Excel to CSV.
- worksheet.SaveToStream (Stream stream, string separator, bool retainHiddenData);
- Bug Fixes:
- Fixes the issue of the drop-down box was missed.
- Fixes the issue that the worksheet.IsEmpty returned incorrect results.
- Fixes the issue that it threw the exception "the object reference was not set to the object instance" when loading an Xlsx file.
- Fixes the issue that the worksheet.IsPasswordProtected returned incorrect results.
- Fixes the issue that the content was incorrect when converting from Excel to PDF.
- Fixes the issue that the speed was slow when using Filter() method to filter.
- Fixes the issue that it threw the exception “ArgumentOutOfRangeException” when loading an Xlsm file.
- Fixes the issue that it threw the exception “The specified parameter has exceeded the range of valid value “when copying a sheet by using the workbook.Worksheets. AddCopy (sheet) method.
- Fixes the issue that the image was shrunk when converting Excel to PDF.
- Fixes the issue that it threw “XmlException” when loading an Xlsx file.
- Fixes the issue that the content was missed when converting from an Xlsm file to PDF.
- Fixes the issue that the additional content appeared when converting an Xlsx file to PDF.
New in Spire.XLS 9.11.14 Hotfix (Nov 26, 2019)
- Bug Fixes:
- Fixes the issue that the xlsm converted from xltm hinted an error when opening in MS Excel.
- Fixes the issue that the application threw an exception "Value was either too large or too small for an unsigned byte" when loading an Excel file.
- Fixes the issue that after inserting an image in Excel, the image was lost when opening the generated Excel in LibreOffice.
- Fixes the issue that the format of table was lost after converting sheet to image.
- Fixes the issue that caused incorrect content after converting Excel to PDF.
- Fixes the issue that caused incorrect content after converting sheet to html.
New in Spire.XLS 9.10.4 Hotfix (Oct 11, 2019)
- New Features:
- Adds two parameters"horizontal:right_to_left" and "vertical:bottom_to_top" for Marker Designer.
- Bug Fixes:
- Fixes the issue that there were empty additional columns after saving .xls to .xlsx.
- Fixes the issue that the content was cut off after converting Excel to PDF.
- Fixes the issue that the application threw the NullReferenceException when loading a .xlsx file.
New in Spire.XLS 9.9.13 Hotfix (Sep 26, 2019)
- Bug Fixes:
- Fixes the issue that the cell color was incorrect after converting Xlt to Xls.
- Fixes the issue that the chart line displayed incorrectly after converting Excel to PDF and image.
- Fixes the issue that the application threw the "NotImplementedException" when using the Time function to create PivotTable.
- Fixes the issue that the formula value was acquired incorrectly.
- Fixes the issue that the application threw an exception when loading an excel file.
- Fixes the issue that the application threw the "StackOverFlowException" when executing CalculateAllValue.
- Fixes the issue that the range of conditional expressions was wrong when copying a range.
New in Spire.XLS 9.9.5 Hotfix (Sep 12, 2019)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 9.9.0 Hotfix (Sep 2, 2019)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 9.8.5 Hotfix (Aug 16, 2019)
- New Features:
- Supports creating chart based on PivotTable.
- worksheet.Charts.Add(ExcelChartType.BarClustered, pivotTable;
- Bug Fixes:
- Fixes the issue that incorrect line height was caused after setting AutoFitRow.
- Fixes the issue that there were errors with the PivotTable after converting Excel to PDF or HTML.
- Fixes the issue that messy content was caused after converting CSV to XLSX in .NET Core.
- Fixes the issue that incorrect line was caused after converting Excel to PDF.
- Fixes the issue that the conditional format was lost after copying range.
- Fixes the issue that if the page number had blank space, there was a problem with the page number after adding.
- Fixes the issue that incorrect Thai characters were caused after converting Excel to PDF.
- Fixes the issue that incorrect chart data was caused after converting Excel to PDF.
- Fixes the issue that the formula of trendline could not be returned correctly.
- Fixes the issue that the color of range could not be cloned successfully.
- Fixes the issue that the application failed to load a correct document if the first document had failed to be loaded.
- Fixes the issue that Excel prompted a message to update link after removing a sheet which contains NamedRange.
- Fixes the issue that the application caught an exception in try catch statement, but another exception was thrown after using GC to collect garbage.
New in Spire.XLS 9.7 (Jul 11, 2019)
- New Features:
- Supports applying external font file to chart, such as axis labels and data labels. Note: embedding the font in Excel file is not supported, but it is supported when converting to PDF.
- Supports specifying EmfType in ToEMFStream method.
- Bug Fixes:
- Fixes the issue that incorrect content format was caused after converting Excel to HTML.
- Fixes the issue that the application threw an exception when converting an Excel which contains formulas to PDF.
- Fixes the issue that incorrect content was caused after copying a sheet which contains named ranges.
- Fixes the issue that the application threw an exception "offset and length beyond the array bounds..." when loading Excel.
- Fixed the issue that after creating a chart using an array with an empty first value, the generated Excel prompted an error when opening.
- Fixes the issue that getting the formula of trendline returned incorrect data.
- Fixes the issue that incorrect color was caused after converting .XLT to .XLS.
- Fixes the issue that an exception "The ' [ '- unterminated [] set is being analyzed" was caused when converting Excel to PDF.
New in Spire.XLS 9.6.12 Hotfix (Jun 28, 2019)
- Bug Fixes:
- Fixes the issue that caused incorrect format when converting Excel to image.
- Fixes the issue that the application threw an exception "the length can't be less than 0" when getting a specific range.
- Fixes the issue that caused incorrect format when converting chart to image.
- Fixes the issue that the application threw the exception "the specified parameter is out of range of valid values" when loading a CSV file.
- Fixes the issue that caused incorrect columns of Pivot Table after adding data.
- Fixes the issue that the formula of trendline could not be obtained correctly.
New in Spire.XLS 9.6.7 Hotfix (Jun 19, 2019)
- Bug Fixes:
- Fixes the issue that caused incorrect format when converting Excel to image.
- Fixes the issue that the application threw an exception "the length can't be less than 0" when getting a specific range.
- Fixes the issue that caused incorrect format when converting chart to image.
- Fixes the issue that the application threw the exception "the specified parameter is out of range of valid values" when loading a CSV file.
- Fixes the issue that caused incorrect columns of Pivot Table after adding data.
- Fixes the issue that the formula of trendline could not be obtained correctly.
New in Spire.XLS 9.5.11 Hotfix (May 23, 2019)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 9.5.6 Hotfix (May 16, 2019)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 9.5.0 Hotfix (May 1, 2019)
- Bug Fixes:
- Fixes the issue that getting the page number of worksheet returned incorrect data.
- Fixes the issue that after adding background image and then saving to Version97to2003 format, the generated .xls had problems on content.
- Fixes the issue that the application threw "OverflowException" when loading an Excel.
- Fixes the issue that the superscript was incorrect after saving an Excel to image.
- Fixes the issue that the application threw an error "XXX is not valid named range" when executing InsertArray method.
- Fixes the issue that the application threw an error "Input string was not in a correct format" when loading an Excel.
- Fixes the issue that the conditional format was lost after converting worksheet to HTML.
New in Spire.XLS 9.4.6 Hotfix (Apr 15, 2019)
- Fixes the issue that incorrect content was caused after converting Excel to PDF.
- Fixes the issue that setting DocumentProperties of version97-2003 format but didn't take effect.
- Fixes the issue that the exception (“XmlException was unhandled”) was caused when loading an Excel.
- Fixes the issue that the DisplayedText of cell in Excel could not be obtained correctly.
- Fixes the issue that after saving as a new Excel file, an error dialog popped up when opening the saved Excel.
- Fixes the issue that the count of NameRange could not be obtained correctly.
New in Spire.XLS 9.4.0 Hotfix (Apr 2, 2019)
- Fixes the issue that incorrect content was caused after converting Excel to PDF.
- Fixes the issue that setting DocumentProperties of version97-2003 format but didn't take effect.
- Fixes the issue that the exception (“XmlException was unhandled”) was caused when loading an Excel.
- Fixes the issue that the DisplayedText of cell in Excel could not be obtained correctly.
- Fixes the issue that after saving as a new Excel file, an error dialog popped up when opening the saved Excel.
- Fixes the issue that the count of NameRange could not be obtained correctly.
New in Spire.XLS 9.3.10 Hotfix (Mar 21, 2019)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 9.3.4 Hotfix (Mar 13, 2019)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 9.2.11 Hotfix (Feb 27, 2019)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 9.2.8 Hotfix (Feb 21, 2019)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 9.1.22 Hotfix (Feb 1, 2019)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 8.12.11 Hotfix (Dec 28, 2018)
- Bug Fixes:
- Fixes the issue that caused "File does not contain workbook stream" exception when loading Excel from stream.
- Fixes the issue that the SaveToFile method threw "NullReferenceException" after deleting sheet.
- Fixes the issue that setting Rotation property of picture didn't take effect after saving as Excel 97-2003 version.
- Fixed the issue that failed to delete Legend of chart.
- Fixed the issue that the String format displayed as Numbered format after applying marker designer.
New in Spire.XLS 8.12.3 Hotfix (Dec 11, 2018)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 8.11.2 Hotfix (Nov 12, 2018)
- Fixes the issue that extracting the OLE in Excel but got empty oleData.
- Fixes the issue that changing the font of chart title had impacts on other fonts of text.
- Fixes the issue that caused an exception when loading an Excel file.
- Fixes the issue that adding the fill color failed.
- Fixes the issue that copying range didn't succeed.
- Fixes the issue that caused an exception when converting Excel to PDF.
- Fixes the issue that caused an exception when saving Excel to stream.
- Fixes the issue that caused incorrect page number after converting Excel to PDF.
New in Spire.XLS 8.10.7 Hotfix (Oct 30, 2018)
- New Features:
- Adds a new method to get ChartSheet via sheet name.
- ChartSheet cs = workbook.GetChartSheetByName("name");
- Adds a new method to save ChartSheet to SVG stream.
- chartSheet.ToSVGStream(fs);
- Bug Fixes:
- Fixes the issue that the returned value was incorrect when obtaining the color of border.
- Fixes the issue that caused an ArgumentException when loading an Excel file.
- Fixes the issue that caused an exception when loading an Excel file from a folder that was set with the checked option "Read-only recommended".
- Fixes the issue that an error occurred when opening the result file after copying a worksheet.
- Fixes the issue that an exception occurred in this line of code "Worksheets.AddCopy" after setting thread culture.
- Fixes the issue that the progress hung when converting worksheet to image.
- Improves the speed of loading a big Excel file.
New in Spire.XLS 8.10.2 Hotfix (Oct 12, 2018)
- New Features:
- Adds a new method to get ChartSheet via sheet name.
- Adds a new method to save ChartSheet to SVG stream.
- Bug Fixes:
- Fixes the issue that the returned value was incorrect when obtaining the color of border.
- Fixes the issue that caused an ArgumentException when loading an Excel file.
- Fixes the issue that caused an exception when loading an Excel file from a folder that was set with the checked option "Read-only recommended".
- Fixes the issue that an error occurred when opening the result file after copying a worksheet.
- Fixes the issue that an exception occurred in this line of code "Worksheets.AddCopy" after setting thread culture.
- Fixes the issue that the progress hung when converting worksheet to image.
- Improves the speed of loading a big Excel file.
New in Spire.XLS 8.9.8 Hotfix (Oct 1, 2018)
- Bug Fixes:
- Adjusted the value of range.Style.Rotation.
- Fixes the issue that the character changed after saving Excel in the Czech region.
- Fixes the issue that the application threw an exception when reloading the Excel which is saved in the last time.
- Fixes the issue that the application took too much time when converting sheet to image.
- Fixes the issue that the application hang when executing InsertRow method.
- Fixes the issue that after creating pivot tables, the generated file popped up an error message when opening.
New in Spire.XLS 8.9.3 Hotfix (Sep 17, 2018)
- New Features:
- Overloads the method "SaveChartAsImage" for supporting saving the charts from chartsheet as images.
- workbook.SaveChartAsImage(ChartSheet cs);
- Bug Fixes:
- Fixes the issue that the application threw an exception when getting the cell range of the OLE object.
- Fixes the issue that the table format became incorrect after converting Excel to PDF.
- Fixes the issue that the application threw an exception when loading an Excel.
- Fixes the issue that the application threw an exception when loading the same Excel file twice.
- Fixes the issue that the formula did not get calculated after printing or converting to PDF.
- Fixes the issue that the formula became incorrect after converting XML to Excel.
New in Spire.XLS 8.8.5 Hotfix (Aug 29, 2018)
- Fixes the issue that the text content got duplicated when converting Excel to XPS.
New in Spire.XLS 8.8.1 Hotfix (Aug 8, 2018)
- Fixes the issue that the text content got duplicated when converting Excel to XPS.
New in Spire.XLS 8.8.0 Hotfix (Aug 1, 2018)
- Bug Fixes:
- Fixes the issue that the color settings for columns with negative values in Column Chart did not work.
- Fixes the issue that the named ranges got lost after copying a worksheet.
- Fixes the issue that the application threw "ArgumentException" exception when loading an .xlsx file.
New in Spire.XLS 8.7.2 Hotfix (Jul 12, 2018)
- Bug Fixes:
- Fixes the issue that the color settings for columns with negative values in Column Chart did not work.
- Fixes the issue that the named ranges got lost after copying a worksheet.
- Fixes the issue that the application threw "ArgumentException" exception when loading an .xlsx file.
New in Spire.XLS 8.6.6 Hotfix (Jun 27, 2018)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 8.5.1 Hotfix (May 10, 2018)
- Hot fix patch contains only the Spire.XLS dlls. If you want to check the main and detailed functions offered by Spire.XLS, download and install Spire.XLS Pack; then go to the "SampleCenter" and API Help.
New in Spire.XLS 7.12.150 Hotfix (Feb 2, 2018)
- Bug Fixes:
- Fixes the issue that chart datalable was duplicated when converting Chart to Image.
- Fixes the issue that CalculateAllValue method threw an exception.
- Fixes the issue that the alignment of chart subtitle was incorrect when converting worksheet to PDF.
- Fixes the issue that the font of chart subtitle was incorrect when converting worksheet to PDF.
- Fixes the issue that the leader lines of chart was added when converting to PDF.
- Fixes the issue that the conditional format was incorrect.
- Fixes the issue that formula returned wrong value.
- Fixes the issue that the returned value of the sheet counts was incorrect.
- Fixes the issue that the retuned value of alternative text of shape was incorrect.
- Fixes the issue that the application was hanging when loading a file
New in Spire.XLS 7.12.140 Hotfix (Dec 29, 2017)
- Bug solutions:
- Fixes the issue that there is extra border for chart title when converting Excel to PDF.
- Fixes the issue that the alignment of chart title was changed after converting Excel worksheet to PDF.
- Fixes the issue that additional leader line of data label for chart occurs after converting Excel worksheet to PDF.
- Fixes the issue that caused InvalidCastException when loading the Excel.
- Fixes the issue that the process was freezing when using LoadFromStream to load file.
- Fixes the issue that caused exception when calling CalculateAllValue method.
- Fixes the issue that the result file has extra data.
New in Spire.XLS 7.12.130 Hotfix (Dec 21, 2017)
- Fixes the issue that the shadow property of shape didn't work.
- Fixes the issue that the border of the rectangle was lost when converting Excel to PDF.
- Fixes the issue that the position of shape was incorrect when converting Excel to PDF.
- Fixes the issue that the sheet protecting password was removed when manipulating locked cell.
- Fixes the issue that caused the exception that it is not supported for this Vertical Axis type when loading the Excel file.
- Fixes the issue that caused the exception when saving empty worksheet.
New in Spire.XLS 7.12 (Aug 11, 2017)
- Bug solutions:
- Reduce the PDF file size when converting Excel to PDF.
- Fixes the issue where the cell with the formula did not autofit although wrap text is enabled when converting Excel to PDF.
- Fixes the issue that caused the "Align with page margins" property in page setup unchecked when saving Excel file.
- Fixes the issue that caused the unexpected spaces exception when loading Excel file.
- Fixes the issue where the first inner group was not collapsed when setting "sheet.PageSetup.IsSummaryRowBelow" property as false.
- Fixes the issue where the value of INameRange was get incorrectly.
- Fixes the issue that caused the data lost when set ignoreSize argument exists in the sheet.Copy method as true.
- Resolves the issue where the width of columns was changed when make an AutoFitColumn on columns with merge values.
New in Spire.XLS 7.0.18 (Mar 14, 2013)
- New feature to support repeating rows as title of page in xls to pdf
- Fix the bug which caused some rows were cut-off when xls to pdf if the worksheet has footer
New in Spire.XLS 7.0.11 (Mar 14, 2013)
- New feature to support fiting sheet to one page in xls to pdf
- New feature to support indent of cell in xls to pdf
- New feature to support Gradient FillPattern of cell in xls to pdf
- New feature to support all types of border of cell in xls to pdf
- Add SaveToPdf method into Workbook (supports >= .NET 3.5)
- Fix bug of Picture offset from cell.
New in Spire.XLS 7.0 (Mar 14, 2013)
- Fix bug of loading/saving Excel file which has Macro
- Fix bug of converting Excel to PDF, this bug caused an IndexOutOfRangeException
New in Spire.XLS 6.9.15 (Mar 14, 2013)
- Fix bug of data losing during saving xls which has macro data
- Fix bug of converting xls to pdf which caused an exception when remove last page
- Fix bug of worksheet protection which caused other worksheet including protection option data will be incorrectly locked
New in Spire.XLS 6.9.9 (Dec 28, 2012)
- fix bug of searching range named by name
New in Spire.XLS 6.8.5 (Aug 31, 2012)
- Fixed:
- access violation exception during calling method LoadFromFile, caused by allocating not enough buffer
New in Spire.XLS 6.8 (Jul 17, 2012)
- When one row has one cell which has multiple lines of text, AutoFitRow opreation caused an exception
New in Spire.XLS 6.6 (May 15, 2012)
- When save a Workbook with Charts as Excel 2007 or Excel 2010, the charts will be lost when open the Workbook
New in Spire.XLS 6.5.9 (Apr 20, 2012)
- Features:
- Enable to Load PageBreaks and WorksheeOptions.ShowPageBreakZoom in Excel 2003 XML file
- Enable to Write PageBreaks and ShowPageBreakZoom into Excel 2003 XML file
- Added ZoomScaleNormal, ZoomScalePageBreakView and ZoomScalePageLayoutView in Worksheet
- Support loading/writing ZoomScaleNormal and ZoomScalePageBreakView in Excel 2003
- Support loading/writing ZoomScaleNormal and ZoomScalePageBreakView in Excel 2003 XML file
- Support loading/writing ZoomScaleNormal, ZoomScalePageBreakView and ZoomScalePageLayoutView in Excel 2007/2010
- Enable to load viewMode in Excel 2003
- Support writing viewMode into Excel 2003
- Fixed:
- Fixed the bug of loading colBreak in Excel 2007
- Fixed the bug of writing sheetView.@view into Excel 2007
- When load Excel 2003 XML file and merge cells, it will delete other cells to cause data lost
- When load Style in Excel 2003 XML file, incorrectly set Parent Style
New in Spire.XLS 6.5 (Mar 23, 2012)
- Fixed:
- Fixed bugs of reading and writing pivot.
- Fixed some bugs of formatting, calculating engine, formula, alignment,etc.
- Features:
- Support powerful sorting features: sort data in both horizontal and vertical directions which allows developers to sort data from top to bottom or left to right.
- Improved charts data preservation and pivot table for Excel 2003/2007/2010.
New in Spire.XLS 6.0 (Aug 23, 2011)
- Silverlight platform supported
- Excel calculate engine entire supported
- Encrypted excel 2007 ~ 2010 file supported
- Spark lines has been supported
- Name range has been supported
- Improve marker designer data type check and data formatting
- Improve read and write pivot table and pivot chart functions
- Improve excel to pdf conversion
New in Spire.XLS 5.8.9 (Aug 23, 2011)
- Fixed:
- Null pointer exception when converting xls to pdf
New in Spire.XLS 5.8.3 (Aug 23, 2011)
- Fix stackoverflow exception during inserting picture.
- Fix pivot table bug. The default case sensitive will lead exception during data analysing process.
New in Spire.XLS 5.8.2 (Apr 27, 2011)
- Fix Color and Font bug. When convert xml to xls, the color and font could not be retrieved correctly.
New in Spire.XLS 5.8.1 (Apr 27, 2011)
- Add the method Spire.License.LicenseProvider.SetLicenseKey(String licenseKey) defined in Spire.License.dll. This method can be called to apply explicitly the license by providing the license key, which is the value of the attribute Key of the root element License of the license file.
New in Spire.XLS 5.8.0 (Apr 27, 2011)
- Features:
- Add new license module to support flexible license mode which descripted by a license file with xml format.
- Deprecated:
- Method Spire.Xls.LicenseProvider.Register
New in Spire.XLS 5.7.2 (Apr 27, 2011)
- Features:
- Add property Workbook.DocumentProperties to support excel document properties
- Add demo InsertRows to demonstrate how to insert rows and copy data and style from existing rows.
- Can ignore to specify the ExcelVersion when create the workbook, just need to specify the ExcelVersion when it saved.(for Excel 2007)
- Fixed:
- Excel 2007 interior style bug.
- Excel 2007/2010 SurfaceContour chart fill color bug.
- When change the data of the datasource of a existing chart, the background color of the chart will be lost in Excel 2007/2010.
- Excel 2007/2010 StockVolumeOpenHighLowClose chart X axis data flag bug.
- Worksheet.TopVisibleRow property could not work.
New in Spire.XLS 5.5.2 (Apr 27, 2011)
- Hot fix the bug that invoking the method XlsRange.Merge() could not merge cells.
New in Spire.XLS 5.5 (Apr 27, 2011)
- Hot fix the bug that an exception occurs when copying worksheet to another workbook
New in Spire.XLS 5.4 (Apr 27, 2011)
- Hot fix the bug that an exception occurs when Workbook opening the Excel 2007 file.
New in Spire.XLS 5.3 (Apr 27, 2011)
- Change the api document, adding c++ sytax support.