How-To C# for /COM (exlist)

562	ADOR, MDB (JET) axList1.BeginUpdate(); axList1.ColumnAutoResize = false; // Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project. ADODB.Recordset rs = new ADODB.Recordset(); rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExList\\Sample\\Access\\sample.mdb",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0); axList1.DataSource = (rs as ADODB.Recordset); axList1.EndUpdate();
561	Highlight the match once the filter is applied // FilterChange event - Occurs when filter was changed. private void axList1_FilterChange(object sender, EventArgs e) { object format = axList1.FormatABC("`lower(value) replace lower('` + value + `') with '<bgcolor 000000><fgcolor FFFFFF>` + value + `</fgcolor></bgcolor>'`",axList1.FilterBarPromptPattern,null,null); axList1.Columns[0].FormatColumn = format.ToString(); axList1.Columns[1].FormatColumn = format.ToString(); axList1.Columns[2].FormatColumn = format.ToString(); } //this.axList1.FilterChange += new EventHandler(this.axList1_FilterChange); axList1.BeginUpdate(); axList1.SelBackColor = axList1.BackColor; axList1.SelForeColor = axList1.ForeColor; axList1.ColumnAutoResize = true; axList1.ContinueColumnScroll = false; axList1.MarkSearchColumn = false; axList1.SearchColumnIndex = 1; axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; axList1.HeaderHeight = 23; axList1.BackColorLevelHeader = axList1.BackColor; axList1.FilterBarCaption = "`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCompact \| EXLISTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.FilterBarBackColor = axList1.BackColor; axList1.FilterBarPromptPattern = "and"; EXLISTLib.Columns var_Columns = axList1.Columns; EXLISTLib.Column var_Column = (var_Columns.Add("Name") as EXLISTLib.Column); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column.FormatColumn = "lower(value)"; EXLISTLib.Column var_Column1 = (var_Columns.Add("Title") as EXLISTLib.Column); var_Column1.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column1.FormatColumn = "lower(value)"; EXLISTLib.Column var_Column2 = (var_Columns.Add("City") as EXLISTLib.Column); var_Column2.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column2.FormatColumn = "lower(value)"; EXLISTLib.Items var_Items = axList1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); axList1.EndUpdate();
560	Re-order the cell's caption, icons and images/pictures axList1.BeginUpdate(); axList1.ColumnAutoResize = true; axList1.Images("gBJJgBAICAADAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEahkZAIAEEbjMjlErlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrlTiFdib/sNjr9gs1nldlrlqtFtt0stlguNvulyh91ud1vVVvNuvt7wFHr9/vl3luEwOJouIq+Dw2KyGRyWTymVy2XzGZzUuiw+lmej0gkUaksljaAnmD" + "cD/cEbf7w1+ufD/fEbeB028bYAO3enB6AB++4EoA4A4sb4vHjXJ4nG5vKAHA4ca6XBjTAD/Y2x/eB/jcB"); EXLISTLib.Column var_Column = (axList1.Columns.Add("ToLeft") as EXLISTLib.Column); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); EXLISTLib.Column var_Column1 = (axList1.Columns.Add("ToRight") as EXLISTLib.Column); var_Column1.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column1.set_Def(EXLISTLib.DefColumnEnum.exCellDrawPartsOrder,"caption,picture,icons,icon,check"); axList1.DefaultItemHeight = 32; axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exVLines; axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; EXLISTLib.Items var_Items = axList1.Items; int h = var_Items.Add("Caption"); var_Items.set_CellImage(h,0,2); var_Items.set_CellImages(h,0,"1,2"); var_Items.set_CellPicture(h,0,(axList1.ExecuteTemplate("loadpicture(`gCJKBOI4NBQaBQAhQNJJIIhShQAEEREAIA0ROZ6PT0hQKYZpIZDKBJkIgKByN5mNJsMsKPABVqXBI4KjrD7HL6GWKPJKiCIhMiySidKxbOzZZJWMLs" + "GL2FqyLjZMonNa2CyiZDOUqsQqUEq0ZCNISFXDIFxzZ4hUrbdrefZ/fz3ZgzZ75Tz3XjvHZnZznPieb55AKgAqmRyOOzEhR7XirWaWQQMTa+QIhDbZOZAAoYUCPDAQG7" + "FXI4JRrNCoIRdPyyFr0AYifDUKZ+PCufK4RReALLUbtdBHSrGTCCNKqT4MbRqUxxQx+CAAEQ2VCBbxqGaLYDZNgzFbCbLDarRCrqMYMM6cWqpHKUDqhZjnVijEoLcp0F" + "CjVg2OYhTjN/QWk4bo4iseBsAcABIDoPA5g2HgADIkQfDCNxwkEQYnFmAIAB4OJHGcKAPioGRKFKdh2g6UB8iiZ5QkYQp3gKWhDlsWYmAARBcgCIAUniVpmiSA5AF3A4" + "wG8P41nGWwDDAW4MAAIpSG+bRzBoGx3AeCJhh6C4ljCUJGnSRBUFKAIQA6EgIHMWBoHqYgAngHJDCALBmhCCAfHOARAScUBvAmc5zHYXxoguXQ8DEMIAH8dI8HmP4/Ay" + "QJAEAYAoHqRByEQGJiECBAzAkKIpBYNIcikAp8kcZhDn4EBChmUoMgqHIqhiWoIgaDImgyVQImaRw/F0EZGCcSw3DaM4Kn6GBBhwYYZDGZo3C+RgOAmNQnhYeYqgsTZe" + "nEVgSFYLo2CydhGg4OROF2HJjlydR7i+cJjDGFo8BgHgVl4Po+DufJRgcbQOlkCxyKuCJNAsdwIhSC4mgieYKkeHJWD0Ih8BQaYYkkMYppwTg0EsFhJC0SxEkgeodDSF" + "pTheV5SDgLBIieRIigyVo5CeOpymoWhtEQfRACMR4zE2KxRnsV5dF2ehFCeC50G+GBkBiZgaCUGYnBySY+BsdIuEkJJJDSSRsjGeYqEWOhliYVYOHWDYbFuNhFmcS5si" + "qbZrnGLYOh0DpPhyXo7D8d4ZHGXR1CcdRAnsMh7GELwIHiSx7CiXY0HYNZ1nOcoPg0SB+CWLwwGqUpbFAQJwEeEImlCVQwk4cJxAiFRIhMS4ulGYRRlmMQVDEHZxG8Yx" + "XhIaQSniLhIiaGwnDiJZGicZYnjeZw8D6OoSkWEIthwI4emudwtGwepNhuLQ3F8Zojm4bQrhALo0D0HZwCcJwoimeI0ASWR6CAJkJQORfAiFcLIXgahaiGCgMsKIpw8D" + "PH8H4Pj2BhjrBMGQGYfxFjuEGIsB4rxbg+DSFsPAxBtChHoAQaYmRojVG0D0e6JALjVD2K0F4qxfjjGyPIRY/QXi1AOAILwFQGgOF8KYDwOgdBsHmCYcobRtjIHoGgZA" + "mBgi7HgPcWoHxTAmCQCcVwTgDB+FYJgfQMAOj0F2PoZgkRMjeKQLkWATwdDzEkPMF4FxzAXDGJYfAlgPAuB+FkeIWxuizC0LkUwvQbD9ByHIDouxvBCBgCMCAvh4CXCM" + "EgSA0BJDEH+AsfwMgfjhDeL0Ro/xkgvH4JMXA7RYjyAONgPAWhfjyCuBEcAFRSAWE4BIOwEAUgTCaIYfA4wSBUAcAsDowQOBFA4J0Hg9h2B4EmCQTYVBdB0FwIwU4rBy" + "jJGmHIRQ8gJAKB4IoZgShaDKAQOUIolQkjVBuGoSw6hugaFaJoeoWgajaDKDoO4dB5j0FcJ0Zw1Ang3CQDEdgNQnA6EmHgGw4QuCiCSAKFIXBgilEwGcLAZAtDmC0N0W" + "gLhaApFiK0HgfxniuGKP4GIvhrhhGgHEZgaRtB5GSBUcIhg5BnHkOAeQFB5A6DiEEao2xoDHH0KIQ4bxYBfFEP8RogB5BfA8AQHwvwqAZBIBURgCgwgPAqAkKYCgfgTH" + "CBwDIegcgjFUDQXQPQzA4DsCkDwnRABNAwE8OgTw5C6AkJEPgPRSg+DqCANoMRBjuHUKEJglQWDrHYOATg3BuDGDWEMa4CQbj3HMB0Z4Pw5jLFuCAWYsB/D2DgBEUQmB" + "1iuDEMkfI0hUCyEkPIfwihKgqGsGobIGhNhfFGGoZY6gDDuGWDceANA1A2DyDUM4txaA/EwG0bo0wTDXEcH8Sg/BcD2GSHQC4pgtiuGOOkNIRg3hbG+MIGYjhzgaBeHw" + "L4FgHAMAYFIfgJh4nJBQGkfAwRNiFAiO4KIlhoiKFiOoO4EwPiYGONUE4RATg6BOMcUwEApgZGmP4X4lxnjYGaLIZg7RNirH6FQG47xZCAC6OQLK5B1BYF8LgOQZAqh0" + "FqGcBo/xMhpE6HsXomQwBKCwIcfA6w/DxA+IURAIxwgmBSCMKoJgOhFD0JMeIkQdhREwFAEQKRFioAYKkJIqQlhpBYFEPYUQui0GCGgFI9BlCOAUDoS4nRhA7HOOkFYd" + "guhgEgGYUgZB2DeE6IIYIMQEgyAiPYHgYgnBlFiNsPYghKiODqISfddhPgVEOCQE4hg5iWHWPEfwfB3BgFYPkAIWQPAOC8BIb1MwrD+QsNEQ43ACAMAKGUQgsBhBoHCG" + "USNrxBBoEqNgGo8QMAJF+MMOwRxGCOFUBwHYdhODvDwMEBILgk21AKKkOI6RrgyD6LIDoJxNjkDUOQF4yAXgoC4FMXgqhKCiE4KACQow9D5CoJgLQiA9CwEMLUYwOxmh" + "AFaEAdoSwdBBF0CEPQEWWDrGOBoEgGhTAaDyBsPoNgXA4CmHIWw+guCDCSJsNIjxsgADcNQPg2hxC2FKLACo2hNDFEMMcKw/BeCcE6LYXoGRvDJGCN8GIxgUjYAyOUbg" + "6BpDrB0OYWw5AgjtGSOoEofAgjRG2NgY4+RRCfBeKUN4qQvi7H+HAYAchwCOCWAcQQZBBFiG4EIUYww3CFFuEQSgRAlBdDMIwCQiRrCMGCMcIwxhuiKDeE0PAlxCC8GF" + "ZQS4YhIgaEkJYS43hLAxE8EkTodQUBbBWMcHoNxy0lHqOETYyAeDeD4I0AQlRhD0G2E0O4PgKCjHeEoSgmBKCGEsBUS4vxUA8C6M0K4ox7irD+O0VouhfD7FUA33I+gm" + "iXE0IsLY1gtipG0CQbQLQPjFDuDQHw2RtjFGsK0bw4x9j0CcO8N4/RtBnhSgvAcBehmAOh0ANgiAhAnhih8gwh1gbhugRhSBRhDhjh2Bvgyhfh3gPhThOBIBOA6B9gsA" + "YAah+BdhlBWBtAuBoBThtB8gnhFheAlhcByh6BKhvAahNBnh5B1gJB1g+hCAsgAAbB1gOguAJhIAoAmhFBvqzACABh0BlgFggA6CaBvBQA7BDEHAaA0AABoAcgGBEACg" + "5AAgYgZgLAIBKgFBBhWh9AggCAIBoBNgAANA9AJhwABBxBwAKAYAAALCJu9ADAYAFBLExBEAiBEgmBEgxBEANBENbhmgJh5gJBNgJgzgJBfgRAvAhpKhnAQg5AIpkARA" + "SA/ASKGAPBJhZBIAdBJAbARh7n4BIhshkAnAZDVgkBZAUg5AWh5AVB5AEgFAbBFA4BFACglA5hlAfAVAChVAtBVAig1AQh1ABBNB+gaAcgUA7AqAbAWgTg2gfB2gSB9A" + "IBdA1BDh2BHAnBdAZg6Apgdh+h0g7lCBoAXh3BJBugahkBwBihkBkAsBYgtg/h7gNATBNgkhIgUhBg0gzI6BZgJRJglhvAvARgrAtBrALBbBFh2BxB2BZh9hFAcgOAcA" + "dAcgCgcBzhcAVB7h9g5BlgxhohsArgDh5A8heA8BKh8hMB8gzB8APgPBmAdByAShQAVgUAWMMAaAThuATgpAWhNASgLARB3ASAwg+AsEwhiAoimBTBxhUAJhEAJhVhJB" + "PhSBTBSBjgyhvBPlWAbgUgfhRhYBUAkAoBTAoBQgrgygfyhgTBShXBSgwhUh0hWgKhTguhQBphRAdhWAjhoBvg1gQA0g0A1AKACAehLgegzgrgmhcAmBahmB+A4AihzA" + "hhLA6ArAFBrAfAbAyhbAPh2hYB7BzB8AOBDgwhTg+hnALAXB8hXBph3AxAPA/BPA2gLg7A8hxg+AlAXANB9ARB+A6B+h5gBgEBAg9BLhFBBAUghAWAhANhhhsgRgBARB" + "vgjAUgiALhjBpBig8hjhHgSA1ASBqgvA4gkhzAmgkglhRgnB7hlh8BKA0hNgxhMBtg7guh5gjAzhPAtB/BJgBBmhhBvAdhDAighg7g2glAzBlg+AVhUAVAphVAHhqURA" + "Ghvh7g0AgAahvA2FigMg2BhhaBrg6AMAegTA6AVi5B6BlgehNgMgoA9gigMAZA/hBgMgGg+hfgbAvAegSgbApgegXhZhqBagzBYgogfgwB/Cwg7hgh/hDA/gTg5B+gNh" + "/gXh6B8hbh8B/hEhfASg2h/BHh6BfhZBbhuAjB/g9h7BbBth0h/gbh2Ayh/hAh+h/gnh/Ajh3AwgnA/gigPBzBPBVBegigfA1h8BPhshr1HgNhvAxB/hoBdgGgBhZh3s" + "UhMh0gmh1hLg9hIgchQB7BthugQh5hbgugth6BTgLi/ALBkocoPgCA/BQBfhmh+hXhzA/hzh+g7B1hbgch/heh4gvhEg3hsBfBOgbA2B9ArhrANhPTSKXAMg7A+Bhh4A" + "fgZh/AVhdg/hzB7BTBsgfh5B+gdhZh/g7oQBogSh/BMrPhUhYBshvheBfA9AThph7ANhvhNgog/hZBNg/hdhvgIAxhjB2hHBhhOBtg1gPBCg3hZBDAmhDg0gfhNhAg8x" + "MhgBiBvkig7BGgKBHBDBfBJhDBWhPg6BPxKAvBOBUhPB5hMhLhAh0mXBXAFhhB/A3hXBIhwB9AAgUBKg4AHA8AMgdgDhuB8hGghhcACgUAAgOA4AAA8AQABh2BQAegHA" + "2BOB9BYhxhrBAA/hfg7hah4BCBrAxgABkAdAcK4BtgsAshdhZCSAVglgFgbASgeB3AQAPhNhIFJ2TBnhahchDBBh9gQBogABSAlhhBUgbBLANBvA+hbh+gAgWBzB5BXB" + "WhFh/knAAADgLAkgiAggqAsAEhigrA1g2AKAqgKBfAZgdh9g2BbhugjhUgCgtgBALAtAYy+AWhEgmgAhFgSAaT4gAASgaATAahIgxACB9ghhGgfgmBoAEB4gIg/ANBag" + "xAkhGBRA0gs3yBaBjTNAFBCBFBghCACAJAlhFh+AAAEgCAQgQg+h2g7Bbhdgdgdhdhxh7gGvUhbBHhah/B5ATAzh3BOtAWchuh3hOA9h3XvAfgbh0hfh8Brg6hegDB9B" + "tnWDQByA4gkAGJIAZAEgcgFh8gvBJBSAdh0BLhqBLACAABHBtgwB2x8yngsg+gAByA2gAB8hxhvh6Byg+AFBp4nBShMgmBzANgAB8ACBZADARBLPVhQh7uKBOg/B7hqB" + "UgphbA+AfALAygQYohXBZi2AThYhcAeBPhAuwhdgIBEgiB7B9YzhDA0AvAthIBAg8AeBfApAohKA/B2BRA+BYm/gGBCguAG5JhAhjZLAgAvgvhPg1gYgehmAbgLZQhDA" + "jAjgjgOh5heAxzgABhx5Wgig0AfgQA/B13iBgBchVgrhXgVXFhbh9gKBdgugUAbXDgygsg+A/B+B8AqA6g6hahbBsANBmA/hCgmhegeSVgeADBwB+BKg+BnA0hwBxBih" + "Fh7BxBxAxAIgGACAiAYAMAKA/BPgnguAMgPBbBngak8B+hsgqAVBag2hnBOAoBWAJhYgsA2AchvAHhIEMAmgmAmAkAjhHgPB6hUBkhSAqApgpjehsBcgZhAhuAYBOBdA" + "uAXAwgpgPBMBwAOB5AjB+AeAYBwANACghgnBTgph3h0B0BMB4h91BgMAJhxAmgSByhshbajBaWPgTgCAYA4ACWGg3g/AyBfgzhnhPBxA1hrhXBshehChChRBQBQAgAeA" + "FBNAtg7h3hHB7h7B7A9BOgHBDgggfhrBEBHA+h9gRB+68hPAfg3huAoAzbAAiAGBZA7B2htAqB7hYgxgwhVgehOVIFFBRgchLhhgAA7BfBthdB9hkhkgkg0hyBlAKhBg" + "3ABAgAZBEg4AcBWAGYIhzgXAEgDA6gmhphwAtgRBYBmBwBwBQAThBA3gvBXn3hrBDBuBcA/BugnANgEBLhKhCgzhwYzhAAiARAohGgHgggJgMg9gMBrA4g+A6BoAUhch" + "ug3BBgAhZAIBPBNApAFAFAFh6hZBZAZAWhMgkAkBEgyApb1BOAqBGBIBmATAShAhsgOgHBuhxh4gsBOhph2ArAfBmBLCWgigxgOhZhshtAMBrghhDgHgjgfrIB5ABBCB" + "QAcAgV4gPhcgIBWhVhXgnhBApA4hVBXhngFhTLMgcgOhRgtAMh+hFh2h2gohnAsgshCg+rTAGgNhcgjgvwhAsA0BOA8gV4dBN8qBJh68rgUgoB2BdA6h5hTABhMgWAxh" + "Tg9A2guguhJBDB0g4B5hzBmsvhwgwgzgog4g4gDAmAygPBUhWAqANgbg3AmBAI2AOBzhDA8hmBKgxBIAFgAAJhbCuhGgKl7BwhwAmgcAKAigDh2gZAJArABANgDBegx5" + "WgZADgwBGBEAkBegAg2AYg9gwKABtBmhPABBoBZAPgFhHBMAPhmB/B6bdhZhdhdhth1hh8lBGgIBEAUgOhEgKgVgrA0AngaAaBiBIgyB5A3gLgXBcAEhlJjAJgEAsAJA" + "kgqqlhththThrhrhrBVBTAWhZhDhPhThIBWARg+Bn7Sg7A3gDhZAvAphEgegGgehuhpAJAyAJBZQ9gBggAAgAgwBDg3BCAAhkgTh0hkAAhLhthWhTgqAqhJBIAhhmAEg" + "qgqgCgbBiB6h9BD8zhxhmABrOhfAqhMg7ghwiA4BSJNhMgqg4BEhkY8AjBphNATBaA6AtAwBYgEACBBiEBABIAggbg7gmh1AlglAlgahXBmhmB1BgBPBEAmAnwZgogyh" + "VgmgABcgxsNBUAWAAB2B4AHBvA5h3B3ggAQBIAwg+hPhSgqBQCEA/gQBQA2htKUgfAJhFgkhkAYBtAIAMHpgbAasHg0gVAsBhhIgbBVAxAi/MgFBnAZBDBpB2ABgwADB" + "Wh3gchuBwBxhrhkB1BbhWAFAP5mBCghgTgnA8AgBV+OgqhSg2g1g3AnBOAcg+hNAYgbhHBRg8g6BjhjhjA2ADgdAdhTg/Aeg/hvA6h1h7A2gChLhKfjAdAxhahigYgMA" + "GAshzg5AAaYh/AGAjh2AChABwBOgwXnBFh/ApAzgT2GBZBGvTBHAjBGhAF0wAgsDi1w4Nza2UkyBUYiA+maxm6g1K32ad3s2Qg8AKlRaBlKD1wKE+rCCjSObAK8iGsFO" + "rC0vR0lTeDV8IUatHu6GO2jkAHgAwgfgC5TYrVsKk2Y3MBRcpBQkgmOUuznY2FqKy0WSymXeX0ASwel0olHI5AwJ1mx0gL1mTXU6XS8Vpdj4hyg8BemDYZHqMFOUyYZT" + "WP1WJ1CN1MTR6gH4cmysjKr2mlCqn3GuR+jDoJHGWlKkU+ajXpgg1yq2FQDFigSEBROwkCKnQwGwjliIU45x2HGyIB4dnM0UmUC+PhaLxefwOdia5zMT3+8wwYCQmEwd" + "i4vQKqHKvigKHoKnc9Rs7GMDUOhhGOnAYjWkzKKRGyxsDUA01QCw0QCOF0uh0OkfRUMMbyRNwTBiCYZwKMIYyZAUkSlBYkxsCYAAHG4qwCBwMQfBYlxsNgsDhLEgwHA8" + "PiPNg1ygP4uywIgMSwK4zSQG46BnFAATDJcL3IHM6DQBsPR3O83j/AsJyGH8w4ZJY5TsN8EAdFojTwJ0AAoA4MgATIMDqAcrQPMEwTDBgVy0LYtiuK8qyrFs6QtCocnL" + "Cs8wAGAChOGM+CZJ0HAaoQHQYocBiaHtJT3LEfgCLYIgQNYgw4IQiSaBcAABBEAB/DAXS4HgPAgLUSCzGkPjkIATyXPQoCeNYfR6Do7QGI8Zj+CAHiyCY2SkIQTSSCIy" + "DQCkpDBJQJinMMuAUPgOxGOcpA/AkoTzJwyiYFMiDwJEsShFAURFCwJRVFceQXKQIS8P8STlBgLggAcrAQCQATjIgZA0JgVSxL0OAmKI6CpEc4SuOkeBeOwMRnLQuQhO" + "ApDJAImYmD44BPIgAzFMYiR3LcQw4JwqhQAknAMFAxwEEwJwUO4ljCHgmxzNwNQ3EU3ScLYEAACocDePwZgCLI+yFN8jg7FEQTtKMcwrAAOhgHw6SQI4OCmJgjDmNAjj" + "5Gw+wbHkkTpEw7gpFgIAA2sABJEUThEK4QhgIJAQ==`)") as Object)); var_Items.set_Caption(h,1,var_Items.get_Caption(h,0)); var_Items.set_CellHAlignment(h,1,EXLISTLib.AlignmentEnum.RightAlignment); var_Items.set_CellImage(h,1,var_Items.get_CellImage(h,0)); var_Items.set_CellImages(h,1,"2,1"); var_Items.set_CellPicture(h,1,(var_Items.get_CellPicture(h,0) as Object)); h = var_Items.Add("<b>HTML</b> <off 4>Caption"); var_Items.set_CaptionFormat(h,0,EXLISTLib.CaptionFormatEnum.exHTML); var_Items.set_CellImage(h,0,2); var_Items.set_CellImages(h,0,"1,2"); var_Items.set_CellPicture(h,0,(axList1.ExecuteTemplate("loadpicture(`gCJKBOI4NBQaBQAhQNJJIIhShQAEEREAIA0ROZ6PT0hQKYZpIZDKBJkIgKByN5mNJsMsKPABVqXBI4KjrD7HL6GWKPJKiCIhMiySidKxbOzZZJWMLs" + "GL2FqyLjZMonNa2CyiZDOUqsQqUEq0ZCNISFXDIFxzZ4hUrbdrefZ/fz3ZgzZ75Tz3XjvHZnZznPieb55AKgAqmRyOOzEhR7XirWaWQQMTa+QIhDbZOZAAoYUCPDAQG7" + "FXI4JRrNCoIRdPyyFr0AYifDUKZ+PCufK4RReALLUbtdBHSrGTCCNKqT4MbRqUxxQx+CAAEQ2VCBbxqGaLYDZNgzFbCbLDarRCrqMYMM6cWqpHKUDqhZjnVijEoLcp0F" + "CjVg2OYhTjN/QWk4bo4iseBsAcABIDoPA5g2HgADIkQfDCNxwkEQYnFmAIAB4OJHGcKAPioGRKFKdh2g6UB8iiZ5QkYQp3gKWhDlsWYmAARBcgCIAUniVpmiSA5AF3A4" + "wG8P41nGWwDDAW4MAAIpSG+bRzBoGx3AeCJhh6C4ljCUJGnSRBUFKAIQA6EgIHMWBoHqYgAngHJDCALBmhCCAfHOARAScUBvAmc5zHYXxoguXQ8DEMIAH8dI8HmP4/Ay" + "QJAEAYAoHqRByEQGJiECBAzAkKIpBYNIcikAp8kcZhDn4EBChmUoMgqHIqhiWoIgaDImgyVQImaRw/F0EZGCcSw3DaM4Kn6GBBhwYYZDGZo3C+RgOAmNQnhYeYqgsTZe" + "nEVgSFYLo2CydhGg4OROF2HJjlydR7i+cJjDGFo8BgHgVl4Po+DufJRgcbQOlkCxyKuCJNAsdwIhSC4mgieYKkeHJWD0Ih8BQaYYkkMYppwTg0EsFhJC0SxEkgeodDSF" + "pTheV5SDgLBIieRIigyVo5CeOpymoWhtEQfRACMR4zE2KxRnsV5dF2ehFCeC50G+GBkBiZgaCUGYnBySY+BsdIuEkJJJDSSRsjGeYqEWOhliYVYOHWDYbFuNhFmcS5si" + "qbZrnGLYOh0DpPhyXo7D8d4ZHGXR1CcdRAnsMh7GELwIHiSx7CiXY0HYNZ1nOcoPg0SB+CWLwwGqUpbFAQJwEeEImlCVQwk4cJxAiFRIhMS4ulGYRRlmMQVDEHZxG8Yx" + "XhIaQSniLhIiaGwnDiJZGicZYnjeZw8D6OoSkWEIthwI4emudwtGwepNhuLQ3F8Zojm4bQrhALo0D0HZwCcJwoimeI0ASWR6CAJkJQORfAiFcLIXgahaiGCgMsKIpw8D" + "PH8H4Pj2BhjrBMGQGYfxFjuEGIsB4rxbg+DSFsPAxBtChHoAQaYmRojVG0D0e6JALjVD2K0F4qxfjjGyPIRY/QXi1AOAILwFQGgOF8KYDwOgdBsHmCYcobRtjIHoGgZA" + "mBgi7HgPcWoHxTAmCQCcVwTgDB+FYJgfQMAOj0F2PoZgkRMjeKQLkWATwdDzEkPMF4FxzAXDGJYfAlgPAuB+FkeIWxuizC0LkUwvQbD9ByHIDouxvBCBgCMCAvh4CXCM" + "EgSA0BJDEH+AsfwMgfjhDeL0Ro/xkgvH4JMXA7RYjyAONgPAWhfjyCuBEcAFRSAWE4BIOwEAUgTCaIYfA4wSBUAcAsDowQOBFA4J0Hg9h2B4EmCQTYVBdB0FwIwU4rBy" + "jJGmHIRQ8gJAKB4IoZgShaDKAQOUIolQkjVBuGoSw6hugaFaJoeoWgajaDKDoO4dB5j0FcJ0Zw1Ang3CQDEdgNQnA6EmHgGw4QuCiCSAKFIXBgilEwGcLAZAtDmC0N0W" + "gLhaApFiK0HgfxniuGKP4GIvhrhhGgHEZgaRtB5GSBUcIhg5BnHkOAeQFB5A6DiEEao2xoDHH0KIQ4bxYBfFEP8RogB5BfA8AQHwvwqAZBIBURgCgwgPAqAkKYCgfgTH" + "CBwDIegcgjFUDQXQPQzA4DsCkDwnRABNAwE8OgTw5C6AkJEPgPRSg+DqCANoMRBjuHUKEJglQWDrHYOATg3BuDGDWEMa4CQbj3HMB0Z4Pw5jLFuCAWYsB/D2DgBEUQmB" + "1iuDEMkfI0hUCyEkPIfwihKgqGsGobIGhNhfFGGoZY6gDDuGWDceANA1A2DyDUM4txaA/EwG0bo0wTDXEcH8Sg/BcD2GSHQC4pgtiuGOOkNIRg3hbG+MIGYjhzgaBeHw" + "L4FgHAMAYFIfgJh4nJBQGkfAwRNiFAiO4KIlhoiKFiOoO4EwPiYGONUE4RATg6BOMcUwEApgZGmP4X4lxnjYGaLIZg7RNirH6FQG47xZCAC6OQLK5B1BYF8LgOQZAqh0" + "FqGcBo/xMhpE6HsXomQwBKCwIcfA6w/DxA+IURAIxwgmBSCMKoJgOhFD0JMeIkQdhREwFAEQKRFioAYKkJIqQlhpBYFEPYUQui0GCGgFI9BlCOAUDoS4nRhA7HOOkFYd" + "guhgEgGYUgZB2DeE6IIYIMQEgyAiPYHgYgnBlFiNsPYghKiODqISfddhPgVEOCQE4hg5iWHWPEfwfB3BgFYPkAIWQPAOC8BIb1MwrD+QsNEQ43ACAMAKGUQgsBhBoHCG" + "USNrxBBoEqNgGo8QMAJF+MMOwRxGCOFUBwHYdhODvDwMEBILgk21AKKkOI6RrgyD6LIDoJxNjkDUOQF4yAXgoC4FMXgqhKCiE4KACQow9D5CoJgLQiA9CwEMLUYwOxmh" + "AFaEAdoSwdBBF0CEPQEWWDrGOBoEgGhTAaDyBsPoNgXA4CmHIWw+guCDCSJsNIjxsgADcNQPg2hxC2FKLACo2hNDFEMMcKw/BeCcE6LYXoGRvDJGCN8GIxgUjYAyOUbg" + "6BpDrB0OYWw5AgjtGSOoEofAgjRG2NgY4+RRCfBeKUN4qQvi7H+HAYAchwCOCWAcQQZBBFiG4EIUYww3CFFuEQSgRAlBdDMIwCQiRrCMGCMcIwxhuiKDeE0PAlxCC8GF" + "ZQS4YhIgaEkJYS43hLAxE8EkTodQUBbBWMcHoNxy0lHqOETYyAeDeD4I0AQlRhD0G2E0O4PgKCjHeEoSgmBKCGEsBUS4vxUA8C6M0K4ox7irD+O0VouhfD7FUA33I+gm" + "iXE0IsLY1gtipG0CQbQLQPjFDuDQHw2RtjFGsK0bw4x9j0CcO8N4/RtBnhSgvAcBehmAOh0ANgiAhAnhih8gwh1gbhugRhSBRhDhjh2Bvgyhfh3gPhThOBIBOA6B9gsA" + "YAah+BdhlBWBtAuBoBThtB8gnhFheAlhcByh6BKhvAahNBnh5B1gJB1g+hCAsgAAbB1gOguAJhIAoAmhFBvqzACABh0BlgFggA6CaBvBQA7BDEHAaA0AABoAcgGBEACg" + "5AAgYgZgLAIBKgFBBhWh9AggCAIBoBNgAANA9AJhwABBxBwAKAYAAALCJu9ADAYAFBLExBEAiBEgmBEgxBEANBENbhmgJh5gJBNgJgzgJBfgRAvAhpKhnAQg5AIpkARA" + "SA/ASKGAPBJhZBIAdBJAbARh7n4BIhshkAnAZDVgkBZAUg5AWh5AVB5AEgFAbBFA4BFACglA5hlAfAVAChVAtBVAig1AQh1ABBNB+gaAcgUA7AqAbAWgTg2gfB2gSB9A" + "IBdA1BDh2BHAnBdAZg6Apgdh+h0g7lCBoAXh3BJBugahkBwBihkBkAsBYgtg/h7gNATBNgkhIgUhBg0gzI6BZgJRJglhvAvARgrAtBrALBbBFh2BxB2BZh9hFAcgOAcA" + "dAcgCgcBzhcAVB7h9g5BlgxhohsArgDh5A8heA8BKh8hMB8gzB8APgPBmAdByAShQAVgUAWMMAaAThuATgpAWhNASgLARB3ASAwg+AsEwhiAoimBTBxhUAJhEAJhVhJB" + "PhSBTBSBjgyhvBPlWAbgUgfhRhYBUAkAoBTAoBQgrgygfyhgTBShXBSgwhUh0hWgKhTguhQBphRAdhWAjhoBvg1gQA0g0A1AKACAehLgegzgrgmhcAmBahmB+A4AihzA" + "hhLA6ArAFBrAfAbAyhbAPh2hYB7BzB8AOBDgwhTg+hnALAXB8hXBph3AxAPA/BPA2gLg7A8hxg+AlAXANB9ARB+A6B+h5gBgEBAg9BLhFBBAUghAWAhANhhhsgRgBARB" + "vgjAUgiALhjBpBig8hjhHgSA1ASBqgvA4gkhzAmgkglhRgnB7hlh8BKA0hNgxhMBtg7guh5gjAzhPAtB/BJgBBmhhBvAdhDAighg7g2glAzBlg+AVhUAVAphVAHhqURA" + "Ghvh7g0AgAahvA2FigMg2BhhaBrg6AMAegTA6AVi5B6BlgehNgMgoA9gigMAZA/hBgMgGg+hfgbAvAegSgbApgegXhZhqBagzBYgogfgwB/Cwg7hgh/hDA/gTg5B+gNh" + "/gXh6B8hbh8B/hEhfASg2h/BHh6BfhZBbhuAjB/g9h7BbBth0h/gbh2Ayh/hAh+h/gnh/Ajh3AwgnA/gigPBzBPBVBegigfA1h8BPhshr1HgNhvAxB/hoBdgGgBhZh3s" + "UhMh0gmh1hLg9hIgchQB7BthugQh5hbgugth6BTgLi/ALBkocoPgCA/BQBfhmh+hXhzA/hzh+g7B1hbgch/heh4gvhEg3hsBfBOgbA2B9ArhrANhPTSKXAMg7A+Bhh4A" + "fgZh/AVhdg/hzB7BTBsgfh5B+gdhZh/g7oQBogSh/BMrPhUhYBshvheBfA9AThph7ANhvhNgog/hZBNg/hdhvgIAxhjB2hHBhhOBtg1gPBCg3hZBDAmhDg0gfhNhAg8x" + "MhgBiBvkig7BGgKBHBDBfBJhDBWhPg6BPxKAvBOBUhPB5hMhLhAh0mXBXAFhhB/A3hXBIhwB9AAgUBKg4AHA8AMgdgDhuB8hGghhcACgUAAgOA4AAA8AQABh2BQAegHA" + "2BOB9BYhxhrBAA/hfg7hah4BCBrAxgABkAdAcK4BtgsAshdhZCSAVglgFgbASgeB3AQAPhNhIFJ2TBnhahchDBBh9gQBogABSAlhhBUgbBLANBvA+hbh+gAgWBzB5BXB" + "WhFh/knAAADgLAkgiAggqAsAEhigrA1g2AKAqgKBfAZgdh9g2BbhugjhUgCgtgBALAtAYy+AWhEgmgAhFgSAaT4gAASgaATAahIgxACB9ghhGgfgmBoAEB4gIg/ANBag" + "xAkhGBRA0gs3yBaBjTNAFBCBFBghCACAJAlhFh+AAAEgCAQgQg+h2g7Bbhdgdgdhdhxh7gGvUhbBHhah/B5ATAzh3BOtAWchuh3hOA9h3XvAfgbh0hfh8Brg6hegDB9B" + "tnWDQByA4gkAGJIAZAEgcgFh8gvBJBSAdh0BLhqBLACAABHBtgwB2x8yngsg+gAByA2gAB8hxhvh6Byg+AFBp4nBShMgmBzANgAB8ACBZADARBLPVhQh7uKBOg/B7hqB" + "UgphbA+AfALAygQYohXBZi2AThYhcAeBPhAuwhdgIBEgiB7B9YzhDA0AvAthIBAg8AeBfApAohKA/B2BRA+BYm/gGBCguAG5JhAhjZLAgAvgvhPg1gYgehmAbgLZQhDA" + "jAjgjgOh5heAxzgABhx5Wgig0AfgQA/B13iBgBchVgrhXgVXFhbh9gKBdgugUAbXDgygsg+A/B+B8AqA6g6hahbBsANBmA/hCgmhegeSVgeADBwB+BKg+BnA0hwBxBih" + "Fh7BxBxAxAIgGACAiAYAMAKA/BPgnguAMgPBbBngak8B+hsgqAVBag2hnBOAoBWAJhYgsA2AchvAHhIEMAmgmAmAkAjhHgPB6hUBkhSAqApgpjehsBcgZhAhuAYBOBdA" + "uAXAwgpgPBMBwAOB5AjB+AeAYBwANACghgnBTgph3h0B0BMB4h91BgMAJhxAmgSByhshbajBaWPgTgCAYA4ACWGg3g/AyBfgzhnhPBxA1hrhXBshehChChRBQBQAgAeA" + "FBNAtg7h3hHB7h7B7A9BOgHBDgggfhrBEBHA+h9gRB+68hPAfg3huAoAzbAAiAGBZA7B2htAqB7hYgxgwhVgehOVIFFBRgchLhhgAA7BfBthdB9hkhkgkg0hyBlAKhBg" + "3ABAgAZBEg4AcBWAGYIhzgXAEgDA6gmhphwAtgRBYBmBwBwBQAThBA3gvBXn3hrBDBuBcA/BugnANgEBLhKhCgzhwYzhAAiARAohGgHgggJgMg9gMBrA4g+A6BoAUhch" + "ug3BBgAhZAIBPBNApAFAFAFh6hZBZAZAWhMgkAkBEgyApb1BOAqBGBIBmATAShAhsgOgHBuhxh4gsBOhph2ArAfBmBLCWgigxgOhZhshtAMBrghhDgHgjgfrIB5ABBCB" + "QAcAgV4gPhcgIBWhVhXgnhBApA4hVBXhngFhTLMgcgOhRgtAMh+hFh2h2gohnAsgshCg+rTAGgNhcgjgvwhAsA0BOA8gV4dBN8qBJh68rgUgoB2BdA6h5hTABhMgWAxh" + "Tg9A2guguhJBDB0g4B5hzBmsvhwgwgzgog4g4gDAmAygPBUhWAqANgbg3AmBAI2AOBzhDA8hmBKgxBIAFgAAJhbCuhGgKl7BwhwAmgcAKAigDh2gZAJArABANgDBegx5" + "WgZADgwBGBEAkBegAg2AYg9gwKABtBmhPABBoBZAPgFhHBMAPhmB/B6bdhZhdhdhth1hh8lBGgIBEAUgOhEgKgVgrA0AngaAaBiBIgyB5A3gLgXBcAEhlJjAJgEAsAJA" + "kgqqlhththThrhrhrBVBTAWhZhDhPhThIBWARg+Bn7Sg7A3gDhZAvAphEgegGgehuhpAJAyAJBZQ9gBggAAgAgwBDg3BCAAhkgTh0hkAAhLhthWhTgqAqhJBIAhhmAEg" + "qgqgCgbBiB6h9BD8zhxhmABrOhfAqhMg7ghwiA4BSJNhMgqg4BEhkY8AjBphNATBaA6AtAwBYgEACBBiEBABIAggbg7gmh1AlglAlgahXBmhmB1BgBPBEAmAnwZgogyh" + "VgmgABcgxsNBUAWAAB2B4AHBvA5h3B3ggAQBIAwg+hPhSgqBQCEA/gQBQA2htKUgfAJhFgkhkAYBtAIAMHpgbAasHg0gVAsBhhIgbBVAxAi/MgFBnAZBDBpB2ABgwADB" + "Wh3gchuBwBxhrhkB1BbhWAFAP5mBCghgTgnA8AgBV+OgqhSg2g1g3AnBOAcg+hNAYgbhHBRg8g6BjhjhjA2ADgdAdhTg/Aeg/hvA6h1h7A2gChLhKfjAdAxhahigYgMA" + "GAshzg5AAaYh/AGAjh2AChABwBOgwXnBFh/ApAzgT2GBZBGvTBHAjBGhAF0wAgsDi1w4Nza2UkyBUYiA+maxm6g1K32ad3s2Qg8AKlRaBlKD1wKE+rCCjSObAK8iGsFO" + "rC0vR0lTeDV8IUatHu6GO2jkAHgAwgfgC5TYrVsKk2Y3MBRcpBQkgmOUuznY2FqKy0WSymXeX0ASwel0olHI5AwJ1mx0gL1mTXU6XS8Vpdj4hyg8BemDYZHqMFOUyYZT" + "WP1WJ1CN1MTR6gH4cmysjKr2mlCqn3GuR+jDoJHGWlKkU+ajXpgg1yq2FQDFigSEBROwkCKnQwGwjliIU45x2HGyIB4dnM0UmUC+PhaLxefwOdia5zMT3+8wwYCQmEwd" + "i4vQKqHKvigKHoKnc9Rs7GMDUOhhGOnAYjWkzKKRGyxsDUA01QCw0QCOF0uh0OkfRUMMbyRNwTBiCYZwKMIYyZAUkSlBYkxsCYAAHG4qwCBwMQfBYlxsNgsDhLEgwHA8" + "PiPNg1ygP4uywIgMSwK4zSQG46BnFAATDJcL3IHM6DQBsPR3O83j/AsJyGH8w4ZJY5TsN8EAdFojTwJ0AAoA4MgATIMDqAcrQPMEwTDBgVy0LYtiuK8qyrFs6QtCocnL" + "Cs8wAGAChOGM+CZJ0HAaoQHQYocBiaHtJT3LEfgCLYIgQNYgw4IQiSaBcAABBEAB/DAXS4HgPAgLUSCzGkPjkIATyXPQoCeNYfR6Do7QGI8Zj+CAHiyCY2SkIQTSSCIy" + "DQCkpDBJQJinMMuAUPgOxGOcpA/AkoTzJwyiYFMiDwJEsShFAURFCwJRVFceQXKQIS8P8STlBgLggAcrAQCQATjIgZA0JgVSxL0OAmKI6CpEc4SuOkeBeOwMRnLQuQhO" + "ApDJAImYmD44BPIgAzFMYiR3LcQw4JwqhQAknAMFAxwEEwJwUO4ljCHgmxzNwNQ3EU3ScLYEAACocDePwZgCLI+yFN8jg7FEQTtKMcwrAAOhgHw6SQI4OCmJgjDmNAjj" + "5Gw+wbHkkTpEw7gpFgIAA2sABJEUThEK4QhgIJAQ==`)") as Object)); var_Items.set_Caption(h,1,var_Items.get_Caption(h,0)); var_Items.set_CaptionFormat(h,1,EXLISTLib.CaptionFormatEnum.exHTML); var_Items.set_CellHAlignment(h,1,EXLISTLib.AlignmentEnum.RightAlignment); var_Items.set_CellImage(h,1,var_Items.get_CellImage(h,0)); var_Items.set_CellImages(h,1,"2,1"); var_Items.set_CellPicture(h,1,(var_Items.get_CellPicture(h,0) as Object)); axList1.EndUpdate();
559	ImageSize property on 32 (specifies the size of control' icons/images/check-boxes/radio-buttons) // AddColumn event - Fired after a new column is added. private void axList1_AddColumn(object sender, AxEXLISTLib._IListEvents_AddColumnEvent e) { // Column.Def(48) = 2 // Column.Def(49) = 2 } //this.axList1.AddColumn += new AxEXLISTLib._IListEvents_AddColumnEventHandler(this.axList1_AddColumn); axList1.BeginUpdate(); axList1.ImageSize = 32; axList1.DefaultItemHeight = 36; axList1.HeaderHeight = axList1.DefaultItemHeight; axList1.SortBarHeight = axList1.DefaultItemHeight; axList1.Font.Size = 16; axList1.FilterBarFont.Size = axList1.Font.Size; axList1.ToolTipFont.Size = axList1.Font.Size; axList1.Images("gBJJgBAIDAAEg4AEEKAD/hz/EMNh8TIRNGwAjEZAEXjAojKAjMLjABhkaABAk0plUrlktl0vmExmUzmk1m03nE5nU7nk9miAoE+oVDolFo1HpFJpU5h8Sf9OqFNqUOq" + "NUqdPq9VrFWrlbr1QpdhAFAkFis1ntFptVrtkrpszrNvmVxqk3uVtm1kmF3sdBvF/wGBmV+j9BYGHwWJulfxdax2NyFdx2JlV6l9Nw7AAGZymdz2Cy2GxErvWcz9ivlw" + "yV21cuxugwktzGIzmvwtl0+53U5y0a0Wazmmyu/3dCyOMyXHx/J5nIr9q3uyqnBxFN3G46ma4vb7mD2Ng4nZze00fDkHC7t7us2rOX5tguetpHRlmz4HVqnXk1PjHO+C" + "MPo9MBMC+j2vC8j7wS8cFNI4kBo05UIvfCT/NsnsApU+0Fqg/T+oy/kPxC0sEQfErKQK96+w28UWRI8UGvO8sTLS9r2PWmsMJTDTask3CsIbIEQRA3shOXEEAO/GclJ9" + "FEKrrA8FRbKMXRIlb0JxCkjS1LMswhCcvuel0cv26cSMa8Ufx+2sQwhEUoSXOCjSbLcnxjKc7sdKUVyq28NtVI71P9P7JxtQEapjQ6fzfM8zPfNE2PhIsLL63E40slk5" + "y7N89LcyU9SvMb3SdUc6VJLj5VLVLfO/PS9KzNFHUa/0XyBD0dxlS9cxhMlTRSoNXypPErWDPyfNS+MwprRNO0FD8wVVZ1AI08URwVRjtJ1WCn21QkkUrXVLVPQS/XIk" + "FgTxT9iONZ9xVTdq+L1eKg3kkF6Upe68XtfV51/MtrVjBlwYFL1ev8y1/P6/lyzzYl02wntj0RVFmS1Qa+M5as93QxEUW9e993rfmQ2+vy65M/mL1lhl/2bj2ByVduMt" + "NhCJT9hdz41nN14Ld12Z9UjfI/oUAaGseiw6+uFLLhcVabJOS5RqOE0BHlZ5VnEr5fOMs3st+aa/bbRzrJGV51Y0b0DbqaWXZD90hIsPbjWu52+6Wyadpe66hhO+P/Xi" + "oW5rD8ZbrUZuVg6n1dsE/cXmewu1m9PVwnd35/nueXho/NaJzmjc61W76esuT77eG8pTquy9TwWH8LEzG8RDfFalx3Gcfvna9rvG/cptGLd9tuI6TZOP5Fiqi99vea+X" + "4VRcBq/JZZtVQ9cwSs5lsXE372+a9z7PbfB3VVqHyvMctLto8uob6eV0m/cD6MN2v+T33t6sBut42vdv2bJ8a997x2maFJfK+qArbGJPEKE+1qTflMsIdW/GCJX17KcT" + "6/czr/X+u1g29B7j/4BQfWkkx4zIHisjhPCmE0K4SwtXM+d4BvHRwNZOoBph9IJvPek9d40FoMJxf691jj2ywQQcHEWET4XJwkTszlVqm2GokewxtBT1DpQjRxDN0rUV" + "DNKdC3lb6tzNOwh6upMSSYfv4YBCl/bsn9PxiFCEo7SI6Obc9HeOrnY8x4jtHtdpN4GRbaorhsbu18Pph5CiHymI0RpSXGJ/z2oUOxYxG858AyiI+bfJtuTcG5yelBJy" + "T8okhqFd4a5yxL0rvulYtKCsZiWxWkc1s1cRoxxwhA31DLE0mR9l9HqX8fJgTDmFMVH0MIsRzVYnwnMi1dyzmhLt2kS2pxIiU62Wj5ptQGlSYFakLonTUJNLKaM5Wzlf" + "fEkuFkk5wTrhVO2eE7G6lJhxFFYUZ55zmn0WuBCD4pzhirFCKkbomsOoIYmZx5p90LoYWGPdD5g0QmJRKYxbZ6zYoVQ2jVGylSak7KSkFH6RSjpHKFuU+YMyNo5SulkC" + "6I0vonTCitMXPoEpVS2H5FQfEqp2R1opIgAEkJISYARTCukOhmPNI5Ex/wzGHUsicMwA1LHgQ90Y/KpoQHAD+pB/R4NzIaMAB9Xaw1gqaAOsh/A/ptIkWUfhGK1kZH8R" + "gH5GqvgArqRmt4AAPrTroRofBGADkqr6Rmu4D7CEaHARiwpJrEEZsXXwlVjyMWRsaRqwdkLGNBABZmytmyMnaINZqyVpLR2ftKAAAdd6h2osbaskdiq4EZtgSmyNcbVW" + "RJNXe3AA7REar3b0stlAAXBtoRmvJGLjEYAHUWsFcwCD/rnaop9aEICMAPdK5hT6xpeuzdOtAgKuJeGfdq6ggEbkTvAP+p9UCHXrvKkcgIA=="); EXLISTLib.Appearance var_Appearance = axList1.VisualAppearance; var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABfICg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj" + "6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" + "MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsOatVqjG5sYjcGC3La9cz3Pq/bpuDCbMxuaK1TrYXr1TTrcofBDldAxXRKDx" + "RDWVhLnYOw9i6XxzjuXprCaOoKB6EwbiCZZCGOdZYlcT4xHmbhMnwNxtn+G5bmqdZ7n4Pw/i+X5zm+dQ9g4CAFjsfAJheOI8HsDoWDWTB/lwSAQkmA5PEgRYoDyDwYFY" + "FoFmGCBmBqBphDgRJ0gOTIYBGRB/lyRh0iSCZbjYWJzgWDwIjYLoLmMCJGDKDJjBgWgqG6YhyhGHRzA2aJ1mCABOAiOJvhCZBJBYRoRmSCQmEqEQimkAZgg8TZnDCV4U" + "kmCUmBKZYJGYWoWCUUhiFMNZckNUh2GENoaGaGZmgmJhqhqZpGGIEx2GYIxSGGGJdggWJth2Z4JmYeoemeSZ2H6H4hGmQhihyTRHGYLg7CiCgmgqIpokoNoOiOaJ4jqA" + "ochqaZGgaCxpAoZoaiaaJqEmWIcGgShcnCJwqEqFoR3YOoFlgchflqNouiuawHmWSYqGkWZQhcatzmaOoumuSp2j6L5bBaKo0GQKRnGGCxqiyCwmkqMpsksNpOGUGI7A" + "0ew1G0Rxlg0PptgsZuDG2Sx2l6N5tnYNZZjUDRXDCVo5l2FoymqOpukuNpujubwLjmWY5k0ZwxkaFxYlWdp6j6b5Lnafo/nABQdg2FxcUsY5BkmXAkmeQpckwNRrkKTh" + "8CSHZBk4NwyC4KxxgMDwakOMZDn8GgwnGAo2C4cwthMcwmCcMoHBMHRehwTIghySYNksZwcH4HBMEsHx5hyPItiweYxnwSZEH4Mozn0fR+DMAo7EYJ50gkdZelKdNql2" + "UgJn0GIukwH4HicQRai2GI4mSVpNl0dZGledgNgcYpYDWUx3FsOQi5YV5anaTY3G6W53A2RxylydxFjiaxEFCCgBBAQ=="); var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABcoFg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj" + "6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" + "MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4" + "nGKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEokiEN5NCKfJ9DyTRjnS" + "cg1CEYxOBmBpPCgagdgcIZoHoGIFA4AxQkCAxKAgKBwgGSpIBCZhjF2E5UnQPQMiMCJBCIBwxkSQgsgo+JtDKT4ziiQw+k6EwAnsOgLnkHI+yCQ4iEuE4klkPhShEJBp" + "AoPgymOMoaDgHBjFMBgyD0HYTiCZSZhIIIGC4ChiHSew5kwM5omILZPiOBI0hwZw5kodIdA+M4Uj4PxOmMSJ9DuTQzmyZgviceZagaHVfj4awwmaAh2GUIYmCOEZZDaD" + "RDFGdwcg4EwyHMN4LBOaJbCoaZqgKH8qkMfIyD8DozDyfA7A0Coui0OpMmOZJdCsahKg6NooioChwmEMxLEoXJbDUTRXGSUgykyMgQG0GpPHMdI3D4TRCgSeQ0kmaw+l" + "GNAtCOZJVCiT5DhyRQwAqMg0EoDBBGEGAsASC5yiSCw+k4Mp6lWNQuksTpRjMTxDGzJwGmGMpDDKXYTECSAxl6Q5olkK4PgMMIVkASRMBMBgzEkaZEjsNALhIZA6AeQB" + "gk0ZJEgAAJ0CIAgODMNIsD6DRih9uYwFyAwfCUb5ijmbI+gwdxkk8MZMGeMpPCkDxzBiC5MHMPJLDSSROFMLIoBEQogEMFJPnENYQGgE4DCOaJfC7tYkhGTQ0kyWwyku" + "XpMiyRpKjKR4wngM4JmOWJACCdYtHMWw+Eych4nINYLAEYA8AgdAEEsQZajaQoog4GxPiMVIolcdxNG8XZVkmNoRwWRVBlFeFEeAZQJgnFiHgHwcAhjhHgGMSI5xki2C" + "yA4EQsA3i0HkBsLwKRFgAHcPkHopBJBcBeDUYI7xyDOHqKkWo2hLCsDIBIY4qQ5A8DoMMYwOAqCSBGKgU4yB2iDBwIgB4hxQgAAWNgBoAgsBdEcBUQ4sQ9A/HqD0JI8R" + "pBzH2OYVgahLBHFiJQJweQiDhDUE4SAARQAzFsG0EQwA6AOWSBkFgVAIBCHeGERQFQiCQHeFkC4vkiB8DyB4F4QxVDvGMNEOQexMjlBeOAKQiQLgfDA7QEAaRiBdEkH8" + "TI7AZiFBAGYBIABWjYBiGACioQ4C1A+AMMgWhfgxHgPsT4URIB0COKgPgjRwiAB8AYUArxBgCF6J4GY5hrAOCAPAAoGRRCsCIMEXATXfgAF8BMJwURuEQDgD4Q4OBoAe" + "HGFgLIwQrC2D0JoSQ+QvhrHoSgQI8AbDFGID8C4Ah6BQAQAASACwgCYCMAUMARAvCKAiAMCAokeCKBEOAKgCBoDaHuMsEAqwJDiACDURg8R6gPCyDofYWAhgoDIJ4ZAu" + "hoiGAYGgRoQw/A0GMMga4GwxiEDeIYYInATCDBQAoBAwAoDlA0KMBoVRGiDGwDQUYIRsgaGGDgM4LAwDWB8EcIA1APhjEgGQVwgRIgjFIIQHokgZA+CSEkLIKQSjHAwM" + "sCwDAsAEB2ABTIwRwD6A8CMToSxkAxE4HYIw+BsgbBEDAHYBwojCBoIYFgXSjABE4MsHIbQWhlGILQS4UhvBdAUKEEwHgxDAAABQQQUAhgKHiDwE4JS4A7BGLQZwCR4g" + "aBEMUYAqgKApHgGwVAIRNgvBMMQXImwZDtE4I8UIyAZCDCAE8AwrhgAdEEBACQLRCg4FEB4AYtA7CdEiPQMoJAMDNCkOMCAXAFDhH0D0Q4EgfAaGSK4NYzRUj9BuCgAg" + "swOBjB4Fqpw8B2ADAwE4A4Qx2DAE6JIaQPQGhAGKBcIQ5B5gHByKIFARwADbAyKUfgdBKBBGyEcVIAB/ijHoIoSA0gdBNl+OATYERZgBGSDYWIWAUCEGKA4FAhR7CIBt" + "YQGYZg4CMAiKEcAOwkBjHWE8Z4lQgA+DkBoTohwwCeAaMEEgBQCCABgHMRwQRhhMEWFQd4HwZgwDqFESItAbAGEANCpINAzANCCJkK4ah+heFYBURwsQrS2CsMYMoWGB" + "hYDWI0EInQgiApXaOVI1QFDsC8MUNoMBMA1HMJga4eh+BeAWOgNNowGjYzCGAAwax+iJBeBVT4gxoBIAGFsJFBxgBiGKFkKQ7g5DFFQEcAo4AzDDACKEQQLgCiJDYB0M" + "gRBCCQAgQEA=="); var_Appearance.Add(3,"gBFLBCJwBAEHhEJAAEhABQ4Fg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj" + "6CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7E" + "MRwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4" + "nGKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEosiYN5NHMOJ+D4TpTnS" + "eQ7CEY4uBmBpPhgagdgcIZoHibIEyUBJZDQIJShoCgcCAcoyAQOYYlcZJ1D0DxDCiQgwEiAZMHEMJLFKPJ9D2DoDnidQ4k+Y5QmKEROBkIhKD0JIZDIS4TGUCQuEeEJj" + "nOIg8CuY4RkYNgwGMM5RllGpThDRYIGKZIpCkJFUH0PINyWcQ3CaaZCG+HBnEOTJhD8Tx4GoeQ/GcaZSHOH5nCmQhshoZhihYYwhiYA4RlkNoNEMUZ3ByDjwEsPxOnMa" + "J9DuDR6F6GYmCmKh0nANtMioP4Gg8aoSiIO5NhodociqaY6GaFYkEyOg8lsNRNTaUgykyMgQG0GpPiONJbD8DpDEyfA6k0KwOkWMQsGsAJU0SagwkoJQJDIPISCQCJTG" + "SUwyGaM4KkmMgtksHpFjAZ4TGCBAbgaSpcksdhNAMIJHHsD5TjSWWMAMOpwjyLwbk6cAz0KRJiDkDYzESCwiggcgcgYIQwCIEINCMCITj6TVxkMXp2j0cQLlCTo7E2F4" + "ymkMZdhMPJHDGHpLAyVg+k4UwrCCSIyByDJ8DuDY8CiWY0kiXAXC6QJwFKGIjCeJpjgyezjlyDw6klHx5myRoMGwZwbkcToTEiew4kwbQfEmUgPkOKJUD4DpTHSHQmgk" + "XI/ASTA1g0XIEDMTBimyfI7jSLYHEiUoPk0Fw/kadAsHGao8A0A5smEMJ2mNyg5gzJZwDgCpChyIZVyIZwFCMJEPASRkBqE+IcHInRcDxA2H4bIsx0AtDsIBpwZwYicD" + "6BscwDwUBgHCIYaIfgtiVH2O4WgUwJjEFeAEQA7y4hMCiBMS4aRdB9A4CYE4LxljyBMHcDItBxinDCLcTYmgejBFQ9UTg9gFBOEmAQTI7A4iZGMGkQAWQ7jYA2HIL8BR" + "AjDG4HcCwARbjZHiNoDw1nLDnGyNINQ+wjCpBMEgcovQUgICQJEcgWRuBvAyJ4d4ugpCUAINcHogxIgnDiM4N4axzD3F2JMTY/hRqYF6FsWIxhYAGGoAALQYgYirBwBE" + "BwpAjBEAAIEIYsA2gOHCMAGgXAACIDmMITAUgFABH0D0I4WwvhNFGMAOIvxRD2GKNcMA8gjAPDCPwBogRPAxA8PgRwZRICYDED8RAXQEghEAN8DIgwIBdB4JYWwMgtiQ" + "HoFQKAiRFguFKGwGQhglDsEOVwEQQRkCKBwOIHgSREDRBYHEXQcQdD7GIGARQHRxipBrMobgewDCUCADsEYWAzgMHKHQDQxxsDzA6EMfAeQHB4GQDkUYPA0iECiKoGgR" + "hcDdA2GMQA8AOCjDSPgHI4QnApAKBICwHg1A+BcAwcYsgbjGGQNkCIgRsA6EcBEWANADjsB0B8YYzQQDIGSBcEYZBCCPEkFIHQSgkgZAwG4IwBAbAYGGAgL4Ch4g8BOC" + "QAA2KKC0GcAke4AAXAFCoHkDw4xbBFEcJkE4JRSiEFeJYKQVRMgJHODwX4xAgC/AsIIZAeAHDRG0HYI40RKCLEGDUI4jAghwBWIceA+whCpHMFYZYOQxglDMHMBQGxYj" + "VHiAoBIPgfgHGwPsHYJRSB6A0IERQLhCjJHMA4OQoAoCOACLYGYSx8DpBQIMWQdRnDRH+DsE4fB3CeAmM67kAAXBFEIDYDI7wLBtEoEIfYNwjiUGGJQYQMAjCHEAO0C4" + "zxW29CoCgfIxR9AKA6J8BgUAIhDGMIoJ40hqgwCgKETgnBhhqCGI0AIqgZhGDANQDIlBDCRGkCoJISR0g1BSKQOgfAzBRG0DYHARh4DeDAOwANuw8ApCKKkYg/RPhjBs" + "H0J4yg5hPGWN0GwFBHQBFaDoQIURljFAoB4GgzRVzbBECQFQRQoguHGHANwDRdCKy8CgSIGwhhoDYJYYI1giBICSAEgI="); var_Appearance.Add(4,"gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH" + "LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKB" + "UrGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo" + "3NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDs" + "YYDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoV" + "mWCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoV" + "oWiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZi" + "Se41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbh" + "FCcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA=="); (axList1.GetOcx() as EXLISTLib.List).BackColorHeader = 0x4c6c6c6; (axList1.GetOcx() as EXLISTLib.List).SelBackColor = 0x4000000; axList1.SelForeColor = Color.FromArgb(0,0,1); axList1.set_CheckImage(EXLISTLib.CheckStateEnum.Unchecked,16777216); axList1.set_CheckImage(EXLISTLib.CheckStateEnum.Checked,33554432); axList1.set_CheckImage(EXLISTLib.CheckStateEnum.PartialChecked,50331648); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exSelBackColorFilter,axList1.SelBackColor); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exSelForeColorFilter,axList1.SelForeColor); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exBackColorFilter,axList1.BackColor); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exForeColorFilter,axList1.ForeColor); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exCursorHoverColumn,-1); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exHeaderFilterBarButton,0x4000000); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exHeaderFilterBarActive,0x4010101); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exFooterFilterBarButton,0x40000ff); axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; axList1.ShowFocusRect = false; axList1.SortBarVisible = true; axList1.BackColorSortBar = axList1.BackColor; axList1.BackColorLevelHeader = axList1.BackColor; axList1.FilterBarDropDownHeight = 1; EXLISTLib.Column var_Column = (axList1.Columns.Add("Check") as EXLISTLib.Column); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.Width = 128; var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowCheckBox; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column1.FormatColumn = "1 pos ``"; var_Column1.AllowSort = false; var_Column1.Width = 48; var_Column1.AllowSizing = false; var_Column1.Alignment = EXLISTLib.AlignmentEnum.CenterAlignment; var_Column1.HeaderAlignment = EXLISTLib.AlignmentEnum.CenterAlignment; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Image") as EXLISTLib.Column); var_Column2.DisplayFilterButton = true; var_Column2.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; var_Column2.FilterType = EXLISTLib.FilterTypeEnum.exImage; var_Column2.Width = 128; var_Column2.HeaderImage = 1; EXLISTLib.Column var_Column3 = (axList1.Columns.Add("Images") as EXLISTLib.Column); var_Column3.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column3.Width = 196; var_Column3.HTMLCaption = "<img>1</img><img>2</img><img>3</img> Images"; axList1.Columns["Pos"].Position = 3; EXLISTLib.Items var_Items = axList1.Items; int h = var_Items.Add("Child A"); var_Items.set_CellImage(h,2,1); var_Items.set_CellImages(h,3,"1,2,3"); var_Items.set_Caption(h,3,"123"); h = var_Items.Add("Child B"); var_Items.set_CellState(h,0,1); var_Items.set_CellImage(h,2,3); var_Items.set_CellImages(h,3,"2,3,1"); var_Items.set_Caption(h,3,"231"); var_Items.set_SelectItem(h,true); h = var_Items.Add("Child C"); var_Items.set_CellImage(h,2,2); var_Items.set_CellState(h,3,1); var_Items.set_Caption(h,3,"312"); var_Items.set_CellImages(h,3,"3,1,2"); axList1.EndUpdate();
558	ImageSize property on 16 (default) (specifies the size of control' icons/images/check-boxes/radio-buttons) // AddColumn event - Fired after a new column is added. private void axList1_AddColumn(object sender, AxEXLISTLib._IListEvents_AddColumnEvent e) { // Column.Def(48) = 2 // Column.Def(49) = 2 } //this.axList1.AddColumn += new AxEXLISTLib._IListEvents_AddColumnEventHandler(this.axList1_AddColumn); axList1.BeginUpdate(); axList1.ImageSize = 16; axList1.Images("gBJJgBAIDAAEg4ACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjMLjABAAgjUYkUnlUrlktl0vmExmUzmk1m03nE5nU7nkrQCAntBoVDolFo1HoM/ADAplLptImdMYFOq" + "dSqlXq1QrVbrlGpVWsFNrNdnNjsk7pQAtNroFnt0sh8Yr9iulTuNxs1Eu8OiT/vsnsNVutXlk/oGGtVKxGLxWNtsZtN8iUYuNvy0Zvd+xNYwdwvl4p870GCqc8vOeuVt" + "tmp1knyOayWVy+WzN/ze1wOElenm+12WUz/Bv2/3UyyWrzeutux2GSyGP2dQ33C1ur3GD3M4zUNzHdlWjq/E3nGzVpjWv4HA7fRy/Tv2IrN8rPW6nZ3ve7mUlfu20Z8a" + "cvQyb+vY9jasYoDwMm+LytVBDqKG3z8O3Cb8P+mkAuY9cCQ2uL4KaxDKvkp8RNLEjqugnrwQo/UWPzFyeQw5sNLZFENrI4kOqU66pw8uzmOKvTqNqjULJvGL1JO48GtT" + "GsbLdEL3scxLlyiw8dQeoUVxdLTtyKmUjwGlslRPJsnK1HbAKbKCrsQo8uQk/CeP44iaR/ATnTNPLvyxPU+z9P9AUDQVBowiofJXQ6Oo+kKMpIkjztE4TKn4P6JowfgP" + "nwD5/nAjB8AOeAPo0eAA1IAFH07UhAIMpYAVIYFHqBUhwVjV1S1EtQAHxW65V0AZwAeuQAnwB5gAPYViEDVhwAHTQBkCjB4gOhwDmCyhH0sACAg=="); EXLISTLib.Appearance var_Appearance = axList1.VisualAppearance; var_Appearance.Add(4,"gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH" + "LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKB" + "UrGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo" + "3NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDs" + "YYDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoV" + "mWCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoV" + "oWiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZi" + "Se41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbh" + "FCcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA=="); (axList1.GetOcx() as EXLISTLib.List).BackColorHeader = 0x4c6c6c6; (axList1.GetOcx() as EXLISTLib.List).SelBackColor = 0x4000000; axList1.SelForeColor = Color.FromArgb(0,0,1); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exSelBackColorFilter,axList1.SelBackColor); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exSelForeColorFilter,axList1.SelForeColor); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exBackColorFilter,axList1.BackColor); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exForeColorFilter,axList1.ForeColor); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exCursorHoverColumn,-1); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exHeaderFilterBarButton,0x4000000); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exHeaderFilterBarActive,0x4010101); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exFooterFilterBarButton,0x40000ff); axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; axList1.ShowFocusRect = false; axList1.SortBarVisible = true; axList1.BackColorSortBar = axList1.BackColor; axList1.BackColorLevelHeader = axList1.BackColor; axList1.FilterBarDropDownHeight = 1; EXLISTLib.Column var_Column = (axList1.Columns.Add("Check") as EXLISTLib.Column); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.Width = 128; var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowCheckBox; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column1.FormatColumn = "1 pos ``"; var_Column1.AllowSort = false; var_Column1.Width = 48; var_Column1.AllowSizing = false; var_Column1.Alignment = EXLISTLib.AlignmentEnum.CenterAlignment; var_Column1.HeaderAlignment = EXLISTLib.AlignmentEnum.CenterAlignment; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Image") as EXLISTLib.Column); var_Column2.DisplayFilterButton = true; var_Column2.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; var_Column2.FilterType = EXLISTLib.FilterTypeEnum.exImage; var_Column2.Width = 128; var_Column2.HeaderImage = 1; EXLISTLib.Column var_Column3 = (axList1.Columns.Add("Images") as EXLISTLib.Column); var_Column3.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column3.Width = 196; var_Column3.HTMLCaption = "<img>1</img><img>2</img><img>3</img> Images"; axList1.Columns["Pos"].Position = 3; EXLISTLib.Items var_Items = axList1.Items; int h = var_Items.Add("Child A"); var_Items.set_CellImage(h,2,1); var_Items.set_CellImages(h,3,"1,2,3"); var_Items.set_Caption(h,3,"123"); h = var_Items.Add("Child B"); var_Items.set_CellState(h,0,1); var_Items.set_CellImage(h,2,3); var_Items.set_CellImages(h,3,"2,3,1"); var_Items.set_Caption(h,3,"231"); var_Items.set_SelectItem(h,true); h = var_Items.Add("Child C"); var_Items.set_CellImage(h,2,2); var_Items.set_CellState(h,3,1); var_Items.set_Caption(h,3,"312"); var_Items.set_CellImages(h,3,"3,1,2"); axList1.EndUpdate();
557	The user clicks the drop-down filter, select a value and the control's list filters for the selected item(s). Is there a way for when the user then goes to the next column to add another filter and the drop down arrow is clicked for the list of values they can filter by to be limited to what is being displayed in the list due to the first filter they set // AddColumn event - Fired after a new column is added. private void axList1_AddColumn(object sender, AxEXLISTLib._IListEvents_AddColumnEvent e) { } //this.axList1.AddColumn += new AxEXLISTLib._IListEvents_AddColumnEventHandler(this.axList1_AddColumn); axList1.BeginUpdate(); axList1.ColumnAutoResize = false; // Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project. ADODB.Recordset rs = new ADODB.Recordset(); rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExList\\Sample\\Access\\sample.accdb",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0); axList1.DataSource = (rs as ADODB.Recordset); axList1.Columns["ShipVia"].Position = 2; axList1.EndUpdate();
556	Is it possible to set from code, a column sort without being inserted in the sortbar axList1.BeginUpdate(); axList1.ColumnAutoResize = false; // Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project. ADODB.Recordset rs = new ADODB.Recordset(); rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExList\\Sample\\Access\\SAMPLE.ACCDB",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0); axList1.DataSource = (rs as ADODB.Recordset); axList1.SortBarVisible = true; axList1.Layout = "singlesort=\"C1:1\""; axList1.EndUpdate();
555	Is it possible to highligth the match while a filter is applied // AddColumn event - Fired after a new column is added. private void axList1_AddColumn(object sender, AxEXLISTLib._IListEvents_AddColumnEvent e) { // Column.Def(17) = 1 } //this.axList1.AddColumn += new AxEXLISTLib._IListEvents_AddColumnEventHandler(this.axList1_AddColumn); // FilterChange event - Occurs when filter was changed. private void axList1_FilterChange(object sender, EventArgs e) { object format = axList1.FormatABC("`value replace '` + value + `' with '<bgcolor 000000><fgcolor FFFFFF>` + value + `</fgcolor></bgcolor>'`",axList1.FilterBarPromptPattern,null,null); axList1.Columns[0].FormatColumn = format.ToString(); axList1.Columns[1].FormatColumn = format.ToString(); } //this.axList1.FilterChange += new EventHandler(this.axList1_FilterChange); axList1.BeginUpdate(); axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exVLines; axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; axList1.Columns.Add("Col 1"); axList1.Columns.Add("Col 2"); EXLISTLib.Items var_Items = axList1.Items; var_Items.set_Caption(var_Items.Add("219 Smith"),1,"Ignacio 1234"); var_Items.set_Caption(var_Items.Add("1666 County Road 309A"),1,"897 Manassa"); var_Items.set_Caption(var_Items.Add("38 Lone Pine"),1,"Durango 11"); var_Items.set_Caption(var_Items.Add("612 Jachim Street"),1,"Lamar 222"); axList1.FilterBarPromptPattern = "1"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCompact \| EXLISTLib.FilterBarVisibleEnum.exFilterBarSingleLine \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.FilterBarPromptType = EXLISTLib.FilterPromptEnum.exFilterPromptCaseSensitive \| EXLISTLib.FilterPromptEnum.exFilterPromptContainsAll; axList1.EndUpdate();
554	Is it possible to highlight the column's header once a filter is applied axList1.BeginUpdate(); EXLISTLib.Appearance var_Appearance = axList1.VisualAppearance; var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgAN" + "J0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8Y" + "NYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4" + "hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mg" + "bhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhW" + "BMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI="); var_Appearance.Add(1,"CP:2 -8 -4 2 4"); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exHeaderFilterBarButton,0x1fefefe); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exHeaderFilterBarActive,0x1010101); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exCursorHoverColumn,-1); axList1.HeaderHeight = 28; axList1.BackColorHeader = Color.FromArgb(255,255,255); axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines; axList1.HeaderVisible = true; EXLISTLib.Columns var_Columns = axList1.Columns; (var_Columns.Add("C1") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (var_Columns.Add("C2") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.Filter = "Item 2"; var_Column.FilterType = EXLISTLib.FilterTypeEnum.exFilter; (var_Columns.Add("C3") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Items var_Items = axList1.Items; int h = var_Items.Add("Item 1"); var_Items.set_Caption(h,1,"Item 2"); var_Items.set_Caption(h,2,"Item 3"); h = var_Items.Add("Item 4"); var_Items.set_Caption(h,1,"Item 5"); var_Items.set_Caption(h,2,"Item 6"); axList1.ApplyFilter(); axList1.EndUpdate();
553	Is it possible to show the filterbar on top of the rows axList1.BeginUpdate(); axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarTop; axList1.HeaderHeight = 24; axList1.FilterBarHeight = axList1.HeaderHeight; axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Flat; axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines; axList1.GridLineStyle = EXLISTLib.GridLinesStyleEnum.exGridLinesGeometric; EXLISTLib.Column var_Column = (axList1.Columns.Add("Column") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = EXLISTLib.FilterTypeEnum.exPattern; var_Column.Filter = "B*"; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Index") as EXLISTLib.Column); var_Column1.FormatColumn = "1 index ``"; var_Column1.Position = 0; var_Column1.Width = 48; var_Column1.AllowSizing = false; var_Column1.SortType = EXLISTLib.SortTypeEnum.SortNumeric; var_Column1.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("A.1"); var_Items.Add("A.2"); var_Items.Add("B.1"); var_Items.Add("B.2"); var_Items.Add("B.3"); var_Items.Add("C"); axList1.ApplyFilter(); axList1.EndUpdate();
552	Is there anyway to stop the header changing colour when the mouse hovers/moves across the column header (non-clickable) axList1.BeginUpdate(); axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; EXLISTLib.Columns var_Columns = axList1.Columns; var_Columns.Add("Item"); EXLISTLib.Column var_Column = (var_Columns.Add("Pos") as EXLISTLib.Column); var_Column.Position = 0; var_Column.Width = 32; var_Column.AllowSizing = false; var_Column.FormatColumn = "1 index ``"; var_Column.AllowSort = false; var_Column.AllowDragging = false; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.EndUpdate();
551	Is there anyway to stop the header changing colour when the mouse hovers/moves across the column header axList1.BeginUpdate(); axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; axList1.set_Background(EXLISTLib.BackgroundPartEnum.exCursorHoverColumn,-1); EXLISTLib.Columns var_Columns = axList1.Columns; var_Columns.Add("Item"); EXLISTLib.Column var_Column = (var_Columns.Add("Pos") as EXLISTLib.Column); var_Column.Position = 0; var_Column.Width = 32; var_Column.AllowSizing = false; var_Column.FormatColumn = "1 index ``"; var_Column.AllowSort = false; var_Column.AllowDragging = false; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.EndUpdate();
550	How do I get notified once the user clicks the cell's button // CellButtonClick event - Fired after the user clicks the cell's button. private void axList1_CellButtonClick(object sender, AxEXLISTLib._IListEvents_CellButtonClickEvent e) { EXLISTLib.Items var_Items = axList1.Items; System.Diagnostics.Debug.Print( var_Items.get_Caption(e.itemIndex,0).ToString() ); } //this.axList1.CellButtonClick += new AxEXLISTLib._IListEvents_CellButtonClickEventHandler(this.axList1_CellButtonClick); axList1.BeginUpdate(); axList1.Columns.Add("Item"); EXLISTLib.Column var_Column = (axList1.Columns.Add("...") as EXLISTLib.Column); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCellHasButton,true); var_Column.Alignment = EXLISTLib.AlignmentEnum.CenterAlignment; var_Column.HeaderAlignment = EXLISTLib.AlignmentEnum.CenterAlignment; var_Column.FormatColumn = "` ... `"; var_Column.Width = 32; var_Column.AllowSizing = false; var_Column.Position = 0; axList1.SelBackMode = EXLISTLib.BackModeEnum.exTransparent; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); axList1.EndUpdate();
549	How do I set an extra data for each item // MouseMove event - Occurs when the user moves the mouse. private void axList1_MouseMoveEvent(object sender, AxEXLISTLib._IListEvents_MouseMoveEvent e) { int i = axList1.get_ItemFromPoint(-1,-1,c,hit); System.Diagnostics.Debug.Print( i.ToString() ); System.Diagnostics.Debug.Print( axList1.Items.get_ItemData(i).ToString() ); } //this.axList1.MouseMoveEvent += new AxEXLISTLib._IListEvents_MouseMoveEventHandler(this.axList1_MouseMoveEvent); axList1.BeginUpdate(); axList1.ColumnAutoResize = true; axList1.Columns.Add("Default"); EXLISTLib.Items var_Items = axList1.Items; var_Items.set_ItemData(var_Items.Add("method"),"your extra data of method"); axList1.EndUpdate();
548	I do not like to specify the item padding for every column I add. The question is how can I do it automatically axList1.BeginUpdate(); axList1.AttachTemplate("handle AddColumn(Column){Column{Def(48)=8;Def(49)=8;AllowDragging=False;AllowSizing = True}}"); axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines; axList1.GridLineStyle = EXLISTLib.GridLinesStyleEnum.exGridLinesVSolid; EXLISTLib.Columns var_Columns = axList1.Columns; var_Columns.Add("Item"); EXLISTLib.Column var_Column = (var_Columns.Add("Pos") as EXLISTLib.Column); var_Column.Position = 0; var_Column.Width = 32; var_Column.AllowSizing = false; var_Column.FormatColumn = "1 index ``"; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.EndUpdate();
547	Can I sort the column by check-state axList1.BeginUpdate(); EXLISTLib.Column var_Column = (axList1.Columns.Add("Check") as EXLISTLib.Column); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.SortType = EXLISTLib.SortTypeEnum.exSortByState; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add(null); var_Items.set_CellState(var_Items.Add(null),0,1); var_Items.set_CellState(var_Items.Add(null),0,1); var_Items.Add(null); axList1.Columns[0].SortOrder = EXLISTLib.SortOrderEnum.SortAscending; axList1.EndUpdate();
546	Can I sort the column by image axList1.BeginUpdate(); axList1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXLISTLib.Column var_Column = (axList1.Columns.Add("Image") as EXLISTLib.Column); var_Column.SortType = EXLISTLib.SortTypeEnum.exSortByImage; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_CellImage(var_Items.Add(null),0,3); var_Items.Add(null); var_Items.set_CellImage(var_Items.Add(null),0,1); var_Items.set_CellImage(var_Items.Add(null),0,2); axList1.Columns[0].SortOrder = EXLISTLib.SortOrderEnum.SortAscending; axList1.EndUpdate();
545	How can I display UNICODE characters axList1.BeginUpdate(); stdole.IFontDisp var_StdFont = axList1.Font; var_StdFont.Name = "Arial Unicode"; var_StdFont.Size = 22; axList1.HeaderVisible = false; axList1.DefaultItemHeight = 48; (axList1.Columns.Add("") as EXLISTLib.Column).set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Ӓӓ"); var_Items.Add("ᦜᦝ;ᦞ"); var_Items.Add("ɮɭ;ɯ"); var_Items.Add("勳勴勵勶"); var_Items.set_FormatCell(var_Items.Add(axList1.Version),0,"(value lfind `UNICODE`) < 0 ? `<fgcolor=FF0000><b>!UNICODE!</b> version</fgcolor> required: ` + value : `` "); axList1.EndUpdate();
544	How do I display the position of the item with 0-padding axList1.BeginUpdate(); (axList1.Columns.Add("Items") as EXLISTLib.Column).FormatColumn = "((1 apos ``) lpad `00`) + `. ` + value"; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); var_Items.Add("Item D"); axList1.EndUpdate();
543	I am skinning the control's header-bar, but the background of the header-bar is shown on each item in the filter-bar drop down panel. What can I do axList1.BeginUpdate(); EXLISTLib.Appearance var_Appearance = axList1.VisualAppearance; var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxRDgMQBQKAAzQFAYcBqGqGAAGQZxYgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH" + "LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQGhsCYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU8lORLUi+M4zSBPcZVTRtGShPDB" + "KTjMKKYgkG4lVpRNa0PC1GTzQ6mazkKQLRADDIDVbAeL3LiMBy9LyLLItQALByua5mWhbcZyBCOPgBTrRb5zO58FjuTK7YLjMB7NrUNYtFaUMy2OpOCADIaecTNcaWLx" + "PF2MY1HWYxVj2Jw3DuRJonKYBgggSRAlIYw6B0ThGFgPAkFUDAhBMfZRiGNAkFECZnm4YQdneJwqnsSQrGAAhWAIJBJBIQgFCQIBiEIAglgqYo0i4V4MEgRI9gSToYFS" + "b4Fk6Y4+BmBZhFOJgTC8TBogQAArgqco4muCZOkOMJtgmYpIjYKg7GKE4uCUK4AAKKg2DwI4DiCZw5k6KJ2D6D4OHiag4DwIxiiQAArAqMosnEPBPAOIhOg+DozjIJ4P" + "GSY4iEwPAkhKLhHUUSQsnKFCnkYU9MjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" + "ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" + "sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" + "pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" + "MR1EOZxWi+bx7HcWQ8msfRYnnDhQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARViHH" + "4HQOYmxuCpF2MsecEQVBvGQCcIQvA6i2CAAIARAQ="); var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzQFAYcBqGqGAAGQZxYgmFgAQhFcZQSKUOQTDKMIziYBYJhEMwwDhEIwjHCEEhsGIbJAGQBJCjWGodQLOEgzN" + "C0IxNFCQILhEZJADKII8TTOU5UPRESwTE4cKBmKhQCo2NpKR7VUTxCKQahLLivoCjBT8EzHMqtIzrCA6MpaP4pQjKcqwHJ8YyHEi0ZrjazKaj6T5AXDUcaWbbNVx3PK3" + "aioOpLZrqOZZYzYFoABTuJzPMSyIhxXD8cweaZvSpLExVYK9BY3PbKMgxC77QgTIpDaQMNS6PjtF43PAALLFUaNYzoOKzABMHATBIXAYJCwIIR5G7ID4BbQcCQAHL9DB" + "aEEIAEEISgGhMGZQmocgymmIRQkIEQ2BcGgbEIRQci8XaMBqTRVgSAZHG+S5pnOep+D6f4vjec5zn0fpfmgBgAH6TRoBYBoAh+eAmAiAgPFgNArgOQpIESdoEmCOAOAq" + "BYfFGAgaEaBgYHYFYFmIB5UiGCJUgKCgmgeYoHk4BgCmKRQiCwApgHgYgyH8B54lQU4NkMeJlBoDgjkiXBTg0R54iYIR+koeQVBoKpkgkChKhEJBkF4SFEjkDgJhFQoe" + "EmDJlBeehUhWJQJGIXoICWOQ6FeFIlhkfhlDsSJpiQVoamaSY2G6G5nAmRhpCOH5pkwVYdmeCZmHqHpnkmdhzhmaAIFiax8AABAEICA=="); (axList1.GetOcx() as EXLISTLib.List).BackColorHeader = 0x1000000; axList1.ForeColorHeader = Color.FromArgb(128,128,128); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exHeaderFilterBarButton,0x2000000); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exBackColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,255,255))); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exForeColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,1))); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exSelBackColorFilter,0x1ff8000); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exSelForeColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240))); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exCursorHoverColumn,-1); axList1.HeaderHeight = 24; axList1.BackColorLevelHeader = axList1.BackColor; EXLISTLib.Column var_Column = (axList1.Columns.Add("Filter") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterPattern = false; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; var_Column.set_Def(EXLISTLib.DefColumnEnum.exHeaderPaddingLeft,2); var_Column.set_Def(EXLISTLib.DefColumnEnum.exHeaderPaddingRight,2); EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("A"); var_Items.Add("B"); var_Items.Add("C"); var_Items.Add("D"); axList1.EndUpdate();
542	Type of wraps the cell's caption support (Sample 2) axList1.BeginUpdate(); axList1.HeaderSingleLine = false; axList1.HeaderHeight = 36; axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines; axList1.ColumnAutoResize = false; axList1.ScrollBySingleLine = true; EXLISTLib.Columns var_Columns = axList1.Columns; EXLISTLib.Column var_Column = (var_Columns.Add("Single-Line (exCaptionSingleLine)") as EXLISTLib.Column); var_Column.Width = 96; var_Column.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCellSingleLine,-1); EXLISTLib.Column var_Column1 = (var_Columns.Add("Word-Wrap (exCaptionWordWrap)") as EXLISTLib.Column); var_Column1.Width = 96; var_Column1.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column1.set_Def(EXLISTLib.DefColumnEnum.exCellSingleLine,0); var_Column1.FormatColumn = "%0"; EXLISTLib.Column var_Column2 = (var_Columns.Add("Break-Wrap (exCaptionBreakWrap)") as EXLISTLib.Column); var_Column2.Width = 96; var_Column2.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column2.set_Def(EXLISTLib.DefColumnEnum.exCellSingleLine,1); var_Column2.FormatColumn = "%0"; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line."); var_Items.Add("This is the <b>first</b> line.\\r\\nThis is the <b>second</b> line.\\r\\nThis is the <b>third</b> line."); axList1.EndUpdate();
541	Type of wraps the cell's caption support (Sample 1) axList1.BeginUpdate(); axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines; axList1.ColumnAutoResize = false; axList1.ScrollBySingleLine = true; (axList1.Columns.Add("Default") as EXLISTLib.Column).Width = 128; EXLISTLib.Items var_Items = axList1.Items; int h = var_Items.Add("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); h = var_Items.Add("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line."); var_Items.set_CaptionFormat(h,0,EXLISTLib.CaptionFormatEnum.exHTML); h = var_Items.Add("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); var_Items.set_CellSingleLine(h,0,EXLISTLib.CellSingleLineEnum.exCaptionWordWrap); h = var_Items.Add("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line."); var_Items.set_CaptionFormat(h,0,EXLISTLib.CaptionFormatEnum.exHTML); var_Items.set_CellSingleLine(h,0,EXLISTLib.CellSingleLineEnum.exCaptionWordWrap); h = var_Items.Add("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); var_Items.set_CellSingleLine(h,0,EXLISTLib.CellSingleLineEnum.exCaptionBreakWrap); h = var_Items.Add("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line."); var_Items.set_CaptionFormat(h,0,EXLISTLib.CaptionFormatEnum.exHTML); var_Items.set_CellSingleLine(h,0,EXLISTLib.CellSingleLineEnum.exCaptionBreakWrap); axList1.EndUpdate();
540	Can I break the cell's caption using the line break <br> or \r\n (Sample 2) axList1.BeginUpdate(); axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines; axList1.ColumnAutoResize = false; axList1.ScrollBySingleLine = true; (axList1.Columns.Add("Default") as EXLISTLib.Column).Width = 128; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_CellSingleLine(var_Items.Add("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."),0,EXLISTLib.CellSingleLineEnum.exCaptionBreakWrap); var_Items.Add("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); axList1.EndUpdate();
539	Can I break the cell's caption using the line break <br> or \r\n (Sample 1) axList1.BeginUpdate(); axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines; axList1.ColumnAutoResize = false; axList1.ScrollBySingleLine = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Default") as EXLISTLib.Column); var_Column.Width = 128; var_Column.set_Def(EXLISTLib.DefColumnEnum.exCellSingleLine,1); EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); var_Items.Add("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."); axList1.EndUpdate();
538	How can I change the visual appearance/color of the Filter For ... field axList1.BeginUpdate(); axList1.BackColorHeader = Color.FromArgb(1,0,0); axList1.ForeColorHeader = Color.FromArgb(255,255,255); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exBackColorFilter,axList1.BackColorHeader); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exForeColorFilter,axList1.ForeColorHeader); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exHeaderFilterBarButton,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240))); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exCursorHoverColumn,-1); axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Bump; EXLISTLib.Column var_Column = (axList1.Columns.Add("Items") as EXLISTLib.Column); var_Column.FilterOnType = true; var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exNoItems; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); axList1.EndUpdate();
537	How can I display the cell's caption without spaces on both sides axList1.BeginUpdate(); axList1.ColumnAutoResize = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Default") as EXLISTLib.Column); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column.FormatColumn = "((trim(value) replace ` ` with ` `) replace ` ` with ` `) replace ` ` with `<bgcolor=FF0000> </bgcolor>`"; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add(""); var_Items.Add("Item A"); var_Items.Add(" Item B"); var_Items.Add(" Item C "); axList1.EndUpdate();
536	How can I highlight the spaces within the column (sample 2) axList1.BeginUpdate(); axList1.ColumnAutoResize = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Default") as EXLISTLib.Column); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column.FormatColumn = "`'` + ( value replace ` ` with `_` ) + `'`"; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add(""); var_Items.Add("Item A"); var_Items.Add(" Item B"); var_Items.Add(" Item C "); axList1.EndUpdate();
535	How can I highlight the spaces within the column (sample 1) axList1.BeginUpdate(); axList1.ColumnAutoResize = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Default") as EXLISTLib.Column); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column.FormatColumn = "len(value) = 0 ? `<bgcolor=FF0000> </bgcolor>` : ( value replace ` ` with `<bgcolor=FF0000> </bgcolor>` )"; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add(""); var_Items.Add("Item A"); var_Items.Add(" Item B"); var_Items.Add(" Item C "); axList1.EndUpdate();
534	How can I change the visual aspect of the drop down filter-calendar axList1.BeginUpdate(); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exBackColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,1))); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exForeColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,255,255))); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exDateScrollRange,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,255,255))); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exDateHeader,axList1.get_Background(EXLISTLib.BackgroundPartEnum.exBackColorFilter)); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exDateScrollThumb,(uint)ColorTranslator.ToWin32(Color.FromArgb(128,128,128))); EXLISTLib.Column var_Column = (axList1.Columns.Add("Date") as EXLISTLib.Column); var_Column.FilterType = EXLISTLib.FilterTypeEnum.exDate; var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; var_Column.DisplayFilterPattern = false; axList1.EndUpdate();
533	Export Data in HTML format axList1.BeginUpdate(); axList1.BackColorAlternate = Color.FromArgb(240,240,240); axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines; axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " + "`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" + "hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" + "nt + ` item(s)`) )))"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCompact \| EXLISTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired \| EXLISTLib.FilterBarVisibleEnum.exFilterBarSingleLine \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.FilterBarPromptType = EXLISTLib.FilterPromptEnum.exFilterPromptContainsAny; EXLISTLib.ConditionalFormats var_ConditionalFormats = axList1.ConditionalFormats; var_ConditionalFormats.Add("%0 like `AA`","aa").BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(192,192,192)); EXLISTLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%0 like `D`","d"); var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128)); var_ConditionalFormat.ApplyTo = EXLISTLib.FormatApplyToEnum.exFormatToColumns; EXLISTLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%0 like `b`","b"); var_ConditionalFormat1.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,255)); var_ConditionalFormat1.Bold = true; var_ConditionalFormat1.Italic = true; var_ConditionalFormat1.ApplyTo = EXLISTLib.FormatApplyToEnum.exFormatToColumns; EXLISTLib.Columns var_Columns = axList1.Columns; EXLISTLib.Column var_Column = (var_Columns.Add("Value") as EXLISTLib.Column); var_Column.Width = 128; var_Column.HTMLCaption = "<b>VA</b><r>sko"; EXLISTLib.Column var_Column1 = (var_Columns.Add("APos") as EXLISTLib.Column); var_Column1.FormatColumn = "0 apos ``"; var_Column1.AllowSort = false; var_Column1.set_Def(EXLISTLib.DefColumnEnum.exCellBackColor,15790320); var_Column1.set_Def(EXLISTLib.DefColumnEnum.exCellForeColor,8421504); var_Column1.set_Def(EXLISTLib.DefColumnEnum.exHeaderForeColor,var_Column1.get_Def(EXLISTLib.DefColumnEnum.exCellForeColor)); var_Column1.Position = 0; EXLISTLib.Column var_Column2 = (var_Columns.Add("RPos") as EXLISTLib.Column); var_Column2.FormatColumn = "0 rpos ``"; var_Column2.AllowSort = false; var_Column2.Position = 1; EXLISTLib.Column var_Column3 = (var_Columns.Add("Index") as EXLISTLib.Column); var_Column3.FormatColumn = "0 index ``"; var_Column3.DisplayFilterButton = true; var_Column3.FilterList = EXLISTLib.FilterListEnum.exShowCheckBox; var_Column3.Position = 2; EXLISTLib.Column var_Column4 = (var_Columns.Add("Data 1") as EXLISTLib.Column); var_Column4.FormatColumn = "0 index `A-Z`"; var_Column4.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); EXLISTLib.Column var_Column5 = (var_Columns.Add("Data 2") as EXLISTLib.Column); var_Column5.FormatColumn = "0 index `AB` replace `A` with `<off -4>A</off>`"; var_Column5.set_Def(EXLISTLib.DefColumnEnum.exCellSingleLine,false); var_Column5.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column5.set_Def(EXLISTLib.DefColumnEnum.exCellHasRadioButton,true); EXLISTLib.Column var_Column6 = (var_Columns.Add("Data 3") as EXLISTLib.Column); var_Column6.FormatColumn = "0 index `CDC` replace `D` with `<b>D</b>`"; var_Column6.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); var_Items.set_CellState(2,4,1); var_Items.Add("Item AA"); var_Items.Add("Item BB"); var_Items.Add("Item CC"); var_Items.set_CellState(5,5,1); var_Items.Add("Item D"); var_Items.Add("Item EE"); var_Items.Add("Item FFF"); axList1.EndUpdate(); string sFile = "c:/temp/export.html"; axList1.Export(sFile,"vis"); // Add 'Microsoft Internet Controls(ieframe.dll)' reference to your project. SHDocVw.ShellBrowserWindow var_ShellBrowserWindow = new SHDocVw.ShellBrowserWindow(); var_ShellBrowserWindow.Navigate2(sFile,null,null,null,null);
532	Export Data in CSV format axList1.BeginUpdate(); axList1.BackColorAlternate = Color.FromArgb(240,240,240); axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines; axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " + "`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" + "hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" + "nt + ` item(s)`) )))"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCompact \| EXLISTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired \| EXLISTLib.FilterBarVisibleEnum.exFilterBarSingleLine \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.FilterBarPromptType = EXLISTLib.FilterPromptEnum.exFilterPromptContainsAny; EXLISTLib.ConditionalFormats var_ConditionalFormats = axList1.ConditionalFormats; var_ConditionalFormats.Add("%0 like `AA`","aa").BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(192,192,192)); EXLISTLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%0 like `D`","d"); var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128)); var_ConditionalFormat.ApplyTo = EXLISTLib.FormatApplyToEnum.exFormatToColumns; EXLISTLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%0 like `b`","b"); var_ConditionalFormat1.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,255)); var_ConditionalFormat1.Bold = true; var_ConditionalFormat1.Italic = true; var_ConditionalFormat1.ApplyTo = EXLISTLib.FormatApplyToEnum.exFormatToColumns; EXLISTLib.Columns var_Columns = axList1.Columns; EXLISTLib.Column var_Column = (var_Columns.Add("Value") as EXLISTLib.Column); var_Column.Width = 128; var_Column.HTMLCaption = "<b>VA</b><r>sko"; EXLISTLib.Column var_Column1 = (var_Columns.Add("APos") as EXLISTLib.Column); var_Column1.FormatColumn = "0 apos ``"; var_Column1.AllowSort = false; var_Column1.set_Def(EXLISTLib.DefColumnEnum.exCellBackColor,15790320); var_Column1.set_Def(EXLISTLib.DefColumnEnum.exCellForeColor,8421504); var_Column1.set_Def(EXLISTLib.DefColumnEnum.exHeaderForeColor,var_Column1.get_Def(EXLISTLib.DefColumnEnum.exCellForeColor)); var_Column1.Position = 0; EXLISTLib.Column var_Column2 = (var_Columns.Add("RPos") as EXLISTLib.Column); var_Column2.FormatColumn = "0 rpos ``"; var_Column2.AllowSort = false; var_Column2.Position = 1; EXLISTLib.Column var_Column3 = (var_Columns.Add("Index") as EXLISTLib.Column); var_Column3.FormatColumn = "0 index ``"; var_Column3.DisplayFilterButton = true; var_Column3.FilterList = EXLISTLib.FilterListEnum.exShowCheckBox; var_Column3.Position = 2; EXLISTLib.Column var_Column4 = (var_Columns.Add("Data 1") as EXLISTLib.Column); var_Column4.FormatColumn = "0 index `A-Z`"; var_Column4.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); EXLISTLib.Column var_Column5 = (var_Columns.Add("Data 2") as EXLISTLib.Column); var_Column5.FormatColumn = "0 index `AB` replace `A` with `<off -4>A</off>`"; var_Column5.set_Def(EXLISTLib.DefColumnEnum.exCellSingleLine,false); var_Column5.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column5.set_Def(EXLISTLib.DefColumnEnum.exCellHasRadioButton,true); EXLISTLib.Column var_Column6 = (var_Columns.Add("Data 3") as EXLISTLib.Column); var_Column6.FormatColumn = "0 index `CDC` replace `D` with `<b>D</b>`"; var_Column6.set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1); EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); var_Items.set_CellState(2,4,1); var_Items.Add("Item AA"); var_Items.Add("Item BB"); var_Items.Add("Item CC"); var_Items.set_CellState(5,5,1); var_Items.Add("Item D"); var_Items.Add("Item EE"); var_Items.Add("Item FFF"); axList1.EndUpdate(); System.Diagnostics.Debug.Print( axList1.Export("","vis").ToString() );
531	How can I get the icon from the cell when using the Items.CellImages property (icon index) // MouseMove event - Occurs when the user moves the mouse. private void axList1_MouseMoveEvent(object sender, AxEXLISTLib._IListEvents_MouseMoveEvent e) { int i = axList1.get_ItemFromPoint(-1,-1,c,hit); System.Diagnostics.Debug.Print( axList1.FormatABC("( 0x44 = ( value bitand 0x44 ) ) ? ( ( (value bitand 0xFFFF0000) bitshift 16 ) array B split `,` ) : `no image`",hit,axList1.Items.get_CellImages(i,c),null).ToString() ); } //this.axList1.MouseMoveEvent += new AxEXLISTLib._IListEvents_MouseMoveEventHandler(this.axList1_MouseMoveEvent); axList1.BeginUpdate(); axList1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); axList1.Columns.Add("Default"); EXLISTLib.Items var_Items = axList1.Items; var_Items.set_CellImages(var_Items.Add("Item 1"),0,"3,2,1"); var_Items.set_CellImages(var_Items.Add("Item 2"),0,"2,3"); var_Items.set_CellImages(var_Items.Add("Item 3"),0,"2,"); axList1.EndUpdate();
530	How can I get the icon from the cell when using the Items.CellImages property (icon position within the cell) // MouseMove event - Occurs when the user moves the mouse. private void axList1_MouseMoveEvent(object sender, AxEXLISTLib._IListEvents_MouseMoveEvent e) { int i = axList1.get_ItemFromPoint(-1,-1,c,hit); System.Diagnostics.Debug.Print( axList1.FormatABC("( 0x44 = ( value bitand 0x44 ) ) ? 1 + ( (value bitand 0xFFFF0000) bitshift 16 ) : `no image`",hit,null,null).ToString() ); } //this.axList1.MouseMoveEvent += new AxEXLISTLib._IListEvents_MouseMoveEventHandler(this.axList1_MouseMoveEvent); axList1.BeginUpdate(); axList1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); axList1.Columns.Add("Default"); EXLISTLib.Items var_Items = axList1.Items; var_Items.set_CellImages(var_Items.Add("Item 1"),0,"3,2,1"); var_Items.set_CellImages(var_Items.Add("Item 2"),0,"2,3"); var_Items.set_CellImages(var_Items.Add("Item 3"),0,"2"); axList1.EndUpdate();
529	How can I get the index of icon from the cell, if using the CellImages property // MouseMove event - Occurs when the user moves the mouse. private void axList1_MouseMoveEvent(object sender, AxEXLISTLib._IListEvents_MouseMoveEvent e) { int i = axList1.get_ItemFromPoint(-1,-1,c,hit); System.Diagnostics.Debug.Print( axList1.FormatABC("( 0x44 = ( value bitand 0x44 ) ) ? 1 + ( (value bitand 0xFFFF0000) bitshift 16 ) : `no image`",hit,null,null).ToString() ); } //this.axList1.MouseMoveEvent += new AxEXLISTLib._IListEvents_MouseMoveEventHandler(this.axList1_MouseMoveEvent); axList1.BeginUpdate(); axList1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); axList1.Columns.Add("Default"); EXLISTLib.Items var_Items = axList1.Items; var_Items.set_CellImages(var_Items.Add("Item 1"),0,"1,2,3"); var_Items.set_CellImages(var_Items.Add("Item 2"),0,"2,3,1"); var_Items.set_CellImages(var_Items.Add("Item 3"),0,"3,2,1"); axList1.EndUpdate();
528	Is it possible to change the visual appearance of the position signs when user changes the column's position by drag and drop axList1.BeginUpdate(); axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched; EXLISTLib.Columns var_Columns = axList1.Columns; var_Columns.Add("Column 1"); var_Columns.Add("Column 2"); var_Columns.Add("Column 3"); EXLISTLib.Appearance var_Appearance = axList1.VisualAppearance; var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzV" + "IUcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4" + "aDhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DB" + "eEMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDI" + "BICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAok" + "GKHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhulRGHKGoImefh0BUZ4JmYeoemeSZ2H6HQmgoBgXDqXwUAQgI="); var_Appearance.Add(2,"CP:1 0 -36 0 0"); axList1.set_Background(EXLISTLib.BackgroundPartEnum.exColumnsPositionSign,0x2000000); axList1.EndUpdate();
527	A black portion is shown while I am using the BackColorAlternate with EBN colors. What can I do axList1.BeginUpdate(); axList1.ColumnAutoResize = true; axList1.DefaultItemHeight = 20; axList1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhIDhAxHAxg0HG0Mg4xGI3HMOig3GcJiYAf8jAEhhUnAAyhEqg8hk0oAsIjgAiAwmYxGA4mYzGwwkI0i0ooUnB0IBMIl1Dg8zmYyGolptPkI1m" + "Y1GAll9KoUslNIrVCqNQldShFUstXAVfrVcrlZtVhuFnsUHq1zoczoQGhFBkNpg6zbDykUkhsPHE2h85nc9n8xtVDtlex9Msd2p1YstVq9ux8HyMtzuFz1PsNTzQlv2h" + "hWfkuqpeVuN0q+nvEooN5veSAGpkb/ACcZrvhU3w83nM/poxGuchGpoVBvWgg+8knA4WimnFxI45Er5XOlHMg/Q3XU33W4ew9Wyu11mchDagcO7zus8VDoNBBEIKBpMY" + "6DqOQyokhA/IQIQmwMk4bIQFDcoO6LWgwhQkNcABwEyAB5GwWbet6cRQg3DENQ5D8QxADZvEkAB8nabsURGeBpFM3pwE2AEZRpDx/neZpOR3Dz9oO/r/wCMoZNTBQAQR" + "JSEwYg8HPGhEIoNCaEwq10gQ2WcRt7LcRxRFpuxUAEURQ3sczBEMgTTG8gN7HpOSEAEiQBAQZpmQ0DibPUFwbKcHwkhQoQtNQNzNEMbABOKDy/DMYQzHLeoPL0OTJSUd" + "0pHcxTewk5zrIygIRPslz4lEngBKIAQivgASs/kLSBTlO00f8t0vGcgUbDlDRjXLCUNRERRvRgAHW2oAICA=="); (axList1.Columns.Add("Default") as EXLISTLib.Column).set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); EXLISTLib.Column var_Column = (axList1.Columns.Add("Position") as EXLISTLib.Column); var_Column.FormatColumn = "1 rindex ``"; var_Column.Visible = false; EXLISTLib.ConditionalFormat var_ConditionalFormat = axList1.ConditionalFormats.Add("%C1 mod 2",null); var_ConditionalFormat.BackColor = 0x1000000; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.Add("Item 4"); axList1.EndUpdate();
526	Is it possible to change the caption from a column without to remove the column and add it with the new caption (axList1.Columns.Add("ColumnName") as EXLISTLib.Column).Caption = "NewName"; (axList1.Columns.Add("ColumnName") as EXLISTLib.Column).HTMLCaption = "<b>New</b>Name";
525	FilterBarCaption ALL Keyword ( sample 2, result ) // AddItem event - Occurs after a new Item is inserted to Items collection. private void axList1_AddItem(object sender, AxEXLISTLib._IListEvents_AddItemEvent e) { // i = FormatABC("value + 1", Items.ItemToIndex(Item)) axList1.Items.set_CellImage(e.item,3,i); } //this.axList1.AddItem += new AxEXLISTLib._IListEvents_AddItemEventHandler(this.axList1_AddItem); axList1.BeginUpdate(); axList1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXLISTLib.Column var_Column = (axList1.Columns.Add("Col-1") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Col-2") as EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Check") as EXLISTLib.Column); var_Column2.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXLISTLib.FilterTypeEnum.exCheck; EXLISTLib.Column var_Column3 = (axList1.Columns.Add("Image") as EXLISTLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXLISTLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox; EXLISTLib.Column var_Column4 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_Caption(var_Items.Add("Item A"),1,"Sub-Item A"); int h = var_Items.Add("Item B"); var_Items.set_Caption(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_Caption(var_Items.Add("Item C"),1,"Sub-Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "(( ( all replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `[" + "<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matchi" + "temcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount" + " + ` item(s)`) )))"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column5 = axList1.Columns[0]; var_Column5.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A\|Item B"; axList1.Columns[2].Filter = 1.ToString(); axList1.ApplyFilter(); axList1.EndUpdate();
524	FilterBarCaption ALL Keyword ( sample 1 ) // AddItem event - Occurs after a new Item is inserted to Items collection. private void axList1_AddItem(object sender, AxEXLISTLib._IListEvents_AddItemEvent e) { // i = FormatABC("value + 1", Items.ItemToIndex(Item)) axList1.Items.set_CellImage(e.item,3,i); } //this.axList1.AddItem += new AxEXLISTLib._IListEvents_AddItemEventHandler(this.axList1_AddItem); axList1.BeginUpdate(); axList1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXLISTLib.Column var_Column = (axList1.Columns.Add("Col-1") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Col-2") as EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Check") as EXLISTLib.Column); var_Column2.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXLISTLib.FilterTypeEnum.exCheck; EXLISTLib.Column var_Column3 = (axList1.Columns.Add("Image") as EXLISTLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXLISTLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox; EXLISTLib.Column var_Column4 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_Caption(var_Items.Add("Item A"),1,"Sub-Item A"); int h = var_Items.Add("Item B"); var_Items.set_Caption(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_Caption(var_Items.Add("Item C"),1,"Sub-Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "all"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column5 = axList1.Columns[0]; var_Column5.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A\|Item B"; axList1.Columns[2].Filter = 1.ToString(); axList1.ApplyFilter(); axList1.EndUpdate();
523	FilterBarCaption ALLUI Keyword ( sample 2, result ) // AddItem event - Occurs after a new Item is inserted to Items collection. private void axList1_AddItem(object sender, AxEXLISTLib._IListEvents_AddItemEvent e) { // i = FormatABC("value + 1", Items.ItemToIndex(Item)) axList1.Items.set_CellImage(e.item,3,i); } //this.axList1.AddItem += new AxEXLISTLib._IListEvents_AddItemEventHandler(this.axList1_AddItem); axList1.BeginUpdate(); axList1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXLISTLib.Column var_Column = (axList1.Columns.Add("Col-1") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Col-2") as EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Check") as EXLISTLib.Column); var_Column2.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXLISTLib.FilterTypeEnum.exCheck; EXLISTLib.Column var_Column3 = (axList1.Columns.Add("Image") as EXLISTLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXLISTLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox; EXLISTLib.Column var_Column4 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_Caption(var_Items.Add("Item A"),1,"Sub-Item A"); int h = var_Items.Add("Item B"); var_Items.set_Caption(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_Caption(var_Items.Add("Item C"),1,"Sub-Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " + "`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` ) + `<r><fgcolor=808080>` + ( matc" + "hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" + "nt + ` item(s)`) )))"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column5 = axList1.Columns[0]; var_Column5.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A\|Item B"; axList1.Columns[2].Filter = 1.ToString(); axList1.ApplyFilter(); axList1.EndUpdate();
522	FilterBarCaption ALLUI Keyword ( sample 1 ) // AddItem event - Occurs after a new Item is inserted to Items collection. private void axList1_AddItem(object sender, AxEXLISTLib._IListEvents_AddItemEvent e) { // i = FormatABC("value + 1", Items.ItemToIndex(Item)) axList1.Items.set_CellImage(e.item,3,i); } //this.axList1.AddItem += new AxEXLISTLib._IListEvents_AddItemEventHandler(this.axList1_AddItem); axList1.BeginUpdate(); axList1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXLISTLib.Column var_Column = (axList1.Columns.Add("Col-1") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Col-2") as EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Check") as EXLISTLib.Column); var_Column2.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXLISTLib.FilterTypeEnum.exCheck; EXLISTLib.Column var_Column3 = (axList1.Columns.Add("Image") as EXLISTLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXLISTLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox; EXLISTLib.Column var_Column4 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_Caption(var_Items.Add("Item A"),1,"Sub-Item A"); int h = var_Items.Add("Item B"); var_Items.set_Caption(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_Caption(var_Items.Add("Item C"),1,"Sub-Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "allui"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column5 = axList1.Columns[0]; var_Column5.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A\|Item B"; axList1.Columns[2].Filter = 1.ToString(); axList1.ApplyFilter(); axList1.EndUpdate();
521	FilterBarCaption AVAILABLE Keyword ( sample 2, result ) // AddItem event - Occurs after a new Item is inserted to Items collection. private void axList1_AddItem(object sender, AxEXLISTLib._IListEvents_AddItemEvent e) { // i = FormatABC("value + 1", Items.ItemToIndex(Item)) axList1.Items.set_CellImage(e.item,3,i); } //this.axList1.AddItem += new AxEXLISTLib._IListEvents_AddItemEventHandler(this.axList1_AddItem); axList1.BeginUpdate(); axList1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXLISTLib.Column var_Column = (axList1.Columns.Add("Col-1") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Col-2") as EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Check") as EXLISTLib.Column); var_Column2.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXLISTLib.FilterTypeEnum.exCheck; EXLISTLib.Column var_Column3 = (axList1.Columns.Add("Image") as EXLISTLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXLISTLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox; EXLISTLib.Column var_Column4 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_Caption(var_Items.Add("Item A"),1,"Sub-Item A"); int h = var_Items.Add("Item B"); var_Items.set_Caption(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_Caption(var_Items.Add("Item C"),1,"Sub-Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "(( ( value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` ) + ` ` + ( ava" + "ilable replace `[` with `<bgcolor=C0C0C0><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` replace `<s>` with `" + "` replace `</s>` with `` ) + `<fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount" + " + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount + ` item(s)`) )))"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column5 = axList1.Columns[0]; var_Column5.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A\|Item B"; axList1.Columns[2].Filter = 1.ToString(); axList1.ApplyFilter(); axList1.EndUpdate();
520	FilterBarCaption AVAILABLE Keyword ( sample 1 ) // AddItem event - Occurs after a new Item is inserted to Items collection. private void axList1_AddItem(object sender, AxEXLISTLib._IListEvents_AddItemEvent e) { // i = FormatABC("value + 1", Items.ItemToIndex(Item)) axList1.Items.set_CellImage(e.item,3,i); } //this.axList1.AddItem += new AxEXLISTLib._IListEvents_AddItemEventHandler(this.axList1_AddItem); axList1.BeginUpdate(); axList1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" + "lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" + "0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); EXLISTLib.Column var_Column = (axList1.Columns.Add("Col-1") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Col-2") as EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Check") as EXLISTLib.Column); var_Column2.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column2.DisplayFilterButton = true; var_Column2.DisplayFilterPattern = false; var_Column2.FilterType = EXLISTLib.FilterTypeEnum.exCheck; EXLISTLib.Column var_Column3 = (axList1.Columns.Add("Image") as EXLISTLib.Column); var_Column3.DisplayFilterButton = true; var_Column3.FilterType = EXLISTLib.FilterTypeEnum.exImage; var_Column3.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox; EXLISTLib.Column var_Column4 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column4.AllowSizing = false; var_Column4.AllowSort = false; var_Column4.Width = 32; var_Column4.FormatColumn = "1 apos ``"; var_Column4.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_Caption(var_Items.Add("Item A"),1,"Sub-Item A"); int h = var_Items.Add("Item B"); var_Items.set_Caption(h,1,"Sub-Item B"); var_Items.set_CellState(h,2,1); var_Items.set_Caption(var_Items.Add("Item C"),1,"Sub-Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "value + ` ` + available"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column5 = axList1.Columns[0]; var_Column5.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column5.Filter = "Item A\|Item B"; axList1.Columns[2].Filter = 1.ToString(); axList1.ApplyFilter(); axList1.EndUpdate();
519	Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 3, results ) axList1.BeginUpdate(); EXLISTLib.Column var_Column = (axList1.Columns.Add("Col-1") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Col-2") as EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column2.AllowSizing = false; var_Column2.AllowSort = false; var_Column2.Width = 32; var_Column2.FormatColumn = "1 apos ``"; var_Column2.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_Caption(var_Items.Add("Item A"),1,"Sub-Item A"); var_Items.set_Caption(var_Items.Add("Item B"),1,"Sub-Item B"); var_Items.set_Caption(var_Items.Add("Item C"),1,"Sub-Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "(`<b>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) +" + " ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )) replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replac" + "e `]` with ` </b></bgcolor></fgcolor>`"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarToggle; EXLISTLib.Column var_Column3 = axList1.Columns[0]; var_Column3.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column3.Filter = "Item A\|Item B"; EXLISTLib.Column var_Column4 = axList1.Columns[1]; var_Column4.FilterType = EXLISTLib.FilterTypeEnum.exPattern; var_Column4.Filter = "*B"; axList1.ApplyFilter(); axList1.EndUpdate();
518	Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 2 ) axList1.BeginUpdate(); EXLISTLib.Column var_Column = (axList1.Columns.Add("Col-1") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Col-2") as EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column2.AllowSizing = false; var_Column2.AllowSort = false; var_Column2.Width = 32; var_Column2.FormatColumn = "1 apos ``"; var_Column2.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_Caption(var_Items.Add("Item A"),1,"Sub-Item A"); var_Items.set_Caption(var_Items.Add("Item B"),1,"Sub-Item B"); var_Items.set_Caption(var_Items.Add("Item C"),1,"Sub-Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>`"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarToggle; EXLISTLib.Column var_Column3 = axList1.Columns[0]; var_Column3.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column3.Filter = "Item A\|Item B"; EXLISTLib.Column var_Column4 = axList1.Columns[1]; var_Column4.FilterType = EXLISTLib.FilterTypeEnum.exPattern; var_Column4.Filter = "*B"; axList1.ApplyFilter(); axList1.EndUpdate();
517	Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 1 ) axList1.BeginUpdate(); EXLISTLib.Column var_Column = (axList1.Columns.Add("Col-1") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Col-2") as EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column2 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column2.AllowSizing = false; var_Column2.AllowSort = false; var_Column2.Width = 32; var_Column2.FormatColumn = "1 apos ``"; var_Column2.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.set_Caption(var_Items.Add("Item A"),1,"Sub-Item A"); var_Items.set_Caption(var_Items.Add("Item B"),1,"Sub-Item B"); var_Items.set_Caption(var_Items.Add("Item C"),1,"Sub-Item C"); axList1.set_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd,axList1.FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",axList1.get_Description(EXLISTLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString()); axList1.FilterBarCaption = "value replace `[` with `<fgcolor=808080>[` replace `]` with `]</fgcolor>`"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarToggle; EXLISTLib.Column var_Column3 = axList1.Columns[0]; var_Column3.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column3.Filter = "Item A\|Item B"; EXLISTLib.Column var_Column4 = axList1.Columns[1]; var_Column4.FilterType = EXLISTLib.FilterTypeEnum.exPattern; var_Column4.Filter = "*B"; axList1.ApplyFilter(); axList1.EndUpdate();
516	Is it possible to automatically displays the control's filter label to the right axList1.BeginUpdate(); EXLISTLib.Column var_Column = (axList1.Columns.Add("Item") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column1.AllowSizing = false; var_Column1.AllowSort = false; var_Column1.Width = 32; var_Column1.FormatColumn = "1 apos ``"; var_Column1.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarCaption = "`<r>` + value"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight \| EXLISTLib.FilterBarVisibleEnum.exFilterBarToggle; EXLISTLib.Column var_Column2 = axList1.Columns[0]; var_Column2.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column2.Filter = "Item B"; axList1.ApplyFilter(); axList1.EndUpdate();
515	How can I get the number of results/items being shown in the control's filter bar (sample 4) axList1.BeginUpdate(); EXLISTLib.Column var_Column = (axList1.Columns.Add("Item") as EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterList = EXLISTLib.FilterListEnum.exShowExclude \| EXLISTLib.FilterListEnum.exShowFocusItem \| EXLISTLib.FilterListEnum.exShowCheckBox \| EXLISTLib.FilterListEnum.exSortItemsAsc; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column1.AllowSizing = false; var_Column1.AllowSort = false; var_Column1.Width = 32; var_Column1.FormatColumn = "1 apos ``"; var_Column1.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.FilterBarPrompt = axList1.FormatABC("`<b>` + value",axList1.FilterBarPrompt,null,null).ToString(); axList1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount " + "+ 1) + ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCompact \| EXLISTLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight \| EXLISTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired \| EXLISTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.EndUpdate();
514	How can I get the number of results being shown in the control's filter bar (sample 3) axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount " + "+ 1) + ` result(s)` ) : ``)"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCompact \| EXLISTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column1 = axList1.Columns[0]; var_Column1.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A\|Item B"; axList1.ApplyFilter(); axList1.EndUpdate();
513	How can I get the number of results being shown in the control's filter bar (sample 2, compact) axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? `<off -4> ` + abs(matchitemcount + 1) + ` result(s)` : ``)"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCompact \| EXLISTLib.FilterBarVisibleEnum.exFilterBarSingleLine \| EXLISTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column1 = axList1.Columns[0]; var_Column1.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A\|Item B"; axList1.ApplyFilter(); axList1.EndUpdate();
512	How can I get the number of results being shown in the control's filter bar (sample 1) axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.FilterBarCaption = "`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column1 = axList1.Columns[0]; var_Column1.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A\|Item B"; axList1.ApplyFilter(); axList1.EndUpdate();
511	FilterBarCaption Predefined Keywords axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Check") as EXLISTLib.Column); var_Column.set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterPattern = false; var_Column.FilterType = EXLISTLib.FilterTypeEnum.exCheck; EXLISTLib.Column var_Column1 = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column1.AllowSizing = false; var_Column1.AllowSort = false; var_Column1.Width = 32; var_Column1.FormatColumn = "1 apos ``"; var_Column1.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.FilterBarCaption = "`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</" + "i></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>" + ": ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF>" + "<i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</" + "i></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=8" + "08080>` + promptpattern + `</fgcolor>`"; axList1.FilterBarPromptPattern = "B"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column2 = axList1.Columns[0]; var_Column2.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column2.Filter = "Item A\|Item B"; axList1.ApplyFilter(); axList1.EndUpdate();
510	I am using filter prompt feature, and also column's filter, just wondering if possible to compact displaying the filter bar so it won't show on multiple lines axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarFont = (axList1.Font as stdole.IFontDisp); axList1.FilterBarCaption = "`<r><i><fgcolor=808080><upline><solidline><sha ;;0>` + value"; axList1.FilterBarPromptPattern = "B"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCompact \| EXLISTLib.FilterBarVisibleEnum.exFilterBarSingleLine \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column1 = axList1.Columns[0]; var_Column1.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A\|Item B"; axList1.ApplyFilter(); axList1.EndUpdate();
509	Just wondering if it is possible to show the filter bar's close button on the right ( sample 2 ) axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight \| EXLISTLib.FilterBarVisibleEnum.exFilterBarToggle \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.FilterBarPrompt = axList1.FormatABC("`<r>` + value",axList1.FilterBarPrompt,null,null).ToString(); axList1.EndUpdate();
508	Just wondering if it is possible to show the filter bar's close button on the right ( sample 1 ) axList1.BeginUpdate(); axList1.RightToLeft = true; (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarToggle \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.EndUpdate();
507	How can I change the visual appearance of the filter bar's close button (EBN) axList1.BeginUpdate(); EXLISTLib.Appearance var_Appearance = axList1.VisualAppearance; var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJ" + "jyI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKm" + "SZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8OR" + "OicbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2" + "DYxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJX" + "AiAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaK" + "JDCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G" + "0TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEA" + "kjIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRS" + "MRsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhA" + "QHkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ"); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarToggle \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.set_Background(EXLISTLib.BackgroundPartEnum.exFooterFilterBarButton,0x1000000); axList1.EndUpdate();
506	How can I change the visual appearance of the filter bar's close button (solid) axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.set_Background(EXLISTLib.BackgroundPartEnum.exFooterFilterBarButton,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0))); axList1.EndUpdate();
505	Is it possible to prevent definitely showing the filter bar's close button axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.set_Background(EXLISTLib.BackgroundPartEnum.exFooterFilterBarButton,-1); axList1.EndUpdate();
504	Is it possible to show the close button only if there is a filter applied axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; axList1.EndUpdate();
503	The control's filter bar is not closed once I click the close button (toggle) axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarCaption = "`<r><fgcolor=808080>` + value"; axList1.FilterBarPromptPattern = "B"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCompact \| EXLISTLib.FilterBarVisibleEnum.exFilterBarToggle \| EXLISTLib.FilterBarVisibleEnum.exFilterBarSingleLine \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column1 = axList1.Columns[0]; var_Column1.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item B"; axList1.ApplyFilter(); axList1.EndUpdate();
502	How can I display the control's filter on a single line axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarCaption = "len(value) ? `filter for: <fgcolor 808080>` + value : `<fgcolor 808080>no filter`"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarSingleLine \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible; EXLISTLib.Column var_Column1 = axList1.Columns[0]; var_Column1.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A\|Item B"; axList1.ApplyFilter(); axList1.EndUpdate();
501	How can I display the control's filter on a single line (prompt-combined) axList1.BeginUpdate(); (axList1.Columns.Add("Item") as EXLISTLib.Column).DisplayFilterButton = true; EXLISTLib.Column var_Column = (axList1.Columns.Add("Pos") as EXLISTLib.Column); var_Column.AllowSizing = false; var_Column.AllowSort = false; var_Column.Width = 32; var_Column.FormatColumn = "1 apos ``"; var_Column.Position = 0; EXLISTLib.Items var_Items = axList1.Items; var_Items.Add("Item A"); var_Items.Add("Item B"); var_Items.Add("Item C"); axList1.FilterBarCaption = "`<r>` + value"; axList1.FilterBarPromptVisible = EXLISTLib.FilterBarVisibleEnum.exFilterBarCompact \| EXLISTLib.FilterBarVisibleEnum.exFilterBarSingleLine \| EXLISTLib.FilterBarVisibleEnum.exFilterBarVisible \| EXLISTLib.FilterBarVisibleEnum.exFilterBarPromptVisible; EXLISTLib.Column var_Column1 = axList1.Columns[0]; var_Column1.FilterType = EXLISTLib.FilterTypeEnum.exFilter; var_Column1.Filter = "Item A\|Item B"; axList1.ApplyFilter(); axList1.EndUpdate();