String values that match some patterns can be filtered using PALO.DFILTER
Currently, PALO.DFILTER can work with string values only when using "=" operator (Also, when using ">" operator,some string values are filtered lexicographically,though). But, it does not support pattern matching. In addition,">" operator do...
The client is modifying the default "viewer" role, by giving it "R" rights for the "audit" object. The user (assigned to a group that has the "viewer" role) has now access to the left navigation bar. Instead, the client would like that the "audit"...
Provide additional information for cell level comments
The following improvements could make cell comments more useful: Username and date: similar to Excel, when adding a comment to a cell in the Web Spreadsheet (Designer) the username and date/time should be added Cell UI: Commented cells should have...
ASARRAY function keeping the subset indent and alias
when using widgets, when I pass the result of a PALO.SUBSET to the widget, it will be passed with the whole nested information (element, alias and indent) if I pack the PALO.SUBSET result in an ASARRAY() formula, only the elements will be kept. th...
Since 2020.1 we can set a style in a dimension element. This is great. However it works perfect only in Dynamic View reports. In custom reports we can apply style only on the cells with palo.data function. It's not possible to apply the style on t...
I would like to propose that the merged cell functionality in Jedox be more like in Excel. If you have a merged cell and hide the first column of that merged cell, then the entire cell content is hidden I would like that it did what excel does, na...
I would like to have the possibility to assign an action to a data validation cell. Including the possibility of providing cell references to this action that update properly (Especially important if you use data validation within a Dynarange).
Sorting functionality in Subseteditor always takes the full hierarchy even though you have excluded certain levels from Hierarchyfilter or Attributefilter. A checkbox where you can set "Sort on filtered subset" would be really helpful. Example: I ...
When you have created an input template, you cannot use trace cell on non input cells. It works find on input ready cells. I do however often find it more relevant to trace the calculated cells, which is typically not input relevant.