In-place editing of values in ODBCDATA cells should be possible (similar to editing values in PALO.DATA but for data from ODBC source). For this additional SQL UPDATE statement has to be defined when defining relational DynaRange #1400117 votes
When editting a formula, a double-click into formula selects a "logical" portion of it in Excel. In Web, this only works for simple argument (named ranges and cell references without $ chars)
Excel seams to select on double-click from the current cursor position, all the content between the next two delimiters to the left and to the right. Delimiters found so far in Excel:
- argument separator (comma in English, semi-colon in german etc.)
- brackets ( and )
- simple operators like +, -, /
- concatenation symbol / ampersand: &
It should be possible to use <CTRL> key to mark different non-neighbouring ranges in a Web spreadsheet (similar as in Excel). #1633816 votes
Currently only supported whole positive values are supported for the data filter, e.g. 'Top 10' values. It should be possible to use negative values to define e.g. -10 for 'Flop 10' values. #1533216 votes
Would be good to have an option for sheets to exclude/include them from snapshot export. #135604 votes
Choose several ETL components of one project which belong somehow logically together and group them under a given name.
Should be displayed in ETL Manager under a new item
A component may be assigned in different tags
Option to create a tag out of the dependency of a component (to decide if dynamic or not)
For new folder in File Manager, the default rights should be 'Deny' - No rights for groups except Admin
A customer expects, that by creating a new Folder in File Manager, the default rights for all groups (except Admin) should be denied - under Folder ->Properties->Security -> Full Control, Write and Read should be 'Deny'. #1236915 votes
Save a set (e.g. 10) of last-used colors and enable advanced color picker everywhere; helpful if you're using a lot of custom color codes (right-now, you have to re-enter color code each time).
Could be saved per server, not necessarily per user (it's a designer feature, typically you don't have to many different designers).
And it would be good if this set were available in all color dialogues:
- border colors (also DynaRange borders)
- font colors
- chart colors (bars, fills, borders etc., for dynamic charts, success charts, micro charts)
Some customers do not like the long external Report URL's we generate in Jedox Web, would be good to have some sort of URL shortening mechanism like incorporating http://yourls.org/ or similar into product.There also seems to be technical limitation for URL length in some 3rd party tools (e.g. Sharepoint). #1200921 votes
OLAP Server contains storage for persisting cell properties (e.g. number format, foreground color, note,...). This can be used to centrally define and store properties of the cell and then later be shared on different frontends e.g. define rule that all cells where value is negative, are displayed in red color. #117394 votes
Add ability to run confirmation prompt from macro (and if possible, make further execution of macro depending on user response) #1076693 votes
When selecting some cell which references named range, it should be possible to display name of the named range instead of the cell address in the address field in Jedox Spreadsheet #103436 votes
SQL Query Designer with UI that generates SQL from clicks, e.g. Query Builder as in MS Access + Editor with Syntax highlighting for SQL.
- Don't see your idea?