endRowOffset Method

Gets or sets the offset relative to the end row of the floating object.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.FloatingObjects.FloatingObject(name, x, y, width, height);
var returnValue; // Type: any
returnValue = instance.endRowOffset(value);

function endRowOffset( 
   value : number
) : any;

Parameters

value: The offset relative to the end row of the floating object.

Return Value

If no value is set, returns the offset relative to the end row of the floating object; otherwise, returns the floating object.

Example

This example creates a floating object.

Javascript

var customFloatingObject = new GC.Spread.Sheets.FloatingObjects.FloatingObject("f1", 10, 10, 60, 64);
var btn = document.createElement('button');
btn.style.width = "60px";
btn.style.height = "30px";
btn.innerText = "button";
customFloatingObject.content(btn);
activeSheet.floatingObjects.add(customFloatingObject);
//takes effect when added into the sheet.
customFloatingObject.startRow(2);
customFloatingObject.startColumn(2);
customFloatingObject.startRowOffset(10);
customFloatingObject.startColumnOffset(10);
customFloatingObject.endRow(7);
customFloatingObject.endColumn(5);
customFloatingObject.endRowOffset(10);
customFloatingObject.endColumnOffset(10);

Remarks

This method only takes effect after the floating object has been added to the sheet.

Reference

FloatingObject type