Showing posts with label Google Spreadsheet Bugs. Show all posts
Showing posts with label Google Spreadsheet Bugs. Show all posts

Sunday, August 19, 2012

Bug found in Google SpreadSheet when you have more than 101 rows

I tested this issue repeatedly by deleting and adding rows and then selecting whole data by pressing "ctrl + A", and what I found is:

If you are having row up to 101 then its not a issue at all.

But when you are having rows more than 101 but not more than 150 and if you select all then actually it will select all but it will show as if you have selected only up to row 101, and display as if rows below 101 are not selected. Even if you then just select range B102 to D121, it will not be highlighted as this range has been selected, but if you copy it (ctrl + c) and then go to some other cell and paste it you will notice that it has copied the data and it is functioning properly.

And if you are having rows more than 151 but not more than 200 and if you try to select all (ctrl + A), then it will show as if you have selected only upto row 151, but not below it. And this goes on in the multiples of 50.

Actually while selecting these cells, they are not displayed as selected (not highlighted) but they are selected.

Note: if you have 233 rows (even if you have data only in the first row, may be only in one Cell A1, it will consider last row no. 233), and if you select all by "ctrl A" it will select up to rows 201 only and not below it.

This blog has been posted at 4:30 A.M. (IST) as on 19th August 2012. May be when you read this blog GOOGLE might have recityfied it.

I hope this bug will be fixed soon by GOOGLE.

Thursday, August 16, 2012

Google spreadsheet normal view disappears and only grey screen appears

While opening a spreadsheet, you may notice that, it opens normally but only for a second, then the page goes blank, "grey screen appears", leaving the title and tabs on top and the row numbers along the side, but nothing else. Following is the screenshot:






It seems there is a some problem with Google Docs.

But here is a solution, you can see the spreadsheet by following these steps

1) Go to the View menu.

2) Then, point your mouse to Freeze columns....
3) Select Freeze 3 columns option.


After performing these steps, you will be able to view and edit data.


Notice: if you freeze 1 or 2 columns - only these columns will be seen. Full spreadsheet becomes visible with 3 columns frozen.


I hope the above solution will help you to open your spreadsheet normally, and I hope GOOGLE DOCS will figure out this issue soon.