Currently, there are a few Excel export options in Jedox Web:
XLSX
XLSX Snapshot
XLSX OLAP Snapshot
Customer would like to (1) keep supported formulas as formulas and (2) return value at unsupported formulas. XLSX (without the Snapshot) and XLSX OLAP Snapshot only satisfies the first condition, whereas XLSX Snapshot only satisfies the second condition. There is no export option that meets both conditions. The feature request is to have an export option that meets both conditions.
With XLSX OLAP Snapshot, some exported formulas like SUM are also working in a not optimal way. This function in Excel supports up to 255 arguments, e.g. SUM(A1,A2,A3,A4,....A255). When this function is used in Jedox to SUM values from dynarange with more than 255 rows, this function fails. Jedox should generate this using range like SUM(A1:A500), and not 500 arguments.
