Hi
I'm busy building a very generic data structure where the column names on a grid are Text1, Text2....; Numeric1, Numeric2..... and so on. The user has the ability to rename the columns to something more meaningful. I've also given the user the ability to create a new column using the formula builder. When the formula build opens it displays to columns as Text1, Text2.... and not as the renamed columns.
Is there a way to get the formula builder to display the meaningful column (Column Header) name in the formula builder instead of the column key?
Hello Acronwright,
If I understand well your scenario and issue, I think that your should change column`s key and column`s caption. Please note that UltraCalcManager and FormulaBuilder works with the column`s key, that`s why you will see the keys in the FormulaBuilder instead of your column`s caption.
Please let me know if you have any questions or if you think that I misunderstand your requirements.
REgards
All I'm really wanting to know is if there is a way to change what is displayed in the FormulaBuilder as we can't change the column keys?
The underlying business object for the grid has properties Text1, Text2....., Numeric1, Numeric2.... (so these will be the keys) and the user has the ability to rename these on the grid (by changing the Header for the column through the displaylayout)
I also have the same issue, I am wondering if I could record the old keys in an array list first, rename all the keys to the caption and put the keys back once the forumla builder is closed? But in which case I guess the formula would not work as its looking at the wrong keys. :( ?
Pity I would quite like to use this feature in my application but like the other user the columns headers are customised by the user but the keys remain the same. I also have special chars in the keys for other complicated reasons I won't go into.
Hello Alex,
One custom approach to implement such functionlity (Alias in Formula Builder) could be if you made change in our source code. Please take a look at the attached screenshot and video file and if you have interests for such solution, I`ll provide you more details how to make these changes.
Please note that I made this solution for hour, specialy for you and I didn`t have a time to make a lot of tests, but you can use it as a starting point.
Regards
Hi, I was wondering if there is an update on the implementation of this fix?
Hello Alex and Andrew,
Sorry for the delay, but right now we discuss what is the best approach to provide this functionality to our customers. I`ll write you soon with more details.
Feel free to write me if you have any questions.
I`d like to inform you that our Product Managment Team take a decision to implement this feature. We will try to include this functionality in version 13.2. If you are not able to wait to version 13.2, we have two possible options:
Option 1: Using Reflection - One of my colleagues made a sample for you with this approach. Please see attachments
Option 2: You could modify our source code using attached files and rebuild assemblies.
NOTE: PLEASE NOTE THAT USING REFLECTION OR MODIFYING OUR SOURCE CODE ARE NOT SUPPORTED
Please let me know if you have any questions.