FloatingObject.TopLeftCell Property

Gets or sets a cell where the top left corner of a floating object is located.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v18.2.Core.dll

Declaration

C#

Cell TopLeftCell { get; set; }

VB.NET

Property TopLeftCell As Cell

Property Value

Type	Description
Cell	A Cell object that is the cell containing the floating object’s top left corner.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the TopLeftCell property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-chart-examples/CS/SpreadsheetDocServerChartAPISamples/CodeExamples/AxesActions.cs#L18

Chart chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet["B3:C5"]);
chart.TopLeftCell = worksheet.Cells["H2"];
chart.BottomRightCell = worksheet.Cells["N14"];

winforms-spreadsheet-chart-api-e5222/CS/SpreadsheetChartAPISamples/CodeExamples/AxesActions.cs#L18

Chart chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet["B3:C5"]);
chart.TopLeftCell = worksheet.Cells["H2"];
chart.BottomRightCell = worksheet.Cells["N14"];

wpf-spreadsheet-chart-api-t113198/CS/SpreadsheetWPFChartAPISamples/CodeExamples/SeriesActions.cs#L18

Chart chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet["B2:E6"]);
chart.TopLeftCell = worksheet.Cells["H2"];
chart.BottomRightCell = worksheet.Cells["N14"];

spreadsheet-how-to-add-a-chart-to-a-document-t467065/CS/T449201/DiagramCreationHelper.cs#L45

Chart chart = worksheet.Charts.Add(ChartType.BarFullStacked);
chart.TopLeftCell = worksheet.Cells["E2"];
chart.BottomRightCell = worksheet.Cells["K15"];

VB.NET

spreadsheet-document-api-chart-examples/VB/SpreadsheetDocServerChartAPISamples/CodeExamples/Charts1.vb#L22

Dim chart As Chart = worksheet.Charts.Add(ChartType.PieOfPie, worksheet("B2:C11"))
chart.TopLeftCell = worksheet.Cells("E2")
chart.BottomRightCell = worksheet.Cells("L16")

winforms-spreadsheet-chart-api-e5222/VB/SpreadsheetChartAPISamples/CodeExamples/AxesActions.vb#L21

Dim chart As Chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet("B3:C5"))
chart.TopLeftCell = worksheet.Cells("H2")
chart.BottomRightCell = worksheet.Cells("N14")

wpf-spreadsheet-chart-api-t113198/VB/SpreadsheetWPFChartAPISamples/CodeExamples/SeriesActions.vb#L22

Dim chart As Chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet("B2:E6"))
chart.TopLeftCell = worksheet.Cells("H2")
chart.BottomRightCell = worksheet.Cells("N14")

spreadsheet-how-to-add-a-chart-to-a-document-t467065/VB/T449201/DiagramCreationHelper.vb#L45

Dim chart As Chart = worksheet.Charts.Add(ChartType.BarFullStacked)
chart.TopLeftCell = worksheet.Cells("E2")
chart.BottomRightCell = worksheet.Cells("K15")