Workflow List

Drop-downs provide developers the ability to add a drop-down menu with specific properties to cells in a workbook. These drop-down menus don't require any extra code other than simply specifying which one to use for the drop-down menu.

SpreadJS has 9 different kinds of drop-downs, and this demo shows how to use the Workflow List.

Before opening the Workflow List, you need to set the options data in cell's style. You can use Workflow List drop-down with the following code :

    // The way of click the dropdown icon to open Workflow List. 
   let style = new GC.Spread.Sheets.Style();
       style.cellButtons = [
           {
               imageType: GC.Spread.Sheets.ButtonImageType.dropdown,
               command: "openWorkflowList",
               useButtonStyle: true,
           }
       ];
       style.dropDowns = [
           {
               type: GC.Spread.Sheets.DropDownType.workflowList,
               option: {
                   items: [
                       { value: "New", transitions: [1] },
                       { value: "Open",transitions: [0,2,3,5] },
                       { value: "In Progress", transitions: [1, 3, 5] },
                       { value: "Resolved", transitions: [5, 4] },
                       { value: "Reopened",transitions: [5, 3, 2] },
                       { value: "Closed", transitions: [4] },
                   ]
               }
           }
       ];
       sheet.setText(4, 4, "Workflow List");
       sheet.setStyle(5, 4, style);

       // The way just open Workflow List with command rather then clicking the dropdown button.
       spread.commandManager().execute({cmd:"openWorkflowList",row:5,col:4,sheetName:"Sheet1"});

The option of Workflow List should follow the structure like this :

export interface IWorkFlowOption {
    items: IWorkFlowItem[];
}


export interface IWorkFlowItem {
    value: string;
    transitions: number[]|string[];
}