Aspose.Cells for .NET

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.

Aspose.Cells for .NET 7.0.2

Amjad Sahi — Fri, 14 Oct 2011 11:13:30 GMT

We are happy to announce Aspose.Cells for .NET v7.0.2! In this version, we made several enhancements and fixed number of user issues/bugs. Moreover, we have removed some unnecessary older obsolete methods for Sheet-to-Image feature now.

1) Aspose.Cells

New Features

30970 Access document properties of an encrypted XLS file

Enhancements

30919 The Worksheet’s TabColor property for Chart type worksheets

25224 Export data without XLS limitation to SpreadsheetML file

30672 Smart Markers - How to group Rows (Calculate Totals, Sub-Totals and Grand Totals)

Exceptions

30548 StackOverflowException occurred when opening certain files

30609 Workbook constructor throws NullReferenceException

30989 Exception: Invalid Excel2007Xlsx file

Bugs

29663 Converting Excel-to-PDF (missing elements issue)

29692 Problem in Excel-to-PDF conversion

29840 Problem with version 6.0.1.3 (regarding Charts)

30102 Problem with Chart Image regarding Data labels and Error bars

30270 Printing issue - Numbers are shown as “#######”

30533 Problem with DeleteRange function

30603 EMF Vs PNG Issue

30729 Wrap Issue when converting XLS-to-PDF

30755 Saving as SaveFormat.XLSM causes errors

30785 Unable to change line style of a ChartPoint

30787 Broken shapes in the copied worksheet

30843 Formulas using intersected ranges don't work

30877 Dates are shown as serial numbers in Charts

30918 Image problems when saving to XLS format

30949 Cell content is splitting part way through a word when converting XLS-to-PDF

30980 Loading and Updating XLSM then Saving causes ERRORS

30998 Problems with Excel 2010 and XLSM

31003 Issue with AutoFitRow and the AutoFitMergedCells

31005 Negative Values in Parentheses

31068 Saving file crashes after using DeleteRange method in some cases

31078 Refresh Pivot table - It does not sort properly

31095 AutoFitRows doesn't work fine

31098 SheetRender exports double-spaces / inconsistent spacing

31099 Issue with Chart’s legend items wrapping when saving as an image

31102 There are too much formats in the worksheet

31195 SheetRender exports chart with wrong height

31243 Copying range with validation

31277 Saving to XLSX the document is Write-Protected

2) GridDesktop

Bugs

31051 GridDesktop issue while loading an Excel document

31053 Parameter is not valid exception occurred in GridDesktop

31071 Incorrect rendering of document via GridDesktop.ImportExcelFile method

Aspose.Cells for .NET 7.0.1 (DLLs only)

Amjad Sahi — Fri, 09 Sep 2011 09:54:20 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.1

Amjad Sahi — Fri, 09 Sep 2011 09:44:07 GMT

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

1) Aspose.Cells

New Features

29512 Add a new overloaded method: Cell.SetStyle(Style style, bool explicitFlag)

Enhancements

30331 Add and Delete Rows in the ListObject / Table

Performance

30177 Stack Overflow Exception while generating a PDF file from an ODS file

30045 Aspose.Cells hangs up when opening the file

Exceptions

30188 Error occurred when converting Date column (with empty string) in Excel XML format

30252 “’o:relid' is a duplicate attribute name” Exception

Bugs

29876 Security Warning issue

27781 Excel chart legends shrinking when saving Excel workbook

29620 Excel chart lose some formatting when opening and saving it

30246 Worksheet.IsVisible = false groups sheets in the workbook

29632 Feature request regarding Exception handling while adding worksheets

30303 Problem in copying Worksheets

30035 MS Excel (Format->AutoFit Row Height) VS Aspose.Cells’ AutoFitRow feature

29841 Problem with Pie chart

30154 Issue with Chart data labels

30153 Macros are disabled in the output XLSM file

30332 Problem with Chart axis scale changing

30308 Secondary Axis in XLSX lost on Save

2) GridDesktop

New Features

29821 Support formula bar control

Aspose.Cells for .NET 7.0.0 (DLLs only)

Amjad Sahi — Mon, 29 Aug 2011 08:01:22 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.0

Amjad Sahi — Mon, 29 Aug 2011 07:36:04 GMT

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

1) Aspose.Cells

Enhancements

29480 How to change the position of a Pivot table Item

29580 Repeating parts of Worksheet based on input data

29377 Export GroupShape problem into XLS format

29632 Throw exception when sheet name contains special characters

29153 Support Conditional Formatting on HTML output

Performance

29451 CalculateFormula() method is Really slow

29461 The performance of CalculateFormula() method

30041 Can't Open ODS File

29983 AutoFitColumns() is extremely slow when columns have Number Format

Exceptions

29511 Failed to open an Excel file

29827 "Not a legal OleAut date" Exception

30056 "Invalid end column index" Exception

Bugs

29413 DataRow values are changed

29599 Chart with 3D Bars to Image issue

29628 Chart to Image issue

29765 Radar Chart to Image issue

29777 VLookup is not working

29408 Add calculated item in the Pivot table

29582 File is corrupt and cannot be opened (XLS)

29293 Aspose.Cells AutoFitColumns feature with trailing spaces

29390 Data mismatch issue in reading file

29620 Chart Alignment / Size issue

30020 Cell’s Gradient Color is not set properly

29597 Adding document properties removes objects in MS Excel

29828 ChartPoint.Datalabel has an issue regarding colors

2) GridWeb

Bugs

29254 Render cells with incorrect styles

29254 Render double values with DateTime format

29254 Render cells with incorrect styles when changing active sheet in IE9

30172 Import Comment images when importing shapes from Excel file

3) GridDesktop

Enhancements

29381 Import formulae with values from Excel file

29381 Import Excel file from stream without calculating all formulae

Bugs

29489 CommentDataChanged event is not fired after changing a comment

30172 Import Comment images when importing shapes from Excel file

Aspose.Cells for .NET 6.0.1 (DLLs only)

Amjad Sahi — Wed, 20 Jul 2011 19:35:02 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 6.0.1

Amjad Sahi — Wed, 20 Jul 2011 19:15:02 GMT

We are happy to announce Aspose.Cells for .NET v6.0.1!

1) Aspose.Cells

Enhancements

28643 Export column index of each Cell in the SpreadSheetML file

29067 How to format Axis in a Line chart

28590 Checking presence of password

Performance

28414 Printing of worksheet takes very long time

28405 SheetRender.ToImage() hangs without an exception or error

Exceptions

28780 SheetRender API throws "Format specifier was invalid." exception

28961 Object Reference Error when converting to PDF

29163 Destination array was not long enough exception

28924 Unable to get Worksheet.Validations to work properly

28867 Parameter invalid in converting Excel to TIFF

Bugs

29129 Legend/Data Labels are bold on charts when generating images

28460 Not evaluating INDIRECT function within VLOOKUP function

28399 ROUND function by Aspose.Cells gives different value than MS Excel

28523 INDIRECT formula does not work when generated in XLSB format

28624 #Recursive Reference! Result is obtained from formula

28626 Unusual problem with recalculation

28781 Formula error when sheet name with bracket is used

28571 Displaced cells in HTML

24963 Image rendered with transparent backgrounds in PDF output

28697 Watermark issue when converting to PDF

28610 Group of objects disappears when converting Excel to PDF

28815 Incorrect conversion from XLS to PDF

28960 Text gets cut off when converted to PDF

28930 Text in cells is truncated when converting to PDF

29184 Cropped images no longer stay cropped when converting to PDF

28352 Pivot Table - extra summary column created

28751 Refresh Pivot table functionality

28489 Problem converting empty XLSX file to TIFF

29058 Rendering problem

28929 Getting bitmap or paper size from SheetRender API bug

24912 Saving XLSB with data filters adds invalid named range

28782 XLSB generation issue when worksheet contains data validation

28714 An issue with XLSB file format

28659 Workbook corruption for XLSM format

28690 Importing a Workbook causes border formatting issue

Regression

28521 Workbook constructor throws 'Invalid cell name'

2) Aspose.Cells.GridWeb

New Features

29286 Import charts and shapes from Excel file

Enhancements

29287 Print function on client side

Bugs

29289 Render vertical scrollbar issue when filtering rows

3) Aspose.Cells.GridDesktop

New Features

26751 Import charts and shapes from Excel file

Enhancements

28964 Export more than 256 columns to Excel 2007 files

26751 Render shape images with EMF format instead of JPEG format

Bugs

28808 Measure string width

Aspose.Cells for .NET 6.0.0 (DLLs only)

Amjad Sahi — Fri, 17 Jun 2011 01:44: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.