Released: Dec 15, 2023

Aggiornamenti in V23.12

Funzionalità

• Added support for MAKEARRAY function.
• Added support for JSON as data source for smart markers.
• You can now retrieve "Style Includes" information.
• Improved the performance of calculating shared formulas recursively.

Correzioni

• Different behavior of XLSX and XLSB files for MaxRow and MaxColumn attributes when using in LightCells APIs.
• VLOOKUP function calculation gets an error value.
• Incorrect value obtained after IRR function calculation.
• Endless loop with "CalculateFormula" method...

Released: Nov 13, 2023

Aggiornamenti in V23.11

Funzionalità

• Added support for PDF version 1.5 and 1.6 when rendering spreadsheets to PDF.
• Added 'HtmlSaveOptions.CalculateFormula' property which lets the user choose to calculate formulas or not before saving.

Correzioni

• DAYS360 function works incorrectly in case of leap day.
• The LOOKUP function obtains an error value after calculation in a Chinese environment.
• Sheet to Image rendering - EMF+ required error instead of images on the sheet.
• Converting files to PDF takes too long.
• Content of some...

Released: Oct 16, 2023

Aggiornamenti in V23.10

Correzioni

• The position of the punctuation mark in vertical text is close to the left side.
• The vertical text position inside the text box is incorrect.
• When converting XLS to PDF, the rounded rectangle is rendered into a right rectangle.
• Regression: calculateFormula hangs.
• Regression: Decimal rounding.
• The numeric values are added extra spaces for some regions such es-ES.
• Character spacing is not retained during chart conversion to image.
• The appearance of the graph changes when converting...

Released: Sep 15, 2023

Aggiornamenti in V23.9

Funzionalità

• Improved parsing of XML with un-escaped greater than signs.

Correzioni

• Characters disappear when saving file to PDF.
• Shapes are lost in Excel to PDF rendering.
• YEARFRAC is not working as in Excel in Aspose Cells for Java 23.8.
• Regression: Worksheet not calculated.
• Labels of Chart are overlapping having missing lines when Chart is converted to PDF.
• Issue with overlapping Donut Chart Labels.
• Legend data of chart error when saving to image.
• The underline style of the chart title is...

Released: Aug 14, 2023

Aggiornamenti in V23.8

Funzionalità

• Added support for preserving padding spaces in formulas.
• You can now read 'button name' and 'title' from ODS files.
• Improved rendering of HTML to Microsoft Excel worksheets.

Correzioni

• Regression: Slow performance of Workbook CalculateFormula.
• YEARFRAC formula calculation error.
• Chart to image rendering - One of the labels is inside the doughnut chart.
• Some labels overlapped when rendering chart to SVG/PDF on Linux.
• Missing values on x-axis on bar chart compared to original Excel...

Released: Jul 14, 2023

Aggiornamenti in V23.7

Correzioni

• Shapes with contents are not rendered precisely in Excel to PDF conversion.
• EXCEL function TRIM() calculation error.
• Inexplicable change in the handling of numbers in right function.
• Overlapping Labels issue in Donut Charts.
• Issue with graph rendering - "+" sign and graph for both the x-axis and y-axis are not being plotted in the output PDF.
• Position of legends is not retained during chart conversion to image.
• Position of leader lines is not retained during chart conversion to image...

Released: Jun 9, 2023

Aggiornamenti in V23.6

Funzionalità

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

Correzioni

• 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...

Released: May 11, 2023

Aggiornamenti in V23.5

Funzionalità

• Added support for adding watermarks while rendering to PDF.

Correzioni

• 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...

Released: Apr 13, 2023

Aggiornamenti in V23.4

Funzionalità

• Adds XlsbSaveOptions.LightCellsDataProvider property - Allows users to save XLSB files in 'LightCell' mode.
• Adds Worksheet.CalculateArrayFormula(...) methods - Allows users 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...

Released: Mar 9, 2023

Aggiornamenti in V23.3

Funzionalità

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

Correzioni

• 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...