Let us know how we can make Jedox even better!
Often, Formulas (especially Palo Data Formulas) are referencing Cell Values. i think it would be nice to have a mode, a Button or a shortcut, to see the explicit Values in the Formulabar.
Concrete example:
Formula = Palo.Data($A$2, $B$2, $C$2, $D$3)
would be shown as: Palo.Data(§"localhost/Project"§, §"ExampleCube"§, §"Parameter1"§, §"Parameter2"§)
This would help move and analyze quickly if Formulas are referencing wrong cells, without scrolling exploring the Sheet.
Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog.
In the meantime, There is a workaround to achieve this in the meantime.
When you have a palo formula like this in a spreadsheet, select an element as below.
and hit F9 on keyboard to see the value of the element.