All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.google.api.services.sheets.v4.model.CellData Maven / Gradle / Ivy

There is a newer version: v4-rev20240826-2.0.0
Show newest version
/*
 * Copyright 2010 Google Inc.
 *
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
 * in compliance with the License. You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software distributed under the License
 * is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
 * or implied. See the License for the specific language governing permissions and limitations under
 * the License.
 */
/*
 * This code was generated by https://code.google.com/p/google-apis-client-generator/
 * (build: 2017-01-11 18:31:16 UTC)
 * on 2017-01-26 at 19:22:02 UTC 
 * Modify at your own risk.
 */

package com.google.api.services.sheets.v4.model;

/**
 * Data about a specific cell.
 *
 * 

This is the Java data model class that specifies how to parse/serialize into the JSON that is * transmitted over HTTP when working with the Google Sheets API. For a detailed explanation see: * http://code.google.com/p/google-http-java-client/wiki/JSON *

* * @author Google, Inc. */ @SuppressWarnings("javadoc") public final class CellData extends com.google.api.client.json.GenericJson { /** * A data validation rule on the cell, if any. * * When writing, the new data validation rule will overwrite any prior rule. * The value may be {@code null}. */ @com.google.api.client.util.Key private DataValidationRule dataValidation; /** * The effective format being used by the cell. This includes the results of applying any * conditional formatting and, if the cell contains a formula, the computed number format. If the * effective format is the default format, effective format will not be written. This field is * read-only. * The value may be {@code null}. */ @com.google.api.client.util.Key private CellFormat effectiveFormat; /** * The effective value of the cell. For cells with formulas, this will be the calculated value. * For cells with literals, this will be the same as the user_entered_value. This field is read- * only. * The value may be {@code null}. */ @com.google.api.client.util.Key private ExtendedValue effectiveValue; /** * The formatted value of the cell. This is the value as it's shown to the user. This field is * read-only. * The value may be {@code null}. */ @com.google.api.client.util.Key private java.lang.String formattedValue; /** * A hyperlink this cell points to, if any. This field is read-only. (To set it, use a * `=HYPERLINK` formula.) * The value may be {@code null}. */ @com.google.api.client.util.Key private java.lang.String hyperlink; /** * Any note on the cell. * The value may be {@code null}. */ @com.google.api.client.util.Key private java.lang.String note; /** * A pivot table anchored at this cell. The size of pivot table itself is computed dynamically * based on its data, grouping, filters, values, etc. Only the top-left cell of the pivot table * contains the pivot table definition. The other cells will contain the calculated values of the * results of the pivot in their effective_value fields. * The value may be {@code null}. */ @com.google.api.client.util.Key private PivotTable pivotTable; /** * Runs of rich text applied to subsections of the cell. Runs are only valid on user entered * strings, not formulas, bools, or numbers. Runs start at specific indexes in the text and * continue until the next run. Properties of a run will continue unless explicitly changed in a * subsequent run (and properties of the first run will continue the properties of the cell unless * explicitly changed). * * When writing, the new runs will overwrite any prior runs. When writing a new * user_entered_value, previous runs will be erased. * The value may be {@code null}. */ @com.google.api.client.util.Key private java.util.List textFormatRuns; /** * The format the user entered for the cell. * * When writing, the new format will be merged with the existing format. * The value may be {@code null}. */ @com.google.api.client.util.Key private CellFormat userEnteredFormat; /** * The value the user entered in the cell. e.g, `1234`, `'Hello'`, or `=NOW()` Note: Dates, Times * and DateTimes are represented as doubles in serial number format. * The value may be {@code null}. */ @com.google.api.client.util.Key private ExtendedValue userEnteredValue; /** * A data validation rule on the cell, if any. * * When writing, the new data validation rule will overwrite any prior rule. * @return value or {@code null} for none */ public DataValidationRule getDataValidation() { return dataValidation; } /** * A data validation rule on the cell, if any. * * When writing, the new data validation rule will overwrite any prior rule. * @param dataValidation dataValidation or {@code null} for none */ public CellData setDataValidation(DataValidationRule dataValidation) { this.dataValidation = dataValidation; return this; } /** * The effective format being used by the cell. This includes the results of applying any * conditional formatting and, if the cell contains a formula, the computed number format. If the * effective format is the default format, effective format will not be written. This field is * read-only. * @return value or {@code null} for none */ public CellFormat getEffectiveFormat() { return effectiveFormat; } /** * The effective format being used by the cell. This includes the results of applying any * conditional formatting and, if the cell contains a formula, the computed number format. If the * effective format is the default format, effective format will not be written. This field is * read-only. * @param effectiveFormat effectiveFormat or {@code null} for none */ public CellData setEffectiveFormat(CellFormat effectiveFormat) { this.effectiveFormat = effectiveFormat; return this; } /** * The effective value of the cell. For cells with formulas, this will be the calculated value. * For cells with literals, this will be the same as the user_entered_value. This field is read- * only. * @return value or {@code null} for none */ public ExtendedValue getEffectiveValue() { return effectiveValue; } /** * The effective value of the cell. For cells with formulas, this will be the calculated value. * For cells with literals, this will be the same as the user_entered_value. This field is read- * only. * @param effectiveValue effectiveValue or {@code null} for none */ public CellData setEffectiveValue(ExtendedValue effectiveValue) { this.effectiveValue = effectiveValue; return this; } /** * The formatted value of the cell. This is the value as it's shown to the user. This field is * read-only. * @return value or {@code null} for none */ public java.lang.String getFormattedValue() { return formattedValue; } /** * The formatted value of the cell. This is the value as it's shown to the user. This field is * read-only. * @param formattedValue formattedValue or {@code null} for none */ public CellData setFormattedValue(java.lang.String formattedValue) { this.formattedValue = formattedValue; return this; } /** * A hyperlink this cell points to, if any. This field is read-only. (To set it, use a * `=HYPERLINK` formula.) * @return value or {@code null} for none */ public java.lang.String getHyperlink() { return hyperlink; } /** * A hyperlink this cell points to, if any. This field is read-only. (To set it, use a * `=HYPERLINK` formula.) * @param hyperlink hyperlink or {@code null} for none */ public CellData setHyperlink(java.lang.String hyperlink) { this.hyperlink = hyperlink; return this; } /** * Any note on the cell. * @return value or {@code null} for none */ public java.lang.String getNote() { return note; } /** * Any note on the cell. * @param note note or {@code null} for none */ public CellData setNote(java.lang.String note) { this.note = note; return this; } /** * A pivot table anchored at this cell. The size of pivot table itself is computed dynamically * based on its data, grouping, filters, values, etc. Only the top-left cell of the pivot table * contains the pivot table definition. The other cells will contain the calculated values of the * results of the pivot in their effective_value fields. * @return value or {@code null} for none */ public PivotTable getPivotTable() { return pivotTable; } /** * A pivot table anchored at this cell. The size of pivot table itself is computed dynamically * based on its data, grouping, filters, values, etc. Only the top-left cell of the pivot table * contains the pivot table definition. The other cells will contain the calculated values of the * results of the pivot in their effective_value fields. * @param pivotTable pivotTable or {@code null} for none */ public CellData setPivotTable(PivotTable pivotTable) { this.pivotTable = pivotTable; return this; } /** * Runs of rich text applied to subsections of the cell. Runs are only valid on user entered * strings, not formulas, bools, or numbers. Runs start at specific indexes in the text and * continue until the next run. Properties of a run will continue unless explicitly changed in a * subsequent run (and properties of the first run will continue the properties of the cell unless * explicitly changed). * * When writing, the new runs will overwrite any prior runs. When writing a new * user_entered_value, previous runs will be erased. * @return value or {@code null} for none */ public java.util.List getTextFormatRuns() { return textFormatRuns; } /** * Runs of rich text applied to subsections of the cell. Runs are only valid on user entered * strings, not formulas, bools, or numbers. Runs start at specific indexes in the text and * continue until the next run. Properties of a run will continue unless explicitly changed in a * subsequent run (and properties of the first run will continue the properties of the cell unless * explicitly changed). * * When writing, the new runs will overwrite any prior runs. When writing a new * user_entered_value, previous runs will be erased. * @param textFormatRuns textFormatRuns or {@code null} for none */ public CellData setTextFormatRuns(java.util.List textFormatRuns) { this.textFormatRuns = textFormatRuns; return this; } /** * The format the user entered for the cell. * * When writing, the new format will be merged with the existing format. * @return value or {@code null} for none */ public CellFormat getUserEnteredFormat() { return userEnteredFormat; } /** * The format the user entered for the cell. * * When writing, the new format will be merged with the existing format. * @param userEnteredFormat userEnteredFormat or {@code null} for none */ public CellData setUserEnteredFormat(CellFormat userEnteredFormat) { this.userEnteredFormat = userEnteredFormat; return this; } /** * The value the user entered in the cell. e.g, `1234`, `'Hello'`, or `=NOW()` Note: Dates, Times * and DateTimes are represented as doubles in serial number format. * @return value or {@code null} for none */ public ExtendedValue getUserEnteredValue() { return userEnteredValue; } /** * The value the user entered in the cell. e.g, `1234`, `'Hello'`, or `=NOW()` Note: Dates, Times * and DateTimes are represented as doubles in serial number format. * @param userEnteredValue userEnteredValue or {@code null} for none */ public CellData setUserEnteredValue(ExtendedValue userEnteredValue) { this.userEnteredValue = userEnteredValue; return this; } @Override public CellData set(String fieldName, Object value) { return (CellData) super.set(fieldName, value); } @Override public CellData clone() { return (CellData) super.clone(); } }




© 2015 - 2024 Weber Informatics LLC | Privacy Policy