Dynarange shouldn't change the specified cell with dollar sign ($) in Excel formula
If a excel formula is defined in a cell which is covered in a Dynarange, position of specified cells in that Excel formula is dynamically changed when the Dynarange is expanded.
e.g.
If "SUMIF($G$2:$G$4,B3,$E$2:$E$4)" is specified in a cell cover...
It would be useful to be able to create, modify, delete and launch tasks directly from the API, allowing specification of :
schedule (date/time of execution and frequence of execution),
active or not,
file location when generating xlsx or pdf.
By default show summary of cells in the bottom right corner
Like in Excel it would be nice to get an automatic summary of cells shown in the bottom right Corner (see attached file).
For example:
Value in cell A1: 20
Value in cell A2: 30
Value in cell A3: 40
When range A1:A3 is selected, the sum of those ...
this would be greatly useful to have a method to get the number of rows returned by an ETL component, such as:
mySource=API.initSource("myExtract");
mySource.getRowCount();
cell comment in Jedox web worksheet automatically from Attribute
In our reports we often show codes e.g. for areas or items.
Often we also need to show descriptions of those codes which takes lots of space.
I often wished I could just show the description as mouse over of the cell which shows the code. Like th...
The different layout of comboboxes and lists makes it impossible to use them side by side without breaking report design:
- Comboboxes and lists should have the same height.
- Comboboxes and lists should use the same style.
At least there should...
Jedox is using a customized Groovy implementation.
This does not contain all functionality of groovy!!!!!!
The documentation
https://knowledgebase.jedox.com/knowledgebase/job-groovy/
does not state a hint that not all native groovy functions are...