Hi All, I am trying to query a spreadsheet using the Google Spreadsheet API. I want a list of entries that includes only those column that have a certain value. To this end, I have tacked on sq=code%3dX (sq=code=X where X is some integer that's computed using the formula =dec2hex(row ()-2)). However, I never get any results because the "code" column is computed. The URI I'm querying is this:
http://spreadsheets.google.com/feeds/list/key/worksheetId/private/values?sq=code%3DX When I change the row w/ a code of X to use the actual number and not the formula, I get one result. With the formula, however, I get none. Can I not perform a structured query using the values computed by a formula? TIA! -- Regards, Travis Spencer -- You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to google-docs-data-a...@googlegroups.com. To unsubscribe from this group, send email to google-docs-data-apis+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en.
