views:

377

answers:

4

What is the data structure used by spreadsheets program like ms-excel?

+2  A: 

Maybe, probably, a sparse matrix:

http://en.wikipedia.org/wiki/Sparse_matrix

Corey Trager
A: 

Possibly a multi-dimensional array.

Bravax
+1  A: 

While it is not exactly Excel, Open Office's Spreadsheet program is open source. It's a fairly large code base but nevertheless giving it a peek might give you a better understanding of how such an application is implemented:

http://contributing.openoffice.org/programming.html

BobbyShaftoe
A: 

I expect it to use many.

For example, an AST to recalculate formulas (see this question).

friol