How can we improve Jedox Software?

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.

If "SUMIF($G$2:$G$4,B3,$E$2:$E$4)" is specified in a cell covered in a dynarange and then the dynarange is expanded, "SUMIF($G$3:$G$5,B4,$E$3:$E$5)", "SUMIF($G$4:$G$6,B5,$E$4:$E$6)",etc will be defined in the cells in the expanded lines.

I would like to make those formulas always refer to same cell, but even if the cell is specified using dollar sign ($), the position of the cells are changed.

Could you consider to change the behavior of the dynarange , so that position of the cells specified using dollar sign ($) won't change when the dynarange is expanded.

2 votes
Sign in Sign in with Jedox AG
Signed in as (Sign out)

We’ll send you updates on this idea

Akito Tanaka shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in Sign in with Jedox AG
Signed in as (Sign out)

Feedback and Knowledge Base