搜索

Help

第29页,共72页。 显示 711 条结果 (0.223 秒)

  1. 客户端宏示例.xml

    ="spreadsheetReport" eventName="onRender" moduleType="ClientSide" name="宏对象示例" disabled="true"><script><![CDATA[function main(spreadsheetReport, isAjaxRefreshCallback) { debugger; var toolbar1 = document.getElementsByClassName("queryview-toolbar"); var toolbar2 = spreadsheetReport.elemToolbarTr; var
  2. 客户端宏示例.xml

    ="spreadsheetReport" eventName="onRender" moduleType="ClientSide" name="宏对象示例" disabled="true"><script><![CDATA[function main(spreadsheetReport, isAjaxRefreshCallback) { debugger; var toolbar1 = document.getElementsByClassName("queryview-toolbar"); var toolbar2 = spreadsheetReport.elemToolbarTr; var
  3. index.html

    ", "smartbi.spreadsheetreport.SpreadsheetReport", "smartbi.spreadsheetreport.macro.SpreadsheetMacroExecutor", "bof.macro.services.MacroService … ","ExcelPlugin","LoadExcel","Page","Index","Mining","Search","OlapQuery","Insight","SpreadSheetReport","SAP-BW","CatalogPublish","InsightEdition","ProcedureQuery
  4. index.html

    ", "smartbi.spreadsheetreport.SpreadsheetReport", "smartbi.spreadsheetreport.macro.SpreadsheetMacroExecutor", "bof.macro.services.MacroService … ","ExcelPlugin","LoadExcel","Page","Index","Mining","Search","OlapQuery","Insight","SpreadSheetReport","SAP-BW","CatalogPublish","InsightEdition","ProcedureQuery
  5. Re: 宏示例-某些情况下导出需要删除隐藏列

    ,但并不是所有的场景都适用,需要根据自己的场景调整相应的宏代码: function main(spreadsheetReport) { if (spreadsheetReport.outputType != "EXCEL2007") return; spreadsheetReport.cacheable = false; var workbook = spreadsheetReport.workbook; var worksheets = workbook.worksheets; for (var i = 0; i < worksheets.count; i++) { var worksheet = worksheets.get
  6. Re: 样式 - 电子表格按钮添加文字描述

    excel数据导入按钮添加文字描述 setTimeout(function() { spreadsheetReport.elemImportConfig.innerText = "excel导入"; spreadsheetReport.elemImportConfig.style.width = "90px"; spreadsheetReport.elem_btnExcelImport.style.fontSize = fontSize; }, 100); image2023-2-21_13-58-50.png
  7. Re: 电子表格导出PDF,数据较多被截断了

    另一种方案: function main(spreadsheetReport) { var sheet = spreadsheetReport.workbook.worksheets.get(0); var cells = sheet.getCells(); var colCount = cells.getMaxColumn(); var posList1 = spreadsheetReport.sheets[0].getExpandedPositions("D8"); for (var i = 0; i < posList1.length; i++) { var pos = posList1[i
  8. migrate (15).xml

    ="spreadsheetReport" eventName="onBeforeOutput" moduleType="ServerSide" name="根据参数值不同导出不同Sheet服务端宏" disabled="false"><script><![CDATA[/** *执行逻辑: * 1,根据城市参数,将每个城市创建一个sheet,并且获取其在原始报表中的起始/结束行 * 2,原始报表sheet内容copy到目标城市所在sheet,并删除初目标城市之外的数据 */ function main(spreadsheetReport) { spreadsheetReport.cacheable = false; //判断导出类型
  9. migrate (15).xml

    ="spreadsheetReport" eventName="onBeforeOutput" moduleType="ServerSide" name="根据参数值不同导出不同Sheet服务端宏" disabled="false"><script><![CDATA[/** *执行逻辑: * 1,根据城市参数,将每个城市创建一个sheet,并且获取其在原始报表中的起始/结束行 * 2,原始报表sheet内容copy到目标城市所在sheet,并删除初目标城市之外的数据 */ function main(spreadsheetReport) { spreadsheetReport.cacheable = false; //判断导出类型
  10. migrate_电子表格参数后添加按钮.xml

    ="I8a8af0a60172a0faa0fa26670172a2c9df9a1245" resourceId="I8a8af0a60172a0faa0fa26670172a2c8e9c5122a" targetName="spreadsheetReport" eventName="onRender" moduleType="ClientSide" name="紧挨参数添加按钮" disabled="false" order="0"><script><![CDATA[function main(spreadsheetReport) { addButtons(spreadsheetReport); } //新增按钮 function addButtons(spreadsheetReport