Often you hide columns/rows in web spreadsheets for simplification of reports. But sometimes you put values in hidden cells, you never ever want the users to see those values. If the user export this report to excel, he could simply unhide those r...
Two major things should be customizable with date picker:
- set first day of week. By default Sunday is first day of week in date picker, but this is not the case in most of the countries;
- displayed date format in date picker. Date picker is sho...
Make spreadsheet function involving cell reference in paramater usable in PHP
There is a lot of spreadsheet function we can't use in PHP with application like : application() - > isformula("A1") Instead of "A1" we could put an paramater that select the cell A1 like the class range, like this :application() - > isformu...
Expand number of columns possible in Jedox Web Spreadsheet from 256 to 1,000 (min)
In order to create web models, it is sometimes necessary to import excel files which have more than 256 columns (current Jedox limit). In many instances these "wide" data blocks are parts of arrays (which can not be broken up) and are needed for m...
More Chart Types and Better Annotation & Exception-Based Reporting Capabilities
Please add more chart types, such as the following, which are very popular on other reporting platforms and a glaring omission on the Jedox platform after so many years: Combination Chart: bars + line on same graph with dual y axes Tornado and Fun...
Ability to directly translate (using Alias) rgrp/fgrp ids using the database dimension from the system database to their real name
If you want to see the Alias of a rgrp/fgrp id, you need to create Integrator extracts of the System database. We would like to directly access these aliases, instead of always running an Integrator job that writes them to one of our cubes.
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 ...