Created
March 7, 2018 01:07
-
-
Save jennybc/da964b6b598549c0a038019808eff45f to your computer and use it in GitHub Desktop.
spreadsheets vs spreadsheets.values for https://docs.google.com/spreadsheets/d/132Ij_8ggTKVLnLqCOM3ima6mV9F8rmY7HEcR-5hjWoQ/edit
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| curl 'https://sheets.googleapis.com/v4/spreadsheets/132Ij_8ggTKVLnLqCOM3ima6mV9F8rmY7HEcR-5hjWoQ?includeGridData=true&ranges=Sheet1!A1%3AF6&key=AIzaSyDXicV6oK4vR948PUAvlyr7QhkNwCoQ0cA' -H 'Accept: application/json' --compressed > spreadsheets_get_2.json | |
| curl 'https://sheets.googleapis.com/v4/spreadsheets/132Ij_8ggTKVLnLqCOM3ima6mV9F8rmY7HEcR-5hjWoQ/values/Sheet1!A1%3AF6?key=AIzaSyDXicV6oK4vR948PUAvlyr7QhkNwCoQ0cA' -H 'Accept: application/json' --compressed > spreadsheets_values_get.json |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "spreadsheetId": "132Ij_8ggTKVLnLqCOM3ima6mV9F8rmY7HEcR-5hjWoQ", | |
| "properties": { | |
| "title": "gs-test-formula-formatting", | |
| "locale": "en_US", | |
| "autoRecalc": "ON_CHANGE", | |
| "timeZone": "America/Los_Angeles", | |
| "defaultFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| } | |
| } | |
| }, | |
| "sheets": [ | |
| { | |
| "properties": { | |
| "sheetId": 0, | |
| "title": "Sheet1", | |
| "index": 0, | |
| "sheetType": "GRID", | |
| "gridProperties": { | |
| "rowCount": 1000, | |
| "columnCount": 25 | |
| } | |
| }, | |
| "data": [ | |
| { | |
| "rowData": [ | |
| { | |
| "values": [ | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "integer" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "integer" | |
| }, | |
| "formattedValue": "integer", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "number_formatted" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "number_formatted" | |
| }, | |
| "formattedValue": "number_formatted", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "number_rounded" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "number_rounded" | |
| }, | |
| "formattedValue": "number_rounded", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "character" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "character" | |
| }, | |
| "formattedValue": "character", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "formula" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "formula" | |
| }, | |
| "formattedValue": "formula", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "formula_formatted" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "formula_formatted" | |
| }, | |
| "formattedValue": "formula_formatted", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "values": [ | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 123456 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 123456 | |
| }, | |
| "formattedValue": "123456", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 654321 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 654321 | |
| }, | |
| "formattedValue": "654,321", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 1.2345 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 1.2345 | |
| }, | |
| "formattedValue": "1.23", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "one" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "one" | |
| }, | |
| "formattedValue": "one", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "formulaValue": "=HYPERLINK(\"http://www.google.com/\",\"Google\")" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "Google" | |
| }, | |
| "formattedValue": "Google", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": { | |
| "red": 0.06666667, | |
| "green": 0.33333334, | |
| "blue": 0.8 | |
| }, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": true | |
| }, | |
| "hyperlinkDisplayType": "LINKED" | |
| }, | |
| "hyperlink": "http://www.google.com/" | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "formulaValue": "=average(A2:A6)" | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 317897.75 | |
| }, | |
| "formattedValue": "3.18E+05", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "SCIENTIFIC", | |
| "pattern": "0.00E+00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "SCIENTIFIC", | |
| "pattern": "0.00E+00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "values": [ | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 345678 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 345678 | |
| }, | |
| "formattedValue": "345678", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 0.1234 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 0.1234 | |
| }, | |
| "formattedValue": "12.34%", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "PERCENT", | |
| "pattern": "0.00%" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "PERCENT", | |
| "pattern": "0.00%" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 2.3456 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 2.3456 | |
| }, | |
| "formattedValue": "2.35", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| {}, | |
| { | |
| "userEnteredValue": { | |
| "formulaValue": "=sum(A2:A6)" | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 1271591 | |
| }, | |
| "formattedValue": "1,271,591.00", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "formulaValue": "=A2/A4" | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 0.52631444320812393 | |
| }, | |
| "formattedValue": "52.63%", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "PERCENT", | |
| "pattern": "0.00%" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "PERCENT", | |
| "pattern": "0.00%" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "values": [ | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 234567 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 234567 | |
| }, | |
| "formattedValue": "234567", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 1234567890 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 1234567890 | |
| }, | |
| "formattedValue": "1.23E+09", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "SCIENTIFIC", | |
| "pattern": "0.00E+00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "SCIENTIFIC", | |
| "pattern": "0.00E+00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 3.4567 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 3.4567 | |
| }, | |
| "formattedValue": "3.46", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "three" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "three" | |
| }, | |
| "formattedValue": "three", | |
| "userEnteredFormat": { | |
| "textFormat": { | |
| "fontFamily": "courier new,monospace", | |
| "bold": true | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "courier new,monospace", | |
| "fontSize": 10, | |
| "bold": true, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "formulaValue": "=IMAGE(\"https://www.google.com/images/srpr/logo3w.png\")" | |
| }, | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "formulaValue": "=A2/A6" | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 0.21739421366813996 | |
| }, | |
| "formattedValue": "0.22", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "0.00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "0.00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "values": [ | |
| {}, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 3.14159265359 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 3.14159265359 | |
| }, | |
| "formattedValue": "3 1/7", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "# ?/?" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "# ?/?" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 4.5678 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 4.5678 | |
| }, | |
| "formattedValue": "4.57", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "four" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "four" | |
| }, | |
| "formattedValue": "four", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "formulaValue": "=ADDRESS(1,1)" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "$A$1" | |
| }, | |
| "formattedValue": "$A$1", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "formulaValue": "=min(A2:A6)" | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 123456 | |
| }, | |
| "formattedValue": "123,456.00", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "values": [ | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 567890 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 567890 | |
| }, | |
| "formattedValue": "567890", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 0.36 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 0.36 | |
| }, | |
| "formattedValue": "$0.36", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "CURRENCY", | |
| "pattern": "\"$\"#,##0.00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "CURRENCY", | |
| "pattern": "\"$\"#,##0.00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "numberValue": 5.6789 | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 5.6789 | |
| }, | |
| "formattedValue": "5.68", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0.00" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "stringValue": "five" | |
| }, | |
| "effectiveValue": { | |
| "stringValue": "five" | |
| }, | |
| "formattedValue": "five", | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 0.9019608, | |
| "green": 0.5686275, | |
| "blue": 0.21960784 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "formulaValue": "=SPARKLINE(A2:A6)" | |
| }, | |
| "effectiveFormat": { | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "LEFT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": { | |
| "red": 0.21568628, | |
| "green": 0.3764706, | |
| "blue": 0.5686275 | |
| }, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| }, | |
| { | |
| "userEnteredValue": { | |
| "formulaValue": "=average($A$2:$A$6)" | |
| }, | |
| "effectiveValue": { | |
| "numberValue": 317897.75 | |
| }, | |
| "formattedValue": "317,898", | |
| "userEnteredFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0" | |
| } | |
| }, | |
| "effectiveFormat": { | |
| "numberFormat": { | |
| "type": "NUMBER", | |
| "pattern": "#,##0" | |
| }, | |
| "backgroundColor": { | |
| "red": 1, | |
| "green": 1, | |
| "blue": 1 | |
| }, | |
| "padding": { | |
| "top": 2, | |
| "right": 3, | |
| "bottom": 2, | |
| "left": 3 | |
| }, | |
| "horizontalAlignment": "RIGHT", | |
| "verticalAlignment": "BOTTOM", | |
| "wrapStrategy": "OVERFLOW_CELL", | |
| "textFormat": { | |
| "foregroundColor": {}, | |
| "fontFamily": "arial,sans,sans-serif", | |
| "fontSize": 10, | |
| "bold": false, | |
| "italic": false, | |
| "strikethrough": false, | |
| "underline": false | |
| }, | |
| "hyperlinkDisplayType": "PLAIN_TEXT" | |
| } | |
| } | |
| ] | |
| } | |
| ], | |
| "rowMetadata": [ | |
| { | |
| "pixelSize": 21 | |
| }, | |
| { | |
| "pixelSize": 21 | |
| }, | |
| { | |
| "pixelSize": 21 | |
| }, | |
| { | |
| "pixelSize": 21 | |
| }, | |
| { | |
| "pixelSize": 21 | |
| }, | |
| { | |
| "pixelSize": 21 | |
| } | |
| ], | |
| "columnMetadata": [ | |
| { | |
| "pixelSize": 50 | |
| }, | |
| { | |
| "pixelSize": 112 | |
| }, | |
| { | |
| "pixelSize": 105 | |
| }, | |
| { | |
| "pixelSize": 60 | |
| }, | |
| { | |
| "pixelSize": 82 | |
| }, | |
| { | |
| "pixelSize": 111 | |
| } | |
| ] | |
| } | |
| ], | |
| "conditionalFormats": [ | |
| { | |
| "ranges": [ | |
| { | |
| "startRowIndex": 5, | |
| "endRowIndex": 6, | |
| "startColumnIndex": 3, | |
| "endColumnIndex": 4 | |
| } | |
| ], | |
| "booleanRule": { | |
| "condition": { | |
| "type": "NOT_BLANK" | |
| }, | |
| "format": { | |
| "backgroundColor": { | |
| "red": 0.9019608, | |
| "green": 0.5686275, | |
| "blue": 0.21960784 | |
| } | |
| } | |
| } | |
| } | |
| ] | |
| } | |
| ], | |
| "spreadsheetUrl": "https://docs.google.com/spreadsheets/d/132Ij_8ggTKVLnLqCOM3ima6mV9F8rmY7HEcR-5hjWoQ/edit" | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "range": "Sheet1!A1:F6", | |
| "majorDimension": "ROWS", | |
| "values": [ | |
| [ | |
| "integer", | |
| "number_formatted", | |
| "number_rounded", | |
| "character", | |
| "formula", | |
| "formula_formatted" | |
| ], | |
| [ | |
| "123456", | |
| "654,321", | |
| "1.23", | |
| "one", | |
| "Google", | |
| "3.18E+05" | |
| ], | |
| [ | |
| "345678", | |
| "12.34%", | |
| "2.35", | |
| "", | |
| "1,271,591.00", | |
| "52.63%" | |
| ], | |
| [ | |
| "234567", | |
| "1.23E+09", | |
| "3.46", | |
| "three", | |
| "", | |
| "0.22" | |
| ], | |
| [ | |
| "", | |
| "3 1/7", | |
| "4.57", | |
| "four", | |
| "$A$1", | |
| "123,456.00" | |
| ], | |
| [ | |
| "567890", | |
| "$0.36", | |
| "5.68", | |
| "five", | |
| "", | |
| "317,898" | |
| ] | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment