We currently have zero suppression, but I would like to propose suppress blank/null, so that summations is not suppressed even if the sum total is zero. Currently I can easily miss data that sums to zero
Expose the PHP functions in the spreadsheet functions
for instance I want to compare 2 ranges, I have a function: function arrayintersect($array1,$array2){ return array_intersect($array1,$array2);} this would be helpful if the array_intersect function would be directly accessible from the spreadsheet...
Dynarange --> control expand/collapse more dynamically (for each node individually)
Currently you can only control the initial expand/collapse of dynarange nodes by level -> e.g. expand whole dynarange up to level 3 . It would be great to set the initial expand/collapse state more individually for each element. . like this: . ...
Version Blending / Forecast Splashing: Centralized HOLD
I would like to be able to manipulate "HOLD" using rules and Integrator. Currently the users needs to use the Planning Assistant / right click in UI. But general hold is needed for Forecast scenario's like 3+9 to ensure splash works correctly, and...
The concatenate.range function is awesome! This would be even more awesome to have the opposite, say, "split.range", that would allow splitting a string regarding a delimiter (like PHP's explode(<string>,<delimiter>). This would return...
the design of the method value() in the macro engine should be improved. It returns a different type depending of the arguments passed to the range() property. Example: activesheet()->range('A1')->value => returns a string // this is corr...
Allow pasting array formulas in Macro Engine, using a method "FormulaArray" like in VBA, e.g.: activesheet()->range('D3:G3')->formulaArray = "=TRANSPOSE(C4:C7)";
Since chromebooks / pixelbooks are becoming popular, make jedox compatible with Chrome OS. Currenlty jedox is very glitchy in pixelbooks e.g. not able to scroll Thanks
Function / rules feature that allows to retrieved saved db value in rule determined cell
I would like a function or rule feature that allows to retrieved saved db value in rule determined cell. Use case is like having a cell calculated unless somebody enters an alternative value. This would allow us to avoid having another measure for...
In SQL we have a lot of nice functions to handle null. A very nice example is ISNULL() gives you the possibility to return and altenate value when the value is null, and if not null then it returns the value you are evaluating.