| Index: generated/googleapis/lib/sheets/v4.dart
|
| diff --git a/generated/googleapis/lib/sheets/v4.dart b/generated/googleapis/lib/sheets/v4.dart
|
| index bcc302ff24f23fcb73ce14b5d7579107189b5061..fa6b28b1312677bec7005bd16a55277b863a1689 100644
|
| --- a/generated/googleapis/lib/sheets/v4.dart
|
| +++ b/generated/googleapis/lib/sheets/v4.dart
|
| @@ -311,6 +311,11 @@ class SpreadsheetsValuesResourceApi {
|
| * [range] - The A1 notation of a range to search for a logical table of data.
|
| * Values will be appended after the last row of the table.
|
| *
|
| + * [includeValuesInResponse] - Determines if the update response should
|
| + * include the values
|
| + * of the cells that were appended. By default, responses
|
| + * do not include the updated values.
|
| + *
|
| * [responseValueRenderOption] - Determines how values in the response should
|
| * be rendered.
|
| * The default render option is ValueRenderOption.FORMATTED_VALUE.
|
| @@ -319,6 +324,11 @@ class SpreadsheetsValuesResourceApi {
|
| * - "UNFORMATTED_VALUE" : A UNFORMATTED_VALUE.
|
| * - "FORMULA" : A FORMULA.
|
| *
|
| + * [insertDataOption] - How the input data should be inserted.
|
| + * Possible string values are:
|
| + * - "OVERWRITE" : A OVERWRITE.
|
| + * - "INSERT_ROWS" : A INSERT_ROWS.
|
| + *
|
| * [valueInputOption] - How the input data should be interpreted.
|
| * Possible string values are:
|
| * - "INPUT_VALUE_OPTION_UNSPECIFIED" : A INPUT_VALUE_OPTION_UNSPECIFIED.
|
| @@ -334,16 +344,6 @@ class SpreadsheetsValuesResourceApi {
|
| * - "SERIAL_NUMBER" : A SERIAL_NUMBER.
|
| * - "FORMATTED_STRING" : A FORMATTED_STRING.
|
| *
|
| - * [includeValuesInResponse] - Determines if the update response should
|
| - * include the values
|
| - * of the cells that were appended. By default, responses
|
| - * do not include the updated values.
|
| - *
|
| - * [insertDataOption] - How the input data should be inserted.
|
| - * Possible string values are:
|
| - * - "OVERWRITE" : A OVERWRITE.
|
| - * - "INSERT_ROWS" : A INSERT_ROWS.
|
| - *
|
| * Completes with a [AppendValuesResponse].
|
| *
|
| * Completes with a [commons.ApiRequestError] if the API endpoint returned an
|
| @@ -352,7 +352,7 @@ class SpreadsheetsValuesResourceApi {
|
| * If the used [http.Client] completes with an error when making a REST call,
|
| * this method will complete with the same error.
|
| */
|
| - async.Future<AppendValuesResponse> append(ValueRange request, core.String spreadsheetId, core.String range, {core.String responseValueRenderOption, core.String valueInputOption, core.String responseDateTimeRenderOption, core.bool includeValuesInResponse, core.String insertDataOption}) {
|
| + async.Future<AppendValuesResponse> append(ValueRange request, core.String spreadsheetId, core.String range, {core.bool includeValuesInResponse, core.String responseValueRenderOption, core.String insertDataOption, core.String valueInputOption, core.String responseDateTimeRenderOption}) {
|
| var _url = null;
|
| var _queryParams = new core.Map();
|
| var _uploadMedia = null;
|
| @@ -369,21 +369,21 @@ class SpreadsheetsValuesResourceApi {
|
| if (range == null) {
|
| throw new core.ArgumentError("Parameter range is required.");
|
| }
|
| + if (includeValuesInResponse != null) {
|
| + _queryParams["includeValuesInResponse"] = ["${includeValuesInResponse}"];
|
| + }
|
| if (responseValueRenderOption != null) {
|
| _queryParams["responseValueRenderOption"] = [responseValueRenderOption];
|
| }
|
| + if (insertDataOption != null) {
|
| + _queryParams["insertDataOption"] = [insertDataOption];
|
| + }
|
| if (valueInputOption != null) {
|
| _queryParams["valueInputOption"] = [valueInputOption];
|
| }
|
| if (responseDateTimeRenderOption != null) {
|
| _queryParams["responseDateTimeRenderOption"] = [responseDateTimeRenderOption];
|
| }
|
| - if (includeValuesInResponse != null) {
|
| - _queryParams["includeValuesInResponse"] = ["${includeValuesInResponse}"];
|
| - }
|
| - if (insertDataOption != null) {
|
| - _queryParams["insertDataOption"] = [insertDataOption];
|
| - }
|
|
|
| _url = 'v4/spreadsheets/' + commons.Escaper.ecapeVariable('$spreadsheetId') + '/values/' + commons.Escaper.ecapeVariable('$range') + ':append';
|
|
|
| @@ -452,8 +452,6 @@ class SpreadsheetsValuesResourceApi {
|
| *
|
| * [spreadsheetId] - The ID of the spreadsheet to retrieve data from.
|
| *
|
| - * [ranges] - The A1 notation of the values to retrieve.
|
| - *
|
| * [valueRenderOption] - How values should be represented in the output.
|
| * The default render option is ValueRenderOption.FORMATTED_VALUE.
|
| * Possible string values are:
|
| @@ -470,6 +468,8 @@ class SpreadsheetsValuesResourceApi {
|
| * - "SERIAL_NUMBER" : A SERIAL_NUMBER.
|
| * - "FORMATTED_STRING" : A FORMATTED_STRING.
|
| *
|
| + * [ranges] - The A1 notation of the values to retrieve.
|
| + *
|
| * [majorDimension] - The major dimension that results should use.
|
| *
|
| * For example, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`,
|
| @@ -490,7 +490,7 @@ class SpreadsheetsValuesResourceApi {
|
| * If the used [http.Client] completes with an error when making a REST call,
|
| * this method will complete with the same error.
|
| */
|
| - async.Future<BatchGetValuesResponse> batchGet(core.String spreadsheetId, {core.List<core.String> ranges, core.String valueRenderOption, core.String dateTimeRenderOption, core.String majorDimension}) {
|
| + async.Future<BatchGetValuesResponse> batchGet(core.String spreadsheetId, {core.String valueRenderOption, core.String dateTimeRenderOption, core.List<core.String> ranges, core.String majorDimension}) {
|
| var _url = null;
|
| var _queryParams = new core.Map();
|
| var _uploadMedia = null;
|
| @@ -501,15 +501,15 @@ class SpreadsheetsValuesResourceApi {
|
| if (spreadsheetId == null) {
|
| throw new core.ArgumentError("Parameter spreadsheetId is required.");
|
| }
|
| - if (ranges != null) {
|
| - _queryParams["ranges"] = ranges;
|
| - }
|
| if (valueRenderOption != null) {
|
| _queryParams["valueRenderOption"] = [valueRenderOption];
|
| }
|
| if (dateTimeRenderOption != null) {
|
| _queryParams["dateTimeRenderOption"] = [dateTimeRenderOption];
|
| }
|
| + if (ranges != null) {
|
| + _queryParams["ranges"] = ranges;
|
| + }
|
| if (majorDimension != null) {
|
| _queryParams["majorDimension"] = [majorDimension];
|
| }
|
| @@ -720,14 +720,6 @@ class SpreadsheetsValuesResourceApi {
|
| *
|
| * [range] - The A1 notation of the values to update.
|
| *
|
| - * [responseValueRenderOption] - Determines how values in the response should
|
| - * be rendered.
|
| - * The default render option is ValueRenderOption.FORMATTED_VALUE.
|
| - * Possible string values are:
|
| - * - "FORMATTED_VALUE" : A FORMATTED_VALUE.
|
| - * - "UNFORMATTED_VALUE" : A UNFORMATTED_VALUE.
|
| - * - "FORMULA" : A FORMULA.
|
| - *
|
| * [valueInputOption] - How the input data should be interpreted.
|
| * Possible string values are:
|
| * - "INPUT_VALUE_OPTION_UNSPECIFIED" : A INPUT_VALUE_OPTION_UNSPECIFIED.
|
| @@ -751,6 +743,14 @@ class SpreadsheetsValuesResourceApi {
|
| * the response will include all values in the requested range (excluding
|
| * trailing empty rows and columns).
|
| *
|
| + * [responseValueRenderOption] - Determines how values in the response should
|
| + * be rendered.
|
| + * The default render option is ValueRenderOption.FORMATTED_VALUE.
|
| + * Possible string values are:
|
| + * - "FORMATTED_VALUE" : A FORMATTED_VALUE.
|
| + * - "UNFORMATTED_VALUE" : A UNFORMATTED_VALUE.
|
| + * - "FORMULA" : A FORMULA.
|
| + *
|
| * Completes with a [UpdateValuesResponse].
|
| *
|
| * Completes with a [commons.ApiRequestError] if the API endpoint returned an
|
| @@ -759,7 +759,7 @@ class SpreadsheetsValuesResourceApi {
|
| * If the used [http.Client] completes with an error when making a REST call,
|
| * this method will complete with the same error.
|
| */
|
| - async.Future<UpdateValuesResponse> update(ValueRange request, core.String spreadsheetId, core.String range, {core.String responseValueRenderOption, core.String valueInputOption, core.String responseDateTimeRenderOption, core.bool includeValuesInResponse}) {
|
| + async.Future<UpdateValuesResponse> update(ValueRange request, core.String spreadsheetId, core.String range, {core.String valueInputOption, core.String responseDateTimeRenderOption, core.bool includeValuesInResponse, core.String responseValueRenderOption}) {
|
| var _url = null;
|
| var _queryParams = new core.Map();
|
| var _uploadMedia = null;
|
| @@ -776,9 +776,6 @@ class SpreadsheetsValuesResourceApi {
|
| if (range == null) {
|
| throw new core.ArgumentError("Parameter range is required.");
|
| }
|
| - if (responseValueRenderOption != null) {
|
| - _queryParams["responseValueRenderOption"] = [responseValueRenderOption];
|
| - }
|
| if (valueInputOption != null) {
|
| _queryParams["valueInputOption"] = [valueInputOption];
|
| }
|
| @@ -788,6 +785,9 @@ class SpreadsheetsValuesResourceApi {
|
| if (includeValuesInResponse != null) {
|
| _queryParams["includeValuesInResponse"] = ["${includeValuesInResponse}"];
|
| }
|
| + if (responseValueRenderOption != null) {
|
| + _queryParams["responseValueRenderOption"] = [responseValueRenderOption];
|
| + }
|
|
|
| _url = 'v4/spreadsheets/' + commons.Escaper.ecapeVariable('$spreadsheetId') + '/values/' + commons.Escaper.ecapeVariable('$range');
|
|
|
| @@ -4824,6 +4824,45 @@ class InterpolationPoint {
|
| }
|
| }
|
|
|
| +/**
|
| + * Settings to control how circular dependencies are resolved with iterative
|
| + * calculation.
|
| + */
|
| +class IterativeCalculationSettings {
|
| + /**
|
| + * When iterative calculation is enabled, the threshold value such that
|
| + * calculation rounds stop when succesive results differ by less.
|
| + */
|
| + core.double convergenceThreshold;
|
| + /**
|
| + * When iterative calculation is enabled, the maximum number of calculation
|
| + * rounds to perform during iterative calculation.
|
| + */
|
| + core.int maxIterations;
|
| +
|
| + IterativeCalculationSettings();
|
| +
|
| + IterativeCalculationSettings.fromJson(core.Map _json) {
|
| + if (_json.containsKey("convergenceThreshold")) {
|
| + convergenceThreshold = _json["convergenceThreshold"];
|
| + }
|
| + if (_json.containsKey("maxIterations")) {
|
| + maxIterations = _json["maxIterations"];
|
| + }
|
| + }
|
| +
|
| + core.Map toJson() {
|
| + var _json = new core.Map();
|
| + if (convergenceThreshold != null) {
|
| + _json["convergenceThreshold"] = convergenceThreshold;
|
| + }
|
| + if (maxIterations != null) {
|
| + _json["maxIterations"] = maxIterations;
|
| + }
|
| + return _json;
|
| + }
|
| +}
|
| +
|
| /** Merges all cells in the range. */
|
| class MergeCellsRequest {
|
| /**
|
| @@ -6728,6 +6767,12 @@ class SpreadsheetProperties {
|
| */
|
| CellFormat defaultFormat;
|
| /**
|
| + * Determines whether and how circular references are resolved with iterative
|
| + * calculation. Absence of this field means that circular references will
|
| + * result in calculation errors.
|
| + */
|
| + IterativeCalculationSettings iterativeCalculationSettings;
|
| + /**
|
| * The locale of the spreadsheet in one of the following formats:
|
| *
|
| * * an ISO 639-1 language code such as `en`
|
| @@ -6757,6 +6802,9 @@ class SpreadsheetProperties {
|
| if (_json.containsKey("defaultFormat")) {
|
| defaultFormat = new CellFormat.fromJson(_json["defaultFormat"]);
|
| }
|
| + if (_json.containsKey("iterativeCalculationSettings")) {
|
| + iterativeCalculationSettings = new IterativeCalculationSettings.fromJson(_json["iterativeCalculationSettings"]);
|
| + }
|
| if (_json.containsKey("locale")) {
|
| locale = _json["locale"];
|
| }
|
| @@ -6776,6 +6824,9 @@ class SpreadsheetProperties {
|
| if (defaultFormat != null) {
|
| _json["defaultFormat"] = (defaultFormat).toJson();
|
| }
|
| + if (iterativeCalculationSettings != null) {
|
| + _json["iterativeCalculationSettings"] = (iterativeCalculationSettings).toJson();
|
| + }
|
| if (locale != null) {
|
| _json["locale"] = locale;
|
| }
|
|
|