https://www.psytech.ro/_next/static/chunks/37023856.efac39af95aff7d9.js

1"use strict";(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[9191],{86318:(e,t,n)=>{n.d(t,{LZ:()=>eY,ZG:()=>eM});var r=n(94867),i=n(69809),l=n(92885),o=n(36664),s=n(52661),u=n(98256),a=n(16975),c=n(50633),d=n(66096),h=n(97561),f=n(94123),g=n(33751),m=n(57438),v=n(93609),p=n(51846),S=n(13099),_=n(83376),y=n(35835),C=n(12115),b=n(95155),R=n(59504),x=n(55966),E=n(78855),I=n(75308),N=n(69405),w=n(60520),k=n(42876);let T={id:"sheet.command.copy-formula-only",type:r.g4t.COMMAND,handler:async e=>e.get(i.udt).copy({copyHookType:i.vfe.SPECIAL_COPY_FORMULA_ONLY})},M={id:"sheet.command.paste-formula",type:r.g4t.COMMAND,handler:async e=>e.get(r.wTY).executeCommand(i.Wy2.id,{value:i.bYT.SPECIAL_PASTE_FORMULA})};function O(e){return(O="function"==typeof Symbol&&"symbol"==typeof Symbol.iterator?function(e){return typeof e}:function(e){return e&&"function"==typeof Symbol&&e.constructor===Symbol&&e!==Symbol.prototype?"symbol":typeof e})(e)}function D(e,t,n){var r;return(r=function(e,t){if("object"!=O(e)||!e)return e;var n=e[Symbol.toPrimitive];if(void 0!==n){var r=n.call(e,t||"default");if("object"!=O(r))return r;throw TypeError("@@toPrimitive must return a primitive value.")}return("string"===t?String:Number)(e)}(t,"string"),(t="symbol"==O(r)?r:r+"")in e)?Object.defineProperty(e,t,{value:n,enumerable:!0,configurable:!0,writable:!0}):e[t]=n,e}function F(e,t){return function(n,r){t(n,r,e)}}function $(e,t,n,r){var i,l=arguments.length,o=l<3?t:null===r?r=Object.getOwnPropertyDescriptor(t,n):r;if("object"==typeof Reflect&&"function"==typeof Reflect.decorate)o=Reflect.decorate(e,t,n,r);else for(var s=e.length-1;s>=0;s--)(i=e[s])&&(o=(l<3?i(o):l>3?i(t,n,o):i(t,n))||o);return l>3&&o&&Object.defineProperty(t,n,o),o}let A=(0,r.Qmd)("formula-ui.prompt-service"),U=class{constructor(e){this._contextService=e,D(this,"_search$",new o.B),D(this,"_help$",new o.B),D(this,"_navigate$",new o.B),D(this,"_accept$",new o.B),D(this,"_acceptFormulaName$",new o.B),D(this,"search$",this._search$.asObservable()),D(this,"help$",this._help$.asObservable()),D(this,"navigate$",this._navigate$.asObservable()),D(this,"accept$",this._accept$.asObservable()),D(this,"acceptFormulaName$",this._acceptFormulaName$.asObservable()),D(this,"_searching",!1),D(this,"_helping",!1),D(this,"_sequenceNodes",[]),D(this,"_isLockedOnSelectionChangeRefString",!1),D(this,"_isLockedOnSelectionInsertRefString",!1)}dispose(){this._search$.complete(),this._help$.complete(),this._navigate$.complete(),this._accept$.complete(),this._acceptFormulaName$.complete(),this._sequenceNodes=[]}search(e){this._contextService.setContextValue("FORMULA_PROMPT_ACTIVATED",e.visible),this._searching=e.visible,this._search$.next(e)}isSearching(){return this._searching}help(e){this._helping=e.visible,this._help$.next(e)}isHelping(){return this._helping}navigate(e){this._navigate$.next(e)}accept(e){this._accept$.next(e)}acceptFormulaName(e){this._acceptFormulaName$.next(e)}getSequenceNodes(){return[...this._sequenceNodes]}setSequenceNodes(e){this._sequenceNodes=e}clearSequenceNodes(){this._sequenceNodes=[]}getCurrentSequenceNode(e){return this._sequenceNodes[this.getCurrentSequenceNodeIndex(e)]}getCurrentSequenceNodeByIndex(e){return this._sequenceNodes[e]}getCurrentSequenceNodeIndex(e){let t=0,n=this._sequenceNodes[0];for(let r=0,i=this._sequenceNodes.length;r<i;r++){let i=this._sequenceNodes[r];if("string"==typeof i)t++;else{let{endIndex:e}=i;t=e}if(e<=t){if("string"==typeof n&&0!==e)return r+1;return r}}return this._sequenceNodes.length}updateSequenceRef(e,t){let n=this._sequenceNodes[e];if("string"==typeof n||n.nodeType!==l.kxp.REFERENCE)return;let r=t.length-n.token.length,i={...n};i.token=t,i.endIndex+=r,this._sequenceNodes[e]=i;for(let t=e+1,n=this._sequenceNodes.length;t<n;t++){let e=this._sequenceNodes[t];if("string"==typeof e)continue;let n={...e};n.startIndex+=r,n.endIndex+=r,this._sequenceNodes[t]=n}}insertSequenceRef(e,t){let n=t.length,r=this.getCurrentSequenceNodeIndex(e);this._sequenceNodes.splice(r,0,{token:t,startIndex:e,endIndex:e+n-1,nodeType:l.kxp.REFERENCE});for(let e=r+1,t=this._sequenceNodes.length;e<t;e++){let t=this._sequenceNodes[e];if("string"==typeof t)continue;let r={...t};r.startIndex+=n,r.endIndex+=n,this._sequenceNodes[e]=r}}insertSequenceString(e,t){let n=this.getCurrentSequenceNodeIndex(e),r=t.split("");this._sequenceNodes.splice(n,0,...r);let i=r.length;for(let e=n+i,t=this._sequenceNodes.length;e<t;e++){let t=this._sequenceNodes[e];if("string"==typeof t)continue;let n={...t};n.startIndex+=i,n.endIndex+=i,this._sequenceNodes[e]=n}}enableLockedSelectionChange(){this._isLockedOnSelectionChangeRefString=!0}disableLockedSelectionChange(){this._isLockedOnSelectionChangeRefString=!1}isLockedSelectionChange(){return this._isLockedOnSelectionChangeRefString}enableLockedSelectionInsert(){this._isLockedOnSelectionInsertRefString=!0}disableLockedSelectionInsert(){this._isLockedOnSelectionInsertRefString=!1}isLockedSelectionInsert(){return this._isLockedOnSelectionInsertRefString}};U=$([F(0,r.oaf)],U);let L={id:"formula-ui.operation.help-function",type:r.g4t.OPERATION,handler:async(e,t)=>(e.get(A).help(t),!0)},j={id:"formula-ui.operation.insert-function",type:r.g4t.OPERATION,handler:async(e,t)=>{var n,o,s,u;let a=e.get(p.Fal),c=e.get(m.Id),d=a.getCurrentSelections();if(!d||!d.length)return!1;let h=(0,p.go2)(e.get(r.HCr));if(!h)return!1;let{worksheet:f,unitId:g,subUnitId:_}=h,y=f.getCellMatrix(),{value:C}=t,b=e.get(r.wTY);e.get(i.JDd);let R=[],x=[],E=null,I=0,N=0,w="";if(1===d.length&&((n=d[0].range).startRow===n.endRow&&n.startColumn===n.endColumn||(o=d[0].range).startRow!==o.endRow&&o.startColumn!==o.endColumn&&W(y,d[0].range))){let{range:e,primary:t}=d[0],n=null!=(s=null==t?void 0:t.actualRow)?s:e.startRow,r=null!=(u=null==t?void 0:t.actualColumn)?u:e.startColumn;E=e,I=n,N=r;let i=P(y,n,r);i&&(w=(0,l.ocP)(i))}else d.some(e=>{let{range:t,primary:n}=e;if(W(y,t)){var r,i;let e=null!=(r=null==n?void 0:n.actualRow)?r:t.startRow,o=null!=(i=null==n?void 0:n.actualColumn)?i:t.startColumn,s=P(y,e,o);if(!s)return E=t,I=e,N=o,!0;let u=`=${C}(${(0,l.ocP)(s)})`;R.push({range:t,primary:{row:e,column:o},formula:u})}else{let{startRow:e,startColumn:n,endRow:r,endColumn:i}=t;if(e===r){let o=function(e,t,n,r){for(let i=n;i<=r;i++)if(!e.getValue(t,i))return i;return r}(y,e,i,f.getColumnCount()-1),s=`=${C}(${(0,l.ocP)({startRow:e,endRow:r,startColumn:n,endColumn:o===i?i-1:i})})`;x.push({range:t,primary:{row:e,column:o},formula:s})}else{let o=-1;for(let e=n;e<=i;e++)o=Math.max(o,function(e,t,n,r){for(let i=n;i<=r;i++)if(!e.getValue(i,t))return i;return r}(y,e,r,f.getRowCount()-1));let s=o===r?r-1:r;for(let r=n;r<=i;r++){let n=`=${C}(${(0,l.ocP)({startRow:e,endRow:s,startColumn:r,endColumn:r})})`;x.push({range:t,primary:{row:o,column:r},formula:n})}}}return!1});if(E){let e=(0,p.Oqq)(I,N,f),t={unitId:g,subUnitId:_,selections:[{range:r.M_G.clone(E),primary:{startRow:e.startRow,startColumn:e.startColumn,endRow:e.endRow,endColumn:e.endColumn,actualRow:I,actualColumn:N,isMerged:e.isMerged,isMergedMainCell:e.startRow===I&&e.startColumn===N}}]};await b.executeCommand(p.NSB.id,t);let n=c.getEditor(r.Fmw),l=c.getEditor(r.azi);b.syncExecuteCommand(i.chT.id,{visible:!0,unitId:g,eventType:v.bKQ.Dblclick});let o=`=${C}(${w}`;null==n||n.replaceText(o),null==l||l.replaceText(o,!1)}

1return(0!==R.length||0!==x.length)&&b.executeCommand(S.T9.id,{list:R,listOfRangeHasNumber:x})}};function P(e,t,n){let r=function(e,t,n){let r=!1;if(0===t)return t;for(let i=t-1;i>=0;i--){let t=e.getValue(i,n);if(V(t)&&!r){if(0===i)return 0;r=!0}else if(r&&!V(t))return i+1;else if(r&&0===i)return 0}return t}(e,t,n);if(r!==t)return{startRow:r,endRow:t-1,startColumn:n,endColumn:n};let i=function(e,t,n){let r=!1;if(0===n)return n;for(let i=n-1;i>=0;i--){let n=e.getValue(t,i);if(V(n)&&!r){if(0===i)return 0;r=!0}else if(r&&!V(n))return i+1;else if(r&&0===i)return 0}return n}(e,t,n);return i!==n?{startRow:t,endRow:t,startColumn:i,endColumn:n-1}:null}function V(e){if(null==e?void 0:e.p){let t=null==e?void 0:e.p.body;if(null==t)return!1;let n=t.dataStream;return(0,r.DMQ)(n.substring(n.length-2,n.length)===r.Wd2?n.substring(0,n.length-2):n)}return e&&(e.t===r.scd.NUMBER||(0,r.ym3)(e)===r.scd.NUMBER)}function W(e,t){for(let n=t.startRow;n<=t.endRow;n++)for(let r=t.startColumn;r<=t.endColumn;r++)if(V(e.getValue(n,r)))return!1;return!0}let B="SHEET_FORMULA_UI_PLUGIN",J=`${B}_MORE_FUNCTIONS_COMPONENT`,q={id:"formula-ui.operation.more-functions",type:r.g4t.OPERATION,handler:async e=>(e.get(_.Jj).open({header:{title:"sheets-formula-ui.insert.tooltip"},children:{label:J}}),!0)},H=/^\$?[A-Za-z]+\$?\d+$/;function K(e){switch(e){case r.F6v.NONE:return r.F6v.ALL;case r.F6v.ALL:return r.F6v.ROW;case r.F6v.ROW:return r.F6v.COLUMN;case r.F6v.COLUMN:default:return r.F6v.NONE}}let z={id:"formula-ui.operation.change-ref-to-absolute",type:r.g4t.OPERATION,handler:async e=>{var t,n;let i=e.get(m.Id),o=e.get(y.pv),s=e.get(l.GMK),u=i.getFocusEditor();if(!u)return!1;let a=u.getEditorId();if(a!==r.Fmw&&a!==r.azi)return!1;let c=o.getActiveTextRange();if(!c)return!1;let d=function(e,t,n){if(!t.startsWith("=")||t.length<=1)return null;let i=e.sequenceNodesBuilder(t);if(!(null==i?void 0:i.length))return null;let o=Math.min(Math.max(n,0),t.length),s=o-1;if(s<0)return null;let u=i.find(e=>"string"!=typeof e&&e.nodeType===l.kxp.REFERENCE&&s>=e.startIndex&&s<=e.endIndex+1);if(!u||"string"==typeof u)return null;let a=function(e,t){var n,i,o;let s,u=(0,l.YKh)(e.token);if(null==u)return null;let{range:a}=u;if(a.rangeType===r.$uV.ROW||a.rangeType===r.$uV.COLUMN)return{token:(0,l.x4m)({...u,range:{...a,startAbsoluteRefType:a.startAbsoluteRefType===r.F6v.NONE?r.F6v.ALL:r.F6v.NONE,endAbsoluteRefType:a.endAbsoluteRefType===r.F6v.NONE?r.F6v.ALL:r.F6v.NONE}}),referenceTarget:"both",previousSeparatorOffset:null,nextSeparatorOffset:null};let{refBody:c}=(0,l.zTH)(e.token),d=c.split(":"),h=2===d.length?e.token.indexOf(":"):null;if(d.some(e=>!H.test(e)))return null;let f=2===d.length,g=f?(n=e.token,i=c,(o=t)===(s=n.length-i.length+i.indexOf(":"))||o===s+1?"both":o<s?"start":"end"):"start",m={...a};if("start"===g||"both"===g){let e=K((0,l.Yuy)(d[0]));m.startAbsoluteRefType=e,f||(m.endAbsoluteRefType=e)}("end"===g||"both"===g)&&(m.endAbsoluteRefType=K((0,l.Yuy)(d[1])));let v=(0,l.x4m)({...u,range:m});return{token:v,referenceTarget:g,previousSeparatorOffset:h,nextSeparatorOffset:2===d.length?v.indexOf(":"):null}}(u,s-u.startIndex);return null==a||a.token===u.token?null:{formulaText:`=${(0,l.Klk)(i.map(e=>e!==u?e:{...e,token:a.token,endIndex:e.startIndex+a.token.length-1}))}`,cursorOffset:function(e,t,n,r,i){if("both"===i.referenceTarget&&null!=i.previousSeparatorOffset&&null!=i.nextSeparatorOffset){let n=t+i.previousSeparatorOffset,r=t+i.nextSeparatorOffset;if(e===n)return r;if(e===n+1)return r+1}return e<=t?e:e>=n?e+(r-(n-t)):t+Math.min(e-t,r)}(o,u.startIndex+1,u.endIndex+2,a.token.length,a)}}(s,r.Z4q.transform.getPlainText(null!=(t=null==(n=u.getDocumentData().body)?void 0:n.dataStream)?t:""),c.endOffset);return!!d&&(u.replaceText(d.formulaText,[{startOffset:d.cursorOffset,endOffset:d.cursorOffset,collapsed:!0}]),!0)}},G={id:"formula-ui.operation.search-function",type:r.g4t.OPERATION,handler:async(e,t)=>(e.get(A).search(t),!0)},Z=class extends r.jGt{constructor(e,t,n,r){super(),this._sheetInterceptorService=e,this._univerInstanceService=t,this._formulaDataModel=n,this._lexerTreeBuilder=r,this._initialize()}_initialize(){this.disposeWithMe(this._sheetInterceptorService.interceptCommand({getMutations:e=>e.id===p.yzM.id?this._reorderFormula(e.params):{redos:[],undos:[]}}))}_reorderFormula(e){let t=[],n=[],{unitId:i,subUnitId:l,range:o,order:s}=e,u=this._univerInstanceService.getUniverSheetInstance(i),a=null==u?void 0:u.getSheetBySheetId(l);if(!a)return{redos:t,undos:n};let c=a.getCellMatrix(),d=new r.hDc,h=new r.hDc,f=!1;return r.Q6t.foreach(o,(e,t)=>{let n=e;s.hasOwnProperty(e)&&(n=s[e]);let o=c.getValue(n,t);if((null==o?void 0:o.f)||(null==o?void 0:o.si)){f=!0;let s=this._formulaDataModel.getFormulaStringByCell(n,t,l,i),u=this._lexerTreeBuilder.moveFormulaRefOffset(s,0,e-n),a=r.S0q.deepClone(o);a.f=u,a.si=null,d.setValue(e,t,a)}else d.setValue(e,t,o);h.setValue(e,t,c.getValue(e,t))}),f&&(t.push({id:p.N48.id,params:{unitId:i,subUnitId:l,cellValue:d.getMatrix()}}),n.push({id:p.N48.id,params:{unitId:i,subUnitId:l,cellValue:h.getMatrix()}})),{redos:t,undos:n}}};Z=$([F(0,(0,r.y_5)(p.e5R)),F(1,(0,r.y_5)(r.HCr)),F(2,(0,r.y_5)(l.SN)),F(3,(0,r.y_5)(l.GMK))],Z);let Y="sheets-formula-ui.base.config";Symbol(Y);let Q={},X="SHEET_FORMULA_ALERT",ee={[l.Byv.DIV_BY_ZERO]:"divByZero",[l.Byv.NAME]:"name",[l.Byv.VALUE]:"value",[l.Byv.NUM]:"num",[l.Byv.NA]:"na",[l.Byv.CYCLE]:"cycle",[l.Byv.REF]:"ref",[l.Byv.SPILL]:"spill",[l.Byv.CALC]:"calc",[l.Byv.ERROR]:"error",[l.Byv.CONNECT]:"connect",[l.Byv.NULL]:"null"},et=class extends r.jGt{constructor(e,t,n,r,i,l){super(),this._context=e,this._hoverManagerService=t,this._cellAlertManagerService=n,this._localeService=r,this._formulaDataModel=i,this._zenZoneService=l,this._init()}

1_init(){this._initCellAlertPopup(),this._initZenService()}_initCellAlertPopup(){this.disposeWithMe(this._hoverManagerService.currentCell$.pipe((0,s.B)(100)).subscribe(e=>{if(e){var t,n;let o=this._context.unit.getActiveSheet();if(!o)return this._hideAlert();let s=o.getCell(e.location.row,e.location.col),u=null==(t=this._formulaDataModel.getArrayFormulaCellData())||null==(t=t[e.location.unitId])||null==(t=t[e.location.subUnitId])||null==(t=t[e.location.row])?void 0:t[e.location.col];if((0,r.SoT)(s)){let t=(0,l.sWL)(s,!!u);if(!t)return void this._hideAlert();let r=this._cellAlertManagerService.currentAlert.get(X),o=null==r||null==(n=r.alert)?void 0:n.location;return o&&o.row===e.location.row&&o.col===e.location.col&&o.subUnitId===e.location.subUnitId&&o.unitId===e.location.unitId?void this._hideAlert():void this._cellAlertManagerService.showAlert({type:i.xYe.ERROR,title:this._localeService.t("sheets-formula-ui.error.title"),message:this._localeService.t(`sheets-formula-ui.error.${ee[t]}`),location:e.location,width:200,height:74,key:X})}}this._hideAlert()}))}_initZenService(){this.disposeWithMe(this._zenZoneService.visible$.subscribe(e=>{e&&this._hideAlert()}))}_hideAlert(){this._cellAlertManagerService.removeAlert(X)}};et=$([F(1,(0,r.y_5)(i.VX2)),F(2,(0,r.y_5)(i.jS1)),F(3,(0,r.y_5)(r.iH9)),F(4,(0,r.y_5)(l.SN)),F(5,_.Uw)],et);let en=class extends r.jGt{constructor(e,t,n,r,i){super(),this._univerInstanceService=e,this._lexerTreeBuilder=t,this._sheetClipboardService=n,this._injector=r,this._formulaDataModel=i,this._initialize()}_initialize(){this._registerClipboardHook()}_registerClipboardHook(){this.disposeWithMe(this._sheetClipboardService.addClipboardHook(this._copyFormulaOnlyHook())),this.disposeWithMe(this._sheetClipboardService.addClipboardHook(this._pasteFormulaHook())),this.disposeWithMe(this._sheetClipboardService.addClipboardHook(this._pasteWithFormulaHook()))}_copyFormulaOnlyHook(){let e=this,t=null;return{id:i.vfe.SPECIAL_COPY_FORMULA_ONLY,priority:10,onBeforeCopy(n,r){t=e._getWorksheet(n,r)},onCopyCellContent(n,i){if(!t)return"";let l=t.getCellRaw(n,i);return l?(0,r.qGs)(l.f)?l.f:(0,r.wJp)(l.si)&&e._formulaDataModel.getFormulaStringByCell(n,i,t.getSheetId(),t.getUnitId())||"":""},onAfterCopy(){t=null},getFilteredOutRows(t,n,r){let i=e._getWorksheet(t,n);if(!i)return[];let{startRow:l,endRow:o}=r,s=[];for(let e=l;e<=o;e++)i.getRowFiltered(e)&&s.push(e);return s},handleMatrixOnCell(n,i,l,o,s,u,a){let c=s.getValue(n,i);if(t&&c&&((0,r.qGs)(c.f)||(0,r.wJp)(c.si))){let s=(0,r.qGs)(c.f)?c.f:e._formulaDataModel.getFormulaStringByCell(n,i,t.getSheetId(),t.getUnitId());u.setValue(l,o,{...(0,r.u2t)(),f:s}),a.setValue(l,o,{...(0,r.u2t)(),f:s,displayV:s})}else s.setValue(n,i,(0,r.u2t)()),u.setValue(l,o,(0,r.u2t)()),a.setValue(l,o,(0,r.u2t)())}}}_pasteFormulaHook(){return{id:i.bYT.SPECIAL_PASTE_FORMULA,priority:10,specialPasteInfo:{label:"specialPaste.formula"},onPasteCells:(e,t,n,r)=>this._onPasteCells(e,t,n,r,!0)}}_pasteWithFormulaHook(){return{id:"default-paste-formula",priority:10,onPasteCells:(e,t,n,r)=>this._onPasteCells(e,t,n,r,!1)}}_getWorkbook(e){return e?this._univerInstanceService.getUnit(e,r.Zy$.UNIVER_SHEET):this._univerInstanceService.getCurrentUnitOfType(r.Zy$.UNIVER_SHEET)}_getWorksheet(e,t){let n=this._getWorkbook(e);return t?null==n?void 0:n.getSheetBySheetId(t):null==n?void 0:n.getActiveSheet()}_onPasteCells(e,t,n,l,o){var s;if([i.bYT.SPECIAL_PASTE_FORMAT,i.bYT.SPECIAL_PASTE_COL_WIDTH].includes(l.pasteType)||l.copyType===i.Jeq.CUT&&!o)return{undos:[],redos:[]};let u=this._getWorkbook(),a=t.unitId||(null==u?void 0:u.getUnitId()),c=t.subUnitId||(null==u||null==(s=u.getActiveSheet())?void 0:s.getSheetId());if(!a||!c)return{undos:[],redos:[]};let d=t.range,h={copyType:l.copyType||i.Jeq.COPY,copyRange:null==e?void 0:e.range,pasteType:l.pasteType};return this._injector.invoke(t=>(function(e,t,n,l,o,s,u,a,c=!1,d){var h,f,g,m,v,S,_,y,C,b,R,x,E,I,N,w,k,T,M,O,D,F,$,A,U,L,j,P,V,W,B,J,q,H,K;let z,G,Z,Y,Q,X,ee,et,en,ei,el,eo=[],es=[],eu=(h=e,f=t,g=n,m=l,v=s,S=u,_=a,(y=d)?v.pasteType===i.bYT.SPECIAL_PASTE_VALUE?(C=h,b=f,R=g,x=m,E=_,I=y,z=new r.hDc,G=null==(N=E.getArrayFormulaCellData())||null==(N=N[I.unitId])?void 0:N[I.subUnitId],Z=E.get

1SheetFormulaData(C,b),x.forValue((e,t,n)=>{var i,l;let o=I.range.rows[e%I.range.rows.length],s=I.range.cols[t%I.range.cols.length],u=R.rows[e],a=R.cols[t],c={};if((0,r.qGs)(n.f)||(0,r.wJp)(n.si))c.v=n.v,c.f=null,c.si=null,c.p=null,z.setValue(u,a,c);else if(null==G||null==(i=G[o])?void 0:i[s])c.v=G[o][s].v,c.f=null,c.si=null,c.p=null,z.setValue(u,a,c);else if(null==Z||null==(l=Z[u])?void 0:l[a]){if(c.v=n.v,c.f=null,c.si=null,c.p=null,n.p){let e=er(n);e&&(c.v=e)}z.setValue(u,a,c)}}),z):v.pasteType===i.bYT.SPECIAL_PASTE_FORMULA?(w=h,k=f,T=g,M=m,O=S,D=_,F=y,Y=new r.hDc,Q=new Map,M.forValue((e,t,n)=>{let i=T.rows[e],l=T.cols[t],o={};if((0,r.wJp)(n.si)){if(F.unitId!==w||F.subUnitId!==k){let n=D.getFormulaStringByCell(F.range.rows[e%F.range.rows.length],F.range.cols[t%F.range.cols.length],F.subUnitId,F.unitId),r=T.cols[t]-F.range.cols[t%F.range.cols.length],i=T.rows[e]-F.range.rows[e%F.range.rows.length],l=O.moveFormulaRefOffset(n||"",r,i);o.si=null,o.f=l}else o.si=n.si,o.f=null;o.v=null,o.p=null,Y.setValue(i,l,o)}else if((0,r.qGs)(n.f)){let s=`${e%F.range.rows.length}_${t%F.range.cols.length}`,u=Q.get(s);if(u)o.si=u,o.f=null;else{u=(0,r.MZQ)(6),Q.set(s,u);let i=T.cols[t]-F.range.cols[t%F.range.cols.length],l=T.rows[e]-F.range.rows[e%F.range.rows.length],a=O.moveFormulaRefOffset(n.f||"",i,l);o.si=u,o.f=a}o.v=null,o.p=null,Y.setValue(i,l,o)}else{if(o.v=n.v,o.f=null,o.si=null,o.p=null,n.p){let e=er(n);e&&(o.v=e)}Y.setValue(i,l,o)}}),Y):($=h,A=f,U=g,L=m,j=v.copyType,P=S,V=_,W=y,X=new r.hDc,ee=new Map,et=V.getSheetFormulaData($,A),en=[],j===i.Jeq.CUT?L.forValue((e,t,n)=>{let i=U.rows[e],l=U.cols[t],o={};(0,r.wJp)(n.si)?((0,r.qGs)(n.f)?(en.push(n.si),o.f=n.f,o.si=n.si):en.includes(n.si)?(o.f=null,o.si=n.si):(o.f=V.getFormulaStringByCell(W.range.rows[e%W.range.rows.length],W.range.cols[t%W.range.cols.length],W.subUnitId,W.unitId),o.si=null),o.v=null,o.p=null,X.setValue(i,l,o)):(0,r.qGs)(n.f)&&(o.f=n.f,o.si=null,o.v=null,o.p=null,X.setValue(i,l,o))}

1):L.forValue((e,t,n)=>{var i;let l=U.rows[e],o=U.cols[t],s={};if((0,r.wJp)(n.si)){if(W.unitId!==$||W.subUnitId!==A){let n=V.getFormulaStringByCell(W.range.rows[e%W.range.rows.length],W.range.cols[t%W.range.cols.length],W.subUnitId,W.unitId),r=U.cols[t]-W.range.cols[t%W.range.cols.length],i=U.rows[e]-W.range.rows[e%W.range.rows.length],l=P.moveFormulaRefOffset(n||"",r,i);s.si=null,s.f=l}else s.si=n.si,s.f=null;s.v=null,s.p=null,X.setValue(l,o,s)}else if((0,r.qGs)(n.f)){let i=`${e%W.range.rows.length}_${t%W.range.cols.length}`,u=ee.get(i);if(u)s.si=u,s.f=null;else{u=(0,r.MZQ)(6),ee.set(i,u);let l=U.cols[t]-W.range.cols[t%W.range.cols.length],o=U.rows[e]-W.range.rows[e%W.range.rows.length],a=P.moveFormulaRefOffset(n.f||"",l,o);s.si=u,s.f=a}s.v=null,s.p=null,X.setValue(l,o,s)}else(null==et||null==(i=et[l])?void 0:i[o])&&(s.v=n.v,s.f=null,s.si=null,s.p=n.p,X.setValue(l,o,s))}),en.length>0&&new r.hDc(et).forValue((e,t,n)=>{if(!(W.range.rows.includes(e)&&W.range.cols.includes(t))&&!(U.rows.includes(e)&&U.cols.includes(t))&&en.includes(null==n?void 0:n.si)){let n=V.getFormulaStringByCell(e,t,W.subUnitId,W.unitId);X.setValue(e,t,{f:n,si:null,v:null,p:null})}}),X):(B=h,J=f,q=g,H=m,K=_,ei=new r.hDc,el=K.getSheetFormulaData(B,J),H.forValue((e,t,n)=>{var i;let l=q.rows[e],o=q.cols[t],s={};(0,r.qGs)(n.v)?(s.v=null,s.f=`${n.v}`,s.si=null,s.p=null,ei.setValue(l,o,s)):(null==el||null==(i=el[l])?void 0:i[o])&&(s.v=n.v,s.f=null,s.si=null,s.p=null,ei.setValue(l,o,s))}),ei));if(!eu.hasValue())return{undos:[],redos:[]};let ea={unitId:e,subUnitId:t,cellValue:eu.getData()};eo.push({id:p.N48.id,params:ea});let ec=(0,p.hro)(o,ea);return es.push({id:p.N48.id,params:ec}),{undos:es,redos:eo}})(a,c,d,n,t,h,this._lexerTreeBuilder,this._formulaDataModel,o,e))}};function er(e){if(null==e?void 0:e.p){let t=null==e?void 0:e.p.body;if(null==t)return;let n=t.dataStream;return n.substring(n.length-2,n.length)===r.Wd2?n.substring(0,n.length-2):n}}en=$([F(0,r.HCr),F(1,(0,r.y_5)(l.GMK)),F(2,i.udt),F(3,(0,r.y_5)(r.zZn)),F(4,(0,r.y_5)(l.SN))],en);let ei=class extends r.jGt{constructor(e,t,n,r,i,l,o,s,u){super(),this._context=e,this._sheetInterceptorService=t,this._sheetSkeletonService=n,this._formulaDataModel=r,this._themeService=i,this._renderManagerService=l,this._sheetSkeletonManagerService=o,this._commandService=s,this._logService=u,D(this,"_previousShape",void 0),D(this,"_skeleton",void 0),this._initSkeletonChangeListener(),this._initInterceptorEditorStart(),this._commandExecutedListener()}_initSkeletonChangeListener(){this.disposeWithMe(this._sheetSkeletonManagerService.currentSkeleton$.subscribe(e=>{if(null==e)this._logService.debug("[FormulaEditorShowController]: should not receive currentSkeleton$ as null!");else{var t;let{skeleton:n}=e,r=null==(t=this._skeleton)||null==(t=t.worksheet)?void 0:t.getSheetId();if(this._changeRuntime(n),r!==n.worksheet.getSheetId())this._removeArrayFormulaRangeShape();else{let{unitId:t,sheetId:n}=e;this._updateArrayFormulaRangeShape(t,n)}}}))}_changeRuntime(e){this._skeleton=e}_initInterceptorEditorStart(){this.disposeWithMe((0,r.saO)(this._sheetInterceptorService.writeCellInterceptor.intercept(p.Yhg,{handler:(e,t,n)=>{var r,i;let{row:l,col:o,unitId:s,subUnitId:u,worksheet:a}=t,c=this._formulaDataModel.getArrayFormulaRange(),d=this._formulaDataModel.getArrayFormulaCellData();if(this._removeArrayFormulaRangeShape(),null==e)return n(e);let h=null,f=this._formulaDataModel.getFormulaStringByCell(l,o,u,s);if(null!==f&&(h={f:f}),null!=e.v&&""!==e.v&&(null==(r=d[s])||null==(r=r[u])||null==(r=r[l])?void 0:r[o])==null)return h?{...e,...h}:n(e);let g=null==c||null==(i=c[s])?void 0:i[u];return(null!=g&&(h=this._displayArrayFormulaRangeShape(g,l,o,s,u,a,h)),h)?{...e,...h}:n(e)}})))}_commandExecutedListener(){this.disposeWithMe(this._commandService.onCommandExecuted((e,t)=>{(e.id===l.Qaq.id||e.id===l.nzv.id&&t&&t.remove)&&this._removeArrayFormulaRangeShape()})),this.disposeWithMe(this._commandService.beforeCommandExecuted(e=>{p.wXn.id===e.id&&requestIdleCallback(()=>{let{unitId:t,subUnitId:n,rowsAutoHeightInfo:r}=e.params;this._refreshArrayFormulaRangeShapeByRow(t,n,r)})}))}_displayArrayFormulaRangeShape(e,t,n,i,o,s,u){return new r.hDc(e).forValue((e,r,a)=>{if(null==a)return!0;let{startRow:c,startColumn:d,endRow:h,endColumn:f}=a;if(e===t&&r===n)return this._createArrayFormulaRangeShape(a,i,o),!1;if(t>=c&&t<=h&&n>=d&&n<=f){let e=s.getCell(c,d);if((null==e?void 0:e.v)===l.Byv.SPILL||(null==e?void 0:e.f)==null)return;return null==u&&(u={f:e.f,isInArrayFormulaRange:!0}),this._createArrayFormulaRangeShape(a,i,o),!1}}),u}_createArrayFormulaRangeShape(e,t,n){let l=this._renderManagerService.getRenderById(t),o=this._sheetSkeletonService.getSkeleton(t,n);if(!l||!o)return;let{scene:s}=l;if(!s)return;let u=(0,p.fcm)({range:e,primary:null,style:{strokeWidth:1,stroke:this._themeService.getColorFromTheme("primary.600"),fill:new r.mKL(this._themeService.getColorFromTheme("white")).setAlpha(0).toString(),widgets:{}}},o),{rowHeaderWidth:a,columnHeaderHeight:c}=o,d=new i.Y8A(s,i.Re$.FORMULA_EDITOR_SHOW,this._themeService,{highlightHeader:!1,rowHeaderWidth:a,columnHeaderHeight:c});d.updateRangeBySelectionWithCoord(u),d.setEvent(!1),this._previousShape=d}_removeArrayFormulaRangeShape(){null!=this._previousShape&&(this._previousShape.dispose(),this._previousShape=null)}_refreshArrayFormulaRangeShape(e,t){if(this._previousShape){let{startRow:n,endRow:r,startColumn:i,endColumn:l}=this._previousShape.getRange();this._removeArrayFormulaRangeShape(),this._createArrayFormulaRangeShape({startRow:n,endRow:r,startColumn:i,endColumn:l},e,t)}}_checkCurrentSheet(e,t){let n=this._sheetSkeletonManagerService.getCurrentSkeleton();if(!n)return!1;let r=n.worksheet;return!!r&&r.unitId===e&&r.getSheetId()===t}_updateArrayFormulaRangeShape(e,t){!this._checkCurrentSheet(e,t)||this._previousShape&&this._refreshArrayFormulaRangeShape(e,t)}_refreshArrayFormulaRangeShapeByRow(e,t,n){if(!this._checkCurrentSheet(e,t)||!this._previousShape)return;let{startRow:r}=this._previousShape.getRange();for(let i=0;i<n.length;i++){let{row:l}=n[i];if(r>=l){this._refreshArrayFormulaRangeShape(e,t);break}}}};ei=$([F(1,(0,r.y_5)(p.e5R)),F(2,(0,r.y_5)(p.QsU)),F(3,(0,r.y_5)(l.SN)),F(4,(0,r.y_5)(r.Fsb)),F(5,v.cSx),F(6,(0,r.y_5)(i.bPr)),F(7,r.wTY),F(8,r.rrK)],ei);let el={tl:{size:6,color:"#409f11"}},eo=class extends r.hy_{constructor(e,t){super(),this._sheetInterceptorService=e,this._formulaDataModel=t,this.disposeWithMe(this._sheetInterceptorService.intercept(p.ZoP.CELL_CONTENT,{effect:r._w8.Style,handler:(e,t,n)=>{var r;let i=null==(r=this._formulaDataModel.getArrayFormulaCellData())||null==(r=r[t.unitId])||null==(r=r[t.subUnitId])||null==(r=r[t.row])?void 0:r[t.col];return(0,l.sWL)(e,!!i)&&e&&(e===t.rawData&&(e={...t.rawData}),e.markers={...null==e?void 0:e.markers,...el}),n(e)},priority:10}))}};

1function es(e,t,n){return function(i){let l=[];try{l=i.get(S.Fy).getSearchListByType(e).map(({name:e})=>({label:{name:e,selectable:!1},value:e}))}catch{l=[]}return{id:`${j.id}.${t}`,commandId:j.id,title:`sheets-formula-ui.functionType.${t}`,tooltip:"sheets-formula-ui.insert.tooltip",icon:n,type:_.xU.SELECTOR,selections:l,hidden$:(0,_.fN)(i,r.Zy$.UNIVER_SHEET)}}}eo=$([F(0,(0,r.y_5)(p.e5R)),F(1,(0,r.y_5)(l.SN))],eo);let eu=es(l.RKz.Financial,"financial"),ea=es(l.RKz.Logical,"logical"),ec=es(l.RKz.Text,"text"),ed=es(l.RKz.Date,"date"),eh=es(l.RKz.Lookup,"lookup"),ef=es(l.RKz.Math,"math"),eg=es(l.RKz.Statistical,"statistical"),em=es(l.RKz.Engineering,"engineering"),ev=es(l.RKz.Information,"information"),ep=es(l.RKz.Database,"database");function eS(e){return{id:q.id,title:"sheets-formula-ui.moreFunctions.allFunctions",tooltip:"sheets-formula-ui.insert.tooltip",type:_.xU.BUTTON,hidden$:(0,_.fN)(e,r.Zy$.UNIVER_SHEET),disabled$:(0,i.JUQ)(e,{workbookTypes:[p.W30],worksheetTypes:[p.qGK,p.r$W],rangeTypes:[p.o9h]})}}let e_={[_.$P.BASIC]:{[`${j.id}.common`]:{order:0,menuItemFactory:function(e){let t=["SUMIF","SUM","AVERAGE","IF","COUNT","SIN","MAX"],n=t.map(e=>({label:{name:e,selectable:!1},value:e}));try{let r=e.get(S.Fy),i=t.filter(e=>!!r.getFunctionInfo(e));i.length>0&&(n=i.map(e=>({label:{name:e,selectable:!1},value:e})))}catch{}return{id:`${j.id}.common`,commandId:j.id,title:"sheets-formula-ui.insert.common",tooltip:"sheets-formula-ui.insert.tooltip",icon:"FunctionIcon",type:_.xU.SELECTOR,selections:n,hidden$:(0,_.fN)(e,r.Zy$.UNIVER_SHEET)}},[q.id]:{order:0,menuItemFactory:eS}},[`${j.id}.financial`]:{order:1,menuItemFactory:eu,[q.id]:{order:0,menuItemFactory:eS}},[`${j.id}.logical`]:{order:2,menuItemFactory:ea,[q.id]:{order:0,menuItemFactory:eS}},[`${j.id}.text`]:{order:3,menuItemFactory:ec,[q.id]:{order:0,menuItemFactory:eS}},[`${j.id}.date`]:{order:4,menuItemFactory:ed,[q.id]:{order:0,menuItemFactory:eS}},[`${j.id}.lookup`]:{order:5,menuItemFactory:eh,[q.id]:{order:0,menuItemFactory:eS}},[`${j.id}.math`]:{order:6,menuItemFactory:ef,[q.id]:{order:0,menuItemFactory:eS}},[`${j.id}.statistical`]:{order:7,menuItemFactory:eg,[q.id]:{order:0,menuItemFactory:eS}},[`${j.id}.engineering`]:{order:8,menuItemFactory:em,[q.id]:{order:0,menuItemFactory:eS}},[`${j.id}.information`]:{order:9,menuItemFactory:ev,[q.id]:{order:0,menuItemFactory:eS}},[`${j.id}.database`]:{order:10,menuItemFactory:ep,[q.id]:{order:0,menuItemFactory:eS}}},[i.qtO]:{[T.id]:{order:0,menuItemFactory:function(e){return{id:T.id,type:_.xU.BUTTON,title:"sheets-formula-ui.operation.copyFormulaOnly",disabled$:(0,i.JUQ)(e,{workbookTypes:[p.FB8],worksheetTypes:[p.$Rn],rangeTypes:[p.fGp]}),hidden$:(0,_.fN)(e,r.Zy$.UNIVER_SHEET)}}}},[i.g8R]:{[M.id]:{order:4,menuItemFactory:function(e){return{id:M.id,type:_.xU.BUTTON,title:"sheets-formula-ui.operation.pasteFormula",disabled$:(0,i.PXm)(e).pipe((0,u.v)((0,i.JUQ)(e,{workbookTypes:[p.W30],rangeTypes:[p.o9h],worksheetTypes:[p.r$W,p.qGK]})),(0,a.T)(([e,t])=>e||t)),hidden$:(0,_.fN)(e,r.Zy$.UNIVER_SHEET)}}}}};function ey(){let e=(0,_.fJ)(S.AX),t=(0,_.fJ)(r.wTY);return(0,b.jsx)(_.z2,{progress:(0,_.J2)(e.progress$),onTerminate:(0,C.useCallback)(()=>{t.executeCommand(l.tJv.id)},[t]),onClearProgress:(0,C.useCallback)(()=>{e.clearProgress()},[e])})}function eC(e){return e.require||e.repeat?e.require&&!e.repeat?e.name:!e.require&&e.repeat?`[${e.name},...]`:e.require&&e.repeat?`${e.name},...`:void 0:`[${e.name}]`}function eb(e){let{prefix:t,value:n}=e;return(0,b.jsxs)("div",{children:[(0,b.jsxs)("span",{children:[t,"("]}),n&&n.map((e,t)=>(0,b.jsxs)("span",{children:[(0,b.jsx)("span",{children:eC(e)}),t===n.length-1?"":","]},t)),")"]})}function eR(e){let{className:t,value:n,title:r}=e;return(0,b.jsxs)("div",{className:"univer-mb-2 univer-text-xs",children:[(0,b.jsx)("div",{className:(0,R.$z)("univer-mb-2 univer-font-medium univer-text-gray-500 dark:!univer-text-gray-300",t),children:r}),(0,b.jsx)("div",{className:"univer-break-all univer-text-gray-900 dark:!univer-text-white",children:n})]})}function ex(e){let{functionInfo:t,onChange:n}=e;if(!t)return null;let[r,i]=(0,C.useState)([]),[l,o]=(0,C.useState)(t.functionParameter),[s,u]=(0,C.useState)(-1);return(0,b.jsxs)("div",{children:[(0,b.jsx)("div",{className:(0,R.$z)("univer-h-[364px] univer-overflow-y-auto",R.oN),children:l.map((e,t)=>(0,b.jsxs)("div",{children:[(0,b.jsx)("div",{className:"univer-text-sm",children:e.name}),(0,b.jsx)("div",{className:"univer-mb-2 univer-mt-1"})]},t))}),(0,b.jsx)("div",{className:(0,R.$z)("univer-flex-1 univer-p-3",R.RI),children:(0,b.jsx)(eR,{title:-1===s?(0,b.jsx)(eb,{prefix:t.functionName,value:l}):l[s].name,value:-1===s?t.description:l[s].detail})})]})}function eE(e){var t,n;let i=null==(t=(0,_.fJ)(r.J0C).getConfig(S.rW))?void 0:t.function,{onChange:o}=e,[s,u]=(0,C.useState)(""),[a,c]=(0,C.useState)([]),[d,h]=(0,C.useState)(0),[f,g]=(0,C.useState)("-1"),[m,v]=(0,C.useState)(0),[p,y]=(0,C.useState)(null),E=(0,_.fJ)(S.Fy),I=(0,_.fJ)(r.iH9),N=(0,_.J2)((0,_.fJ)(_.Jj).sidebarOptions$),w=(n=!!i,Object.keys(l.RKz).filter(e=>isNaN(Number(e))&&"DefinedName"!==e&&"Table"!==e&&(n||"User"!==e)).map(e=>({label:I.t(`sheets-formula-ui.functionType.${e.toLocaleLowerCase()}`),value:`${l.RKz[e]}`}))).filter(e=>E.getSearchListByType(Number(e.value)).length>0);w.unshift({label:I.t("sheets-formula-ui.moreFunctions.allFunctions"),value:"-1"});let k=I.t("sheets-formula-ui.prompt.required"),T=I.t("sheets-formula-ui.prompt.optional");(0,C.useEffect)(()=>{O("-1")},[]),(0,C.useEffect)(()=>{M(0)},[a]),(0,C.useEffect)(()=>{(null==N?void 0:N.visible)&&(u(""),c([]),h(0),g("-1"),v(0),y(null),O("-1"))},[N]);let M=e=>{if(0===a.length){y(null),o(null);return}v(e);let t=E.getFunctionInfo(a[e].name);if(!t){y(null),o(null);return}y(t),o(t)};

1function O(e){g(e),c(E.getSearchListByType(+e))}function D(e){if(e.stopPropagation(),"ArrowDown"===e.key){let e=d+1;h(e===a.length?0:e)}else if("ArrowUp"===e.key){let e=d-1;h(-1===e?a.length-1:e)}else"Enter"===e.key&&M(d)}let F=()=>{h(-1)};return(0,b.jsxs)("div",{children:[(0,b.jsxs)("div",{className:"univer-flex univer-items-center univer-justify-between univer-gap-2",children:[(0,b.jsx)(R.l6,{value:f,options:w,onChange:O}),(0,b.jsx)(R.pd,{placeholder:I.t("sheets-formula-ui.moreFunctions.searchFunctionPlaceholder"),onKeyDown:D,value:s,onChange:function(e){u(e),c(E.getSearchListByName(e))},size:"small",allowClear:!0})]}),a.length>0&&(0,b.jsx)("ul",{className:(0,R.$z)("univer-mb-0 univer-mt-2 univer-box-border univer-max-h-72 univer-w-full univer-select-none univer-list-none univer-overflow-y-auto univer-rounded univer-p-3 univer-outline-none",R.gW,R.oN),onKeyDown:D,tabIndex:-1,children:a.map(({name:e},t)=>(0,b.jsxs)("li",{className:(0,R.$z)("univer-relative univer-box-border univer-cursor-pointer univer-rounded univer-px-7 univer-py-1 univer-text-sm univer-text-gray-900 univer-transition-colors dark:!univer-text-white",{"univer-bg-gray-200 dark:!univer-bg-gray-600":d===t}),onMouseEnter:()=>{h(t)},onMouseLeave:F,onClick:()=>M(t),children:[m===t&&(0,b.jsx)(x.J,{className:"univer-absolute univer-left-1.5 univer-top-1/2 univer-inline-flex -univer-translate-y-1/2 univer-text-base univer-text-primary-600"}),(0,b.jsx)("span",{className:"univer-block",children:(e=>{if(""===s.trim())return e;let t=RegExp(`(${s.toLocaleUpperCase()})`);return e.split(t).filter(Boolean).map((e,n)=>e.match(t)?(0,b.jsx)("span",{className:"univer-text-red-500",children:e},n):e)})(e)})]},t))}),p&&(0,b.jsxs)("div",{className:(0,R.$z)("univer-mx-0 univer-my-2 univer-overflow-y-auto",R.oN),children:[(0,b.jsx)(eR,{title:p.functionName,value:p.description}),(0,b.jsx)(eR,{title:I.t("sheets-formula-ui.moreFunctions.syntax"),value:(0,b.jsx)(eb,{prefix:p.functionName,value:p.functionParameter})}),(0,b.jsx)(eR,{title:I.t("sheets-formula-ui.prompt.helpExample"),value:`${p.functionName}(${p.functionParameter.map(e=>e.example).join(",")})`}),p.functionParameter&&p.functionParameter.map(e=>(0,b.jsx)(eR,{title:e.name,value:`${e.require?k:T} ${e.detail}`},e.name))]})]})}function eI(){let e=(0,i.SXm)(),[t,n]=(0,C.useState)(!0),[l,o]=(0,C.useState)(!1),[s,u]=(0,C.useState)(null);(0,_.fJ)(i.JDd);let a=(0,_.fJ)(r.iH9),c=(0,_.fJ)(m.Id),d=(0,_.fJ)(r.HCr),h=(0,_.fJ)(r.wTY);function f(){n(!t),o(!l)}return(0,b.jsxs)("div",{"data-u-comp":"sheets-formula-functions-panel",className:"univer-box-border univer-flex univer-h-full univer-flex-col univer-justify-between univer-py-2",children:[t&&(0,b.jsx)(eE,{onChange:u}),l&&(0,b.jsx)(ex,{functionInfo:s,onChange:()=>{}}),(0,b.jsxs)("div",{className:"univer-flex univer-justify-end",children:[l&&(0,b.jsx)(R.$n,{variant:"primary",onClick:f,className:"univer-mb-5 univer-ml-4 univer-mr-0 univer-mt-0",children:a.t("sheets-formula-ui.moreFunctions.next")}),l&&(0,b.jsx)(R.$n,{onClick:f,className:"univer-mb-5 univer-ml-4 univer-mr-0 univer-mt-0",children:a.t("sheets-formula-ui.moreFunctions.prev")}),t&&!!e&&(0,b.jsx)(R.$n,{disabled:!s,variant:"primary",onClick:function(){let e=(0,p.go2)(d);if(!e)return;h.executeCommand(i.chT.id,{visible:!0,unitId:e.unitId,eventType:v.bKQ.Dblclick});let t=c.getEditor(r.Fmw),n=c.getEditor(r.azi),l=`=${null==s?void 0:s.functionName}(`;null==t||t.replaceText(l),null==n||n.replaceText(l,!1)},className:"univer-mb-5 univer-ml-4 univer-mr-0 univer-mt-0",children:a.t("sheets-formula-ui.moreFunctions.confirm")})]})]})}let eN={id:z.id,binding:_.DD.F4,preconditions:e=>(0,i.Q$u)(e)},ew={id:S._.id,binding:_.SK.ALT|_.DD.EQUAL,preconditions:i.GXv,mac:_.SK.CTRL_COMMAND|_.SK.ALT|_.DD.EQUAL,description:"sheets-formula-ui.shortcut.quick-sum",group:"4_sheet-edit",groupTitle:"sheets-ui.shortcut.sheet-edit"},ek=class extends r.jGt{constructor(e,t,n,r,i,l,o){super(),this._injector=e,this._menuManagerService=t,this._commandService=n,this._shortcutService=r,this._uiPartsService=i,this._renderManagerService=l,this._componentManager=o,this._initialize()}_initialize(){this._registerCommands(),this._registerMenus(),this._registerShortcuts(),this._registerComponents(),this._registerRenderModules()}_registerMenus(){this._menuManagerService.mergeMenu(e_)}

1_registerCommands(){[T,M,j,q,G,L,z].forEach(e=>this.disposeWithMe(this._commandService.registerCommand(e)))}_registerShortcuts(){[ew,eN].forEach(e=>{this.disposeWithMe(this._shortcutService.registerShortcut(e))})}_registerComponents(){this.disposeWithMe(this._uiPartsService.registerComponent(i.YMV.FORMULA_AUX,()=>(0,_.pK)(ey,this._injector))),this._componentManager.register(J,eI)}_registerRenderModules(){this.disposeWithMe(this._renderManagerService.registerRenderModule(r.Zy$.UNIVER_SHEET,[ei]))}};ek=$([F(0,(0,r.y_5)(r.zZn)),F(1,_.Zi),F(2,r.wTY),F(3,_.nF),F(4,_.fe),F(5,v.cSx),F(6,(0,r.y_5)(_.BJ))],ek);let eT=class extends r.jGt{constructor(e,t,n){super(),this._imageFormulaCellInterceptorController=e,this._renderManagerService=t,this._univerInstanceService=n,this._imageFormulaCellInterceptorController.registerRefreshRenderFunction(()=>{let e=this._univerInstanceService.getCurrentUnitOfType(r.Zy$.UNIVER_SHEET);if(!e)return;let t=this._renderManagerService.getRenderById(e.getUnitId());if(!t)return;t.with(i.bPr).reCalculate();let n=t.mainComponent;n&&n.makeDirty()})}};eT=$([F(0,(0,r.y_5)(S.lZ)),F(1,v.cSx),F(2,r.HCr)],eT);var eM=class{constructor(){D(this,"_currentSelector$",new c.t(null)),D(this,"currentSelector$",this._currentSelector$.asObservable())}showRangeSelectorDialog(e){let t=e.callback,n=new Promise(n=>{e.callback=e=>{n(e),t(e)}});return this._currentSelector$.next(e),n}};let eO=class extends i.fn5{constructor(e,t,n,r,l,o,s){super(t,n,r,l,o),this._context=e,this._contextService=o,this._refSelectionsService=s,D(this,"_workbookSelections",void 0),D(this,"_eventDisposables",void 0),this._workbookSelections=this._refSelectionsService.getWorkbookSelections(this._context.unitId),this._initSelectionChangeListener(),this._initSkeletonChangeListener(),this._initUserActionSyncListener(),this._setSelectionStyle(function(e){let t=(0,i.HFY)(e);return t.widgets={tl:!0,tc:!0,tr:!0,ml:!0,mr:!0,bl:!0,bc:!0,br:!0},t}(this._themeService)),this._remainLastEnabled=!0,this._highlightHeader=!1}getLocation(){return this._skeleton.getLocation()}setRemainLastEnabled(e){this._remainLastEnabled=e}setSkipLastEnabled(e){this._skipLastEnabled=e}clearLastSelection(){let e=this._selectionControls[this._selectionControls.length-1];e&&(e.dispose(),this._selectionControls.pop())}enableSelectionChanging(){return this._disableSelectionChanging(),this._eventDisposables=this._initCanvasEventListeners(),(0,r.saO)(()=>this._disableSelectionChanging())}_disableSelectionChanging(){var e;null==(e=this._eventDisposables)||e.dispose(),this._eventDisposables=null}disableSelectionChanging(){this._disableSelectionChanging()}_initCanvasEventListeners(){let{spreadsheetRowHeader:e,spreadsheetColumnHeader:t,spreadsheet:n,spreadsheetLeftTopPlaceholder:l}=this._getSheetObject(),{scene:o}=this._context,s=new r.VdD;return s.add(null==n?void 0:n.onPointerDown$.subscribeEvent((e,t)=>{this.inRefSelectionMode()&&(this._onPointerDown(e,n.zIndex+1,r.$uV.NORMAL,this._getActiveViewport(e)),2!==e.button&&t.stopPropagation())})),s.add(null==e?void 0:e.onPointerDown$.subscribeEvent((e,t)=>{if(!this.inRefSelectionMode())return;let l=this._sheetSkeletonManagerService.getCurrentSkeleton();if(!l)return;let{row:s}=(0,i.WZI)(e.offsetX,e.offsetY,o,l);(0,i.HcA)(this._workbookSelections.getCurrentSelections(),s,r.$uV.ROW)||(this._onPointerDown(e,(n.zIndex||1)+1,r.$uV.ROW,this._getActiveViewport(e),v.rDM.Y),2!==e.button&&t.stopPropagation())})),s.add(null==t?void 0:t.onPointerDown$.subscribeEvent((e,t)=>{if(!this.inRefSelectionMode())return;let l=this._sheetSkeletonManagerService.getCurrentSkeleton();if(!l)return;let{column:s}=(0,i.WZI)(e.offsetX,e.offsetY,o,l);(0,i.HcA)(this._workbookSelections.getCurrentSelections(),s,r.$uV.COLUMN)||(this._onPointerDown(e,(n.zIndex||1)+1,r.$uV.COLUMN,this._getActiveViewport(e),v.rDM.X),2!==e.button&&t.stopPropagation())})),s.add(null==l?void 0:l.onPointerDown$.subscribeEvent((e,t)=>{if(this._reset(),!this.inRefSelectionMode())return;let n=this._sheetSkeletonManagerService.getCurrentSkeleton();if(!n)return;let r=(0,i.wPP)(n);this._addSelectionControlByModelData(r),this._selectionMoveStart$.next(this.getSelectionDataWithStyle());let l=o.onPointerUp$.subscribeEvent(()=>{l.unsubscribe(),this._selectionMoveEnd$.next(this.getSelectionDataWithStyle())});2!==e.button&&t.stopPropagation()})),s}_addSelectionControlByModelData(e){var t;let n=this._skeleton,r=null!=(t=e.style)?t:(0,i.HFY)(this._themeService),l=this._scene;return e.style=r,this.newSelectionControl(l,n,e)}_initSelectionChangeListener(){this.disposeWithMe(this._refSelectionsService.selectionSet$.subscribe(e=>{this._reset(),this._skeleton&&this.resetSelectionsByModelData(e||[])}))}_initUserActionSyncListener(){this.disposeWithMe(this.selectionMoveStart$.subscribe(e=>{this._updateSelections(e,p.kFf.MOVE_START)})),this.disposeWithMe(this.selectionMoving$.subscribe(e=>{this._updateSelections(e,p.kFf.MOVING)})),this.disposeWithMe(this.selectionMoveEnd$.subscribe(e=>{this._updateSelections(e,p.kFf.MOVE_END)}))}_updateSelections(e,t){let n=this._context.unit.getActiveSheet().getSheetId();0!==e.length&&this._workbookSelections.setSelections(n,e.map(e=>(0,p.Y9H)(e)),t)}_initSkeletonChangeListener(){this.disposeWithMe(this._sheetSkeletonManagerService.currentSkeleton$.subscribe(e=>{var t;if(!e)return;let{skeleton:n}=e,{scene:r}=this._context,i=r.getViewport(v.p3k.VIEW_MAIN);this._skeleton&&(null==(t=this._skeleton.worksheet)?void 0:t.getSheetId())!==n.worksheet.getSheetId()&&this._reset(),this._changeRuntime(n,r,i);let l=this._workbookSelections.getCurrentSelections();this.resetSelectionsByModelData(l)}))}_getActiveViewport(e){let t=this._getSheetObject();return null==t?void 0:t.scene.getActiveViewportByCoord(v.I9Y.FromArray([e.offsetX,e.offsetY]))}_getSheetObject(){return(0,i.bB8)(this._context.unit,this._context)}_onPointerDown(e,t=0,n=r.$uV.NORMAL,i,l=v.rDM.ALL){var o;this._rangeType=n;let s=this._skeleton,u=this._scene;if(!u||!s)return;i&&(this._activeViewport=i);let{offsetX:a,offsetY:c}=e,d=u.getViewport(v.p3k.VIEW_MAIN);if(!d)return;let h=u.getCoordRelativeToViewport(v.I9Y.FromArray([a,c])),{x:f,y:g}=h;this._startViewportPosX=f,this._startViewportPosY=g;let m=u.getScrollXYInfoByViewport(h),{scaleX:S,scaleY:_}=u.getAncestorScale(),y=this._skeleton.getCellByOffset(f,g,S,_,m);if(!y)return;switch(n){case r.$uV.NORMAL:break;case r.$uV.ROW:y.startColumn=0,y.endColumn=this._skeleton.getColumnCount()-1;break;case r.$uV.COLUMN:y.startRow=0,y.endRow=this._skeleton.getRowCount()-1;break;case r.$uV.ALL:y.startRow=0,y.startColumn=0,y.endRow=this._skeleton.getRowCount()-1,y.endColumn=this._skeleton.getColumnCount()-1}let C={range:y,primary:y,style:null};(y.isMerged||y.isMergedMainCell)&&(C={range:{...y,startRow:y.startRow,endRow:y.startRow,startColumn:y.startColumn,endColumn:y.startColumn},primary:{...y,actualRow:y.startRow,actualColumn:y.startColumn,startRow:y.startRow,endRow:y.startRow,startColumn:y.startColumn,endColumn:y.startColumn},style:null}),C.range.rangeType=n;let b=(0,p.fcm)(C,this._skeleton);this._startRangeWhenPointerDown={...b.rangeWithCoord};let R={...b.rangeWithCoord,rangeType:n},x=this.getActiveSelectionControl();

1for(let t of this.getSelectionControls()){if(2===e.button&&r.M_G.contains(t.model,R)){x=t;return}if(t.model.isEqual(R)){x=t;break}}this._checkClearPreviousControls(e);let E=null==x?void 0:x.model.currentCell,I=e.shiftKey&&E,N=this._remainLastEnabled&&!e.ctrlKey&&!e.shiftKey&&!this._skipLastEnabled&&!this._singleSelectionEnabled;I&&E?this._makeSelectionByTwoCells(E,R,s,n,x):N&&x?x.updateRangeBySelectionWithCoord(b):x=this.newSelectionControl(u,s,C);for(let e=0;e<this.getSelectionControls().length-1;e++)this.getSelectionControls()[e].clearHighlight();this._selectionMoveStart$.next(this.getSelectionDataWithStyle()),u.disableObjectsEvent(),this._clearUpdatingListeners(),this._addEndingListeners(),null==(o=u.getTransformer())||o.clearSelectedObjects(),this._setupPointerMoveListener(d,x,n,l,f,g),this._escapeShortcutDisposable=this._shortcutService.forceEscape(),this._scenePointerUpSub=u.onPointerUp$.subscribeEvent(()=>{var e;this._clearUpdatingListeners(),this._selectionMoveEnd$.next(this.getSelectionDataWithStyle()),null==(e=this._escapeShortcutDisposable)||e.dispose(),this._escapeShortcutDisposable=null})}newSelectionControl(e,t,n){let r=this.getSelectionControls().length,{rowHeaderWidth:l,columnHeaderHeight:o}=t,s=new i.Y8A(e,r,this._themeService,{highlightHeader:this._highlightHeader,enableAutoFill:!1,rowHeaderWidth:l,columnHeaderHeight:o}),u=(0,p.fcm)(n,t);return s.updateRangeBySelectionWithCoord(u),this._selectionControls.push(s),s.setControlExtension({skeleton:t,scene:e,themeService:this._themeService,injector:this._injector,selectionHooks:{selectionMoveEnd:()=>{this._selectionMoveEnd$.next(this.getSelectionDataWithStyle())}}}),s}};eO=$([F(1,(0,r.y_5)(r.zZn)),F(2,(0,r.y_5)(r.Fsb)),F(3,_.nF),F(4,(0,r.y_5)(i.bPr)),F(5,r.oaf),F(6,p.BcG)],eO);let eD=(e,t,n=!0)=>{let r=-1;return e.reduce((e,i,l)=>{if(e.isFinish)return e;let o=e.currentIndex;if("string"!=typeof i)e.currentIndex+=i.token.length;else{let t=i.length;e.currentIndex+=t}return(n?e.currentIndex===t:t>o&&t<=e.currentIndex)&&(r=l,e.isFinish=!0),e},{currentIndex:0,isFinish:!1}),r},eF=(e,t)=>{let n=e[t],r=-1;if(!n||"string"==typeof n||n.nodeType!==l.kxp.REFERENCE)return -1;for(let n=0;n<=t;n++){let t=e[n];"string"!=typeof t&&t.nodeType===l.kxp.REFERENCE&&r++}return r};function e$(e,t,n){let i=(0,_.fJ)(m.Id),l=(0,C.useMemo)(()=>new c.t({left:-999,top:-999,right:-999,bottom:-999}),[]),o=(0,_.fJ)(_.Jj),s=(0,_.fJ)(r.HCr),u=(0,_._q)(()=>{var t;let n=i.getEditor(e);if(!n)return;let r=n.getBoundingClientRect(),{marginTop:o=0,marginBottom:s=0}=n.getDocumentData().documentStyle,u=n.getSkeleton();if(!u)return;let a=null==(t=u.getSkeletonData())?void 0:t.pages[0].height,{left:c,top:d,right:h,bottom:f}=r;d+=o,f=a?d+a:f-s;let g=l.getValue();if(g.left!==c||g.top!==d||g.right!==h||g.bottom!==f)return l.next({left:c-1,right:h+1,top:d-1,bottom:f+1}),r});return(0,C.useEffect)(()=>{t&&u()},[e,i,s.unitAdded$,u,t,...null!=n?n:[]]),((e,t=100)=>{(0,C.useEffect)(()=>{let n=null,r=()=>{null===n&&(n=window.setTimeout(()=>{e(),n=null},t))};return window.addEventListener("scroll",r),window.addEventListener("resize",r),()=>{null!==n&&clearTimeout(n),window.removeEventListener("scroll",r),window.removeEventListener("resize",r)}},[e,t])})(u),(0,C.useEffect)(()=>{let e=o.scrollEvent$.pipe((0,d.c)(100)).subscribe(u);return()=>{e.unsubscribe()}},[]),[l,u]}let eA=e=>{let t=(0,C.useRef)(e);return t.current=e,t},eU=({onClick:e})=>(0,b.jsx)("div",{className:"univer-z-[15] univer-box-border univer-h-[18px] univer-cursor-pointer univer-overflow-visible univer-whitespace-nowrap univer-rounded-l univer-border univer-border-r-0 univer-border-gray-600 univer-bg-primary-600 univer-p-0.5 univer-text-xs univer-font-bold univer-leading-[13px] univer-text-white",onClick:e,children:"?"}),eL=({className:e,title:t,value:n})=>(0,b.jsxs)("div",{className:"univer-my-2",children:[(0,b.jsx)("div",{className:(0,R.$z)("univer-mb-2 univer-text-sm univer-font-medium univer-text-gray-900 dark:!univer-text-white",e),children:t}),(0,b.jsx)("div",{className:"univer-whitespace-pre-wrap univer-break-words univer-text-xs univer-text-gray-500",children:n})]}),ej=e=>{let{prefix:t,value:n,active:r,onClick:i}=e;return(0,b.jsxs)("div",{children:[(0,b.jsxs)("span",{children:[t,"("]}),n&&n.map((e,t)=>(0,b.jsxs)("span",{children:[(0,b.jsx)("span",{className:r===t?"univer-text-primary-500":"",onClick:()=>i(t),children:eC(e)}),t===n.length-1?"":","]},e.name)),")"]})};function eP(e){let{onParamsSwitch:t=r.lQ1,onClose:n=r.lQ1,isFocus:o,editor:u,formulaText:c}=e,{functionInfo:d,paramIndex:g,reset:m}=((e,t,n)=>{let r=(0,_.fJ)(A),i=(0,_.fJ)(S.Fy),o=(0,_.fJ)(l.GMK),[u,c]=(0,C.useState)(),[d,g]=(0,C.useState)(-1),[m,v]=(0,C.useState)(!0),p=eA(m),y=(0,C.useRef)(t);y.current=t;let b=()=>{c(void 0),g(-1),v(!1)};return(0,C.useEffect)(()=>{let e=o.sequenceNodesBuilder(t.slice(1));r.setSequenceNodes(null!=e?e:[])},[t]),(0,C.useEffect)(()=>

1{if(n&&e){let e=n.selectionChange$.pipe((0,s.B)(50)).subscribe(e=>{if(1===e.textRanges.length){let[t]=e.textRanges;if(t.collapsed&&p.current){let{startOffset:e}=t,n=r.getCurrentSequenceNodeIndex(e-2),s=r.getCurrentSequenceNodeByIndex(n),u=r.getCurrentSequenceNodeByIndex(n+1);if(s)if("string"==typeof s||3!==s.nodeType||i.hasDefinedNameDescription(s.token.trim())||u!==l.RD4.OPEN_BRACKET){let t=o.getFunctionAndParameter(`${y.current}A`,e-1);if(t){let{functionName:e,paramIndex:n}=t;c(i.getFunctionInfo(e)),g(n);return}}else{c(i.getFunctionInfo(s.token)),g(-1);return}}}c(void 0),g(-1)}),t=n.selectionChange$.pipe((0,h.p)(e=>1===e.textRanges.length),(0,a.T)(e=>e.textRanges[0].startOffset),(0,f.F)()).subscribe(()=>{v(!0)});return()=>{e.unsubscribe(),t.unsubscribe()}}},[n,e]),(0,C.useEffect)(()=>{e||b()},[e]),{functionInfo:u,paramIndex:d,reset:b}})(o,c,u),v=(0,_.fJ)(i.JDd),p=!(0,_.J2)(v.helpFunctionVisible$),[y,x]=(0,C.useState)(!1),N=(0,_.fJ)(r.iH9),w=N.t("sheets-formula-ui.prompt.required"),k=N.t("sheets-formula-ui.prompt.optional"),[T]=e$(u.getEditorId(),!!d,[d,g]),M=(0,_._q)(e=>{v.helpFunctionVisible$.next(!e)});return d?p?(0,b.jsx)(_.VX,{portal:!0,anchorRect$:T,direction:"left-center",children:(0,b.jsx)(eU,{onClick:()=>M(!1)})},"hidden"):(0,b.jsx)(_.VX,{portal:!0,onClickOutside:()=>m(),anchorRect$:T,direction:"vertical",children:(0,b.jsxs)("div",{className:(0,R.$z)("univer-m-0 univer-box-border univer-w-[250px] univer-select-none univer-list-none univer-rounded-lg univer-bg-white univer-leading-5 univer-shadow-md univer-outline-none dark:!univer-bg-gray-900",R.gW),children:[(0,b.jsxs)("div",{className:(0,R.$z)("univer-box-border univer-flex univer-items-center univer-justify-between univer-px-4 univer-py-3 univer-text-xs univer-font-medium univer-text-gray-900 dark:!univer-text-white",R.vp),style:{overflowWrap:"anywhere"},children:[(0,b.jsx)(ej,{prefix:d.functionName,value:d.functionParameter,active:g,onClick:function(e){t&&t(e)}}),(0,b.jsxs)("div",{className:"univer-flex",children:[(0,b.jsx)("div",{className:"univer-ml-2 univer-flex univer-size-6 univer-cursor-pointer univer-items-center univer-justify-center univer-rounded univer-bg-transparent univer-p-0 univer-text-xs univer-text-gray-500 univer-outline-none univer-transition-colors hover:univer-bg-gray-200 dark:hover:!univer-bg-gray-600",style:{transform:y?"rotateZ(-90deg)":"rotateZ(90deg)"},onClick:()=>x(!y),children:(0,b.jsx)(E.Z,{})}),(0,b.jsx)("div",{className:"univer-ml-2 univer-flex univer-size-6 univer-cursor-pointer univer-items-center univer-justify-center univer-rounded univer-bg-transparent univer-p-0 univer-text-xs univer-text-gray-600 univer-outline-none univer-transition-colors hover:univer-bg-gray-300 dark:!univer-text-gray-200 dark:hover:!univer-bg-gray-600",onClick:()=>{M(!0),n()},children:(0,b.jsx)(I.U,{})})]})]}),(0,b.jsx)("div",{className:(0,R.$z)("univer-box-border univer-max-h-[350px] univer-overflow-y-auto univer-px-4 univer-pb-3 univer-pt-0",R.oN),style:{height:y?"unset":0,padding:y?"revert-layer":0},children:(0,b.jsxs)("div",{className:"univer-mt-3",children:[(0,b.jsx)(eL,{title:N.t("sheets-formula-ui.prompt.helpExample"),value:`${d.functionName}(${d.functionParameter.map(e=>e.example).join(",")})`}),(0,b.jsx)(eL,{title:N.t("sheets-formula-ui.prompt.helpAbstract"),value:d.description}),d&&d.functionParameter&&d.functionParameter.map((e,t)=>(0,b.jsx)(eL,{className:g===t?"univer-text-primary-500":"",title:e.name,value:`${e.require?w:k} ${e.detail}`},t))]})})]})},"show"):null}function eV(e){var t;let{unitId:n,subUnitId:i,currentWorkbook:o,refSelections:s,editor:u,refSelectionsService:a,refSelectionsRenderService:c,sheetSkeletonManagerService:d,themeService:h,univerInstanceService:f}=e,g=o.getUnitId(),m=f.getUnit(n,r.Zy$.UNIVER_SHEET),v=null==m?void 0:m.getActiveSheet(),S=[];if(!m||!v)return void a.setSelections(S);let _=v.getSheetId(),y=e=>{var t;return null==m||null==(t=m.getSheetBySheetName(e))?void 0:t.getSheetId()};if(!(null==d?void 0:d.getSkeleton(_)))return;let C=[];for(let e=0,t=s.length;e<t;e++){let{themeColor:t,token:o,refIndex:u,endIndex:a}=s[e],{unitId:c,sheetName:d,range:f}=(0,l.YJw)(o),m=y(d);if(!m&&d||g!==n&&c!==g||c&&c!==g||m&&m!==_||!m&&_!==i)continue;let b=(0,p.cpS)(f,v.getRowCount(),v.getColumnCount());b.unitId=n,b.sheetId=_,S.push({range:b,primary:null,style:{id:u.toString(),strokeWidth:1,stroke:t,fill:new r.mKL(t).setAlpha(.05).toRgbString(),widgets:{tl:!0,tc:!0,tr:!0,ml:!0,mr:!0,bl:!0,bc:!0,br:!0},widgetSize:6,widgetStrokeWidth:1,widgetStroke:h.getColorFromTheme("white")}}),C.push(a)}if(u){let e=null==(t=u.getSelectionRanges())||null==(t=t[0])?void 0:t.startOffset,n=C.findIndex(t=>t+2===e);

1-1!==n?null==c||c.setActiveSelectionIndex(n):null==c||c.resetActiveSelectionIndex()}return S}function eW(e=""){let t,n=(0,_.fJ)(S.Fy),i=(t=(0,_.fJ)(r.Fsb),(0,C.useMemo)(()=>({formulaRefColors:[t.getColorFromTheme("loop-color.1"),t.getColorFromTheme("loop-color.2"),t.getColorFromTheme("loop-color.3"),t.getColorFromTheme("loop-color.4"),t.getColorFromTheme("loop-color.5"),t.getColorFromTheme("loop-color.6"),t.getColorFromTheme("loop-color.7"),t.getColorFromTheme("loop-color.8"),t.getColorFromTheme("loop-color.9"),t.getColorFromTheme("loop-color.10"),t.getColorFromTheme("loop-color.11"),t.getColorFromTheme("loop-color.12")].map(e=>t.isValidThemeColor(e)?t.getColorFromTheme(e):e),numberColor:t.getColorFromTheme("blue.700"),stringColor:t.getColorFromTheme("jiqing.800"),plainTextColor:t.getColorFromTheme("black")}),[t.getCurrentTheme()])),o=(0,_.fJ)(r.wTY),s=(0,C.useMemo)(()=>e.length,[e]);return(0,_._q)((t,u,a=!0,c)=>{let d=t.getDocumentData(),h=t.getEditorId();if(!d)return[];let f=d.body;if(!f)return[];let g=f.dataStream.slice(0,f.dataStream.length-2),v={dataStream:"",...d.body};if(!g.startsWith(e))return[];if(null==u||0===u.length)return v.textRuns=[],o.syncExecuteCommand(m.Z7.id,{unitId:h,body:(0,r.DyH)(v,0,v.dataStream.length-2)}),[];{let d,{textRuns:f,refSelections:g}=function(e,t,n){let{formulaRefColors:r,numberColor:i,stringColor:o,plainTextColor:s}=t,u=[],a=[],c=new Map,d=0;for(let t=0,h=n.length;t<h;t++){let h=n[t];if("string"==typeof h){let e=u[u.length-1],t=e?e.ed:0,n=t+h.length;u.push({st:t,ed:n,ts:{cl:{rgb:s},fs:11}});continue}if(e.hasDefinedNameDescription(h.token.trim())){u.push({st:h.startIndex,ed:h.endIndex+1,ts:{cl:{rgb:s},fs:11}});continue}let{startIndex:f,endIndex:g,nodeType:m,token:v}=h,p="";m===l.kxp.REFERENCE?(c.has(v)?p=c.get(v):(p=r[d%r.length],c.set(v,p),d++),a.push({refIndex:t,themeColor:p,token:v,startIndex:h.startIndex,endIndex:h.endIndex,index:a.length})):m===l.kxp.NUMBER?p=i:m===l.kxp.STRING?p=o:m===l.kxp.ARRAY&&(p=o),p&&p.length>0?u.push({st:f,ed:g+1,ts:{cl:{rgb:p},fs:11}}):u.push({st:f,ed:g+1,ts:{cl:{rgb:s},fs:11}})}return{textRuns:u,refSelections:a}}(n,i,u);if(s&&f.forEach(e=>{e.ed=e.ed+s,e.st=e.st+s}),v.textRuns=[{st:0,ed:1,ts:{fs:11}},...f],v.dataStream=`${e}${u.reduce((e,t)=>"string"==typeof t?`${e}${t}`:`${e}${t.token}`,"")}\r
2`,a){d=t.getSelectionRanges();let e=v.dataStream.length-2+s;d.forEach(t=>{t.startOffset=Math.max(0,Math.min(t.startOffset,e)),t.endOffset=Math.max(0,Math.min(t.endOffset,e))})}return o.syncExecuteCommand(m.Z7.id,{unitId:h,body:(0,r.DyH)(v,0,v.dataStream.length-2),textRanges:null!=c?c:d}),g}})}let eB=e=>e.map(e=>"string"==typeof e?e:e.token).join(""),eJ=(e,t=!1,n="",r=!1)=>t||r?e.map(e=>r?(0,l.x4m)(e):""!==e.sheetName&&e.sheetName!==n?(0,l.jzl)(e.sheetName,e.range):(0,l.ocP)(e.range)):e.map(e=>(0,l.ocP)(e.range)),eq=(0,C.forwardRef)(function(e,t){let{isFocus:n,sequenceNodes:i,onSelect:o,editor:u,onClose:a=r.lQ1}=e,c=u.getEditorId(),d=(0,_.fJ)(_.nF),h=(0,_.fJ)(r.wTY),{searchList:f,searchText:g,handlerFormulaReplace:m,reset:p}=((e,t=[],n)=>{let r=(0,_.fJ)(S.Fy),[i,o]=(0,C.useState)([]),[u,a]=(0,C.useState)(""),c=(0,C.useRef)(-1),d=eA({nodes:t}),h=()=>{o([]),a(""),c.current=-1};return(0,C.useEffect)(()=>{if(n&&e){let e=n.input$.pipe((0,s.B)(300)).subscribe(()=>{let e=n.getSelectionRanges();if(1===e.length){let t=d.current.nodes,n=e[0];if(n.collapsed){let e=eD(t,n.startOffset-1,!1);c.current=e;let i=t[e];if(i&&"string"!=typeof i&&i.nodeType===l.kxp.FUNCTION){c.current=e;let t=i.token;o(r.getSearchListByNameFirstLetter(t).slice(0,10)),a(t);return}}}c.current=-1,a(""),o(e=>(null==e?void 0:e.length)?[]:e)});return()=>{e.unsubscribe()}}},[n,e]),(0,C.useEffect)(()=>{e||h()},[e]),{searchList:i,searchText:u,handlerFormulaReplace:(e,t)=>(function(e,t,n,r){let i=[...e];if(-1!==t){var o;let e=i.splice(t+1),s=i.pop()||"",u=("string"==typeof s?s.length:s.token.length)-n.length;return i.push(n),e[0]!==l.RD4.OPEN_BRACKET&&(o=r)!==l.RKz.DefinedName&&o!==l.RKz.Table&&(i.push(l.RD4.OPEN_BRACKET),u--),{text:eB([...i,...e]),offset:u}}})(d.current.nodes,c.current,e,t),reset:h}})(n,i,u),y=(0,C.useMemo)(()=>!!f.length,[f]),x=(0,C.useRef)(void 0),[E,I]=(0,C.useState)(0),N=(0,C.useRef)(!1),[w]=e$(c,y,[g,f]),k=eA({searchList:f,active:E}),T=(e,t)=>

2{let n=m(e,t);n&&(p(),o(n))};function M(){N.current&&I(-1)}function O(e){let t=x.current;if(!t)return;let n=t.children[e];if(!n)return;let r=t.getBoundingClientRect().top,i=t.offsetHeight,l=n.getBoundingClientRect(),o=l.top,s=l.height;if(o>=0&&o>r&&o-r+s<=i)return;let u=n.offsetTop-(i-s)/2;t.scrollTo({top:u,behavior:"smooth"})}(0,C.useEffect)(()=>{if(!f.length)return;let e=`sheet.formula-embedding-editor.search_function.${c}`,t=new r.VdD;return t.add(h.registerCommand({id:e,type:r.g4t.OPERATION,handler(e,t){let{keyCode:n}=t;(e=>{let{searchList:t,active:n}=k.current;switch(e){case _.DD.ARROW_UP:I(e=>{let t=Math.max(0,e-1);return O(t),t});break;case _.DD.ARROW_DOWN:I(e=>{let n=Math.min(t.length-1,e+1);return O(n),n});break;case _.DD.TAB:case _.DD.ENTER:{let e=t[n];T(e.name,e.functionType);break}case _.DD.ESC:p(),a()}})(n)}})),[_.DD.ARROW_UP,_.DD.ARROW_DOWN,_.DD.ENTER,_.DD.ESC,_.DD.TAB].map(t=>({id:e,binding:t,preconditions:()=>!0,priority:1e3,staticParameters:{eventType:v.bKQ.Keyboard,keyCode:t}})).forEach(e=>{t.add(d.registerShortcut(e))}),()=>{t.dispose()}},[f]);let D=(0,C.useMemo)(()=>{let e="";return()=>{clearTimeout(e),N.current=!0,e=setTimeout(()=>{N.current=!1},300)}},[]);return f.length>0&&y&&(0,b.jsx)(_.VX,{portal:!0,anchorRect$:w,direction:"vertical",children:(0,b.jsx)("ul",{ref:e=>{x.current=e,t&&(t.current=e)},"data-u-comp":"sheets-formula-editor",className:(0,R.$z)("univer-m-0 univer-box-border univer-max-h-[400px] univer-w-[250px] univer-list-none univer-overflow-y-auto univer-rounded-lg univer-bg-white univer-p-2 univer-leading-5 univer-shadow-md univer-outline-none dark:!univer-bg-gray-900",R.gW,R.oN),children:f.map((e,t)=>(0,b.jsxs)("li",{className:(0,R.$z)("univer-box-border univer-cursor-pointer univer-rounded univer-px-2 univer-py-1 univer-text-gray-900 univer-transition-colors dark:!univer-text-white",{"univer-bg-gray-200 dark:!univer-bg-gray-600":E===t}),onMouseEnter:()=>{N.current&&I(t)},onMouseLeave:M,onMouseMove:D,onClick:()=>{T(e.name,e.functionType),u&&u.focus()},children:[(0,b.jsxs)("span",{className:"univer-block univer-truncate univer-text-xs",children:[(0,b.jsx)("span",{className:"univer-text-red-500",children:e.name.substring(0,g.length)}),(0,b.jsx)("span",{children:e.name.slice(g.length)})]}),(0,b.jsx)("span",{className:"univer-block univer-text-xs univer-text-gray-400",children:e.desc})]},e.name))})})}),eH=(0,C.forwardRef)((e,t)=>{var n,o,u,a,c,d,f;let S,x,E,I,N,w,k,T,M,O,D,F,$,A,U,L,j,P,V,W,B,J,q,H,{errorText:K,initValue:z,unitId:G,subUnitId:Z,isFocus:Y=!0,isSupportAcrossSheet:Q=!1,onFocus:X=r.lQ1,onBlur:ee=r.lQ1,onChange:et,onVerify:en,className:er,editorId:ei,moveCursor:el=!0,onFormulaSelectingChange:eo,keyboardEventConfig:es,onMoveInEditor:eu,resetSelectionOnBlur:ea=!0,autoScrollbar:ec=!0,isSingle:ed=!0,disableSelectionOnClick:eh=!1,autofocus:ef=!0,disableContextMenu:eg,style:em,borderless:ev=!1,canvasStyle:ep}=e,eS=(0,_.fJ)(m.Id),e_=(0,C.useRef)(null),ey=(0,_._q)(et);(0,C.useImperativeHandle)(t,()=>({isClickOutSide:e=>!!e_.current&&!e_.current.contains(e.target)}));let eC=(0,_._q)(eo),eb=(0,C.useRef)(null),eR=(0,C.useRef)(void 0),ex=eR.current,[eE,eI]=(0,C.useState)(Y),eN=(0,C.useRef)(null),ew=(0,C.useMemo)(()=>null!=ei?ei:(0,r.EDB)(`${i.fTm}-${(0,r.MZQ)(4)}`),[]),ek=(0,C.useMemo)(()=>void 0!==K,[K]),eT=(0,_.fJ)(r.HCr),eM=eT.getUnit(ew);(0,_.J2)(null==eM?void 0:eM.change$);let e$=(S=(0,_.fJ)(l.GMK),(0,C.useCallback)(e=>S.sequenceNodesBuilder(e)||[],[S])),eU=r.Z4q.transform.getPlainText(null!=(n=null==eM||null==(o=eM.getBody())?void 0:o.dataStream)?n:""),eL=eA(eU),ej=(0,C.useMemo)(()=>eU.startsWith(l.gmK.EQUALS)?eU.slice(1):"",[eU]),eH=(0,C.useMemo)(()=>e$(ej),[ej,e$]),{isSelecting:eK,isSelectingRef:ez}=function(e){var t;let{editorId:n,isFocus:i,disableOnClick:o,unitId:s,subUnitId:u}=e,a=(0,_.fJ)(v.cSx),c=(0,_.fJ)(r.HCr),d=a.getRenderById(s),f=a.getRenderById(n),g=null==f?void 0:f.with(m.qw),p=(0,_.fJ)(y.pv),S=(0,_.fJ)(r.zZn),[b,R]=(0,C.useState)(0),x=(0,_.fJ)(l.GMK),E=(0,C.useRef)(!0),I=null==d?void 0:d.with(eO),N=eA(b),w=c.getUnit(s,r.Zy$.UNIVER_SHEET),k=null==w?void 0:w.getSheetBySheetId(u),T=(0,_._q)(e=>{I&&I.setSkipLastEnabled(1===e||3===e||4===e),N.current=e,R(e)}),M=(0,_._q)(()=>{var e,t,n;let i=c.getCurrentUnitOfType(r.Zy$.UNIVER_SHEET);if(!i)return;let o=i.getActiveSheet(),s=null==g?void 0:g.getActiveTextRange(),u=(null==s?void 0:s.collapsed)?s.startOffset:-1,a=function(e){var t,n;let i=e.get(r.HCr).getCurrentUniverDocInstance();if(null==i?void 0:i.getBody())return{dataStream:null!=(t=null==(n=i.getBody())?void 0:n.dataStream)?t:"",offset:0}}(S);if(!a)return;let d=null==a||null==(e=a.dataStream)?void 0:e.slice(0,-2),h=(null!=(t=x.sequenceNodesBuilder(d))?t:[]).map(e=>"object"==typeof e?e.nodeType===l.kxp.REFERENCE?{...e,range:(0,l.YKh)(e.token)}:{...e,range:void 0}:e),f=d[u-1],m=d[u],v=h.find(e=>"object"==typeof e&&e.nodeType===l.kxp.REFERENCE&&u===e.endIndex+2),p=f&&(0,l.mVA)(f)&&(!m||(0,l.Ol5)(m)&&m!==l.RD4.OPEN_BRACKET),_=!!v;if((null==d?void 0:d.substring(0,1))==="="&&(p||_))if(_){if(E.current)return;let{sheetName:e,unitId:t}=v.range,i=null==(n=c.getCurrentUnitOfType(r.Zy$.UNIVER_SHEET))?void 0:n.getUnitId();t&&t!==i?T(4):(e||o.getSheetId()!==(null==k?void 0:k.getSheetId()))&&e!==o.getName()?T(3):T(2)}else E.current=!1,T(1);else T(0)});return(0,C.useEffect)(()=>{let e=p.textSelection$.pipe((0,h.p)(e=>e.unitId===n)).subscribe(()=>{M()});return()=>e.unsubscribe()},[M,p.textSelection$,n]),(0,C.useEffect)(()=>{i||(T(0),E.current=!0)},[i,T]),(0,C.useEffect)(()=>{var e;if(!o)return;let t=null==f||null==(e=f.mainComponent)?void 0:e.onPointerDown$.subscribeEvent(()=>{T(0),E.current=!0});return()=>null==t?void 0:t.unsubscribe()},[o,null==f||null==(t=f.mainComponent)?void 0:t.onPointerDown$,T]),(0,C.useEffect)(()=>

2{if(!i)return;let e=null==w?void 0:w.activeSheet$.subscribe(()=>{M()}),t=c.getCurrentTypeOfUnit$(r.Zy$.UNIVER_SHEET).subscribe(()=>{M()});return()=>{null==e||e.unsubscribe(),null==t||t.unsubscribe()}},[M,i,null==w?void 0:w.activeSheet$,c.getCurrentTypeOfUnit$]),{isSelecting:b,isSelectingRef:N}}({unitId:G,subUnitId:Z,editorId:ew,isFocus:eE,disableOnClick:eh}),eG=(0,C.useRef)(""),eZ=(0,_.fJ)(v.cSx).getRenderById(ew),eY=null==eZ?void 0:eZ.with(m.qw),eQ=null==eY?void 0:eY.isFocusing,eX=(0,_.J2)((0,C.useMemo)(()=>eT.getCurrentTypeOfUnit$(r.Zy$.UNIVER_DOC),[eT])),e0=(null==eX?void 0:eX.getUnitId())===ew,e1=(0,C.useRef)([]),e2=null==(u=null==(a=(0,_.fJ)(r.J0C).getConfig("sheets-formula-ui.base.config"))?void 0:a.functionScreenTips)||u;(0,_.w5)(()=>{ey(eU)},[eU,ey]);let e5=eW("="),e3=(x=(0,_.fJ)(r.HCr),E=(0,_.fJ)(r.Fsb),I=(0,_.fJ)(p.BcG),N=(0,_.fJ)(v.cSx),T=null==(k=(w=(0,_.J2)((0,C.useMemo)(()=>x.getCurrentTypeOfUnit$(r.Zy$.UNIVER_SHEET),[x])))?N.getRenderById(w.getUnitId()):null)?void 0:k.with(eO),M=null==k?void 0:k.with(i.bPr),O=(0,_._q)((e,t)=>{let n=x.getCurrentUnitOfType(r.Zy$.UNIVER_SHEET);if(!n||(null==T?void 0:T.selectionMoving))return;let i=eV({unitId:G,subUnitId:Z,currentWorkbook:n,refSelections:e,editor:t,refSelectionsService:I,refSelectionsRenderService:T,sheetSkeletonManagerService:M,themeService:E,univerInstanceService:x});i&&(((null==T?void 0:T.getSelectionControls())||[]).length===i.length?null==T||T.resetSelectionsByModelData(i):I.setSelections(i))}),(0,C.useEffect)(()=>()=>{null==T||T.resetActiveSelectionIndex()},[T]),O),e6=(0,_._q)((e,t=!0,n,r)=>{if(!eR.current)return;eG.current=e;let i="="===e[0]?e.slice(1):"",l=e$(i),o=l.reduce((e,t)=>"object"==typeof t?`${e}${t.token}`:`${e}${t}`,""),s=e5(eR.current,o===i?l:[],t,r);if(e1.current=s,n){let e=null!=r?r:null==ex?void 0:ex.getSelectionRanges();if((null==e?void 0:e.length)!==1)return;let t=eF(l,eD(l,e[0].startOffset-1,!1));if(t>=0){let e=s.splice(t,1)[0];e&&s.push(e)}e3(eE?s:[],eR.current)}});(0,C.useEffect)(()=>{eE&&e6(eU,!1,!0)},[eE]),(0,C.useEffect)(()=>{eE&&eG.current!==eU&&e6(eU,!1,!0)},[eU]),D=(0,_.fJ)(l.GMK),F=(0,C.useRef)(!0),(0,C.useEffect)(()=>{if(eE){let e=setTimeout(()=>{F.current=!1},500);return()=>{clearTimeout(e)}}},[eE]),(0,C.useEffect)(()=>{!F.current&&en&&en(0===D.checkIfAddBracket(eU)&&eU.startsWith(l.gmK.EQUALS),`${eU}`)},[eU,en]);let e4=($=(0,_.fJ)(m.Id),(0,_._q)(e=>{if(ex){$.focus(ex.getEditorId());let i=[...ex.getSelectionRanges()];if(r.S0q.isDefine(e))ex.setSelectionRanges([{startOffset:e,endOffset:e}]);else if(i.length||ex.docSelectionRenderService.isOnPointerEvent)ex.setSelectionRanges(i);else{var t,n;let e=Math.max((null!=(t=null==(n=ex.getDocumentData().body)?void 0:n.dataStream)?t:"\r\n").length-2,0);ex.setSelectionRanges([{startOffset:e,endOffset:e}])}}})),e9=(A=(0,_.fJ)(r.HCr),U=(0,_.fJ)(p.Fal),(0,C.useCallback)(()=>{if(eE){let e=[...U.getWorkbookSelections(G).getSelectionsOfWorksheet(Z)],t=A.getCurrentUnitOfType(r.Zy$.UNIVER_SHEET),n=null==t?void 0:t.getActiveSheet();(null==t?void 0:t.getUnitId())!==G&&A.setCurrentUnitForType(G),n&&n.getSheetId()===Z&&U.setSelections(e)}},[eE,U,Z,G,A]));(0,C.useEffect)(()=>{var e;eC(eK,null==(e=null==eY?void 0:eY.isFocusing)||e)},[eC,eK]),(0,m.v_)(eE,es,ex),(0,C.useLayoutEffect)(()=>{let e;if(eN.current){var t;e=eS.register({autofocus:ef,editorUnitId:ew,initialSnapshot:{id:ew,body:{dataStream:`${z}\r
3`,textRuns:[],customBlocks:[],customDecorations:[],customRanges:[]},documentStyle:{pageSize:{width:1/0,height:1/0},documentFlavor:r.CQy.UNSPECIFIED,marginTop:0,marginBottom:0,marginRight:0,marginLeft:0,paragraphLineGapDefault:0,renderConfig:{horizontalAlign:r.wqs.UNSPECIFIED,verticalAlign:r.G4t.TOP}}},canvasStyle:{...ep,backgroundColor:null!=(t=null==ep?void 0:ep.backgroundColor)?t:"#fff"}},eN.current),eR.current=eS.getEditor(ew),e6(z,!1,!0)}return()=>{null==e||e.dispose()}},[]),(0,C.useLayoutEffect)(()=>{let e=0,t=0,n=()=>{!Y||(null==eY?void 0:eY.isFocusing)||e4()};return Y?(eI(Y),e4(),e=requestAnimationFrame(()=>{n(),t=requestAnimationFrame(n)})):(ea&&(null==ex||ex.blur(),e9()),eI(Y)),()=>{cancelAnimationFrame(e),cancelAnimationFrame(t)}},[Y,eY,ex,e4,e9,ea]);let{checkScrollBar:e8}=(0,m.st)(ex,ed,ec);((e,t,n,i=!0)=>{var l;let o=(0,_.fJ)(v.cSx),s=(0,_.fJ)(r.oaf),u=(0,_.fJ)(_.ZL),a=(0,_.fJ)(p.BcG),c=(0,_.fJ)(r.HCr),d=(0,_.J2)((0,C.useMemo)(()=>c.getCurrentTypeOfUnit$(r.Zy$.UNIVER_SHEET),[c])),h=o.getRenderById(null!=(l=null==d?void 0:d.getUnitId())?l:""),f=null==h?void 0:h.with(eO);(0,C.useLayoutEffect)(()=>

3{if(e)return s.setContextValue(r.AF$,!0),i&&u.disable(),()=>{let e=c.getCurrentUnitOfType(r.Zy$.UNIVER_DOC);(null==e?void 0:e.getUnitId())===n&&s.setContextValue(r.AF$,!1),i&&u.enable(),a.clear()}},[s,e,a,i,n]),(0,C.useLayoutEffect)(()=>{if(e&&t){let e=null==f?void 0:f.enableSelectionChanging();return s.setContextValue(p.C5D,!0),()=>{s.setContextValue(p.C5D,!1),null==e||e.dispose()}}},[s,e,f,t]),(0,C.useEffect)(()=>{e&&(null==f||f.setSkipLastEnabled(!1))},[e,f])})(eE,!!(eK&&e0),ew,eg),c=!!(eE&&eQ&&el),L=(0,_.fJ)(r.wTY),j=(0,_.fJ)(_.nF),(P=(0,C.useRef)(eK)).current=eK,(V=(0,C.useRef)(eu)).current=eu,(0,C.useEffect)(()=>{if(!ex||!c)return;let e=`sheet.formula-embedding-editor.${ex.getEditorId()}`,t=new r.VdD;return t.add(L.registerCommand({id:e,type:r.g4t.OPERATION,handler(e,t){let n,{keyCode:l,metaKey:o}=t;n=r.OP3.DOWN,l===_.DD.ARROW_DOWN?n=r.OP3.DOWN:l===_.DD.ARROW_UP?n=r.OP3.UP:l===_.DD.ARROW_LEFT?n=r.OP3.LEFT:l===_.DD.ARROW_RIGHT&&(n=r.OP3.RIGHT),P.current?o===_.SK.CTRL_COMMAND?L.executeCommand(i.LQ_.id,{direction:n,jumpOver:i.$G5.moveGap,extra:"formula-editor",fromCurrentSelection:1===P.current||3===P.current}):o===_.SK.SHIFT?L.executeCommand(i.MIk.id,{direction:n,extra:"formula-editor"}):o===(_.SK.CTRL_COMMAND|_.SK.SHIFT)?L.executeCommand(i.MIk.id,{direction:n,jumpOver:i.$G5.moveGap,extra:"formula-editor"}):L.executeCommand(i.LQ_.id,{direction:n,extra:"formula-editor",fromCurrentSelection:1===P.current||3===P.current}):((e,t)=>{if(V.current)return V.current(e,t);let n=r.OP3.LEFT;e===_.DD.ARROW_DOWN?n=r.OP3.DOWN:e===_.DD.ARROW_UP?n=r.OP3.UP:e===_.DD.ARROW_RIGHT&&(n=r.OP3.RIGHT),t===_.SK.SHIFT?L.executeCommand(m.ve.id,{direction:n}):L.executeCommand(m.zm.id,{direction:n})})(l,o)}})),[{keyCode:_.DD.ARROW_DOWN},{keyCode:_.DD.ARROW_LEFT},{keyCode:_.DD.ARROW_RIGHT},{keyCode:_.DD.ARROW_UP},{keyCode:_.DD.ARROW_DOWN,metaKey:_.SK.SHIFT},{keyCode:_.DD.ARROW_LEFT,metaKey:_.SK.SHIFT},{keyCode:_.DD.ARROW_RIGHT,metaKey:_.SK.SHIFT},{keyCode:_.DD.ARROW_UP,metaKey:_.SK.SHIFT},{keyCode:_.DD.ARROW_DOWN,metaKey:_.SK.CTRL_COMMAND},{keyCode:_.DD.ARROW_LEFT,metaKey:_.SK.CTRL_COMMAND},{keyCode:_.DD.ARROW_RIGHT,metaKey:_.SK.CTRL_COMMAND},{keyCode:_.DD.ARROW_UP,metaKey:_.SK.CTRL_COMMAND},{keyCode:_.DD.ARROW_DOWN,metaKey:_.SK.CTRL_COMMAND|_.SK.SHIFT},{keyCode:_.DD.ARROW_LEFT,metaKey:_.SK.CTRL_COMMAND|_.SK.SHIFT},{keyCode:_.DD.ARROW_RIGHT,metaKey:_.SK.CTRL_COMMAND|_.SK.SHIFT},{keyCode:_.DD.ARROW_UP,metaKey:_.SK.CTRL_COMMAND|_.SK.SHIFT}].map(({keyCode:t,metaKey:n})=>({id:e,binding:n?t|n:t,preconditions:()=>!0,priority:900,staticParameters:{eventType:v.bKQ.Keyboard,keyCode:t,metaKey:n}})).forEach(e=>{t.add(j.registerShortcut(e))}),()=>{t.dispose()}},[L,ex,c,j]);let e7=(0,_._q)((e,t,n)=>{!eQ||(e6(`=${e}`,!0,n,-1!==t?[{startOffset:t+1,endOffset:t+1,collapsed:!0}]:void 0),n&&(e4(),-1!==t&&setTimeout(()=>{let e=null==ex?void 0:ex.render.with(m.r0);null==e||e.scrollToRange({startOffset:t+1,endOffset:t+1,collapsed:!0})},50),e8()))});return((e,t,n,o,u,a,c,d,h,f=r.lQ1)=>{var m;let S=(0,_.fJ)(v.cSx),b=(0,_.fJ)(r.HCr),R=(0,_.fJ)(r.wTY),x=(0,_.fJ)(y.pv),E=(0,_.fJ)(r.Fsb),I=(0,_.fJ)(l.GMK),N=b.getUnit(o),w=(0,_._q)((e,t)=>{var n,r;return null!=(n=null==(r=b.getUnit(e))||null==(r=r.getSheetBySheetId(t))?void 0:r.getName())?n:""}),k=(0,C.useMemo)(()=>w(o,u),[w,u,o]),T=(0,_.J2)(null==N?void 0:N.activeSheet$),M=eA({activeSheet:T,sheetName:k}),O=(0,_.J2)((0,C.useMemo)(()=>b.getCurrentTypeOfUnit$(r.Zy$.UNIVER_SHEET),[b])),D=S.getRenderById(null!=(m=null==O?void 0:O.getUnitId())?m:""),F=null==D?void 0:D.with(eO),$=null==D?void 0:D.with(i.bPr),A=(0,_.fJ)(p.BcG),U=(0,_._q)((e,t,r)=>{var i,s,a,d,g,m,v,p,S,_;let y=(e=>{var t,n,r;let{editor:i,lexerTreeBuilder:l}=e,o=null==i?void 0:i.getSelectionRanges();if((null==o?void 0:o.length)!==1)return;let s=o[0].startOffset-1,u=(null!=(t=null==i||null==(n=i.getDocumentData().body)?void 0:n.dataStream)?t:"\r\n").slice(0,-2),a=null!=(r=l.sequenceNodesBuilder(u.slice(1)))?r:[],c=eD(a,s,!1);return{nodeIndex:c,updatingRefIndex:eF(a,c),sequenceNodes:a,offset:s}})({editor:h,lexerTreeBuilder:I});if(!y)return;let{nodeIndex:C,updatingRefIndex:b,sequenceNodes:R,offset:x}=y;if(1===n.current)if(0!==x){if(-1===C&&R.length)return;let n=e[e.length-1],r=R.splice(C+1),d=null!=(i=n.sheetId)?i:u,h={range:n,unitId:null!=(s=n.unitId)?s:O.getUnitId(),sheetName:w(null!=(a=n.unitId)?a:O.getUnitId(),d)},g=d!==u,m=(null==O?void 0:O.getUnitId())!==o,v=eJ([h],c&&(g||m),k,m);R.push({token:v[0],nodeType:l.kxp.REFERENCE}),f(eB([...R,...r]),R.reduce((e,t)=>

3"string"==typeof t?e+t.length:e+t.token.length,0),t)}else{let n=e[e.length-1],r=null!=(d=n.sheetId)?d:u,i={range:n,unitId:null!=(g=n.unitId)?g:O.getUnitId(),sheetName:w(null!=(m=n.unitId)?m:O.getUnitId(),r)},s=r!==u,a=(null==O?void 0:O.getUnitId())!==o,h=eJ([i],c&&(s||a),k,a);R.unshift({token:h[0],nodeType:l.kxp.REFERENCE}),f(eB(R),h[0].length,t)}else if(3===n.current||4===n.current){let n=e.pop();if(!n)return;let r=R[C];if("object"==typeof r&&r.nodeType===l.kxp.REFERENCE){let e=r.token;(null==O?void 0:O.getUnitId())!==o?r.token=(0,l.U9w)(null!=(v=null==O?void 0:O.getUnitId())?v:"",k,n):r.token=k===(null==T?void 0:T.getName())?(0,l.ocP)(n):(0,l.jzl)(T.getName(),n);let i=x+(r.token.length-e.length);f((0,l.Klk)(R),i,t)}}else{let n,i=[...e];if(!r&&-1!==b){let e=i.pop();e&&i.splice(b,0,e)}let s=0,a=R.map(e=>{if("string"==typeof e)return e;if(e.nodeType===l.kxp.REFERENCE){var t,n,r,a;let d=(0,l.YJw)(e.token);if(d.sheetName||(d.sheetName=k),(d.unitId||o)!==(null==O?void 0:O.getUnitId())||c&&(null==(a=M.current.activeSheet)?void 0:a.getName())!==d.sheetName)return e.token;let h=i[s];if(s++,!h)return"";let f=null!=(t=h.sheetId)?t:u,g={range:h,unitId:null!=(n=h.unitId)?n:O.getUnitId(),sheetName:w(null!=(r=h.unitId)?r:O.getUnitId(),f)},m=(null==O?void 0:O.getUnitId())!==o;return eJ([g],c&&(f!==u||m),k,m)[0]}return e.token}),d="";a.forEach((e,t)=>{d+=e,t===C&&(n=d.length)});let h=[];for(let t=s;t<=e.length-1;t++){let n=e[t],r=null!=(p=n.sheetId)?p:u,i={range:n,unitId:null!=(S=n.unitId)?S:O.getUnitId(),sheetName:w(null!=(_=n.unitId)?_:O.getUnitId(),r)},l=(null==O?void 0:O.getUnitId())!==o,s=eJ([i],c&&(r!==u||l),k,l);h.push(s[0])}let g=R[R.length-1],m=g&&"string"!=typeof g&&g.nodeType===l.kxp.REFERENCE,v=`${d}${h.length&&m?",":""}${h.join(",")}`;f(v,!h.length&&n?n:v.length,t)}});(0,C.useEffect)(()=>{if(F&&e){let e=!0,t=0,n=(n,r)=>{if(e){e=!1,t=n.length;return}let i=n.length>t;r&&(t=n.length),U(n.map(e=>e.rangeWithCoord),r,i)},i=new r.VdD;return i.add(F.selectionMoving$.subscribe(e=>{n(e,!1)})),i.add(F.selectionMoveEnd$.subscribe(e=>{n(e,!0)})),()=>{i.dispose()}}},[e,U,F]),(0,C.useEffect)(()=>{if(t&&F&&h){let e=new r.VdD,t=(0,g.h)(h.input$,A.selectionSet$,F.selectionMoveEnd$).pipe((0,s.B)(50)).subscribe(()=>{e.dispose(),F.getSelectionControls().forEach((t,n)=>{e.add(t.selectionScaling$.subscribe(e=>{let t=F.getSelectionDataWithStyle().map(e=>e.rangeWithCoord),r=t[n];e.sheetId=r.sheetId,e.unitId=r.unitId,t[n]=e,U(t,!1)})),e.add(t.selectionMoving$.subscribe(e=>{let t=F.getSelectionDataWithStyle().map(e=>e.rangeWithCoord),r=t[n];e.sheetId=r.sheetId,e.unitId=r.unitId,t[n]=e,U(t,!0)}))})});return()=>{t.unsubscribe(),e.dispose()}}},[h,t,U,F,A.selectionSet$]),null==F||F.getSelectionDataWithStyle(),(0,C.useEffect)(()=>{if(d){let e=R.onCommandExecuted(e=>{if(e.id!==p.NSB.id)return;let t=e.params;if("formula-editor"===t.extra&&t.selections.length){let e=t.selections[t.selections.length-1];if(e){var i;let{range:l,primary:o}=e;((null==o?void 0:o.isMergedMainCell)||(null==o?void 0:o.isMerged))&&r.M_G.contains(o,l)&&(l.startRow=o.startRow,l.endRow=o.startRow,l.startColumn=o.startColumn,l.endColumn=o.startColumn),l.unitId=t.unitId,l.sheetId=t.subUnitId;let s=1===n.current,u=(null!=(i=null==F?void 0:F.getSelectionDataWithStyle())?i:[]).map(e=>e.rangeWithCoord);s?u.push(l):u[u.length-1]=l,U(u,!0)}}});return()=>{e.dispose()}}},[R,h,n,I,d,U,F]),(0,C.useEffect)(()=>{if(!h)return;let e=x.textSelection$.subscribe(e=>{e.unitId===h.getEditorId()&&eV({unitId:o,subUnitId:u,refSelections:a.current,editor:h,refSelectionsService:A,refSelectionsRenderService:F,sheetSkeletonManagerService:$,themeService:E,univerInstanceService:b,currentWorkbook:O})});return()=>e.unsubscribe()},[x.textSelection$,h,a,F,A,$,u,E,o,b])})(eE&&!!(eK&&e0),eE,ez,G,Z,e1,Q,!!eK,ex,e7),d=eE&&!!(eK&&e0),f=()=>{e6(eL.current,!1,!0)},W=(0,_.fJ)(r.wTY),B=(0,_.fJ)(m.Id),J=(0,_.fJ)(v.cSx).getRenderById(G),q=(0,_.fJ)(r.HCr),H=null==J?void 0:J.with(eO),(0,C.useEffect)(()=>{if(d&&H)if(Q){let e=()=>{let e=H.getSelectionControls().length;for(let t=1;t<=e;t++)H.clearLastSelection();return setTimeout(()=>{f()},30)},t=W.onCommandExecuted(t=>{t.id===p._M5.id&&e()}),n=q.getCurrentTypeOfUnit$(r.Zy$.UNIVER_SHEET).subscribe(t=>{e()});return()=>{t.dispose(),n.unsubscribe()}}else{let e=W.beforeCommandExecuted(e=>{if(e.id===p._M5.id){eI(!1),ee(),f();let e=B.getEditor(r.Fmw);null==e||e.focus()}});return()=>{e.dispose()}}},[d,H]),(0,b.jsxs)("div",{className:er,children:[(0,b.jsx)("div",{ref:e_,className:(0,R.$z)("univer-relative univer-box-border univer-flex univer-size-full univer-items-center univer-justify-around univer-gap-2 univer-rounded-none univer-p-0",{"univer-ring-1":!ev,"univer-ring-primary-500":eE&&!ev,"univer-ring-red-500":ek&&!ev}),children:(0,b.jsx)("div",{ref:eN,className:"univer-relative univer-size-full",onMouseUp:()=>{eI(!0),X(),e4()}})}),void 0!==K&&(0,b.jsx)("div",{className:"univer-my-1 univer-text-xs univer-text-red-500",children:K}),e2&&ex&&""!==ej&&(0,b.jsx)(eP,{editor:ex,isFocus:eE,formulaText:eU,onClose:()=>e4()}),e2&&!!ex&&(0,b.jsx)(eq,{isFocus:eE,sequenceNodes:eH,onSelect:e=>{if(e){let t=null==ex?void 0:ex.getSelectionRanges();if(t&&1===t.length){let n=t[0];if(n.collapsed){let t=e.offset;setTimeout(()=>{null==ex||ex.setSelectionRanges([{startOffset:n.startOffset-t,endOffset:n.endOffset-t}])},30)}}e4(),e6(`=${e.text}`)}},ref:eb,editor:ex})]})}),eK=e=>!e.some(e=>{if("string"==typeof e){if(e!==l.RD4.COMMA)return!0}else if(e.nodeType!==l.kxp.REFERENCE)return!0;return!1});function ez(e){let{visible:t,initialValue:n,unitId:i,subUnitId:o,maxRangeCount:s=1/0,supportAcrossSheet:u,keepSheetReference:a,onConfirm:c,onClose:d,onShowBySelection:h}=e,f=(0,_.fJ)(r.iH9),g=(0,_.fJ)(l.GMK),[m,v]=(0,C.useState)([]),[S,y]=(0,C.useState)(0),x=(0,C.useRef)(null);return(0,C.useEffect)(()=>

3{if(t&&n.length){let e=n.map(e=>e.sheetName?(0,l.jzl)(e.sheetName,e.range):(0,l.ocP)(e.range));v(e),y(e.length-1)}else v([""]),y(0)},[t]),!function(e){let t=(0,_.fJ)(p.Fal),{supportAcrossSheet:n=!1,keepSheetReference:i=!1,unitId:l,subUnitId:o,onChange:s}=e,u=(0,_.fJ)(r.HCr).getUnit(l,r.Zy$.UNIVER_SHEET),a=(0,_._q)(s),c=(0,_._q)((e,t)=>{let r=null==u?void 0:u.getActiveSheet();if(!r||!n&&r.getSheetId()!==o||!(null==e?void 0:e.length))return;let s=i?r.getName():r.getSheetId()===o?"":r.getName();a(e.map(e=>({range:e.range,unitId:l,sheetName:s})),t)});(0,C.useEffect)(()=>{let e=new r.VdD;return e.add(t.selectionMoveStart$.subscribe(e=>{c(e,!0)})),e.add(t.selectionMoving$.subscribe(e=>{c(e,!1)})),e.add(t.selectionMoveEnd$.subscribe(e=>{c(e,!1)})),()=>{e.dispose()}},[c,t.selectionMoveEnd$,t.selectionMoveStart$,t.selectionMoving$])}({unitId:i,subUnitId:o,supportAcrossSheet:u,keepSheetReference:a,onChange:(e,n)=>{if(!t&&(null==h?void 0:h(e)))return;let r=new Set(m),i=e.map(e=>e.sheetName?(0,l.jzl)(e.sheetName,e.range):(0,l.ocP)(e.range)),o=i.filter(e=>!r.has(e));if(!o.length)return;let u=[...m];if(i.length>1){n||u.splice(S,1),u.push(...o);let e=u.slice(0,s);v(e),y(e.length-1),requestAnimationFrame(()=>{var e;null==(e=x.current)||e.scrollTo({top:x.current.scrollHeight})})}else u.splice(S,1,...o),v(u.slice(0,s)),y(S+o.length-1)}}),(0,b.jsx)(R.lG,{width:"328px",open:t,title:f.t("sheets-formula-ui.rangeSelector.title"),draggable:!0,mask:!1,maskClosable:!1,footer:(0,b.jsxs)("footer",{className:"univer-flex univer-gap-2",children:[(0,b.jsx)(R.$n,{onClick:d,children:f.t("sheets-formula-ui.rangeSelector.cancel")}),(0,b.jsx)(R.$n,{variant:"primary",onClick:()=>{c(m.filter(e=>{let t=g.sequenceNodesBuilder(e);return t&&1===t.length&&"string"!=typeof t[0]&&t[0].nodeType===l.kxp.REFERENCE}).map(e=>(0,l.YJw)(e)).map(e=>({...e,range:(e=>{if(e.endColumn<e.startColumn){let t=e.endColumn;e.endColumn=e.startColumn,e.startColumn=t}if(e.endRow<e.startRow){let t=e.endRow;e.endRow=e.startRow,e.startRow=t}return e})(e.range)})))},children:f.t("sheets-formula-ui.rangeSelector.confirm")})]}),onClose:d,children:(0,b.jsxs)("div",{ref:x,className:(0,R.$z)("-univer-mx-6 univer-max-h-60 univer-overflow-y-auto univer-px-6",R.oN),children:[m.map((e,t)=>(0,b.jsxs)("div",{className:"univer-mb-2 univer-flex univer-items-center univer-gap-4",children:[(0,b.jsx)(R.pd,{className:(0,R.$z)("univer-w-full",{"univer-border-primary-600":S===t}),placeholder:f.t("sheets-formula-ui.rangeSelector.placeHolder"),onFocus:()=>y(t),value:e,onChange:e=>{let n;(n=[...m])[t]=e,v(n)}}),m.length>1&&(0,b.jsx)(N.d,{className:"univer-cursor-pointer",onClick:()=>{m.splice(t,1),v([...m])}})]},t)),m.length<s&&(0,b.jsx)("div",{children:(0,b.jsxs)(R.$n,{variant:"link",onClick:()=>{v([...m,""]),y(m.length)},children:[(0,b.jsx)(w.s,{}),(0,b.jsx)("span",{children:f.t("sheets-formula-ui.rangeSelector.addAnotherRange")})]})})]})})}function eG(e){let[t,n]=(0,C.useState)(null),{onVerify:o,selectorRef:s,unitId:u,subUnitId:a,maxRangeCount:c,supportAcrossSheet:d,keepSheetReference:h,autoFocus:f,onChange:g,onRangeSelectorDialogVisibleChange:v,onClickOutside:S,onFocusChange:y,forceShowDialogWhenSelectionChanged:x,hideEditor:E,resetRange:I}=e,[N,w]=(0,C.useState)(null!=f&&f),[T,M]=(0,C.useState)(!1),[O,D]=(0,C.useState)([]),F=(0,_.fJ)(r.iH9),$=(0,_.fJ)(m.Id),{sequenceNodes:A}=function(e,t,n){var o;let s=(0,_.fJ)(l.GMK),u=eW(""),a=(0,_.J2)(null==e||null==(o=e.getDocumentDataModel())?void 0:o.change$),[c,d]=(0,C.useState)([]),h=(0,_.fJ)(i.oHG),f=(0,C.useRef)(""),g=(0,_.fJ)(r.HCr);return(0,C.useEffect)(()=>{if(!e)return;let t=e.getDocumentDataModel().getPlainText();if(f.current===t)return;f.current=t;let n=s.sequenceNodesBuilder(t);d(null!=n?n:[])},[a,e,s]),(0,C.useEffect)(()=>{if(!e)return;if(!t){var i,o;let t=e.getDocumentData();e.setDocumentData({...t,body:{...t.body,dataStream:null!=(i=null==(o=t.body)?void 0:o.dataStream)?i:"",textRuns:[]}});return}let s=u(e,c,!1),a=new r.VdD;return s.forEach(e=>{let t=(0,l.YJw)(e.token),i=g.getCurrentUnitOfType(r.Zy$.UNIVER_SHEET),o=null==i?void 0:i.getActiveSheet();if(!t.sheetName&&n!==(null==o?void 0:o.getSheetId())||t.sheetName&&(null==o?void 0:o.getName())!==t.sheetName)return;let s=new r.mKL(e.themeColor).toRgb(),u=h.addShape({range:t.range,style:{stroke:e.themeColor,fill:`rgba(${s.r}, ${s.g}, ${s.b}, 0.1)`,strokeDash:12},primary:null});u&&a.add(()=>h.removeShape(u))}),()=>{a.dispose()}},[e,t,u,h,c]),{sequenceNodes:c}}(t,N,a),U=eA(A),L=(0,_.fJ)(r.wTY),j=(0,_._q)(()=>{null==t||t.setSelectionRanges([]),null==t||t.blur(),$.blur()}),P=(0,_._q)(()=>{var e,n;j(),D((null!=(e=null==t||null==(n=t.getDocumentDataModel())?void 0:n.getPlainText())?e:"").split(l.RD4.COMMA).filter(e=>!!e).map(e=>(0,l.YJw)(e))),M(!0)});return(0,C.useEffect)(()=>{s&&(s.current={get editor(){return t},focus(){$.focus(t.getEditorId())},blur:j,verify:()=>eK(U.current),showDialog:e=>{j(),D(e),M(!0)},hideDialog:()=>{D([]),M(!1)},getValue:()=>{var e,n;return null!=(e=null==t||null==(n=t.getDocumentDataModel())?void 0:n.getPlainText())?e:""}})},[j,t,$,s,U]),(0,C.useEffect)(()=>{var e,n;null==o||o(eK(A),null!=(e=null==t||null==(n=t.getDocumentDataModel())?void 0:n.getPlainText())?e:"")},[A]),(0,C.useEffect)(()=>{null==v||v(T)},[T]),(0,C.useEffect)(()=>

3{if(T&&I)return()=>{L.executeCommand(p.NSB.id,{unitId:u,subUnitId:a,selections:I})}},[T]),(0,b.jsxs)(b.Fragment,{children:[E?null:(0,b.jsx)(m.dS,{isSingle:!0,...e,onFocusChange:(e,t)=>{w(e),null==y||y(e,t)},editorRef:n,onClickOutside:()=>{w(!1),j(),null==S||S()},icon:(0,b.jsx)(R.m_,{title:F.t("sheets-formula-ui.rangeSelector.buttonTooltip"),placement:"bottom",children:(0,b.jsx)(k.h,{className:"univer-cursor-pointer dark:!univer-text-gray-300",onClick:P})})}),(0,b.jsx)(ez,{initialValue:O,unitId:u,subUnitId:a,visible:T,maxRangeCount:c,onConfirm:e=>{let n=e.map(e=>e.sheetName?(0,l.jzl)(e.sheetName,e.range):(0,l.ocP)(e.range)).join(l.RD4.COMMA),i=r.X_1.newEmptyData();i.body.dataStream=n,null==t||t.replaceText(n,!1),null==g||g(i,n),M(!1),D([]),requestAnimationFrame(()=>{j()})},onClose:()=>{M(!1),D([])},supportAcrossSheet:d,keepSheetReference:h,onShowBySelection:e=>!N&&!x||(D(e),M(!0),!1)})]})}let eZ=()=>{var e,t;let n=(0,_.J2)((0,_.fJ)(eM).currentSelector$),r=(0,C.useRef)(null);return(0,C.useEffect)(()=>{if(n){var e,t;return null==(e=r.current)||e.showDialog(null!=(t=n.initialValue)?t:[]),()=>{var e;null==(e=r.current)||e.hideDialog()}}},[n]),(0,b.jsx)(eG,{unitId:null!=(e=null==n?void 0:n.unitId)?e:"",subUnitId:null!=(t=null==n?void 0:n.subUnitId)?t:"",hideEditor:!0,selectorRef:r,onChange:(e,t)=>

3{var r;null==n||n.callback(null!=(r=null==t?void 0:t.split(",").map(e=>(0,l.YJw)(e)))?r:[])}})},eY=class extends r.k_1{constructor(e=Q,t,n,i,l){super(),this._config=e,this._injector=t,this._renderManagerService=n,this._configService=i,this._uiPartsService=l;const{menu:o,...s}=(0,r.h1I)(Q,this._config);o&&this._configService.setConfig("menu",o,{merge:!0}),this._configService.setConfig(Y,s,{merge:!0})}onStarting(){(0,r.tMf)(this._injector,[[A,{useClass:U}],[eM],[ek],[en],[ei],[eo],[Z],[eT]]),this._initUIPart()}onReady(){[[eO]].forEach(e=>{this.disposeWithMe(this._renderManagerService.registerRenderModule(r.Zy$.UNIVER_SHEET,e))})}onRendered(){[[et]].forEach(e=>{this.disposeWithMe(this._renderManagerService.registerRenderModule(r.Zy$.UNIVER_SHEET,e))}),(0,r.HLP)(this._injector,[[ek],[en],[eo],[eT]])}onSteady(){this._injector.get(Z)}_initUIPart(){let e=this._injector.get(_.BJ);this.disposeWithMe(e.register(i.Eib,eG)),this.disposeWithMe(e.register(i.xUC,eH)),this.disposeWithMe(this._uiPartsService.registerComponent(_.ns.GLOBAL,()=>(0,_.pK)(eZ,this._injector)))}};D(eY,"pluginName",B),D(eY,"packageName","@univerjs/sheets-formula-ui"),D(eY,"version","0.25.0"),D(eY,"type",r.Zy$.UNIVER_SHEET),eY=$([(0,r.dCC)(S.Jr),F(1,(0,r.y_5)(r.zZn)),F(2,v.cSx),F(3,r.J0C),F(4,_.fe)],eY)}}]);