Excel 2003 Vs Excel 2007 and Aspose Limitations

Aspose.Cells Product Family
1

Hi,

I found following statistics between Excel 2003 Vs Excel 2007.

Excel 2003 versus Excel 2007

Excel 2003 Excel 2007
Number of rows 65,536 1,048,576
Number of columns 256 16,384
Amount of memory used 1 Gbytes Maximum allowed by Windows
Number of colors 56 4.3 billion
Number of conditional formats per cell 3 Unlimited
Number of levels of sorting 3 64
Number of levels of undo 16 100
Number of items shown in the Auto-Filter dropdown 1,000 10,000
The total number of characters that can display in a cell 1,000 32,000
Number of unique styles in a workbook 4,000 64,000
Maximum number of characters in a formula 1,000 8,000
Number of levels of nesting in a formula 7 64
Maximum number of function arguments 30 255
Maximum number of function arguments 30 255

Are all these statistics work in ASPOSE?

Please let me know if there is any limitation in any of above mentioned statistics.

Thank You.

2

Hi,

Thanks for considering Aspose.

Yes, Generally, Aspose.Cells can work in the similar way as MS Excel 2003 and MS Excel 2007 do. The component covers almost all the features for MS Excel 2007 as your table shows. If any feature is not completely supported (as your statistics shows), we will try to enhance the relevant feature ASAP for your need.

Thank you.

3

Number of conditional formats per cell<?XML:NAMESPACE PREFIX = O />

3

Unlimited

Maximum number of function arguments

30

255

Maximum number of function arguments

30

255

For these 3 features, Aspose.Cells supports Excel2003 but not Excel2007. We will check and support them in the future.