Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Change upper limit of rows in a single sheet

I have a spreadsheet that will never hold more than 200 rows, and some columns are always automatically filled. I've been filling the entire column with statements like IF(ISBLANK(previous cell)=FALSE,true value, "") in order to keep it blank before the row is used, but going all the way to 1M is overkill (and sometimes crashes Libreoffice), is there a way to hard limit the number of rows in a document?

I realise I could just extend the column formula for 200 rows or so, but it would feel much neater to hard limit the rows if at all possible.

Change Lower the hard upper limit of rows in a single sheet

I have a spreadsheet that will never hold more than 200 rows, and some columns are always automatically filled. I've been filling the entire column with statements like IF(ISBLANK(previous cell)=FALSE,true value, "") in order to keep it blank before the row is used, but going all the way to 1M is overkill (and sometimes crashes Libreoffice), is there a way to hard limit the number of rows in a document?

I realise I could just extend the column formula for 200 rows or so, but it would feel much neater to hard limit the rows if at all possible.