Aspose.Cells 7.3.1

New Features 40519 - Conditional formatting - Include DataBar type’s missing fields 40520 - Conditional formatting - Include IconSet type’s missing values 40521 - Conditional formatting - Support FormatConditionValueType.AutomaticMin/AutomaticMax 40593 - Read conditional formatting rules with cross-sheet formulas 40877 - Support Cells.MinDataColumn and Cells.MinDataRow properties 40954 - Support Cell Background Colors with Conditional Formatting (MS Excel 2010) 40773 - Data Filters of the PivotTable are supported 40856 - Advanced data validation of MS Excel 2010 is supported Enhancements 40923 - Throws CellsException when changing the part of the array formula 40815 - Marker types and styles in the charts of Excel 2007/2010 40918 - Custom Marker shapes in the chart 40919 - How to create custom Markers 40808 - Sub-Charts are not accessible 40900 - AutoShapes in HTML Output 40688 - DataBars - Conditional formatting in PivotTable 40664 - Losing web queries in MS Excel 2007 formats 40677 - Manage external data ranges and their properties 40883 - MS Excel’s XLSB file size Issue Exceptions 40880 - The static method CellsHelper.DetectFileFormat() throws exception 40926 - Looking for a solution in Aspose.Cells 40962 - Exception: “Index was out of range” 40884 - Loading workbook throws: 'Input string was not in a correct format' 40893 - Shape to image Error in Excel to PDF feature Bugs 40876 - Image’s color mode formatting is not kept when saving an Excel file 40886 - MS Excel 2003 Worksheet’s Custom Properties corrupted 40924 - BUG in calculating Formulas 40937 - Opening and saving a file with conditional formatting failed 40963 - Bold style is not seen on ListObject’s header cell 40911 - Series markers issue 40932 - Quotes in the saved Tab Delimited file 40949 - CSV read/write does not 'round trip' for some inputs 40868 - StringValue returns a wrong value 40833 - 2 small issues with CELL function’s implementation 40850 - Issues with CELL function 40862 - GETPIVOTDATA formula calculation issue 40874 - PPMT formula is causing file recovery after calling Workook.CalculateFormula() method 40890 - Issue with IFERROR and VLOOKUP combination 40967 - COUNTIFS formula does not evaluate correct value 40975 - OFFSET function calculation issues 40976 - MODE function calculation issues 40977 - CELL function calculation issues 40978 - VLOOKUP function’s bug 40981 - TRIM function calculation issues 40581 - Save as HTML shows hidden column in the output 40771 - Saving clears formatting 40846 - Graphics in HTML output 40969 - HTML formatting issues (regarding extra borders) 40694 - SheetRender’s XPS and custom number format issue 40251 - Save as PDF does not preserve formatting 40751 - Problems with XLSX formatting in Excel and PDF outputs 40775 - Excel’s pivot table rendered to PDF is not correct 40811 - Custom fonts in PDF 40858 - Cell’s Vertical Alignment rendering issue 40896 - Text missing in the right-most end 40972 - Some conditional formattings are not rendered correctly 40871 - Problem with formatting in the Total Row in the PivotTable 40875 - Office for Mac-Os 2k11 crashes after opening an Excel file 40940 - Why is this code failing? 40951 - PivotTable’s calculated field getting changed 40952 - Problem saving Workbook with Calculated Members 40955 - Compact Layout for pivot table 40968 - Corrupt File when Refreshing Pivot Tables 40980 - ChangeDataSource() is broken 40601 - SheetRender draws textbox contents bold 40902 - Excel text box is resized incorrectly when rendering to image 40914 - SheetRender exports shape incorrectly