# 2.2.3.36 wcellgraph

## Brief Information

Modify properties of embedded graphs in worksheet

Minimum Origin Version Required: 8.6

## Command Line Usage

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

## Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Reference Cell irng

Input

Range

<active>
Select cells of embedded graphs.
Cell Graph Setting settings

Input

TreeNode

<unassigned>
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 Default
Value
Description
display Display Caching

Input

int

0
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

0
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

0
Specify whether (1) or not (0) to resize the worksheet cells to fit the embedded or linked graphs.
keepAspect Keep Aspect Ratio

Input

int

0
Specify whether (1) or not (0) to keep the aspect ratio of the graphs.
axes Hide Axes and Legend

Input

int

0
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

0
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

1. Open the project file \Samples\Samples.opj.
2. Make the 3D and Contour sheet active.
3. 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.