More no of rows/columns in office web components?

H

Hari

Hi,

I have read post(s) on excel having column Limit of 256 and row as 65536.

But following link -> http://www.bygsoftware.com/Excel/functions/minmax.htm

If u insert a new spreadsheet by using command and options button on any
embedded excel workbook and then workbook tab, then it shows that there are
262144 rows and 1756 Columns.How has that been achieved.?

Regards,
Hari
India
 
H

Hari

Hi Dave,

Actually my query was how is it that normal office excel has only 256 Col
and 65536 rows while office web component has more rows and columns?

Regards,
Hari
India
 
D

Dave Peterson

One is the real excel (256x65536) and the other is a web based thingy.

There's been speculation why xl is limited to 256 columns and it kind of boils
down to it would be difficult to maintain compatibility with older versions and
that there really isn't an overwhelming market that demands it.
 
Top