Aspose.Cells 7.4.3

New Features 41589 - Add new overload: AutoFitColumns(int firstRow, int firstColumn, int lastRow, int lastColumn, AutoFitterOptions options) 41553 - Copy a cell over a range of cells Enhancements 41520 - Smart Marker Grouping 41514 - Copy ListObjects/Tables in copying range. 41506 – Saving Workbook to CSV is not keeping columns for each row Performance 41527 - System.OutOfMemoryException on loading the workbook Exceptions 41477 - Mono problem – Unknown Heap Type: SmartAssembly 41554 - NullReferenceException calling DeleteRow (external data connections) 41552 - Worksheets.GetNamedRanges causes NullReferenceException 41534 - Exception: “Object reference not set to an instance of an object” - while saving the Excel file 41538 - "Invalid chart MarkerStyle string val" while opening a template file 41606 - "Invalid FontUnderlineType value" while saving an Excel file Bugs 41566 - Rendering PDF from Excel ignores Alpha 41511 - Print area header and footer does not appear when converting Excel to PDF 41498 - Graphic not exported properly 41582 - Excel Sparklines don't get saved in the rendered image 41576 - Image Contrast not preserved when rendering image from Excel 41541 - Some text/data is wrongly shared at the top 41560 - Incorrect calculation of GETPIVOTDATA in Aspose.Cells 7.4.2.x 41551 - Problem with XLSX to HTML conversion 41515 - Problem with XLSX to HTML conversion II 41496 - Problem with truncated cell text in the XLSX to HTML conversion 41578 - Cells next to Pivot table are populated with Pivot table’s values 41569 - Changing Pivot table’s data source will cause problems 41561 - Set Table as Pivot Table's data source problem 41556 - Issue with Pivot ranges 41509 - Pivot table’s formatting problem 41581 - Calculated values are not accepted by Pivot table's RefreshData() method 41580 - Error found when saving an Excel file 41563 - Excel to Html problem - the cell's characters are over wrapped 41540 - Pivot table borders are wrongly visible in the PDF 41453 - Pivot chart in the generated PDF is not the same as Pivot chart in the generated XLSX file 41489 - Data series Line styles’ cap Type property is reset to default 41530 - Data labels appear outside of the chart area 41478 - Changing the position of data labels is not working 41548 - Issue with a custom font color of the legend entry for a particular series 41597 - Hidden columns extracted as string data table have incorrect and empty values 41590 - Conditional formatting issue 41575 - After saving the file with Aspose.Cells, the last two columns move to the next page break 41562 - CalculateFormula is not working right 41550 - Copying a range of columns that are grouped, the grouping options/attributes are not copied 41547 - Values are hidden after saving an XLS file 41523 - Background of Ole Objects is changed to blue after double-conversion (XLS->XLSM->XLS) 41516 - Aspose.Cells does not update formulas properly when deleting rows 41513 - Excel formula optimizations in XLSX and XLS break formula calculations 41529 - Incorrect formula after deleting row when referencing a ListObject Header 41521 - ActiveX controls do not get copied when using Workbook.Copy(source) 41517 - Cell.HtmlString - Font size in the Cell is not correct 41594 - The generated XLSX's sorting does not work the same way as per MS Excel 41588 - RAND() and RANDBETWEEN() are not working