OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 8

changes.mady.by.user Unknown User (seank)

Saved on

compared with

New Version Current

changes.mady.by.user Unknown User (seank)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

Moves the chart to a different worksheet. The method specifies whether the chart should be inserted as an object within the worksheet, or converted to a chart sheet.

Signature
C#
C#
 public void MoveChart(ChartLocation chartLocation, System.String sheetName)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Sub MoveChart(ByVal chartLocation As ChartLocation, ByVal sheetName As String)
{signature}
{parameters}
{param:chartLocation}[
Parameters
Param
chartLocation
chartLocation

Chart.ChartLocation.ChartAsSheet

|Chart.ChartLocation#ChartAsSheet]

or

[

Chart.ChartLocation.ObjectInSheet

|Chart.ChartLocation#ObjectInSheet].{param} {param:sheetName}New name for the sheet to which the chart is moved.{param} {exceptions} {exception:ArgumentException} An ArgumentException will be thrown in two cases. First, if {{chartLocation}} is {{ChartAsSheet}} and a sheet ({{Worksheet}} or {{Chartsheet}}) named {{sheetName}} already exists. Second, if {{chartLocation}} is {{ObjectInSheet}}, and a sheet named {{sheetName}} already exists and is a {{Chartsheet}}. {exception} {remarks} If {{chartLocation}} is {{ChartAsSheet}}, this will create a {{Chartsheet}} named {{sheetName}} at the end of the workbook and move the chart into it. If {{chartLocation}} is {{ObjectInSheet}} and there is already a worksheet named {{sheetName}}, this will move the chart into that sheet. If there is no such sheet, this will create a new {{Worksheet}} with that name at the end of the workbook and move the chart into it. In either case, the chart's formulas (for series data, axis titles, etc) will maintain their original references. If the chart is inside a chartsheet before calling this method, that chartsheet is deleted. {remarks} {scrollbar}

.

Param
sheetName
sheetName

New name for the sheet to which the chart is moved.

Exceptions
Exception
ArgumentException
ArgumentException

An ArgumentException will be thrown in two cases. First, if chartLocation is ChartAsSheet and a sheet (Worksheet or Chartsheet) named sheetName already exists. Second, if chartLocation is ObjectInSheet, and a sheet named sheetName already exists and is a Chartsheet.

Remarks

If chartLocation is ChartAsSheet, this will create a Chartsheet named sheetName at the end of the workbook and move the chart into it.

If chartLocation is ObjectInSheet and there is already a worksheet named sheetName, this will move the chart into that sheet. If there is no such sheet, this will create a new Worksheet with that name at the end of the workbook and move the chart into it.

In either case, the chart's formulas (for series data, axis titles, etc) will maintain their original references.

If the chart is inside a chartsheet before calling this method, that chartsheet is deleted.

Scrollbar