What’s new in this release?
We are pleased to announce the new release of Aspose.Cells for .NET 8.4.2. This release contains some useful features and other enhancements. The most worth mentioning feature of the release is the support for adding VBA modules to the spreadsheets. Starting with this release, Aspose.Cells for .NET has provided support for adding VBA modules to the spreadsheets. Aspose.Cells for .NET 8.4.2 has exposed the VbaModuleCollection.Add method to add a new VBA module to the instance of Workbook. The VbaModuleCollection.Add method accepts a parameter of type of Worksheet to add a worksheet specific module, whereas the existing VbaModule class contains all the module specific properties. Aspose.Cells for .NET 8.4.2 has exposed simplified mechanism to create charts on the fly. Please note, the conventional means of creating charts involves several steps that may include, but not limited to specifying the series and category axis data ranges separately. With new mechanism, all you have to do is to specify the chart’s data range while using the Chart.SetChartDataRange method. The SetChartDataRange method accepts two parameters, where first parameter is of type String in order to specify the cell area from which to plot the data series. The second parameter is of type Boolean that specifies the plot orientation, that is; whether to plot the chart data series from a range of cell values by row or by columns. In the new version, we have also provided some important new enhancements, such as support for IFNA function, added an overloaded version of Cells.CopyColumns method that can be used to repeat the source columns onto the destination while copy operation, exposed 2 new fields for the PasteType enumeration in order to mimic the Excel’s ‘All’ & ‘All except borders’ functionality for pasting range of cells. In this release, several important issues have been addressed. For example, issues around reading/ writing Microsoft Excel file formats, deleting rows, retrieving data validation applied on the cells, manipulating list objects/ tables, rendering to HTML file format, manipulating drawing objects and shapes, rendering images from Excel worksheets, manipulating charts with formatting, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. We have also enhanced the Aspose.Cells formula calculation engine and fixed a few relevant issues in this release. This release includes several enhanced features and bug fixes as listed below
Overview: Aspose.Cells for .NET
Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.
We are pleased to announce the new release of Aspose.Cells for .NET 8.4.2. This release contains some useful features and other enhancements. The most worth mentioning feature of the release is the support for adding VBA modules to the spreadsheets. Starting with this release, Aspose.Cells for .NET has provided support for adding VBA modules to the spreadsheets. Aspose.Cells for .NET 8.4.2 has exposed the VbaModuleCollection.Add method to add a new VBA module to the instance of Workbook. The VbaModuleCollection.Add method accepts a parameter of type of Worksheet to add a worksheet specific module, whereas the existing VbaModule class contains all the module specific properties. Aspose.Cells for .NET 8.4.2 has exposed simplified mechanism to create charts on the fly. Please note, the conventional means of creating charts involves several steps that may include, but not limited to specifying the series and category axis data ranges separately. With new mechanism, all you have to do is to specify the chart’s data range while using the Chart.SetChartDataRange method. The SetChartDataRange method accepts two parameters, where first parameter is of type String in order to specify the cell area from which to plot the data series. The second parameter is of type Boolean that specifies the plot orientation, that is; whether to plot the chart data series from a range of cell values by row or by columns. In the new version, we have also provided some important new enhancements, such as support for IFNA function, added an overloaded version of Cells.CopyColumns method that can be used to repeat the source columns onto the destination while copy operation, exposed 2 new fields for the PasteType enumeration in order to mimic the Excel’s ‘All’ & ‘All except borders’ functionality for pasting range of cells. In this release, several important issues have been addressed. For example, issues around reading/ writing Microsoft Excel file formats, deleting rows, retrieving data validation applied on the cells, manipulating list objects/ tables, rendering to HTML file format, manipulating drawing objects and shapes, rendering images from Excel worksheets, manipulating charts with formatting, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. We have also enhanced the Aspose.Cells formula calculation engine and fixed a few relevant issues in this release. This release includes several enhanced features and bug fixes as listed below
- Add new Module to Worksheet VbaProject
- Support of IFNA formula/function
- Text is moved out of banner when Excel file is converted to PDF
- Watermarks are not displayed correctly
- Unable to save embedded OLE-object from the XLSX to the HTML
- Custom font does not work with SheetRender
- Columns moved to next page when converting to PDF
- Incorrect page break in the generated PDF via Aspose.Cells
- SheetRender.ToImage generated image has text getting cutoff
- Incorrect Pie Chart's datalabel value
- Data labels' text exceeds the chart area when converted to PDF
- Converting Chart to Image and inserting the image
- Major Grid lines disappear and series legend comes on center
- X-Axis labels are not properly displayed
- Issue with calculating formulas when enable Iterative calculation
- Incorrect formula results for PERCENTRANK function
- Issue with calculating LINEST formula/ function
- Spreadsheet disappears from view when Restore Window button is clicked
- System.ArgumentOutOfRangeException while loading a file saved by Aspose.Cells for Java
- ListObjects.DataRange does not update after deleting a row
- Cells.DeleteRows makes the spreadsheet corrupted
- Vlookup formula was not calculated correctly
- Xlsx file gets corrupt on opening and saving
- Cell.GetValidationValue not working for numeric list
- SaveCommand event is not firing
- IE8 is not working fine with Dutch-Belgium custom format
Overview: Aspose.Cells for .NET
Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.
- Homepage of Aspose.Cells for .NET C#
- Download Aspose.Cells for .NET
No comments:
Post a Comment