We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Excel-Filter same Items in Selectionlist

Thread ID:

Created:

Updated:

Platform:

Replies:

128401 Jan 19,2017 05:08 AM Jan 23,2017 06:18 AM Windows Forms 4
loading
Tags: GridGroupingControl
Thomas
Asked On January 19, 2017 05:08 AM

Hello,

I have a problem with an Excel-Filter. I use Entity Framework.

I load my GGC with vehicleBindingSource.DataSource = VehicleService.GetAllVehicles();

and I have the columns where I replace my CountryId, RegistrationOfficeId with the realname.
countries = VehicleService.GetAllCountries();
registrationOffice = VehicleService.GetAllRegistrationOffice();

I configure the columns
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalRegistrationOfficeId"].HeaderText = "Zulassungsstelle";
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalRegistrationOfficeId"].Width = 120;
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalRegistrationOfficeId"].Appearance.AnyRecordFieldCell.CellType = GridCellTypeName.GridListControl;
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalRegistrationOfficeId"].Appearance.AnyRecordFieldCell.DataSource = registrationOffice;
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalRegistrationOfficeId"].Appearance.AnyRecordFieldCell.DisplayMember = "Name";
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalRegistrationOfficeId"].Appearance.AnyRecordFieldCell.ValueMember = "RegistrationOfficeId";
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalRegistrationOfficeId"].Appearance.AnyRecordFieldCell.ShowButtons = GridShowButtons.Hide;
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalCountryId"].HeaderText = "Land";
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalCountryId"].Width = 100;
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalCountryId"].Appearance.AnyRecordFieldCell.CellType = GridCellTypeName.GridListControl;
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalCountryId"].Appearance.AnyRecordFieldCell.DataSource = countries;
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalCountryId"].Appearance.AnyRecordFieldCell.DisplayMember = "CountryName";
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalCountryId"].Appearance.AnyRecordFieldCell.ValueMember = "CountryId";
gridGroupingControlVehicle.TableDescriptor.Columns["GlobalCountryId"].Appearance.AnyRecordFieldCell.ShowButtons = GridShowButtons.Hide;

everything is OK.

I configure the Excel-Filter
GridExcelFilter excelFilter = new GridExcelFilter();
excelFilter.WireGrid(gridGroupingControlVehicle);
excelFilter.AllowSearch = false;

foreach (GridColumnDescriptor column in gridGroupingControlVehicle.TableDescriptor.Columns)
{
   column.AllowFilter = true;
}

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"???


2. Question
I would like to translate the Excel-Filter in German. But I can find all variables. For example the Submenu in Textfilters.

3. Question
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?.

Thanks for your support
BR Thomas



Attachment: GGC_Picture_c69ac967.zip

Mohanraj Gunasekaran [Syncfusion]
Replied On January 20, 2017 06:32 AM

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 


Thomas
Replied On January 21, 2017 04:52 AM

Hello,

ok, I think I have all fields translated - thanks. Shame on me - I have not tried the Office2007-Filter.
One Problem. The German translation for "Cancel" is "Abbrechen". But when I open the Excel-Filter the button for Cancel show only "Abbreche" - the last letter ist cut off.

                case DynamicFilterResourceIdentifiers.Office2007FilterCancel:
                    return "Abbrechen";

This translation is OK:

                case DynamicFilterResourceIdentifiers.CustomAutoFilterCancel:
                    return "Abbrechen";

BR Thomas

Thomas
Replied On January 21, 2017 04:57 AM

Hi,

is it possible to change the color for the Excel-Filter (Buttons, Header)? I use in my App Steelblue?

BR Thomas

Mohanraj Gunasekaran [Syncfusion]
Replied On January 23, 2017 06:18 AM

Hi Thomas, 

Thanks for your update, 

Please find your responses in below table, 

The German translation for "Cancel" is "Abbrechen". But when I open the Excel-Filter the button for Cancel show only "Abbreche" - the last letter ist cut off. 


In our GridGroupingControl architecture, we do not have the support to customize the excel filter popup (button, header) also we do not have the support to change the excel filter ok and cancel button sizes. So we have logged the feature report for these cases which will be available in any of our main release. 
is it possible to change the color for the Excel-Filter (Buttons, Header)? I use in my App Steelblue? 

Please let us know, if you have any further assistance. 

Regards, 
Mohanraj G. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;