getFormula Method (ShapeBase)

getFormula Method

In This Topic

Gets the formula string from the shape by the path.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Shapes.ShapeBase();
var value; // Type: string
value = instance.getFormula(path);

function getFormula( 
   path : string
) : string;

Parameters

path: The path which can accept a formula string, it could be one of "x", "y", "width", "height".

Return Value

Returns the formula string from the shape by the path.

Example

Javascript

sheet.name("Sheet1");
sheet.setValue(0, 1, 150);
var shape1 = sheet.shapes.add("myShape1", GC.Spread.Sheets.Shapes.AutoShapeType.rectangle, 100, 100, 200, 200);
shape1.setFormula("x", "=Sheet1!B1");
shape1.getFormula("x");//returns "=Sheet1!B1"

Reference

ShapeBase type

Product Support Forum | Print this page