1. Home
  2. Forum
  3. WPF
  4. Some Questions - Diverging bar chart, clone window, clone column

Some Questions - Diverging bar chart, clone window, clone column

Hello and good day,

I'm writing a specification document for a custom software that will be using Syncfusion components. 

I would like to know if the following features could be done using Sfdatagrid and what would be the best way to achieve them. The concept is that sfdatagrid is inside a ribbon window. Each column type is different and each has its own functionality.  They are independent in a way expect they are bound by one data axis(column).

1. Firstly is it possible to have a diverging bar chart? This means that inside that column one would need to have two values and a bar to visualize the data. 

2.Can one clone a window?

3.Can one clone a column (a combined command of copy and paste)?

4.Can one have unbound rows on the bottom and on the top? And can they have a show hide button for each column? This is to create some column based statistical analysis.  

5. Can a column have its own busy indicator?

Thank you very much,

Kind Regards

10 Replies
GT Gnanasownthari Thirugnanam Syncfusion Team November 29, 2017 03:32 AM UTC

Hi Helder, 
 
Please find the response for your queries, 
 
Query 1: Firstly is it possible to have a diverging bar chart? This means that inside that column one would need to have two values and a bar to visualize the data. 
You can load the bar chart inside the column using CellTemplate property in GridColumn like below code example. 
XAML 
<syncfusion:GridTextColumn MappingName="CustomerID" HeaderText="CustomerID"> 
                    <syncfusion:GridTextColumn.CellTemplate> 
                        <DataTemplate> 
                            <syncfusion:SfChart> 
                                <syncfusion:BarSeries XBindingPath="CustomerID"/> 
                            </syncfusion:SfChart> 
                        </DataTemplate> 
                    </syncfusion:GridTextColumn.CellTemplate> 
                </syncfusion:GridTextColumn> 
 
Please refer the below UG link for more details about that. 
 
Query 2. Can one clone a window? 
 
Query 3. Can one clone a column (a combined command of copy and paste)? 
 
We cannot understood your requirement clearly, kindly please share your requirement like screenshot or video illustration with more details about your requirement that will be helpful to provide appropriate solution at earliest. We will happy to assist you.  
Query 4. Can one have unbound rows on the bottom and on the top? And can they have a show hide button for each column? This is to create some column based statistical analysis.   
You can place the UnboundRow in SfDataGrid at top and bottom position like below code example. 
 
<syncfusion:SfDataGrid.UnBoundRows> 
                <syncfusion:GridUnBoundRow Position="Bottom"/> 
                <syncfusion:GridUnBoundRow Position="Top"/> 
            </syncfusion:SfDataGrid.UnBoundRows> 
 
You can refer the below UG link for more details about UnboundRow 
 
Query 5. Can a column have its own busy indicator? 
You can load the busy indicator in column using CellTemplate property like below code example. 
XAML 
<syncfusion:GridTextColumn MappingName="OrderID" HeaderText="OrderID"> 
                    <syncfusion:GridTextColumn.CellTemplate> 
                        <DataTemplate> 
                            <syncfusion:BusyDecorator   Width="50" IsBusyIndicatorShowing="True" /> 
                        </DataTemplate> 
                    </syncfusion:GridTextColumn.CellTemplate> 
                </syncfusion:GridTextColumn> 
 
 
 
We have prepared the sample based on your requirement, you can download it from below mentioned location. 
 
 
Regards, 
Gnanasownthari T. 


HL Helder Liboi November 30, 2017 03:39 PM UTC

Hello Gnanasownthari,

Firstly, thank you for your kind and timely reply. 

I'm very thankful for your response and sample.

REgarding query 3 and 4 ill elaborate the best I can:

Cloning a column would mean a context command enabling the copy of all data, visualization properties to the side of that column. Probably a combined command between copy column and paste it immediately on is right. I when through some of the previous questions asked here and found possibly something that is similar: 

https://www.syncfusion.com/kb/3245/how-to-copy-the-column-and-paste-it-as-a-new-column-by-contextmenu-in-sfdatagrid


 The "clone" command would do them both. I think the previous example satisfies my requirements.


The "clone" window is the same principle. A ribbon window with the possibility through a command duplicate itself into an exactly same window thus having two similar windows. I'm imagining that that would be more of a serialization matter right? Serialize the window and run a command to create it like the serialization.

Thank you once again Gnanasownthari,


Kind Regards,

Helder



 

MK Muthukumar Kalyanasundaram Syncfusion Team December 2, 2017 05:24 PM UTC

Hi Helder, 

Thanks for the update. 

We couldn’t understand your requirement clearly. Based on our understanding, we have shared the documentation link. In that link, you can get the details about serialize and de-serialized of the SfDataGrid. 


You can save the SfDataGrid settings in the xml file by using the Serialize and De-Serialized method and then you can able to apply the same changes in another SfDataGrid. Also you can customize the serialization and de-serialization operation by setting SerializationOptions and DeSerializationOptions. 

If your requirement is different from this, could you please share some more information about your requirement clearly ?.  This would be more helpful for us to proceed further.   
 
Regards, 
Muthukumar K 


HL Helder Liboi December 5, 2017 12:05 PM UTC

Thank You very much for your reply.


I will provide the clarification to the general UI.



The requirements for the UI are very similar to the sample you provide with portfolio analyzer.


One Ribbon Control without the backstage button. In the minimized state.

The Ribbon Control will contain general options, no QAT. 

ContextTabGroups will provide specific options depending on the column selected from Sfdatagrid. 

Minimize/Maximize the ribbon is located in RibbonTabPanel. 

The RibbonWindow will also display a status bar with buttons.


Below the area is controlled by Docking Manager. 

  • Two stack Panels.

  1.    One with only the AutoPin option.First Panel will contain buttons. 

  2.    The other has a Sfdatagrid without header (no options whatsoever to close minimize or Hide)from the docking manager.


Please see the attatchment.


Thank you kindly,


Best Regards





Attachment: Window_43b50de4.rar

VR Vijayalakshmi Roopkumar Syncfusion Team December 7, 2017 06:54 AM UTC

Hi Helder,  
Thank you for the update.  
Please find the response from the below table:  
Ribbon Query: 
S No  
Customer Query   
Response 
1.  
One Ribbon Control without the backstage button. In the minimized state.  
  
To hide Backstage Button in Ribbon control. In our sample, we have done in loaded , similary you can use the following code exampl as desired. 
  
C#  
//To hide the Backstage button  
_ribbon.BackStageButton.Visibility =Visibility.Collapsed;  
  
2.  
The Ribbon Control will contain general options, no QAT.   
  
In our sample, we have not added the QAT items, but we could not understand what do you mean by the general options. Can you please brief about this requirement.  
3.  
ContextTabGroups will provide specific options depending on the column selected from Sfdatagrid.   
  
To open the ContextTabGroup on selecting the desired columns cell, you can use the below code example:  
 C# 
  
private void Datagrid_CurrentCellActivated(object sender, Syncfusion.UI.Xaml.Grid.CurrentCellActivatedEventArgs e)  
{  
string text =this.datagrid.SelectionController.CurrentCellManager.CurrentCell.Renderer.GetControlValue().ToString();  
Tabletools.Label = text;  
//To enable the contexttabgroup  
Tabletools.IsGroupVisible = true;  
}  
  
  
  
4.  
Minimize/Maximize the ribbon is located in RibbonTabPanel.   
  
You can add the button in RibbonTab panel to maximize and maximize the ribbon. The same has been demonstrated in the following code example:  
  
 C# 
//To toggle the RbbonState  
if(_ribbon.RibbonState == Syncfusion.Windows.Tools.RibbonState.Normal)  
{  
_ribbon.RibbonState = Syncfusion.Windows.Tools.RibbonState.Hide;  
}  
  
else  
{  
_ribbon.RibbonState = Syncfusion.Windows.Tools.RibbonState.Normal;  
}  
  
5.  
The RibbonWindow will also display a status bar with buttons.  
  
To display a status bar with buttons in the Ribbon , you can use the following code example.  
  
<syncfusion:RibbonWindow.StatusBar>  
  
<syncfusion:RibbonStatusBar>  
  
<WrapPanel>  
  
<syncfusion:RibbonButton x:Name="ribbonbutton1" SizeForm="ExtraSmall" Label="StatusBar1"/>  
  
  
<syncfusion:RibbonButton x:Name="ribbonbutton2" SizeForm="ExtraSmall" Label="StatusBar2"/>  
  
</WrapPanel>  
  
</syncfusion:RibbonStatusBar>  
  
</syncfusion:RibbonWindow.StatusBar>  
  
  
  
  
 
  
  
Docking Manager queries:  
  
S No  
Query  
Response  
1.  
One with only the AutoPin option.First Panel will contain buttons.   
To show DockingManger to show autopin option, set the DockingState as Autohide  
  
syncfusion:DockingManager.State="AutoHidden"  
  
2.  
The other has a Sfdatagrid without header (no options whatsoever to close minimize or Hide)from the docking manager.  
To remove the header for DockingManager content, you can use the following property.  
  
syncfusion:DockingManager.NoHeader="True"  
 
Also to hide header for SfDataGrid, you can use HeaderRowHeight property to Zero. 
  
 
  
The same has been prepared in the sample. Please download it from following location:  
Please try this solution and let us know if it is helpful.  
Regards,  
Vijayalakshmi V.R. 


HL Helder Liboi December 7, 2017 10:14 AM UTC

Firstly, Thank you very much for your reply to my queries. I want to congratulate you for a 5-star support to my queries. Has you might see Im gathering information on several aspects of the main window. First the SfDatagrid and now the Main Window, the "container/shell" for that SfDatagrid. I'm extremely grateful for your responses.

I just have some final questions:

Those are in the screen-shots attached and pertain to:
  1. The space handling from the DockingManager.
  2. The possibility to show/hide unbound rows at runtime.

My other questions regarding:
Context Menu in the header.
Duplicating a Window/Column.
Cell Style customization based on the value.

Were answered previously on in other previous posts.




Attachment: MainWindow_cont_6229e4d0.rar

HL Helder Liboi December 7, 2017 10:37 AM UTC

Forgot to attach the Gif where it shows the minimized behavior if the minimize ribbon button below is active.
  1.  It will show a blank row in RibbonControl. The idea is that it shouldn't. This is due probably because of the minimize icon.
  2. The context Menus appear maximized. The idea is to have them discreetly appear but minimized. 


Also by specific by general options I meant application derived buttons like title bar buttons similar to the design of Essential Studio where the where the Menus are situated in the Title Bar and not below, but instead of Menus we would use buttons for general options. 

Again,

Thank you so much for your assistance.
Kind Regards 


Attachment: Mainwindow1_d6f4859f.rar

VR Vijayalakshmi Roopkumar Syncfusion Team December 8, 2017 05:22 PM UTC

 Hi Helder

Thank you for the update.

We have Modified the sample according to your requirement with Ribbon and DockingManager as shown in the screenshot. Please download the same from the following location:

Sample: http://www.syncfusion.com/downloads/support/forum/134729/ze/RibbonContextMenu_Modified633860035 

You can download the below sample for the requirement  "show/hide unbound rows"  with SfDatagrid.

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/SfGridDemo2054591270.zip 

Query:  Also by specific by general options I meant application derived buttons like title bar buttons similar to the design of Essential Studio where the where the Menus are situated in the Title Bar and not below, but instead of Menus we would use buttons for general options.

We regret to inform that we still could not get your actual requirement. Can you please show this requirement clearly in the screenshot? It would be helpful for us to proceed on this.

Regards,
Vijayalakshmi V.R. 


HL Helder Liboi December 12, 2017 08:55 AM UTC

Thank You very much for your response.

The requirements are in fact title bar icons.

Thank you again very much. If I have any other doubts I will say. As the samples you provided pointed me in the right direction.


VR Vijayalakshmi Roopkumar Syncfusion Team December 13, 2017 06:05 AM UTC

Hi Helder

Thank you for the update.

Please let us know if you need any further assistance on this.

Regards,
Vijayalakshmi V.R.

Loader.
Up arrow icon