Aspose.Cells for .NET

Aspose.Cells for .NET 7.2.1 (DLLs only)

Amjad Sahi — Thu, 17 May 2012 07:31:37 GMT

This ZIP file contains only the Aspose.Cells for .NET assemblies. The assemblies are the same as in the MSI installer of the product of the same version.

Download this if you want to use Aspose.Cells without the MSI installer, for example, you might not run MSI installers on Mono or some other environments.

This ZIP download does not contain the user documentation in the Microsoft Help format and does not contain the demo projects that are included in the MSI installer.

Aspose.Cells for .NET 7.2.1

Amjad Sahi — Thu, 17 May 2012 06:51:33 GMT

We are happy to announce Aspose.Cells for .NET v7.2.1!

1) Aspose.Cells

Enhancements

40580 - Shapes’ lines are incorrectly filed after converting to PDF

40588 - Macro disappeared after saving an XLSM file to XLS format

40589 - List box options overlap one another

40591 - Aspose.Cells corrupting XLSM file after calling the Workbook.Save() method

40621 - The component destroys properties of the workbook XML’s CalcPr node

40646 - You want to put a string longer than 32K

40659 - Smart Markers syntax for column index

40662 - Smart Markers - Nested Objects

Exceptions

40583 - GetNamedRanges() method throwing Unsupported function

40587 - Exception: Invalid IMEModeType string val

40590 - Exception while loading an XLSX Spreadsheet from SharePoint

40596 - GetNamedRanges() method throwing NullReferenceException

40614 - Exception while initializing with .xlsm input file

40618 - Fails to open a document with complex formula(s)

40635 - Exception on PivotTable’s RefreshData() method

40650 - Error found while creating a new SheetRender object

40653 - Exception while file was opening

Bugs

40438 - Disappearing chart title in the Pie charts

40446 - Chart to image conversion is not working properly

40456 - Mismatches between Excel chart and the exported chart’s image

40459 - Problems with DataTable in charts when converting to image

40477 - Problem with DataTable in MS Excel charts

40550 - Differences in chart’s appearance between MS Excel and PDF

40575 - Converting Excel 97- 2003 to PDF

40577 - Aspose.Cells corrupting XLSM file after calling the Save twice

40582 - Bookmarks on one level issue

40592 - Aspose.Cells permanently hides ActiveX control on Save operation

40598 - Excel 2010 files with Pen data is getting corrupted

40599 - VLookup with an Indirect returns a “#REF” value

40606 - The Save call corrupts an XLSM file

40612 - Named ranges disappeared after Worksheet’s Copy

40615 - VLookup with an Indirect returns a “#REF” value - 2

40620 - Copied chart rotates the Display Unit Labels by 90 degrees

40622 - Calculation bug with a Workbook

40623 - Performing Subtotal Calculations on Grouped Column

40629 - The issues for PDF conversion regarding drawing shapes

40630 - Named Ranges issue

40632 - Aspose.Cells corrupting Excel files which contain Pivot Tables

40636 - XLSX to PDF conversion issues

40641 - Aspose.Cells handles Date value incorrectly

40649 - Get error while creating a new Workbook from the file

40651 - Named range does not grow horizontally with Smart Markers

40661 - Issue found in the relative XML file

40672 - Shape name changed after saving the XLSM file into new workbook

40674 - Bug with VLookup formula having wild cards (e.g. “*”)

2) GridWeb

Bugs

40426 - Shapes in the file does not display correctly

40594 - GridWeb1.SelectCells is Null

3) GridDesktop

Bugs

40616 - Headers are aligned to top instead of center

Aspose.Cells for .NET 7.2.0 (DLLs only)

Amjad Sahi — Fri, 13 Apr 2012 08:28:37 GMT

This ZIP file contains only the Aspose.Cells for .NET assemblies. The assemblies are the same as in the MSI installer of the product of the same version.

Download this if you want to use Aspose.Cells without the MSI installer, for example, you might not run MSI installers on Mono or some other environments.

This ZIP download does not contain the user documentation in the Microsoft Help format and does not contain the demo projects that are included in the MSI installer.

Aspose.Cells for .NET 7.2.0

Amjad Sahi — Fri, 13 Apr 2012 08:00:14 GMT

We are happy to announce Aspose.Cells for .NET v7.2.0!

1) Aspose.Cells

Enhancements

40471 - Cells.ImportDataView only imports 65535 rows

40497 - Could not update ComboBox in XLSM file

Exceptions

40517 - Shapes.AddCopy throws: Index was out of range

40562 - NullReferenceException after copying worksheet

40564 - Exception: Invalid MsoLineDashStyle string val occurred while opening the file

40495 - Unable to convert some XLSX files to TIFF format

Bugs

40454 - .NET C++ Build Error C2686

40482 - Converting XLS file to XLSX discard text formatting

40510 - Copy charts from one workbook to another

40509 - Corrupted cell coloring after worksheet copying

40504 - Hyperlinks not moving with sorted cells

40532 - Chart problems in designer Spreadsheet

40545 - Worksheet.Copy() does not copy values for invalid formulas

40538 - Applying custom style to cells issue

40543 - ListBox does not recognize selection changes

40563 - Chart Title is lost when opening XLSM file with Office 2010

40421 - Bugs when converting an Excel file into an image.

40167 - Upgrade from version v5.1 to v7.0.3

40511 - Charts.ToImage() quality issue

40478 - Charts Gradient effects problem

40458 - Formula calculation engine problem

40512 - Problem with calculated cells when saving in PDF format

40536 - Cells Calculation is incorrect

40505 - Custom formatting of text values when exporting to PDF

40432 - Issue with Excel to PDF Conversion

40469 - Workbook gets corrupted by removing a sheet which has a pivot table

40486 - Tables as Data Source for PivotTable broken using Designer

40513 - Corruption when adding fields to Pivot Table

40518 - Issue on Pivot Table Rendering After Refresh

40513 - Corruption when adding fields to Pivot Table

40534 - Integrity problems with MS Excel 2003

40542 - Style for Pivot Table issue

40547 - SheetRender is not wrapping text properly

40470 - Worksheet’s Custom Properties with large values

40468 - The component is corrupting objects which contain Excel Add-In Formulas

40455 - Cannot get Picture images to print accurately in Aspose.Cells

40496 - Error while using WorkBook.Copy() method

40556 - Microsoft Office File Validation Add-In Warning

40559 - Problems with saving to XLS format with ClearData option

40525 - Conditional formatting - Compatibility problems with *.XLSB

40529 - Corrupted workbook after a simple opening\saving

40533 - Excel produces invalid XLS file when converting XLSX file created by Aspose.Cells

40544 - Save may corrupt workbook when CurrentCulture is not English

2) GridWeb

Bugs

40494 - AutoFit Rows Bug

3) GridDesktop

Bugs

40433 - Borders are shown in the wrong place while import an Excel file to Grid

Aspose.Cells for .NET 7.1.2 (DLLs only)

Amjad Sahi — Tue, 13 Mar 2012 14:42:53 GMT

This ZIP file contains only the Aspose.Cells for .NET assemblies. The assemblies are the same as in the MSI installer of the product of the same version.

Download this if you want to use Aspose.Cells without the MSI installer, for example, you might not run MSI installers on Mono or some other environments.

This ZIP download does not contain the user documentation in the Microsoft Help format and does not contain the demo projects that are included in the MSI installer

Aspose.Cells for .NET 7.1.2

Amjad Sahi — Tue, 13 Mar 2012 13:10:52 GMT

We are happy to announce Aspose.Cells for .NET v7.1.2!

1) Aspose.Cells

New Features

40318 - Support Tables in XLS files

40423 - Customizing the Ribbon XML

40452 - Support Workbook.ContentTypeProperties

Enhancements

40440 - IF() Formula returns “0” instead of “#N/A”

40345 - Problems with FirstPageNumber property

40413 - Layout changed when document is converted to PDF

40135 - The property 'DragData' is missing in 'PivotField'

40246 - Change DataSource on Pivot Table.

40377 - Issues with Pivot Tables

40360 - Convert Workflow diagram/shapes to image(s)

Performance

40271 - Worksheet.RemoveFormulas - performance issue

40063 - Pdf Generation => OutOfMemoryException

40317 - Excessive memory usage when converting Excel-to-PDF

40369 - Save to PDF uses 3GB for a 10MB Excel file

40409 - Opening Workbook takes too long to open

Exceptions

40405 - NullReference exception during Save operation if copying worksheet from other workbook

40380 - Crash on Workbook.CalculateFormula() method

40439 - RowSpan Attribute throws Exception

40446 - ArgumentOutOfRangeException occurred while initializing the file

Bugs

40320 - VLOOKUP and OFFSET functions issues

40373 - IRR is not computed correctly

40396 - MS Excel Calculations’ problems

40430 - Array Formula using Indirect() function copies only 1 value

40435 - CellsException in calculating TREND() formula

40374 - Copy worksheet replaces header and footer

40398 - Problem Printing Excel file with embedded EMF images

40382 - Pivot Table Issue - Formatting Filter bug

40431 - PivotField - Reading items from the cache

40429 - Multiple issues while upgrading to latest versions

40365 - Creating Workbook with InputStream is not working

40393 - Generated XLS file is crashing MS Excel

40394 - Dropdown and Chart are removed from workbook after Save

40424 - Aspose.Cells not correctly applying custom cell’s formatting

40367 - XLSM files are corrupted under certain conditions

40407 - The Cell Font size format with non-integer number changed

40415 - Insert Symbol at the end of a cell value

2) GridDesktop

Bugs

40341 - Graph values are wrongly displayed for XLSX file

40314 - SUM() issue in GridDesktop’s worksheet

40370 - GridDesktop.ImportExcelFile() throws exception

40371 - Index was outside the bounds of the array

40383 - GridDestop’s issue on formula cell(s)

40406 - Griddesktop.ImportExcelFile() throws OutOfMemoryException

Aspose.Cells for .NET 7.1.1 (DLLs only)

Amjad Sahi — Mon, 13 Feb 2012 10:06:04 GMT

This ZIP file contains only the Aspose.Cells for .NET assemblies. The assemblies are the same as in the MSI installer of the product of the same version.

Download this if you want to use Aspose.Cells without the MSI installer, for example, you might not run MSI installers on Mono or some other environments.

This ZIP download does not contain the user documentation in the Microsoft Help format and does not contain the demo projects that are included in the MSI installer.

Aspose.Cells for .NET 7.1.1

Amjad Sahi — Mon, 13 Feb 2012 09:26:10 GMT

We are happy to announce Aspose.Cells for .NET v7.1.1!

1) Aspose.Cells

New Features

40294 - Tracing Precedents and Dependents

Enhancements

40338 - Saving workbook in XLSX is throwing error

40351 - AutoFitColumn options

19106 - Is there GetDependents() method in the .NET version

40356 - Support TH elements in the HTML Table

40156 - Excel to PDF (Arabic) - Incorrect word/date formatting on conversion

40280 - Antivirus software strips out Excel files from emails

Exceptions

40334 - Error while opening a file which has one worksheet with name containing: “!” character

40141 - Exceptions on loading valid Excel file - every time

40355 - Range of AutoFilter is not valid

40290 - Exception after using Combine() and Save() methods for workbooks with external references

Bugs

40296 - Conditional Formatting issue as of the version v4.8.1

40289 - Button properties

40308 - Cells with Feet and Inches are incorrect when converted to PDF

40309 - Problem rendering em dash characters in PDF output

40144 - Page Layout changed in the Merged workbook

40336 - Save as XLSX sometimes produces an invalid file

40327 - XLS file opens in Protected mode after using Aspose.Cells

40350 - Cell.GetDependents() doesn't work with NamedRange

40340 - AutoFitRow and IndentLevel issue

40359 - Problem with named range when using Combine operation

40298 - TickLabels are not visible when the no. of Ticklabels’ count is larger

40358 - Problems translating MS Excel charts to PDF, Y-Axis missing

40293 - Issues with Line width in Graphics and blank text areas

40302 - Issue with ADDRESS, COUNTBLANK, and IF Functions

40320 - VLOOKUP AND OFFSET FUNCTIONS Issues

40315 - No MS Excel Formula Validation

40346 - Problems with NETWORKDAYS function in XLS output

40183 - HTML-to-Excel Conversion Issues

40361 - HTML’s rowspan and class attributes issues

40357 - Does Cells support datauri

40349 - Custom formatted borders lost when converting to PDF

40332 - Gridlines in PDF Export

40300 - Excel Found Unreadable Content error

40331 - Extract the custom pivot style out from the template file

40300 - Issue found in MS Excel: “Excel Found Unreadable Content…”

40323 - Column alignment in image when using SheetRender API

40339 - Excel rendering issue

2) Aspose.Cells.GridWeb

Bugs

40335 - Text Wrap Issue for GridWeb

40313 - GridWeb.SaveToExcelFile not including newly inserted data

40347 - Text vertical-alignment setting doesn't work

3) Aspose.Cells.GridDesktop

Bugs

40297 - String was not recognized as a valid Boolean

Aspose.Cells for .NET 7.1.0 (DLLs only)

Amjad Sahi — Mon, 16 Jan 2012 10:54:53 GMT

This ZIP file contains only the Aspose.Cells for .NET assemblies. The assemblies are the same as in the MSI installer of the product of the same version.

Download this if you want to use Aspose.Cells without the MSI installer, for example, you might not run MSI installers on Mono or some other environments.

This ZIP download does not contain the user documentation in the Microsoft Help format and does not contain the demo projects that are included in the MSI installer.

Aspose.Cells for .NET 7.1.0

Amjad Sahi — Mon, 16 Jan 2012 10:10:47 GMT

We are happy to announce Aspose.Cells for .NET v7.1.0!

1) Aspose.Cells

New Features

40082 - Support to apply Conditional Formatting to Pivot Tables

40176 - Read configuration of Group Fields in Pivot Tables

40245 - Convert Worksheet to SVG

Enhancements

40109 - NullReferenceException when opening document with auto-formatted Pivot Table

40147 - Pivot Table’s filtering in MS Excel 2007 and later versions

40148 - Chart’s formatting issue

40157 - Copying worksheet does not work

40172 - Smart Marker Tags conversion

40179 - Missing properties (Pivot Table)

40180 - Missing properties (Pivot Field)

40213 - PivotField.ShowCompact - Incorrect property value in XLS format

40215 - Pivot Field’s incorrect items value in the grouped fields

40217 - Reading items from cache (Pivot Field)

40268 - Problems opening a SpreadsheetML file

Performance

40121 - Performance issue on adding range names

40257 - Memory exception and formula calculations on cells

Exceptions

40047 - Unable to copy a particular worksheet into another workbook

40117 - Pivot table throws exception while refreshing

40235 - ListBox with assigned Input range causes Aspose.Cells crush

Bugs

40042 - Failed to refresh pivot table in an Excel workbook

40066 - Problem with default paper size

40119 - Dirty right border on image when converting XLS to PDF

40152 - Workbook.CalculateFormula() method bug

40178 - Multiple issues found while upgrading from v5.2.1.0 to v7.0.3.0

40184 - Unable to include Row/Column Headings and Comments in the TIFF file

40186 - Excel-to-Html - word-wrap problem

40190 - Button’s font attributes are changed after Save

40195 - Chart’s legend becomes shrunk using Shape.UpperLeftRow() method

40203 - Error in the output PDF document

40204 - Multi-line Headers not supported while rendering to PDF file

40205 - Reading all data from the base fields of Pivot Table

40210 - Exporting Excel sheet to DataTable gives error

40231 - Opening ODS files issue

40232 - Cell border is not rendered properly with Aspose.Cells v7.0.4.x

40234 - Formula results in #Ref

40241 - XLS file crashes MS Excel 2007

40255 - Error opening file using Ms Excel

40259 - Problem with HTML output in the new Aspose.Cells DLL (version)

40261 - Updating XLSX file with Pivot Table causes Excel to display error

40262 - ToImage function generating extra column in the generated image (Sheet-to-Image issue)

40272 - Excel 2007 workbook with multiple colored tables is not rendered in the converted PDF file

40273 - Using the Fitting Sheet on One Page option in Excel to convert to PDF does not seem to work

40274 - Multiple issues while upgrading from v5.2.1.0 to v7.0.3.0

2) Aspose.Cells.GridDesktop

New Features

40115 - MS Excel’s Grouping Data feature while importing to the GridDesktop

3) Aspose.Cells.GridWeb

Bugs

40196 - Importing an XLSX file to the GridWeb issues

40267 - Formula does not work well

Aspose.Cells for .NET 7.0.4 (DLLs only)

Amjad Sahi — Mon, 19 Dec 2011 07:56:59 GMT

This ZIP file contains only the Aspose.Cells for .NET assemblies. The assemblies are the same as in the MSI installer of the product of the same version.

Download this if you want to use Aspose.Cells without the MSI installer, for example, you might not run MSI installers on Mono or some other environments.

This ZIP download does not contain the user documentation in the Microsoft Help format and does not contain the demo projects that are included in the MSI installer.

Aspose.Cells for .NET 7.0.4

Amjad Sahi — Mon, 19 Dec 2011 07:12:45 GMT

We are happy to announce Aspose.Cells for .NET v7.0.4!

1) Aspose.Cells

New Features

40055 Support calculating GETPIVOTDATA function

Enhancements

22235 Icon sets are lost from Excel spreadsheet

29583 No Connectors are rendered to PDF

30699 Color of conditional formatting changes

40038 Read chart from ODS file

40095 Enumeration for property 'DataDisplayFormat'

40098 Strange behavior of AutoShowCount (PivotTable)

40112 Formula and Value setters are interfering one with the other

40114 Compatibility problems in the Pivot Table

40147 PivotTable’s filtering in Excel 2007 and later versions

40172 Smart Marker Tags are converted to #NAME?

Exceptions

40097 Another Get Named Ranges Exception: Object Reference not set

40105 Exceptions while accessing items in fields with the Subtotals

40111 RefreshPivotData issue

40126 ‘ArgumentException’ when opening the document

Performance

40123 CalculateFormula is time consuming once the workbook is saved with the product

Bugs

23657 Embedded OLE Object is removed from an ODS file after re-saving the file

40089 Embedded message is OleFileType.Unknown

40092 Issue while reading Pivot Table style from an XLS file

40108 After Workbook.Save, the XLSX file loses Excel 2010 features

40110 Uncheck Multi-level Category Labels in Charts

40116 Conditional formatting formulas are incorrect after inserting/copying/deleting column

40128 Copying charts issue

40133 Delete range loses data validation

40134 PivotTable.EnableFieldList - Incorrect property name and description

40136 UpdateLinkedDataSource issue

40140 Problems after migration to Aspose.Cells for .NET v7.0.3

40145 Conditional Formatting on pivot table getting scrambled

40151 Legend key of Pie Chart has the wrong color

40160 Invalid Excel2007Xlsx file format issue while loading an XLSX file

40162 Error found while working with XLSM file

40164 InsertRange method breaks formula referencing entire column

40165 Excel found unreadable content error after worksheet was deleted

40171 Cell value returns incorrect value after calling Workbook.CalculateFormula

40173 Invalid PageOrientationType issue

2) GridDesktop

Bugs

40090 Does not update the calculated results in the resultant cells after entering values

40015 Issue with grouping rows/columns

40096 Custom date formatting issue in GridDesktop

Aspose.Cells for .NET 7.0.3 (DLLs only)

Amjad Sahi — Wed, 16 Nov 2011 08:24:41 GMT

This ZIP file contains only the Aspose.Cells for .NET assemblies. The assemblies are the same as in the MSI installer of the product of the same version.

Download this if you want to use Aspose.Cells without the MSI installer, for example, you might not run MSI installers on Mono or some other environments.

This ZIP download does not contain the user documentation in the Microsoft Help format and does not contain the demo projects that are included in the MSI installer.

Aspose.Cells for .NET 7.0.3

Amjad Sahi — Wed, 16 Nov 2011 08:05:49 GMT

We are happy to announce Aspose.Cells for .NET v7.0.3!

Aspose.Cells

New Features

24953 Support MS Excel’s advanced conditional formatting in the generated PDF file

30020 Support Cell Gradient Color that is not set properly while converting to PDF document

40010 Uncheck Multi-level Category Labels while formatting Chart’s Axis

Enhancements

31243 Copy range with validation

31347 Sorting & Dynamic formulas in Smart Markers

40027 Implement ToString() method in the Cell, Range, Worksheet and other classes/objects

40080 Enhancement - Excel95 - Excel 2003 file

40081 Error checking options not working with XLSM files

Exceptions

31331 Error occurred while opening XLS file

40045 NullReferenceException found when setting Header/Footer in Page Setup

40047 Unable to copy a particular worksheet into another workbook with one worksheet

40060 Invalid Brush Type when converting Excel workbook to XPS

40061 StackOverflow on calling WorksheetCollection.GetNamedRanges() method

Performance

31266 XLS to PDF or XPS takes so much time

40053 Excel-to- PDF Performance decreases as number of worksheets increases

Bugs

29234 Hide pivot table columns issue

30224 Charts images do not match Excel’s charts

30651 Cell.SetStyle(Style style, bool explicitFlag) doesn't work as expected

31334 BuiltInDocumentProperties.HyperlinkBase can’t be read or set

40009 Opening XLSM file issue

40012 The Style changed after merging or adding copy sheet to workbook operation

40013 RowField Subtotal – formatting issue

40014 Opening and saving XLSM file throws away macros and ribbons

40016 Errors while saving Excel files

40024 Charts not rendering fine in rendering / copying workbooks

40046 Pivot table does not refresh correctly

40057 Array formula references aren't updated on deleting a row or column

40065 Negative bigInt problem

40073 Aspose.Cells Smart Markers parameters problem

40074 Chart disappears after Save

40075 Problems found while refreshing Pivot table

40076 Error while saving XLSM file

40079 Usage of Excel’s default conditional formatting is not working

GridDesktop

New Features

29869 Support Conditional formatting (only Excel 2003 styles are supported (currently))

Bugs

40022 Parameter is not valid exception

40029 Issue: “Address of the site is not valid" regarding hyperlinks in the sheet

40051 ImportFromExcelFile gives problem while loading an XLSX file (with merged cells) from MemoryStream

40064 Bulleted contents are not displayed correctly

18463 Problems in grand total calculation in Pivot Table

Aspose.Cells for .NET 7.0.2 (DLLs only)

Amjad Sahi — Fri, 14 Oct 2011 11:33:44 GMT

This ZIP file contains only the Aspose.Cells for .NET assemblies. The assemblies are the same as in the MSI installer of the product of the same version.

Download this if you want to use Aspose.Cells without the MSI installer, for example, you might not run MSI installers on Mono or some other environments.

This ZIP download does not contain the user documentation in the Microsoft Help format and does not contain the demo projects that are included in the MSI installer.