Hello,I'm evaluating different WPF grids for a current software project in our company. By reading your documentations, forum threads and trying your demos, I couldn't find out if your grid control could meet all of our special requirements:1. multiple grouping with collapsing/hidding possibility (could be fixed groups, not necassary for user to change grouping items at runtime)
2. different formulas per cell not just per column, i.e. the FormulaColumn-item[1] could have another formula than FormulaColumn-item[2].
3. formula in one cell that is related to other cells (other column and/or row index), i.e. formula in cell A1: "B5 + C10"
4. possibility for user to change the formulas (by editor)Maybe this all could be done by combining your xamGrid, xamCalculationManager and xamFormulaEditor but I'm not quite sure. Could you please tell me if this is somehow possible and give me an example?
Hello,
Thank you for your post. I have been looking into it and I created a sample project for you with the functionality you want (3 and 4). As for the second one I can say that you are able to use the Cells from the same Record only and for the first one you can set the CellVisibilityWhenGrouped on the FieldSettings to Collapsed. Please let me know if this is what you want or I have misunderstood you in some way.
Looking forward for your reply.
thank you for your sample project!
Am I right that it is not possible to create a formula like "[//Loans][3]*[//Loans][5]" for multiplying the loan of the 3rd row with the loan of the 5th row?
If it's not, would it be possible to add this functionality by myself (i.e. by extending your classes/controls) or do you have a sample how to achieve this?
redards
I have been looking into your requirement and I modified the sample I sent you before, so now it has the functionality you want. Basically I handled the GroupByRecordPresenter’s Loaded event and in there I made the calculations you want and add the m to the Record’s Description, but you can modify them as you want.
Hope this helps you.
I would like to test your new sample but the link to the ZIP-file doesn't seem to work.
Could you please try again to download it and let me know if it helps you.
Hi,
yes, the link now works and the sample looks like what we are searching for. One last thing I'm missing is that the values in the group headers get updated automatically if i.e. some loan or asset value changes. But although I didn't have the time to look too deep into your sourcecode (I just used your samples) I think coding this will also be easy, right?!
I am just checking the progress of this issue and was wondering if you managed to achieve your goal or if you need any further assistance on the matter.
Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.
Thanks again.
yes your last sample seems to have all the features we want. I have to talk to my boss and check if there are any additional requirements, but I think we will buy your controls in the near future!
Thank you for your assistance!