Greetings spreadsheets users! Here's what we have been working on
these past weeks, for your editing pleasure:
FEATURES
Create a "New Form" from your Docs List - This will let you
immediately create a form which will populate a spreadsheet when the
form is filled out by others. The spreadsheet is created for you in
the background and will show up in your Docs List with a special Forms
icon.
Details at http://documents.google.com/support/spreadsheets/bin/answer.py?hl=en&...
Find and replace - Finally, a quick and easy way to replace certain
words/numbers in entire spreadsheet - in one click! Use CTRL-F (or
Command-F on Mac). To get to the browser's own Find feature, hit Ctrl-
F (or Command-F) a second time.
Details at http://documents.google.com/support/spreadsheets/bin/answer.py?answer...
SPLIT formula - An easy way to break up the contents of one cell into
many individual cells.
Check out examples at http://documents.google.com/support/spreadsheets/bin/answer.py?answer...
Cross-workbook references - You can now more easily pull data from one
spreadsheet into another using the ImportRange() function.
Details and examples at http://documents.google.com/support/spreadsheets/bin/answer.py?answer...
We've also changed the way we check size limits, allowing for larger
spreadsheets that we can handle:
Rows - No explicit limit (but see the cell limits below)
Total cells - doubled from 100,000 to 200,000
Sheets - more than doubled, from 40 to 100
Cells with formulas - more than doubled, from 20,000 to 50,000
For detailed info, check out http://documents.google.com/support/spreadsheets/bin/answer.py?answer...
FIXES
You asked for better offline performance - we've definitely improved
that.
We've also fixed some annoying things such as:
- 'File format is not valid' error is displayed on exporting to XLS
when "TL" currency format is applied to data in a cell
- Importing issues with sheets with data validation
- Unable to use 'Find' to locate content that hasn't loaded yet (see
Find/Replace, above)
- Unable to scroll in chat window
- Many fixes to Gadgets embedded on a sheet or moved to its own sheet
As always, thanks for all of the feedback!
Steve
|
