What’s new in this release?
We are pleased to announce the new release of Aspose.Cells for .NET 7.6.1. This new release supports calculating the color selected by MS Excel when a ColorScale Conditional formatting is used in the template file. Moreover, we have enhanced the product regarding encrypted files in such a way that these do not raise FIPS validation error now. We have also added some significant improvements for the generated password protected files (by Aspose.Cells), so OOXML API does not raise an exception anymore when loading/opening the files in it. Please see the sample code on how to compute the color selected by MS Excel for ColorScale conditional formatting in original blog post. We have fixed an exception when rendering images from Excel worksheets.
In this release, several important issues have been addressed. For example, issues around rendering Microsoft Excel file formats, rendering and manipulating PivotTables , rendering images from Excel worksheets , manipulating custom document properties, working with advanced conditional formatting (MS Excel 2007/2010), rendering and manipulating Charts, rendering images files from Charts and exporting Excel workbooks to PDF format have been resolved. A few improvements are also made pertaining to the formula calculation engine of Aspose.Cells for .NET.
We have made a few enhancements regarding navigation b/w worksheets in the web based grid control provided by Aspose.Cells for .NET. Now, you may select a range of cells and delete the cells/data in one go. We also fixed an issue regarding CellImage object in GridWeb. This release includes few enhanced features and plenty of bug fixes as listed below
In this release, several important issues have been addressed. For example, issues around rendering Microsoft Excel file formats, rendering and manipulating PivotTables , rendering images from Excel worksheets , manipulating custom document properties, working with advanced conditional formatting (MS Excel 2007/2010), rendering and manipulating Charts, rendering images files from Charts and exporting Excel workbooks to PDF format have been resolved. A few improvements are also made pertaining to the formula calculation engine of Aspose.Cells for .NET.
We have made a few enhancements regarding navigation b/w worksheets in the web based grid control provided by Aspose.Cells for .NET. Now, you may select a range of cells and delete the cells/data in one go. We also fixed an issue regarding CellImage object in GridWeb. This release includes few enhanced features and plenty of bug fixes as listed below
- Compute the color chosen by MS Excel when a ColorScale conditional formatting is used
- IE10 support and enhancements regarding navigation between worksheets in GridWeb
- Password protected files raising FIPS validation error is now resolved
- Aspose.Cells locked template file and not opening with OOXML is now fixed
- Delete several cells at the same time using mouse selection is fixd
- ConditionalFormattingResult.ConditionalFormattingIcon crashes in certain conditions
- Missing Arrows when converting Excel to PNG format is now fixed
- Random "Excel found unreadable contents…" message after processing with Aspose.Cells is now fixed
- The hidden text issue is resolved when the cell had a background-color set
- An issue is resolved for copying Pivot chart
- Value corrected for updating when re-populate a data source table
- Double strikethrough on chart data labels, axis or legends items is now saved
- Issue with Date format in image generation is resolved
- Chart issue is fixed after converting it to image
- Converting Pivot Charts into PDF results in x-axis values overlapping the graph
- Adding custom document property with characters such as, <, > etc.
- Text formula is now calculated correctly
- Aspose.Cells now returns correct Hyperlink.TextToDisplay value for web links Formula issue is resolved when trying to set formula through a whole formula column
- Wrong value is fixed in VerticalAlignment when using XML Spreadsheets
- Copying rows with merged cell(s) is improved
- OpenDocument spreadsheet format - Problem with file-based relative hyperlinks
- Input string was now in a correct format error
- IFS formulas are now calculated successfully
- Aspose.Cells copy command button and macro code fine
- PivotTable with Smart Markers issue is fixed
- XLS with Japanese characters are now properly converted to PDF correctly
- Problem with footer in XLS to PDF conversion is fixed
- Footer is getting overlapped with data in the output PDF is now fixed
- Formatting issues are resolved in the output PDF
- Getting an issue in underline when saving as image is now fixed
- Quality difference between PDFs generated by MS Excel and by Aspose.Cells
- Save as PDF Borders problems is now fixed
- Appearance issue is resolved with pivot columns with colors
- SheetRender renders an image with black patches is now fixed
- Height of the image gets increased by opening and saving the file is now fixed
- Worksheet.CalculateFormula behavior in case of formula error is fixed
- GridLines now correclly appear when rendered to image using SheetRender
Other most recent bug fixes are also included in this release
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.
No comments:
Post a Comment