Browse our Products

Aspose.Cells for JavaScript via C++ 26.8 Release Notes

KeySummaryCategory
CELLSCPP-1230Missing page numbers in PDF ExportBug
CELLSNET-41504Excel to PDF graph issueBug
CELLSNET-43712Yellow rectangles locations are changing in the output pdfBug
CELLSNET-43913Shadow of the object is lost while rendering the spreadsheet to PDFBug
CELLSNET-44697Shapes images are wrongBug
CELLSNET-45346The red box in the image in the lower left part is a bit moved in Excel to PDF renderingBug
CELLSNET-45349Some objects are moved while a few objects/shapes are unnecessarily visible in the output PDFBug
CELLSNET-45363Some objects (oval, ellipse, text field, etc.) are displaced/moved while some part of text in the rectangle shape is unnecessarily visible in the output PDFBug
CELLSNET-45854Color of Image changes when Excel is converted to PdfBug
CELLSNET-59863When using Aspose.Cells 26.2 in an Excel VTS add-in project to output a PDF, the line spacing in the text boxes is not displayed correctlyBug
CELLSNET-60425The position of the arrow shape is incorrect.Bug
CELLSNET-57270Support GROUPBY and PIVOTBY cell formulas/functionsNew Feature
CELLSNET-60102“#NAME?” error on Workbook.CalculateFormula method when evaluating LET functionBug
CELLSNET-60310REDUCE was calculated incorrectly when using LET-bound LAMBDA functionBug
CELLSNET-60376Aspose.Cells 26.2 XIRR Calc Error - .NETBug
CELLSNET-60387Support calculating BYROW/BYCOL with functions other than LAMBDAImprovement
CELLSNET-60392Failed to set formula of GROUPBY/PIVOTBY with LAMBDA functionBug
CELLSNET-60398“#VALUE!” error on Workbook.CalculateFormula method when using TOCOL with identical rangesBug
CELLSNET-60407LET function that uses custom function as parameter value causes #NAME? in the generated XLSXBug
CELLSNET-60410Unrecognized Error when opening the fileBug
CELLSNET-60420Reference,names and arrays are not supported in pivot table formulasBug
CELLSNET-60432Re-saved file was corrupted because the calculation chain was retained after all formulas have been removedBug
CELLSNET-60435Exception “Unexpected EXP token” when setting intersection of ranges to shape’s formulaException
CELLSNET-60444Remove useless formula chainsImprovement
CELLSNET-60457Formula is invalid in the generated xlsx from corrupted xls fileBug
CELLSNET-60462HYPGEOM.DIST formula name being corrupted to HYPGEOM_DIST on Workbook.Save methodBug
CELLSNET-60414“Chart/Picture to image Error!” on SheetRender.ToImage methodException
CELLSNET-60437The pie chart size reduction in chart to PDFBug
CELLSNET-60441“Overflow error” on Workbook.Save method when exporting to MarkdownException
CELLSNET-60459ArgumentNullException on Workbook.Save method when exporting to MarkdownException
CELLSNET-50176Phonetic Guide is lost after saving as Pdf fileNew Feature
CELLSNET-57445Phonetic kana loss when converting file to xpsBug
CELLSNET-58470Furigana text is lost when converting file to xpsBug
CELLSNET-60368Regarding line-breaking rules (Kinsoku Shori) when converting Excel files to PDFBug
CELLSNET-60429Bar code not appearing after conversion from XLSX to PDFBug
CELLSNET-60434An extra dot is appeared in the bar code while converting to pdfBug
CELLSNET-42475Nested Css in workbook is not displayingBug
CELLSNET-43619Conversion from MHTML to XLS generates a corrupted spreadsheetBug
CELLSNET-60400FileFormatUtil.DetectFileFormat returns LoadFormat.Unknown for valid XHTML filesBug
CELLSNET-60440“ArgumentNullException (path1)” on Workbook.Save method when exporting to MarkdownException
CELLSNET-48533Can’t dynamically refresh pivot table data by changing filter valueBug
CELLSNET-60200Copied chart renders incorrectly after manual worksheet normalization on Shapes.AddCopy methodBug
CELLSNET-60384Improve reading and writing phonetic settings for xls and xlsbImprovement
CELLSNET-60385Conditional rendering in Aspose cells smart markers templateBug
CELLSNET-60411Simplify subtotal setting of pivot fieldImprovement
CELLSNET-60417Pivot table formatting is lost when converting XLSX to XLSB using ASPOSE.CELLS.Bug
CELLSNET-60418Invalid pivot table viewBug
CELLSNET-60419Corrupted xlsb with pivot tables when converting from xlsxBug
CELLSNET-60421Support saving pivot alignment format setting of pivot table for xlsbImprovement
CELLSNET-60430Support calculating style of pivot table with outline border settingTask
CELLSNET-60442Missing count numbers subtotal result of multiple data pivot fieldsBug
CELLSNET-60443Count function of pivot table is changed.Bug
CELLSNET-60455“Aspose.Cells.CellsException: File is corrupted” on Workbook constructorException
CELLSNET-60374Fixed incorrect cell values during Numbers to XLSX conversionBug

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 C++. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds one method in BorderCollection class.

Indicates if left, right, top, and bottom borders should be applied only to outside borders of a cell range. Default value is true.

Adds one method in Cell class.

Gets a Picture which wrapped the embedded image in the cell.

Adds and obsoletes some methods in ShapePath class.

Add:

Gets ShapeSegmentPathCollection list

Obsoletes:

Please use ShapePath::GetPathSegments() method instead.

Adds and obsoletes some methods in HtmlLoadOptions class.

Add:

Specifies how HTML <p> elements are rendered when loading HTML. The default value is HtmlParagraphLayoutMode.Normal.

Obsoletes:

Please use HtmlLoadOptions::GetParagrahLayoutMode()/HtmlLoadOptions::SetParagrahLayoutMode(HtmlParagraphLayoutMode) methods instead.

Adds and obsoletes some methods in PaneCollection class.

Add:

Gets and sets the active pane.

Obsoletes:

Please use PaneCollection::GetActivePaneType()/PaneCollection::SetActivePaneType(RectangleAlignmentType) methods instead.

Obsoletes class CustomPiovtFieldGroupItem.

Please use DiscreteGroupItem class instead.

Adds new class DiscreteGroupItem.

Represents an item of custom grouped field.

Adds and obsoletes some methods in PivotDiscreteGroupSettings class.

Add:

Gets the discrete items.

Obsoletes:

Please use PivotField::GroupBy(const Vector&, bool) method instead.

Adds and obsoletes some methods in PivotField class.

Add:

Custom group the field.

Gets or sets the subtotals of the field. Only for Row or Column pivot field.

Indicates whether the specified field can be dragged to the row region. The default value is true.

Indicates whether the specified field can be dragged to the column region. The default value is true.

Indicates whether the specified field can be dragged to the page region. The default value is true.

Indicates whether this pivot field can be removed from the PivotTable view. The default value is true.

Indicates whether the specified field can be dragged to the values region. The default value is true.

Obsoletes:

Please use PivotField::GetPivotItems().Get(int).IsHidden() method instead.

Please use PivotField::GetPivotItems().Get(int).IsHidden() method instead.

Please use PivotField::GetPivotItems().Get(const U16String&).IsHidden()/PivotField::GetPivotItems().Get(const char16_t*).IsHidden() methods instead.

Please use PivotField::GetPivotItems().Get(int).IsDetailHidden() method instead.

Please use PivotField::GetPivotItems().Get(int).IsDetailHidden() method instead.

Please use PivotField::PivotItems.HideAllDetail() method instead.

Please use PivotField::GroupBy(const Vector&, bool) method instead.

Please use PivotField::GetAllowDraggingToRow()/PivotField::SetAllowDraggingToRow(bool) methods instead.

Please use PivotField::GetAllowDraggingToColumn()/PivotField::SetAllowDraggingToColumn(bool) methods instead.

Please use PivotField::GetAllowDraggingToPage()/PivotField::SetAllowDraggingToPage(bool) methods instead.

Please use PivotField::GetAllowRemovingFromView()/PivotField::SetAllowRemovingFromView(bool) methods instead.

Please use PivotField::GetAllowDraggingToData()/PivotField::SetAllowDraggingToData(bool) methods instead.

Please use PivotField::GetPivotItems().GetCount() method instead.

Adds and obsoletes two members in PivotFieldGroupType enum.

Add:

Grouped by numeric range.

Obsoletes:

Please use PivotFieldGroupType::NumericRange member instead.

Obsoletes one method in PivotItem class.

Please use PivotItem::GetPosition()/PivotItem::SetPosition(int32_t) methods instead.

Obsoletes class PivotNumbericRangeGroupSettings.

Please use PivotNumericRangeGroupSettings class instead.

Adds new class PivotNumericRangeGroupSettings.

Represents the numeric range group of the pivot field.

Adds and obsoletes some methods in PivotTable class.

Add:

Refresh PivotCache from data source and calculate data and style for pivot view.

Moves the PivotTable to a different location in the worksheet.

Indicates whether to preserve cell formatting (PivotTableFormat) when the pivot table is refreshed or recalculated.

Obsoletes:

Please use PivotTable::GetPreserveCellFormattingOnUpdate()/PivotTable::SetPreserveCellFormattingOnUpdate(bool) methods instead.

Adds and obsoletes some methods in SqlScriptColumnTypeMap class.

Add:

Gets numeric type in the database.

Obsoletes:

Please use SqlScriptColumnTypeMap::GetNumberType() method instead.

Adds some methods in Style class.

Set the outline borders

Adds and obsoletes some methods in VbaProject class.

Add:

Indicates whether this VBA project is locked for view. If true,the codes could not be visible.

Obsoletes:

Please use VbaProject::IsLockedForView() method instead.

Adds and obsoletes some methods in VbaProjectReferenceCollection class.

Add:

Add a reference to a twiddled type library and its extended type library.

Adds a reference to an external VBA project.

Obsoletes:

Please use VbaProjectReferenceCollection::AddControlReferernce(const U16String&, const U16String&, const U16String&, const U16String&)/VbaProjectReferenceCollection::AddControlReferernce(const char16_t*, const char16_t*, const char16_t*, const char16_t*) methods instead.

Please use VbaProjectReferenceCollection::AddProjectReferernce(const U16String&, const U16String&, const U16String&)/VbaProjectReferenceCollection::AddProjectReferernce(const char16_t*, const char16_t*, const char16_t*) methods instead.

Adds some methods in Worksheet class.

Query cell areas that mapped/linked to the specific path of xml map.

Removes two methods in FindOptions class.