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