| Key | Summary | Category |
|---|---|---|
| CELLSGO-205 | Optimize function mapping relationship table. | Improvement |
| CELLSNET-58944 | Provide option to determine how to output significant digits for numeric values | New Feature |
| CELLSNET-59052 | Support to process exported cell with custom ExportTableOptions when ExportAsString is true | Enhancement |
| CELLSNET-59074 | Support to parse datetime with calendar of Japanese Emperor Reign | Enhancement |
| CELLSNET-59078 | Support to refresh dynamic array formulas by default when calculating formulas for Workbook | Enhancement |
| CELLSNET-59045 | Improve compatibility with PdfBox library for the generated pdf file while converting to pdf | Enhancement |
| CELLSNET-59114 | Support to calculate style for pivot table while rendering pivot table range to image | Enhancement |
| CELLSNET-59071 | Export advanced charts of Excel 2016 to docx | Enhancement |
| CELLSNET-59123 | Support to populate comment on a cell using Smart Markers | Enhancement |
| CELLSNET-51941 | XLSX to PDF: Shapes messed up after conversion | Bug |
| CELLSNET-54573 | Incomplete TextBox display when converting files to Pdf | Bug |
| CELLSNET-56230 | A vertical green line appears from top to bottom when saving file to pdf | Bug |
| CELLSNET-57564 | Green line unnecessary appeared when rendering an Excel file to PDF | Bug |
| CELLSNET-58127 | Some images resized during Excel to PDF conversion | Bug |
| CELLSNET-58605 | The result file crashes when adding auto shape with AutoShapeType.LineCalloutWithAccentBar4 type | Bug |
| CELLSNET-58606 | The result file crashes when adding auto shape with AutoShapeType.LineCalloutNoBorder4 type | Bug |
| CELLSNET-59155 | Trapezoid position is incorrect when rendering xlsx to pdf | Bug |
| CELLSNET-58960 | Hyperlink formula cells lose background(conditional formatting) when converting file to html or pdf | Bug |
| CELLSNET-58966 | Range object returns "#VALUE!" errors whereas Excel returns values | Bug |
| CELLSNET-58994 | Values do not match when converting Excel file to PDF with enabled PdfSaveOptions.CalculateFormula | Bug |
| CELLSNET-59009 | The reference is set to #REF! for data connection after calling Cells.DeleteRows method | Bug |
| CELLSNET-59032 | Set value cannot display in the output Excel file | Bug |
| CELLSNET-59039 | ROW and COLUMN functions for range data produce incorrect result in calculating array formulas | Bug |
| CELLSNET-59043 | IFERROR for long text in array formula was calculated as false but ms excel calculates it as true | Bug |
| CELLSNET-59044 | XLSX to PDF: Incorrect formula result when workbook filename contains ']' | Bug |
| CELLSNET-59110 | Workbook.RefreshDynamicArrayFormulas() did not calculate some cells correctly when there are recursive references | Bug |
| CELLSNET-59111 | FILTER function caused resultant data out of order when the target range has default value at the tail | Bug |
| CELLSNET-58979 | The font of values changes (Arial Narrow -> Calibri) when rendering in the EMF image | Bug |
| CELLSNET-58980 | The bar chart uses red bars (using shadow property) are not rendered in the output image | Bug |
| CELLSNET-59015 | Chart to image is excluding data labels from the image | Bug |
| CELLSNET-59081 | LegendEntry.IsDeleted does not work as expected for the series whose state changed from disabled to enabled | Bug |
| CELLSNET-59016 | Cell.HtmlString does not apply styles for the contents | Bug |
| CELLSNET-59011 | Cells are not merged when using parameter group:merge in smart markers | Bug |
| CELLSNET-59077 | Ignore invalid horizontal or vertical page breaks when saving as .ods file format | Bug |
| CELLSNET-59103 | Copying formulas with cell referecing other sheets is not working as excel | Bug |
| CELLSNET-59124 | Table's column formula was not copied when importing data with false value for "InsertRows" option | Bug |
| CELLSNET-59125 | Importing data with true for "InsertRows" option caused invalid formula | Bug |
| CELLSNET-59117 | ArgumentOutOfRangeException on Workbook.RefreshDynamicArrayFormulas(true) method | Exception |
Public API and Backwards Incompatible Changes
The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Go via C++. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.
Changes behavior of Workbook.CalculateFormula(...) methods for refreshing dynamic array formulas.
Dynamic array formula is becoming more and more popular in more and more users' cases. Old versions of Aspose.Cells require users to call Workbook.RefreshDynamicArrayFormulas(...) explicitly before calling Workbook.CalculateFormula() if there are dynamic array formulas that need to be refreshed. Starting from 25.10, we include this step into Workbook.CalculateFormula(...) automatically. So users do not need to explicitly call Workbook.RefreshDynamicArrayFormulas(...) any more before calculating formulas for the workbook.
Adds three methods in CalculationOptions class.
Indicates whether dynamic array formulas in a workbook should be refreshed automatically when using this CalculationOptions to calculate formulas.
func (instance *CalculationOptions) GetRefreshDynamicArrayFormula() (bool, error)
func (instance *CalculationOptions) SetRefreshDynamicArrayFormula(value bool) error
Indicates whether it is explicitly set by the user through the CalculationOptions::RefreshDynamicArrayFormula method. If true, then use the specified value to determine whether to refresh dynamic array formulas. If false, whether refresh dynamic array formulas depends on what kind of formulas need to be calculated with this CalculationOptions. If it is to calculate formulas for the whole workbook, then dynamic array formulas will be refreshed automatically. If it is to calculate formulas for one cell or worksheet, then dynamic array formulas will not be refreshed.
func (instance *CalculationOptions) GetUserSpecifiedRefreshDynamicArrayFormula() (bool, error)
Adds SignificantDigitsType enum.
Represents the type of significant digits for outputing numeric values.
Adds four methods in WorkbookSettings class.
Indicates how to control the significant digits when outputing numeric values.
func CellsHelper_GetSignificantDigitsType() (SignificantDigitsType, error)
func CellsHelper_SetSignificantDigitsType(value SignificantDigitsType) error
Represents the limitation of unique items per pivot field.
func (instance *WorkbookSettings) GetMaxUniqueItemsPerField() (int32, error)
func (instance *WorkbookSettings) SetMaxUniqueItemsPerField(value int32) error
Adds two methods in MarkdownSaveOptions class.
Indicates whether blank rows in the worksheet should be treated as table separators when exporting to Markdown.
func (instance *MarkdownSaveOptions) GetSplitTablesByBlankRow() (bool, error)
func (instance *MarkdownSaveOptions) SetSplitTablesByBlankRow(value bool) error