More no of rows/columns in office web components?

[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

 

[Hari]

Correction :- Please read that as 17576 columns (=26^3)

Regards,
Hari
India

 

[Dave Peterson]

There's an Office Web Components option that you can install (or not).

But there are quite a few restrictions on what you can do with this.

http://support.microsoft.com/default.aspx?scid=kb;en-us;288729

I searched the MSKB and got lots of hits:

http://support.microsoft.com/search/default.aspx?Query=office+web+component

I've never used it.

 

[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

 

[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.