search

reqable / reqable-app

Reqable issue track repo
https://reqable.com
3.72k stars 133 forks source link

[bug] 导入cURL时，对转义字符的处理在特定情况下有问题，没有将\\n转成\n，postman可以支持。我把整个curl附上了 #1128

Closed lipenghao1216 closed 5 days ago

lipenghao1216 commented 1 week ago

curl 'https://dev.cloud.hecom.cn/report//paas/app/chineseReport/operation/data/compute' \ -H 'accept: /' \ -H 'accept-language: zh-CN,zh;q=0.9,en;q=0.8,en-US;q=0.7' \ -H 'accesstoken: YgbwkdK3jTtEFKzbUgmFpU4TqJrsfCgl' \ -H 'act: operation' \ -H 'app: chineseReport' \ -H 'clienttag: web' \ -H 'content-type: application/json' \ -H 'cookie: _ga=GA1.2.1928857177.1688548158; _ga_QZJBSCYW27=GS1.2.1708430409.4.1.1708431205.0.0.0; sensorsdata2015jssdkcross=%7B%22distinct_id%22%3A%221902569f8243d9-03eeeeeeeeeeeec-1a525637-2104200-1902569f8251fc5%22%2C%22first_id%22%3A%22%22%2C%22props%22%3A%7B%7D%2C%22identities%22%3A%22eyIkaWRlbnRpdHlfY29va2llX2lkIjoiMTkwMjU2OWY4MjQzZDktMDNlZWVlZWVlZWVlZWVjLTFhNTI1NjM3LTIxMDQyMDAtMTkwMjU2OWY4MjUxZmM1In0%3D%22%2C%22history_login_id%22%3A%7B%22name%22%3A%22%22%2C%22value%22%3A%22%22%7D%2C%22%24device_id%22%3A%221902569f8243d9-03eeeeeeeeeeeec-1a525637-2104200-1902569f8251fc5%22%7D; __bid_n=1902569f865641658de8ac; Hm_lvt_8c3936c07d955bb0021efe1622ba6e33=1729731934; Hm_lpvt_8c3936c07d955bb0021efe1622ba6e33=1729731934; HMACCOUNT=168115EFA7016CD2; Hm_lvt_88b06c04e23e1e6b1fcdd7f55522eb71=1729731934; Hm_lpvt_88b06c04e23e1e6b1fcdd7f55522eb71=1729731934; SECKEY_ABVK=NlBZE9MSgd56rf57n2i3eOXlo/vrsLc7fPuGcC1huwM%3D' \ -H 'empcode: 2498019091' \ -H 'entcode: jidianerlei_demo' \ -H 'origin: https://dev.cloud.hecom.cn' \ -H 'priority: u=1, i' \ -H 'referer: https://dev.cloud.hecom.cn/' \ -H 'sec-ch-ua: "Google Chrome";v="131", "Chromium";v="131", "Not_A Brand";v="24"' \ -H 'sec-ch-ua-mobile: ?0' \ -H 'sec-ch-ua-platform: "macOS"' \ -H 'sec-fetch-dest: empty' \ -H 'sec-fetch-mode: cors' \ -H 'sec-fetch-site: same-origin' \ -H 'uid: c973896577586429952' \ -H 'user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36' \ --data-raw $'{"sheets":[{"id":"0-7r0GNRFHq7uqz8qGT4D","label":"工作表","colConfigs":[{"index":0,"height":93},{"index":1,"height":93},{"index":2,"height":86},{"index":3,"height":84},{"index":4,"height":80},{"index":5,"height":80},{"index":6,"height":80},{"index":7,"height":80},{"index":8,"height":80},{"index":9,"height":80},{"index":10,"height":80},{"index":11,"height":80},{"index":12,"height":80},{"index":13,"height":80},{"index":14,"height":80},{"index":15,"height":80},{"index":16,"height":80}],"rowConfigs":[{"index":1,"height":27,"hidden":false},{"index":2,"height":27,"hidden":false},{"index":3,"height":27,"hidden":false}],"finalRowIndex":3,"finalColIndex":16,"cells":[{"key":"0-7r0GNRFHq7uqz8qGT4D-1-0","rowIndex":1,"colIndex":0,"rowSpan":0,"colSpan":0,"label":"设计师","value":"设计师","name":"A2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-1","rowIndex":1,"colIndex":1,"rowSpan":0,"colSpan":0,"label":"项目","value":"项目","name":"B2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-2","rowIndex":1,"colIndex":2,"rowSpan":0,"colSpan":0,"name":"C2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":false,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-3","rowIndex":1,"colIndex":3,"rowSpan":0,"colSpan":0,"name":"D2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":false,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-4","rowIndex":1,"colIndex":4,"rowSpan":0,"colSpan":0,"label":"总计","value":"总计","name":"E2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":false,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-5","rowIndex":1,"colIndex":5,"rowSpan":0,"colSpan":0,"label":"1月","value":"1月","name":"F2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-6","rowIndex":1,"colIndex":6,"rowSpan":0,"colSpan":0,"label":"2月","value":"2月","name":"G2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-7","rowIndex":1,"colIndex":7,"rowSpan":0,"colSpan":0,"label":"3月","value":"3月","name":"H2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-8","rowIndex":1,"colIndex":8,"rowSpan":0,"colSpan":0,"label":"4月","value":"4月","name":"I2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-9","rowIndex":1,"colIndex":9,"rowSpan":0,"colSpan":0,"label":"5月","value":"5月","name":"J2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-10","rowIndex":1,"colIndex":10,"rowSpan":0,"colSpan":0,"label":"6月","value":"6月","name":"K2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-11","rowIndex":1,"colIndex":11,"rowSpan":0,"colSpan":0,"label":"7月","value":"7月","name":"L2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-12","rowIndex":1,"colIndex":12,"rowSpan":0,"colSpan":0,"label":"8月","value":"8月","name":"M2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-13","rowIndex":1,"colIndex":13,"rowSpan":0,"colSpan":0,"label":"9月","value":"9月","name":"N2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-14","rowIndex":1,"colIndex":14,"rowSpan":0,"colSpan":0,"label":"10月","value":"10月","name":"O2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-15","rowIndex":1,"colIndex":15,"rowSpan":0,"colSpan":0,"label":"11月","value":"11月","name":"P2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-1-16","rowIndex":1,"colIndex":16,"rowSpan":0,"colSpan":0,"label":"12月","value":"12月","name":"Q2","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":false,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-0","rowIndex":2,"colIndex":0,"rowSpan":1,"colSpan":0,"label":"G(设计任务列表.设计师)","value":"G(设计任务列表.设计师)","name":"A3","elementType":"COLUMN_DATA","expand":1,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null},"datasetId":2592258699,"datasetFieldName":"field2","datasetFieldId":2592259232,"dataSetting":"GROUP","modelId":2592262018,"modelDatasetName":"CustomObject192"},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-1","rowIndex":2,"colIndex":1,"rowSpan":1,"colSpan":0,"label":"G(设计任务列表.项目名称)","value":"G(设计任务列表.项目名称)","name":"B3","elementType":"COLUMN_DATA","expand":1,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-0","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null},"datasetId":2592258699,"datasetFieldName":"field1","datasetFieldId":2592259200,"dataSetting":"GROUP","modelId":2592262018,"modelDatasetName":"CustomObject192"},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-2","rowIndex":2,"colIndex":2,"rowSpan":0,"colSpan":1,"label":"合计","value":"合计","name":"C3","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-4","rowIndex":2,"colIndex":4,"rowSpan":0,"colSpan":0,"label":"F3+G3+H3+I3+J3+K3+L3+M3+N3+O3+P3+Q3\n","value":"F3+G3+H3+I3+J3+K3+L3+M3+N3+O3+P3+Q3\n","name":"E3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":false},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-5","rowIndex":2,"colIndex":5,"rowSpan":0,"colSpan":0,"label":"SUM(F4)","value":"SUM(F4)","name":"F3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":false},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-6","rowIndex":2,"colIndex":6,"rowSpan":0,"colSpan":0,"label":"SUM(G4)","value":"SUM(G4)","name":"G3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-7","rowIndex":2,"colIndex":7,"rowSpan":0,"colSpan":0,"label":"SUM(H4)","value":"SUM(H4)","name":"H3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-8","rowIndex":2,"colIndex":8,"rowSpan":0,"colSpan":0,"label":"SUM(I4)","value":"SUM(I4)","name":"I3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-9","rowIndex":2,"colIndex":9,"rowSpan":0,"colSpan":0,"label":"SUM(J4)","value":"SUM(J4)","name":"J3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-10","rowIndex":2,"colIndex":10,"rowSpan":0,"colSpan":0,"label":"SUM(K4)","value":"SUM(K4)","name":"K3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-11","rowIndex":2,"colIndex":11,"rowSpan":0,"colSpan":0,"label":"SUM(L4)","value":"SUM(L4)","name":"L3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-12","rowIndex":2,"colIndex":12,"rowSpan":0,"colSpan":0,"label":"SUM(M4)","value":"SUM(M4)","name":"M3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-13","rowIndex":2,"colIndex":13,"rowSpan":0,"colSpan":0,"label":"SUM(N4)","value":"SUM(N4)","name":"N3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-14","rowIndex":2,"colIndex":14,"rowSpan":0,"colSpan":0,"label":"SUM(O4)","value":"SUM(O4)","name":"O3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-15","rowIndex":2,"colIndex":15,"rowSpan":0,"colSpan":0,"label":"SUM(P4)","value":"SUM(P4)","name":"P3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-2-16","rowIndex":2,"colIndex":16,"rowSpan":0,"colSpan":0,"label":"SUM(Q4)","value":"SUM(Q4)","name":"Q3","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":"#CCCCCC","verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-2","rowIndex":3,"colIndex":2,"rowSpan":0,"colSpan":0,"label":"S(设计任务列表.开始日期)","value":"S(设计任务列表.开始日期)","name":"C4","elementType":"COLUMN_DATA","expand":1,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-2-1","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":false,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"DATE","dateFormat":"yyyy-MM-dd"},"datasetId":2592258699,"datasetFieldName":"field3","datasetFieldId":2592259263,"dataSetting":"LIST","modelId":2592262018,"modelDatasetName":"CustomObject192"},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-3","rowIndex":3,"colIndex":3,"rowSpan":0,"colSpan":0,"label":"S(设计任务列表.结束日期)","value":"S(设计任务列表.结束日期)","name":"D4","elementType":"COLUMN_DATA","expand":1,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-2","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":false,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"DATE","dateFormat":"yyyy-MM-dd"},"datasetId":2592258699,"datasetFieldName":"field4","datasetFieldId":2592259304,"dataSetting":"LIST","modelId":2592262018,"modelDatasetName":"CustomObject192"},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-4","rowIndex":3,"colIndex":4,"rowSpan":0,"colSpan":0,"name":"E4","elementType":"SIMPLE_TEXT","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-5","rowIndex":3,"colIndex":5,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-01-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-01-01\') < \'2024-02-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-02-01\', FORMAT(DATEOFFSET(\'2024-02-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-01-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-01-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-01-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-02-01\', FORMAT(DATEOFFSET(\'2024-02-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-01-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-01-01\') < \'2024-02-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-02-01\', FORMAT(DATEOFFSET(\'2024-02-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-01-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-01-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-01-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-02-01\', FORMAT(DATEOFFSET(\'2024-02-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"F4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":false},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-6","rowIndex":3,"colIndex":6,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-02-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-02-01\') < \'2024-03-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-03-01\', FORMAT(DATEOFFSET(\'2024-03-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-02-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-02-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-02-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-03-01\', FORMAT(DATEOFFSET(\'2024-03-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-02-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-02-01\') < \'2024-03-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-03-01\', FORMAT(DATEOFFSET(\'2024-03-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-02-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-02-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-02-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-03-01\', FORMAT(DATEOFFSET(\'2024-03-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"G4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-7","rowIndex":3,"colIndex":7,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-03-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-03-01\') < \'2024-04-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-04-01\', FORMAT(DATEOFFSET(\'2024-04-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-03-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-03-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-03-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-04-01\', FORMAT(DATEOFFSET(\'2024-04-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-03-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-03-01\') < \'2024-04-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-04-01\', FORMAT(DATEOFFSET(\'2024-04-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-03-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-03-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-03-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-04-01\', FORMAT(DATEOFFSET(\'2024-04-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"H4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-8","rowIndex":3,"colIndex":8,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-04-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-04-01\') < \'2024-05-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-05-01\', FORMAT(DATEOFFSET(\'2024-05-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-04-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-04-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-04-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-05-01\', FORMAT(DATEOFFSET(\'2024-05-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-04-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-04-01\') < \'2024-05-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-05-01\', FORMAT(DATEOFFSET(\'2024-05-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-04-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-04-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-04-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-05-01\', FORMAT(DATEOFFSET(\'2024-05-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"I4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-9","rowIndex":3,"colIndex":9,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-05-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-05-01\') < \'2024-06-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-06-01\', FORMAT(DATEOFFSET(\'2024-06-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-05-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-05-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-05-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-06-01\', FORMAT(DATEOFFSET(\'2024-06-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-05-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-05-01\') < \'2024-06-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-06-01\', FORMAT(DATEOFFSET(\'2024-06-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-05-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-05-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-05-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-06-01\', FORMAT(DATEOFFSET(\'2024-06-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"J4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-10","rowIndex":3,"colIndex":10,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-06-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-06-01\') < \'2024-07-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-07-01\', FORMAT(DATEOFFSET(\'2024-07-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-06-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-06-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-06-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-07-01\', FORMAT(DATEOFFSET(\'2024-07-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-06-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-06-01\') < \'2024-07-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-07-01\', FORMAT(DATEOFFSET(\'2024-07-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-06-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-06-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-06-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-07-01\', FORMAT(DATEOFFSET(\'2024-07-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"K4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-11","rowIndex":3,"colIndex":11,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-07-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-07-01\') < \'2024-08-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-08-01\', FORMAT(DATEOFFSET(\'2024-08-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-07-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-07-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-07-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-08-01\', FORMAT(DATEOFFSET(\'2024-08-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-07-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-07-01\') < \'2024-08-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-08-01\', FORMAT(DATEOFFSET(\'2024-08-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-07-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-07-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-07-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-08-01\', FORMAT(DATEOFFSET(\'2024-08-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"L4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-12","rowIndex":3,"colIndex":12,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-08-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-08-01\') < \'2024-09-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-09-01\', FORMAT(DATEOFFSET(\'2024-09-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-08-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-08-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-08-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-09-01\', FORMAT(DATEOFFSET(\'2024-09-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-08-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-08-01\') < \'2024-09-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-09-01\', FORMAT(DATEOFFSET(\'2024-09-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-08-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-08-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-08-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-09-01\', FORMAT(DATEOFFSET(\'2024-09-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"M4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-13","rowIndex":3,"colIndex":13,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-09-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-09-01\') < \'2024-10-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-10-01\', FORMAT(DATEOFFSET(\'2024-10-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-09-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-09-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-09-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-10-01\', FORMAT(DATEOFFSET(\'2024-10-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-09-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-09-01\') < \'2024-10-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-10-01\', FORMAT(DATEOFFSET(\'2024-10-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-09-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-09-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-09-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-10-01\', FORMAT(DATEOFFSET(\'2024-10-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"N4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-14","rowIndex":3,"colIndex":14,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-10-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-10-01\') < \'2024-11-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-11-01\', FORMAT(DATEOFFSET(\'2024-11-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-10-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-10-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-10-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-11-01\', FORMAT(DATEOFFSET(\'2024-11-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-10-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-10-01\') < \'2024-11-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-11-01\', FORMAT(DATEOFFSET(\'2024-11-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-10-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-10-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-10-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-11-01\', FORMAT(DATEOFFSET(\'2024-11-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"O4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-15","rowIndex":3,"colIndex":15,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-11-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-11-01\') < \'2024-12-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-12-01\', FORMAT(DATEOFFSET(\'2024-12-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-11-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-11-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-11-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-12-01\', FORMAT(DATEOFFSET(\'2024-12-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-11-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-11-01\') < \'2024-12-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-12-01\', FORMAT(DATEOFFSET(\'2024-12-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-11-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-11-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-11-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2024-12-01\', FORMAT(DATEOFFSET(\'2024-12-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"P4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":true,"rightLine":false,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}},{"key":"0-7r0GNRFHq7uqz8qGT4D-3-16","rowIndex":3,"colIndex":16,"rowSpan":0,"colSpan":0,"label":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-12-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-12-01\') < \'2025-01-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2025-01-01\', FORMAT(DATEOFFSET(\'2025-01-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-12-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-12-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-12-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2025-01-01\', FORMAT(DATEOFFSET(\'2025-01-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","value":"IF(\nAND(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-12-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-12-01\') < \'2025-01-01\',\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2025-01-01\', FORMAT(DATEOFFSET(\'2025-01-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')) >= \'2024-12-01\'),\nDATEDIF(\nIF(FORMAT(C4, \'yyyy-MM-dd\') > \'2024-12-01\', FORMAT(C4, \'yyyy-MM-dd\'), \'2024-12-01\'),\nIF(FORMAT(D4, \'yyyy-MM-dd\') >= \'2025-01-01\', FORMAT(DATEOFFSET(\'2025-01-01\',\'D\',-1),\'yyyy-MM-dd\'), FORMAT(D4, \'yyyy-MM-dd\')), \'D\')\n+ 1, 0)","name":"Q4","elementType":"EXPRESSION","expand":0,"extend":3,"upParentKey":"","defaultUp":true,"leftParentKey":"0-7r0GNRFHq7uqz8qGT4D-3-3","defaultLeft":true,"fontConfig":{"name":"微软雅黑","heightInPoints":11,"bold":null,"italic":null,"underline":null,"strikeout":null,"color":null},"cellStyleConfig":{"backgroundColor":null,"verticalAlignment":null,"horizontalAlignment":null,"topLine":false,"rightLine":true,"bottomLine":true,"leftLine":true},"dataFormat":{"decimal":null,"type":"GENERIC","dateFormat":null}}],"calculate":true}],"reportFilterList":[],"reportFilterConfigList":[{"crossModelFilterConfigList":[],"curModelFilter":true,"dateFormat":"YMD","inputType":2,"key":"5b7a3c1b-6034-4daf-8927-6481f13fb2b5","label":"设计师","modelFilterField":{"datasetId":2592258699,"dateFormat":"YMD","fieldId":2592259232,"fieldName":"field2","index":0,"modelDatasetName":"CustomObject192","modelId":2592262018,"nativeType":"TEXT"},"modelId":2592262018,"opType":"eq","required":false,"sheetIds":["0-7r0GNRFHq7uqz8qGT4D"]}]}'

MegatronKing commented 6 days ago

@lipenghao1216 您好，感谢反馈，下个版本修复。

MegatronKing commented 5 days ago

@lipenghao1216 您好，请更新2.30.2试试，问题应该修复了。

lipenghao1216 commented 5 days ago

已经更新使用了，问题解决了😄，多谢