Released: Feb 11, 2022

V22.2 버젼 업데이트

기능

• Added the ability to extract all the NameCollections of a particular worksheet.
• Added StandardHeightInch property to Cells class.

수정사항

• Various formatting and other shapes rendering issues in PDF and HTML of Excel file.
• Some shapes are not rendered properly in Excel to PDF conversion.
• Invalid value for external reference in DataSource field of Pivot Table.
• Regression: CSV to PDF conversion not working.
• Empty CellsArea array returned for CSV/TSV files.
• Finnish language - Numbers formatted as...

Released: Jan 7, 2022

V22.1 버젼 업데이트

기능

• Added support for returning original indices of sorted rows/columns.
• Added the ability to set print job name, with PrinterSettings, while rendering to printer.
• Added the ability to ignore hidden rows and columns when getting Cells.MaxDisplayRange.

수정사항

• Incorrect result for calculating FREQUENCY function in array formula.
• Unsupported function: CUBESET.
• Different behavior about collapsing and expanding multi level groups.
• BMP image files don’t display in header/footer.
• XLS to PDF: Conversion...

Released: Dec 8, 2021

V21.12 버젼 업데이트

기능

• Added support for converting Microsoft Excel to SQL scripts.
• Added support for converting Excel to XML data.
• Added support for importing XML data.
• Updated priorities when adding new format conditions.
• Sorting with DataSorter now affects table formatting.
• FormatConditionCollection.AddCondition() now gives different behavior for the formula.
• Added filter option for revision logs while creating workbook from template file.
• Added the ability to ignore 3D references for conditional formatting when...

Released: Nov 8, 2021

V21.11 버젼 업데이트

기능

• Added support for XLOOKUP formula/function.
• Added support for saving images with workbook.Save() method.
• Added support for saving as a JSON file.
• Added the ability to retrieve formatted cell values against certain cells.
• Added the ability to clear defined names when clearing worksheets.
• Improved performance when converting Microsoft Excel to HTML.

수정사항

• 3D, the shape of the cloud changed.
• Bug of saving external NamedRange which references to range of multiple sheets.
• Single type data saved...

Released: Oct 14, 2021

V21.10 버젼 업데이트

기능

• Added the ability to open files with HTML tables as XLS files.
• Added support for the Range.CurrentRegion property.
• Updated hyperlink(Sheet1!A1) when changing the name of the worksheet.
• Improved support for autofill range with fill type.
• Added the ability to remove invisible shapes when rendering HTML.

수정사항

• Conditional formatting of ODS is lost in Microsoft Excel if type is “Contains Text”.
• Issue with retrieving Ranges (RefersTo) with an offset function.
• Application halts while calculating...

Released: Sep 15, 2021

V21.9 버젼 업데이트

기능

• Added support for rendering Microsoft Excel 2016 Box and Whisker charts to an image.
• Added the ability to delete pivot tables while preserving data.
• Added support for named range of whole row/column for ODS files.
• Added support for setting the transparency of pictures in XLSX files.
• Improved the changing of a threaded comment’s author.
• Improved cell iterator access when rendering GridDesktop.
• Improved performance when writing ODS files.

수정사항

• Excel document is not converted to HTML.
• Out Of...

Released: Aug 12, 2021

V21.8 버젼 업데이트

기능

• Added support for scaling worksheet pages when exporting to HTML.
• Added support for XML maps.
• Added support for reading the latest Apple .numbers file format.
• Added auto-fill (pattern) for numbers, text or dates.
• You can now merge more empty spaces in output HTML.

수정사항

• License is not working in release version of MVC application when deployed on IIS server.
• Hang on save to HTML for the XLSB file.
• Object with rotation is distorted.
• Shift in the texts in the diagram shapes.
• The text position in...

Released: Jul 13, 2021

V21.7 버젼 업데이트

기능

• Added the option to apply conditional formatting on Pivot Tables.
• Added the ability to create conditional formatting on PivotTable via PivotField in row area, column area and data area.
• GridWeb - You can now run formulas similar to GridDesktop feature.
• Added GridWeb rows and columns grouping feature.
• Added the ability to preserve text formatting while converting from HTML to XLSX.
• Added the ability to show cell comments (rich text) exactly as in Microsoft Excel.
• Added support for pattern...

Released: Jun 16, 2021

V21.6 버젼 업데이트

기능

• Added the ability to get the value of SlicerCacheItem in the Slicer.SlicerCache.SlicerCacheItems collection.
• Added support for custom Slicer styles in XLSB.
• Added the ability to set user defined formulas as array-formulas and at the same time provide values as calculated results for those formulas.
• Added the ability to embed fonts with ANSI encoding.
• Added the ability to check if a worksheet is empty.

수정사항

• Deep copy of Workbook after calculation with CreateCalcChain setting.
• Retrieved...

Released: May 14, 2021

V21.5 버젼 업데이트

기능

• Added support for binding Slicer Reports with pivot tables and pivot charts.
• Added support for importing free HTML with SVG images.
• Added support for referring to spill range with #.
• Added support for moving existing columns in GridWeb.
• Added support for exporting all worksheets to CSV.
• Improved ArgumentException on CalculateFormula method.
• Improved support for ELSE function when converting XLS to XLSX.
• Added support for setting global PageOrientationType.
• Improved performance for reading ODS...