hello.
please look at the Image. How to formula the column by part1 and part2? thanks!
Hello psky,
Looking at your table I can see that you are referring to string columns. You could hook to the 'InitializeRow' event of the 'UltraGrid' and assign the string values of the corresponding cells to the formula cell:
private void ultraGrid1_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
{
e.Row.Cells[2].Value = e.Row.Cells[0].Value.ToString() + e.Row.Cells[1].Value.ToString();
}
Please feel free to let me know if a question about our tool set comes up on your mind.
psky,
I am checking about the progress of this issue. Please let me know If you need any further assistance on this.
Sorry, The last column is sum(part4) group by part12. you know?
please see the last formula column= the first row + the four row
Nobody can reply to me。How to do it?
Hello,
I am not able to understand how would you want to sum the string column and show it in the int column.
Are you looking for the summaries functionality: http://help.infragistics.com/NetAdvantage/WinForms/2013.1/CLR4.0/?page=Infragistics4.Win.UltraWinGrid.v13.1~Infragistics.Win.UltraWinGrid.UltraGridOverride~AllowRowSummaries.html?
Hi,Boris. you do not understand it. i hope add a formula column. it's data come from part4. the column part4 is not string.
please watch the picture.
Hello Psky,
If I understand well your requirement, to solved your task, you should implement custom formula (function) into your UltraCalcManager and apply this formula to your column -"Formula5". After that each time when you make changes into your "part12" column, you should call ultraCalcManager1.ReCalc(); method.
Please take a look at the attached screenshot, video and sample for more details. Let me know if you have any questions.
Hi,
If you need any additional assistance don’t hesitate to ask.
Regards
Here is the sample
Sorry for the delay. You should make small modification in protected override Infragistics.Win.CalcEngine.UltraCalcValue Evaluate() method. I used our previous sample and I made changes in this method. Using a LINQ you could get desired results. For example:
var w = Rows.Where(z => z.Index <= gg && z.GetCellText(z.Band.Columns[0]) == FilterValue).Sum(s => Convert.ToDecimal(s.GetCellText(col)));
Please take a look at the attached sample for more details and let me know if you have any questions.
Hello,Georgi,
Where to go? Can you help me make a similar custom function?
Oh,I know.
can you help me to create a sample ?