Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have an XLSX spreadsheet. It has 68251 rows and 94637 cells, and it's on-disk size is 1510842 bytes. When I try to upload it, Google claims that it exceeds the 400,000 cell limit.

The cell count here is the number of non-empty cells. The spreadsheet is created with Apache POI by a Java program. Some of the rows just have a sentence (of Korean) in the first column.

Some have a single word of Korean. Some have nothing at all, and are just there for visual whitespace.

share|improve this question
    
How many columns are you using? –  Tom Horwood Oct 16 '13 at 0:01
    
2. Sometimes the first one has a long-ish string in it. –  bmargulies Oct 16 '13 at 0:31
1  
Are you using more than one sheet? If not, I don't understand how the number of cells isn't a multiple of the number of rows. Please add more information to your question. –  Tom Horwood Oct 16 '13 at 0:42
    
And what’s the question? –  Alex Oct 18 '13 at 4:52
    
Why does it reject my spreadsheet. –  bmargulies Oct 18 '13 at 18:41

1 Answer 1

up vote 7 down vote accepted

Blank cells count towards the limit if they are within the range of non blank cells. The calculation is done by multiplying the number of the last row with data by the number of the last column with data

for example:

+----+---+---+---+
|    | A | B | C |
+----+---+---+---+
|  1 | x |   |   |
|  2 |   |   |   |
|  3 |   |   |   |
|  4 |   | x |   |
|  5 | x |   |   |
|  6 |   |   | x |
|  7 | x |   |   |
|  8 |   |   |   |
|  9 |   |   |   |
| 10 | x |   |   |
+----+---+---+---+

Although there are a lot of blank cells, and no more than once cell filled per row, the total cells calculation is 10 x 3 = 30

It is possible that non-visible characters are present in your spreadsheet (especially as your sheet was generated rather than manually created).

In a case such as the one below (if there is a space in the cell D4), there is no visual indicator of the final row.

+---+---+---+---+---+
|   | A | B | C | D |
+---+---+---+---+---+
| 1 | x |   |   |   |
| 2 | x |   |   |   |
| 3 |   | x |   |   |
| 4 |   |   |   |   |
+---+---+---+---+---+

To find out for sure what your 'end' cell is, put the focus on A1, then use Ctrl+Shift+End and the focus will move to the cell that is in the final row and the final column.

To remove any unwanted cells, select the first unwanted column, press Ctrl+Shift+Right arrow, then right-click and choose delete. Do a similar procedure to delete unwanted rows.

share|improve this answer
    
That would be 94637 * 1. There is never more than one cell filled on a row. –  bmargulies Oct 16 '13 at 1:20
    
Do you only have data in column A? –  Tom Horwood Oct 16 '13 at 2:16
    
Yes. that's correct. –  bmargulies Oct 16 '13 at 12:27
1  
It may be an artifact of Apache Poi. Ctrl-Shift-End should take you to B94637. Could you confirm this please? –  Tom Horwood Oct 16 '13 at 12:59
    
No, it takes me way out to column CW. I guess that explains it. –  bmargulies Oct 16 '13 at 17:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.