SpreadJS 13
SpreadJS Documentation / Developer's Guide / Features / Manage User Interface / Auto Fill Data / Auto Fill Strings
In This Topic
    Auto Fill Strings
    In This Topic

    SpreadJS allows users to automatically fill strings by using the drag fill option. You can simply drag the fill handle in an upward or downward direction in order to fill the cell data with strings across the entire column in the worksheet.

    Users can also carry out other custom string filling operations like filling cells with strings that contain numbers only and filling cells with strings that contain number at the end, as shown in the image shared below.

    Auto fill strings

    The following example image depicts automatic filling of strings that contain numbers initially and strings that just copy data in the same order.

    Auto fill strings

    Using Code

    Refer to the following example code in order to automatically fill strings that contain numbers only, strings that contain number at the end, strings that contain numbers initially and strings that copy data in the same order.

    JavaScript
    Copy Code
    $(document).ready(function ()
    {
    // Initializing Spread
    var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'),
    { sheetCount: 1});
    
    // Drag Fill strings
    var sheet1 = spread.getSheet(0);
    sheet1.name("String DragFill");
    
    // N: number, S: string.
    /* DragFill for string, detecting number from end to start, SN first and
    NS second.Trend N if S is same */
    sheet1.setValue(0, 0, 'Please drag up or down');
    sheet1.setValue(1, 0, 'String contains numbers only');
    sheet1.setValue(6, 0, '123');
    sheet1.setValue(7, 0, '125');
    sheet1.setValue(6, 1, '-3');
    sheet1.setValue(7, 1, '-2');
    sheet1.setValue(6, 2, '003');
    sheet1.setValue(7, 2, '007');
    sheet1.setColumnWidth(2, 70);
    sheet1.setColumnWidth(3, 20);
    sheet1.setValue(1, 4, 'String contains number in the end');
    
    // Choose "Fill Series" for the single one
    sheet1.setValue(6, 4, 'a2');
    sheet1.setValue(6, 5, 'a1');
    sheet1.setValue(7, 5, 'a5');
    sheet1.setValue(6, 6, 'a001');
    sheet1.setValue(7, 6, 'a002');
    sheet1.setValue(6, 7, '1a2a3a4a5');
    sheet1.setValue(7, 7, '1a2a3a4a6');
    sheet1.setColumnWidth(7, 80);
    sheet1.setValue(13, 0, 'String contains numbers initally');
    sheet1.setValue(18, 0, '5a');
    sheet1.setValue(19, 0, '2a');
    sheet1.setValue(18, 1, '003b');
    sheet1.setValue(19, 1, '005b');
    sheet1.setValue(18, 2, '1a1a1a');
    sheet1.setValue(19, 2, '2a1a1a');
    sheet1.setValue(13, 4, 'String just to copy');
    sheet1.setValue(18, 4, 'a1a1');
    sheet1.setValue(19, 4, 'a2a2');
    sheet1.setValue(18, 5, '1a1');
    sheet1.setValue(19, 5, '2a2');
    sheet1.setValue(18, 6, 'a1');
    sheet1.setValue(19, 6, 'b2');
    });