Trait

com.google.appsscript.spreadsheet

EmbeddedChartBuilder

Related Doc: package spreadsheet

Permalink

trait EmbeddedChartBuilder extends Object

EmbeddedChartBuilder This builder allows you to edit an EmbeddedChart. Make sure to call sheet.updateChart(builder.build()) to save your changes.

var sheet = SpreadsheetApp.getActiveSheet(); var range = sheet.getRange("A1:B8"); var chart = sheet.getCharts()[0]; chart = chart.modify() .addRange(range) .setOption('title', 'Updated!') .setOption('animation.duration', 500) .setPosition(2,2,0,0) .build(); sheet.updateChart(chart);

Annotations
@RawJSType()
Linear Supertypes
Object, Any, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. EmbeddedChartBuilder
  2. Object
  3. Any
  4. AnyRef
  5. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Value Members

  1. final def !=(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int

    Permalink
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  4. def addRange(range: Range): EmbeddedChartBuilder

    Permalink

    Adds a Range to the chart represented by this builder.

    Adds a Range to the chart represented by this builder. Will not add the Range if it has already been added to the chart.

  5. def asAreaChart(): EmbeddedAreaChartBuilder

    Permalink

    Sets the chart type to AreaChart and returns an EmbeddedAreaChartBuilder.

  6. def asBarChart(): EmbeddedBarChartBuilder

    Permalink

    Sets the chart type to BarChart and returns an EmbeddedBarChartBuilder.

  7. def asColumnChart(): EmbeddedColumnChartBuilder

    Permalink

    Sets the chart type to ColumnChart and returns an EmbeddedColumnChartBuilder.

  8. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any
  9. def asLineChart(): EmbeddedLineChartBuilder

    Permalink

    Sets the chart type to LineChart and returns an EmbeddedLineChartBuilder.

  10. def asPieChart(): EmbeddedPieChartBuilder

    Permalink

    Sets the chart type to PieChart and returns an EmbeddedPieChartBuilder.

  11. def asScatterChart(): EmbeddedScatterChartBuilder

    Permalink

    Sets the chart type to ScatterChart and returns an EmbeddedScatterChartBuilder.

  12. def asTableChart(): EmbeddedTableChartBuilder

    Permalink

    Sets the chart type to TableChart and returns an EmbeddedTableChartBuilder.

  13. def build(): EmbeddedChart

    Permalink

    Builds the chart to reflect all changes made to it.

    Builds the chart to reflect all changes made to it. This method will not automatically draw the chart on top of the spreadsheet. A new chart must be inserted via sheet.insertChart(chart), and an existing chart should be updated via sheet.update(chart);

  14. def clone(): AnyRef

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  15. final def eq(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  16. def equals(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  17. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  18. def getChartType(): ChartType

    Permalink

    Returns the current chart type.

  19. final def getClass(): Class[_]

    Permalink
    Definition Classes
    AnyRef → Any
  20. def getContainer(): ContainerInfo

    Permalink

    Return the ContainerInfo, which encapsulates where the chart appears on the sheet.

  21. def getRanges(): Array[Range]

    Permalink

    Returns a copy of the list of ranges currently providing data for this chart.

    Returns a copy of the list of ranges currently providing data for this chart. Use addRange and removeRange to modify this list.

  22. def hasOwnProperty(v: String): Boolean

    Permalink
    Definition Classes
    Object
  23. def hashCode(): Int

    Permalink
    Definition Classes
    AnyRef → Any
  24. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any
  25. def isPrototypeOf(v: Object): Boolean

    Permalink
    Definition Classes
    Object
  26. final def ne(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  27. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef
  28. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef
  29. def propertyIsEnumerable(v: String): Boolean

    Permalink
    Definition Classes
    Object
  30. def removeRange(range: Range): EmbeddedChartBuilder

    Permalink

    Removes the specified Range from the chart represented by this builder.

    Removes the specified Range from the chart represented by this builder. Will not throw an error if the Range is not in this chart. The range removed must match up with a range added via addRange(range), or it will not be removed, and it will not throw an exception. This method cannot be used to partially remove values from a range.

  31. def setChartType(type: ChartType): EmbeddedChartBuilder

    Permalink

    Changes the type of chart.

    Changes the type of chart. Not all embedded chart types are currently supported. See ChartType.

  32. def setOption(option: String, value: AnyRef): EmbeddedChartBuilder

    Permalink

  33. def setPosition(anchorRowPos: Int, anchorColPos: Int, offsetX: Int, offsetY: Int): EmbeddedChartBuilder

    Permalink

    Sets the position, changing where the chart appears on the sheet.

    Sets the position, changing where the chart appears on the sheet. AnchorRowPos and AnchorColPos are 1-indexed.

  34. final def synchronized[T0](arg0: ⇒ T0): T0

    Permalink
    Definition Classes
    AnyRef
  35. def toLocaleString(): String

    Permalink
    Definition Classes
    Object
  36. def toString(): String

    Permalink
    Definition Classes
    AnyRef → Any
  37. def valueOf(): Any

    Permalink
    Definition Classes
    Object
  38. final def wait(): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  39. final def wait(arg0: Long, arg1: Int): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  40. final def wait(arg0: Long): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

Inherited from Object

Inherited from Any

Inherited from AnyRef

Inherited from Any

Ungrouped