Spreadsheets - New features, fixes and improvements to size limits! - Announcements and Alerts

Message from discussion Spreadsheets - New features, fixes and improvements to size limits!

Google Docs Guide 4

View profile

More options Aug 12 2008, 3:41 pm

From: Google Docs Guide 4 <GDSGui...@google.com>

Date: Tue, 12 Aug 2008 12:41:37 -0700 (PDT)

Local: Tues, Aug 12 2008 3:41 pm

Subject: Spreadsheets - New features, fixes and improvements to size limits!

  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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

Forward