Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

ShapePictureFill.SourceRect Property

Gets the part of the picture used for the fill.

Namespace: DevExpress.Spreadsheet.Drawings

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

ShapeRectangleOffset SourceRect { get; }

#Property Value

Type Description
ShapeRectangleOffset

An object that specifies the source rectangle offsets from the corresponding edges of the bounding box.

#Remarks

If the SourceRect property is a positive value, the source image is cropped and stretched to fill the available area. For instance, the left offset of 35% specifies that the leftmost 35% of the picture is cropped and the remaining part of the picture is used to fill the shape, as shown in the table below (the chart is displayed in Microsoft® Excel®).

If the SourceRect property is a negative value, an empty space appears along the corresponding edges of the picture. For instance, the left and right offsets of -10% specifies that two blank bands of equal width (10% of the bounding box’s width) are shown along the left and right edges of the picture.

SourceRect is not specified

SourceRect.Left = 0.35

SourceRect.Left = -0.1

SourceRect.Right = -0.1

SpreadsheetSourceRectangleOffsetLeft0Percent

SpreadsheetSourceRectangleOffsetLeft35Percent

SpreadsheetSourceRectangleOffsetLeftMinus10Percent

Use the ShapeComplexFill.FillRect property to specify where the picture fill should start.

Note

The SourceRect property has no effect on the visual appearance of a chart when the document is loaded in the SpreadsheetControl. However, the property can be accessed in code, exported in supported formats and visualized in Microsoft Excel.

See Also