Table 73000 XML Document 15/02/09 12:00:00 7500 xlt Table 73001 XLT Style 16/02/09 12:00:00 7852 xlt Table 73002 XLT Field Total 09/02/09 12:00:00 4476 xlt Form 73000 XLT Style Card 17/02/09 12:00:00 29312 xlt Form 73001 XML Document 08/02/09 12:00:00 8956 xlt Form 73002 XLT Style List 15/02/09 12:00:00 14732 xlt Form 73003 XLT Excel Style Card 16/02/09 12:00:00 74632 xlt Form 73004 XLT Excel Style List 08/02/09 12:00:00 7040 xlt Form 73005 XLT Layout Card 16/02/09 12:00:00 88240 xlt Form 73006 XLT Layout List 16/02/09 12:00:00 8136 xlt Form 73007 XLT Layout Xizard 16/02/09 12:00:00 23388 xlt Form 73008 XLT Total Fields 09/02/09 12:00:00 4572 xlt Codeunit 73000 XML Document Mgt 16/02/09 12:00:00 77668 xlt Codeunit 73001 XLT Style Sheet Data Mgt 16/02/09 12:00:00 12244 xlt Dp KsA  {B d%/ +~aAbBcCdDeEfFgGhHiIjJkKlLmMnNoOpPqQrRsStTuUvVwWxXyYzZ҉ӊԋ،׍ޑ┙֢餥ڿ + '- !"#$%&()*,./:;?@[\]^_`{|}~ɲ˳+<=>񮯞Ͼ̴0123456789aAdžbBcCdDeEԈ҉fFgGhHiI֍ތ׋jJkKlLmMnNoO┙囝pPqQrRsSڿtTuUꁚvVwWxXyYzZ   !"#$%&'()*+,-./0456789:;<=>?@BӟGHJKLMNPQRTVWX[\]_`BӟGHJKLMNPQRTVWX{|}~ӏ؏Ӓ؝ŏٿߝ᝝蚚 +&!+%" ƹƹ\(XML Document d . xltLX)XLT Style d . xlt# \*XLT Field Total d . xlt| \(XLT Style Card d . xltrNrt \)XML Document d . xlt"{X# \*XLT Style List d . xlt9!9 d+XLT Excel Style Card d . xlt## d,XLT Excel Style List d . xltS \-XLT Layout Card d . xltXf YT \.XLT Layout List d . xltD$  `/XLT Layout Xizard d . xlt\[[ `0XLT Total Fields d . xltN<D `(XML Document Mgt d . xltd//@ h)XLT Style Sheet Data Mgt d . xlt/l<0\(XML Document d . xltLpL( d<  ddd`00 40-0-h0-H0 Version@  Line No. Node Typed(h  NodeAttribute Text456 Declaration Comment Node Name@P Node Value@ Name Space@ Parent NodedA A A dp ddddddfff<(ef f(f((f,f,f(f  Rec4f  xRec  CurrFieldNo  GetStyleNodes3f  GetConditioinNodes3f  GetAttributeValue3f  DeleteSubNodes3f <df d(f `fffff-f-f ffff RESET DELETEALL SETCURRENTKEY Version Parent Node SETRANGE FINDLAST Line No. Node Name FINDSET Node Value NEXT Node Type INSERT FINDFIRST DeleteSubNodes DELETE $ xeGex f(-f(f(f(  VersionCode  TmpXMLDocument5f:f  AttributeName  XMLTable  XMLTable2  XMLTable3  FoundNodeIeJeEee eee eeeee ee e ee ee eee ee eeee ee/eeee ee e ee ee eee ee eee ee e-xsl:templateeee e eeHe ee e ee ee eee ee eeee e ee`ee e3e?eee e e7ee-eeee e e7ee-ee$e eee ee e ee ee eee ee eee ee e eee e eepee eee eeeee e e7eee{eP$ 0,,,0,,<X,,( 880,,0((peeWeete;eWeete;ete := FALSE;eeWeeTeeVeete );eWeeTeeVeete);eWeeTeete,0);IF NOT eeWeete THENEXIT;eeWeeTeeVeete );eWeeTeeVeete);eWeeTeeVeeWeete);eWeeTee VePexsl:templatete );IF eWee te THEN BEGINe eWeeTeeVeete );eWeeTeeVeete);REPEAT eWeeTeeVeeWeete );IF eWee te THENREPEATete := (eWee te = ete);UNTIL (eWee te = 0) OR ete;UNTIL (jeWee te = 0) OR ete ;END;eXe Get Styles sub-nodeseeWeete;eWeeTeeVeete );eWeeTeeVeete);eWeeTeeVeeWeete);eWeeTee VeeWee ReQe te );IF eWee te THENREPEATete := ete ;IF eWeete THEN;UNTIL jeWee te = 0;eGe, 4f(P  VersionCode  TmpXMLDocument5f:fIeEe e{epeeGeT-Df(L-Tf(\  XMLTable  Attribute  XMLTable2HeIeJeEeTe ee e ee ee eee ee eee ee e ee ee eeee eee$ee ?ee(ee -ode?eee{e,,0,(peeWeeTeeVeete);eWeeTeeVeeWeete);eWeeTeeVeeWeete);eWeeTee VeeWee ReQe te);eWeeTee Veete );IF eWeete THENEXIT(eWee te);eteEXIT('');eGe@ LPf(T  DeleteVersion  lineNo  XMLRecIeJeEe(e ee e ee ee eee ee eeee e eete eeeee eeee e e7eee{e8,,((,peeWeeTeeVeete);eWeeTeeVeete);eWeeTeeVeete );IF eWee te THENREPEATeTeeWeeVeeWeete ); eWeete;UNTIL eWee te = 0;eeeeeeeeeeeeeeeeeEe4e eeeee{eoeOnDeleteeTeeVeete);e  Version Line No. Node Type Node Name Node Value Name Space Parent NodeX)XLT Style d . xlt9Q dT $ddd`aGR*HR*h 00- (0-,(0(()0-024030,<0,F0-x4-t=-4T Code@ < Description@ New XSLT-File Location@ Base Style Sheet Base Style Sheet Origin@ Destinationd(hAll style sheets'Style sheets common to all forms Style sheets for this form only Destination Form No.bc Default Table IDbc Total Style@b c  Destination Form Name36<5w3@!< Default Table Name36<5w<@!<,A dp ddddddfff<( ef   f)f)<ff(f5wg(@f$f,f f f f  Rec4f  xRec  CurrFieldNo  Text001;f Rename is not allowed.  XMLRec  Object  XMLMgt  Text002;f$ Style %1 does not exist.  LookupStyle3f  CheckLookupStyle3f SYSTEM ACTION DIALOG  df d)fd(fd5wfd(g d,f dfdf df Pff CLEAR UPPERCASE -Ff -4f 3-=<ff Code Total Style CALCFIELDS Destination Form Name VALIDATE Destination Form No. Default Table Name Default Table ID CheckLookupStyle LookupStyle,fffffff SETRANGE Version FINDFIRST GetAttributeValue GetStyleNodes FINDSET NEXT DELETEALLff  RESET SETRANGE Type ID4f LookupObjectfffff SETRECORD SetVersion LOOKUPMODE RUNMODAL GETRECORD,f  ,f ERROR |\hh  \ eGe@tf(xf,  ForFieldd(( TotalCaption Label  XMLRec  ExcelStyleListIeJeEee eee ee eee eee eeee eeee eeeefe eee fe<3ee(e eeeee8eeTee-e eee-ss:IDie?ee =e>ee{e$, 8 dpeeTeete);eWeeTeeVeete);eWeete;eeWeeTeete);eWeeTeete);eWeete(TRUE);IF eWeete = e ReQe e<te THENeWeeTeete);ee^ereete OFeReQe te:ete := eWeeTeeVePe ss:IDite );END;eGeh-X-\f(`f(p-x  Style  XMLRec  TmpXMLTable:f  StyleNameHeIeJeEee ee eee eee eeee-output-Styleslueee eeeee-e eee-ss:IDTae?ee-e eee-e ee3ee$ee?eeTee ee7ee0e eeee{e 4@(DL,pe eWeeTeeVeete);eWeete;eWeeTeeWeeVeeVePeoutput-Styleslute );IF eWeete THENREPEATete := eWeeTeeVePe ss:IDTate );IF eTeete ) = eTeete) THENEXIT(Iete);UNTIL jeWeete = 0;eTeeVeete);eEePe ee eee eee{e 4oeOnDeleteeWeeTeeVeete);eWeete;ueEe$e eee{eoeOnRenameeTeete);eEe0e ee ee{eoeOnValidateeTeete);eEee eee ee e ee eeee ee eee{e 0 (oeOnLookupeeWeete;eWeeTeeVeeWeeReQe te);eWeeTeete);eTeeVeeWeete);eEe0e ee ee{eoeOnValidateeTeete);eEee eee ee e ee eeee ee eee{e 0 (oeOnLookupeeWeete;eWeeTeeVeeWeeReQe te);eWeeTeete);eTeeVeeWeete);eEe`ee -ota2ee<ee-e e ee?ee{e (0oeOnValidateteIF ete <> '' THENaaete := xe Teete);eEe,e e eee{eoeOnLookupee te (0);e  ( )2 3 4<=F Code Description New XSLT-File Location Base Style Sheet Base Style Sheet Origin Destination Destination Form No. Destination Form Name Default Table ID Default Table Name Total Style \*XLT Field Total d . xlt|k|X d4 ddd0000 8<l - l -@` Table IDc Form ID Field IDc Style Sheet ID Type5d(  Total Table Name36<5w@!< Field Name36<)5w@!<<(A dp ddddddfff<(ef  f*f*f5wf)5wfff f f  Rec4f  xRec  CurrFieldNo  Object  Fld  ObjectList  FldList SYSTEM ACTION df d*fd5wfd)5wfdff df dfdf ,f CLEARf- f-  Table ID CALCFIELDS Table Name Field ID GETFILTER Field Named f  GET Type ID ff  GET SETFILTER TableNo No.ffff SETRECORD LOOKUPMODE RUNMODAL GETRECORDfffff SETTABLEVIEW SETRECORD LOOKUPMODE RUNMODAL GETRECORDLff   8eEe8ee ee e -eeeeeee eeee eeeefe eee fe<3ee`e eeeee?ee ee ee{eP X$oeOnLookupeteIF eWeeTeeWeeReQe te ,'',ete) THEN;eeTeete);eWeeTeete);eWeete(TRUE);IF eWeete = eReQe e<te THEN BEGINeWeeTeete );ete := eWeete;eTeete );END;eEeee eeeeee-e ee ee -abl2eeXe ee e-e ee eeeeee eeee eeee eeeefe eee fe<3ee`e eeeee?ee ee ee{e @DP X$oeOnLookupeteIF eWeeTeeVeete) THEN;IF eTeete) <> '' THENqeWeeTeeVeeTeete ));eeeTeete);eWeeTeete);eWeeTeete);eWeete(TRUE);IF eWeete = eReQe e<te THEN BEGINeWeeTeete );ete := eWeete;eTeete );END;e   Table ID Form ID Field ID Style Sheet ID Type Table Name Field Name \(XLT Style Card d . xltr5r\r d hdd7!l48!!|$R$ d %R)1RM /FOR@| t4t4|4t4tt4t4444t4D 5!6!7!28!9!:!!< 4General DestinationStandard Styles 5! 6!7! 8!B!D!=R4 eEeeDee{eee 5!6!7! 8!B! 5! 6!r7!|8!B!D!=R4 e-EeeDee{eee 5!6!r7! 8!B! 5! 6! 7!8!=!B!D!=R4 eEeeDee{eee 5!6! 7! 8!B! 5! 6!, 7!|8!B!D!=R4 e-EeeDee{eee  5!6!, 7! 8!B! '5!X6! 7!.8!B!D!=R4 e-EeeDee{eee  5! 6!7!8!B!D!=R4 eEeeDee{eee  5!6!7! 8!B!   5! 6!7!|8!B!D!=R4 e-EeeDee{eee  5!6!7! 8!B!   FormNo5! 6!x7!8!B!D!=R4 eEee Dee{ee e 5!6!x7! 8!B!  FormName5! 6!7!|8!B!D!=R4 e-Eee Dee{ee e 5!6!7! 8!B! *5! 6! 7!|8!B!D!<=R4 eEeeDee{eeeR +5! 6! 7!|8!B!D!<=R4 eEeeDee{eeeR ,5! 6!7!|8!B!D!<=R4 eEeeDee{eeeR -5!6!7! 8!B!, 5! 6!7!|8!B!D!=R4 e-Eee Dee{ee e 5!6!7! 8!B! 5!*6!X7!8!&9!:!g!T 5!!6!X7!8!&9!:!!  St&yle!Ly$Rt\d\ 0\ @< <8( g!"Yp!?!  &List (g!#Y! DocumentBR)DRER o! !  Import r!! Import from DatabaseR  r!! Import from FileR !o! "!  Export #r!! Export to DatabaseR $r!! Export to FileR  %o! &!  ResetR  5!~6!X7!8!&9!:!! D&esign!T$R$ d 08t ! Excel StylesR  )! Conditional FormattingR  .o! /g!#Y! Total FieldsBR0DR,<3ER dp ddddddfff( !"$%&()*-./01245689:=>?@ABDEFHIJMNOPQRTUVXYZ]^_`abdefhijmnopqstuwxy|}~ef efefefefefefefefefef ef!!ef""ef$$ef%%ef&&ef((ef))ef*+ef--ef..ef//ef00ef11ef22ef44ef55ef66ef88ef99ef:;ef==ef>>ef??ef@@efAAefBBefDDefEEefFFefHHefIIefJKefMMefNNefOOefPPefQQefRRefTTefUUefVVefXXefYYefZ[ef]]ef^^ef__ef``efaaefbbefddefeeefffefhhefiiefjkefmmefnnefooefppefqqefssefttefuuefwwefxxefyzef||ef}}ef~~efefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefl"$ff)f)f(fB5wg( f+8fdf8fPfHfLffHf f-Tf<f8f(f--- f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f ff f f f ff f f f ff f f f f- f f f- f f f- f f f f f f f f f f ff f  f  f  f ff f fff ff f fff f f f f  CurrForm5f  xRec  Rec4f  XMLTable  StyleSheet  XMLMgt  ExcelStyleForm  Text001;f Update cancelled.  Text002;fH BStyle sheet %1 already exists. Do you want to overwrite this?  Text003;f Update cancelled.  Text004;f4 .Style sheet was uploaded to the database.  Text005;f, &Please specify a valid file in %1  Text006;f0 +File was succesfully exported to %1.  Text007;fh cWarning! This will undo any changes you have made since you imported the base style sheet.\\  Text008;f, %Are you sure you want to continue?  ExcelLayoutForm  Text009;f8 2Overwrite existing stylesheet and formatting?  Text010;f Replace existing file?  Text011;f Export cancelled. ([A UpdateEnabled3f Which5f Steps5f BelowxRec5f BelowxRec5f URL5f URL5f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f4f 4f4f4f4f4f 4f4f4f4f4f 4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f4f4f4f4f4f 4f DIALOG FORM ACTION SYSTEM FILE 4f4f4f 4f 4f4f 4f4f4f 4f 4f4f4f4f4f df df d)fd(fdB5wfd(g d+f d-f dfddf df dfdf df dg dffffff TEMPORARYPATH FORMAT CREATEGUID TODAY CLEARpfff FormNo FormName CAPTIONl2-( - -)<-= 3 -4-Fffff Destination Code Description Base Style Sheet New XSLT-File Location Base Style Sheet Origin Default Table ID Default Table Name Destination Form No. Destination Form Name Total Style CALCFIELDS MODIFY TESTFIELD FIELDCAPTIONfff RESET SETRANGE Version DELETEALLfff-fff.f RESET SETRANGE Program ID CALCFIELDS Style Sheet Name FINDFIRST DELETE INIT Style Sheet ID Object Type Object ID Date INSERTLff Import ExportLf f SetVersion RUNLf f SetVersion RUN,f ENABLEDpfff HASVALUE EXPORT IMPORTlfff CONFIRM ERROR MESSAGE0f RUNMODAL,f  Lff ERASE EXISTS0f OpenFileLff CREATE CLOSE  <PPPPx #$&()eEele eee 3eee eee 3eee{e 8peeWeeWeete := ete = eReQe te;eWeeWeete := ete = eReQe te;ueEeeee{eoeOnAfterGetRecordeete;eFexEeeee{eoeOnValidateete;eFe}Eeeee{eoeOnValidateete;eFeEeeee{eoeOnValidateete;eGe@-   TmpFileNameFeJeEee e e eee e eeLeeee/ee eeee eee ee eEFeefee eee fe<3eele ee eee eee?ee e ee eee ee eee eeee-eee-eeeee'e?ee e e ee e eee eeeeeeee{e4|(,<h,X$ (oe OnPushie Teete );IF eWee te THENIF NOT de Teete) THEN e Teete);eeWeete;eWeeTeeVePe,{00024500-0000-0000-C000-000000000046}te );IF eWeeTeeReQe Veete ) = eReQe e<te THEN BEGINeWeeTeete );ete := eWeete;ete := eWeete;e te ;END;eeWeete;eWeeTeeVeete);eWeete;eete := ete + eTeete);e Teete);eWeeWee Teete);eWeeTeeVeete);eTeete);eGe@gH-P-X  CommonDlg  FileName  TmpFileNameFeJeEe4e e e eee e eeLeeee/ee ee ee eee ee eee eeee-e ee-e eeee e4-,,Stylesheets (*.xslt)|*.xsl*|(All files)|*.*ee?eeeeeeXe e eeeee?ee e ee eeeee{e((,,Loe OnPushie Teete );IF eWee te THENIF NOT de Teete) THEN e Tee te);eWeete;eWeeTeeVeete);eWeete;eete := eWeeTeeWeeVeete,4,Pe0Stylesheets (*.xslt)|*.xsl*|(All files)|*.*te ,0);eteIF eTeete) THEN BEGINqeWee Teete,FALSE);qete := ete;e te ;END;eeWeeTeeVeete);eGe@-   TmpFileNameFeJeEe(e ee ee eee ee eEFee ee eeee eeepeeeeee/ee ee ee eeee-eee -\MP'ee-eeeee'ee-.xmlEGU'e?ee eeeee e ee eee?ee eee 3eee e ?eeeEF?eee?ee e eeee e.ee?ee eeeeeee ee{e<|<,`|($ $$$oe OnPushieTeete);eWeete;eWeeTeeVePe,{00024500-0000-0000-C000-000000000046}|te);eWeeTeeVeete );IF eWeete THEN BEGINIF NOT e Teete ,FALSE,ete) THEN e Tee te );eWeete ;END;eete := ete + '\' + eTeete ) + hPe .xmlEGUte;eWeeTeeVeete);eeWee te;eWee te := ete;eWee te := eWee ReQe  te ;IF ete = eReQe te THENeWee te := e te;eWeete := Pe,{00024500-0000-0000-C000-000000000046}|te;eWeete := ete;eWeeWee Teete,FALSE);eWee te := ete;eWeete;eeTeete);ee Tee te);eGe@f   TestFileFeJeEee ee eeeeeeLeeee/ee eeeee eeee@e eeeeeeLee e-e ee eee eeeeee eee{e$|(,HL(oe OnPushieTeete );IF eTeete) THENIF NOT e Teete) THEN e Teete);eXe0 test if file location is a valid file nameeteIF eWeeTeete) THEN BEGINqeWeete;eTeete)END ELSEe Tee VeeTeete ));eeeWeeTeeVeete);ee Tee Veete);eGe@-   TmpFileNameFeJeEeeee e'ee/ee ee ee eee ee eee eeee-eee-eeeee'e?ee e e ee e eee eeeeeeee{e$,X$ (oe OnPushite IF NOT e te(e te +ete)THENe Tee te);eeWeete;eWeeTeeVeete);eWeete;eete := ete + eTeete);e Teete);eWee Teete);eWeeTeeVeete);eTeete);eFeEe\eeee eeee eee{e ( oe OnPushieTeete);eWeeTeete);eWeete;ueFeEe\eeee eeee eee{e ( oe OnPushieTeete);eWeeTeete);eWeete;ue-  '    *+,-( !"#$%&)./ Form  Code  Description  Base Style Sheet  New XSLT-File Location  Base Style Sheet Origin Default Table ID  Default Table Name  FormNo  FormName  Destination Destination Destination  Total Style                    t \)XML Document d . xlt""" d ddV7!n78!f+!\[7<$R$ d %R(*R1R\4M6RR D t<<t<TTD4 4 5!6! 7!H58!9!:!! 5!6!7!&8!B!E!=R4 eEeeDee{eee 5!6!7!8!B!F! 5!,6!7!8!9!B!E!=R4 e-Eee Dee{ee eR 5!6!7!8!B!F! 5!6!7!08!B!E!=R4 e-EeeDee{eee 5!6!7!8!B!F! 5!6!d(7!8!&9!:!@!g!e<h!  5!$6!d(7!8!&9!:!A!g!f<h!  5!-6!d(7!8!&9!:!g!T  5!6!n7!58!*9!  5! 6!p7!8!B! D!K!! Show Attributes=R4 eEeeDee{eeeR  5!6!p7! 8!B!  dp ddddddfff=(    !"#$%'()+,-012345789;<=@ABCDEFGHIJKLMNOPQef efef ef  ef ef efefefefefefefefefefefefefef ef!!ef""ef##ef$$ef%%ef''ef((ef))ef++ef,,ef-.ef00ef11ef22ef33ef44ef55ef77ef88ef99ef;;ef<<ef=>ef@@efAAefBBefCCefDDefEEefFFefGGefHHefIIefJJefKKefLLefMMefNNefOOefPPefQQD R$ff(f(f(- --- f f- f f f- f f f- f f f f f f -f f f- f f f- f f f f f f- f f f- f f f- f f f f f f f f f f f f f f f ff f f  CurrForm5f  xRec  Rec4f  XmlDoc  NodeValue  ShowAttributes  Indentation Which5f Steps5f BelowxRec5f BelowxRec5f URL5f URL5f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f  Text5f 4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f4f4f4f4f4f4f4f4f4f4f 4f4f4f ldf df d(fdf 0f Node Namel f fff-- SETRANGE Node Type GET Version Line No. Parent Node SETCURRENTKEY FINDFIRST Node Value Node Name4f UPDATEINDENTd l eEeeeLe ee e e ee8e ee e ee{e<8oeOnOpenFormteIF ete THENeTeeVeeReQe VeeReQe te)ELSEeTeeVeeReQe te);eEeeee eeeeee eeeee4eee !e?eee ee e ee ee eee ee eee ee e eee eee$ee ?ee ee -ode?ee{e (8,0,,0( oeOnAfterGetRecordeete := 0;eWeeTeeVeete);WHILE eWeeTeeWeeVeeWeete ) DOqete := ete + 1;eeWeeTeeVeete);eWeeTeeVeete);eWeeTeeVeete);eWeeTeeVeeWeeReQe te );IF eWeete THENete := eWee eaeeteete := '';eFeEe<e eee d#eee{eoeOnFormatateeWeeWeeTeete * 100);eFe:EeeeLe ee e e ee8e ee e ee{e <8oeOnValidateteIF ete THENeTeeVeeReQe VeeReQe te)ELSEeTeeVeeReQe te);e      Form  Node Type  Node Name  NodeValue      ShowAttributes  \*XLT Style List d . xlt9B9h9 d pdd7!t@8!6=!!7<$R$ d %R)1R6(E < t<|<t<t<t<t<t<t<t<t<t<TTD 5!6!7!>8!|9!:! 5!6!7!8!B!E!=R4 eEeeDee{eee 5!6!7!8!B!F! 5!6!7!08!9!B!E!=R4 e-EeeDee{eee 5!6!7!8!B!F! 5!6!7!08!B!E!=R4 e-EeeDee{eee 5!6!7!8!B!F! 5!6!7!8!B!E!=R4 eEeeDee{eee  5!6!7!8!B!F!  5!6!7!08!B!E!=R4 e-EeeDee{eee  5!6!7!8!B! F!  5!6!7!&8!B!E!=R4 eEeeDee{eee  5!6!7!8!B! F! 5!6!7!8!B!E!=R4 eEeeDee{eee 5!6!7!8!B!F! 5!6!7!08!B!E!=R4 e-EeeDee{eee 5!6!7!8!B!F! 5!6!7!8!B!E!=R4 eEee Dee{ee e 5!6!7!8!B!F! 5!6!7!08!B!E!=R4 e-Eee Dee{ee e 5!6!7!8!B!F! 5!6!7!08!B!E!=R4 e-Eee Dee{ee e 5!6!7!8!B!F! 5!$6!47!8!&9!:!@!g!e<h! 5!-6!47!8!&9!:!A!g!f<h! 5!76!47!8!&9!:!g!T dp ddddddfffL(     !#$%'(),-./01345789<=>?@ACDEGHILMNOPQSTUWXY\]^_`acdeghilmnopqstuwxy|}~ef efefefefef  ef  ef  ef efefefefefefefefefefefefefefef ef!!ef##ef$$ef%%ef''ef((ef)*ef,,ef--ef..ef//ef00ef11ef33ef44ef55ef77ef88ef9:ef<<ef==ef>>ef??ef@@efAAefCCefDDefEEefGGefHHefIJefLLefMMefNNefOOefPPefQQefSSefTTefUUefWWefXXefYZef\\ef]]ef^^ef__ef``efaaefccefddefeeefggefhhefijefllefmmefnnefooefppefqqefssefttefuuefwwefxxefyzef||ef}}ef~~efefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefef$ff)f)--- f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f f f f f f f f  CurrForm5f  xRec  Rec4f Which5f Steps5f BelowxRec5f BelowxRec5f URL5f URL5f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f4f4f4f4f4f4f4f ldf df d)fdf   - -( -)2 3 -4<-=-F Code Description New XSLT-File Location Base Style Sheet Base Style Sheet Origin Destination Destination Form No. Destination Form Name Default Table ID Default Table Name Total Style eH       Form  Code  Description  New XSLT-File Location  Base Style Sheet  Base Style Sheet Origin  Destination  Destination Form No.  Destination Form Name  Default Table ID  Default Table Name  Total Style     d+XLT Excel Style Card d . xlt##d## dH $dd7!B,8!F2!$R$ d %R(0R e-EeHe-e eee-ss:IDrieDee{eeTeeVePe ss:IDrite)e1Ryz7'99RRRR R R R $/D4 <\ 444d` 5!`"6!D/7!8!&9!:!g!T 5!Z6!D/7!8!&9!:!! E&xcel Style!f$RX@d@0 p!?!  &ListR  5!6!7!*8!v 9!  StyleID5! 6!7!R 8!B!D!! Style ID</=R4 e-EeeDee{eee 5!6!7! 8!B!D! 5!6!7!@)8!9!:!! Style Properties 5!86!+7! 8!B!C!!  Value=RP e-Ee(e e  eDee{ee te [12]e  5!86!)7! 8!B!C!!  Value=RP e-Ee(e e  eDee{ee te [11]e  5!86!'7! 8!B!C!!  Value=RP e-Ee(e e  eDee{ee te [10]e  5!86!b%7! 8!B!C!!  Value=RL e-Ee(e e  eDee{ee te[9]e  5!86!<#7! 8!B!C!!  Value=RL e-Ee(e e  eDee{ee te[8]e  5!6!+7! 8!B!C!! Property=RP e-Ee(e e  eDee{ee te [12]e 5!6!)7! 8!B!C!! Property=RP e-Ee(e e  eDee{ee te [11]e 5!6!'7! 8!B!C!! Property=RP e-Ee(e e  eDee{ee te [10]e 5!6!b%7! 8!B!C!! Property=RL e-Ee(e e  eDee{ee te[9]e 5!6!<#7! 8!B!C!! Property=RL e-Ee(e e  eDee{ee te[8]e 5!6!!7! 8!B!C!! Property=RL e-Ee(e e  eDee{ee te[7]e 5!86!!7! 8!B!C!!  Value=RL e-Ee(e e  eDee{ee te[7]e 5!6!7! 8!B!C!! Property=RL e-Ee(e e  eDee{ee te[6]e 5!86!7! 8!B!C!!  Value=RL e-Ee(e e  eDee{ee te[6]e 5!6!7! 8!B!C!! Property=RL e-Ee(e e  eDee{ee te[5]e 5!86!7! 8!B!C!!  Value=RL e-Ee(e e  eDee{ee te[5]e 5!6!7! 8!B!C!! Property=RL e-Ee(e e  eDee{ee te[4]e 5!86!7! 8!B!C!!  Value=RL e-Ee(e e  eDee{ee te[4]e 5!6!+7! 8!B!C!!  Option=RP e-Ee(e e  eDee{ee te [12]e 5!6!)7! 8!B!C!!  Option=RP e-Ee(e e  eDee{ee te [11]e 5!6!'7! 8!B!C!!  Option=RP e-Ee(e e  eDee{ee te [10]e 5!6!b%7! 8!B!C!!  Option=RL e-Ee(e e  eDee{ee te[9]e 5!6!<#7! 8!B!C!!  Option=RL e-Ee(e e  eDee{ee te[8]e 5!6!!7! 8!B!C!!  Option=RL e-Ee(e e  eDee{ee te[7]e  5!6!7! 8!B!C!!  Option=RL e-Ee(e e  eDee{ee te[6]e !5!6!7! 8!B!C!!  Option=RL e-Ee(e e  eDee{ee te[5]e "5!6!7! 8!B!C!!  Option=RL e-Ee(e e  eDee{ee te[4]e #5!6!~7! 8!B!C!!  Option=RL e-Ee(e e  eDee{ee te[3]e $5!6!~7! 8!B!C!! Property=RL e-Ee(e e  eDee{ee te[3]e %5!86!~7! 8!B!C!!  Value=RL e-Ee(e e  eDee{ee te[3]e &5!6!X7! 8!B!C!!  Option=RL e-Ee(e e  eDee{ee te[2]e '5!6!X7! 8!B!C!! Property=RL e-Ee(e e  eDee{ee te[2]e (5!86!X7! 8!B!C!!  Value=RL e-Ee(e e  eDee{ee te[2]e )5!6!27! 8!B!C!!  Option=RL e-Ee(e e  eDee{ee te[1]e ,5!6! 7! 8!B!) *5!6!27! 8!B!C!! Property=RL e-Ee(e e  eDee{ee te[1]e -5!6! 7! 8!B!* +5!86!27! 8!B!C!!  Value=RL e-Ee(e e  eDee{ee te[1]e .5!86! 7! 8!B!+ /5!6!D/7! 8!&9!:!! Edit in Excel (F9)R 05!6!D/7! 8!&9!:!! Update (F11)R dp ddddddfff((!"#$%&'(*+,-.0124569:;<=>@ABDEFIJKLMOPQSTUXYZ[\^_`bcdghijkmnoqrsvwxyz|}~   !"#%&'*+,-.0124569:;<=?@ACDEHIJKLNOPRSTWXYZ[]^_abcfghijlmnpqruvwxy{|}    !"$%&)*+,-/0134589:;<=?@ACDEHIJKLMOPQSTUXYZ[\]^_`ef  efefefefef ef!"ef"#ef##ef$$ef%%ef&&ef''ef((ef**ef++ef,,ef--ef..ef00ef11ef22ef44ef55ef67ef99ef::ef;;ef<<ef==ef>>ef@@efAAefBBefDDefEEefFGefIIefJJefKKefLLefMMefOOefPPefQQefSSefTTefUVefXXefYYefZZef[[ef\\ef^^ef__ef``efbbefccefdeefggefhhefiiefjjefkkefmmefnnefooefqqefrrefstefvvefwwefxxefyyefzzef||ef}}ef~~efefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefef  ef  ef  efefefefefefefefefefefefefefef!!ef""ef##ef%%ef&&ef'(ef**ef++ef,,ef--ef..ef00ef11ef22ef44ef55ef67ef99ef::ef;;ef<<ef==ef??ef@@efAAefCCefDDefEFefHHefIIefJJefKKefLLefNNefOOefPPefRRefSSefTUefWWefXXefYYefZZef[[ef]]ef^^ef__efaaefbbefcdefffefggefhhefiiefjjefllefmmefnnefppefqqefrsefuuefvvefwwefxxefyyef{{ef||ef}}efefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefef ef  ef  ef  efefefefefefefefefefefefefef  ef!!ef""ef$$ef%%ef&'ef))ef**ef++ef,,ef--ef//ef00ef11ef33ef44ef56ef88ef99ef::ef;;ef<<ef==ef??ef@@efAAefCCefDDefEFefHHefIIefJJefKKefLLefMMefOOefPPefQQefSSefTTefUVefXXefYYefZZef[[ef\\ef]]ef^^ef__ef``Sa$ff(f($f(g( f, -(-,-(-QHff8f@f$f$f$f$f$f$f f f f-$$-- f f ff f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f ff f ff  CurrForm5f  xRec  Rec4f  TmpXMLDoc:f  XmlMgt  ExcelStyleList  VersionCode  FoundNode  StyleID  StyleOption8f   StyleProperty8f   StyleValue8f   Text001;f, $Style with ID Label does not exist.  Text002;fd ^Please apply format in Excel sheet.\ Then close and save Excel before saying yes to this.  Text003;f Update cancelled.  Text004;f$ Please specify Style ID.  SetVersion3f  InitForm3f   UpdateForm3f  EditInExcel3f  UpdateTable3f  InsertRec3f SYSTEM DIALOG FILE Which5f Steps5f  BelowxRec5f  BelowxRec5f URL5f URL5f4f4f4f 4f ACTION4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f 4f4f4f 4f ,df df d(fd(g d,f Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $df Tdf $Tdf $Tdf $Tdf $dydf dfdfdf $LQ!s.O $L}Q!X8Oxd}NK $3)6{O>` $LQ!3)6{O>` $LQ!3)6{O>` $LQ!3)6{O>` $LQ!3)6{O>` $L}Q!X8Oxd}NK $3)6{O>` $L}Q!8Ox~NK $3)6{O>` $LFEF $LFF $LFF $LFF $LFF $L $LQ!3)6{O>`ffffffff CLEAR CREATE TEMPORARYPATH FORMAT CREATEGUID ARRAYLEN DELCHR ROUNDLff UPDATE StyleIDfffffff f--fff f-f DELETEALL GetStyleNodes FINDSET INSERT NEXT SETCURRENTKEY Version Parent Node SETRANGE Line No. Node Type RESET Node Name Node Value GetAttributeValue FINDFIRST FINDLAST GET Name Space DELETEf+[f*[f.[f  EditStyleInExcel AddNode AddAttribute ResetLineNumbersfffff SETRECORD SetVersion LOOKUPMODE RUNMODAL GETRECORD<f=HfXf6<f@<f:@f async$ $$ selectSingleNode$f-$$ createNode$0f y--$$ save$ y$$ load$ y$$ selectNodes$f-$$@fHfPf  removeChild$ff$$ selectSingleNode$f- w$$ insertBefore$$ff y$$\f4f\f\f\f\f\f\fHf\f\f\f\f\f\f4f \f4f\f\f  $LQ!3)6{O>` parentNode$ f$$  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>` selectSingleNode$f-$$  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>` attributes$ f$$  $LQ!3)6{O>` childNodes$ f$$  $LQ!3)6{O>`  $LQ!3)6{O>` 04f Hf4f 4f lastChild$ f$$ selectSingleNode$f- w$$ attributes$ f$$ nodeName$ -$$\f<f\f0fJ\f  $LQ!3)6{O>` item$f w$$  $LQ!3)6{O>` length$ $$  $LQ!3)6{O>`DfS0fJ<f getNamedItem$f- w$$ length$ $$ item$f$$<fx0fv value$ y\ y3$$ name$ -$$<f.4f< Visible$ $$ Workbooks$ f$$P4f3 ActiveSheet$ f$$ Lff ERROR CONFIRMl\ff  $LFF Open$f- w y y2 y w y yN y yr yO y y y y y yk$$x\f  $LFFx\f  $LP\f\f\f  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`lyyy   ,f ERASE0f ACTIVATE,f  a3D pL0L1eGeD $  NewVersionCodeIeEe ee?ee{epeete := ete;eEee eee eeee-output-Stylesee eeee ee eeee ee7eee{e @peete;eTeeVeeVePeoutput-Styleste);eWeete;REPEATqete := ete;ete;UNTIL eeWeete = 0;eGe@f(Lf(Xd  StyleXMLTable  StyleXMLTable2  StyleCounterJeEeee eee eee eee ?ee ee e ee e e eee e e e ee e e e eee eeee e ee ee e ee e e eee e e e eee eeee e ee ?ee e ee ?ee e ee?eeee !e?eee ee7eeXee ee7eee{e80,,0@0,,( $,,peeTee te);eTee te);eTee te);ete := 1;eeWeeTeeVeete);eWee TeeVeete);eWee TeeVee te);eWee Tee VeeWee ReQe te );IF eWeete THEN BEGINeWee te;eWeeTeeVeete );eWee TeeVeeWeete);REPEAT eWee TeeVeeWee te );IF eWeete THENREPEATe [eete ] := eWee te;e [eete ] := eWee te;e [eete ] := eWeete;ete := ete + 1;UNTIL IeWeete = 0;UNTIL eWeete = 0;END;eGe|f(f(f(f(g( fffHff f hf f f ffP-Xd-p|||   XMLStyle  XMLStyle2  TempXMLStyle:f  TempXMLStyle2:f  XMLMgt  ExcelDoc $LQ!s.O $3)6{O>`?f.[A  ParentNode $L}Q!X8Oxd}NK $3)6{O>`  DomNode $LQ!3)6{O>`?f.[A  DomNode2 $LQ!3)6{O>`?f.[A  NewDomNode $LQ!3)6{O>`?f.[A  DomNodeList $LQ!3)6{O>`?f.[A  AttributeList $L}Q!X8Oxd}NK $3)6{O>`  Attribute $L}Q!8Ox~NK $3)6{O>`  ExcelApp $LFEF $F?f0[A  ExcelBook $LFF?f1[A  ExcelSheet $LFF?f2[A  TmpFileName  LabelLineNumber  NewLabelAttName  DomnodeFound  i  j  NextLineNo  CurrentVersionJeEeee?ee eeeeeeeee eeee eeeeee-eee-eeeee'ee-.xmlEGU'e?eeefe ee-Workbook/Stylese eeefe ee ee eeeeefe ee e-Stylesoe8-00urn:schemas-microsoft-com:office:spreadsheete eeefe ee- Worksheetlee ee eeeeeefe ee-Stylesie ee eee-Styleee -tyle -tyle -tyleeefe e e-StyleSie ee eee-ss:IDNoe-LabelNoeeee eeee-output-Stylesree eee-e eee-ss:IDLSee3eeee ?eee ee7ee6e-eele7ee ee ee e ee ee e ee e e eee e e eee e e e eee eeehe e ee ee e ee e e eee e e e eee ee/eee eee e -odee -odee -odeeeefe e e ee e ?ee e ?ee eee e e e eee eeede eee eeee ee7eeee ee7eee eeeeeeeeee e eeeefefe e e eee eeefe ee eeee e/ee eeeeeee eeee eeeeefe ee(- Workbook/Worksheet/Table/Rownd e eeefe e ee eeefe e e-CelltSie eeefe e e eeefe e e- ss:StyleIDme eee-eeye e ee?eeefe ee -Workbook/Styles/Styleore eeeeefe e ee eeee !e?eeefe ee eeefe e e-ss:IDede ee-eeye e eee3eeee?eeee e e3ee-eee e ee ee e ee e e eee e e eee e e e ee eeee e e eee eee4ee e d!e?eeTe eeeeee e ,!e?eeefe ee eee@eee e ee "ee Aeeefe e ee ee e?eeee  !e?ee e ?ee e-e e e?eee -ode?eee8-00urn:schemas-microsoft-com:office:spreadsheetng ?eee?ee eeeefe e e eee@eee e ee "ee AeDeefe e ee eee?ee e?eeee  !e?ee e ?ee e-e e e?eeeye e e eee -ame?eee ?ee eeCeCeeeee{e$(lD, @(<T<@ @L<0,,0@0,,x,,(0,, L,, T4<,@DL 4$,<L@0,,0$($0$,$,D,$,,peete := ete;eWeete;eTeete);eTeete);eWeete(FALSE);eWeeTeeVeete);ete := ete + eTeete ) + WPe .xmlEGUte;eete := eWeeTePeWorkbook/Styleste);ete := eWeete;eWeeTeete);eete := eWeete(1,Pe StylesoVePe4urn:schemas-microsoft-com:office:spreadsheette);ete := eWeeTePeWorksheetlete);eWeeTeeVeete);eete := eWeeTePe Stylesite);eWeeTeeVePe Styleete,'','','');eete := eWee TePe StyleSite);eWeeTeeVePe ss:IDNoVePe LabelNote);eete := 0;eWeeTeeVeeVePeoutput-Stylesrte);eeWeete;REPEATIF eWeeTeeVePe ss:IDLSte ) = ete THENete := eWee te;UNTIL (eWeete = 0) OR (ete <> 0);IF ete = 0 THENeTee te);eeWee te;eWeeTeeVee te);eWee TeeVeeWeete);eWee TeeVeete);eWee Tee VeeWee ReQe te );IF eWeete THEN BEGINeWee te;eWeeTeeVeete );eWee TeeVeeWeete);REPEAT eWee Tee VeeWee te);IF NOT eWeete THEN BEGIN eWeeTeeVeeWee te,'','',''); ete := eWee te;eWee te := eWee te;eWee te := eWee te;eWeete;END;e eWee TeeVeeWee te );IF eWeete THENREPEATeWeeTeeVeeWee VeeWeete);UNTIL reWeete = 0;UNTIL eWeete = 0;END;eXe Save xml and open with XLfeeWeeTeete);eTeete);eeTeete);eWee te(TRUE);eete := eWee WeeTeete);ete := eWeete;ete IF NOT eTee te) THENeTeete);eXe Load new format from XLLfeeTeete);eWeete(FALSE);eWeeTeete);eXe@ Excel creates new styles. Find style belonging to 2nd roweete := eWeeTePe$Workbook/Worksheet/Table/Rownd te);ete := eWee te (0);ete := eWee TePe CelltSite);ete := eWee te;ete := eWee TePess:StyleIDmte);ete := eTeeWee te);eXe$ find the style node for Label eete := eWeeTePeWorkbook/Styles/Styleorte);ete := 0;REPEATete := eWee Teete );ete := ete + 1;ete := eWeete;ete := eWee TePe ss:IDedte );IF eTeeWee te ) = ete THENete := TRUE;UNTIL (ete = eWee te ) OR ete;eeWee te;eWeeTeeVeete);eWee TeeVeeWeete);eWee TeeVeete);eWee Tee VeeWee ReQe te);eWeete(TRUE);eeeWee Tee te );IF eWeete THENete := eWee te + 100ELSE BEGINeWeeTeeVeete );ete := eWee te + 300;END;eeeeete := eWeete;ecereete := 0 TO eWee te - 1 DO BEGINete := eWee Teete );eWee te := ete;ete := ete + 10;eWee te := eWee ReQe te;eWee te := eWee te;eWeete := '';eWeete := Pe4urn:schemas-microsoft-com:office:spreadsheetng te;eWeete := ete;eWeete;eteete := eWee te ;FOR ete := 0 TO eWee te - 1 DO BEGINete := eWee Teete ); eWeete := eWeete;eWee te := ete;ete := ete + 10; eWee te := eWee ReQe te;eWee te := eWee te;eWeete := eWee te;eWeete := '';e eWeete := eWee te;eWeete;END;END;eeTeete);eGe@ f(f(f(  ,4<-@-H-QX  XMLStyle  TmpXMLStyle:f  TmpXMLAttribute:f  LabelLineNumber  NextLineNo  OptionCounter  NodeLineNo  ParentNode  StyleID  StyleName  PreviousAttributeJe Eee eee eee ?eee-e eee-ss:IDlee?eee-e eee-ss:Namee?ee eeee eee e e '!e?ee e ?ee e-ss:IDam?eee?eee -ame?eee?ee eeee e '!e?eee @eeee ee Aee-ee e ee -=tie - tiee -ti2eee e e !e?ee e e e?eee e e?eee e e?ee eeCee ee eee eee e e2eee e?eeee !e?ee e ?ee e ?eee -ode?eee8-00urn:schemas-microsoft-com:office:spreadsheetng ?eee ?eee ?ee eeee ?ee e?eeee !e?ee e ?ee e?eee?eee -ame?eee?ee eeee ee7eee{ep4xDD$$$ $($D$peeWeeTeeVee te);ete := eWee te;ete := eWeeTeeVePe ss:IDlete);ete := eWeeTeeVePe ss:Namete);eWeete(TRUE); WXe deletes all sub nodesoeeWeete;UeeeWee te := eWee te + 10000;eWee te := eWee ReQe te;eWee te := Pe ss:IDamte;eWeete := ete;eWeete := '';eeWeete := ete;eWeete;ete := eWee te + 10000;ecereete := 1 TO eTee te) DO BEGINIF eTee [eete$],'=',' ') <> '' THEN BEGINe Xe4insert into temp table to sort by attributesng ete eWee te := eWee te + 1;eWee te := e [eete ]; eWeete := e [eete ]; eWeete := e [eete ]; eWeete;END;END;eWeeTee te );IF eWeete THENREPEATIF eWee te <> ete THEN BEGIN Xe Insert Nodebutete eWee te := ete;ete := ete + 500; eWee te := eWee ReQe te;eWee te := eWee te; XeStyleOptionete eWeete := ''; eWeete := Pe4urn:schemas-microsoft-com:office:spreadsheetng te;eWeete := e te;ete := eWee te;eWeete;ete := eWee te;END;e Xeinsert Attributeofete eWee te := ete;ete := ete + 500;e eWee te := eWee ReQe te;eWee te := eWeete; XeStylePropertyeete eWeete := eWeete; XeStyleValuebete eWeete := '';e eWeete := ete;eWeete;UNTIL eWeete = 0;eGe@f(Hf(PX  NewXMLDoc  NewXMLDoc2  prevLineNoJeEe<ee -tyl3ee eeee eee eee ?ee ee $eee e2 eee "ee2 @ ee2 @ee !e?ee e ?ee e-Styleam?eee8-00urn:schemas-microsoft-com:office:spreadsheetng ?eee -ode?eee?ee eeee?ee e e d!e?ee e ?ee e-ss:IDam?eee?eee -ame?eee ?ee eee e e d!e?ee e-ss:Name?eee?ee eeeee eee ee{eD((pD$$peteIF ete = '' THENeTeete);eeWeeTeeWeeVeeWee te);ete := eWee te;eWeete (-1);eWee te := ete((ete - eWee te) / 2,1) + eWee te;eWee te := eWee ReQe te;eWee te := Pe Styleamte;eWeete := Pe4urn:schemas-microsoft-com:office:spreadsheetng te;eWeete := '';eeWeete := eWeete;eWeete;eeWeete := eWeete;eWee te := eWee te + 100;eeWee te := eWee ReQe te;eWee te := Pe ss:IDamte;eWeete := ete;eWeete := '';eeWeete := eWee te;eWeete;eWee te := eWee te + 100;eeWee te := Pe ss:Namete;eWeete := ete;eWeete;eete;eeTeeWeeVeeWee te);eEeDeeee eeee{e oeOnOpenFormete ;IF ete THEN;eEe,e eeee{eoeOnCloseFormeWeeTeete);EeEe`ee-e eee-ss:IDrie?eeee{e LoeOnAfterGetRecordeete := eTeeVePe ss:IDrite);ete;ueFeEeee -tyl?eee eee eee ee eee{e((oeOnNewRecordete := '';eeTee te);eTee te);eTee te);eeWeeWeete;ueFeEeTee -ers3eeeeee?eee{e 0oeOnInsertRecordteIF ete = '' THENete;EXIT(FALSE);eGe@f(   XMLDeleteFeJeEePe eee ee eeee{e oeOnDeleteRecordeWeeTeeVee te);eWeete (TRUE);eFe Eeeeee eeee eeee eeeefe eee fe<3ee(e eeee{e( 8(oe OnPushieTeete);eWeeTeete);eWeeTeete);eWeete(TRUE);IF eWeete = e)ReQe )e<te THENeWeeTeete);eFeEeLee -ers3eeeeeee{e0oe OnPushiteIF ete = '' THENete;eete;ueFeEeeee{eoe OnPushiete;e2      !"#$%&'(),*-+./0 Form     StyleID   StyleValue StyleValue StyleValue StyleValue StyleValue StyleProperty StyleProperty StyleProperty StyleProperty StyleProperty StyleProperty StyleValue StyleProperty StyleValue StyleProperty StyleValue StyleProperty StyleValue StyleOption StyleOption StyleOption StyleOption StyleOption StyleOption StyleOption StyleOption StyleOption StyleOption StyleProperty StyleValue StyleOption StyleProperty StyleValue StyleOption  StyleProperty  StyleValue    d,XLT Excel Style List d . xlt \ d dd7!*8!6=!!8;7<$R$ d %R(1RA(y09RRR < |<<t<TTD 5!6!7!@)8!|9!:! 5!6!7!&8!;!B!E!=R4 eEeeDee{eee 5!6!7!8!B!F! 5!6!7!08!9!;!B!E!=R4 e-Eee Dee{ee e 5!6!7!8!B!F! 5!6!7!08!B!E!=R4 e-EeeDee{eee 5!6!7!8!B!F! 5!6!47!8!&9!:!@!g!e<h!  5!6!47!8!&9!:!A!g!f<h!  5!!6!47!8!&9!:!g!T dp ddddddfffL7(   !"#$%&()*,-.12345689:<=>ABCDEFGHIJKLef ef ef  ef  ef efefefefefefefefefefefefefefef!!ef""ef##ef$$ef%%ef&&ef((ef))ef**ef,,ef--ef./ef11ef22ef33ef44ef55ef66ef88ef99ef::ef<<ef==ef>?efAAefBBefCCefDDefEEefFFefGGefHHefIIefJJefKKefLL M$ff(f(f($f( -$f--- f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f f f f f f f f  CurrForm5f  xRec  Rec4f  XMLTable  TmpXMLTable:f  VersionCode  NodeValue  SetVersion3f Which5f Steps5f BelowxRec5f BelowxRec5f URL5f URL5f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f4f4f4f4f4f4f4f ldf df d(fdf  H ffffff - COPY GetStyleNodes Version FINDSET INSERT NEXT GetAttributeValue Node Type Node Name \eGe@f(   NewXMLTableIeEe,e eeee{epeeWeeTeete);eEee eeee-output-Styleseee eee`ee ee eeee ee7eee{eH(oeOnOpenFormeTeeWeeVeeVePeoutput-Styleste );IF eWeete THENREPEATete := ete;ete;UNTIL eWeete = 0;eEePee-e eee-ss:IDrie?ee{eoeOnAfterGetRecordeete := eTeeVePe ss:IDrite);eD    Form  Node Type  Node Name  NodeValue    S \-XLT Layout Card d . xltXWXX d dd7!-8!'!d~3<$R$ d %R(1RrGPG9RRRRR2[T 44444DXD\ 5!6!7!+8!`"!$ General Style 5!!6!: 7!8!B!D!=RP eEe(ee  eDee{eete [10]e 5!!6!7!8!B!D!=RL eEe(ee  eDee{eete[9]e 5!6!7! 8!B!D!=RL e-Ee(e e  eDee{ee te[9]e 5!6!: 7! 8!B!D!=RP e-Ee(e e  eDee{ee te [10]e 5!!6!7!8!B!D!=RL eEe(ee  eDee{eete[8]e 5!6!7! 8!B!D!=RL e-Ee(e e  eDee{ee te[8]e 5!6!7! 8!B!D!=RL e-Ee(e e  eDee{ee te[7]e  5!!6!7!8!B!D!=RL eEe(ee  eDee{eete[7]e  5!6!7! 8!B!D!=RL e-Ee(e e  eDee{ee te[6]e  5!!6!7!8!B!D!=RL eEe(ee  eDee{eete[6]e  5!.6!7!8!B!D!=RL eEe(e e  eDee{ee te[8]e  5!.6!7!8!B!D!=RL eEe(e e  eDee{ee te[9]e 5!.6!7!8!B!D!=RL eEe(e e  eDee{ee te[7]e 5!.6!7!8!B!D!=RL eEe(e e  eDee{ee te[6]e 5!.6!: 7!8!B!D!=RP eEe(e e  eDee{ee te [10]e 5!6!|7! 8!B!D!=RL e-Ee(e e  eDee{ee te[5]e 5!!6!|7!8!B!D!=RL eEe(ee  eDee{eete[5]e 5!.6!|7!8!B!D!=RL eEe(e e  eDee{ee te[5]e 5!6!V7! 8!B!D!=RL e-Ee(e e  eDee{ee te[4]e 5!!6!V7!8!B!D!=RL eEe(ee  eDee{eete[4]e 5!.6!V7!8!B!D!=RL eEe(e e  eDee{ee te[4]e 5!6!V7! 8!B!D!=RL e-Ee(e e  eDee{ee te[4]e 5!6!|7! 8!B!D!=RL e-Ee(e e  eDee{ee te[5]e 5!6!7! 8!B!D!=RL e-Ee(e e  eDee{ee te[6]e 5!6!7! 8!B!D!=RL e-Ee(e e  eDee{ee te[7]e 5!6!7! 8!B!D!=RL e-Ee(e e  eDee{ee te[8]e 5!6!7! 8!B!D!=RL e-Ee(e e  eDee{ee te[9]e 5!6!: 7! 8!B!D!=RP e-Ee(e e  eDee{ee te [10]e 5!6!07! 8!B!D!=RL e-Ee(e e  eDee{ee te[3]e 5!.6!07!8!B!D!=RL eEe(e e  eDee{ee te[3]e  5!!6!07!8!B!D!=RL eEe(ee  eDee{eete[3]e !5!6!07! 8!B!D!=RL e-Ee(e e  eDee{ee te[3]e "5!.6! 7!8!B!D!=RL eEe(e e  eDee{ee te[2]e #5!6! 7! 8!B!D!=RL e-Ee(e e  eDee{ee te[2]e $5!!6! 7!8!B!D!=RL eEe(ee  eDee{eete[2]e %5!6! 7! 8!B!D!=RL e-Ee(e e  eDee{ee te[2]e &5!.6! 7!8!B!D!=RL eEe(e e  eDee{ee te[1]e *5!.6! 7!r8!B!& '5!6! 7! 8!B!D!=RL e-Ee(e e  eDee{ee te[1]e +5!6! 7! 8!B!' (5!6! 7! 8!B!D!=RL e-Ee(e e  eDee{ee te[1]e ,5!6! 7! 8!B!( )5!!6! 7!8!B!D!! AND / OR=RL eEe(ee  eDee{eete[1]e -5!!6! 7!8!B!) .5! 6!7!8!p=!B!D!^!<H[A=R4 e-Eee Dee{ee e /5!6!7! 8!B!. 05!^6!47!t 8!B!D!=RP e-Ee(ee  eDee{eete [10]e 15!^6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[9]e 25!|6!47!t 8!B!D!=RP e-Ee(ee  eDee{eete [10]e 35!|6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[9]e 45!^6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[8]e 55!|6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[8]e 65!^6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[7]e 75!|6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[7]e 85! 6!47!t 8!B!D!=RP e-Ee(ee  eDee{eete [10]e 95! 6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[7]e :5! 6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[8]e ;5! 6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[9]e <5!^6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[6]e =5!|6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[6]e >5! 6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[6]e ?5!^6!v 7!t 8!B!D!=RL e-Ee(ee  eDee{eete[5]e @5!|6!v 7!t 8!B!D!=RL e-Ee(ee  eDee{eete[5]e A5! 6!v 7!t 8!B!D!=RL e-Ee(ee  eDee{eete[5]e B5!^6!P 7!t 8!B!D!=RL e-Ee(ee  eDee{eete[4]e C5!|6!P 7!t 8!B!D!=RL e-Ee(ee  eDee{eete[4]e D5! 6!P 7!t 8!B!D!=RL e-Ee(ee  eDee{eete[4]e E5!^6!*7!t 8!B!D!=RL e-Ee(ee  eDee{eete[3]e F5!|6!*7!t 8!B!D!=RL e-Ee(ee  eDee{eete[3]e G5! 6!*7!t 8!B!D!=RL e-Ee(ee  eDee{eete[3]e H5!6!47!t 8!B!D!=RP e-Ee(ee  eDee{eete [10]e I5!6!P 7!t 8!B!D!=RL e-Ee(ee  eDee{eete[4]e J5!6!v 7!t 8!B!D!=RL e-Ee(ee  eDee{eete[5]e K5!6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[6]e L5!6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[7]e M5!6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[8]e N5!6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[9]e O5!6!*7!t 8!B!D!=RL e-Ee(ee  eDee{eete[3]e P5!6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[2]e Q5!^6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[2]e R5!|6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[2]e S5! 6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[2]e T5!6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[1]e U5!^6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[1]e V5!|6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[1]e W5! 6!7!t 8!B!D!=RL e-Ee(ee  eDee{eete[1]e X5!6!$7!8!&9!:!!  Layout!Hg$Rd0(0 [p!?!  ListR \!  ResetR  ]o! ^p!=>w!  InsertR  _;! Y5!6!$7!8!&9!:!!  UpdateR  Z5!$6!$7!8!&9!:!g!T `5!*6!$7!8!&9!:!!  Insert (F3)R  dp ddddddfffV( !"#$%&()*,-.12345789;<=@ABCDFGHJKLOPQRSUVWYZ[^_`abdefhijmnopqstuwxy|}~    !"#$%'()+,-01234678:;<?@ABCEFGIJKNOPQRTUVXYZ]^_`acdeghilmnoprstvwx{|}~     !"#$&'(*+,/01235679:;>?@ABDEFHIJMNOPQRTUVXYZ]^_`abdefhijmnopqrtuvxyz}~     !$%&'(*+,./0345679:;=>?BCDEFHIJLMNQRSTUWXY[\]`abcdfghjklopqrsuvwyz{~     #$%&')*+-./2345689:<=>ABCDEGHIKLMPQRSTVWXZ[\_`abcefgijknopqrtuvxyz}~ef efefefefefef !ef!"ef""ef##ef$$ef%%ef&&ef((ef))ef**ef,,ef--ef./ef11ef22ef33ef44ef55ef77ef88ef99ef;;ef<<ef=>ef@@efAAefBBefCCefDDefFFefGGefHHefJJefKKefLMefOOefPPefQQefRRefSSefUUefVVefWWefYYefZZef[\ef^^ef__ef``efaaefbbefddefeeefffefhhefiiefjkefmmefnnefooefppefqqefssefttefuuefwwefxxefyzef||ef}}ef~~efefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefef  ef  ef  ef  efefefefefefefefefefefefefef!!ef""ef##ef$$ef%%ef''ef((ef))ef++ef,,ef-.ef00ef11ef22ef33ef44ef66ef77ef88ef::ef;;ef<=ef??ef@@efAAefBBefCCefEEefFFefGGefIIefJJefKLefNNefOOefPPefQQefRRefTTefUUefVVefXXefYYefZ[ef]]ef^^ef__ef``efaaefccefddefeeefggefhhefijefllefmmefnnefooefppefrrefssefttefvvefwwefxyef{{ef||ef}}ef~~efefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefef  ef  ef  ef  efefefefefefefefefefefefef  ef!!ef""ef##ef$$ef&&ef''ef((ef**ef++ef,-ef//ef00ef11ef22ef33ef55ef66ef77ef99ef::ef;<ef>>ef??ef@@efAAefBBefDDefEEefFFefHHefIIefJKefMMefNNefOOefPPefQQefRRefTTefUUefVVefXXefYYefZ[ef]]ef^^ef__ef``efaaefbbefddefeeefffefhhefiiefjkefmmefnnefooefppefqqefrrefttefuuefvvefxxefyyefz{ef}}ef~~efefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefef  ef  ef  ef  efefefefefefefefefefefefefef  ef!"ef$$ef%%ef&&ef''ef((ef**ef++ef,,ef..ef//ef01ef33ef44ef55ef66ef77ef99ef::ef;;ef==ef>>ef?@efBBefCCefDDefEEefFFefHHefIIefJJefLLefMMefNOefQQefRRefSSefTTefUUefWWefXXefYYef[[ef\\ef]^ef``efaaefbbefccefddefffefggefhhefjjefkkeflmefooefppefqqefrrefssefuuefvvefwwefyyefzzef{|ef~~efefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefef  ef  ef  ef  efefefefefefefefefefefefefef !ef##ef$$ef%%ef&&ef''ef))ef**ef++ef--ef..ef/0ef22ef33ef44ef55ef66ef88ef99ef::ef<<ef==ef>?efAAefBBefCCefDDefEEefGGefHHefIIefKKefLLefMNefPPefQQefRRefSSefTTefVVefWWefXXefZZef[[ef\]ef__ef``efaaefbbefccefeeefffefggefiiefjjefklefnnefooefppefqqefrrefttefuuefvvefxxefyyefz{ef}}ef~~efefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefefef$ff(f(g(f(f($f( f. f/ -,-Qh,-D(-(-0-0-$f$f$f f f--- f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f fff ff f f f f ff f f f f ff  CurrForm5f  xRec  Rec4f  XMLMgt  XMLTable  XMLTable2  TmpXMLTable:f  XLTLayoutList  LayoutWizard  VersionCode  Condition  ConditionOption8f   Operatord(< =<><<=>>=8f   ConditionText8f   AndOrd( andor8f   ThenName8f  ThenValue8f  ThenAttributeName8f  ThenAttributeValue8f  InitForm3f  SetVersion3f  RunWizard3f SYSTEM ACTION Which5f Steps5f BelowxRec5f BelowxRec5f URL5f URL5f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f 4f 4f4f 4f4f4f4f4f4f 4f4f4f4f4f4f 4f  df df d(fd(g d.f d/f dfdf df,f CLEAR ffffffffff ff DELETEALL GetStyleNodes FINDFIRST RESET SETCURRENTKEY Version Parent Node SETRANGE Line No. FINDSET GetAttributeValue INSERT NEXT GET DELETEf f0[(f1[ ResetLineNumbers TypeFormatToOptions "ConditionFormatOptionsToTableffffff GETRECORD SETRECORD EDITABLE SetVersion LOOKUPMODE RUNMODALtfff SetRec LOOKUPMODE RUNMODALLff    ( 8|Hp<YZL\$_LaeEee eee ee ee$-Control[@type='TextBox']ee eee eee ee e ee ee eee ee e ee e ee-e e ee-testbleee -est2ee4ee ee e eee e e7ee`e{e$ L0,,Ppeete;eTee VeeVePe Control[@type='TextBox']te);eWeete;eeWeete;eWeeTeeVeete);eWeeTeeVeeWeete);eWeeTeeVeeWee te);eWee te;REPEATIF eWee TeeVePe testblete) <> '' THEN BEGIN ete := ete;e te;END;UNTIL eWee te = 0;eGe@   NewVersionIeEe e e?ee{epee te := ete;eGe|, <H  NewLayoutVersion  NewLayoutLineNoJeEeeeee eee ee eeeefe eee fe<3ee8eee eeee{e(H ,peeTeete);eWeeTeeVee te);eWeete(TRUE);eeteIF eWeete = eReQe e<te THEN BEGINete;eWeeTeete );END;eEeeee{eoeOnOpenFormete;eEe,e eeee{eoeOnCloseFormeWeeTeete);eEee e-e e ee-testtrie?ee eee e e eeeeee e{e L`oeOnAfterGetRecordee te := eWee TeeVePe testtrite);eWeete(eVee Vee Vee VeeVeeVeeVeeVeete);eGe@f(   XMLDeleteFeJeEePe eee ee eeee{e `oeOnDeleteRecordeWeeTeeVee te);eWeete (TRUE);eFeEeeeee eeee eeee eeee eeeefe eee fe<3ee(e eeee{e(  8oe OnPushteTeete);eWeeTeete);eWeete(FALSE);eWeeTeete);eWeete(TRUE);IF eWeete = eReQe e<te THENeWeeTeete);eFeEe e{e oe OnPushtte{seDataTypeFormat.RESET;']ese4DataTypeFormat.SETRANGE("Style ID","Style ID");ese<DataTypeFormat.SETRANGE("Control Type","Control Type");ese4DataTypeFormat.SETRANGE("Sub Type","Sub Type");ese(DataTypeFormat.SETRANGE(Test,Test);ese8DataTypeFormat.SETRANGE(Description,Description);peese DataTypeFormat.DELETEALL;scese XLStyleDescription := '';sceseUpdateForm;ete}ueFeEeeee{eoe OnPushtete;eFeEee eee ee eee e e eeeeee eeee eee eee{e8`oe OnPushieWeeTeeVee te);eWeete(eVee Vee Vee VeeVeeVeeVeeVeete);eete ;IF eTeeWeeVeeWee te ) THENeFeEeeee{eoe OnPushiete;et b      !"#$%&*'+(,)-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVW[\]^_XYZ` Form  AndOr AndOr ConditionText ConditionText AndOr ConditionText ConditionText AndOr ConditionText AndOr Operator Operator Operator Operator Operator ConditionText AndOr Operator ConditionText AndOr Operator ConditionOption ConditionOption ConditionOption ConditionOption ConditionOption ConditionOption ConditionOption ConditionText Operator AndOr ConditionOption Operator ConditionText AndOr ConditionOption Operator  ConditionOption  ConditionText  AndOr  Condition  ThenValue ThenValue ThenAttributeValue ThenAttributeValue ThenValue ThenAttributeValue ThenValue ThenAttributeValue ThenAttributeName ThenAttributeName ThenAttributeName ThenAttributeName ThenValue ThenAttributeValue ThenAttributeName ThenValue ThenAttributeValue ThenAttributeName ThenValue ThenAttributeValue ThenAttributeName ThenValue ThenAttributeValue ThenAttributeName ThenName ThenName ThenName ThenName ThenName ThenName ThenName ThenName ThenName ThenValue ThenAttributeValue ThenAttributeName ThenName ThenValue ThenAttributeValue ThenAttributeName         T \.XLT Layout List d . xlt d dd7!>&8!6!X{7<$R$ d %R(1RgE+9RRR < |<<|<TTD 5!6!7!$8!|9!:! 5!6!t 7!&8!;!B!E!=R4 eEeeDee{eee 5!6!7!8!B!F!  5!,6!v 7!x8!9!:!B!E!!  Node Value=R4 e-EeeDee{eee  5!6!7!8!B! F! 5!&6!t 7!08!;!B!E!=R4 e-EeeDee{eee 5!6!7!8!B!F! 5! 6!47!8!&9!:!@!g!e<h! 5!V6!47!8!&9!:!A!g!f<h! 5!6!47!8!&9!:!g!T dp ddddddfffL7(   !"#$%&()*,-.12345689:<=>ABCDEFGHIJKLef ef ef  ef  ef efefefefefefefefefefefefefefef!!ef""ef##ef$$ef%%ef&&ef((ef))ef**ef,,ef--ef./ef11ef22ef33ef44ef55ef66ef88ef99ef::ef<<ef==ef>?efAAefBBefCCefDDefEEefFFefGGefHHefIIefJJefKKefLL M$ff(f(f($f( -$f--- f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f f f f f f f f  CurrForm5f  xRec  Rec4f  XMLTable  TmpXMLTable:f  VersionCode  NodeValue  SetVersion3f Which5f Steps5f BelowxRec5f BelowxRec5f URL5f URL5f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f4f4f4f4f4f4f4f ldf df d(fdf  <ffffffffff f - COPY GetStyleNodes Version FINDFIRST RESET SETCURRENTKEY Parent Node SETRANGE Line No. FINDSET GetAttributeValue INSERT NEXT GET Node Type Node Name eGe@f(   NewXMLTableIeEe,e eeee{epeeWeeTeete);eGe@f(   XMLTable2JeEee eeee$-Control[@type='TextBox']ee eee eee ee e ee ee eee ee e ee e ee-e e ee-testbleee -est2ee4ee ee e eee e e7ee`ee eee eee{e,0,,P,oeOnOpenFormeTeeWeeVeeVePe Control[@type='TextBox']te);eeWeete;eeWeete;eWeeTeeVeete);eWeeTeeVeeWeete);eWeeTeeVeeWee te);eWee te;REPEATIF eWee TeeVePe testblete) <> '' THEN BEGIN ete := ete;e te;END;UNTIL eWee te = 0;eeteIF eTeeWeeVeeWee te ) THEN;eEePee-e e ee-testtrie?ee{eoeOnAfterGetRecordeete := e TeeVePe testtrite);eD    Form  Node Type  NodeValue  Node Name     `/XLT Layout Xizard d . xlt\[~\[8[ d hdd7!J88! !$R$ d %R(1RX"W/RD`T 4||||XTPTP 5!6!7!08! :!i! ! 5!h.6!87!8!&9!:!g!e<! &FinishR 5!6!7!%8!9!:!!  Apply Style 5!z6!(7!r8!B!C!! Table ID< =R4 eEee Dee{ee eRR 5!z6!7! 8!B! 5!6!(7!8!=!B!C!=R4 e-Eee Dee{ee e  5!6!7! 8!=!B!C!=R4 e-Eee Dee{ee e  5!d(6!7!(8!B!C!< =R4 eEeeDee{eee  5!-6!7! 8!B!C!<=R4 e-EeeDee{eee  5!z6!7!8!B!C!< =R4 eEee Dee{ee eR R   5!z6!v 7!8!B!C!! Add Condition 5!d(6!7!(8!B!C!! Condition 5!-6!7! 8!B!C!!  Value 5!z6!V7! 8!B!C!!  Chose style 5!z6!|7!8!B!C!<=R4 e-EeeDee{eeeR R  5!z6!7! 8!B!C!!  Field dp ddddddfff< a(!"#$%&'()*+-./1236789:;=>?ABCFGHIJLMNPQRUVWXY[\]_`adefghjklnopstuvwyz{}~ef efefefefef ef!"ef"#ef##ef$$ef%%ef&&ef''ef((ef))ef**ef++ef--ef..ef//ef11ef22ef34ef66ef77ef88ef99ef::ef;;ef==ef>>ef??efAAefBBefCDefFFefGGefHHefIIefJJefLLefMMefNNefPPefQQefRSefUUefVVefWWefXXefYYef[[ef\\ef]]ef__ef``efabefddefeeefffefggefhhefjjefkkefllefnnefooefpqefssefttefuuefvvefwwefyyefzzef{{ef}}ef~~efefefefefefefefefefefefefefefefefefef@$ff(f(f(f(f)f)5wf5wf,g(--` --$  f$f(f(f f--- f f ff f f- f f f- ff f -f f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- f f f- f f f f f- f f f- ff f -f f f f f f f f f- f f f- ff f -f f f f f  CurrForm5f  xRec  Rec4f  MainXMLDoc  XMLDoc  XLTStyle  FieldRec  Object  XLStyleList  XMLMgt  TableID  TblName  FldID  FldName  NewOperatorFldd(< =<><<=>>=  NewConditionFld  XLStyleID  NewLayoutVersion  NewLayoutLineNo  VersionCode  SetRec3f  UpdateTable3f  FinishWizard3f  BuildTestString3f SYSTEM Which5f Steps5f BelowxRec5f BelowxRec5f URL5f URL5f4f4f4f 4f4f4f Text5f4f4f4f Text5f4f 4f4f  Text5f 4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f Text5f4f4f4f Text5f4f 4f4f  Text5f 4f4f4f4f4f4f4f4f4f Text5f4f4f4f Text5f4f 4f4f  Text5f 4f ACTION4f4f4f  df df d(fd)fd)5wfd5wfd,f d(g dfdfdf ffff ROUND FORMAT UPPERCASE CLEAR,f CLOSE<ff ff ---fffff GetStyleNodes FINDFIRST Line No. GET NEXT Node Type Node Name Node Value Name Space Parent Node INSERT Version FINDSET GetAttributeValue SETRANGE RESET ff-=< GET CALCFIELDS Default Table Name Default Table ID f-f  GET FieldName SETRANGE TableNo No. f-  GET Type Name IDfffff SetVersion EDITABLE LOOKUPMODE RUNMODAL GETRECORDXff LookupObject LookupField ,f  x*  xl(8  eGet,f(4 @  NewXMLDoc  NewVersionCodeIeEe4ee eee?ee{e peete := ete;ete := ete;ueEe e{epeeGehf(tf(x  TmpXML:f  XMLRec  BeginLineNo  NextLineNo  ParentNodeNumberJeEee eeee$-Control[@type='TextBox']ee eeee?ee eeeee eeee2 eee"ee2 @ ee!ee2 @e?eee?eee?eeee d!e?eee ?eee- xsl:whenu?eee -ode?ee e0-((http://www.w3.org/1999/XSL/Transform?ee e?ee e eee ?eee?eee?eeee d!e?eee ?eee-testNam?eee-ee?ee e -ame?ee e?ee e eee?eeee !e?eee ?eee-xsl:attribute n?eee -ode?ee e0-((http://www.w3.org/1999/XSL/Transform?ee e?eee?ee e eee?eeee d!e?eee ?eee-nameNam?eee- ss:StyleIDb?ee e -ame?ee e?ee e eee?eee ?eee-#textam?eee?ee e -ame?ee e?ee e eee eeeeee{e>d(p$ <$$$$<$ peeTeeVeeVePe Control[@type='TextBox']te);eeWeete;ete := eWeete;eWeeTeeVeeWeete);eWeete;ete := ete((eWeete - ete) / 2 +ete ,1);eXe NodeineeWeete := ete;ete := eWeete;ete := ete + 100;eeWeete := eWeeReQe te;eWeete := Pexsl:whenute;eWeete := '';eeWee te := Pe,http://www.w3.org/1999/XSL/Transformte;eWee te := ete;eWee te;ete := eWee te;ete := eWeete;eeXe AttributeneeWeete := ete;ete := ete + 100;eeWeete := eWeeReQe te;eWeete := Pe testNamte;eWeete := ete;eWee te := '';eeWee te := ete;eWee te;eXe xsl:attribute nodeeeWeete := ete;ete := ete + 1;eWeete := eWeeReQe te;eWeete := Pexsl:attribute nte;eWeete := '';eeWee te := Pe,http://www.w3.org/1999/XSL/Transformte;eWee te := ete;ete := eWeete;eWee te;eXe Name attributeeeWeete := ete;ete := ete + 100;eeWeete := eWeeReQe te;eWeete := Pe nameNamte;eWeete := Pess:StyleIDbte;eWee te := '';eeWee te := ete;eWee te;eXe TextoeeWeete := ete;eWeete := eWeeReQe te;eWeete := Pe #textamte;eWeete := ete;eWee te := '';eeWee te := ete;eWee te;eteIF eTeeVeete ) THEN;eGeX,--$  TmpStringHeJeEeee- (@name='in?eeee 'ee -')N'e?ee-eeee -ewC2eeeee- and(@valuen'e?eee 3ee4eee -!=S'e?ee@eee-eee'e?eeee -'pS'ee'ee -'wC'e?eeee -)pS'e?eee?eee{e$ 0d $@@$ peete := Pe(@name='inte;ete := ete + e te + ''')';eteIF eTeete) <> '' THEN BEGINete := ete + Peand(@valuente ;IF ete = eReQe te THENete := ete + '!='ELSEete := ete + eTeete );ete := ete + '''' + ete + '''';qete := ete +')';END;eeDeTeete);eEeee ee eeTe ee ee e?ee e?ee{e\oeOnOpenFormteIF eWeeTeeWee te) THEN BEGINqeWeeTeete );e te := eWeete;e te := eWeete ;END;eGeD-$  TmpDescriptionFe JeEe4eee eee{e(loe OnPushiete;eXe$TmpDescription := Description;seXe$Description := NewDescription;seXe SSMgt.TypeFormatToOptions(oeXet Rec,ConditionOption,Operator,ConditionText,AndOr,ThenName,ThenValue,ThenAttributeName,ThenAttributeValue);eeXeAddCondition;nOeXeUpdateTable;nOeeete{se SSMgt.TypeFormatToOptionsateset (Rec,ConditionOption,Operator,ConditionText,AndOr,ThenName,ThenValue,ThenAttributeName,ThenAttributeValue);ete}eeWeete;ueFeEeee ee e -e ee$e e?ee e e -blN?ee{eX oeOnValidatetteIF eWeeTeeWeeReQe te ,'',e te) THENe te := eWeeeaeetee te := '';eFeEee 6ee@e ee e -eee eeee6ee0e e?ee e?ee{e$8 (oeOnLookuplidteIF e te <> 0 THENeWeeTeeWeeReQe te ,'',eWeete);e WeeTeete );IF eWeete <> 0 THEN BEGINqe te := eWeete;e te := eWeete ;END;eFeLEexee ee e ee$e e?ee e e -ldN?ee{eH (oeOnValidatetteIF eWeeTee Vee te) THENe te := eWeeeaeetee te := '';eFeNEee 6ee4e ee e ee eeee6ee0e e?ee e?ee{e$, (oeOnLookuplidteIF e te <> 0 THENeWeeTeeVee te);e WeeTeete );IF eWeete <> 0 THEN BEGINqe te := eWeete;e te := eWeete ;END;eGeDf($  TmpXML:fFe[JeEeee -LSt2ee\e ee ee-output-Stylesgeeee e eee-ee-e eee-ss:IDieee-eee3eeLee-e eee-ss:IDie?eee ee7eee{e|@(|D,oeOnValidatetXe( Make sure to get the right caseondeteIF ete <> '' THEN BEGINeWeeTeeWee VeeVePeoutput-Stylesgete );IF eWee te THENREPEATIF deTeeWeeTeeVePe ss:IDite )) = eTeete) THENp ete := eWeeTeeVePe ss:IDite)UNTIL e eWeete = 0;END;eFe]Eeeeee ee e eee eeee eeee eeee eeeefe eee fe<3eele eeeee-e eee-ss:IDie?ee eee{e (,( XDoeOnLookuplideTeete);eWeeTee VeeWee te );IF eWeete THEN;eWeeTeete);eWeete(FALSE);eWeete(TRUE);IF eWeete = eReQe e<te THEN BEGINeWeeTeete );ete := eWeeTeeVePe ss:IDite);ete END;eWeete;ue      Form    TableID  TblName FldName NewOperatorFld NewConditionFld FldID     XLStyleID  `0XLT Total Fields d . xltQ d hdd7!t@8!6!0j7<$R$ d %R*1R6(E< t<t<TTD 5!6!7!>8!|9!:! 5!6!7!8!B!E!=R4 eEeeDee{eee 5!6!7!8!B!F! 5!6!7!(8!B!E!=R4 e-EeeDee{eee 5!6!7!8!B!F! 5!$6!47!8!&9!:!@!g!e<h! 5!-6!47!8!&9!:!A!g!f<h! 5!76!47!8!&9!:!g!T dp ddddddfff,+(     !#$%'(),-./01234567ef efefefefef  ef  ef  ef efefefefefefefefefefefefefefef ef!!ef##ef$$ef%%ef''ef((ef)*ef,,ef--ef..ef//ef00ef11ef22ef33ef44ef55ef66ef778$ff*f*--- f f- f f f- f f f- f f f f f f- f f f- f f f- f f f f f f f f f f f f f  CurrForm5f  xRec  Rec4f Which5f Steps5f BelowxRec5f BelowxRec5f URL5f URL5f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f Text5f4f4f4f Text5f4f4f4f Text5f4f4f4f4f4f4f4f4f4f4f4f4f4f ldf df d*fdf  T-  Field ID Field Name e   Form  Field ID  Field Name    D `(XML Document Mgt d . xltd/9d/@// d dp ddddddfff <(ef 8 f(f-$ $-QPfPfXf f f$f,f(f(f,f(f f,f8f0f(f$f,f,fxfwL6w|fwL6w f f f!  XMLDocTabletmp  GlobalXMLDoc $LQ!s.O $3)6{O>`?f  FileName  GlobalVersionCode  LineCounter  CurrentNameSpace  Text001;f4 /Document %1 is not a valid xml document.  Text002;f4 ,Condition already exists in line number %1.  Text003;f< 7Invalid operator at the beginning of this line:\  Import3f  Export3f  InsertNode3f  InsertAttributes3f  WriteSubNodes3f  WriteAttribute3f *[A EditStyleInExcel3f -[A AddAttribute3f )[A AddNode3f  /[A TypeFormatToOptions3f  0[A "ConditionFormatOptionsToTable3f  4[A GetOperatorPos3f 9f  LookupObject3f   LookupField3f  PostProcess3f9f   ResetLineNumbers3f  GlobalXMLDoc::ondataavailable3f=f>f?f@fondataavailableAfGlobalXMLDoc  GlobalXMLDoc::onreadystatechan3f=f>f?f@fonreadystatechangeAfGlobalXMLDoc SYSTEM DIALOG ACTION (df d(fTdf $Tdf $Tdf $Tdf $Tdf $df Tdf $Tdf $Tdf $Tdf $Tdf $dyTdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $d5wfdff dfdf d)5wfdJf Tdf $d)fTdf $Tdf $ $LQ!s.O $LQ!s.O $L0Q!'xTNK $3)6{O>` $L0Q!'xTNK $3)6{O>` $LQ!3)6{O>` $LQ!3)6{O>` $LQ!s.O $L0Q!'xTNK $3)6{O>` $L0Q!'xTNK $3)6{O>` $L}Q! f'x~NK $3)6{O>` $L0Q!'xTNK $3)6{O>` $LQ!3)6{O>` $L}Q!Myx~NK $3)6{O>` $LQ!3)6{O>` $LQ!3)6{O>` $LQ!3)6{O>` $LQ!s.O $L}Q!\Քxd}NK $3)6{O>` $L}Q!\Քxd}NK $3)6{O>` $L}Q!B۔xd}NK $3)6{O>` $LQ!3)6{O>` $LQ!3)6{O>` $L}Q!Քx~NK $3)6{O>` $LQ!3)6{O>` $L}Q!\Քxd}NK $3)6{O>` $LQ!3)6{O>` $LQ!s.O $L}Q!I<1x~NK $3)6{O>` $L}Q!I<1x~NK $3)6{O>`T ffffffffff CREATE ISCLEAR FORMAT CLEAR STRPOS COPYSTR STRLEN LOWERCASE ARRAYLEN DELCHRff --ff-ffffffffff SETRANGE Version Parent Node FINDSET Node Type Node Name Name Space NEXT INIT Line No. Node Value INSERT SETCURRENTKEY SETFILTER GetStyleNodes COPY GetAttributeValue RESET DELETE DELETEALL FINDFIRSTXf6Df/Df+ createNode$0f y--$$ createAttribute$f-$$ createTextNode$f-$$<f=<f:4f async$ $$ load$ y$$ childNodes$ f$$0fJ<f length$ $$ item$f$$  \f\f0fJ<f\f\f\f\f\f\f  $LQ!3)6{O>`  $LQ!3)6{O>` length$ $$ item$f$$  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`,f ERRORlD\f\f\f\f\f\f\f4f@f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f\f4f \fHf\f4f\f\f\f8f 4f\fPf \f4f \f\f\f4f\f\f\f\f\f\f\f\f\f\f  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>` nodeType$ y\$$ nodeValue$ y y$$  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>` attributes$ f$$  $LQ!3)6{O>` selectSingleNode$f-$$  $LQ!3)6{O>` childNodes$ f$$  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>` namespaceURI$ -\$$ firstChild$ f$$  $LQ!3)6{O>` insertBefore$$ff y$$  $LQ!3)6{O>` lastChild$ f$$  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>` parentNode$ f$$  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`TXf6@f4f <f@ createNode$0f y--$$ appendChild$ff$$ lastChild$ f$$ save$ y$$ l4f4f<f8f 4f nodeType$ y$$ nodeName$ -$$ text$--$$ namespaceURI$ -$$ childNodes$ f$$ l yyyyyyyyyyy           P4f  attributes$ f$$ \f0fJ<f\fDfT\f\f\fDfS\f  $LQ!3)6{O>` length$ $$ item$f$$  $LQ!3)6{O>` setNamedItem$ff w$$  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>` getNamedItem$f-$$  $LQ!3)6{O>`4f0fv<fx nodeType$ y$$ name$ -$$ value$ y y$$\@f appendChild$ff$$P4f  attributes$ f$$0\f<fx\f  $LQ!3)6{O>` value$ y y$$  $LQ!3)6{O>`<f=\f.Pf 4fXf6@fHf@f async$ $$ createProcessingInstruction$$f--$$ insertBefore$$ff y$$ childNodes$ f\$$ createNode$0f y--$$ appendChild$ff$$ selectSingleNode$f-$$ selectNodes$f-$$4f Hf@f lastChild$ f$$ selectSingleNode$f-$$ appendChild$ff$$<f0fJ item$f w$$ length$ \$$ \f\f  $LQ!3)6{O>`  $LQ!3)6{O>`P4f  attributes$ f$$X<fx value$ y y$$\@f appendChild$ff$$ x\f  $LQ!3)6{O>` ffffff SETRECORD SETTABLEVIEW EDITABLE LOOKUPMODE RUNMODAL GETRECORDLff    ffffff SETRECORD SETTABLEVIEW EDITABLE LOOKUPMODE RUNMODAL GETRECORD@fXf6 selectNodes$f-3)$$ createNode$0f y--$$L f-F GET Total Style0fv<fx name$ -$$ value$ y5 y8$$0fJ<f length$ $$ item$f$$dH64'\#h eGeD| -ff`f  VersionCode  FileName  XMLDoc $LQ!s.O $3)6{O>`?f  MainNodeList $L0Q!'xTNK $3)6{O>`?f  MainNode $L0Q!'xTNK $3)6{O>`?f  iIeJeEeee?eeeee eeee eeeeefe ee eee ee7ee(eeeeee@eee eee "ee Aedeefe eee ee eeeCee{e p ,, pe ete := ete;eeTeete);eWeete(FALSE);eWeeTeete);eete := eWeete ;IF eWeete = 0 THENeTeeVeete );FOR ete := 0 TO eWeete - 1 DO BEGINete := eWeeTeete );e Teete,0);END;eGeh p-xf(f f L  VersionCode  FileName  XMLDocTable  XMLDoc $LQ!s.O $3)6{O>`?f  Node $L0Q!'xTNK $3)6{O>`?fIeJeEeeeeeeeee eeee ee eee ee eee eeeefe e eeee eeeeee e eeee ee7eeXeefe e e ee eeeeeeee e eee{e,(,,D ,, pe eTeete );IF eTeete) THENeTeete);eWeeTeeVeete);eWeeTeete ,0);eWeete;REPEATqete := eWee TeeWeeVeeWeeVeeWeete );eTeeVeete );eWee Teete);UNTIL eWeete = 0;eete := eWee te;e TeeVeete);eeTeeVeete);eeWee Teete);eGe$|f f(fLf   NewXMLNode $L0Q!'xTNK $3)6{O>`?f  ParentNodeLineNo  XMLDocTable  NodeList $LQ!3)6{O>`  SubNode $L}Q! f'x~NK $3)6{O>`  iIeJeEeeee '!e?ee e eee?ee e?eeeye e e eee-e e e?ee-eeye e eee -1de2ee4e e-e e e?eee-e e e?eee?ee e ee ee eeefe e e eee@eee eee "ee Aedeefe eee ee ee eCee{e,`,,P,, , pe ete := ete + 10000;eWee te;eWeete := ete;eWee te := ete;eWeete := eWee te;eWeete := eWee te ;IF eTeeWee te) <> '1' THENeWee te := eWee te;eWeete := eWee te;eWeete := ete;eWee te;e TeeVeeWee te);eete := eWee te ;FOR ete := 0 TO eWeete - 1 DO BEGINete := eWeeTeete );e TeeVeeWee te );END;eGe,|ff(fPf  NewXMLNode $L0Q!'xTNK $3)6{O>`?f  ParentNodeLineNo  XMLDocTable  AttributeList $LQ!3)6{O>`  Attribute $L}Q!Myx~NK $3)6{O>`  iIeJeEeeefe ee eeeeeeeee@eee eee "ee AeXeefe eee ee e eee?eeee '!e?ee e?eeeye ee eee-e ee?ee eye ee eee?ee e eCee{e$p($,,,pe ete := eWeete ;IF eTeete) THENEXIT;FOR ete := 0 TO eWeete - 1 DO BEGINete := eWeeTeete );eWee te;eWeete := ete;ete := ete + 10000;eWee te := ete;eWeete := eWeete;eWeete := eWeete;eWee te := eWeete;eWeete := ete;eWee te ;END;eGexTff(f(f  ParentNode $LQ!3)6{O>`5f  XMLTable  XLMTableSubNode  NewNode $LQ!3)6{O>`IeJeEe<e e e e ee ee eee ee e ee ee e-<>%1Type eee eeeHeefe eeeee ee-eeye eeee -3de3ee(e e e eeeeee eeee eeeee ee7eee{e ,,@(DP pe eWee TeeVeete);eWeeTeeVeeWeete);eWeeTeeVeeWee te);eWeeTeete,'<>%1',eWeeReQe te );IF eWeete THENREPEATete := eWeeTeeWeeVeeWeeVeeWeete );IF eTeeWeete) = '3' THEN Xetext nodeNete eWee te := eWee te;eTeeVeete ); e TeeVeete ); eWeeTeete);UNTIL jeWeete = 0;eGeTff(f(f$  ParentNode $LQ!3)6{O>`5f  XMLTable  XMLTableAttributes  Attribute $LQ!3)6{O>`IeJeEete ee eee ee e ee ee e eee eeeeefe eee ee ee eefe ee eeeee ee7eePe{e0,(4 8peeWeeTeeVeeWeete);eWeeTeeVeeWeeReQe te);eWeeTeeVeeWee te );IF eWeete THENREPEATete := eWeeTeeWeete ); eWeete := eWee te;eWeeWeeTeete);UNTIL jeWeete = 0;eGe fTf(Xf(lf(pf(tff fxff,-4 )[A ExcelDomDoc $LQ!s.O $3)6{O>`5f  XMLRec  TmpXmlRecStyles:f  XMLRec2  XMLRec3 ([A XMLNode $L}Q!\Քxd}NK $3)6{O>`  SubXMLNode $L}Q!\Քxd}NK $3)6{O>`  SubXMLNode2 $L}Q!\Քxd}NK $3)6{O>` +[A XMLNodeList $L}Q!\Քxd}NK $3)6{O>` ,[A XMLProcessing $L}Q!B۔xd}NK $3)6{O>` -[A FileNameIeJe Ee8eeeee eeee eeeeefe ee -xmle-version="1.0"nge ee eeefefe ee eeeeeefe ee-mso-applicatione -progid="Excel.Sheet"ucte ee eeefefe ee eeeeeefe ee e- Workbookee -orke eeee-xmlnsee8-00urn:schemas-microsoft-com:office:spreadsheeteeee-xmlns:oe0-((urn:schemas-microsoft-com:office:officeeeee-xmlns:xe0-((urn:schemas-microsoft-com:office:exceleeee- xmlns:ssutee8-00urn:schemas-microsoft-com:office:spreadsheeteeee- xmlns:htmlee(- http://www.w3.org/TR/REC-html40ee eeeee0-((urn:schemas-microsoft-com:office:excels?eeefe ee- Workbookglee eeee-ExcelWorkbookdee -xcee-xmlnsoreeeefe ee -Workbook/ExcelWorkbookoe eeee-WindowHeightlWoe-9300wHee -300e -300eeee- WindowWidthe-15135Wie -513e -513eeee- WindowTopXe -120e -20e -20eeee- WindowTopYe -120e -20e -20eeee-ProtectStructurekboe-FalsetSe -alse -alseeee-ProtectWindowsee-FalsetWe -alse -alseee8-00urn:schemas-microsoft-com:office:spreadsheet?eeefe ee- Workbookglee eeee-Stylese -tyle -tyle -tyleeefe ee ee eeee-output-Stylesseee eeee e e e ee ee eeeee-Styleee -tyle -tyle -tyleeefe ee ee ee e ee ee e eee eee\eeee eee ee7eee ee e eee eeeeeee e -odee -odeeeefe ee ee eeee ee e ee ee e eee eee\eeee eee ee7eeee ee7eexee ee7eeeefe ee- Workbookglee eeee- Worksheetlee -orke -orke -orkeeefe ee-Workbook/Worksheetfe eeee-ss:Namee-Test documentheeeee-Tableee -able -able -ableeefe ee$-Workbook/Worksheet/Table:ofe eeee -ss:ExpandedColumnCountee -1:Eeeee-ss:ExpandedRowCounte -3:Eeeee-x:FullColumnsCoe -1Fueeee- x:FullRowsee -1Fueeee-Columne -olue -olue -olueeefe ee(- Workbook/Worksheet/Table/Columne eeee-ss:AutoFitWidthe -0:Aeeee- ss:Widthutee-46.5dtheeefe ee$-Workbook/Worksheet/TableCole eeee -Rowe -owe -owe -oweeefe ee(- Workbook/Worksheet/Table/Rowmne eeefe eee eee "ee eeee- ss:Heighttee-15.75gheeee-Celldee -elle -elle -elleeefe ee-CelltSie eeee- ss:StyleIDee-Labelleeeee-Datadee(- Apply your format to this celle -pple -ppleeefe ee-DatatSie eeee-ss:Typee-Stringeee0-((urn:schemas-microsoft-com:office:excels?eeefe ee-Workbook/Worksheetfe eeee-WorksheetOptionstfe -orke -orke -orkeeefe ee,-$$Workbook/Worksheet/WorksheetOptionse eeee-xmlnseeeeee- SelectedmeSe -elee -elee -eleeeee-Panesee -anee -anee -aneeeee-ProtectObjectsee-FalsetOe -alse -alseeee-ProtectScenariost/We-FalsetSe -alse -alseeefe ee4-,,Workbook/Worksheet/WorksheetOptions/Panesete eeee-Panedee -anee -anee -aneeeefe ee8-00Workbook/Worksheet/WorksheetOptions/Panes/Panee eeee-Numbere -3mbe -mbe -mbeeee- ActiveRowore -0tie -tie -tieeee- ActiveColore -0tie -tie -tieee8-00urn:schemas-microsoft-com:office:spreadsheete?ee{et\P`d`X`XXdT <@TLXTPP\XD@L,@X,L,,0((,0(@, ,0((,,,@PH@LPD@<8LT<<PHT\<L<<h<8<HXX0PLX\`LdLPPpeteIF eTeete) THENeTeete);eWeete(FALSE);eXe Processing Instructionseete := eWeeTePexmlVePeversion="1.0"ngte);eWeeTeeVeeWeeWeete (0));ete := eWeeTePemso-applicationVePeprogid="Excel.Sheet"uctte);eWeeTeeVeeWeeWeete (0));eete := eWeete(1,PeWorkbookete ,'');eTeeVePe xmlnseVePe4urn:schemas-microsoft-com:office:spreadsheette);eTeeVePe xmlns:oVePe,urn:schemas-microsoft-com:office:officete);eTeeVePe xmlns:xVePe,urn:schemas-microsoft-com:office:excelte);eTeeVePexmlns:ssuteVePe4urn:schemas-microsoft-com:office:spreadsheette);eTeeVePexmlns:htmleVePe$http://www.w3.org/TR/REC-html40te);eWeeTeete);eXe WorkBookdeete := Pe,urn:schemas-microsoft-com:office:excelste;ete := eWeeTePeWorkbookglete);eTeeVePeExcelWorkbookdete ,'',Pe xmlnsorVeete);ete := eWeeTePeWorkbook/ExcelWorkbookote);eTeeVePeWindowHeightlWote,'9300','','');eeTeeVePeWindowWidthte,'15135','','');eTeeVePeWindowTopXte,'120','','');eTeeVePeWindowTopYte,'120','','');eTeeVePeProtectStructurekboVePe FalsetSte,'','');eTeeVePeProtectWindowseVePe FalsetWte,'','');ete := Pe4urn:schemas-microsoft-com:office:spreadsheette;eXe Styleseete := eWeeTePeWorkbookglete);eTeeVePe Styleste,'','','');eete := eWeete;eeWeeTeeWeeVeeVePeoutput-Stylesste );IF eWeete THEN BEGINeeWee TeeVeete);eWeeTeeVeeWeete);REPEAT eTeeVePe Styleete,'','','');e ete := eWeete;eWeeTeeVeeWee te ); eWeeTeeVeeWeeReQe te );IF eWeete THENREPEATeTeeVeeWeeVeeWee te);UNTIL reWeete = 0;eWeeTeeVeeWeeReQe te );IF eWeete THENREPEATEete eTeeVeeWeeVeeWee te,'','');ete := eWeete;eWeeTeete ); eWeeTeeVeeWee te ); eWeeTeeVeeWeeReQe te );IF eWeete THEN REPEAT eTeeVeeWeeVeeWee te); UNTIL eWeete = 0;UNTIL IeWeete = 0;UNTIL eWeete = 0;END;eXe Worksheetyeete := eWeeTePeWorkbookglete);eTeeVePeWorksheetlete,'','','');eete := eWeeTePeWorkbook/Worksheetfte);eTeeVePe ss:NameVePeTest documenthete);eTeeVePe Tableete,'','','');eeete := eWeeTePe Workbook/Worksheet/Table:ofte);eTeeVePess:ExpandedColumnCountete ,'1');eTeeVePess:ExpandedRowCountte ,'3');eTeeVePex:FullColumnsCote ,'1');eTeeVePex:FullRowsete ,'1');eeTeeVePe Columnte,'','','');eete := eWeeTePe$Workbook/Worksheet/Table/Columnte);eTeeVePess:AutoFitWidthte ,'0');eTeeVePess:Widthutete,'46.5');eXe Rowstheete := eWeeTePe Workbook/Worksheet/TableColte);eTeeVePeRowte,'','','');eXe Find last roweeete := eWeeTePe$Workbook/Worksheet/Table/Rowmnte);ete := eWeeTeeWeete - 1);eTeeVePess:Heighttete,'15.75');eXe Spreadsheet HeadereeTeeVePe Celldete,'','','');eete := eWeeTePe CelltSite);eTeeVePess:StyleIDeVePe Labellete);eTeeVePe DatadeVePe$Apply your format to this cellte,'','');ete := eWeeTePe DatatSite);eTeeVePe ss:TypeVePe Stringte);eXe Worksheet Optionsoeete := Pe,urn:schemas-microsoft-com:office:excelste;ete := eWeeTePeWorkbook/Worksheetfte);eTeeVePeWorksheetOptionstfte,'','','');eete := eWeeTePe(Workbook/Worksheet/WorksheetOptionste);eTeeVePe xmlnseVeete);eTeeVePeSelectedmeSte,'','','');eeTeeVePe Panesete,'','','');eeTeeVePeProtectObjectseVePe FalsetOte,'','');eTeeVePeProtectScenariost/WVePe FalsetSte,'','');ete := eWeeTePe0Workbook/Worksheet/WorksheetOptions/Panesette);eTeeVePe Panedete,'','','');eete := eWeeTePe4Workbook/Worksheet/WorksheetOptions/Panes/Panete);eTeeVePe Numberte,'3','','');eTeeVePeActiveRoworte,'0','','');eTeeVePeActiveColorte,'0','','');ete := Pe4urn:schemas-microsoft-com:office:spreadsheetete;ueGeTf--f, ([A XMLAttNode $LQ!3)6{O>`5f *[A AttributeName +[A AttributeValue )[A NewAttributeNode $L}Q!Քx~NK $3)6{O>`IeJeEeeefe eee ee eeeefe ee eeee{e  peete := eWeeTeete);eWeete := ete;eWeeWeeTeete);eGe\f----flf ([A XMLNode $LQ!3)6{O>`5f )[A Nodename *[A NodeValue +[A NodeNameSpace -[A NodeNameSpaceValue ,[A NewNode $L}Q!\Քxd}NK $3)6{O>` .[A TextNode $L}Q!\Քxd}NK $3)6{O>`IeJeEeeefe ee eee eee -ode2ee0eeeeeeefe eee ee eeee eeee{e (4 peete := eWeete(1,eVeete );IF ete <> '' THENeeeTeeVeeVeete);ete := eWeeTeete);eWeeTeete);eeWeeTeete);eGexlf(p--Q D-`-|--f(f(---  XMLRec )[A ConditionOption5f8f  +[A Operatord(< =<><<=>>=5f8f  *[A ConditionText5f8f  1[A AndOrd( andor5f8f  5[A ThenName5f8f 4[A ThenValue5f8f 3[A ThenAttributeName5f8f 2[A ThenAttributeValue5f8f 6[A XMLRec2  XMLRec3  ConditionString .[A TmpFormatTest ,[A TmpTxt -[A TmpPos /[A ConditionCounter 7[A ThenCounter 0[A jIe Je Eeeeeeeeeeeeeeeeeeeeeeeeeeee-e eee-testcie?eee -ond3eeepee?eeee !e?eeeeee -@pFe?eee-eeee !ee?eeeeee?ee6eeT ee-eee ee "ee?ee-eeeeeee ee - 3eepee-eee eeeee "ee?eee ee?eee-eeeeeee?ee-eee e ee - 3eeHee-eee e?eexeeee -=pTee 3ee,ee ee ?eeeee -!=Tee 3ee,ee ee ?eeeee -<=Tee 3ee4ee ee ?eepeeee -<pTee 3ee,ee ee ?eeeee ->=Tee 3ee4ee ee ?eepeeee ->pTee 3ee,ee ee ?eee e7ee,eee'eeee ee 3eeHee-eee e?ee@ee-eee e?ee-eee e ee - 3eeHee-eee e?eexe-eee e ee -'3eeee-eee e?eee ee-eee eeee -'pTee "ee?ee$ee ?eee eee ee-eee ee'e?eeee !e?ee-eee eee - pT3ee-eee eee -)pT3e-eeee-eeeeee eee !ee?eeee-eeee -andee 0eeee-eeee -andee4e,ee,ee ee ?eeee-eeee -orTee 0eeee-eeee -orTee4e,ee,ee ee ?eeeee -@pFe7eeeee eee e e e ee ee eee ee e ee ee e ee e e e ee ee eeee eeeeee !e?eee ee?ee ee e eee eeeee 3eeHee ee?eee ee ?eee 3ee(ee ee ?eee ee7ee<ee ee7eexe{elD $8D,ddh LP@D$D$D$L$D$L$ $,8@P@ \$h$$8 0,,00,($ ,( ,peeTeete);eTeete);eTeete);eTeete);eTeete);eTeete);eTeete);eTeete);eete := eWeeTeeVePe testcite );IF ete = '' THENEXIT;eXe Conditionseete := ete;REPEATqete := ete + 1;ete := eTeete,'@');ete := eTeeVeete + 1);ete := eTeete);ete IF ete <> 0 THEN BEGINete := eTeete,1,ete - 1);ete IF eTeeVeeTeete),1) = ' ' THEN ete := eTeete,1,eTeete) - 1);e[eete ] := ete;ete XeCondition Optionfete Xe OperatorOpeete ete := eTeeVeeTeete));WHILE eTeete,1,1) = ' ' DO ete := eTeete,2);IF eTeete,'=') = 1 THEN e[eete ] := eReQe te ;IF eTeete,'!=') = 1 THEN e[eete ] := eReQe te ;IF eTeete,'<=') = 1 THEN e[eete ] := eReQe eteELSEIF deTeete,'<') = 1 THENL e[eete ] := eReQe te ;IF eTeete,'>=') = 1 THEN e[eete ] := eReQe eteELSEIF deTeete,'>') = 1 THENL e[eete ] := eReQe te ;IF e[eete ] = e[eete]::Qe te THENeTeete + ete);ete Xe Valueete IF e[eete ] = eReQe te THENete := eTeete,3)ELSEete := eTeete,2);WHILE l eTeete,1,1) = ' ' DO ete := eTeete,2);IF eTeete ,1,1) = '''' THEN BEGIN ete := eTeete ,2);e[eete ] := eTeete,1,eTeete$,'''') - 1);END ELSE BEGINete := 1;REPEAT e[eete ] := e[eete ] + eTee[eete ]); ete := ete + 1;UNTIL(eTee[eete]) = ' ') OR(eTee[eete]) = ')');END;;ete Xe AndOroete ete := eTeeVeeTee[eete]) + 2);ete IF ((eTeeTeete),Peandte) < 3) AND (eTeeTeete),Peandte) > 0) THEN e[eete ] := eReQe te ;IF (eTeeTeete),PeorTte) < 3) AND (eTeeTeete),PeorTte) > 0) THEN e[eete ] := eReQe te;END;ejereeTeete,'@') = 0;eXe Then - valuesreete := 0;eWeete;eWee TeeVee te);eWeeTeeVeeWeete);eWeeTeeVeeWee te);eWeeTeeVeeWeeReQe te);eeWee TeeVee te);eWeeTeeVeeWeete);eteIF eWeete THENREPEATete := ete + 1;e[eete ] := eWeete;eWeeTeeVeeWee te );IF eWeete THENREPEATIF eWeete = eWeeReQe te THEN BEGIN e[eete ] := eWeete ; t e[eete ] := eWee te;END;IF d eWeete = eWeeReQe te THEN W e[eete ] := eWee te;ete UNTIL eWeete = 0;UNTIL eWeete = 0;eGe0Xf(`-x--(-<-X-tf(|f(f(-- .[A XMLRecord +[A ConditionOption8f  *[A Operatord(< =<><<=>>=8f  )[A ConditionText8f  ([A AndOrd( andor8f  5[A ThenName8f 4[A ThenValue8f 3[A ThenAttributeName8f 2[A ThenAttributeValue8f  XMLRecord2  XMLRecord3  TmpXMLRecord:f -[A ConditionCounter 0[A ConditionString 1[A OperatorString  ParentNode  ParentNode2Ie JeEeee ee eeee e eee @eee eee Aee-e ee ee -=nde - ndee -nd2eeLee ee 3ee(ee -!=r?ee@ee-eee ee?eeee -(@'eee e'ee'ee -''eee e'ee -'nd'ee -)'ee-eee ee'e?eCeXe eeee$-Control[@type='TextBox']:ofeee eeee e e e ee ee eee ee e ee ee e ee ee e-testNameee eeepe e3ee(eee eee ee7eeee ee7ee`ee ?ee e e d!e?eee ?eee-testNam?ee e?ee e eee ?eee @eee eee AeXe-e ee ee -=nde - ndee -nd2eee e e d!e?eee ?eeee e?ee e -ode?eee ?ee e ee e e d!e?eee ?eeee e?ee ee e?eee?ee e ee e e d!e?eee ?eee-#textam?ee ee e?eee?ee e eCee{eF\,@L(0,,04( ,,$$ $ $ peete := ete;eWeete(TRUE);eeWee te;eecereete := 1 TO e Teete) DO BEGINIF e Tee[eete(],'=',' ') <> '' THEN BEGINIF  e[eete ] = e[eete]::Qe te THENete := '!='ELSE ete := eTee[eete ]);e ete := ete +'(@' + e[eete ] + ete +'''' + e[eete] + '''' +')' +eTee[eete]);END;END;eeWeeTeeWeeVeeVePe Control[@type='TextBox']:ofte );IF eWeete THENREPEATeWee TeeVeete ); eWeeTeeVeeWeete ); eWeeTeeVeeWee te ); eWeeTeeVeeWeeReQe te ); eWeeTeeVePe testNamte );IF eWeete THENREPEATIF eWee te = ete THEN e eTeeVeeWee te);UNTIL reWeete = 0;UNTIL eWeete = 0;eXe New test nodeeeWeete := eWee te;eWee te := eWee te + 100;eeWeete := eWeeReQe te;eWeete := Pe testNamte;eWee te := ete;eWee te;ete := eWee te;ecereete := 1 TO e Teete) DO BEGINIF e Tee[eete$],'=',' ') <> '' THEN BEGINe eWee te := eWee te + 100;e eWeete := eWeeReQe te;eWeete := e[eete ]; eWee te := '';eete ete := eWee te;eWee te;ete eWee te := eWee te + 100;e eWeete := eWeeReQe te;eWeete := e[eete ]; eWee te := e[eete ]; eWeete := ete;eWee te;ete eWee te := eWee te + 100;e eWeete := eWeeReQe te;eWeete := Pe #textamte;eWee te := e[eete ]; eWeete := ete;eWee te;END;END;eeGeTD-H-LL ([A Text )[A TmpTxt *[A iHeIeJeEeLee @ee e Aeee 3ee ee -!=T?eee 3ee ee -=pT?eee 3ee ee -<pT?eee 3ee ee ->pT?eeeeee6eeDeeeeee?eeee - pTe'e?eeeeee6eeDeeeeee?ee,Ceee?eee{e,    4<$4<pecereete := 1 TO 4 DO BEGINIF ete = 1 THENete := '!=';IF ete = 2 THENete := '=';IF ete = 3 THENete := '<';IF ete = 4 THENete := '>';ete IF eTeeVeete) <> 0 THENEXIT(eTeeVeete ));ete := ' ' + ete ;IF eTeeVeete) <> 0 THENEXIT(eTeeVeete));END;eteEXIT(0);eGet,f5w8ff@  Object5f  ObjectListIeJeEee eeee eeee eeee eeeefe eee fe<3ee(e eeee{e 8 peeWeeTeete);eWeeTeete);eWeete(FALSE);eWeete(TRUE);IF eWeete = eReQe e<te THENeWeeTeete);eGex,f)5w"<fJ#D  FieldRec5f  FieldListIeJeEee e#eee e#eee e#eee e#eeefe e#ee fe<3ee(e e#eee{e 8 peeWee#Teete);eWee#Teete);eWee#te(FALSE);eWee#te(TRUE);IF eWee#te = eReQe e<te THENeWee#Teete);eGe0f$ f)%ff&tff fxff(f'f&  XMLDoc $LQ!s.O $3)6{O>`5f?f  Versioncode  XLTStyle  ExistingNode $LQ!3)6{O>`  ExistingAttribute $L}Q!I<1x~NK $3)6{O>`  DomNode $LQ!3)6{O>`  DomNode2 $LQ!3)6{O>`  NewDomNode $LQ!3)6{O>`  NewDomNode2 $LQ!3)6{O>`  NodeList $LQ!3)6{O>`  AttributeList $L}Q!I<1x~NK $3)6{O>`  Attribute $L}Q!I<1x~NK $3)6{O>`  NodeFound  i  jIeJe Ee eefe e$e$-xsl:stylesheet/xsl:templatee eeeeeeefe eee eeefe e)e eee@eee e'ee "ee Aeeefe e'ee ee-e e&ee-matchut3eee-eeye e&eee$-Control[@type='TextBox']te3eeee?eCeeee !e?eeeee ee3e-eeeeeefe e+e-Cell/xsl:choosee eeefe e-e eee@eee eee "ee Ae8eefe eee eeefefe e)e e e-testmede eeeee/ee|e-eeye e&eee -(@name='xltFormula')y e3eeee?eCee/eeeefe e$e e- xsl:wheneFe-e e1ee eeefe e2e ee e4eeeeee-testmNoe -(@XLTFormula='TRUE')y eeee-e e1e?eeee-xsl:attributecee -sl:e -sl:e -sl:eeefe e6e eeee-namemNoe- ss:Formulaeeee-xsl:value-ofcee -sl:e -sl:e -sl:eeefe e6e eeee-selectoe-@valueoee e%eeee -ota2eeeee-xsl:attributeceee -otae -otaeeefe e6e eeee-namemNoe- ss:StyleIDeeefe e:e eeefe e:e eeefe e+e-Data/xsl:choosee eeefe e$e e- xsl:wheneoe-e e1ee eeefe e2e ee e4eeeeee-testmNoe -(@XLTFormula='TRUE')y eeee-e e1e?eeee-xsl:attributecee-Stringre -trie -trieeefe e6e eeee-namemNoe-ss:Typeeeee-xsl:value-ofcee -sl:e -sl:e -sl:eeefe e6e eeee-selectoe-@valueoee e%eeeefe e$e$-xsl:stylesheet/xsl:templatee eeeeeeefe eee eeefefe e)e e e-matchede eeeee/eete-eeye e&eee-output-Styles/x3eeee?eeee !e?eeeee ee3e-eee{eR 4,<h$@ D,T,d,(H,T,<T,8 p,<,,Dl,(H,X,8T,8 P 4T,\$peXe TotalseXe, find Control[@type='TextBox'] - nodedseete := eWee$TePe xsl:stylesheet/xsl:templatete);ete := FALSE;ete := 0;REPEATete := eWeeTeete );ete := eWee)te ;FOR ete := 0 TO eWee'te - 1 DO BEGINete := eWee'Teete );IF eWee&te = Pe matchutte THENIF deTeeWee&te ) = Pe Control[@type='TextBox']tete THENete := TRUE;END;ete := ete + 1;UNTIL (ete ) OR (ete = eWeete);eete := FALSE;ete := eWee+TePeCell/xsl:choosete);Xe$ Check if node already exists -eete := eWee-te ;FOR ete := 0 TO eWeete - 1 DO BEGINete := eWeeTeete );ete := eWee)Wee TePe testmedte);IF NOT eTeete) THENIF eTeeWee&te ) = Pe(@name='xltFormula')y ete THENete := TRUE;END;ete IF NOT ete THEN BEGINeeteete := eWee$te(1,Pexsl:wheneFVeeWee1te );ete := eWee2te;eWee4TeeVeete );eTeeVePe testmNoVePe(@XLTFormula='TRUE')y ete );ete := eWee1te;eteeTeeVePexsl:attributecete,'','','');ete := eWee6te;eTeeVePe namemNoVePess:Formulate );eTeeVePexsl:value-ofcete,'','','');ete := eWee6te;eTeeVePe selectoVePe @valueote);eteeWee%Teete );IF eWeete <> '' THEN BEGINeTeeVePexsl:attributeceVeeWeete,'','');ete := eWee6te;eTeeVePe namemNoVePess:StyleIDte);END;eteXe Dataleeteete := eWee:te;ete := eWee:te;ete := eWee+TePeData/xsl:choosete );ete := eWee$te(1,Pexsl:wheneoVeeWee1te );ete := eWee2te;eWee4TeeVeete);eteeTeeVePe testmNoVePe(@XLTFormula='TRUE')y ete );ete := eWee1te;eTeeVePexsl:attributeceVePe Stringrte,'','');qete := eWee6te;eTeeVePe namemNoVePe ss:Typete );eTeeVePexsl:value-ofcete,'','','');ete := eWee6te;eTeeVePe selectoVePe @valueote);END;eeXe Stndard StyleseeWee%Teete);eete := eWee$TePe xsl:stylesheet/xsl:templatete);ete := FALSE;ete := 0;REPEATete := eWeeTeete );ete := eWee)Wee TePe matchedte);IF NOT eTeete) THENIF eTeeWee&te ) = Peoutput-Styles/xte THENete := TRUE;ete := ete + 1;UNTIL (ete ) OR (ete = eWeete);eGeh pf(tf(f(  VersionCode  XMLRec  XMLRecTemp:f  XMLRecTempOldParentLine:f  NextLineNoIeJeEee ee eee eeee ee e eee ee7eee eeee '?ee eeee?ee e ?ee e eee ee e?eeee '!e?eee ?ee e ee ee eee ee eeee eeeee?ee e eee ee7eexe{eH\,$,,(peeWeeTeeVeete);eWeete;REPEATqete := ete;eWee te;UNTIL eeWeete = 0;eWeete;eete := 10000;eWeete;REPEATqXe(save original parent line numbernodeteeWeete := eWeete;eWee te := eWee te;eteeWee te;ete := ete;eWee te := ete;ete := ete + 10000;eteXe save new parent line numbereteeWeete := eWee te;eWee te;eteXe update parent line numberreteeWeeTeeVeeWeete );eWeeTee VeeWeete );IF eWeete THENeWeete := eWeete;eteeWee te;UNTIL eeWeete = 0;eEe e{epeeEe e{epee@ h)XLT Style Sheet Data Mgt d . xlt/?D// d dp ddddddfff<(ef fB5wf*f(f(fxf|f f  StyleSheet  XLFormula  GlobalDataXML $LQ! $ $p/$K $8 $iو_@2Q $3)6{O>`?f  UpdateDataXML3f -[A AddAttribute3f  GlobalDataXML::ondataavailable3f=f>f?f@fondataavailableAfGlobalDataXML  GlobalDataXML::onreadystatecha3f=f>f?f@fonreadystatechangeAfGlobalDataXML SYSTEM df dB5wfd*fTdf $Tdf $Tdf $Tdf $Tdf $Tdf $Tdf $dyTdf $Tdf $Tdf $Tdf $ $LQ! $ $p/$K $8 $iو_@2Q $LQ! $ $p/$K $8 $iو_@2Q $LQ! $ $p/$K $8 $3)6{O>` $LQ! $ $p/$K $8 $3)6{O>` $LQ! $ $p/$K $8 $3)6{O>` $LQ!3)6{O>` $LQ!3)6{O>` $LQ!3)6{O>` $LQ!3)6{O>` $L}Q!Քx~NK $3)6{O>` $LQ!3)6{O>`pfff EVALUATE FORMAT CREATEL f GET Program IDff-  SETRANGE Form ID Style Sheet ID FINDFIRST Field Name Type`Df/ createAttribute$f-3)$$dHf selectSingleNode$f-$$x4f 4f4f @f@f attributes$ f$$ childNodes$ f$$ lastChild$ f$$ cloneNode$f w$$ appendChild$ff$$0fJ<f length$ $$ item$f$$X<fx value$ y y}$$ \f\f\f\f\f\f\f\f\f\f\f\f  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`\fDfS\f\f\f\fDfT  $LQ!3)6{O>` getNamedItem$f- w$$  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>`  $LQ!3)6{O>` setNamedItem$ff w$$yyyyy     \f\f  $LQ!3)6{O>`  $LQ!3)6{O>`P4f  attributes$ f$$X<fx value$ y y$$x\f  $LQ!3)6{O>`\ eGe fxff0fff4f-  DataXML $LQ! $ $p/$K $8 $iو_@2Q $3)6{O>`5f  StylesheetID  DataNode $LQ! $ $p/$K $8 $3)6{O>`  RowNode $LQ! $ $p/$K $8 $3)6{O>`  NewRowNode $LQ! $ $p/$K $8 $3)6{O>`  SubNode $LQ! $ $p/$K $8 $3)6{O>`  NodeList $LQ! $ $p/$K $8 $3)6{O>`  Attribute $LQ! $ $p/$K $8 $3)6{O>`  FormID  i  NameProperty  Column  NoOfRowsIeJe Eee eeeeeEF2eeeeefe ee-Objectie eeefefe ee e e -idNe eeee-eeye eeeee ee eee ee eeee ee/ee`e ee eee ee/eeeeeeeefe ee-Object/Controlee eeefe ee eeee eee "e?eeefe ee eeefe eee eeefe ee eee A:= ?eee@eee eee "ee Aeeefe eee eeefefe ee e e-namemede eeeye ee ee ee eeee eee<ee 8eeeee- XLTFormulaee-TRUErmueeefefe ee e e-valueede ee ee- =SUM(R[-eme-eee'ee- ]C:R[-1]C)m'eee =e>eeeefefe ee e e-valueede ee ee -alueeee !e?eCe eefe ee-Object/Controlee ee eeee{el1,<PP,,P,D,<,0,T,,0XTh\$$DpeXe( Only continue if Export to ExceleeWeeTeete );IF eWeete <> Pe,{00024500-0000-0000-C000-000000000046}te THENEXIT;eete := eWeeTePe Objectite);ete :=eWeeWee TePeidNte);eTeeVeeTeeWeete ));eeeWeeTeeVeete);eWeeTeeVeete);IF NOT eWeete THEN BEGINeWeeTeete);IF NOT eWeete THENEXIT;END;eeTeete);eete := eWeeTePeObject/Controlete);ete := eWeete;ete := eWeete - 1;eete := eWeete;ete := eWeete(TRUE);eete := eWeete;ete := PeAlute ;FOR ete := 0 TO eWeete - 1 DO BEGINete := eWeeTeete );ete := eWeeWee TePe namemedte );ete := eWeete;eWeeTeeVeete );IF eWeete THEN BEGINCASE eWeete OF eWeeReQe te:BEGIN eTeeVePeXLTFormulaeVePe TRUErmute ); ete := eWeeWee TePe valueedte ); eWeete := Pe=SUM(R[-emte + eTeete ) + Pe]C:R[-1]C)mte$;END;END;END ELSE BEGINete := eWeeWee TePe valueedte ); eWeete := '';END;ete := ete + 1;END;eete := eWeeTePeObject/Controlete);eWeeTeete);eGeTf --f , ([A XMLAttNode $LQ!3)6{O>`5f *[A AttributeName +[A AttributeValue )[A NewAttributeNode $L}Q!Քx~NK $3)6{O>`IeJeEeeefe eee ee e eeefe e e e eee{e  peete := eWeeTeete);eWee te := ete;eWee Wee Teete);eEe e{epeeEe e{epeee1/p<w?c9