|
575
|
Defines the symbol used to indicate repeated captions, providing a clear visual cue for identical entries (ditto mark)
axList1.BeginUpdate();
axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched;
axList1.HeaderHeight = 24;
axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines;
(axList1.Columns.Add("Country") as EXLISTLib.Column).ShowIdem = "<fgcolor gray>〃";
EXLISTLib.Items var_Items = axList1.Items;
var_Items.Add("Spain");
var_Items.Add("Spain");
var_Items.Add("Spain");
var_Items.Add("Spain");
var_Items.Add("Germany");
var_Items.Add("Germany");
var_Items.Add("Germany");
var_Items.Add("Germany");
axList1.EndUpdate();
|
|
574
|
Defines the symbol used to indicate repeated captions, providing a clear visual cue for identical entries (space)
axList1.BeginUpdate();
axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched;
axList1.HeaderHeight = 24;
axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines;
(axList1.Columns.Add("Country") as EXLISTLib.Column).ShowIdem = " ";
EXLISTLib.Items var_Items = axList1.Items;
var_Items.Add("Spain");
var_Items.Add("Spain");
var_Items.Add("Spain");
var_Items.Add("Spain");
var_Items.Add("Germany");
var_Items.Add("Germany");
var_Items.Add("Germany");
var_Items.Add("Germany");
axList1.EndUpdate();
|
|
573
|
Displays a glitch funnel for drop-down filter buttons (empty or active)
axList1.BeginUpdate();
EXLISTLib.Appearance var_Appearance = axList1.VisualAppearance;
var_Appearance.RenderType = -1;
var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABa8IQAAYAQGKIYBkAKBQAGaAoDDUNQxQwAAxwfBMKgBBCLIxhEYobgmGIXRpFMbxCKQahLEiTIhGUYJHgmK4tRiAUgxVDkBxrECZYqjcBZO" +
"iwLQ2TxDM7DNKUCBnIoABhGOaYDh+IQNQjUFKwTRFGRxK4EIRKAyTDLQdRyGSMMbjdQpBCbMiMRqhESKRq2UwYRYCFS1NalaztO6BUAvK67YrWez/YBfF+SfwGeqDYRe" +
"WAPfgWERnQrGMLxbD8KwZAKTRjkGJ4XhuB41TbQMqufL9ByXHKSSDpGjaXjeO5VVjYNAvS69UzXNq3bhtQAOXCMEwCgI=");
var_Appearance.Add(2,"CP:1 -2 0 0 0");
axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines;
axList1.GridLineStyle = EXLISTLib.GridLinesStyleEnum.exGridLinesGeometric;
axList1.ShowFocusRect = false;
axList1.set_Background(EXLISTLib.BackgroundPartEnum.exHeaderFilterBarButton,0x2000000);
axList1.set_Background(EXLISTLib.BackgroundPartEnum.exHeaderFilterBarActive,0x2000001);
axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched;
axList1.BackColorHeader = Color.FromArgb(255,255,255);
axList1.HeaderHeight = 24;
axList1.HeaderVisible = true;
EXLISTLib.Column var_Column = (axList1.Columns.Add("1st col") as EXLISTLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.Filter = "Item B";
var_Column.FilterType = EXLISTLib.FilterTypeEnum.exFilter;
axList1.Columns.Add("2nd col");
EXLISTLib.Items var_Items = axList1.Items;
var_Items.Add("Item A");
var_Items.Add("Item B");
var_Items.Add("Item C");
axList1.ApplyFilter();
axList1.EndUpdate();
|
|
572
|
How can I replace or add an icon at runtime
axList1.BeginUpdate();
axList1.ReplaceIcon("gAAAABgYACEHgUJFEEAAWhUJCEJEEJggEhMCYEXjUbjkJQECj8gj8hAEjkshYEpk8kf8ClsulsvAExmcvf83js5nU7nkCeEcn8boMaocXosCB9Hn09pkzcEuoL/fE+O" +
"kYB0gB9YhIHrddgVcr9aktZADAD8+P8CgIA==",null);
axList1.ReplaceIcon("C:\\images\\favicon.ico",0);
(axList1.Columns.Add("Items") as EXLISTLib.Column).set_Def(EXLISTLib.DefColumnEnum.exCaptionFormat,1);
axList1.Items.Add("Item <img>1</img>");
axList1.EndUpdate();
|
|
571
|
Can I set a filter that automatically adds a * before and after the word, so the user can just search for 'cat' and it becomes '*cat*' automatically
axList1.BeginUpdate();
axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched;
axList1.HeaderHeight = 24;
EXLISTLib.Column var_Column = (axList1.Columns.Add("Items") as EXLISTLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = true;
var_Column.set_Def(EXLISTLib.DefColumnEnum.exFilterPatternTemplate,"*<%filter%>*");
var_Column.FilterType = EXLISTLib.FilterTypeEnum.exPattern;
var_Column.Filter = "1";
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 1");
var_Items.Add("Item 2");
var_Items.Add("Item 3");
axList1.ApplyFilter();
axList1.EndUpdate();
|
|
570
|
Disable temporarily the column's sort, resize and drag and drop
axList1.BeginUpdate();
axList1.SortBarVisible = true;
axList1.SortBarCaption = "<fgcolor 808080><c>the header and the sort-bar are disabled (no drag and drop is allowed)";
axList1.HeaderEnabled = false;
axList1.HeaderAppearance = EXLISTLib.AppearanceEnum.Etched;
(axList1.Columns.Add("Index") as EXLISTLib.Column).FormatColumn = "1 index ``";
(axList1.Columns.Add("Pos") as EXLISTLib.Column).FormatColumn = "1 apos ``";
axList1.Columns.Add("Edit");
axList1.GridLineStyle = EXLISTLib.GridLinesStyleEnum.exGridLinesGeometric;
axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exVLines;
axList1.GridLineColor = Color.FromArgb(224,224,224);
axList1.EndUpdate();
|
|
569
|
Expandable-caption
// AnchorClick event - Occurs when an anchor element is clicked.
private void axList1_AnchorClick(object sender, AxEXLISTLib._IListEvents_AnchorClickEvent e)
{
System.Diagnostics.Debug.Print( e.anchorID.ToString() );
}
//this.axList1.AnchorClick += new AxEXLISTLib._IListEvents_AnchorClickEventHandler(this.axList1_AnchorClick);
axList1.BeginUpdate();
axList1.ColumnAutoResize = true;
axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines;
axList1.GridLineStyle = EXLISTLib.GridLinesStyleEnum.exGridLinesGeometric;
axList1.BackColorAlternate = Color.FromArgb(240,240,240);
axList1.ShowFocusRect = false;
axList1.Columns.Add("Default");
EXLISTLib.Items var_Items = axList1.Items;
var_Items.Add("before item");
int h = var_Items.Add("<solidline> <c><b>Bank Account</b></solidline><br>+ owner: String <r><a 1;e64=gA8ABzABvABsABpABkg8JABuABlAA+AAgAECMcTi4AMwAM4Aj" +
"MGhEGOUVAA4AAwk8plcqihwAElg0wiUlOkOiUEgQvgcFhsKhkIhUQiUUnccj0gn0jmMagUlowAMNOpEfkMNkkmlEqrctjQmAAjAA5AA2sssHcbnkdq1Ln1QtVSjQAAEB" +
"A==>▲</a><br><solidline>+ balance: Currency = 0</solidline><br>+ deposit(amount: Currency)<r><a 2;e64=gA8ABjAA+AECMwAM8DAB" +
"vABshoAOQAEAAHAAGEWjEajMGNoAMoAOgANERMgAOcHAAvAEJhcEh0Qh0Tg0CmkqMMFlUuhkxiMTisXjNCjk6EwAEYAHIAG1MjY7lUsnkwh8/nUClk5gwAAEBA==> " +
"650;</a><br>+ withdraw(amount: Currency)");
var_Items.set_CaptionFormat(h,0,EXLISTLib.CaptionFormatEnum.exHTML);
var_Items.set_CellSingleLine(h,0,EXLISTLib.CellSingleLineEnum.exCaptionWordWrap);
var_Items.Add("after item");
axList1.EndUpdate();
|
|
568
|
Expandable-caption
axList1.BeginUpdate();
axList1.ColumnAutoResize = true;
axList1.DrawGridLines = EXLISTLib.GridLinesEnum.exAllLines;
axList1.GridLineStyle = EXLISTLib.GridLinesStyleEnum.exGridLinesGeometric;
axList1.BackColorAlternate = Color.FromArgb(240,240,240);
axList1.ShowFocusRect = false;
axList1.Columns.Add("Default");
EXLISTLib.Items var_Items = axList1.Items;
var_Items.Add("before item");
int h = var_Items.Add("<solidline><b>Header</b></solidline><br>Line1<r><a ;exp=show lines>+</a><br>Line2<br>Line3");
var_Items.set_CaptionFormat(h,0,EXLISTLib.CaptionFormatEnum.exHTML);
var_Items.set_CellSingleLine(h,0,EXLISTLib.CellSingleLineEnum.exCaptionWordWrap);
var_Items.Add("after item");
axList1.EndUpdate();
|
|
567
|
Force hover-all feature
axList1.set_Background(EXLISTLib.BackgroundPartEnum.exScrollHoverAll,-1);
|
|
566
|
Disable hover-all feature (Windows 11 or greater)
axList1.set_Background(EXLISTLib.BackgroundPartEnum.exScrollHoverAll,(uint)ColorTranslator.ToWin32(Color.FromArgb(1,0,0)));
|
|
565
|
Display a custom tooltip
// MouseMove event - Occurs when the user moves the mouse.
private void axList1_MouseMoveEvent(object sender, AxEXLISTLib._IListEvents_MouseMoveEvent e)
{
axList1.ShowToolTip("new content","",null,"+8","+8");
}
//this.axList1.MouseMoveEvent += new AxEXLISTLib._IListEvents_MouseMoveEventHandler(this.axList1_MouseMoveEvent);
|
|
564
|
Shows the tooltip of the object moved relative to its default position
// MouseMove event - Occurs when the user moves the mouse.
private void axList1_MouseMoveEvent(object sender, AxEXLISTLib._IListEvents_MouseMoveEvent e)
{
axList1.ShowToolTip("<null>","<null>",null,"+8","+8");
}
//this.axList1.MouseMoveEvent += new AxEXLISTLib._IListEvents_MouseMoveEventHandler(this.axList1_MouseMoveEvent);
axList1.ColumnAutoResize = false;
(axList1.Columns.Add("tootip") as EXLISTLib.Column).ToolTip = "this is a tooltip assigned to a column";
|
|
563
|
How do I prevent changing the cell's state ( check-box state )
// CellStateChanging event - Fired before cell's state is about to be changed.
private void axList1_CellStateChanging(object sender, AxEXLISTLib._IListEvents_CellStateChangingEvent e)
{
EXLISTLib.Items var_Items = axList1.Items;
e.newState = var_Items.get_CellState(e.itemIndex,e.colIndex);
}
//this.axList1.CellStateChanging += new AxEXLISTLib._IListEvents_CellStateChangingEventHandler(this.axList1_CellStateChanging);
axList1.BeginUpdate();
axList1.FreezeEvents(true);
(axList1.Columns.Add("P1") as EXLISTLib.Column).set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true);
(axList1.Columns.Add("P2") as EXLISTLib.Column).set_Def(EXLISTLib.DefColumnEnum.exCellHasCheckBox,true);
EXLISTLib.Items var_Items = axList1.Items;
var_Items.Add("C1");
var_Items.set_CellState(var_Items.Add("C2"),0,1);
var_Items.set_CellState(var_Items.Add("C3"),0,1);
var_Items.Add("C4");
axList1.FreezeEvents(false);
axList1.EndUpdate();
|
|
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();
|