Excel-Filter same Items in Selectionlist
4 Replies
Hi Thomas,
Thanks for using Syncfusion products.
Please find your responses in below table
|
The filter works in all columns, expect in this columns where I have a GridListControl. When i click the first time for example on column "Zulassungsstelle" (Filter OK.png) - all ok. But when I click on an filter in a other column ("Land", Filter wrong.png). I get the same items as in the first column???? When I restart the app and change and click at first on the columns "Land" (Filter ok 2.png) - all OK. But when I click on the column "Zulassungsstelle" i get the same items as in the column "Land"???
|
We have created a new incident for this query and updated the response through the incident. Please follow up with that incident using your direct-track login
|
|
I would like to translate the Excel-Filter in German. But I can find all variables. For example the Submenu in Textfilters. |
In order to localize the ExcelFilter dropdown, you can use the ILocalizationProvider and Localization.Provider property. Please refer the below code snippet and refer the dashboard sample from below location,
Code snippet
class Localizer : ILocalizationProvider
{
public void getstring(bool s, bool recordNavig, bool office2007, bool fieldChooser)
{
}
public string GetLocalizedString(System.Globalization.CultureInfo culture, string name,object obj)
{
}
}
public partial class Form1 : Form
{
Localizer loc = new Localizer();
loc.getstring(checkBox5.Checked, checkBox8.Checked, checkBox6.Checked, checkBox7.Checked);
LocalizationProvider.Provider = loc;
}
Sample link: <Install Location>\Syncfusion\EssentialStudio\[Version Number]\Windows\Grid.Grouping.Windows\Samples\Localization Samples\Localization Demo
Screenshot
  |
|
How is it possible to change the color from the Down-Arrow (white) in Black in a ComboBoxAdv (Metro-Style). I can change the Background-Color but not the Arrow?. |
By default, arrow image has loaded in ComboBox drop down button. If you want to customize the drop down arrow, you can use Cancel property in TableControlDrawCellButtonBackground event. Please refer the below code snippet and refer the attached sample,
Code snippet
this.gridGroupingControl1.TableControlDrawCellButtonBackground += new GridTableControlDrawCellButtonBackgroundEventHandler(gridGroupingControl1_TableControlDrawCellButtonBackground);
void gridGroupingControl1_TableControlDrawCellButtonBackground(object sender, GridTableControlDrawCellButtonBackgroundEventArgs e)
{
if (e.Inner.Style.CellType == GridCellTypeName.ComboBox)
{
ThemedComboBoxDrawing.DropDownState btnState = ThemedComboBoxDrawing.DropDownState.Normal;
int rowIndex = e.Inner.Style.CellIdentity.RowIndex;
int colIndex = e.Inner.Style.CellIdentity.ColIndex;
bool isHovering = e.Inner.Button.IsHovering(rowIndex, colIndex);
bool isMouseDown = e.Inner.Button.IsMouseDown(rowIndex, colIndex);
bool disabled = !e.Inner.Style.Clickable;
if (disabled)
{
btnState = ThemedComboBoxDrawing.DropDownState.Disabled;
}
else if (isMouseDown)
{
btnState = ThemedComboBoxDrawing.DropDownState.Pressed;
}
else if (isHovering)
{
btnState = ThemedComboBoxDrawing.DropDownState.Hot;
}
//Customize the ComboBox Button.
this.gridGroupingControl1.TableModel.Options.GridVisualStylesDrawing.DrawComboBoxStyle(e.Inner.Graphics, e.Inner.Button.Bounds, btnState, Color.Gray);
Bitmap bitmap = new Bitmap(@"..\..\dropdownarrow.png");
//Customize the icon of ComboBox.
iconPaint.PaintIcon(e.Inner.Graphics, e.Inner.Button.Bounds, Point.Empty, bitmap, Color.Black);
e.Inner.Cancel = true;
}
}
Sample link: GridGroupingControl
|
Regards,
Mohanraj G
SIGN IN To post a reply.
