# General Questions

    * Do I need to have a gmail account to use Google Spreadsheets?
    * How can I switch off the autosave option
    * How can I have more than 100 rows ?
    * The format I want is not in the menu. What can I do?
    * How can I create a custom format ?
    * I have opened up a spreadsheet and it is totally black.
    * How does the autofill feature work?
    * How do I hide the gridlines.
    * Can I use names for ranges?
    * How can I make an email address live/clickable?

# Time and date related questions.

    * How can I calculate working times ?
    * How can I get the local time/date for my timezone?
    * How can I format time without hours?
    * How can I format time values without the seconds ?
    * How can I add times ?
    * How can I display time values which are over 24 hours ?
    * How to display the day of the week ?

google.visualization.Query.setResponse({
    version: '0.6',
    status: 'ok',
    sig: '202289222',
    table: {
        cols: [{
            id: 'A',
            label: 'Name',
            type: 'string',
            pattern: ''
        },
        {
            id: 'B',
            label: 'Value',
            type: 'number',
            pattern: '#0.###############'
        }],
        rows: [{
            c: [{
                v: 'One'
            },
            {
                v: 1.0,
                f: '1'
            }]
        },
        {
            c: [{
                v: 'Ten'
            },
            {
                v: 10.0,
                f: '10'
            }]
        }]
    }
});

( pretty printed by http://jsbeautifier.org/ )

Here's an example: http://spreadsheets.google.com/tq?key=rYdmpMlO1sGo3OBxv6SusWA&range=A1:B3&gid=0 and the spreadsheet it came from: http://spreadsheets.google.com/ccc?key=rYdmpMlO1sGo3OBxv6SusWA&hl=en

google.visualization.Query

Represents a query that is sent to a data source.

Constructor

google.visualization.Query(dataSourceUrl, opt_options)

Parameters

dataSourceUrl

[Required, String] URL to send the query to. The data source should expose this URL in some way; for example, to get the dataSourceUrl from a Google Spreadsheet, do the following:

1. In your spreadsheet, select the range of cells.
2. Select 'Insert' and then 'Gadget' from the menu.
3. Open the gadget's menu by clicking on the top-right selector.
4. Select menu option 'Get data source URL'.

• Here's the spreadsheet: http://spreadsheets.google.com/ccc?key=r3nTy-cjddJFXh6ZmpmxcaA&hl=en#
• Here's where I set up the page: http://www.google.com/webelements/docs/spreadsheets/
• How is this different from a Google Gadget?

This presents you with various categories of gadgets to choose from (similar to the iGoogle directory). My gadget isn't yet in the gallery, so you'll need to select "Custom" and then type in the URL to the gadget:

12. The Morris worm
11. Google search rank
10. Apollo guidance system
9. Excel spreadsheet
8. Macintosh OS
7. Sabre system
6. Mosaic browser
5. Java language
4. IBM System 360 OS
That leaves my third, second, and top-most choices still to go. So here they are:

"Categorized PUBLIC examples, spreadsheets, templates and stories of collaboration and sharing using Google Docs."

"Vaughn Seward - aka Masago - not only posts one form of poetry to his blog every day, but he also uses spreadsheets extensively to outline his works and some of he meanings and categories behind them. Possibly the most interesting non-numeric applications of spreadsheets I've seen. Now, if Vaughn begins to collaborate online with other poets, we may see a real boom in the real-time-collaborative-spreadsheet-based-poetry market ;) Site: Masago's Daily Haiku Blog Page/Post: Rengay through the seasons #21 Spreadsheet: Haiku Poetry Spreadsheet"