Aspose.Cells for .NET 7.3.1 Release Notes

We are happy to announce Aspose.Cells for .NETv7.3.1 for the users!

\1) Aspose.Cells

New Features

• Conditional formatting - Include DataBar type’s missing fields
• Conditional formatting - Include IconSet type’s missing values
• Conditional formatting - Support
• Read conditional formatting rules with cross-sheet formulas
• Support Cells.MinDataColumn and Cells.MinDataRow properties
• Support Cell Background Colors with Conditional Formatting (MS Excel 2010)
• Data Filters of the PivotTable are supported
• Advanced data validation of MS Excel 2010 is supported

Enhancements

• Throws CellsException when changing the part of the array formula
• Marker types and styles in the charts of Excel 2007/2010
• Custom Marker shapes in the chart
• How to create custom Markers
• Sub-Charts are not accessible

-AutoShapes in HTML Output

• DataBars - Conditional formatting in PivotTable
• Losing web queries in MS Excel 2007 formats
• Manage external data ranges and their properties
• MS Excel’s XLSB file size Issue

Exceptions

• The static method CellsHelper.DetectFileFormat() throws exception
• Looking for a solution in Aspose.Cells
• Exception: “Index was out of range”
• Loadingworkbook throws: ‘Input string was not in a correct format’
• Shape to image Error in Excel to PDF feature

Bugs

• Image’s color mode formatting is not kept when saving an Excel file
• MS Excel 2003 Worksheet’s Custom Properties corrupted
• BUG in calculating Formulas
• Opening and saving a file with conditional formatting failed
• Bold style is not seen on ListObject’s header cell
• Series markers issue

-Quotes in the saved Tab Delimited file

• CSV read/write does not ‘round trip’ for some inputs

-StringValue returns a wrong value

• 2 small issues with CELL function’s implementation
• Issues with CELL function
• GETPIVOTDATA formula calculation issue
• PPMT formula is causing file recovery after calling Workook.CalculateFormula()method
• Issuewith IFERROR and VLOOKUP combination
• COUNTIFS formula does not evaluate correct value
• OFFSET function calculation issues
• MODE function calculation issues
• CELL function calculation issues

-VLOOKUP function’s bug

-TRIM function calculation issues

• Save as HTML shows hidden column in the output
• Saving clears formatting
• Graphics in HTML output
• HTML formatting issues (regarding extra borders)

-SheetRender’s XPS and custom number format issue

-Save as PDF does not preserve formatting

• Problems with XLSX formatting in Excel and PDF outputs
• Excel’s pivot table rendered to PDF is not correct
• Custom fonts in PDF
• Cell’s Vertical Alignment rendering issue
• Text missing in the right-most end
• Some conditional formattings are not rendered correctly
• Problem with formatting in the Total Row in the PivotTable
• Office for Mac-Os 2k11 crashes after opening an Excel file

-Why is this code failing?

• PivotTable’s calculated field getting changed
• Problem saving Workbook with Calculated Members
• Compact Layout for pivot table
• Corrupt File when Refreshing Pivot Tables
• ChangeDataSource() is broken
• SheetRender draws textbox contents bold
• Excel text box is resized incorrectly when rendering to image
• SheetRender exports shape incorrectly

\2) GridWeb

Bugs

40838 - GridWeb’s formattingis not saved

• Re-sizing columnmakes it hidden

40722 - Custom formattingwith Percentage

40826 - Top border issuein the GridWeb

40831 - Cross-browserissues for Aspose.Cells.GridWeb 

40822 - User mustdepress key twice to register when tabbing into a new cell - Firefox Issue  

• Upgrading toAspose.Cells.GridWeb version issue
• GroupRow with IndentLevel, Text mask and hidden group issue