Worksheet Technical Specifications

The following technical specifications for the worksheet include the number of cells allowed in the worksheet and the nature of the numbers allowed in the worksheet.

  • Maximum number of rows in a worksheet: 1 billion
  • Maximum number of columns in a worksheet: 1 billion
  • Approximate memory requirements (for unformatted numeric data): 10.5 bytes per cell + 24 bytes per column
  • Maximum numeric precision (counting the digits before and after the decimal place): 15 digits
  • Maximum numeric resolution (the smallest detectable difference between two numbers): 2.22E-16
  • Maximum absolute value (the largest value that can be represented): 1.79769E+308
  • Minimum absolute value (the smallest value that is different from zero): 2.22507E-308

Example 1

This example has 10,000 rows of numbers in three columns.

30,000 cells x 10.5 bytes/cell = 315,000 bytes (308 Kbytes)

3 columns x 24 bytes/column = 72 bytes

TOTAL MEMORY NEEDED (in addition to memory needed to run the program): 380 Kbytes

 

Example 2

This example has three rows of numbers in 10,000 columns.

30,000 cells x 10.5 bytes/cell = 315,000 bytes (308 Kbytes)

10,000 columns x 24 bytes/column = 240,000 bytes (234 Kbytes)

TOTAL MEMORY NEEDED (in addition to memory needed to run the program): 542 Kbytes

See Also

Worksheet Document