SpreadJS 13
GC.Spread.Sheets.FloatingObjects Namespace / FloatingObject type / endRowOffset Method
The offset relative to the end row of the floating object.
In This Topic
    endRowOffset Method
    In This Topic
    Gets or sets the offset relative to the end row of the floating object.
    Syntax
    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.
    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.
    See Also