Category talk:Google Docs.spreadsheets
From Bogleheads
How to publish a Google Docs spreadsheet for viewing:
- Login to Google Docs
- Create your spreadsheet (or upload from Excel).
- Note that Data Validation (same as Excel Tools --> Data Validation) is supported, but will NOT be imported or exported. IOW, Excel files will lose functionality during the export / import.
- Mixed text formatting within the same cell is not supported. A text cell with mixed underlining and colors will not be shown correctly. If the entire cell is one format, that will be OK.
- (Upper right corner) Share --> See who has access and verify all is correct.
- (Upper right corner) Share --> Publish as a web page. A dialog box appears with the URL. Verify that /key? is embedded in the URL. If you see /ccc? it's not published.
- Logout from Google Docs, clear all browser cookies from Google.com domain. Leave the Bogleheads.org cookie.
- Test that your spreadsheet is indeed viewable using the published URL.
LadyGeek 01:30, 16 February 2009 (UTC)
