Released: Jun 10, 2023

V23.6 での更新項目

機能

• Read 'track changes' information and highlight relevant cells.
• You can now optimize SVG images.
• Added support for setting 'duotone' effects.

不具合の修正

• Header row getting included in sorting after applying subtotal and getting wrong results.
• The calculation result of the FILTER function is incorrect.
• Cells text is not center aligned vertically in the generated EMF image.
• Missing part of cell border when converting to HTML.
• Graphic position error converting file to HTML.
• The newly created...

Released: May 10, 2023

V23.5 での更新項目

機能

• Added support for adding watermarks while rendering to PDF.

不具合の修正

• The data in the text box is out of bounds.
• Text is moved when converting grouped autoshapes to PDF.
• Vertical text in figure in Excel is slanted when converted to PDF.
• Oval shape display error when exporting file to HTML.
• Replaced font of text boxes issues.
• Conditional formatting reference rules are not updated fine when copying ranges from one workbook to another workbook.
• Error plot is not displayed.
• Endless loop when...

Released: Apr 12, 2023

V23.4 での更新項目

機能

• Adds XlsbSaveOptions.LightCellsDataProvider property - Allows user to save XLSB files in 'LightCell' mode.
• Adds Worksheet.CalculateArrayFormula(…) methods - Allows user to calculate one formula as array formula dynamically without setting it to a cell at first.
• Adds CalculationOptions.CharacterEncoding property - Allows user to specify the encoding used for characters when calculating formulas such as CHAR and CODE.
• Adds EquationNode class and it’s derived classes - Allows users to complete...

Released: Mar 8, 2023

V23.3 での更新項目

機能

• You can now modify the logic when generating a 'group' object from a 'smartart' object.
• Added support for 'img' tag margins when loading HTML.

不具合の修正

• Converted image is not same as MS Excel.
• Calculated field values are not retrieved by the getCalculatedValue() function.
• Chart to Image - character and legend height not rendered correctly.
• Converted PDF is showing diagram labels at different location and incorrect Axis points.
• Data labels missing from chart in copied workbook in v23.
• When...

Released: Feb 9, 2023

V23.2 での更新項目

機能

• You can now fill <Application> tags in XLSX.

不具合の修正

• When reading into 03 format Excel, the ‘FillType’ of the straight line is not processed.
• Horizontal flip seems to be missing when reading arrow lines.
• XLS to HTML: Image stretched.
• XLS to HTML: Arrow shifting.
• Diagram scattered issue in Excel to PDF rendering.
• Incomplete shape display after rotation when save to PDF.
• SUM AVERAGE calculation '#VALUE!'.
• Displayed result is incorrect for resultant HTML when cell value is string with...

Released: Jan 12, 2023

V23.1 での更新項目

機能

• You can now 'interrupt' when calculating formulas.
• Added support for zooming sheets and freezing panes when exporting and importing HTML.

不具合の修正

• XLS to HTML: Rectangle shape is distorted.
• How to code/utilize Row 1 Filter Flag Option.
• XLS to HTML: Image clipped and moved out of place.
• Difference in values between an Excel file and the converted PDF (via Aspose.Cells) file.
• Double quotes " from XLSX file not shown in converted PDF file.
• DATEDIF function doesn’t work correctly with leap years...

Released: Dec 9, 2022

V22.12 での更新項目

機能

• Set chart image DPI settings for PNG and JPG files.

不具合の修正

• The “3-D-format” attribute of the rectangle is not rendered correctly.
• Double quote causing inline style failed in HTML.
• Optimize the shadow effect.
• Chart getDataLabels().getText() returning different value in v22.6.0 and later versions.
• Convert Excel to HTML, the datalabels display errors.
• Transparency changed when inserting Excel range as image with different format into PowerPoint slide.
• Excel to HTML conversion - the graph legend...

Released: Nov 11, 2022

V22.11 での更新項目

不具合の修正

• “+” and “-” were disappeared after conversion - Excel to HTML rendering.
• Chart labels overlapped in chart to image rendering.
• Chart to image rendering - One of the labels is inside the doughnut chart.
• XLSX to PDF: Chart labels not rendered correctly.
• XLS to PDF: Insufficient data for an image.
• Convert Excel to HTML results in thousands of similar small images.
• Resizing tables change formatting of cells.
• Images cannot display in the sheet when converting HTML to Excel.
• Exception “java.lang...

Released: Oct 12, 2022

V22.10 での更新項目

機能

• Added support for importing files with 'openpassword'.

不具合の修正

• List numbers are incorrect after XLSX to HTML or PDF conversion.
• Workbook containing pivot table gets corrupted after processing pivot table in it.
• The formatted result for GridWeb was different from Cell.DisplayStringValue.
• Borders and fewer lines shown in black and white pie slices in chart to image rendering.
• The data on the x-axis angle is not the same as Excel in chart to image rendering.
• The data on the y-axis step is not the...

Released: Sep 10, 2022

V22.9 での更新項目

不具合の修正

• Drawing shape is not rendered in Excel to PDF rendering.
• Concurrent loading of workbooks throws spurious “File is corrupted” errors.
• Borders and fewer lines shown in black and white pie slices in chart to image rendering.
• Text rotation of labels does not match with Excel in the output image of the chart.
• Chart labels overlapped in chart to image rendering.
• The display of cell text does not same as in Excel in some merged areas.
• Multi pages are output instead of one page as in Excel while...