sherazam77
Well-known member
What is new in this release?
The long awaited version of Aspose.Cells for .NET 7.5.0 has been released. The new release includes a useful feature for adding a picture based on your desired range of cells as its data source. We have added some significant enhancements for shading a style’s fill effect for cells, opening CSV files with values longer than 32K in the cells and copying table and list object formulas accordingly when inserting new rows. We have fixed a few exceptions when refreshing PivotTable, saving to HTML and reading files. In this release, several important issues have been addressed. For example, issues around rendering Microsoft Excel 2007/2010 file formats, rendering PivotTables, converting Excel files to HTML format, manipulating worksheets, applying formatting, rendering charts, rendering image files and exporting to PDF have been resolved. An improvement is also made pertaining to the formula calculation engine. We have made a few enhancements and fix some bugs regarding cells sections and numbers formatting in the Grid controls provided by Aspose.Cells for .NET. This release includes few enhanced features and plenty of bug fixes as listed below
- Insert a picture based on cell reference (MS Excel 2010)
- Shading Style Fill Effect for cells is not working
- Open CSV file with value longer than 32K in a cell
- InsertRow / InsertRows does not copy Table/List Object formulas accordingly
- "Do not compress images in file" setting is changed
- Throw “CellsException” when a file contains MS Graph charts
- Formulas calculation is improved
- Collection was modified; enumeration operation may not execute
- Workbook saved as XLSX is corrupted and is now fixed
- Month now ordered the same as an XLSX copy in the PDF
- Problem resolved for duplicated column in XLSX to HTML conversion
- Pivot filter text copied to cells below it is now fixed
- Losing Value correction on PivotTable refresh is fixed
- One character becomes a question mark is fixed
- Pivot Table’s CalculatedField SUM now working for 10 digits -ve number on Windows XP
- Removing the “CustomUI14.xml” file from the Excel workbook
- IsAutoFormat setting of PivotTable affecting the hidden columns is now fixed
- MS Excel warning is resolved on opening the saved file
- Problem with custom date formatting in XLSX to HTML conversion is fixed
- Dates in Pivot Table now formatted correctly
- PivotTable headers are wrong in the converted PDF file is fixed
- PDF now showing the filtered items
- Total text of PivotTable is now rendered properly
- The very top line of the chart was cutoff and is now fixed
- Chart Legend position is corrected
- Chart is moved or resized after re-saving the file is fixed
- Converting an XLS file to PDF, the Charts and Images now update accordingly
- The name of the red line in the chart drops off partially is fixed
- Chart get resized when exported as Ole Frame is now fixed
- Chart Legend can now be aligned center
- Certain Copy/Paste features was broken and now are fixed
- The saved XLT document error is resolved if we save the document to streams
- Opening and saving file generates the corrupt file is fixed
- Sorting setting lost is fixed after re-saving and refreshing the filters
- Opening an XLT file by right clicking on it shows error is fixed
- Border breaks after inserting row is fixed
- Worksheet.Copy method Issue is resolved
- Aspose.Cells interfering with original VBA codes in the spreadsheet is fixed
- Range now extend its area accordingly
- Moving worksheet now validates Named Ranges
- Problem resolved with Subtotal (Smart Markers)
- File (with Smart Art) saved with Aspose.Cells is now opening with Open XML SDK
- Creates unreadable content in the XLSXM files is fixed
- Add-ins formula issue is resolved
- Processing document through Aspose.Cells is improved
- OpenOffice Document Spreadsheets issue resolved while opening the files
- Shapes getting copied correctly when using Worksheet.Cells.CopyRows
- Custom number formatting issue is resolved (GridDesktop)
Other most recent bug fixes are also included in this release.
Newly added documentation pages and articles
Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.
- Insert a Picture Based on Cell Reference
- Set External Links in Formulas
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.
More about Aspose.Cells for .NET
- Homepage of Aspose.Cells for .NET C#
- Product Overview of Aspose.Cells for .NET
- Download Aspose.Cells for .NET
- Online documentation of Aspose.Cells for .NET
- Demos of Aspose.Cells for .NET
- Post your technical questions/queries to Aspose.Cells for .NET Forum
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - Your File Format Experts
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465
The long awaited version of Aspose.Cells for .NET 7.5.0 has been released. The new release includes a useful feature for adding a picture based on your desired range of cells as its data source. We have added some significant enhancements for shading a style’s fill effect for cells, opening CSV files with values longer than 32K in the cells and copying table and list object formulas accordingly when inserting new rows. We have fixed a few exceptions when refreshing PivotTable, saving to HTML and reading files. In this release, several important issues have been addressed. For example, issues around rendering Microsoft Excel 2007/2010 file formats, rendering PivotTables, converting Excel files to HTML format, manipulating worksheets, applying formatting, rendering charts, rendering image files and exporting to PDF have been resolved. An improvement is also made pertaining to the formula calculation engine. We have made a few enhancements and fix some bugs regarding cells sections and numbers formatting in the Grid controls provided by Aspose.Cells for .NET. This release includes few enhanced features and plenty of bug fixes as listed below
- Insert a picture based on cell reference (MS Excel 2010)
- Shading Style Fill Effect for cells is not working
- Open CSV file with value longer than 32K in a cell
- InsertRow / InsertRows does not copy Table/List Object formulas accordingly
- "Do not compress images in file" setting is changed
- Throw “CellsException” when a file contains MS Graph charts
- Formulas calculation is improved
- Collection was modified; enumeration operation may not execute
- Workbook saved as XLSX is corrupted and is now fixed
- Month now ordered the same as an XLSX copy in the PDF
- Problem resolved for duplicated column in XLSX to HTML conversion
- Pivot filter text copied to cells below it is now fixed
- Losing Value correction on PivotTable refresh is fixed
- One character becomes a question mark is fixed
- Pivot Table’s CalculatedField SUM now working for 10 digits -ve number on Windows XP
- Removing the “CustomUI14.xml” file from the Excel workbook
- IsAutoFormat setting of PivotTable affecting the hidden columns is now fixed
- MS Excel warning is resolved on opening the saved file
- Problem with custom date formatting in XLSX to HTML conversion is fixed
- Dates in Pivot Table now formatted correctly
- PivotTable headers are wrong in the converted PDF file is fixed
- PDF now showing the filtered items
- Total text of PivotTable is now rendered properly
- The very top line of the chart was cutoff and is now fixed
- Chart Legend position is corrected
- Chart is moved or resized after re-saving the file is fixed
- Converting an XLS file to PDF, the Charts and Images now update accordingly
- The name of the red line in the chart drops off partially is fixed
- Chart get resized when exported as Ole Frame is now fixed
- Chart Legend can now be aligned center
- Certain Copy/Paste features was broken and now are fixed
- The saved XLT document error is resolved if we save the document to streams
- Opening and saving file generates the corrupt file is fixed
- Sorting setting lost is fixed after re-saving and refreshing the filters
- Opening an XLT file by right clicking on it shows error is fixed
- Border breaks after inserting row is fixed
- Worksheet.Copy method Issue is resolved
- Aspose.Cells interfering with original VBA codes in the spreadsheet is fixed
- Range now extend its area accordingly
- Moving worksheet now validates Named Ranges
- Problem resolved with Subtotal (Smart Markers)
- File (with Smart Art) saved with Aspose.Cells is now opening with Open XML SDK
- Creates unreadable content in the XLSXM files is fixed
- Add-ins formula issue is resolved
- Processing document through Aspose.Cells is improved
- OpenOffice Document Spreadsheets issue resolved while opening the files
- Shapes getting copied correctly when using Worksheet.Cells.CopyRows
- Custom number formatting issue is resolved (GridDesktop)
Other most recent bug fixes are also included in this release.
Newly added documentation pages and articles
Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.
- Insert a Picture Based on Cell Reference
- Set External Links in Formulas
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.
More about Aspose.Cells for .NET
- Homepage of Aspose.Cells for .NET C#
- Product Overview of Aspose.Cells for .NET
- Download Aspose.Cells for .NET
- Online documentation of Aspose.Cells for .NET
- Demos of Aspose.Cells for .NET
- Post your technical questions/queries to Aspose.Cells for .NET Forum
- Receive notifications about latest news and supported features by subscribing to Aspose.Cells for .NET blog
Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Australia
Aspose - Your File Format Experts
sales@aspose.com
Phone: 888.277.6734
Fax: 866.810.9465