关于导出excel式样错乱

收藏

为什么我导出excel的样式会乱这是我页面样式 image.png872866210.png

这是我导出后的样式

这是我的代码

这是我引用的js和css image.png303815612.png

Clark.Pan · Clark.Pan

您提供一下您序列化的ssjson,我帮您看一下，另外您用的是什么版本的？

simon1043 · simon1043

7)"},"4":{"value":416455.64622,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(E2:E7)"},"5":{"value":432626.805947974,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F2:F7)"},"6":{"value":454839.044515285,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(G2:G7)"},"7":{"value":474120.052565145,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H2:H7)"},"8":{"value":0,"style":{"hAlign":2,"formatter":"#,##0","locked":true},"formula":"SUM(I2:I7)"},"9":{"value":474120.052565145,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J2:J7)"},"10":{"value":19281.0080498601,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(K2:K7)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":0.095910022325711,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J8)=\"\",TRIM(F8)=\"\",SUM(J8)*SUM(F8)=0),\" \",SUM(J8)/IF(SUM(F8)=0,1,SUM(F8))-1)"},"13":{"value":"0.0921943380","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":0.201957022582881,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F8)=\"\",TRIM(C8)=\"\",SUM(F8)*SUM(C8)=0),\" \",SUM(F8)/IF(SUM(C8)=0,1,SUM(C8))-1)"},"15":{"value":0.212905957351742,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C8)=\"\",TRIM(B8)=\"\",SUM(C8)*SUM(B8)=0),\" \",SUM(C8)/IF(SUM(B8)=0,1,SUM(B8))-1)"},"16":{"value":0.147709347985521,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C8)=\"\",TRIM(J8)=\"\",SUM(C8)*SUM(J8)<=0),\" \",SUM(POWER(SUM(J8)/IF(SUM(C8)=0,1,SUM(C8)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"19":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"20":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"21":{"style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"23":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"24":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"25":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"8":{"0":{"value":"IGT Eq."},"1":{"value":"114956.9611617830","style":{"hAlign":2,"formatter":"#,##0"}},"2":{"value":"145571.0646982250","style":{"hAlign":2,"formatter":"#,##0"}},"3":{"value":"152237.2096300000","style":{"hAlign":2,"formatter":"#,##0"}},"4":{"value":"160087.1549000000","style":{"hAlign":2,"formatter":"#,##0"}},"5":{"value":"162242.0527183488","style":{"hAlign":2,"formatter":"#,##0"}},"6":{"value":"173099.7536071910","style":{"hAlign":2,"formatter":"#,##0"}},"7":{"value":175429.811141613,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F9)*SUM(1,N9)"},"8":{"style":{"hAlign":2,"formatter":"#,##0","locked":false}},"9":{"value":175429.811141613,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H9,I9)"},"10":{"value":2330.057534422,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J9,-G9)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":0.081284464799999,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J9)=\"\",TRIM(F9)=\"\",SUM(J9)*SUM(F9)=0),\" \",SUM(J9)/IF(SUM(F9)=0,1,SUM(F9))-1)"},"13":{"value":"0.0812844648","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":0.114521303080962,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F9)=\"\",TRIM(C9)=\"\",SUM(F9)*SUM(C9)=0),\" \",SUM(F9)/IF(SUM(C9)=0,1,SUM(C9))-1)"},"15":{"value":0.266309262414807,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C9)=\"\",TRIM(B9)=\"\",SUM(C9)*SUM(B9)=0),\" \",SUM(C9)/IF(SUM(B9)=0,1,SUM(B9))-1)"},"16":{"value":0.097777104293078,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C9)=\"\",TRIM(J9)=\"\",SUM(C9)*SUM(J9)<=0),\" \",SUM(POWER(SUM(J9)/IF(SUM(C9)=0,1,SUM(C9)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"value":"0.3285128986","style":{"hAlign":2,"formatter":"0.0%"}},"19":{"value":"0.3231186384","style":{"hAlign":2,"formatter":"0.0%"}},"20":{"value":"0.2863929104","style":{"hAlign":2,"formatter":"0.0%"}},"21":{"value":"530060.6389885070","style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":0.330961777272084,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(V9)=\"\",TRIM(J9)=\"\",SUM(V9)*SUM(J9)=0),\" \",SUM(J9)/IF(SUM(V9)=0,1,SUM(V9)))"},"23":{"value":0.007843138872084,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(W9)=\"\",TRIM(T9)=\"\"),\" \",SUM(W9,-T9))"},"24":{"value":"0.0006645942","style":{"hAlign":2,"formatter":"0.0%"}},"25":{"style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"9":{"0":{"value":"Ultra Eq."},"1":{"value":"258885.1386744340","style":{"hAlign":2,"formatter":"#,##0"}},"2":{"value":"278510.4827789430","style":{"hAlign":2,"formatter":"#,##0"}},"3":{"value":"293670.0000500000","style":{"hAlign":2,"formatter":"#,##0"}},"4":{"value":"299747.4332200000","style":{"hAlign":2,"formatter":"#,##0"}},"5":{"value":"301747.1648721064","style":{"hAlign":2,"formatter":"#,##0"}},"6":{"value":"322819.5382570000","style":{"hAlign":2,"formatter":"#,##0"}},"7":{"value":324973.192909706,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F10)*SUM(1,N10)"},"8":{"style":{"hAlign":2,"formatter":"#,##0","locked":false}},"9":{"value":324973.192909706,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H10,I10)"},"10":{"value":2153.654652706,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J10,-G10)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":0.076971818599998,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J10)=\"\",TRIM(F10)=\"\",SUM(J10)*SUM(F10)=0),\" \",SUM(J10)/IF(SUM(F10)=0,1,SUM(F10))-1)"},"13":{"value":"0.0769718186","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":0.083431983820898,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F10)=\"\",TRIM(C10)=\"\",SUM(F10)*SUM(C10)=0),\" \",SUM(F10)/IF(SUM(C10)=0,1,SUM(C10))-1)"},"15":{"value":0.075807148316803,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C10)=\"\",TRIM(B10)=\"\",SUM(C10)*SUM(B10)=0),\" \",SUM(C10)/IF(SUM(B10)=0,1,SUM(B10))-1)"},"16":{"value":0.08019707180912,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C10)=\"\",TRIM(J10)=\"\",SUM(C10)*SUM(J10)<=0),\" \",SUM(POWER(SUM(J10)/IF(SUM(C10)=0,1,SUM(C10)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"value":"0.2535287069","style":{"hAlign":2,"formatter":"0.0%"}},"19":{"value":"0.2667105957","style":{"hAlign":2,"formatter":"0.0%"}},"20":{"value":"0.2415742795","style":{"hAlign":2,"formatter":"0.0%"}},"21":{"value":"1269794.8510685600","style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":0.255925744726586,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(V10)=\"\",TRIM(J10)=\"\",SUM(V10)*SUM(J10)=0),\" \",SUM(J10)/IF(SUM(V10)=0,1,SUM(V10)))"},"23":{"value":-0.010784850973414,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(W10)=\"\",TRIM(T10)=\"\"),\" \",SUM(W10,-T10))"},"24":{"value":"0.0014476264","style":{"hAlign":2,"formatter":"0.0%"}},"25":{"style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"10":{"0":{"value":" MA Eq."},"1":{"value":"101021.0565052490","style":{"hAlign":2,"formatter":"#,##0"}},"2":{"value":"89356.1578975891","style":{"hAlign":2,"formatter":"#,##0"}},"3":{"value":"125691.0185300000","style":{"hAlign":2,"formatter":"#,##0"}},"4":{"value":"100700.4045600000","style":{"hAlign":2,"formatter":"#,##0"}},"5":{"value":"88689.8988498990","style":{"hAlign":2,"formatter":"#,##0"}},"6":{"value":"110771.8607228180","style":{"hAlign":2,"formatter":"#,##0"}},"7":{"value":97560.1355818319,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F11)*SUM(1,N11)"},"8":{"style":{"hAlign":2,"formatter":"#,##0","locked":false}},"9":{"value":97560.1355818319,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H11,I11)"},"10":{"value":-13211.7251409861,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J11,-G11)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":0.1000140585,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J11)=\"\",TRIM(F11)=\"\",SUM(J11)*SUM(F11)=0),\" \",SUM(J11)/IF(SUM(F11)=0,1,SUM(F11))-1)"},"13":{"value":"0.1000140585","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":-0.007456218612865,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F11)=\"\",TRIM(C11)=\"\",SUM(F11)*SUM(C11)=0),\" \",SUM(F11)/IF(SUM(C11)=0,1,SUM(C11))-1)"},"15":{"value":-0.11546997241168,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C11)=\"\",TRIM(B11)=\"\",SUM(C11)*SUM(B11)=0),\" \",SUM(C11)/IF(SUM(B11)=0,1,SUM(B11))-1)"},"16":{"value":0.044898135323534,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C11)=\"\",TRIM(J11)=\"\",SUM(C11)*SUM(J11)<=0),\" \",SUM(POWER(SUM(J11)/IF(SUM(C11)=0,1,SUM(C11)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"value":"0.2008045030","style":{"hAlign":2,"formatter":"0.0%"}},"19":{"style":{"hAlign":2,"formatter":"0.0%"}},"20":{"value":"0.1518962902","style":{"hAlign":2,"formatter":"0.0%"}},"21":{"style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(V11)=\"\",TRIM(J11)=\"\",SUM(V11)*SUM(J11)=0),\" \",SUM(J11)/IF(SUM(V11)=0,1,SUM(V11)))"},"23":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(W11)=\"\",TRIM(T11)=\"\"),\" \",SUM(W11,-T11))"},"24":{"value":"0.0067396724","style":{"hAlign":2,"formatter":"0.0%"}},"25":{"style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"11":{"0":{"value":" ECR(excl HRC Eq.)"},"1":{"value":"0.0000000000","style":{"hAlign":2,"formatter":"#,##0"}},"2":{"value":"22069.5250163279","style":{"hAlign":2,"formatter":"#,##0"}},"3":{"style":{"hAlign":2,"formatter":"#,##0"}},"4":{"value":"235.2473300000","style":{"hAlign":2,"formatter":"#,##0"}},"5":{"value":"12333.2092387977","style":{"hAlign":2,"formatter":"#,##0"}},"6":{"value":"18350.4594957145","style":{"hAlign":2,"formatter":"#,##0"}},"7":{"value":86436.631196079,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F12)*SUM(1,N12)"},"8":{"style":{"hAlign":2,"formatter":"#,##0","locked":false}},"9":{"value":86436.631196079,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H12,I12)"},"10":{"value":68086.1717003645,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J12,-G12)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":6.0084460194,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J12)=\"\",TRIM(F12)=\"\",SUM(J12)*SUM(F12)=0),\" \",SUM(J12)/IF(SUM(F12)=0,1,SUM(F12))-1)"},"13":{"value":"6.0084460194","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":-0.441165624105045,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F12)=\"\",TRIM(C12)=\"\",SUM(F12)*SUM(C12)=0),\" \",SUM(F12)/IF(SUM(C12)=0,1,SUM(C12))-1)"},"15":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C12)=\"\",TRIM(B12)=\"\",SUM(C12)*SUM(B12)=0),\" \",SUM(C12)/IF(SUM(B12)=0,1,SUM(B12))-1)"},"16":{"value":0.979030206248727,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C12)=\"\",TRIM(J12)=\"\",SUM(C12)*SUM(J12)<=0),\" \",SUM(POWER(SUM(J12)/IF(SUM(C12)=0,1,SUM(C12)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"value":"0.2167158027","style":{"hAlign":2,"formatter":"0.0%"}},"19":{"style":{"hAlign":2,"formatter":"0.0%"}},"20":{"value":"0.1903586646","style":{"hAlign":2,"formatter":"0.0%"}},"21":{"style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(V12)=\"\",TRIM(J12)=\"\",SUM(V12)*SUM(J12)=0),\" \",SUM(J12)/IF(SUM(V12)=0,1,SUM(V12)))"},"23":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(W12)=\"\",TRIM(T12)=\"\"),\" \",SUM(W12,-T12))"},"24":{"value":"0.1878630641","style":{"hAlign":2,"formatter":"0.0%"}},"25":{"style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"12":{"0":{"value":" HRC Equip"},"1":{"value":"37264.8909582875","style":{"hAlign":2,"formatter":"#,##0"}},"2":{"value":"12773.1984962508","style":{"hAlign":2,"formatter":"#,##0"}},"3":{"value":"10950.0500000000","style":{"hAlign":2,"formatter":"#,##0"}},"4":{"value":"11546.4109700000","style":{"hAlign":2,"formatter":"#,##0"}},"5":{"value":"11229.5046527019","style":{"hAlign":2,"formatter":"#,##0"}},"6":{"value":"11836.0003323268","style":{"hAlign":2,"formatter":"#,##0"}},"7":{"value":11511.145858972,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F13)*SUM(1,N13)"},"8":{"style":{"hAlign":2,"formatter":"#,##0","locked":false}},"9":{"value":11511.145858972,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H13,I13)"},"10":{"value":-324.854473354799,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J13,-G13)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":0.025080465700002,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J13)=\"\",TRIM(F13)=\"\",SUM(J13)*SUM(F13)=0),\" \",SUM(J13)/IF(SUM(F13)=0,1,SUM(F13))-1)"},"13":{"value":"0.0250804657","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":-0.120854134068456,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F13)=\"\",TRIM(C13)=\"\",SUM(F13)*SUM(C13)=0),\" \",SUM(F13)/IF(SUM(C13)=0,1,SUM(C13))-1)"},"15":{"value":-0.657232366235863,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C13)=\"\",TRIM(B13)=\"\",SUM(C13)*SUM(B13)=0),\" \",SUM(C13)/IF(SUM(B13)=0,1,SUM(B13))-1)"},"16":{"value":-0.050686956969758,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C13)=\"\",TRIM(J13)=\"\",SUM(C13)*SUM(J13)<=0),\" \",SUM(POWER(SUM(J13)/IF(SUM(C13)=0,1,SUM(C13)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"style":{"hAlign":2,"formatter":"0.0%"}},"19":{"style":{"hAlign":2,"formatter":"0.0%"}},"20":{"value":"0.0367918635","style":{"hAlign":2,"formatter":"0.0%"}},"21":{"style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(V13)=\"\",TRIM(J13)=\"\",SUM(V13)*SUM(J13)=0),\" \",SUM(J13)/IF(SUM(V13)=0,1,SUM(V13)))"},"23":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(W13)=\"\",TRIM(T13)=\"\"),\" \",SUM(W13,-T13))"},"24":{"value":"0.0006331941","style":{"hAlign":2,"formatter":"0.0%"}},"25":{"style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"13":{"0":{"value":"

CMS Eq."},"1":{"value":138285.947463536,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(B11:B13)"},"2":{"value":124198.881410168,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(C11:C13)"},"3":{"value":136641.06853,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(D11

13)"},"4":{"value":112482.06286,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(E11:E13)"},"5":{"value":112252.612741399,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F11:F13)"},"6":{"value":140958.320550859,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(G11:G13)"},"7":{"value":195507.912636883,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H11:H13)"},"8":{"value":0,"style":{"hAlign":2,"formatter":"#,##0","locked":true},"formula":"SUM(I11:I13)"},"9":{"value":195507.912636883,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J11:J13)"},"10":{"value":54549.5920860236,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(K11:K13)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":0.741678058641563,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J14)=\"\",TRIM(F14)=\"\",SUM(J14)*SUM(F14)=0),\" \",SUM(J14)/IF(SUM(F14)=0,1,SUM(F14))-1)"},"13":{"value":"0.2531626552","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":-0.096186604364949,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F14)=\"\",TRIM(C14)=\"\",SUM(F14)*SUM(C14)=0),\" \",SUM(F14)/IF(SUM(C14)=0,1,SUM(C14))-1)"},"15":{"value":-0.101869107539525,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C14)=\"\",TRIM(B14)=\"\",SUM(C14)*SUM(B14)=0),\" \",SUM(C14)/IF(SUM(B14)=0,1,SUM(B14))-1)"},"16":{"value":0.25465212719857,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C14)=\"\",TRIM(J14)=\"\",SUM(C14)*SUM(J14)<=0),\" \",SUM(POWER(SUM(J14)/IF(SUM(C14)=0,1,SUM(C14)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"value":"0.1470000000","style":{"hAlign":2,"formatter":"0.0%"}},"19":{"value":"0.1493759649","style":{"hAlign":2,"formatter":"0.0%"}},"20":{"style":{"hAlign":2,"formatter":"0.0%"}},"21":{"value":"754291.2947658340","style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":0.25919417868607,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(V14)=\"\",TRIM(J14)=\"\",SUM(V14)*SUM(J14)=0),\" \",SUM(J14)/IF(SUM(V14)=0,1,SUM(V14)))"},"23":{"value":0.10981821378607,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(W14)=\"\",TRIM(T14)=\"\"),\" \",SUM(W14,-T14))"},"24":{"style":{"hAlign":2,"formatter":"0.0%"}},"25":{"style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"14":{"0":{"value":"HI Eq."},"1":{"value":"12755.8907065867","style":{"hAlign":2,"formatter":"#,##0"}},"2":{"value":"18598.3840291576","style":{"hAlign":2,"formatter":"#,##0"}},"3":{"value":"21340.6412900000","style":{"hAlign":2,"formatter":"#,##0"}},"4":{"value":"21017.5118600000","style":{"hAlign":2,"formatter":"#,##0"}},"5":{"value":"17806.7496322454","style":{"hAlign":2,"formatter":"#,##0"}},"6":{"value":"23160.2781873798","style":{"hAlign":2,"formatter":"#,##0"}},"7":{"value":19622.1740133051,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F15)*SUM(1,N15)"},"8":{"style":{"hAlign":2,"formatter":"#,##0","locked":false}},"9":{"value":19622.1740133051,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H15,I15)"},"10":{"value":-3538.1041740747,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J15,-G15)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":0.101951474499997,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J15)=\"\",TRIM(F15)=\"\",SUM(J15)*SUM(F15)=0),\" \",SUM(J15)/IF(SUM(F15)=0,1,SUM(F15))-1)"},"13":{"value":"0.1019514745","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":-0.042564687107822,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F15)=\"\",TRIM(C15)=\"\",SUM(F15)*SUM(C15)=0),\" \",SUM(F15)/IF(SUM(C15)=0,1,SUM(C15))-1)"},"15":{"value":0.458023156278224,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C15)=\"\",TRIM(B15)=\"\",SUM(C15)*SUM(B15)=0),\" \",SUM(C15)/IF(SUM(B15)=0,1,SUM(B15))-1)"},"16":{"value":0.027154932218067,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C15)=\"\",TRIM(J15)=\"\",SUM(C15)*SUM(J15)<=0),\" \",SUM(POWER(SUM(J15)/IF(SUM(C15)=0,1,SUM(C15)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"style":{"hAlign":2,"formatter":"0.0%"}},"19":{"style":{"hAlign":2,"formatter":"0.0%"}},"20":{"value":"0.0358238004","style":{"hAlign":2,"formatter":"0.0%"}},"21":{"style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(V15)=\"\",TRIM(J15)=\"\",SUM(V15)*SUM(J15)=0),\" \",SUM(J15)/IF(SUM(V15)=0,1,SUM(V15)))"},"23":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(W15)=\"\",TRIM(T15)=\"\"),\" \",SUM(W15,-T15))"},"24":{"value":"0.0007754769","style":{"hAlign":2,"formatter":"0.0%"}},"25":{"style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"15":{"0":{"value":"

HM(excl.PHS)"},"1":{"value":"0.0000000000","style":{"hAlign":2,"formatter":"#,##0"}},"2":{"value":"0.0000000000","style":{"hAlign":2,"formatter":"#,##0"}},"3":{"style":{"hAlign":2,"formatter":"#,##0"}},"4":{"value":"0.0000000000","style":{"hAlign":2,"formatter":"#,##0"}},"5":{"style":{"hAlign":2,"formatter":"#,##0"}},"6":{"value":"0.0000000000","style":{"hAlign":2,"formatter":"#,##0"}},"7":{"value":0,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F16)*SUM(1,N16)"},"8":{"style":{"hAlign":2,"formatter":"#,##0","locked":false}},"9":{"value":0,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H16,I16)"},"10":{"value":0,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J16,-G16)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J16)=\"\",TRIM(F16)=\"\",SUM(J16)*SUM(F16)=0),\" \",SUM(J16)/IF(SUM(F16)=0,1,SUM(F16))-1)"},"13":{"value":"0.0000000000","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F16)=\"\",TRIM(C16)=\"\",SUM(F16)*SUM(C16)=0),\" \",SUM(F16)/IF(SUM(C16)=0,1,SUM(C16))-1)"},"15":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C16)=\"\",TRIM(B16)=\"\",SUM(C16)*SUM(B16)=0),\" \",SUM(C16)/IF(SUM(B16)=0,1,SUM(B16))-1)"},"16":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C16)=\"\",TRIM(J16)=\"\",SUM(C16)*SUM(J16)<=0),\" \",SUM(POWER(SUM(J16)/IF(SUM(C16)=0,1,SUM(C16)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"style":{"hAlign":2,"formatter":"0.0%"}},"19":{"style":{"hAlign":2,"formatter":"0.0%"}},"20":{"style":{"hAlign":2,"formatter":"0.0%"}},"21":{"style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(V16)=\"\",TRIM(J16)=\"\",SUM(V16)*SUM(J16)=0),\" \",SUM(J16)/IF(SUM(V16)=0,1,SUM(V16)))"},"23":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(W16)=\"\",TRIM(T16)=\"\"),\" \",SUM(W16,-T16))"},"24":{"style":{"hAlign":2,"formatter":"0.0%"}},"25":{"style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"16":{"0":{"value":"CC&HI Platform"},"1":{"value":"686.2196424005","style":{"hAlign":2,"formatter":"#,##0"}},"2":{"value":"1015.2554398541","style":{"hAlign":2,"formatter":"#,##0"}},"3":{"value":"2368.7947400000","style":{"hAlign":2,"formatter":"#,##0"}},"4":{"value":"341.3450000000","style":{"hAlign":2,"formatter":"#,##0"}},"5":{"value":"592.7493779268","style":{"hAlign":2,"formatter":"#,##0"}},"6":{"value":"977.0967478321","style":{"hAlign":2,"formatter":"#,##0"}},"7":{"value":1696.7393176764,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F17)*SUM(1,N17)"},"8":{"style":{"hAlign":2,"formatter":"#,##0","locked":false}},"9":{"value":1696.7393176764,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H17,I17)"},"10":{"value":719.6425698443,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J17,-G17)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":1.8624902545,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J17)=\"\",TRIM(F17)=\"\",SUM(J17)*SUM(F17)=0),\" \",SUM(J17)/IF(SUM(F17)=0,1,SUM(F17))-1)"},"13":{"value":"1.8624902545","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":-0.416157397775694,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F17)=\"\",TRIM(C17)=\"\",SUM(F17)*SUM(C17)=0),\" \",SUM(F17)/IF(SUM(C17)=0,1,SUM(C17))-1)"},"15":{"value":0.479490497098834,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C17)=\"\",TRIM(B17)=\"\",SUM(C17)*SUM(B17)=0),\" \",SUM(C17)/IF(SUM(B17)=0,1,SUM(B17))-1)"},"16":{"value":0.292765933581556,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C17)=\"\",TRIM(J17)=\"\",SUM(C17)*SUM(J17)<=0),\" \",SUM(POWER(SUM(J17)/IF(SUM(C17)=0,1,SUM(C17)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"style":{"hAlign":2,"formatter":"0.0%"}},"19":{"style":{"hAlign":2,"formatter":"0.0%"}},"20":{"style":{"hAlign":2,"formatter":"0.0%"}},"21":{"style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(V17)=\"\",TRIM(J17)=\"\",SUM(V17)*SUM(J17)=0),\" \",SUM(J17)/IF(SUM(V17)=0,1,SUM(V17)))"},"23":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(W17)=\"\",TRIM(T17)=\"\"),\" \",SUM(W17,-T17))"},"24":{"style":{"hAlign":2,"formatter":"0.0%"}},"25":{"style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"17":{"0":{"value":"HS Equip"},"1":{"value":822324.687370761,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(B8,B9,B10,B14,B15,B16,B17)"},"2":{"value":927829.405327302,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(C8,C9,C10,C14,C15,C16,C17)"},"3":{"value":1009823.6666,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(D8,D9,D10,D14,D15,D16,D17)"},"4":{"value":1010131.15406,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(E8,E9,E10,E14,E15,E16,E17)"},"5":{"value":1027268.13529,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F8,F9,F10,F14,F15,F16,F17)"},"6":{"value":1115854.03186555,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(G8,G9,G10,G14,G15,G16,G17)"},"7":{"value":1191349.88258433,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H8,H9,H10,H14,H15,H16,H17)"},"8":{"value":0,"style":{"hAlign":2,"formatter":"#,##0","locked":true},"formula":"SUM(I8,I9,I10,I14,I15,I16,I17)"},"9":{"value":1191349.88258433,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J8,J9,J10,J14,J15,J16,J17)"},"10":{"value":75495.8507187813,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(K8,K9,K10,K14,K15,K16,K17)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":0.159726308699344,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J18)=\"\",TRIM(F18)=\"\",SUM(J18)*SUM(F18)=0),\" \",SUM(J18)/IF(SUM(F18)=0,1,SUM(F18))-1)"},"13":{"value":"0.1020924739","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":0.107173505594619,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F18)=\"\",TRIM(C18)=\"\",SUM(F18)*SUM(C18)=0),\" \",SUM(F18)/IF(SUM(C18)=0,1,SUM(C18))-1)"},"15":{"value":0.128300560079102,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C18)=\"\",TRIM(B18)=\"\",SUM(C18)*SUM(B18)=0),\" \",SUM(C18)/IF(SUM(B18)=0,1,SUM(B18))-1)"},"16":{"value":0.133145287565968,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C18)=\"\",TRIM(J18)=\"\",SUM(C18)*SUM(J18)<=0),\" \",SUM(POWER(SUM(J18)/IF(SUM(C18)=0,1,SUM(C18)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"19":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"20":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"21":{"style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"23":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"24":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"25":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"18":{"0":{"value":"Customer Service"},"1":{"value":"301021.5252393560","style":{"hAlign":2,"formatter":"#,##0"}},"2":{"value":"283875.8954088880","style":{"hAlign":2,"formatter":"#,##0"}},"3":{"value":"295226.0000900000","style":{"hAlign":2,"formatter":"#,##0"}},"4":{"value":"321824.9491100000","style":{"hAlign":2,"formatter":"#,##0"}},"5":{"value":"322914.5324401839","style":{"hAlign":2,"formatter":"#,##0"}},"6":{"value":"347082.1169624970","style":{"hAlign":2,"formatter":"#,##0"}},"7":{"value":348257.211982338,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F19)*SUM(1,N19)"},"8":{"style":{"hAlign":2,"formatter":"#,##0","locked":false}},"9":{"value":348257.211982338,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H19,I19)"},"10":{"value":1175.09501984098,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J19,-G19)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":0.078481074700001,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J19)=\"\",TRIM(F19)=\"\",SUM(J19)*SUM(F19)=0),\" \",SUM(J19)/IF(SUM(F19)=0,1,SUM(F19))-1)"},"13":{"value":"0.0784810747","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":0.137520084172929,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F19)=\"\",TRIM(C19)=\"\",SUM(F19)*SUM(C19)=0),\" \",SUM(F19)/IF(SUM(C19)=0,1,SUM(C19))-1)"},"15":{"value":-0.056958152134917,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C19)=\"\",TRIM(B19)=\"\",SUM(C19)*SUM(B19)=0),\" \",SUM(C19)/IF(SUM(B19)=0,1,SUM(B19))-1)"},"16":{"value":0.107607278267734,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C19)=\"\",TRIM(J19)=\"\",SUM(C19)*SUM(J19)<=0),\" \",SUM(POWER(SUM(J19)/IF(SUM(C19)=0,1,SUM(C19)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"style":{"hAlign":2,"formatter":"0.0%"}},"19":{"style":{"hAlign":2,"formatter":"0.0%"}},"20":{"style":{"hAlign":2,"formatter":"0.0%"}},"21":{"style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(V19)=\"\",TRIM(J19)=\"\",SUM(V19)*SUM(J19)=0),\" \",SUM(J19)/IF(SUM(V19)=0,1,SUM(V19)))"},"23":{"value":" ","style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(W19)=\"\",TRIM(T19)=\"\"),\" \",SUM(W19,-T19))"},"24":{"style":{"hAlign":2,"formatter":"0.0%"}},"25":{"value":0.212642644598364,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(SUM(V2,V3,V9)*SUM(J2,J3,J9)=0,\" \",SUM(J2,J3,J9)/IF(SUM(V2,V3,V9)=0,1,SUM(V2,V3,V9)))"},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}},"19":{"0":{"value":"Health Systems"},"1":{"value":1123346.21261012,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(B18,B19)"},"2":{"value":1211705.30073619,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(C18,C19)"},"3":{"value":1305049.66669,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(D18,D19)"},"4":{"value":1331956.10317,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(E18,E19)"},"5":{"value":1350182.66773018,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(F18,F19)"},"6":{"value":1462936.14882805,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(G18,G19)"},"7":{"value":1539607.09456667,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(H18,H19)"},"8":{"value":0,"style":{"hAlign":2,"formatter":"#,##0","locked":true},"formula":"SUM(I18,I19)"},"9":{"value":1539607.09456667,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(J18,J19)"},"10":{"value":76670.9457386223,"style":{"hAlign":2,"formatter":"#,##0"},"formula":"SUM(K18,K19)"},"11":{"value":"","style":{"hAlign":2}},"12":{"value":0.140295406957738,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(J20)=\"\",TRIM(F20)=\"\",SUM(J20)*SUM(F20)=0),\" \",SUM(J20)/IF(SUM(F20)=0,1,SUM(F20))-1)"},"13":{"value":"0.0963975997","style":{"hAlign":2,"formatter":"0.0%"}},"14":{"value":0.114283041354904,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(F20)=\"\",TRIM(C20)=\"\",SUM(F20)*SUM(C20)=0),\" \",SUM(F20)/IF(SUM(C20)=0,1,SUM(C20))-1)"},"15":{"value":0.078657040130812,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C20)=\"\",TRIM(B20)=\"\",SUM(C20)*SUM(B20)=0),\" \",SUM(C20)/IF(SUM(B20)=0,1,SUM(B20))-1)"},"16":{"value":0.127214191761218,"style":{"hAlign":2,"formatter":"0.0%"},"formula":"IF(OR(TRIM(C20)=\"\",TRIM(J20)=\"\",SUM(C20)*SUM(J20)<=0),\" \",SUM(POWER(SUM(J20)/IF(SUM(C20)=0,1,SUM(C20)),1/2),-1))"},"17":{"value":"","style":{"hAlign":2}},"18":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"19":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"20":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"21":{"style":{"hAlign":2,"formatter":"#,##0"}},"22":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"23":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"24":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"25":{"value":"","style":{"hAlign":2,"formatter":"0.0%"}},"26":{"value":"","style":{"hAlign":2}},"27":{"value":"","style":{"hAlign":2}},"28":{"value":"","style":{"hAlign":2}},"29":{"value":"","style":{"hAlign":2}},"30":{"value":"","style":{"hAlign":2}}}},"rowDataArray":[null,{"style":{"font":"italic 13.3333px Arial"}},{"style":{"font":"italic 13.3333px Arial"}},{"style":{"font":"italic 13.3333px Arial"}},{"style":{"font":"italic 13.3333px Arial"}},{"style":{"font":"italic 13.3333px Arial"}},{"style":{"font":"italic 13.3333px Arial"}},{"style":{"font":"700 13.3333px Arial","textDecoration":1}},null,null,{"style":{"font":"italic 13.3333px Arial"}},{"style":{"font":"italic 13.3333px Arial"}},{"style":{"font":"italic 13.3333px Arial"}},{"style":{"font":"700 13.3333px Arial","textDecoration":1}},null,null,null,{"style":{"font":"700 13.3333px Arial","textDecoration":1}},null,{"style":{"font":"700 13.3333px Arial","textDecoration":1}}],"columnDataArray":[null,null,null,null,null,null,null,null,{"style":{"backColor":"#ffffcc"}},{"style":{"backColor":"#B7DEE8"}},null,null,{"style":{"backColor":"#B7DEE8"}},{"style":{"backColor":"#DCDEE8"}}],"defaultDataNode":{"style":{"themeFont":"Body"}}},"rowHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"colHeaderData":{"defaultDataNode":{"style":{"themeFont":"Body"}}},"selections":{"0":{"row":0,"rowCount":1,"col":0,"colCount":1},"length":1},"columns":[{"size":150},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":30},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":30},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":100},{"size":30},{"size":30},{"size":30},{"size":30},{"size":30}],"columnOutlines":{"itemsData":[{"index":1,"count":4,"info":{"level":0,"collapsed":false}},{"index":5,"count":1,"info":{"level":-1,"collapsed":true}},{"index":20,"count":1,"info":{"level":0,"collapsed":false}},{"index":21,"count":1,"info":{"level":-1,"collapsed":true}},{"index":24,"count":7,"info":{"level":0,"collapsed":false}},{"index":31,"count":1,"info":{"level":-1,"collapsed":true}}],"tail":{"level":0,"collapsed":true,"viewCollapsed":false}},"isProtected":true,"index":0}}}

simon1043 · simon1043

var ssjson = JSON.stringify(spread.toJSON();)
这是用这个方法取出来的值你说的ssjson是这个么
怎么看版本

Clark.Pan · Clark.Pan

您好：

这个问题已经重现并且反馈给开发了，原因需要进行调查，有结果了会第一时间向您回复。

Clark.Pan · Clark.Pan

您好：

这个问题已经确认是产品本身的一个BUG，是列样式的问题，研发那边需要讨论制定修复策略，我这边会继续跟进，如果有进一步的信息我会第一时间向您进行反馈。

simon1043 · simon1043

您好这个样式bug还没修复么什么时候能修复呢

Clark.Pan · Clark.Pan

columnstyle的问题，这个问题修复最快要到SP2版本了，也就是今年的8~9月，临时解决方法就是将您设置的列样式在导出前全部转换设置到单元格上。

simon1043 · simon1043

对于单元格样式来说只允许设置一种再设置会替换样式而单元格样式与行样式活列样式却不冲突对么

simon1043 · simon1043

我现在将背景色改成单元格设置可以但会出现已设置的样式无效

		自动登录	找回密码
密码			立即注册

[已处理] 关于导出excel式样错乱

17 个回复

讲师达人

悬赏达人

微信认证勋章

SpreadJS 认证

SpreadJS 高级认证

元老葡萄