2.2.3.37 wcellgraph

1 Brief Information
2 Additional Information
3 Command Line Usage
4 X-Function Execution Options
5 Variables
- 5.1 settings
6 Description
7 Examples
8 Related X-Functions

Brief Information

Modify properties of embedded graphs in worksheet

Additional Information

Minimum Origin Version Required: 8.6

Command Line Usage

wcellgraph irng:=[Book1]Sheet1!1[2] settings.resizecell:=1;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name

Variable
Name

I/O
and
Type

Default
Value

Description

Reference Cell

irng

Input

Range

Select cells of embedded graphs.

Cell Graph Setting

settings

Input

TreeNode

Specify the settings for the embedded graphs. For more details, see the settings node.

settings

The settings tree node allows you to specify properties for embedded graphs.

Syntax: settings.Treenode:= <value>

Examples:

settings.display:=0

Treenode	Label	Type	Description
display	Display Caching	Input int	Specify the method of display caching. Option list: Enhanced Metafile (0) Display the inserted graph in EMF format. Bitmap (1) Display the inserted graph in BMP format.
cache	Cache in Page	Input int	Specify whether (1) or not (0) to cache embedded graphs in the worksheet's page. If checked, it can enhance the redraw speed of embedded graphs.
resizecell	Resize Cell	Input int	Specify whether (1) or not (0) to resize the worksheet cells to fit the embedded or linked graphs.
keepAspect	Keep Aspect Ratio	Input int	Specify whether (1) or not (0) to keep the aspect ratio of the graphs.
axes	Hide Axes and Legend	Input int	Specify whether (1) or not (0) to hide the axes and legend of the graph when it is displayed in the worksheet cell.
label	Hide Text Labels	Input int	Specify whether (1) or not (0) to hide the text labels on the graph when it is displayed in the worksheet cell.

Description

It is used to modify the properties of embedded graphs in the worksheet.

Examples

Open the project file \Samples\Samples.opj.
Make the 3D and Contour sheet active.
Run the script.

wcellgraph irng:=[Book2]"3D and Contour"!1[2] settings.axes:=1;

The axes of the graph in row 2 of column 1 will be hidden. Note that since the input range is fully specified, the 3D and Contour sheet does not need to be active in order for the script to work.