Free Support Forum - aspose.com

Excel 2003 Vs Excel 2007 and Aspose Limitations

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.

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.

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.