refresh Method

refresh the formula text box with the active cell.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.FormulaTextBox.FormulaTextBox(host, options);
var value; // Type: any
value = instance.refresh();

function refresh() : any;

Example

This example updates the formulaTextBox.

Javascript

var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"));
var sheet = spread.getActiveSheet();
sheet.setArray(0, 0, [1, 2, 3, 4, 5]);
var fbx = new GC.Spread.Sheets.FormulaTextBox.FormulaTextBox(document.getElementById("formulaTextBox"));
fbx.workbook(spread);
$("#button1").click(function () {
sheet.setActiveCell(0, 4);
sheet.getCell(0, 4).formula("=A1");
fbx.refresh();

Reference

FormulaTextBox class

Send comments on this topic.