Worksheet 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

  • Maximum numeric precision: 15 digits (Counting the digits before and after the decimal place)

  • Maximum numeric resolution: 2.22E-16 (The smallest detectable difference between two numbers)

  • Maximum absolute value: 1.79769E+308 (The largest value that can be represented)

  • Minimum absolute value: 2.22507E-308 (The smallest value that is different from zero)

  • Double precision floating-point numbers can only represent approximately 15 significant decimal digits.

  • Approximate memory requirements for unformatted numeric data: 10.5 bytes per cell + 24 bytes per column

Example 1

10,000 rows of numbers in 3 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): 308 Kbytes

Example 2

3 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