公式支持

window.onload = function () {
    var spread = new GC.Spread.Sheets.Workbook(_getElementById('ss'), { sheetCount: 0 });
    initSpread(spread);
};

function initSpread(spread) {
    spread.options.autoFitType = GC.Spread.Sheets.AutoFitType.cellWithHeader;
    spread.clearSheets();
    var dataManager = spread.dataManager();
    initHierarchyFormulas(spread, dataManager);
}
function initHierarchyFormulas(spread, dataManager) {
    var table = dataManager.addTable("Table", {
remote: {
    read: {
url: getBaseApiUrl() + "/Hierarchy_Formula"
    }
},
schema: {
    hierarchy: {
type: 'Parent',
column: 'parent',
summaryFields: {
    'budget': '=SUM(CHILDREN(1,"budget"))'
}
    },
    columns: {
id: {
    isPrimaryKey: true,
},
    },
}
    });

    var sheet = spread.addSheetTab(0, "HierarchyFormula", GC.Spread.Sheets.SheetType.tableSheet);
    sheet.setDefaultRowHeight(40, GC.Spread.Sheets.SheetArea.colHeader);
    sheet.options.allowAddNew = false;

    table.fetch().then(function () {
var myView = table.addView("myView", [
    { value: '=CONCAT([@department]," (L",LEVEL(),"-",LEVELROWNUMBER(),")")', caption: 'Department', width: 265, outlineColumn: true },
    { value: "budget", width: 100, caption: 'Budget' },
    { value: '=IF(LEVEL()=0,"",[@budget]/PARENT(1,"budget"))', width: 120, caption: 'Percentage', style: { formatter: '0.00%' } },
    { value: "location", width: 100, caption: 'Location' },
    { value: "phone", width: 150, caption: 'Phone' },
    { value: "country", width: 100, caption: 'Country' },
]);
spread.suspendPaint();
sheet.setDataView(myView);
spread.resumePaint();
    });
}