• Register
0 votes

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

Please log in or register to answer this question.

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 7 views
I am new to this. I just want to know how to do that?
asked Nov 30, 2020 TeamScript 9.7k points
0 votes
1 answer 80 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 120 views
Problem: You use this method to determine the number of items stored in an ArrayList object?
asked Apr 18, 2020 ArifulIslam 5.6k points
0 votes
1 answer 63 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, 2020 mphil 2.3k points
0 votes
2 answers 1.3K 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
0 votes
1 answer 67 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, 2020 mphil 2.3k points
1 vote
1 answer 161 views
Problem : I am very new to Python programming. My below code gives me errors : with open(json_file) as jfile:     try:         json_config = json.load(jfile)     except ValueError as e:         raise Exception('Invalid json: {}'.format(e)) Please find below errors ... Invalid json: Expecting ',' delimiter: line 103 column 9 (char 1093) Can some expert tell me how can I quickly fix above errors?
asked Apr 13, 2020 morrisBson 3.2k points
0 votes
1 answer 12 views
Problem: I want to increase the width of a textbox in my HTML page along with the font size. How I can do that?
asked Oct 19, 2020 Code Learner 5.5k points
1 vote
2 answers 318 views
Problem : Looking for solution on bellow npm error npm err! this is probably not a problem with npm. there is likely additional logging output above.
asked Nov 8, 2019 peterlaw 6.9k points
0 votes
1 answer 13 views
Problem: In general, for which of the following would you want to use lossless compression? -A log file -A movie -A JPEG image -An mp3 audio file -An encrypted email
asked Jul 21, 2020 HenryL 620 points