• Register
0 votes
71 views

Problem :

I am getting below google sheet error
this action would increase the number of cells in the workbook above the limit of 2000000 cells.
6 5 3
6,930 points

1 Answer

0 votes

Solution :

According to the Files you can store in Google Drive Google Sheets has the 5 million cells limit by spreadsheet. 

I myself tested the above scenario by trying to insert a 1,999,999 columns to the spreadsheet that contains a single sheet with a single cell (A1) by using the below script:

function testCol() {
  SpreadsheetApp.getActiveSheet().insertColumns(1, 1999999)
}
9 7 4
38,600 points

Related questions

0 votes
1 answer 73 views
73 views
Problem : java does not limit the number of dimensions that an array may have
asked Nov 1, 2019 peterlaw 6.9k points
0 votes
2 answers 54 views
54 views
Problem: You use this method to determine the number of items stored in an ArrayList object?
asked Apr 18 ArifulIslam 5.7k points
0 votes
1 answer 35 views
35 views
Problem : I am currently facing below error in my iPhone: “The maximum number of free accounts have been activated on this iPhone”. To fix this problem I even tried to erase all content and settings of the iPhone and after that set it as the fresh new iPhone. But I am still facing the above problem. How can I fix my iPhone now?
asked Feb 28 mphil 2.3k points
0 votes
1 answer 38 views
38 views
Problem : I am facing the problem with my URLs length. How can I know when my URL's length is exceeded? This issue experienced only after sending large number of query variables in my query string. Can I increase it at run time?
asked Feb 24 mphil 2.3k points
0 votes
2 answers 986 views
986 views
Problem : I am trying to view an image in the Jupyter notebook as below. It's size is 9.9MB .png file. from IPython.display import Image Image(filename='path_to_image/image.png') I am facing the following error : IOPub data rate exceeded. The notebook server ... for me and also I think it got already reported elsewhere. Is this the expected behavior and is there any simple solution on it?
asked Dec 11, 2019 alecxe 7.5k points