smartsheet
Advanced tools
Comparing version 2.77.1 to 2.77.2
@@ -10,2 +10,10 @@ # Changelog | ||
## 2.77.2 - Aug 9, 2019 | ||
- Updated the following dependencies due to security vulnerabilities: | ||
- `set-value` | ||
- `union-value` | ||
- `mixin-deep` | ||
- `lodash` | ||
- `lodash.merge` | ||
## 2.77.1 - June 6, 2019 | ||
@@ -12,0 +20,0 @@ - Updated `js-yaml` and `handlebars` dependencies due to security vulnerabilities |
{ | ||
"name": "smartsheet", | ||
"version": "2.77.1", | ||
"version": "2.77.2", | ||
"description": "Smartsheet JavaScript client SDK", | ||
@@ -5,0 +5,0 @@ "main": "index.js", |
@@ -177,2 +177,4 @@ # Smartsheet SDK for JavaScript [![Build Status](https://travis-ci.org/smartsheet-platform/smartsheet-javascript-sdk.svg?branch=master)](https://travis-ci.org/smartsheet-platform/smartsheet-javascript-sdk) [![Coverage Status](https://coveralls.io/repos/github/smartsheet-platform/smartsheet-javascript-sdk/badge.svg?branch=master)](https://coveralls.io/github/smartsheet-platform/smartsheet-javascript-sdk?branch=master) [![npm version](https://badge.fury.io/js/smartsheet.svg)](https://badge.fury.io/js/smartsheet) | ||
Note that a successful test run will currently output some unhandled rejection messages in the body of the logs. This is expected, and does not indicate test failure. | ||
## Passthrough Option | ||
@@ -179,0 +181,0 @@ |
@@ -85,2 +85,3 @@ [ | ||
"backgroundColor": "#E2E2E2", | ||
"permalink": "https://app.smartsheet.com/dashboards/Qv1", | ||
"columnCount": 6, | ||
@@ -92,8 +93,9 @@ "widgets": [ | ||
"contents": { | ||
"type": "SHORTCUT", | ||
"shortcutData": [ | ||
{ | ||
"label": "Starbucks Stores By State", | ||
"labelFormat": ",2,,,,,1,,1,,,,,,,", | ||
"labelFormat": ",2,,,,,1,,1,,,,,,,,", | ||
"hyperlink": { | ||
"url": "https://app.smartsheet.com/b/home", | ||
"url": "https://app.smartsheet.com/sheets/r21", | ||
"sheetId": 500 | ||
@@ -112,3 +114,3 @@ }, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
@@ -120,2 +122,7 @@ }, | ||
"contents": { | ||
"type": "METRIC", | ||
"hyperlink": { | ||
"url": "http://www.seattle.gov/", | ||
"interactionType": "WEB" | ||
}, | ||
"cellData": [ | ||
@@ -125,7 +132,8 @@ { | ||
"label": "Millimetres", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 4, | ||
"cell": { | ||
"columnId": 236, | ||
"rowId": 284, | ||
"value": 958, | ||
@@ -135,2 +143,3 @@ "objectValue": 958, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 958 | ||
@@ -141,7 +150,8 @@ }, | ||
"label": "State", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 1, | ||
"cell": { | ||
"columnId": 492, | ||
"rowId": 284, | ||
"value": "Washington", | ||
@@ -151,2 +161,3 @@ "objectValue": "Washington", | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": "Washington" | ||
@@ -157,7 +168,8 @@ }, | ||
"label": "City", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 0, | ||
"cell": { | ||
"columnId": 612, | ||
"rowId": 284, | ||
"value": "Seattle", | ||
@@ -167,2 +179,3 @@ "objectValue": "Seattle", | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": "Seattle" | ||
@@ -173,7 +186,8 @@ }, | ||
"label": "Inches", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 3, | ||
"cell": { | ||
"columnId": 740, | ||
"rowId": 284, | ||
"value": 37.7, | ||
@@ -183,2 +197,3 @@ "objectValue": 37.7, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 37.7 | ||
@@ -189,7 +204,8 @@ }, | ||
"label": "Days", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 2, | ||
"cell": { | ||
"columnId": 988, | ||
"rowId": 284, | ||
"value": 149, | ||
@@ -199,2 +215,3 @@ "objectValue": 149, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 149 | ||
@@ -206,2 +223,3 @@ } | ||
"id": 612, | ||
"version": 0, | ||
"index": 0, | ||
@@ -216,2 +234,3 @@ "title": "City", | ||
"id": 492, | ||
"version": 0, | ||
"index": 1, | ||
@@ -225,2 +244,3 @@ "title": "State", | ||
"id": 988, | ||
"version": 0, | ||
"index": 2, | ||
@@ -234,2 +254,3 @@ "title": "Days", | ||
"id": 740, | ||
"version": 0, | ||
"index": 3, | ||
@@ -243,2 +264,3 @@ "title": "Inches", | ||
"id": 236, | ||
"version": 0, | ||
"index": 4, | ||
@@ -251,3 +273,3 @@ "title": "Millimetres", | ||
], | ||
"gridID": 10624640 | ||
"sheetId": 524 | ||
}, | ||
@@ -261,3 +283,3 @@ "xPosition": 1, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
@@ -269,2 +291,3 @@ }, | ||
"contents": { | ||
"type": "RICHTEXT", | ||
"htmlContent": "<p>This is a <span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">rich</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:italic;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">text </span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">test</span></p>" | ||
@@ -281,24 +304,13 @@ }, | ||
{ | ||
"id": 612, | ||
"type": "IMAGE", | ||
"contents": { | ||
"privateId": "TCA", | ||
"height": 18, | ||
"width": 18, | ||
"fileName": "info_tip_16x16.png", | ||
"format": ",7,1,,,,2,2,1,3,,,,,,1" | ||
}, | ||
"xPosition": 4, | ||
"yPosition": 1, | ||
"width": 1, | ||
"height": 4, | ||
"showTitleIcon": false, | ||
"showTitle": false, | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 108, | ||
"type": "GRIDGANTT", | ||
"contents": { | ||
"htmlContent": "<style type=\"text/css\">" | ||
"type": "GRIDGANTT", | ||
"hyperlink": { | ||
"url": "https://app.smartsheet.com/reports/J81", | ||
"reportId": 876, | ||
"interactionType": "SOURCE_SHEET" | ||
}, | ||
"htmlContent": "<style type=\"text/css\">", | ||
"reportId": 876 | ||
}, | ||
@@ -317,4 +329,5 @@ "xPosition": 0, | ||
"contents": { | ||
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\">This is my title</span></p>", | ||
"backgroundColor": "#F7F7F7" | ||
"type": "RICHTEXT", | ||
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:20pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 )\"></span><span class=\"clsDbFt\">This is my title</span></p>", | ||
"backgroundColor": "#D0AF8F" | ||
}, | ||
@@ -330,47 +343,551 @@ "xPosition": 0, | ||
{ | ||
"id": 852, | ||
"type": "SHEETSUMMARY", | ||
"id": 796, | ||
"type": "CHART", | ||
"contents": { | ||
"type": "CHART", | ||
"hyperlink": { | ||
"url": "http://www.somesite.com" | ||
"url": "https://app.smartsheet.com/sheets/9J1", | ||
"sheetId": 660, | ||
"interactionType": "SMARTSHEET_ITEM" | ||
}, | ||
"cellData": [ | ||
"series": [ | ||
{ | ||
"columnId": 788, | ||
"label": "Population (July 1, 2013)", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"order": 0, | ||
"cell": { | ||
"columnId": 788, | ||
"value": 6971406, | ||
"objectValue": 6971406, | ||
"displayValue": "6971406" | ||
"title": "Days", | ||
"titleInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"objectValue": 6971406 | ||
"seriesType": "COLUMN", | ||
"tooltips": { | ||
"labelType": "X-SERIES-Y" | ||
}, | ||
"color": "#1061C3", | ||
"axisLocationX": "BOTTOM", | ||
"axisLocationY": "LEFT", | ||
"yColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"xColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesData": [ | ||
{ | ||
"y": 113 | ||
}, | ||
{ | ||
"x": "Austin", | ||
"y": 88 | ||
}, | ||
{ | ||
"x": "Baltimore", | ||
"y": 116 | ||
}, | ||
{ | ||
"x": "Birmingham", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Boston", | ||
"y": 126 | ||
}, | ||
{ | ||
"x": "Buffalo", | ||
"y": 167 | ||
}, | ||
{ | ||
"x": "Charlotte", | ||
"y": 110 | ||
}, | ||
{ | ||
"x": "Chicago", | ||
"y": 124 | ||
}, | ||
{ | ||
"x": "Cincinnati", | ||
"y": 137 | ||
}, | ||
{ | ||
"x": "Cleveland", | ||
"y": 155 | ||
}, | ||
{ | ||
"x": "Columbus", | ||
"y": 139 | ||
}, | ||
{ | ||
"x": "Dallas", | ||
"y": 81 | ||
}, | ||
{ | ||
"x": "Denver", | ||
"y": 87 | ||
}, | ||
{ | ||
"x": "Detroit", | ||
"y": 135 | ||
}, | ||
{ | ||
"x": "Hartford", | ||
"y": 130 | ||
}, | ||
{ | ||
"x": "Houston", | ||
"y": 104 | ||
}, | ||
{ | ||
"x": "Indianapolis", | ||
"y": 129 | ||
}, | ||
{ | ||
"x": "Jacksonville", | ||
"y": 114 | ||
}, | ||
{ | ||
"x": "Kansas City", | ||
"y": 91 | ||
}, | ||
{ | ||
"x": "Las Vegas", | ||
"y": 27 | ||
}, | ||
{ | ||
"x": "Los Angeles", | ||
"y": 36 | ||
}, | ||
{ | ||
"x": "Louisville", | ||
"y": 123 | ||
}, | ||
{ | ||
"x": "Memphis", | ||
"y": 108 | ||
}, | ||
{ | ||
"x": "Miami", | ||
"y": 135 | ||
}, | ||
{ | ||
"x": "Milwaukee", | ||
"y": 127 | ||
}, | ||
{ | ||
"x": "Minneapolis", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Nashville", | ||
"y": 119 | ||
}, | ||
{ | ||
"x": "New Orleans", | ||
"y": 115 | ||
}, | ||
{ | ||
"x": "New York", | ||
"y": 122 | ||
}, | ||
{ | ||
"x": "Oklahoma City", | ||
"y": 84 | ||
}, | ||
{ | ||
"x": "Orlando", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Philadelphia", | ||
"y": 118 | ||
}, | ||
{ | ||
"x": "Phoenix", | ||
"y": 30 | ||
}, | ||
{ | ||
"x": "Pittsburgh", | ||
"y": 151 | ||
}, | ||
{ | ||
"x": "Portland", | ||
"y": 164 | ||
}, | ||
{ | ||
"x": "Providence", | ||
"y": 125 | ||
}, | ||
{ | ||
"x": "Raleigh", | ||
"y": 100 | ||
}, | ||
{ | ||
"x": "Richmond", | ||
"y": 114 | ||
}, | ||
{ | ||
"x": "Riverside", | ||
"y": 30 | ||
}, | ||
{ | ||
"x": "Rochester", | ||
"y": 167 | ||
}, | ||
{ | ||
"x": "Sacramento", | ||
"y": 60 | ||
}, | ||
{ | ||
"x": "Salt Lake City", | ||
"y": 96 | ||
}, | ||
{ | ||
"x": "San Antonio", | ||
"y": 83 | ||
}, | ||
{ | ||
"x": "San Diego", | ||
"y": 42 | ||
}, | ||
{ | ||
"x": "San Francisco", | ||
"y": 68 | ||
}, | ||
{ | ||
"x": "San Jose", | ||
"y": 62 | ||
}, | ||
{ | ||
"x": "Seattle", | ||
"y": 149 | ||
}, | ||
{ | ||
"x": "St. Louis", | ||
"y": 113 | ||
}, | ||
{ | ||
"x": "Tampa", | ||
"y": 105 | ||
}, | ||
{ | ||
"x": "Virginia Beach", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Washington", | ||
"y": 114 | ||
} | ||
], | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 988, | ||
"sourceColumnId2": 988 | ||
} | ||
] | ||
}, | ||
{ | ||
"title": "Inches", | ||
"titleInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesType": "COLUMN", | ||
"tooltips": { | ||
"labelType": "X-SERIES-Y" | ||
}, | ||
"color": "#EA352E", | ||
"axisLocationX": "BOTTOM", | ||
"axisLocationY": "LEFT", | ||
"yColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"xColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesData": [ | ||
{ | ||
"y": 49.7 | ||
}, | ||
{ | ||
"x": "Austin", | ||
"y": 34.2 | ||
}, | ||
{ | ||
"x": "Baltimore", | ||
"y": 41.9 | ||
}, | ||
{ | ||
"x": "Birmingham", | ||
"y": 53.7 | ||
}, | ||
{ | ||
"x": "Boston", | ||
"y": 43.8 | ||
}, | ||
{ | ||
"x": "Buffalo", | ||
"y": 40.5 | ||
}, | ||
{ | ||
"x": "Charlotte", | ||
"y": 41.6 | ||
}, | ||
{ | ||
"x": "Chicago", | ||
"y": 36.9 | ||
}, | ||
{ | ||
"x": "Cincinnati", | ||
"y": 41.9 | ||
}, | ||
{ | ||
"x": "Cleveland", | ||
"y": 39.1 | ||
}, | ||
{ | ||
"x": "Columbus", | ||
"y": 39.3 | ||
}, | ||
{ | ||
"x": "Dallas", | ||
"y": 37.6 | ||
}, | ||
{ | ||
"x": "Denver", | ||
"y": 15.6 | ||
}, | ||
{ | ||
"x": "Detroit", | ||
"y": 33.5 | ||
}, | ||
{ | ||
"x": "Hartford", | ||
"y": 45.9 | ||
}, | ||
{ | ||
"x": "Houston", | ||
"y": 49.8 | ||
}, | ||
{ | ||
"x": "Indianapolis", | ||
"y": 42.4 | ||
}, | ||
{ | ||
"x": "Jacksonville", | ||
"y": 52.4 | ||
}, | ||
{ | ||
"x": "Kansas City", | ||
"y": 39.1 | ||
}, | ||
{ | ||
"x": "Las Vegas", | ||
"y": 4.2 | ||
}, | ||
{ | ||
"x": "Los Angeles", | ||
"y": 12.8 | ||
}, | ||
{ | ||
"x": "Louisville", | ||
"y": 44.9 | ||
}, | ||
{ | ||
"x": "Memphis", | ||
"y": 53.7 | ||
}, | ||
{ | ||
"x": "Miami", | ||
"y": 61.9 | ||
}, | ||
{ | ||
"x": "Milwaukee", | ||
"y": 34.8 | ||
}, | ||
{ | ||
"x": "Minneapolis", | ||
"y": 30.6 | ||
}, | ||
{ | ||
"x": "Nashville", | ||
"y": 47.3 | ||
}, | ||
{ | ||
"x": "New Orleans", | ||
"y": 62.7 | ||
}, | ||
{ | ||
"x": "New York", | ||
"y": 49.9 | ||
}, | ||
{ | ||
"x": "Oklahoma City", | ||
"y": 36.5 | ||
}, | ||
{ | ||
"x": "Orlando", | ||
"y": 50.7 | ||
}, | ||
{ | ||
"x": "Philadelphia", | ||
"y": 41.5 | ||
}, | ||
{ | ||
"x": "Phoenix", | ||
"y": 8.2 | ||
}, | ||
{ | ||
"x": "Pittsburgh", | ||
"y": 38.2 | ||
}, | ||
{ | ||
"x": "Portland", | ||
"y": 43.5 | ||
}, | ||
{ | ||
"x": "Providence", | ||
"y": 47.2 | ||
}, | ||
{ | ||
"x": "Raleigh", | ||
"y": 46 | ||
}, | ||
{ | ||
"x": "Richmond", | ||
"y": 43.6 | ||
}, | ||
{ | ||
"x": "Riverside", | ||
"y": 10.3 | ||
}, | ||
{ | ||
"x": "Rochester", | ||
"y": 34.3 | ||
}, | ||
{ | ||
"x": "Sacramento", | ||
"y": 18.5 | ||
}, | ||
{ | ||
"x": "Salt Lake City", | ||
"y": 16.1 | ||
}, | ||
{ | ||
"x": "San Antonio", | ||
"y": 32.3 | ||
}, | ||
{ | ||
"x": "San Diego", | ||
"y": 10.3 | ||
}, | ||
{ | ||
"x": "San Francisco", | ||
"y": 20.7 | ||
}, | ||
{ | ||
"x": "San Jose", | ||
"y": 15.8 | ||
}, | ||
{ | ||
"x": "Seattle", | ||
"y": 37.7 | ||
}, | ||
{ | ||
"x": "St. Louis", | ||
"y": 41 | ||
}, | ||
{ | ||
"x": "Tampa", | ||
"y": 46.3 | ||
}, | ||
{ | ||
"x": "Virginia Beach", | ||
"y": 46.5 | ||
}, | ||
{ | ||
"x": "Washington", | ||
"y": 39.7 | ||
} | ||
], | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 740, | ||
"sourceColumnId2": 740 | ||
} | ||
] | ||
} | ||
], | ||
"columns": [ | ||
"axes": [ | ||
{ | ||
"id": 788, | ||
"index": 2, | ||
"title": "Population (July 1, 2013)", | ||
"type": "TEXT_NUMBER", | ||
"validation": false, | ||
"width": 150 | ||
"location": "LEFT", | ||
"includeZero": true | ||
}, | ||
{ | ||
"location": "BOTTOM" | ||
} | ||
], | ||
"gridID": 10624332 | ||
"legend": { | ||
"location": "RIGHT" | ||
}, | ||
"sheetId": 524, | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 612, | ||
"sourceColumnId2": 740 | ||
} | ||
] | ||
}, | ||
"xPosition": 0, | ||
"yPosition": 11, | ||
"width": 4, | ||
"height": 6, | ||
"title": "Annual Averages for Total Precipitation By City", | ||
"showTitleIcon": false, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 932, | ||
"type": "IMAGE", | ||
"contents": { | ||
"type": "IMAGE", | ||
"hyperlink": { | ||
"url": "http://www.smartsheet.com", | ||
"interactionType": "WEB" | ||
}, | ||
"privateId": "_kpnN9Q", | ||
"height": 48, | ||
"width": 197, | ||
"fileName": "smartsheet-logo-blue-197x48.png", | ||
"format": ",7,1,,,,2,2,1,3,,,,,,1," | ||
}, | ||
"xPosition": 4, | ||
"yPosition": 5, | ||
"yPosition": 1, | ||
"width": 1, | ||
"height": 2, | ||
"title": "Starbucks Stores By State", | ||
"showTitleIcon": true, | ||
"height": 4, | ||
"showTitleIcon": false, | ||
"showTitle": false, | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 636, | ||
"type": "WEBCONTENT", | ||
"contents": { | ||
"type": "WidgetWebContent", | ||
"url": "https://www.youtube.com/" | ||
}, | ||
"xPosition": 0, | ||
"yPosition": 17, | ||
"width": 4, | ||
"height": 6, | ||
"showTitleIcon": false, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
} | ||
] | ||
], | ||
"createdAt": "2016-08-14T23:45:06Z", | ||
"modifiedAt": "2019-07-12T22:25:42Z" | ||
} | ||
@@ -433,14 +950,16 @@ } | ||
"backgroundColor": "#E2E2E2", | ||
"permalink": "https://app.smartsheet.com/dashboards/PP1", | ||
"columnCount": 6, | ||
"widgets": [ | ||
{ | ||
"id": 556, | ||
"id": 532, | ||
"type": "SHORTCUTLIST", | ||
"contents": { | ||
"type": "SHORTCUT", | ||
"shortcutData": [ | ||
{ | ||
"label": "Starbucks Stores By State", | ||
"labelFormat": ",2,,,,,1,,1,,,,,,,", | ||
"labelFormat": ",2,,,,,1,,1,,,,,,,,", | ||
"hyperlink": { | ||
"url": "https://app.smartsheet.com/b/home", | ||
"url": "https://app.smartsheet.com/sheets/r21", | ||
"sheetId": 500 | ||
@@ -459,9 +978,14 @@ }, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 500, | ||
"id": 28, | ||
"type": "SHEETSUMMARY", | ||
"contents": { | ||
"type": "METRIC", | ||
"hyperlink": { | ||
"url": "http://www.seattle.gov/", | ||
"interactionType": "WEB" | ||
}, | ||
"cellData": [ | ||
@@ -471,7 +995,8 @@ { | ||
"label": "Millimetres", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 4, | ||
"cell": { | ||
"columnId": 236, | ||
"rowId": 284, | ||
"value": 958, | ||
@@ -481,2 +1006,3 @@ "objectValue": 958, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 958 | ||
@@ -487,7 +1013,8 @@ }, | ||
"label": "State", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 1, | ||
"cell": { | ||
"columnId": 492, | ||
"rowId": 284, | ||
"value": "Washington", | ||
@@ -497,2 +1024,3 @@ "objectValue": "Washington", | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": "Washington" | ||
@@ -503,7 +1031,8 @@ }, | ||
"label": "City", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 0, | ||
"cell": { | ||
"columnId": 612, | ||
"rowId": 284, | ||
"value": "Seattle", | ||
@@ -513,2 +1042,3 @@ "objectValue": "Seattle", | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": "Seattle" | ||
@@ -519,7 +1049,8 @@ }, | ||
"label": "Inches", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 3, | ||
"cell": { | ||
"columnId": 740, | ||
"rowId": 284, | ||
"value": 37.7, | ||
@@ -529,2 +1060,3 @@ "objectValue": 37.7, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 37.7 | ||
@@ -535,7 +1067,8 @@ }, | ||
"label": "Days", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 2, | ||
"cell": { | ||
"columnId": 988, | ||
"rowId": 284, | ||
"value": 149, | ||
@@ -545,2 +1078,3 @@ "objectValue": 149, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 149 | ||
@@ -552,2 +1086,3 @@ } | ||
"id": 612, | ||
"version": 0, | ||
"index": 0, | ||
@@ -562,2 +1097,3 @@ "title": "City", | ||
"id": 492, | ||
"version": 0, | ||
"index": 1, | ||
@@ -571,2 +1107,3 @@ "title": "State", | ||
"id": 988, | ||
"version": 0, | ||
"index": 2, | ||
@@ -580,2 +1117,3 @@ "title": "Days", | ||
"id": 740, | ||
"version": 0, | ||
"index": 3, | ||
@@ -589,2 +1127,3 @@ "title": "Inches", | ||
"id": 236, | ||
"version": 0, | ||
"index": 4, | ||
@@ -597,3 +1136,3 @@ "title": "Millimetres", | ||
], | ||
"gridID": 10624640 | ||
"sheetId": 524 | ||
}, | ||
@@ -607,9 +1146,10 @@ "xPosition": 1, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 5371172654212996, | ||
"id": 20, | ||
"type": "RICHTEXT", | ||
"contents": { | ||
"type": "RICHTEXT", | ||
"htmlContent": "<p>This is a <span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">rich</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:italic;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">text </span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">test</span></p>" | ||
@@ -626,24 +1166,13 @@ }, | ||
{ | ||
"id": 748, | ||
"type": "IMAGE", | ||
"contents": { | ||
"privateId": "TCA", | ||
"height": 18, | ||
"width": 18, | ||
"fileName": "info_tip_16x16.png", | ||
"format": ",7,1,,,,2,2,1,3,,,,,,1" | ||
}, | ||
"xPosition": 4, | ||
"yPosition": 1, | ||
"width": 1, | ||
"height": 4, | ||
"showTitleIcon": false, | ||
"showTitle": false, | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 244, | ||
"id": 516, | ||
"type": "GRIDGANTT", | ||
"contents": { | ||
"htmlContent": "<style type=\"text/css\">" | ||
"type": "GRIDGANTT", | ||
"hyperlink": { | ||
"url": "https://app.smartsheet.com/reports/J81", | ||
"reportId": 876, | ||
"interactionType": "SOURCE_SHEET" | ||
}, | ||
"htmlContent": "<style type=\"text/css\">", | ||
"reportId": 876 | ||
}, | ||
@@ -659,7 +1188,8 @@ "xPosition": 0, | ||
{ | ||
"id": 124, | ||
"id": 268, | ||
"type": "TITLE", | ||
"contents": { | ||
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\">This is my title</span></p>", | ||
"backgroundColor": "#F7F7F7" | ||
"type": "RICHTEXT", | ||
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:20pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 )\"></span><span class=\"clsDbFt\">This is my title</span></p>", | ||
"backgroundColor": "#D0AF8F" | ||
}, | ||
@@ -675,47 +1205,551 @@ "xPosition": 0, | ||
{ | ||
"id": 620, | ||
"type": "SHEETSUMMARY", | ||
"id": 764, | ||
"type": "CHART", | ||
"contents": { | ||
"type": "CHART", | ||
"hyperlink": { | ||
"url": "http://www.somesite.com" | ||
"url": "https://app.smartsheet.com/sheets/9J1", | ||
"sheetId": 660, | ||
"interactionType": "SMARTSHEET_ITEM" | ||
}, | ||
"cellData": [ | ||
"series": [ | ||
{ | ||
"columnId": 788, | ||
"label": "Population (July 1, 2013)", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"order": 0, | ||
"cell": { | ||
"columnId": 788, | ||
"value": 6971406, | ||
"objectValue": 6971406, | ||
"displayValue": "6971406" | ||
"title": "Days", | ||
"titleInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"objectValue": 6971406 | ||
"seriesType": "COLUMN", | ||
"tooltips": { | ||
"labelType": "X-SERIES-Y" | ||
}, | ||
"color": "#1061C3", | ||
"axisLocationX": "BOTTOM", | ||
"axisLocationY": "LEFT", | ||
"yColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"xColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesData": [ | ||
{ | ||
"y": 113 | ||
}, | ||
{ | ||
"x": "Austin", | ||
"y": 88 | ||
}, | ||
{ | ||
"x": "Baltimore", | ||
"y": 116 | ||
}, | ||
{ | ||
"x": "Birmingham", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Boston", | ||
"y": 126 | ||
}, | ||
{ | ||
"x": "Buffalo", | ||
"y": 167 | ||
}, | ||
{ | ||
"x": "Charlotte", | ||
"y": 110 | ||
}, | ||
{ | ||
"x": "Chicago", | ||
"y": 124 | ||
}, | ||
{ | ||
"x": "Cincinnati", | ||
"y": 137 | ||
}, | ||
{ | ||
"x": "Cleveland", | ||
"y": 155 | ||
}, | ||
{ | ||
"x": "Columbus", | ||
"y": 139 | ||
}, | ||
{ | ||
"x": "Dallas", | ||
"y": 81 | ||
}, | ||
{ | ||
"x": "Denver", | ||
"y": 87 | ||
}, | ||
{ | ||
"x": "Detroit", | ||
"y": 135 | ||
}, | ||
{ | ||
"x": "Hartford", | ||
"y": 130 | ||
}, | ||
{ | ||
"x": "Houston", | ||
"y": 104 | ||
}, | ||
{ | ||
"x": "Indianapolis", | ||
"y": 129 | ||
}, | ||
{ | ||
"x": "Jacksonville", | ||
"y": 114 | ||
}, | ||
{ | ||
"x": "Kansas City", | ||
"y": 91 | ||
}, | ||
{ | ||
"x": "Las Vegas", | ||
"y": 27 | ||
}, | ||
{ | ||
"x": "Los Angeles", | ||
"y": 36 | ||
}, | ||
{ | ||
"x": "Louisville", | ||
"y": 123 | ||
}, | ||
{ | ||
"x": "Memphis", | ||
"y": 108 | ||
}, | ||
{ | ||
"x": "Miami", | ||
"y": 135 | ||
}, | ||
{ | ||
"x": "Milwaukee", | ||
"y": 127 | ||
}, | ||
{ | ||
"x": "Minneapolis", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Nashville", | ||
"y": 119 | ||
}, | ||
{ | ||
"x": "New Orleans", | ||
"y": 115 | ||
}, | ||
{ | ||
"x": "New York", | ||
"y": 122 | ||
}, | ||
{ | ||
"x": "Oklahoma City", | ||
"y": 84 | ||
}, | ||
{ | ||
"x": "Orlando", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Philadelphia", | ||
"y": 118 | ||
}, | ||
{ | ||
"x": "Phoenix", | ||
"y": 30 | ||
}, | ||
{ | ||
"x": "Pittsburgh", | ||
"y": 151 | ||
}, | ||
{ | ||
"x": "Portland", | ||
"y": 164 | ||
}, | ||
{ | ||
"x": "Providence", | ||
"y": 125 | ||
}, | ||
{ | ||
"x": "Raleigh", | ||
"y": 100 | ||
}, | ||
{ | ||
"x": "Richmond", | ||
"y": 114 | ||
}, | ||
{ | ||
"x": "Riverside", | ||
"y": 30 | ||
}, | ||
{ | ||
"x": "Rochester", | ||
"y": 167 | ||
}, | ||
{ | ||
"x": "Sacramento", | ||
"y": 60 | ||
}, | ||
{ | ||
"x": "Salt Lake City", | ||
"y": 96 | ||
}, | ||
{ | ||
"x": "San Antonio", | ||
"y": 83 | ||
}, | ||
{ | ||
"x": "San Diego", | ||
"y": 42 | ||
}, | ||
{ | ||
"x": "San Francisco", | ||
"y": 68 | ||
}, | ||
{ | ||
"x": "San Jose", | ||
"y": 62 | ||
}, | ||
{ | ||
"x": "Seattle", | ||
"y": 149 | ||
}, | ||
{ | ||
"x": "St. Louis", | ||
"y": 113 | ||
}, | ||
{ | ||
"x": "Tampa", | ||
"y": 105 | ||
}, | ||
{ | ||
"x": "Virginia Beach", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Washington", | ||
"y": 114 | ||
} | ||
], | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 988, | ||
"sourceColumnId2": 988 | ||
} | ||
] | ||
}, | ||
{ | ||
"title": "Inches", | ||
"titleInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesType": "COLUMN", | ||
"tooltips": { | ||
"labelType": "X-SERIES-Y" | ||
}, | ||
"color": "#EA352E", | ||
"axisLocationX": "BOTTOM", | ||
"axisLocationY": "LEFT", | ||
"yColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"xColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesData": [ | ||
{ | ||
"y": 49.7 | ||
}, | ||
{ | ||
"x": "Austin", | ||
"y": 34.2 | ||
}, | ||
{ | ||
"x": "Baltimore", | ||
"y": 41.9 | ||
}, | ||
{ | ||
"x": "Birmingham", | ||
"y": 53.7 | ||
}, | ||
{ | ||
"x": "Boston", | ||
"y": 43.8 | ||
}, | ||
{ | ||
"x": "Buffalo", | ||
"y": 40.5 | ||
}, | ||
{ | ||
"x": "Charlotte", | ||
"y": 41.6 | ||
}, | ||
{ | ||
"x": "Chicago", | ||
"y": 36.9 | ||
}, | ||
{ | ||
"x": "Cincinnati", | ||
"y": 41.9 | ||
}, | ||
{ | ||
"x": "Cleveland", | ||
"y": 39.1 | ||
}, | ||
{ | ||
"x": "Columbus", | ||
"y": 39.3 | ||
}, | ||
{ | ||
"x": "Dallas", | ||
"y": 37.6 | ||
}, | ||
{ | ||
"x": "Denver", | ||
"y": 15.6 | ||
}, | ||
{ | ||
"x": "Detroit", | ||
"y": 33.5 | ||
}, | ||
{ | ||
"x": "Hartford", | ||
"y": 45.9 | ||
}, | ||
{ | ||
"x": "Houston", | ||
"y": 49.8 | ||
}, | ||
{ | ||
"x": "Indianapolis", | ||
"y": 42.4 | ||
}, | ||
{ | ||
"x": "Jacksonville", | ||
"y": 52.4 | ||
}, | ||
{ | ||
"x": "Kansas City", | ||
"y": 39.1 | ||
}, | ||
{ | ||
"x": "Las Vegas", | ||
"y": 4.2 | ||
}, | ||
{ | ||
"x": "Los Angeles", | ||
"y": 12.8 | ||
}, | ||
{ | ||
"x": "Louisville", | ||
"y": 44.9 | ||
}, | ||
{ | ||
"x": "Memphis", | ||
"y": 53.7 | ||
}, | ||
{ | ||
"x": "Miami", | ||
"y": 61.9 | ||
}, | ||
{ | ||
"x": "Milwaukee", | ||
"y": 34.8 | ||
}, | ||
{ | ||
"x": "Minneapolis", | ||
"y": 30.6 | ||
}, | ||
{ | ||
"x": "Nashville", | ||
"y": 47.3 | ||
}, | ||
{ | ||
"x": "New Orleans", | ||
"y": 62.7 | ||
}, | ||
{ | ||
"x": "New York", | ||
"y": 49.9 | ||
}, | ||
{ | ||
"x": "Oklahoma City", | ||
"y": 36.5 | ||
}, | ||
{ | ||
"x": "Orlando", | ||
"y": 50.7 | ||
}, | ||
{ | ||
"x": "Philadelphia", | ||
"y": 41.5 | ||
}, | ||
{ | ||
"x": "Phoenix", | ||
"y": 8.2 | ||
}, | ||
{ | ||
"x": "Pittsburgh", | ||
"y": 38.2 | ||
}, | ||
{ | ||
"x": "Portland", | ||
"y": 43.5 | ||
}, | ||
{ | ||
"x": "Providence", | ||
"y": 47.2 | ||
}, | ||
{ | ||
"x": "Raleigh", | ||
"y": 46 | ||
}, | ||
{ | ||
"x": "Richmond", | ||
"y": 43.6 | ||
}, | ||
{ | ||
"x": "Riverside", | ||
"y": 10.3 | ||
}, | ||
{ | ||
"x": "Rochester", | ||
"y": 34.3 | ||
}, | ||
{ | ||
"x": "Sacramento", | ||
"y": 18.5 | ||
}, | ||
{ | ||
"x": "Salt Lake City", | ||
"y": 16.1 | ||
}, | ||
{ | ||
"x": "San Antonio", | ||
"y": 32.3 | ||
}, | ||
{ | ||
"x": "San Diego", | ||
"y": 10.3 | ||
}, | ||
{ | ||
"x": "San Francisco", | ||
"y": 20.7 | ||
}, | ||
{ | ||
"x": "San Jose", | ||
"y": 15.8 | ||
}, | ||
{ | ||
"x": "Seattle", | ||
"y": 37.7 | ||
}, | ||
{ | ||
"x": "St. Louis", | ||
"y": 41 | ||
}, | ||
{ | ||
"x": "Tampa", | ||
"y": 46.3 | ||
}, | ||
{ | ||
"x": "Virginia Beach", | ||
"y": 46.5 | ||
}, | ||
{ | ||
"x": "Washington", | ||
"y": 39.7 | ||
} | ||
], | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 740, | ||
"sourceColumnId2": 740 | ||
} | ||
] | ||
} | ||
], | ||
"columns": [ | ||
"axes": [ | ||
{ | ||
"id": 788, | ||
"index": 2, | ||
"title": "Population (July 1, 2013)", | ||
"type": "TEXT_NUMBER", | ||
"validation": false, | ||
"width": 150 | ||
"location": "LEFT", | ||
"includeZero": true | ||
}, | ||
{ | ||
"location": "BOTTOM" | ||
} | ||
], | ||
"gridID": 10624332 | ||
"legend": { | ||
"location": "RIGHT" | ||
}, | ||
"sheetId": 524, | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 612, | ||
"sourceColumnId2": 740 | ||
} | ||
] | ||
}, | ||
"xPosition": 0, | ||
"yPosition": 11, | ||
"width": 4, | ||
"height": 6, | ||
"title": "Annual Averages for Total Precipitation By City", | ||
"showTitleIcon": false, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 644, | ||
"type": "IMAGE", | ||
"contents": { | ||
"type": "IMAGE", | ||
"hyperlink": { | ||
"url": "http://www.smartsheet.com", | ||
"interactionType": "WEB" | ||
}, | ||
"privateId": "Jppz", | ||
"height": 48, | ||
"width": 197, | ||
"fileName": "smartsheet-logo-blue-197x48.png", | ||
"format": ",7,1,,,,2,2,1,3,,,,,,1," | ||
}, | ||
"xPosition": 4, | ||
"yPosition": 5, | ||
"yPosition": 1, | ||
"width": 1, | ||
"height": 2, | ||
"title": "Starbucks Stores By State", | ||
"showTitleIcon": true, | ||
"height": 4, | ||
"showTitleIcon": false, | ||
"showTitle": false, | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 140, | ||
"type": "WEBCONTENT", | ||
"contents": { | ||
"type": "WidgetWebContent", | ||
"url": "https://www.youtube.com/" | ||
}, | ||
"xPosition": 0, | ||
"yPosition": 17, | ||
"width": 4, | ||
"height": 6, | ||
"showTitleIcon": false, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
} | ||
] | ||
], | ||
"createdAt": "2019-08-07T20:12:02Z", | ||
"modifiedAt": "2019-08-07T20:12:02Z" | ||
} | ||
@@ -722,0 +1756,0 @@ } |
@@ -24,10 +24,10 @@ { | ||
"dependencies": { | ||
"colors": "^1.1.2", | ||
"underscore": "^1.8.3", | ||
"yargs": "^10.0.3" | ||
"colors": "^1.3.3", | ||
"underscore": "^1.9.1", | ||
"yargs": "^13.3.0" | ||
}, | ||
"devDependencies": { | ||
"mocha": "^4.0.1", | ||
"should": "^13.1.3" | ||
"mocha": "^6.2.0", | ||
"should": "^13.2.3" | ||
} | ||
} |
@@ -19,2 +19,3 @@ { | ||
"backgroundColor": "#E2E2E2", | ||
"permalink": "https://app.smartsheet.com/dashboards/Qv1", | ||
"columnCount": 6, | ||
@@ -26,8 +27,9 @@ "widgets": [ | ||
"contents": { | ||
"type": "SHORTCUT", | ||
"shortcutData": [ | ||
{ | ||
"label": "Starbucks Stores By State", | ||
"labelFormat": ",2,,,,,1,,1,,,,,,,", | ||
"labelFormat": ",2,,,,,1,,1,,,,,,,,", | ||
"hyperlink": { | ||
"url": "https://app.smartsheet.com/b/home", | ||
"url": "https://app.smartsheet.com/sheets/r21", | ||
"sheetId": 500 | ||
@@ -46,3 +48,3 @@ }, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
@@ -54,2 +56,7 @@ }, | ||
"contents": { | ||
"type": "METRIC", | ||
"hyperlink": { | ||
"url": "http://www.seattle.gov/", | ||
"interactionType": "WEB" | ||
}, | ||
"cellData": [ | ||
@@ -59,7 +66,8 @@ { | ||
"label": "Millimetres", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 4, | ||
"cell": { | ||
"columnId": 236, | ||
"rowId": 284, | ||
"value": 958, | ||
@@ -69,2 +77,3 @@ "objectValue": 958, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 958 | ||
@@ -75,7 +84,8 @@ }, | ||
"label": "State", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 1, | ||
"cell": { | ||
"columnId": 492, | ||
"rowId": 284, | ||
"value": "Washington", | ||
@@ -85,2 +95,3 @@ "objectValue": "Washington", | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": "Washington" | ||
@@ -91,7 +102,8 @@ }, | ||
"label": "City", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 0, | ||
"cell": { | ||
"columnId": 612, | ||
"rowId": 284, | ||
"value": "Seattle", | ||
@@ -101,2 +113,3 @@ "objectValue": "Seattle", | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": "Seattle" | ||
@@ -107,7 +120,8 @@ }, | ||
"label": "Inches", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 3, | ||
"cell": { | ||
"columnId": 740, | ||
"rowId": 284, | ||
"value": 37.7, | ||
@@ -117,2 +131,3 @@ "objectValue": 37.7, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 37.7 | ||
@@ -123,7 +138,8 @@ }, | ||
"label": "Days", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 2, | ||
"cell": { | ||
"columnId": 988, | ||
"rowId": 284, | ||
"value": 149, | ||
@@ -133,2 +149,3 @@ "objectValue": 149, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 149 | ||
@@ -140,2 +157,3 @@ } | ||
"id": 612, | ||
"version": 0, | ||
"index": 0, | ||
@@ -150,2 +168,3 @@ "title": "City", | ||
"id": 492, | ||
"version": 0, | ||
"index": 1, | ||
@@ -159,2 +178,3 @@ "title": "State", | ||
"id": 988, | ||
"version": 0, | ||
"index": 2, | ||
@@ -168,2 +188,3 @@ "title": "Days", | ||
"id": 740, | ||
"version": 0, | ||
"index": 3, | ||
@@ -177,2 +198,3 @@ "title": "Inches", | ||
"id": 236, | ||
"version": 0, | ||
"index": 4, | ||
@@ -185,3 +207,3 @@ "title": "Millimetres", | ||
], | ||
"gridID": 10624640 | ||
"sheetId": 524 | ||
}, | ||
@@ -195,3 +217,3 @@ "xPosition": 1, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
@@ -203,2 +225,3 @@ }, | ||
"contents": { | ||
"type": "RICHTEXT", | ||
"htmlContent": "<p>This is a <span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">rich</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:italic;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">text </span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">test</span></p>" | ||
@@ -215,24 +238,13 @@ }, | ||
{ | ||
"id": 612, | ||
"type": "IMAGE", | ||
"contents": { | ||
"privateId": "TCA", | ||
"height": 18, | ||
"width": 18, | ||
"fileName": "info_tip_16x16.png", | ||
"format": ",7,1,,,,2,2,1,3,,,,,,1" | ||
}, | ||
"xPosition": 4, | ||
"yPosition": 1, | ||
"width": 1, | ||
"height": 4, | ||
"showTitleIcon": false, | ||
"showTitle": false, | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 108, | ||
"type": "GRIDGANTT", | ||
"contents": { | ||
"htmlContent": "<style type=\"text/css\">" | ||
"type": "GRIDGANTT", | ||
"hyperlink": { | ||
"url": "https://app.smartsheet.com/reports/J81", | ||
"reportId": 876, | ||
"interactionType": "SOURCE_SHEET" | ||
}, | ||
"htmlContent": "<style type=\"text/css\">", | ||
"reportId": 876 | ||
}, | ||
@@ -251,4 +263,5 @@ "xPosition": 0, | ||
"contents": { | ||
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\">This is my title</span></p>", | ||
"backgroundColor": "#F7F7F7" | ||
"type": "RICHTEXT", | ||
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:20pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 )\"></span><span class=\"clsDbFt\">This is my title</span></p>", | ||
"backgroundColor": "#D0AF8F" | ||
}, | ||
@@ -264,47 +277,551 @@ "xPosition": 0, | ||
{ | ||
"id": 852, | ||
"type": "SHEETSUMMARY", | ||
"id": 796, | ||
"type": "CHART", | ||
"contents": { | ||
"type": "CHART", | ||
"hyperlink": { | ||
"url": "http://www.somesite.com" | ||
"url": "https://app.smartsheet.com/sheets/9J1", | ||
"sheetId": 660, | ||
"interactionType": "SMARTSHEET_ITEM" | ||
}, | ||
"cellData": [ | ||
"series": [ | ||
{ | ||
"columnId": 788, | ||
"label": "Population (July 1, 2013)", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"order": 0, | ||
"cell": { | ||
"columnId": 788, | ||
"value": 6971406, | ||
"objectValue": 6971406, | ||
"displayValue": "6971406" | ||
"title": "Days", | ||
"titleInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"objectValue": 6971406 | ||
"seriesType": "COLUMN", | ||
"tooltips": { | ||
"labelType": "X-SERIES-Y" | ||
}, | ||
"color": "#1061C3", | ||
"axisLocationX": "BOTTOM", | ||
"axisLocationY": "LEFT", | ||
"yColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"xColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesData": [ | ||
{ | ||
"y": 113 | ||
}, | ||
{ | ||
"x": "Austin", | ||
"y": 88 | ||
}, | ||
{ | ||
"x": "Baltimore", | ||
"y": 116 | ||
}, | ||
{ | ||
"x": "Birmingham", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Boston", | ||
"y": 126 | ||
}, | ||
{ | ||
"x": "Buffalo", | ||
"y": 167 | ||
}, | ||
{ | ||
"x": "Charlotte", | ||
"y": 110 | ||
}, | ||
{ | ||
"x": "Chicago", | ||
"y": 124 | ||
}, | ||
{ | ||
"x": "Cincinnati", | ||
"y": 137 | ||
}, | ||
{ | ||
"x": "Cleveland", | ||
"y": 155 | ||
}, | ||
{ | ||
"x": "Columbus", | ||
"y": 139 | ||
}, | ||
{ | ||
"x": "Dallas", | ||
"y": 81 | ||
}, | ||
{ | ||
"x": "Denver", | ||
"y": 87 | ||
}, | ||
{ | ||
"x": "Detroit", | ||
"y": 135 | ||
}, | ||
{ | ||
"x": "Hartford", | ||
"y": 130 | ||
}, | ||
{ | ||
"x": "Houston", | ||
"y": 104 | ||
}, | ||
{ | ||
"x": "Indianapolis", | ||
"y": 129 | ||
}, | ||
{ | ||
"x": "Jacksonville", | ||
"y": 114 | ||
}, | ||
{ | ||
"x": "Kansas City", | ||
"y": 91 | ||
}, | ||
{ | ||
"x": "Las Vegas", | ||
"y": 27 | ||
}, | ||
{ | ||
"x": "Los Angeles", | ||
"y": 36 | ||
}, | ||
{ | ||
"x": "Louisville", | ||
"y": 123 | ||
}, | ||
{ | ||
"x": "Memphis", | ||
"y": 108 | ||
}, | ||
{ | ||
"x": "Miami", | ||
"y": 135 | ||
}, | ||
{ | ||
"x": "Milwaukee", | ||
"y": 127 | ||
}, | ||
{ | ||
"x": "Minneapolis", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Nashville", | ||
"y": 119 | ||
}, | ||
{ | ||
"x": "New Orleans", | ||
"y": 115 | ||
}, | ||
{ | ||
"x": "New York", | ||
"y": 122 | ||
}, | ||
{ | ||
"x": "Oklahoma City", | ||
"y": 84 | ||
}, | ||
{ | ||
"x": "Orlando", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Philadelphia", | ||
"y": 118 | ||
}, | ||
{ | ||
"x": "Phoenix", | ||
"y": 30 | ||
}, | ||
{ | ||
"x": "Pittsburgh", | ||
"y": 151 | ||
}, | ||
{ | ||
"x": "Portland", | ||
"y": 164 | ||
}, | ||
{ | ||
"x": "Providence", | ||
"y": 125 | ||
}, | ||
{ | ||
"x": "Raleigh", | ||
"y": 100 | ||
}, | ||
{ | ||
"x": "Richmond", | ||
"y": 114 | ||
}, | ||
{ | ||
"x": "Riverside", | ||
"y": 30 | ||
}, | ||
{ | ||
"x": "Rochester", | ||
"y": 167 | ||
}, | ||
{ | ||
"x": "Sacramento", | ||
"y": 60 | ||
}, | ||
{ | ||
"x": "Salt Lake City", | ||
"y": 96 | ||
}, | ||
{ | ||
"x": "San Antonio", | ||
"y": 83 | ||
}, | ||
{ | ||
"x": "San Diego", | ||
"y": 42 | ||
}, | ||
{ | ||
"x": "San Francisco", | ||
"y": 68 | ||
}, | ||
{ | ||
"x": "San Jose", | ||
"y": 62 | ||
}, | ||
{ | ||
"x": "Seattle", | ||
"y": 149 | ||
}, | ||
{ | ||
"x": "St. Louis", | ||
"y": 113 | ||
}, | ||
{ | ||
"x": "Tampa", | ||
"y": 105 | ||
}, | ||
{ | ||
"x": "Virginia Beach", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Washington", | ||
"y": 114 | ||
} | ||
], | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 988, | ||
"sourceColumnId2": 988 | ||
} | ||
] | ||
}, | ||
{ | ||
"title": "Inches", | ||
"titleInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesType": "COLUMN", | ||
"tooltips": { | ||
"labelType": "X-SERIES-Y" | ||
}, | ||
"color": "#EA352E", | ||
"axisLocationX": "BOTTOM", | ||
"axisLocationY": "LEFT", | ||
"yColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"xColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesData": [ | ||
{ | ||
"y": 49.7 | ||
}, | ||
{ | ||
"x": "Austin", | ||
"y": 34.2 | ||
}, | ||
{ | ||
"x": "Baltimore", | ||
"y": 41.9 | ||
}, | ||
{ | ||
"x": "Birmingham", | ||
"y": 53.7 | ||
}, | ||
{ | ||
"x": "Boston", | ||
"y": 43.8 | ||
}, | ||
{ | ||
"x": "Buffalo", | ||
"y": 40.5 | ||
}, | ||
{ | ||
"x": "Charlotte", | ||
"y": 41.6 | ||
}, | ||
{ | ||
"x": "Chicago", | ||
"y": 36.9 | ||
}, | ||
{ | ||
"x": "Cincinnati", | ||
"y": 41.9 | ||
}, | ||
{ | ||
"x": "Cleveland", | ||
"y": 39.1 | ||
}, | ||
{ | ||
"x": "Columbus", | ||
"y": 39.3 | ||
}, | ||
{ | ||
"x": "Dallas", | ||
"y": 37.6 | ||
}, | ||
{ | ||
"x": "Denver", | ||
"y": 15.6 | ||
}, | ||
{ | ||
"x": "Detroit", | ||
"y": 33.5 | ||
}, | ||
{ | ||
"x": "Hartford", | ||
"y": 45.9 | ||
}, | ||
{ | ||
"x": "Houston", | ||
"y": 49.8 | ||
}, | ||
{ | ||
"x": "Indianapolis", | ||
"y": 42.4 | ||
}, | ||
{ | ||
"x": "Jacksonville", | ||
"y": 52.4 | ||
}, | ||
{ | ||
"x": "Kansas City", | ||
"y": 39.1 | ||
}, | ||
{ | ||
"x": "Las Vegas", | ||
"y": 4.2 | ||
}, | ||
{ | ||
"x": "Los Angeles", | ||
"y": 12.8 | ||
}, | ||
{ | ||
"x": "Louisville", | ||
"y": 44.9 | ||
}, | ||
{ | ||
"x": "Memphis", | ||
"y": 53.7 | ||
}, | ||
{ | ||
"x": "Miami", | ||
"y": 61.9 | ||
}, | ||
{ | ||
"x": "Milwaukee", | ||
"y": 34.8 | ||
}, | ||
{ | ||
"x": "Minneapolis", | ||
"y": 30.6 | ||
}, | ||
{ | ||
"x": "Nashville", | ||
"y": 47.3 | ||
}, | ||
{ | ||
"x": "New Orleans", | ||
"y": 62.7 | ||
}, | ||
{ | ||
"x": "New York", | ||
"y": 49.9 | ||
}, | ||
{ | ||
"x": "Oklahoma City", | ||
"y": 36.5 | ||
}, | ||
{ | ||
"x": "Orlando", | ||
"y": 50.7 | ||
}, | ||
{ | ||
"x": "Philadelphia", | ||
"y": 41.5 | ||
}, | ||
{ | ||
"x": "Phoenix", | ||
"y": 8.2 | ||
}, | ||
{ | ||
"x": "Pittsburgh", | ||
"y": 38.2 | ||
}, | ||
{ | ||
"x": "Portland", | ||
"y": 43.5 | ||
}, | ||
{ | ||
"x": "Providence", | ||
"y": 47.2 | ||
}, | ||
{ | ||
"x": "Raleigh", | ||
"y": 46 | ||
}, | ||
{ | ||
"x": "Richmond", | ||
"y": 43.6 | ||
}, | ||
{ | ||
"x": "Riverside", | ||
"y": 10.3 | ||
}, | ||
{ | ||
"x": "Rochester", | ||
"y": 34.3 | ||
}, | ||
{ | ||
"x": "Sacramento", | ||
"y": 18.5 | ||
}, | ||
{ | ||
"x": "Salt Lake City", | ||
"y": 16.1 | ||
}, | ||
{ | ||
"x": "San Antonio", | ||
"y": 32.3 | ||
}, | ||
{ | ||
"x": "San Diego", | ||
"y": 10.3 | ||
}, | ||
{ | ||
"x": "San Francisco", | ||
"y": 20.7 | ||
}, | ||
{ | ||
"x": "San Jose", | ||
"y": 15.8 | ||
}, | ||
{ | ||
"x": "Seattle", | ||
"y": 37.7 | ||
}, | ||
{ | ||
"x": "St. Louis", | ||
"y": 41 | ||
}, | ||
{ | ||
"x": "Tampa", | ||
"y": 46.3 | ||
}, | ||
{ | ||
"x": "Virginia Beach", | ||
"y": 46.5 | ||
}, | ||
{ | ||
"x": "Washington", | ||
"y": 39.7 | ||
} | ||
], | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 740, | ||
"sourceColumnId2": 740 | ||
} | ||
] | ||
} | ||
], | ||
"columns": [ | ||
"axes": [ | ||
{ | ||
"id": 788, | ||
"index": 2, | ||
"title": "Population (July 1, 2013)", | ||
"type": "TEXT_NUMBER", | ||
"validation": false, | ||
"width": 150 | ||
"location": "LEFT", | ||
"includeZero": true | ||
}, | ||
{ | ||
"location": "BOTTOM" | ||
} | ||
], | ||
"gridID": 10624332 | ||
"legend": { | ||
"location": "RIGHT" | ||
}, | ||
"sheetId": 524, | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 612, | ||
"sourceColumnId2": 740 | ||
} | ||
] | ||
}, | ||
"xPosition": 0, | ||
"yPosition": 11, | ||
"width": 4, | ||
"height": 6, | ||
"title": "Annual Averages for Total Precipitation By City", | ||
"showTitleIcon": false, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 932, | ||
"type": "IMAGE", | ||
"contents": { | ||
"type": "IMAGE", | ||
"hyperlink": { | ||
"url": "http://www.smartsheet.com", | ||
"interactionType": "WEB" | ||
}, | ||
"privateId": "_kpnN9Q", | ||
"height": 48, | ||
"width": 197, | ||
"fileName": "smartsheet-logo-blue-197x48.png", | ||
"format": ",7,1,,,,2,2,1,3,,,,,,1," | ||
}, | ||
"xPosition": 4, | ||
"yPosition": 5, | ||
"yPosition": 1, | ||
"width": 1, | ||
"height": 2, | ||
"title": "Starbucks Stores By State", | ||
"showTitleIcon": true, | ||
"height": 4, | ||
"showTitleIcon": false, | ||
"showTitle": false, | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 636, | ||
"type": "WEBCONTENT", | ||
"contents": { | ||
"type": "WidgetWebContent", | ||
"url": "https://www.youtube.com/" | ||
}, | ||
"xPosition": 0, | ||
"yPosition": 17, | ||
"width": 4, | ||
"height": 6, | ||
"showTitleIcon": false, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
} | ||
] | ||
], | ||
"createdAt": "2016-08-14T23:45:06Z", | ||
"modifiedAt": "2019-07-12T22:25:42Z" | ||
}, | ||
@@ -311,0 +828,0 @@ "headers": { |
@@ -32,14 +32,16 @@ { | ||
"backgroundColor": "#E2E2E2", | ||
"permalink": "https://app.smartsheet.com/dashboards/PP1", | ||
"columnCount": 6, | ||
"widgets": [ | ||
{ | ||
"id": 556, | ||
"id": 532, | ||
"type": "SHORTCUTLIST", | ||
"contents": { | ||
"type": "SHORTCUT", | ||
"shortcutData": [ | ||
{ | ||
"label": "Starbucks Stores By State", | ||
"labelFormat": ",2,,,,,1,,1,,,,,,,", | ||
"labelFormat": ",2,,,,,1,,1,,,,,,,,", | ||
"hyperlink": { | ||
"url": "https://app.smartsheet.com/b/home", | ||
"url": "https://app.smartsheet.com/sheets/r21", | ||
"sheetId": 500 | ||
@@ -58,9 +60,14 @@ }, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 500, | ||
"id": 28, | ||
"type": "SHEETSUMMARY", | ||
"contents": { | ||
"type": "METRIC", | ||
"hyperlink": { | ||
"url": "http://www.seattle.gov/", | ||
"interactionType": "WEB" | ||
}, | ||
"cellData": [ | ||
@@ -70,7 +77,8 @@ { | ||
"label": "Millimetres", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 4, | ||
"cell": { | ||
"columnId": 236, | ||
"rowId": 284, | ||
"value": 958, | ||
@@ -80,2 +88,3 @@ "objectValue": 958, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 958 | ||
@@ -86,7 +95,8 @@ }, | ||
"label": "State", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 1, | ||
"cell": { | ||
"columnId": 492, | ||
"rowId": 284, | ||
"value": "Washington", | ||
@@ -96,2 +106,3 @@ "objectValue": "Washington", | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": "Washington" | ||
@@ -102,7 +113,8 @@ }, | ||
"label": "City", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 0, | ||
"cell": { | ||
"columnId": 612, | ||
"rowId": 284, | ||
"value": "Seattle", | ||
@@ -112,2 +124,3 @@ "objectValue": "Seattle", | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": "Seattle" | ||
@@ -118,7 +131,8 @@ }, | ||
"label": "Inches", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 3, | ||
"cell": { | ||
"columnId": 740, | ||
"rowId": 284, | ||
"value": 37.7, | ||
@@ -128,2 +142,3 @@ "objectValue": 37.7, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 37.7 | ||
@@ -134,7 +149,8 @@ }, | ||
"label": "Days", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1,", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1,", | ||
"order": 2, | ||
"cell": { | ||
"columnId": 988, | ||
"rowId": 284, | ||
"value": 149, | ||
@@ -144,2 +160,3 @@ "objectValue": 149, | ||
}, | ||
"dataSource": "CELL", | ||
"objectValue": 149 | ||
@@ -151,2 +168,3 @@ } | ||
"id": 612, | ||
"version": 0, | ||
"index": 0, | ||
@@ -161,2 +179,3 @@ "title": "City", | ||
"id": 492, | ||
"version": 0, | ||
"index": 1, | ||
@@ -170,2 +189,3 @@ "title": "State", | ||
"id": 988, | ||
"version": 0, | ||
"index": 2, | ||
@@ -179,2 +199,3 @@ "title": "Days", | ||
"id": 740, | ||
"version": 0, | ||
"index": 3, | ||
@@ -188,2 +209,3 @@ "title": "Inches", | ||
"id": 236, | ||
"version": 0, | ||
"index": 4, | ||
@@ -196,3 +218,3 @@ "title": "Millimetres", | ||
], | ||
"gridID": 10624640 | ||
"sheetId": 524 | ||
}, | ||
@@ -206,9 +228,10 @@ "xPosition": 1, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 5371172654212996, | ||
"id": 20, | ||
"type": "RICHTEXT", | ||
"contents": { | ||
"type": "RICHTEXT", | ||
"htmlContent": "<p>This is a <span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">rich</span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:italic;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">text </span><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:10pt;font-weight:normal;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 );background-color:rgb( 255 , 255 , 255 )\">test</span></p>" | ||
@@ -225,24 +248,13 @@ }, | ||
{ | ||
"id": 748, | ||
"type": "IMAGE", | ||
"contents": { | ||
"privateId": "TCA", | ||
"height": 18, | ||
"width": 18, | ||
"fileName": "info_tip_16x16.png", | ||
"format": ",7,1,,,,2,2,1,3,,,,,,1" | ||
}, | ||
"xPosition": 4, | ||
"yPosition": 1, | ||
"width": 1, | ||
"height": 4, | ||
"showTitleIcon": false, | ||
"showTitle": false, | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 244, | ||
"id": 516, | ||
"type": "GRIDGANTT", | ||
"contents": { | ||
"htmlContent": "<style type=\"text/css\">" | ||
"type": "GRIDGANTT", | ||
"hyperlink": { | ||
"url": "https://app.smartsheet.com/reports/J81", | ||
"reportId": 876, | ||
"interactionType": "SOURCE_SHEET" | ||
}, | ||
"htmlContent": "<style type=\"text/css\">", | ||
"reportId": 876 | ||
}, | ||
@@ -258,7 +270,8 @@ "xPosition": 0, | ||
{ | ||
"id": 124, | ||
"id": 268, | ||
"type": "TITLE", | ||
"contents": { | ||
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\">This is my title</span></p>", | ||
"backgroundColor": "#F7F7F7" | ||
"type": "RICHTEXT", | ||
"htmlContent": "<p style=\"text-align:center\"><span class=\"clsDbFt\" style=\"font-family:'arial';font-size:20pt;font-weight:bold;font-style:normal;text-decoration:none;color:rgb( 0 , 0 , 0 )\"></span><span class=\"clsDbFt\">This is my title</span></p>", | ||
"backgroundColor": "#D0AF8F" | ||
}, | ||
@@ -274,47 +287,551 @@ "xPosition": 0, | ||
{ | ||
"id": 620, | ||
"type": "SHEETSUMMARY", | ||
"id": 764, | ||
"type": "CHART", | ||
"contents": { | ||
"type": "CHART", | ||
"hyperlink": { | ||
"url": "http://www.somesite.com" | ||
"url": "https://app.smartsheet.com/sheets/9J1", | ||
"sheetId": 660, | ||
"interactionType": "SMARTSHEET_ITEM" | ||
}, | ||
"cellData": [ | ||
"series": [ | ||
{ | ||
"columnId": 788, | ||
"label": "Population (July 1, 2013)", | ||
"labelFormat": ",2,,,,,,,1,,,,,,,1", | ||
"valueFormat": ",2,1,,,,1,,1,3,,,,,,1", | ||
"order": 0, | ||
"cell": { | ||
"columnId": 788, | ||
"value": 6971406, | ||
"objectValue": 6971406, | ||
"displayValue": "6971406" | ||
"title": "Days", | ||
"titleInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"objectValue": 6971406 | ||
"seriesType": "COLUMN", | ||
"tooltips": { | ||
"labelType": "X-SERIES-Y" | ||
}, | ||
"color": "#1061C3", | ||
"axisLocationX": "BOTTOM", | ||
"axisLocationY": "LEFT", | ||
"yColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"xColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesData": [ | ||
{ | ||
"y": 113 | ||
}, | ||
{ | ||
"x": "Austin", | ||
"y": 88 | ||
}, | ||
{ | ||
"x": "Baltimore", | ||
"y": 116 | ||
}, | ||
{ | ||
"x": "Birmingham", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Boston", | ||
"y": 126 | ||
}, | ||
{ | ||
"x": "Buffalo", | ||
"y": 167 | ||
}, | ||
{ | ||
"x": "Charlotte", | ||
"y": 110 | ||
}, | ||
{ | ||
"x": "Chicago", | ||
"y": 124 | ||
}, | ||
{ | ||
"x": "Cincinnati", | ||
"y": 137 | ||
}, | ||
{ | ||
"x": "Cleveland", | ||
"y": 155 | ||
}, | ||
{ | ||
"x": "Columbus", | ||
"y": 139 | ||
}, | ||
{ | ||
"x": "Dallas", | ||
"y": 81 | ||
}, | ||
{ | ||
"x": "Denver", | ||
"y": 87 | ||
}, | ||
{ | ||
"x": "Detroit", | ||
"y": 135 | ||
}, | ||
{ | ||
"x": "Hartford", | ||
"y": 130 | ||
}, | ||
{ | ||
"x": "Houston", | ||
"y": 104 | ||
}, | ||
{ | ||
"x": "Indianapolis", | ||
"y": 129 | ||
}, | ||
{ | ||
"x": "Jacksonville", | ||
"y": 114 | ||
}, | ||
{ | ||
"x": "Kansas City", | ||
"y": 91 | ||
}, | ||
{ | ||
"x": "Las Vegas", | ||
"y": 27 | ||
}, | ||
{ | ||
"x": "Los Angeles", | ||
"y": 36 | ||
}, | ||
{ | ||
"x": "Louisville", | ||
"y": 123 | ||
}, | ||
{ | ||
"x": "Memphis", | ||
"y": 108 | ||
}, | ||
{ | ||
"x": "Miami", | ||
"y": 135 | ||
}, | ||
{ | ||
"x": "Milwaukee", | ||
"y": 127 | ||
}, | ||
{ | ||
"x": "Minneapolis", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Nashville", | ||
"y": 119 | ||
}, | ||
{ | ||
"x": "New Orleans", | ||
"y": 115 | ||
}, | ||
{ | ||
"x": "New York", | ||
"y": 122 | ||
}, | ||
{ | ||
"x": "Oklahoma City", | ||
"y": 84 | ||
}, | ||
{ | ||
"x": "Orlando", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Philadelphia", | ||
"y": 118 | ||
}, | ||
{ | ||
"x": "Phoenix", | ||
"y": 30 | ||
}, | ||
{ | ||
"x": "Pittsburgh", | ||
"y": 151 | ||
}, | ||
{ | ||
"x": "Portland", | ||
"y": 164 | ||
}, | ||
{ | ||
"x": "Providence", | ||
"y": 125 | ||
}, | ||
{ | ||
"x": "Raleigh", | ||
"y": 100 | ||
}, | ||
{ | ||
"x": "Richmond", | ||
"y": 114 | ||
}, | ||
{ | ||
"x": "Riverside", | ||
"y": 30 | ||
}, | ||
{ | ||
"x": "Rochester", | ||
"y": 167 | ||
}, | ||
{ | ||
"x": "Sacramento", | ||
"y": 60 | ||
}, | ||
{ | ||
"x": "Salt Lake City", | ||
"y": 96 | ||
}, | ||
{ | ||
"x": "San Antonio", | ||
"y": 83 | ||
}, | ||
{ | ||
"x": "San Diego", | ||
"y": 42 | ||
}, | ||
{ | ||
"x": "San Francisco", | ||
"y": 68 | ||
}, | ||
{ | ||
"x": "San Jose", | ||
"y": 62 | ||
}, | ||
{ | ||
"x": "Seattle", | ||
"y": 149 | ||
}, | ||
{ | ||
"x": "St. Louis", | ||
"y": 113 | ||
}, | ||
{ | ||
"x": "Tampa", | ||
"y": 105 | ||
}, | ||
{ | ||
"x": "Virginia Beach", | ||
"y": 117 | ||
}, | ||
{ | ||
"x": "Washington", | ||
"y": 114 | ||
} | ||
], | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 988, | ||
"sourceColumnId2": 988 | ||
} | ||
] | ||
}, | ||
{ | ||
"title": "Inches", | ||
"titleInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesType": "COLUMN", | ||
"tooltips": { | ||
"labelType": "X-SERIES-Y" | ||
}, | ||
"color": "#EA352E", | ||
"axisLocationX": "BOTTOM", | ||
"axisLocationY": "LEFT", | ||
"yColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"xColumnInfo": { | ||
"type": "TEXT_NUMBER" | ||
}, | ||
"seriesData": [ | ||
{ | ||
"y": 49.7 | ||
}, | ||
{ | ||
"x": "Austin", | ||
"y": 34.2 | ||
}, | ||
{ | ||
"x": "Baltimore", | ||
"y": 41.9 | ||
}, | ||
{ | ||
"x": "Birmingham", | ||
"y": 53.7 | ||
}, | ||
{ | ||
"x": "Boston", | ||
"y": 43.8 | ||
}, | ||
{ | ||
"x": "Buffalo", | ||
"y": 40.5 | ||
}, | ||
{ | ||
"x": "Charlotte", | ||
"y": 41.6 | ||
}, | ||
{ | ||
"x": "Chicago", | ||
"y": 36.9 | ||
}, | ||
{ | ||
"x": "Cincinnati", | ||
"y": 41.9 | ||
}, | ||
{ | ||
"x": "Cleveland", | ||
"y": 39.1 | ||
}, | ||
{ | ||
"x": "Columbus", | ||
"y": 39.3 | ||
}, | ||
{ | ||
"x": "Dallas", | ||
"y": 37.6 | ||
}, | ||
{ | ||
"x": "Denver", | ||
"y": 15.6 | ||
}, | ||
{ | ||
"x": "Detroit", | ||
"y": 33.5 | ||
}, | ||
{ | ||
"x": "Hartford", | ||
"y": 45.9 | ||
}, | ||
{ | ||
"x": "Houston", | ||
"y": 49.8 | ||
}, | ||
{ | ||
"x": "Indianapolis", | ||
"y": 42.4 | ||
}, | ||
{ | ||
"x": "Jacksonville", | ||
"y": 52.4 | ||
}, | ||
{ | ||
"x": "Kansas City", | ||
"y": 39.1 | ||
}, | ||
{ | ||
"x": "Las Vegas", | ||
"y": 4.2 | ||
}, | ||
{ | ||
"x": "Los Angeles", | ||
"y": 12.8 | ||
}, | ||
{ | ||
"x": "Louisville", | ||
"y": 44.9 | ||
}, | ||
{ | ||
"x": "Memphis", | ||
"y": 53.7 | ||
}, | ||
{ | ||
"x": "Miami", | ||
"y": 61.9 | ||
}, | ||
{ | ||
"x": "Milwaukee", | ||
"y": 34.8 | ||
}, | ||
{ | ||
"x": "Minneapolis", | ||
"y": 30.6 | ||
}, | ||
{ | ||
"x": "Nashville", | ||
"y": 47.3 | ||
}, | ||
{ | ||
"x": "New Orleans", | ||
"y": 62.7 | ||
}, | ||
{ | ||
"x": "New York", | ||
"y": 49.9 | ||
}, | ||
{ | ||
"x": "Oklahoma City", | ||
"y": 36.5 | ||
}, | ||
{ | ||
"x": "Orlando", | ||
"y": 50.7 | ||
}, | ||
{ | ||
"x": "Philadelphia", | ||
"y": 41.5 | ||
}, | ||
{ | ||
"x": "Phoenix", | ||
"y": 8.2 | ||
}, | ||
{ | ||
"x": "Pittsburgh", | ||
"y": 38.2 | ||
}, | ||
{ | ||
"x": "Portland", | ||
"y": 43.5 | ||
}, | ||
{ | ||
"x": "Providence", | ||
"y": 47.2 | ||
}, | ||
{ | ||
"x": "Raleigh", | ||
"y": 46 | ||
}, | ||
{ | ||
"x": "Richmond", | ||
"y": 43.6 | ||
}, | ||
{ | ||
"x": "Riverside", | ||
"y": 10.3 | ||
}, | ||
{ | ||
"x": "Rochester", | ||
"y": 34.3 | ||
}, | ||
{ | ||
"x": "Sacramento", | ||
"y": 18.5 | ||
}, | ||
{ | ||
"x": "Salt Lake City", | ||
"y": 16.1 | ||
}, | ||
{ | ||
"x": "San Antonio", | ||
"y": 32.3 | ||
}, | ||
{ | ||
"x": "San Diego", | ||
"y": 10.3 | ||
}, | ||
{ | ||
"x": "San Francisco", | ||
"y": 20.7 | ||
}, | ||
{ | ||
"x": "San Jose", | ||
"y": 15.8 | ||
}, | ||
{ | ||
"x": "Seattle", | ||
"y": 37.7 | ||
}, | ||
{ | ||
"x": "St. Louis", | ||
"y": 41 | ||
}, | ||
{ | ||
"x": "Tampa", | ||
"y": 46.3 | ||
}, | ||
{ | ||
"x": "Virginia Beach", | ||
"y": 46.5 | ||
}, | ||
{ | ||
"x": "Washington", | ||
"y": 39.7 | ||
} | ||
], | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 740, | ||
"sourceColumnId2": 740 | ||
} | ||
] | ||
} | ||
], | ||
"columns": [ | ||
"axes": [ | ||
{ | ||
"id": 788, | ||
"index": 2, | ||
"title": "Population (July 1, 2013)", | ||
"type": "TEXT_NUMBER", | ||
"validation": false, | ||
"width": 150 | ||
"location": "LEFT", | ||
"includeZero": true | ||
}, | ||
{ | ||
"location": "BOTTOM" | ||
} | ||
], | ||
"gridID": 10624332 | ||
"legend": { | ||
"location": "RIGHT" | ||
}, | ||
"sheetId": 524, | ||
"selectionRanges": [ | ||
{ | ||
"sourceRowId1": 292, | ||
"sourceRowId2": 908, | ||
"sourceColumnId1": 612, | ||
"sourceColumnId2": 740 | ||
} | ||
] | ||
}, | ||
"xPosition": 0, | ||
"yPosition": 11, | ||
"width": 4, | ||
"height": 6, | ||
"title": "Annual Averages for Total Precipitation By City", | ||
"showTitleIcon": false, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 644, | ||
"type": "IMAGE", | ||
"contents": { | ||
"type": "IMAGE", | ||
"hyperlink": { | ||
"url": "http://www.smartsheet.com", | ||
"interactionType": "WEB" | ||
}, | ||
"privateId": "Jppz", | ||
"height": 48, | ||
"width": 197, | ||
"fileName": "smartsheet-logo-blue-197x48.png", | ||
"format": ",7,1,,,,2,2,1,3,,,,,,1," | ||
}, | ||
"xPosition": 4, | ||
"yPosition": 5, | ||
"yPosition": 1, | ||
"width": 1, | ||
"height": 2, | ||
"title": "Starbucks Stores By State", | ||
"showTitleIcon": true, | ||
"height": 4, | ||
"showTitleIcon": false, | ||
"showTitle": false, | ||
"version": 1 | ||
}, | ||
{ | ||
"id": 140, | ||
"type": "WEBCONTENT", | ||
"contents": { | ||
"type": "WidgetWebContent", | ||
"url": "https://www.youtube.com/" | ||
}, | ||
"xPosition": 0, | ||
"yPosition": 17, | ||
"width": 4, | ||
"height": 6, | ||
"showTitleIcon": false, | ||
"showTitle": true, | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1", | ||
"titleFormat": ",,1,,,,,,,3,,,,,,1,", | ||
"version": 1 | ||
} | ||
] | ||
], | ||
"createdAt": "2019-08-07T20:12:02Z", | ||
"modifiedAt": "2019-08-07T20:12:02Z" | ||
} | ||
@@ -321,0 +838,0 @@ }, |
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is too big to display
Sorry, the diff of this file is too big to display
Major refactor
Supply chain riskPackage has recently undergone a major refactor. It may be unstable or indicate significant internal changes. Use caution when updating to versions that include significant changes.
Found 1 instance in 1 package
14007178
21553
244
0