Open Large CSV Files in Excel and Insert Picture Based on Cell Reference

The long awaited version of Aspose.Cells for .NET 7.5.0 has been released. The new release includes a useful feature of adding a picture based on your desired range of cells as its data source. Aspose 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. Aspose 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. Aspose 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 / InsertRowsdoes 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.