title: Why can't I get more than 30 cells in a table?
body: <p>I try to get data from more than 30 cells (if I'm not mistaken, about 40), but all the time I get no more than 30. How to solve this issue?</p>
  
  <ul>
  <li>In Case 9 - ok   </li>
  <li>In Case 10 - failure.</li>
  </ul>
  
  <p>Rows has 30 items, but I select much more</p>
  
  <pre><code>namespace CBox
  {
      public partial class Form1 : Form
      {
          static string[] Scopes = { SheetsService.Scope.SpreadsheetsReadonly };
          static string ApplicationName = "CBox";
  
          static String spreadsheetId = "1LovVHkHGQYADfgEBMGEaZFTDkSgQEQhQ-FuRZHWkXHo";
          String range;
          static String credPath = "token.json";
          static FileStream stream = new FileStream("credentials.json", FileMode.Open, FileAccess.Read);
          SpreadsheetsResource.ValuesResource.GetRequest request;
  
          static UserCredential credential = GoogleWebAuthorizationBroker.AuthorizeAsync(GoogleClientSecrets.Load(stream).Secrets, Scopes, "user", CancellationToken.None, new FileDataStore(credPath, true)).Result;
          SheetsService service = new SheetsService(new BaseClientService.Initializer()
          {
              HttpClientInitializer = credential,
              ApplicationName = ApplicationName,
          });
  
  
          private void ComboBox1_SelectedIndexChanged(object sender, EventArgs e)
          {
  
              comboBox2.Items.Clear();
  
              range = "A2:AT9";
              request = service.Spreadsheets.Values.Get(spreadsheetId, range);
              //request.MajorDimension = SpreadsheetsResource.ValuesResource.GetRequest.MajorDimensionEnum.COLUMNS;
              ValueRange response = request.Execute();
              IList&lt;IList&lt;Object&gt;&gt; values = response.Values;
  
              switch (comboBox1.SelectedIndex)
              {
                  ***********
  
                  case 9:                                                     //120
                      foreach (var rows in values)
                      {
                          if (rows[28] != "" &amp;&amp; rows[29] != "")
                          {
                              comboBox2.Items.Add(rows[0]);
                          }
                      }
                      break;
  
                  case 10:                                                     //130
                      foreach (var rows in values)
                      {
                          if (rows[30] != "" &amp;&amp; rows[31] != "")
                          {
                              comboBox2.Items.Add(rows[0]);
                          }
                      }
                      break;
  
  
              }
          }
      }
  }
  </code></pre>