1. Home
  2. Spreadsheet Limits

Spreadsheet Limits

The following limits apply to the size of data within a Genstat spreadsheet.

Pages

The maximum number of sheets or pages in a Genstat book is a user defined limit between 20 and 4000, which can be set on the Tools | Spreadsheet Options | Books tab. If the specified limit of pages is reached, Genstat will start adding subsequent pages to a new book.

Columns

The maximum number of columns in a Genstat spreadsheet is a user defined limit between 250 and 50,000, which can be set on the Tools | Spreadsheet Options | Sheets tab. Genstat will not read in more columns from any data source than the specified limit.

Rows

The only limit to the number of rows in a Genstat spreadsheet is the amount of memory available on the computer.

Factor labels

The maximum number of characters for a factor label in Genstat is 90 (increased from 60 in the 16th edition). Reading cells into a factor that contains text longer than this amount will result in the labels being truncated. If two groups factor labels are the same for the first 90 characters, then this can result in these two groups being amalgamated into a single group.

Text values

The maximum text length in Genstat is a user defined limit between 90 and 10,000, which can be set on the Tools | Spreadsheet Options | Conversions tab. Texts read from any data source which are longer than the specified limit will be truncated.

Updated on March 13, 2019

Was this article helpful?