2.2.3.37 wcellgraph


Contents

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

<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.

Related X-Functions

insertGraph