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?
This looks really good! But is this functionality also combinable with the multi grouping feature of the grid?
Hello,
I have been looking into your requirement and I modified the sample I sent you before so now you can choose Loans or Assets from all the Records. Please let me know if this helps you or you need further assistance.
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
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.