Dynamic formatting - formula limitation

[Former Member]

Hi Expert,

We're having some confusing issue with dynamic formatting template.

It seems that when we exceed 100 formulas, the following formulas simply do not work. Even the button 'Remove' is inactive and has different label  - 'Button'. I can not find any information regarding such limitation in the documentation.

Can somebody confirm the limitation of 100 formulas per Workbook?

Regards,

Maciej

[former_member186338 · Accepted solution]

Hi Maciej,

I don't know about the limitations, but what is the idea to have so many formulas? It will slow down the report execution... May be it's better to use some property etc...

Vadim

[Former Member · Accepted solution]

Thank you for your reply Vadim.

The idea is that we have to load around 150 opening balances from a document our customer has been using and the easiest way seemed to be dynamic formulas to map source fields into accounts in our form.

Well anyways, we already figured out how to work this around. We'll create standard Excel formulas and then will have to copy/paste the data into active area of the form.

PS.

I managed to replicate this issue in another document so apparently you can't create more than 100 dynamic formulas in a Worksheet.

Thanks again Vadim,

Regards,

Maciej

[former_member186338 · Accepted solution]

"The idea is that we have to load around 150 opening balances from a document our customer has been using and the easiest way seemed to be dynamic formulas to map source fields into accounts in our form." - still think there is a better way May be using local members etc...