| GOOGLE SPREADSHEETS | |||
| Forum¬ | Current issues¬ and status¬ | spreadsheet Function list | |
| PROBLEMS AFFECTING VIEWERS |
|||
| Date |
PROBLEM |
WORKAROUND |
FOUND USING |
| 2011-05 |
Control - mouse wheel fails to zoom the browswer window. |
Use Ctrl + to zoom in, and Ctrl - to zoom out |
Firefox 6 |
| 2011-05 | Changing the zoom level, E.g. with Ctrl- or Ctrl+, can put the blue "selected cell" indication in the wrong place. | If this happens, retresh the browser window | Firefox 6 |
| 2011-05 | Clicking to the left of right of the horizontal scroll bar has no effect. |
Drag the horizontal scroll bar. |
Firefox 6 |
| 2011-05 | Clicking on the up and down scroll bar arrors somethimes has no effect. |
Use the mouse wheel, drag the vertical scroll bar, or click on above or below the vertical scroll bar. |
Firefox 6 |
| 2011-05 | The part of the status bar on the bottom of the window allocated to the selected formula is too small. |
Always use F2 to display the formula |
Firefox 6 |
| Date | PROBLEMS AFFECTING EDITORS |
||
| 2011-05 | Moving a row containing a named cell does not change the value of the name |
Use cell references instead of named cells |
Firefox 6 |
| 2011-05 | Drop down boxes dissapear if the mouse moves off the icon/box |
Hold the mouse button to remind yourself to move down before moving across |
Firefox 6 |
| 2011-05 | use of #value! in a comparison formula causes a "Server error" |
Firefox 6 | |
| 2011-05 | Copying cells, does not copy any conditional formatting. |
Enter any conditional formatting by hand |
Firefox 6 |
| 2011-05 | Clicking on a long formula near the RH edge of the window displays a scroll bar which can obscure the formula |
.Maintain a bland column at the RH edge of the sheet. |
Firefox 6 |
| 2011-05 | The Firefox spell checker does not seem to be able to suggest or correct spellings. |
Highlight the whole sheet. Tools > Spelling then left click on any red underlined words, then on the correctly spelt word, and "Next" to impliment the change. |
Firefox 6 |
| 2011-12 |
All unfrozen columns disappear shortly after loading |
Avoid freezing two columns, if necessary by creating a third column |
Firefox 6 and 8 |
| 2012-12-13 |
Using the File>Revision history to go back to a previous version and then forward to the current one can delete hidden rows |
||
| Date | PROBLEMS AFFECTING PDF PRINTING |
||
| 2011-05 | Comments print as numbers in square brackets, with a key on the last page of the printout |
Don't use comments |
Firefox 6 |
| 2011-05 | Some characters, (such as char(9485)) appear correctly on screen, but (some of them?) appear different in the PDF |
Test print any sheets with unusual characters
|
Firefox 6 |
| Date | PROBLEMS AFFECTING CONVERSION TO EXCEL | ||
| 2011-12-13 |
=<source cell>, where the source cell is blank produces blank in Google, but 0 in Excel |
Change to
=if(<cource cell>="","",<source cell>)
|
Firefox 8 |
| 2011-12-13 | =contcatenate(<cell1>:<cell2>) |
Produces #VALUE in Excel | Firefox 8 |
| 2011-12-13 | User Defined Functions |
Are undefined in Excel, with any previous values being lost |
Firefox 8 |