Softpedia >Windows >Office tools >Other Office Tools >Aspose.Cells for .Net >  Changelog

Aspose.Cells for .Net Changelog

What's new in Aspose.Cells for .Net 8.1.1

Jun 27, 2014
  • Aspose.Cells
  • Other Improvements and Changes
  • New Features:
  • Remove scenarios from the worksheets
  • Bugs:
  • SheetRender fails when UpdateSelectedValue is used
  • Text is moved out of banner.
  • Curved Connector shape does not appear when rendering XLSX to PDF
  • Text in the Matrix is displayed different
  • PivotTable Sub-Totals have incorrect cell merging
  • Converting the spreadsheet having PivotTable to PDF has style related issues
  • GetPivotData function computes erronated value
  • Aspose.Cells Embeds Incorrect Fonts in the PDF
  • Header is getting duplicated in the output pdf
  • X-axis labels of chart are cut off
  • Bullet points do not render correctly if they are within a text box
  • Arrows are showing mirrored on a vertical axis
  • Legend lines are thiner than in Excel
  • XLSM to PDF tends to hang when changes are made to the Cell Value & Format
  • Bullet list is not printed properly under List heading
  • Bullet list under the Cycle heading is not properly converted to pdf
  • Xlam file does not open in Excel after opening and resaving it
  • Opening and saving the file causes Custom Views error
  • Inserted image loses original size
  • XLSM Ribbons Lost after re-saving the XLSM file
  • Row.ApplyStyle is not working correctly
  • Green background color of cells disappears in HTML
  • Protected view error in MS Excel file - Investigation required
  • Exceptions:
  • System.FormatException when reading xlsx file
  • Specified cast is not valid exception on Cell.GetDisplayStyle()
  • StackOverflowException occured when calling Worksheet/Workbook.CalculateFormula() method
  • Invalid Formula on loading a possibly damaged spreadsheet
  • System.OutOfMemoryException at DetectFileFormat
  • Public API and Backwards Incompatible Changes:
  • The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for .NET. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.
  • Adding HtmlSaveOptions.PresentationPreference property
  • Indicating if html or mht file is presentation preference.The default value is false.if you want to get more beautiful presentation,please set the value to true.
  • Public ScenarioCollection, Scenario,ScenarioInputCellCollection , ScenarioInputCell classes and Worksheet.Scenarios property.
  • Supports adding ,modifying and deleting Scenario settings.

New in Aspose.Cells for .Net 8.1.0 (Jun 6, 2014)

  • New Features:
  • Support Pivot table option: "For empty cells show"
  • Performance:
  • Performance Issue while Formatting Pivot Table Rows
  • Bugs:
  • Conversion to XLS to XLSX causes Unreadable Content Error in Excel
  • Workbook.FileFormat property returns wrong formats
  • Xls file gets corrupt on saving and shows protected view warning when it is opened in MS-Excel
  • Data (with multiple lines) to be hidden when converting from Excel to PDF
  • Match formula is not evaluated properly
  • Hidden sheets and images are generated inside the ouput html _files directory
  • System.FormatException while loading HTML file having 'font-size: 91%'
  • Subscript and Superscript are not working
  • Creating a PivotTable causes the MS Excel to show "Unable to read file"
  • Cell formats are lost in the output xlsx
  • Cell.GetDisplayStyle() is not reflecting the applied table filter
  • RepeatDynamicFormula is not repeating itself in latest version
  • Calculation mode of xlsb could not be set manual
  • Smart Markers - Concatenate formula computes incorrectly
  • CellsException: Arithmetic operation resulted in an overflow. on SheetRender.ToImage
  • Underline is little higher in the PDF generated by Aspose.Cells as compared to one generated with MS Excel 2013
  • Pivot Table in PDF output is not same as in Excel output
  • Header rows on page 3 and onward does not expand
  • Image in header performance issue in Page Layout view in MS Excel
  • Unreadable Content Error after opening and saving the xlsx file
  • Aspose.Cells renders empty category inside the Pie chart
  • Chart Lines missing when converted to PDF
  • Datalabel is not correct
  • Missing Win/Loss Sparkline after converting XLSX to PDF
  • Cell borders are applied on both side of page break
  • Top Aligned columns in pivot tables does not get enough height to show the whole text in PDF
  • Additional line in PDF
  • Load Html - Save to xls ignoring table formatting
  • Pivot chart axis different in generated PDF
  • Invalid Excel file after saving with Aspose.Cells
  • Exceptions:
  • System.InvalidCastException while saving xlsx file to csv
  • Aspose.Cells Grid Suite:
  • Bugs:
  • ImportExcelFile do not let change worksheet tabs
  • Public API and Backwards Incompatible Changes:
  • The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for .NET. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.
  • Obsoletes BuiltInDocumentPropertyCollection.Bytes/Characters/CharactersWithSpaces/Lines/Paragraphs properties
  • Those properties are written for Word and PowerPoint, Excel will omit them.
  • Adds Cell.StringValueWithoutFormat property
  • Gets cell's value as string without any format.
  • Adds HtmlSaveOptions.ExportHiddenWorksheet property
  • Indicating whether export the hidden worksheet content when saving html file. The default value is true.

New in Aspose.Cells for .Net 8.0.2 (May 14, 2014)

  • Aspose.Cells:
  • Other Improvements and Changes
  • New Features:
  • Change Comment Text Direction
  • Performance:
  • System.OutOfMemoryException while saving XLSX to PDF where XLSX has lots of blank cells with formatting
  • Bugs:
  • CalculateTextSize function of the Shape object problems
  • CalculateTextSize() does not return correct height
  • Problem with TextBox AutoSizing
  • CalculateTextSize does not return correct height
  • Auto-fit Columns feature is not working for the Pivot's filtered drop down cols
  • Formulas are not working with foreign currency
  • PivotTable formatting in the output XPS is not correct
  • AutoFitRows is causing the Wrapped text to hide in resultant PDF
  • SheetRender does not render superscript correctly
  • Vertical Text Justification is not working correctly in SheetRender
  • Save Excel file to PDF ignores color settings in header
  • Page break issue when rendering to PDF
  • Border is getting copied to next page while converting XLSX to PDF
  • Pdf rendering contains undesired lines in page 2 and 3
  • Graph disappears when converted to PDF
  • Line chart and bar chart in same graph are not in correct position
  • Gridlines are shown in MS-Excel Print Preview when workbook is saved in Xlsb format
  • AutoFitColumns does not work with ListObjects when new Rows are added.
  • xml:space="preserve" attribute lost for Excel Cell's v (value) OpenXML node
  • Unable to insert a Table into XLSB file
  • Comment text alignment when set to right is not working
  • Excel Found Unreadable Contents error upon opening Aspose.Cells converted XLSM from XLSB
  • ArgumentOutOfRangeException - when opening the Excel XLSX file
  • Cell formulas in the smart markers are not expanding
  • Column namely Sieve Size shows #N/A
  • Exceptions:
  • Null reference exception on saving the xls as pdf
  • System.NullReferenceException while loading a MHTML spreadsheet
  • Cell.GetDispalyStyle() fails for some conditional formatting rules
  • System.NullReferenceException on opening the file
  • NullReferenceException - while retrieving the conditional style for a cell
  • Aspose.Cells Grid Suite:
  • Other Improvements and Changes
  • Bugs:
  • Sheet tab color is not preserved inside the GridWeb
  • WebGrid Context Menu - FIND fails on IE11 with JS error: Unable to get property 'acwFindReplaceDialog_Element' of undefined or null reference
  • Formula issue when loading template file to GridWeb
  • Number format on column H inside the GridWeb not preserved
  • List objects/tables formatting/ style lost when importing Excel file to GridWeb
  • Error creating control for GridWeb
  • Public API and Backwards Incompatible Changes:
  • The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for .NET. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.
  • Adds Shape.TextDirection property
  • Gets/Sets the direction of the text flow for the Shape.
  • Adds HTMLLoadOptions.ConvertFormulasData property
  • Indicating whether or not convert string to formula when the string value starting with character '=' is formula string, the default value is false.
  • Adds HtmlSaveOptions.ImageOptions property
  • Gets/Sets options for rendering when saving html files.
  • Obsoletes HtmlSaveOptions.ExportChartImageFormat property
  • Uses HtmlSaveOptions.ImageOptions instead for image format settings when saving html files.

New in Aspose.Cells for .Net 8.0.1 (Apr 18, 2014)

  • New Features:
  • Set Pixel format for the rendered image (Excel to Image (TIF) rendering)
  • Enhancements:
  • Named range does not grow horizontally with smart markers when it refers to a single cell
  • Performance:
  • CalculateFormula takes more than 9 seconds to process the formulas
  • Bugs:
  • The output file crashed in MS Excel after adding Pivot filtering
  • The hidden comment is shown when exported to HTML
  • Excel found unreadable contents message on Aspose.Cells generated XLSX
  • Excel found unreadable contents in the spreadsheet after adding the PivotTable
  • Many VML elements (controls) do not render properly (Excel to HTML conversion)
  • VML Form Elements in HTML Conversion are not Rendered
  • Rich Text formatting not maintained.
  • Issue using DeleteColumns function
  • Spaces between words are lost in output pdf
  • Image gets blurry when saving to PDF
  • Text Alignment issue on wrapping lines when XLSX is converted to PDF
  • Contents do not maintain their position when XLSX is converted to PDF
  • Horizontal alignment and display issue
  • Missing characters when converting from XLSX to PDF
  • Extra page break in SaveAsPDF
  • sheet name issue
  • '#NULL!' value calculated as 0
  • Excel found unreadable content error
  • Input.xlsx file gets corrupt on opening and saving
  • B Traffic font is not working fine
  • Formula does not calculate before converting the worksheet to image
  • Error getting named ranges
  • IFERROR Issue with Aspose Cells when opening Workbook
  • Incorrect working of Convert and Roman excel functions
  • Image gets blurry in the output pdf
  • Workbook.CalculateFormula bug
  • Problem with CalculateFormula
  • Unable to copy workbook more than once.
  • Shapes overlap
  • Exceptions:
  • Exception on saving and reading the files
  • Exception when converting xls to pdf
  • System.ArgumentOutOfRangeException while opening the file
  • System.ArgumentOutOfRangeException while loading XLS
  • 2) Aspose.Cells Grid Suite:
  • Bugs:
  • GridWeb issue:adjust column width not work in chrome
  • Shapes are not rendered properly in gridweb
  • Range is ambiguous in the namespace Aspose.cells
  • TableItemStyle.NumberType is not applying to columns
  • Performance issue while loading large formatted data (having columns >= 200)
  • GridWeb - Performance issue
  • Public API and Backwards Incompatible Changes
  • The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for .NET. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.
  • Adds Cells.MemorySetting property
  • Gets/Sets which memory usage option be used for current cells collection.

New in Aspose.Cells for .Net 8.0.0 (Mar 26, 2014)

  • Major Features:
  • Memory usage option can be used for performance consideration.
  • When building workbook with large cells data set, MemorySetting.MemoryPreference option may optimize memory usage for cells data to decrease the memory cost.
  • Other Improvements and Changes:
  • New Features:
  • Exporting data without hidden rows and columns
  • Enhancements:
  • PrintTitleRow problem with Turkish Regional Settings
  • Aspose.Cells.dll can not pass BinScope check
  • Typo in method name - SeriesCollection.SecondCatergoryData
  • Scenarios lost during conversion xlsb to xlsm
  • Performance:
  • Performance Issue with AutoFitRow(int rowIndex) method
  • Template file takes longer time to be loaded
  • Bugs:
  • Vertical text issue in the output pdf
  • Calculated field not being calculated/printed
  • GetPivotData function computes error value
  • Excel file gets corrupted after refreshing pivot table and saving.
  • Text is overlapping with checkboxes and textboxes
  • Text alignment issue with checkboxes
  • Some checkboxes are missing in the output html
  • Missing borders while converting XLSX to HTML
  • Deletion test fails in Aspose.Cells v7.7.2.5
  • Cell.StringValue resolves incorrectly for one custom formatting
  • Horizontal alignment is not correct
  • Underline and double bottom cell border not printing properly
  • Font Size changed after conversion to PDF
  • SheetRender problem with different Footer Pictures
  • SheetRender failes to correctly output images
  • Hyperlink does not work when converted to PDF
  • Databar conditional formating does not render correctly
  • Font size increasing for left justified numbers.
  • Object is currently in use somewhere exception
  • Excel to PDF conversion - rows are not visible
  • Number 8 Missing In PDF file with some viewers
  • Extra page break in Excel to PDF conversion
  • Discrepancies and issues for values and charts in the output XPS
  • Designs from XLS page completely lost
  • Negative databar does not appear in the output pdf
  • Chart does not contain markers in the output pdf
  • Chart Size and Placement problem while converting XLSX to PDF
  • Chart's data series removed in the output XLSX files
  • File corrupted with lastest version of MS Excel (2013)
  • Border is thinner when setting big dpi
  • Worksheet.Cells.ClearFormat() dramatically increases the file size
  • MID formula values are not calculated correctly
  • Macro disappeared after saving .xlsm file to .xls file
  • Incorrect WEEKNUM() output
  • Some formulas are not working in output pdf after invoking CalculateFormula()
  • Formula property not working on the cell object
  • Custom menu/ribbon not showing when using Workbook.Copy function
  • DetectFileFormat incorrectly works with password protected Word and PowerPoint files
  • SetLicense for Cells not working
  • Sheet password protection is not working for some files
  • SmartMarkers: (group:merge AND skip:1) don't appear to work together
  • Exceptions:
  • Error in xlsx calling GetNamedRanges

New in Aspose.Cells for .Net 7.7.2 (Feb 14, 2014)

  • Major Features:
  • Support opening password protected 2013 excel files
  • Other Improvements and Changes
  • New Features:
  • Support for B3 (13.9 x 19.7 inches) PaperSizeType
  • Support Justify Distributed Alignment Setting
  • Retrieve RemovePersonalInformation setting
  • Bugs:
  • Incorrect conversion from HTML to XLSX
  • Save as HTML creates too many br tags
  • The output PDF does not reflect the chart in the Excel file
  • Output PDF fails to calculate the values for Calculated Fields in Pivot Table
  • Pivot Table display problem while converting from xls to xlsm
  • Numbers with General as its number format appear with fractions
  • Xlsx file with conditional formatting icon sets gets corrupted after opening and resaving
  • Conditional formatting features like icons, slicers and colour gradient are lost in the output xlsb file
  • Problem with save as html and hidden columns when they have merged cells as headers
  • Conditional formatting is lost when file is opened and resaved.
  • Aspose Cells 7.6.0 - Problem loading and saving Xlsb files with Pivot inside
  • PivotTable DataBodyRange start column property is incorrect
  • Problem while saving excel sheet as html
  • Excel to HTML - no line breaks
  • Month format in the pivot table is wrong in the output pdf
  • PivotTable getting truncated when XLSX is converted to PDF
  • Text formatting issue - Letter y in the word city is cut off
  • Header border varies in thickness across different pages while converting XLSX to PDF
  • Underline breaks while converting XLSX to PDF
  • Icon Set alignment in PDF export
  • Setting the PaperSizeType to PaperA6 renders the PDF in PaperA4 size
  • CHAR(151) is not working properly in pdf
  • Aspose.Cells very strange behavior on IIS 7.5 with AutoFit operation
  • Printing comments in Excel files not working
  • Missing chart in the html
  • Missing chart in the pdf
  • Problem with shape in xlsx to image conversion
  • Saving an XLS file as XLSM, then back to XLS, modifies the chart in the file
  • Characters has been changed to upper case after the Workbook.CalculateFormula()
  • Formula Calculation inconsistency
  • Conditional formatting is lost on Deleting Row
  • XLSM to PDF: Formula Fields are Displayed as #DIV/0!
  • SheetRender doesn't keep account of selected values in ComboBoxes
  • VLOOKUP formula isn't resolved by Aspose.Cells
  • MS Excel XLT format support
  • Loading of Excel file - Browser View Options reset
  • Styles (Parent styles) not copied when using Workbook.Copy() method
  • Exceptions
  • NullReferenceException while loading Excel 2013 file
  • ArgumentOutOfRangeException at Workbook constructor
  • Null Reference Exception on Saving
  • ArgumentException: Parameter is not valid
  • NullReferenceException while saving Workbook to MemoryStream with SaveFormat.Xlsx
  • System.ArgumentException at Cells.ExportDataTableAsString
  • Images not getting generated for excel files and throws null reference exception
  • Index was outside the bounds of the array error
  • ArgumentNullException: Buffer cannot be null. Parameter name:buffer at Workbook.Save

New in Aspose.Cells for .Net 7.6.0 (Oct 29, 2013)

  • Aspose.Cells:
  • New Features:
  • 42063 - Select a different PaperSource in Aspose.Cells
  • 41985 - Add collection objects to Lambda/Linq friendly
  • Enhancements:
  • 41995 - PowerPoint file formats are detected incorrectly by Aspose.Cells
  • 41990 - Publicize some older APIs (classes, methods etc.) after updating them (e.g. Shape.Paths, ShapePathCollection etc.)
  • 41928 - Inserting OLE Documents as linked - Issue with updating SourceFullName attribute
  • 41924 - Set Excel VBS / CreateObject font color and cell’s shading color
  • Performance:
  • 41947 - Support Re-sampling for the added images to reduce the file size
  • Exceptions:
  • 42003 - Issue with refreshing PivotTables
  • 41977 - Exception: "Invalid FontUnderlineType string val" while re-saving the file
  • 42062 - Opening a worksheet complains about invalid formula
  • 42050 - CellsException: Invalid formula"=NOT(ISERROR(SEARCH(..........." while re-saving the file
  • 42005 - Exception when cell formula contains '\r' character
  • 41956 - Exception when opening the template file
  • Bugs:
  • 41984 - Calculation of the height (via CalculateTextSize() method) is incorrect
  • 42054 - Output PDF's PivotTable does not look the same as its original XLSX file
  • 42053 - Cannot save an XLSX file as a PDF if there is no field in the "Row Labels" in PivotTables
  • 42018 - Pivot chart with Dates in X-axis does not appear in the output PDF
  • 42016 - Pivot table’s calculated field is not calculated correctly in the output PDF
  • 42007 - Pivot table’s vertical alignment always resets to Center
  • 42006 - PivotTables are not auto-fitting rows to display the word wrapped contents correctly
  • 42004 - The background color is not rotated but text is rotated in the HTML
  • 41973 - The generated Excel file from HTML format does not have defined Cell Names
  • 41970 - Subtotal row of Date columns in the PDF does not have the same Date formatting
  • 41962 - Insert blank lines not working in other Pivot columns other than the first in the output PDF
  • 41958 - Background color doesn't match in Excel if exporting to HTML
  • 41712 - Generated PDF does not have the PivotTables’ Page Breaks
  • 42025 - SharedStrings are retained even after clearing data from the worksheet since v7.5.2.1
  • 42045 - XLS to PDF conversion prints all the pages instead of Print Area
  • 41570 - Excel to PDF Arabic conversion issue
  • 41394 - Bug in converting Excel (RTL (Right-to-Left) format) to PDF
  • 42033 - Issue with copying PivotTable in MS Excel 2010
  • 42030 - Text wrap setting lost on refreshing PivotTable in Values’ columns
  • 41983 - PivotTables in XLS files cause corruption
  • 42036 - Saving a Column chart with RefreshChartCache option rotates the chart
  • 42028 - Half of the dates are correct, but the other half is formatted as numbers
  • 42023 - Graph data labels are not rendered correctly
  • 42022 - Problem with setting Gradient fill color in the Line chart type series
  • 42017 - Equation and RSquared are not hiding in the Trend Lines
  • 42011 - Incorrect Pie charts after conversion from XLSX to XLS
  • 41948 - Chart to Image conversion issue
  • 42064 - RemoveExternalLinks removes the custom Excel formulas/functions as well
  • 42042 - Setting ListObject.ShowHeaderRow to “false” broken
  • 42041 - Bug in Worksheet.Cells.ExportDataTableAsString method
  • 42040 - Data sorter obliterates rich text formatting
  • 42038 - Excel syntax not supported by Aspose.Cells - it should print 360
  • 42032 - Excel found unreadable content in XLSX
  • 42020 - DATEDIF function problem in Aspose.Cells for .NET
  • 42012 - Formula calculation issue
  • 42010 - Security Alert in MS Excel after converting the file
  • 41997 - Japanese Fonts’ display problem
  • 41971 - “IFERROR(IF…” formula values do not appear in PivotTable in the output PDF
  • Aspose.Cells.GridWeb:
  • Bugs:
  • 42048 - Bug with right click menu and IE8 browser type
  • 41998 - Bug with Undo button in formulas’ calculation
  • Aspose.Cells.GridDesktop:
  • Bugs:
  • 42060 - Link to cells in the same workbook
  • 42056 - ADDRESS formula’s calculation problem
  • 41994 - Lost format of cells after using ImportExcelFile() method

New in Aspose.Cells for .Net 7.5.3 (Sep 24, 2013)

  • New Features:
  • Support reading and writing Page Setup options of HTML file format
  • Exceptions:
  • Exception “Object reference not set to an instance of an object” occurred when re-saving a template XLS file
  • CellsException calculating SUBSTITUTE function
  • Exception during the PivotTable.RefreshData() method call
  • Bugs:
  • Errors and formatting issues in the generated PDF
  • Black background when merging / adding sheets in the output PDF format
  • Unable to convert specific XLS to PDF format
  • Output TIF image is not correct
  • Converting Excel to MHTML issue(s)
  • Left cell overlaps into the right cell (XLS to HTML conversion)
  • Right- to-Left problem in saving as HTML or MHT file format
  • Conditional formatting fails when saving workbook as HTML format
  • Pivot table seems to be using the cell’s Bold setting when converting to PDF file format
  • Pivot table headers in compact form is using the header from Tabular/Outline form
  • Pivot table headers with the wrong color in PDF format
  • Subtotal entry in Pivot table is in the wrong column in the output PDF
  • Calculated fields are not calculated if the source worksheet is removed
  • Item label filters to only display ‘TRUE’ items is not working in the converted PDF file
  • Day of week ordered incorrectly in the output PDF format
  • Calculated field is not working / calculating correctly in Pivot tables
  • Repeat item labels Pivot table setting is not used in the converted PDF
  • Pivot table shows ‘#DIV/0!’ in value columns that are set to Average, AVERAGEIF formulas
  • XLS file will not open without errors after removing Ole objects
  • Saving XLSX file results in unreadable content
  • Page Setup issue / problem which results in corrupted file
  • Array formulas do not retain references to columns in the same table
  • Corrupt files when merging workbooks
  • COUNTIFS formula is not calculated correctly when converting to PDF

New in Aspose.Cells for .Net 7.5.2 (Aug 19, 2013)

  • Aspose.Cells:
  • New Features:
  • 40611 - Support custom data sorting
  • Enhancements:
  • 41850 - Copy range fails to copy the color of the conditional formula
  • 41849 - Clearing Textboxes is not working
  • Exceptions:
  • 41843 - Exception: “Input string was not in a correct format” in reading/writing the template file
  • 41858 - Exception that is caused by writing Legend entries
  • 41873 - Exception: “Index was out of range” - caused by writing legend entries
  • Bugs:
  • 41903 - Aspose.Cells has two bugs regarding Shapes.AddTextEffect API
  • 41807 - Hyperlink over an image in XLSX is not shown when rendering to HTML
  • 41904 - The aligned pivot columns are set to "Wrap text" in the resultant file when file is re-saved
  • 41891 - Issue with refreshing Pivot table(s)
  • 41827 - DataSource is null when the PivotTable's data source is set to a Print area
  • 41854 - Pivot table: Date is not shown in the sorted order
  • 41830 - Data labels fill color and borders disappeared after repositioning
  • 41814 - XY chart scale is incorrect in the exported image
  • 41816 - Converting Chart to Image is not accurate
  • 41900 - Workbook.CalculateFormula is miscalculating Subtotal formula
  • 41888 - MS Excel page’s layout is changed after simple Save
  • 41883 - Calculated value of Indirect formula is not correct
  • 41868 - DSUM formula issue
  • 41864 - INDIRECT formula/function does not work with MS Excel tables
  • 41851 - TextBox.IsPrintable always returns true
  • 41835 - Array formula is not calculated by Workbook.CalculateFormula() method
  • 41688 - Font change is affecting the image size
  • 41887 - Scales of X-axis do not display
  • Aspose.Cells.GridWeb:
  • New Features:
  • 41882 - Not able to copy one cell value/data to multiple cells at once
  • 41831 - Changes in cell style reset on Sheet tab click
  • Bugs:
  • 41848 - Cannot copy data from component/control to be pasted in the Excel file
  • 41899 - Issue when using Freeze Pane feature(s)
  • 41893 - Response time issue in IE (e.g. 10) when enabling MS Ajax mode for GridWeb
  • 41890 - Aspose.Cells. GridWeb cells are jumping while typing
  • Aspose.Cells.GridDesktop:
  • Enhancements:
  • 41779 - Capture RowCount after user applies a filter in GridDesktop
  • Bugs:
  • 41872 - "#REF" error for the INDEX formulas - GridDesktop

New in Aspose.Cells for .Net 7.5.1 (Jul 23, 2013)

  • Aspose.Cells:
  • New Features:
  • 41740 - Get DataBar and ColorScale objects used in the conditional formatting
  • 41605 - How to get/read the Icons used in the conditional formatting for a cell
  • 41615 - Support Worksheet Background (Excel to HTML conversion)
  • 41587 - PivotTable.RefreshData() does not Refresh all PivotTable fields
  • 41524 - Parse Custom views in XLS to XLSM conversion
  • 41522 - Parse Scenarios in XLS to XLSM conversion
  • Performance:
  • 41526 - XLSX to PDF conversion hangs
  • 41108 - Converting a 60MB Excel file to PDF/A – OutOfMemoryException issue
  • Exceptions:
  • 41792 - Exception: “Insertion index was out of range”
  • 41808 - Exception: “Object reference not set to an instance of an object” in rendering Chart to Image
  • 41773 - Exception occurs on opening the file
  • 41767 - Error working with certain embedded objects
  • Bugs:
  • 41805 - Workbook formulas do not work
  • 41761 - Header image is not getting repeated in the PDF output
  • 41685 - Problems with Auto-size for the Textbox
  • 41799 - Language changes in XLS to PDF conversion
  • 41825 - PivotTable date formats wrong when there is more than one value item
  • 41823 - Some of the files generated through Aspose.Cells are producing errors
  • 41758 - PivotTable in the PDF output is not correct
  • 41751 - Array formula(s) lost on Save
  • 41669 - Aspose.Cells removing the CustomUI14.xml file from the Excel workbook
  • 41784 - Chart axis values changed when saving from XLSX to PDF
  • 41759 - Negative number missing minus sign at web with Pie chart
  • 41741 - Chart labels and Legend difference between version v7.0.3.2 and v7.4.3.0
  • 41812 - Recursive Reference errors after calling Workbook.CalculateFormula
  • 41806 - Cannot apply Aspose.Cells.SortOrder to tables with an Array Formula
  • 41787 - File is corrupted on Save
  • 41783 - Files generated from a template file that contain a slicer need fixing
  • 41780 - Issues with Smart Markers with grouped data
  • 41768 - Aspose.Cells causes an Excel file to become corrupt
  • 41766 - Copied cell values are different in target than the source
  • 41747 - Array formulas are not calculated fine
  • 41674 - Issue with creating a chart whose data source referenced in the other workbook
  • 41537 - PDF Generation error with conditional formatting and Array formulas
  • Aspose.Cells.GridWeb:
  • Bugs:
  • 41822 - Find error in "acwmain.js" file - GridWeb
  • 41774 - Aspose.Cells.Gridweb cells hanged if there is large data to edit

New in Aspose.Cells for .Net 7.4.3 (Apr 27, 2013)

  • New Features:
  • Add new overload: AutoFitColumns(int firstRow, int firstColumn, int lastRow, int lastColumn, AutoFitterOptions options)
  • Copy a cell over a range of cells
  • Enhancements:
  • Smart Marker Grouping
  • Copy ListObjects/Tables in copying range.
  • Saving Workbook to CSV is not keeping columns for each row
  • Performance:
  • System.OutOfMemoryException on loading the workbook

New in Aspose.Cells for .Net 7.4.2 (Apr 5, 2013)

  • Aspose.Cells:
  • New Features:
  • 41494 - Copying Macros in XSLM file
  • Enhancements:
  • 41486 - Change the logic to rebuild numbers formatting
  • 41491 - Cell.HtmlString attribute - Support for new symbols/chars
  • 41475 - Copy ListObjects when copying ranges between two workbooks
  • 41455 - Cannot start the source application for the embedded OLE Object
  • Exceptions:
  • 41490 - Exception: Illegal characters in the path
  • 41467 - PivotTable.ChangeDataSource causes "Unknown Area" error
  • 41465 - "Reference not set to an instance of an object" error in the method: PivotTable.RefreshData()
  • 41487 - Error found on GetNamedRanges() method
  • Bugs:
  • 41440 - Dotted line Issue - Sheet-to-Image
  • 41485 - Background color is not visible in the generated image
  • 41484 - Hidden rows are visible in the generated image
  • 41483 - Image output is not in sync with Excel’s print preview page output
  • 41462 - Paper size is not maintained in the PDF document
  • 41444 - PDF rendering issue (last character truncated in some words)
  • 41470 - Regarding convert Workbook-to-PDF file
  • 41448 - Custom number format and right-aligned columns are not converted correctly in the PDF
  • 41442 - ToTiff function: Number Alignment Issues
  • 41439 - ToTiff function: Border Issues
  • 41437 - ToTiff function: Currency Issues
  • 41466 - Issue with custom IconSet 5 Icons in conditional formatting
  • 41436 - Formatted cell values showing extra dot and missing thousands delimiter in XP
  • 41441 - Formatted cell values showing extra dot (“.”)
  • 41464 - Invalid Excel file after saving
  • 41463 - Invalid Excel file when using an empty TCD data source
  • 41471 - CopyStyle option of Pivot Table caused Excel to throw a warning message
  • 41432 - Pivot Chart is not updated with the Pivot Table
  • 41409 - Issue with refreshing the PivotTable
  • 41499 - Expected different behavior of the formula SUM
  • 41451 - Issue with formulas referencing data tables and saving as PDF
  • 41443 - SUMPRODUCT(INDEX(...):INDEX(...),..) #VALUE!... in the XLSB format
  • 41456 - AutoFitWidth not working when reading an XML spreadsheet file
  • Aspose.Cells.GridWeb:
  • New Features:
  • 41459 - Using GridWeb in JavaScript
  • 41429 - Add an edit box toolbar for GridWeb
  • Bugs:
  • 41450 - Reference formulas errors - GridDesktop
  • 41461 - INDEX Formula does not work in GridFormula
  • 41480 - After pressing Ctrl+C on editor box, cell value is not updated
  • 41476 - Editing some cells with formula will not update the values
  • 41457 - The template which is loaded gets hanged when navigating b/w worksheets
  • 41417 - Getting the error value if the cell's formula is referred to some other sheet
  • 41414 - Reference formula errors / issues
  • 41407 - Setting XHtml mode to “false” causes style/formatting issue
  • 41404 - Cannot run the project within Internet Explorer 7

New in Aspose.Cells for .Net 7.3.2 (Oct 10, 2012)

  • New Features:
  • 41009 - Support to copy Sparklines in Workbook.Copy()
  • Enhancements:
  • 40997 - Saving Workbook (XLSM file) removes MS Excel Table’s Array Formulas
  • 41004 - An enhancement regarding input formatting for Ranges
  • 41024 - Find an XML exception while saving a workbook
  • 41052 - Using ProtectedRange to allow domain users/groups edit permissions
  • Performance:
  • 41010 - Performance issues with PivotTables
  • Exceptions:
  • 41008 - Error: “Excel found unreadable content…”
  • 41044 - NullReferenceException in Aspose.Cells.Workbook..ctor
  • Bugs:
  • 40988 - Range of sheets in formula has been changed after sheets are re-ordered
  • 40990 - Wrong row height using AutoFitRows with IsTextWrapped option on
  • 41034 - Protect Workbook with ProtectionType.Windows
  • 41028 - Problem with Zoom setting in Page Break Preview
  • 41046 - Table: Convert To Range feature
  • 41068 - Corrupted file with new Aspose.Cells version
  • 41067 - Worksheet corrupted after opening the file
  • 41065 - Add Page Header problem
  • 41059 - Excel with circular errors showing values instead of error strings
  • 41054 - The Excel file becomes corrupted after deleting row
  • 41053 - Hidden pictures disappeared after copying worksheet
  • 41077 - After save, the Excel worksheet’s data disappeared
  • 41023 - Saving XLSX file with Scatter plot enables extra options
  • 41039 - DataLabels.ShowBubbleSize issue with XLSX file format
  • 41036 - Excel Pie Chart’s title is not rendered to image file correctly
  • 41003 - Incorrect Formula Calculation issue
  • 41015 - German language issue regarding conditional formatting
  • 41016 - Blank pages after converting to PDF
  • 41005 - Header/Footer issues in PDF file
  • 40907 - Lost spaces when rendering Excel range to image
  • 41050 - Language/regional problem - conditional formatting issue with SheetRender
  • 41048 - Custom number formatting issue with negative number
  • 40960 - Set color for Sub Total in PivotTable
  • 40952 - Problem in saving workbook with calculated members inside a PivotTable
  • 41012 - Formula and language issues in connection with SheetRender (XPS)
  • 40987 - Sub Totals are calculated in incorrect order (Smart Markers)
  • 40939 - Excel’s XLSB file size Issue - Pick List vanishes
  • 41301 - Shape to image error when saving PDF using Aspose Cells
  • 41062 - After converting to PDF, the file is corrupted
  • GridWeb - Bugs:
  • 41000 - Calculation should be done automatically

New in Aspose.Cells for .Net 7.3.0 (Aug 14, 2012)

  • New Features:
  • 40701 - Support Reading and Writing MHT files
  • 40448 - Support XML Maps
  • Enhancements:
  • 40676 - Mono supported version issue
  • 40818 - Can't use formula as parameter of CustomFunction
  • 40828 - Can custom functions return ranges that can be used to SUM on
  • 40829 - Applying themes to Charts
  • 40752 - Problem with Formula referencing an image
  • Exceptions:
  • 40800 - Subtotaling generates Runtime error
  • 40836 - Exception is thrown when calling Cell.GetPrecedents() method
  • 40843 - “Invalid Start Row Index” exception while Subtotaling
  • Bugs
  • 40694 - SheetRender’s XPS and custom Number format issue
  • 40753 - Chart’s legend items wrapping when saving as an image
  • 40755 - Bug sheet charts are not showing up
  • 40756 - An Issue with Cells.ExportDataTableAsString() method and custom formatting
  • 40760 - A serious problem with Pivot Table
  • 40762 - Using Workbook.CalculateFormula() method on multiple workbooks on the fly gives #VALUE
  • 40768 - PDF rendering of business shapes (text inside) is not nice
  • 40769 - Issue with XLS table of contents based on the number of printed pages
  • 40774 - The PDF conversion misses the values ??of the named areas
  • 40777 - Referencing cells with values from array formulas does not work
  • 40793 - Cells Formatting Problem
  • 40779 - Problem with formula referencing an image
  • 40799 - Array Formulas in SpreadsheetML do not carry over when converting to XLSX
  • 40835 - Losing named ranges bug in XLSM

New in Aspose.Cells for .Net 7.1.0 (Jan 18, 2012)

  • New Features:
  • Support to apply Conditional Formatting to Pivot Tables
  • Read configuration of Group Fields in Pivot Tables
  • Convert Worksheet to SVG
  • Enhancements:
  • NullReferenceException when opening document with auto-formatted Pivot Table
  • Pivot Table’s filtering in MS Excel 2007 and later versions
  • Chart’s formatting issue
  • Copying worksheet does not work
  • Smart Marker Tags conversion
  • Missing properties (Pivot Table)
  • Missing properties (Pivot Field)
  • PivotField.ShowCompact - Incorrect property value in XLS format
  • Pivot Field’s incorrect items value in the grouped fields
  • Reading items from cache (Pivot Field)
  • Problems opening a SpreadsheetML file
  • Performance:
  • Performance issue on adding range names
  • Memory exception and formula calculations on cells
  • Exceptions:
  • Unable to copy a particular worksheet into another workbook
  • Pivot table throws exception while refreshing
  • ListBox with assigned Input range causes Aspose.Cells crush
  • Bugs:
  • Failed to refresh pivot table in an Excel workbook
  • Problem with default paper size
  • Dirty right border on image when converting XLS to PDF
  • Workbook.CalculateFormula() method bug
  • Multiple issues found while upgrading from v5.2.1.0 to v7.0.3.0
  • Unable to include Row/Column Headings and Comments in the TIFF file
  • Excel-to-Html - word-wrap problem
  • Button’s font attributes are changed after Save
  • Chart’s legend becomes shrunk using Shape.UpperLeftRow() method
  • Error in the output PDF document
  • Multi-line Headers not supported while rendering to PDF file
  • Reading all data from the base fields of Pivot Table
  • Exporting Excel sheet to DataTable gives error
  • Opening ODS files issue
  • Cell border is not rendered properly with Aspose.Cells v7.0.4.x
  • Formula results in #Ref
  • XLS file crashes MS Excel 2007
  • Error opening file using Ms Excel
  • Problem with HTML output in the new Aspose.Cells DLL (version)
  • Updating XLSX file with Pivot Table causes Excel to display error
  • ToImage function generating extra column in the generated image (Sheet-to-Image issue)
  • Excel 2007 workbook with multiple colored tables is not rendered in the converted PDF file
  • Using the Fitting Sheet on One Page option in Excel to convert to PDF does not seem to work
  • Multiple issues while upgrading from v5.2.1.0 to v7.0.3.0
  • Aspose.Cells.GridDesktop:
  • New Features
  • MS Excel’s Grouping Data feature while importing to the GridDesktop
  • Aspose.Cells.GridWeb:
  • Bugs
  • Importing an XLSX file to the GridWeb issues
  • Formula does not work well

New in Aspose.Cells for .Net 7.0.4 (Jan 18, 2012)

  • New Features:
  • Support calculating GETPIVOTDATA function
  • Enhancements:
  • Icon sets are lost from Excel spreadsheet
  • No Connectors are rendered to PDF
  • Color of conditional formatting changes
  • Read chart from ODS file
  • Enumeration for property 'DataDisplayFormat'
  • Strange behavior of AutoShowCount (PivotTable)
  • Formula and Value setters are interfering one with the other
  • Compatibility problems in the Pivot Table
  • PivotTable’s filtering in Excel 2007 and later versions
  • Smart Marker Tags are converted to #NAME?
  • Exceptions:
  • Another Get Named Ranges Exception: Object Reference not set
  • Exceptions while accessing items in fields with the Subtotals
  • RefreshPivotData issue
  • ‘ArgumentException’ when opening the document
  • Performance:
  • CalculateFormula is time consuming once the workbook is saved with the product
  • Bugs:
  • Embedded OLE Object is removed from an ODS file after re-saving the file
  • Embedded message is OleFileType.Unknown
  • Issue while reading Pivot Table style from an XLS file
  • After Workbook.Save, the XLSX file loses Excel 2010 features
  • Uncheck Multi-level Category Labels in Charts
  • Conditional formatting formulas are incorrect after inserting/copying/deleting column
  • Copying charts issue
  • Delete range loses data validation
  • PivotTable.EnableFieldList - Incorrect property name and description
  • UpdateLinkedDataSource issue
  • Problems after migration to Aspose.Cells for .NET v7.0.3
  • Conditional Formatting on pivot table getting scrambled
  • Legend key of Pie Chart has the wrong color
  • Invalid Excel2007Xlsx file format issue while loading an XLSX file
  • Error found while working with XLSM file
  • InsertRange method breaks formula referencing entire column
  • Excel found unreadable content error after worksheet was deleted
  • Cell value returns incorrect value after calling Workbook.CalculateFormula
  • Invalid PageOrientationType issue
  • GridDesktop:
  • Bugs
  • Does not update the calculated results in the resultant cells after entering values
  • Issue with grouping rows/columns
  • Custom date formatting issue in GridDesktop

New in Aspose.Cells for .Net 7.0.3 (Nov 22, 2011)

  • New Features:
  • Support MS Excel’s advanced conditional formatting in the generated PDF file
  • Support Cell Gradient Color that is not set properly while converting to PDF document
  • Uncheck Multi-level Category Labels while formatting Chart’s Axis
  • Enhancements:
  • Copy range with validation
  • Sorting & Dynamic formulas in Smart Markers
  • Implement ToString() method in the Cell, Range, Worksheet and other classes/objects
  • Enhancement - Excel95 - Excel 2003 file
  • Error checking options not working with XLSM files
  • Exceptions:
  • Error occurred while opening XLS file
  • NullReferenceException found when setting Header/Footer in Page Setup
  • Unable to copy a particular worksheet into another workbook with one worksheet
  • Invalid Brush Type when converting Excel workbook to XPS
  • StackOverflow on calling WorksheetCollection.GetNamedRanges() method
  • Performance:
  • XLS to PDF or XPS takes so much time
  • Excel-to- PDF Performance decreases as number of worksheets increases
  • Bugs:
  • Hide pivot table columns issue
  • Charts images do not match Excel’s charts
  • Cell.SetStyle(Style style, bool explicitFlag) doesn't work as expected
  • BuiltInDocumentProperties.HyperlinkBase can’t be read or set
  • Opening XLSM file issue
  • The Style changed after merging or adding copy sheet to workbook operation
  • RowField Subtotal – formatting issue
  • Opening and saving XLSM file throws away macros and ribbons
  • Errors while saving Excel files
  • Charts not rendering fine in rendering / copying workbooks
  • Pivot table does not refresh correctly
  • Array formula references aren't updated on deleting a row or column
  • Negative bigInt problem
  • Aspose.Cells Smart Markers parameters problem
  • Chart disappears after Save
  • Problems found while refreshing Pivot table
  • Error while saving XLSM file
  • Usage of Excel’s default conditional formatting is not working

New in Aspose.Cells for .Net 7.0.2 (Oct 18, 2011)

  • New Features:
  • Access document properties of an encrypted XLS file
  • Enhancements:
  • The Worksheet’s TabColor property for Chart type worksheets
  • Export data without XLS limitation to SpreadsheetML file
  • Smart Markers - How to group Rows (Calculate Totals, Sub-Totals and Grand Totals)
  • Exceptions:
  • StackOverflowException occurred when opening certain files
  • Workbook constructor throws NullReferenceException
  • Exception: Invalid Excel2007Xlsx file
  • Bugs:
  • Converting Excel-to-PDF (missing elements issue)
  • Problem in Excel-to-PDF conversion
  • Problem with version 6.0.1.3 (regarding Charts)
  • Problem with Chart Image regarding Data labels and Error bars
  • Printing issue - Numbers are shown as “#######”
  • Problem with DeleteRange function
  • EMF Vs PNG Issue
  • Wrap Issue when converting XLS-to-PDF
  • Saving as SaveFormat.XLSM causes errors
  • Unable to change line style of a ChartPoint
  • Broken shapes in the copied worksheet
  • Formulas using intersected ranges don't work
  • Dates are shown as serial numbers in Charts
  • Image problems when saving to XLS format
  • Cell content is splitting part way through a word when converting XLS-to-PDF
  • Loading and Updating XLSM then Saving causes ERRORS
  • Problems with Excel 2010 and XLSM
  • Issue with AutoFitRow and the AutoFitMergedCells
  • Negative Values in Parentheses
  • Saving file crashes after using DeleteRange method in some cases
  • Refresh Pivot table - It does not sort properly
  • AutoFitRows doesn't work fine
  • SheetRender exports double-spaces / inconsistent spacing
  • Issue with Chart’s legend items wrapping when saving as an image
  • There are too much formats in the worksheet
  • SheetRender exports chart with wrong height
  • Copying range with validation
  • Saving to XLSX the document is Write-Protected

New in Aspose.Cells for .Net 7.0.1 (Sep 19, 2011)

  • New Features:
  • Add a new overloaded method: Cell.SetStyle(Style style, bool explicitFlag)
  • Enhancements:
  • Add and Delete Rows in the ListObject / Table
  • Performance:
  • Stack Overflow Exception while generating a PDF file from an ODS file
  • Aspose.Cells hangs up when opening the file
  • Exceptions:
  • Error occurred when converting Date column (with empty string) in Excel XML format
  • “’o:relid' is a duplicate attribute name” Exception
  • Bugs:
  • Security Warning issue
  • Excel chart legends shrinking when saving Excel workbook
  • Excel chart lose some formatting when opening and saving it
  • Worksheet.IsVisible = false groups sheets in the workbook
  • Feature request regarding Exception handling while adding worksheets
  • Problem in copying Worksheets
  • MS Excel (Format->AutoFit Row Height) VS Aspose.Cells’ AutoFitRow feature
  • Problem with Pie chart
  • Issue with Chart data labels
  • Macros are disabled in the output XLSM file
  • Problem with Chart axis scale changing
  • Secondary Axis in XLSX lost on Save

New in Aspose.Cells for .Net 7.0.0 (Sep 7, 2011)

  • 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

New in Aspose.Cells for .Net 6.0.0 (Jun 20, 2011)

  • New Features:
  • Export to XPS file
  • Create write-protected XLSX files
  • Enhancements:
  • Show expand/collapse buttons for Pivot Table
  • Chart’s legend is shrinking when Excel workbook is saved
  • Excel Chart Data Labels are moving when Excel file is saved
  • Apply Date format to Nullable date fields
  • Lost sorting for a column after Save
  • Support Table source as named ranges
  • Specify Dynamic Print Area while printing or rendering to PDF
  • Performance:
  • Excel to PDF performance issue
  • Problem with Workbook.CalculateFormula() method
  • The process is hangs when opening a file which contains shapes
  • Opening an XLSX file is slow
  • Exceptions:
  • Opening Workbook Causes Exception
  • Broken picture causes Aspose.Cells to crash
  • Exception thrown when opening legitimate XLSX file
  • An exception occurred when saving an XLS workbook in XLSM format
  • Bugs:
  • Fail to evaluate some Excel formulas/functions
  • Invalid formula obtained if table’s column title contains simple quotes
  • Not calculating the array formulas properly
  • Workbook.CalculateFormula() is not calculating correctly
  • Bug with evaluating Convert function
  • ROUND function gives value other than MS Excel
  • Special Characters in the formula
  • Get Named Ranges and Tables
  • Diagonal Lines are not showing correctly in PDF
  • Grouped shapes are distorted when saving to PDF
  • Excel to PDF Conversion - Chart Ranges Issue
  • Saving Excel (XLS) file as PDF results in an issue
  • Protected view warning in MS Excel 2010
  • Set an existing tables data source to named range(s)
  • Pivot Table corrupted after updating source data sheet
  • Borders missing on the right and bottom of image in Sheet to Image feature
  • Bullets missing in the exported image in Sheet to Image feature
  • Column’s format in TIFF Conversion is not correct
  • Escape character in Smart Markers
  • An issue of opening SpreadsheetML file
  • AutoRow height issue while creating rows that exceed maximum height
  • AutoFilter issue between XLS and XLSX files
  • Problem with cell formatting in generated file
  • Formulas are not refreshing properly

New in Aspose.Cells for .Net 5.3.3 (May 24, 2011)

  • Enhancements:
  • Set Hyperlink’s Target attribute when converting Excel file to Html format
  • Render Checkboxes in Html file
  • Support Justified Alignment in rendering PDF format
  • Excel-to-Pdf enhancement for Mono
  • External web links have some strange characters attached
  • Enhance various Custom Properties in XLS, XLSX/XLSM documents
  • Support STDEV.S function/formula
  • Performance:
  • Excel- to-PDF conversion
  • Exceptions:
  • Handle FormatException while opening an ODS file
  • Invalid column index - Aspose.Cells.CellsException from SheetRender.ToImage() method
  • Aspose.Cells cannot open the XLS file
  • Source array was not long enough – exception on opening Excel file
  • SheetRender.ToImage() method is failed to render some Worksheets
  • Bugs:
  • Render almost blank picture (from Chart.ToImage() method) , the dash lines are not rendered fine
  • Title in Chart Image is not appearing on the right side of the chart area
  • Data Labels are not visible properly using Chart-to-Image feature
  • No values in the generated chart’s image using Chart-to-Image feature
  • Reduce font size while saving to Pdf file
  • Wrong text in PDF Export
  • Save to Pdf (bugs)
  • Multiple Issues when saving the generated Excel file as PDF
  • Pivot Tables getting corrupted
  • Setting RefreshDataOnOpeningFile does not seem to work
  • Corrupt Pivot Table with Aspose.Cells
  • File Corruption issue
  • Get Maximum Value of ValueAxis in an Excel Chart
  • An Issue with PutValue and ClearContents methods
  • Problem with Copying Rows and Conditional Formatting
  • Calculated cell has “#VALUE!” after using Workbook.CalculateFormula() method
  • Get “#Value!” in the calculated cells
  • Problem with formulas calculation across Worksheets
  • XLSB Formula returns different value than XLSX formula
  • Excel file opens with warning after using Range.CopyValue for Table’s header
  • ListObjectCollection.Add corrupts formatting in header cells
  • Excel file places a shape with zOrderPosition of 0 on top
  • Render Alt Text in MS Excel 2010 XLSX file
  • TextBox Linked Cell returns null
  • Insert a new column into a Table
  • Document corruption after processing with Aspose.Cells

New in Aspose.Cells for .Net 5.3.2 (Apr 19, 2011)

  • Inserts a common value into all the cells of the range by using Range.Value.
  • Supports MS Excel 2010 encryption.
  • Provides support to disable/hide Printing-Process dialog box
  • Supports to change paper source while printing.
  • 43 enhancements and fixes.

New in Aspose.Cells for .Net 5.3.1 (Mar 24, 2011)

  • Aspose.Cells:
  • Supports Arabic text rendering in PDF conversion.
  • 17 enhancements and fixes.
  • Aspose.Cells.GridWeb:
  • Supports calculating array constants in Formulas.
  • Supports multiple non-sequential cells operations.
  • Aspose.Cells.GridDesktop:
  • Supports calculating array constants in Formulas.

New in Aspose.Cells for .Net 5.3.0 (Feb 28, 2011)

  • Chart-to-Image feature is enhanced.
  • Excel-to-PDF feature is enhanced.
  • R/W ODS files feature is enhanced.
  • Auto-fit rows feature is enhanced.
  • 63 enhancement and fixes.

New in Aspose.Cells for .Net 5.2.2 (Jan 28, 2011)

  • Supports exporting Tables style to PDF file format.
  • Enhances R/W ODS files.
  • 27 enhancements and fixes.

New in Aspose.Cells for .Net 5.2.1 (Dec 23, 2010)

  • Supports pre-defined styles of OOXML (MS Excel 2007).
  • Supports “Password to modify” option while encrypting spreadsheets.
  • 22 enhancement and fixes.

New in Aspose.Cells for .Net 5.2.0 (Nov 26, 2010)

  • Supports signing and validating Digital Signatures in XLSX files.
  • Supports R/W Pivot Tables in XLS and XLSX files.
  • Calculates Pivot Table data to cells.
  • 31 enhancement and fixes.

New in Aspose.Cells for .Net 5.1.4 (Oct 28, 2010)

  • Supports exporting encrypted PDF files.
  • 45 enhancements and fixes.

New in Aspose.Cells for .Net 5.1.3 (Oct 28, 2010)

  • Enhances the performance of saving PDF files.
  • 39 enhancements and fixes.

New in Aspose.Cells for .Net 5.1.2 (Oct 28, 2010)

  • 19 fixes.
  • Issues Resolved:
  • Chart2Image: Print Area/ Chart
  • Pdf: Conversion to PDF through Aspose.Cells Shrinks text
  • Pdf: Look and feel of generated PDF is not same as Excel
  • Pdf: SaveAs PDF Issue - Corrupted PDF
  • SpreadML: Error converting Excel2003XML to XLSX
  • Xls: Combine with charts causing plot area mismatch
  • Xls: Conditional Formatting issue as of version 4.8.1
  • Xls: Copy Excel having Command button event handler
  • Xls: Document becomes unreadable
  • Xls: Error Opening Large Files Aspose.Cells v4.7.1.0
  • Xls: Office 2010 has detected a problem with this XLS file
  • Xls: PivotTables unable to view
  • Xls: Problem on attribute IsStrikeout
  • Xls: Undesired behavior of Worksheet.Move method
  • Xlsx: Bar chart format lost when saved
  • Xlsx: Line chart format lost when saved
  • Xlsx: Picture reference deleted with Version 5.1.1.0
  • Xlsx: Pivot tables corrupted on passing through Aspose.Cells
  • Xlsx: Workbook.CalculateFormula() doesn't calculate the values
  • GridWeb: Bug of formula calculation engine

New in Aspose.Cells for .Net 5.1.1 (Aug 6, 2010)

  • Fixes a few issues of Workbook constructor and Workbook.Save() method.
  • 15 enhancements and fixes.

New in Aspose.Cells for .Net 5.0.0.0 (Jul 1, 2010)

  • Includes MS Excel 2007 XLSB file format support.
  • Provides Copy and Paste Special feature.
  • Supports Sorting Smart Markers.
  • 37 enhancement and fixes.

New in Aspose.Cells for .Net 4.8.0.0 (Oct 22, 2009)

  • Merge Aspose.Grid suite into Aspose.Cells
  • Optimize the performance of Formula recalculations
  • Improve the performance of inserting/deleting Rows/Columns
  • Enhance the performance of Auto-fit Rows/Columns feature
  • Add WordArt shapes to XLS file
  • Read Gradient Fill effects for the Chart
  • Create spreadsheets with First Page or Even/Odd Header/Footer attributes for Page Setup
  • Support multiple Print Areas in Worksheet-to-Image feature
  • Add Formula Calculation support for some new MS Excel built-in functions
  • Set background image for a Chart type Worksheet
  • Provide support for setting Image Options in Chart-to-Image and Worksheet-to-Image features
  • 101 fixes and other enhancements

New in Aspose.Cells for .Net 4.7.1 (Jun 11, 2009)

  • What's changed
  • Directly export excel files to pdf stream.
  • Apply Subtotals to worksheet tables.
  • 55 fixes and enhancements.

New in Aspose.Cells for .Net 4.7.0.0 (Mar 21, 2009)

  • Supports directly converting Excel files to Pdf.
  • Supports Gridline option of the page setup setting while printing worksheet.
  • Supports to insert a WAV file as Ole object.
  • Supports R/W checkboxes in Excel 2007 files.
  • Supports to use anonymous types or custom object as data source in Smart marker
  • Supports to set display zero value option.
  • Supports to union and intersect two ranges.
  • Supports preserving data after saving the workbook.
  • Supports the option to inserting blank rows in pivot table or not.
  • Enhances the calculate engine and supports more functions.
  • 45 fixes and enhancements.

New in Aspose.Cells for .Net 4.6.0.0 (Jan 21, 2009)

  • Supports to export PivotTable to Excel2007 file.
  • Supports to add pivot calculated item to pivot table in 97-2003 xls file.
  • Supports Page setup Header(s) and Footer(s) in Worksheet2Image.
  • Supports to R/W xltm , xlmx file.
  • 46 fixes and enhancements.

New in Aspose.Cells for .Net 4.4.1.0 (Feb 8, 2008)

  • New: Auto-detect file type when opening an Excel file
  • Enhanced Excel2007 Xlsx support
  • Enhanced xls2pdf conversion
  • Enhanced pivot table support
  • Supported more functions in formula calculation engine
  • Fixed: Bug in opening a few special far-east Excel files
  • Fixed: Bug in formula parsing and calculation
  • Fixed: Bug in page setup settings
  • Fixed: Bug in import/export some text files
  • Fixed: Bug in processing smart markers
  • Fixed: Problem in installation on vista

New in Aspose.Cells for .Net 4.4.0.0 (Sep 3, 2007)

  • New: Allows to delete defined names from template files
  • New: Support to create an encrypted Excel file from scratch
  • Improved: Writes the formula calculation result back to file
  • Improved: Chart2image conversion enhancement
  • Improved: Xls2pdf feature enhancement
  • Improved: Support to set vertical text in text box
  • Fix: Chart PlotArea setting bug
  • Fix: AutoFitRow bug for some bold font
  • Fix: Bug in calculating Indirect and Address function in some cases
  • Fix: Bug in send xlsx file to client browser

New in Aspose.Cells for .Net 4.0.1.0 (Jul 18, 2006)

  • Added new chart demos
  • Fixed bugs in InsertRows/DeleteRows method
  • Fixed bug in loading/saving SpreadsheetML file
  • Fixed bug in loading CSV file which contains a single period(.) in a cell
  • Fixed a bug in xls2pdf feature