Adding formulas to table

Hi,

thanks for the question.

Unfortunately, I haven’t yet found the time to write the documentation for this, but you can find some examples in this forums thread: https://www.ads-software.com/support/topic/how-to-do-formulas

Regards,
Tobias

Hi Tobias, thanks for the link.

Unfortunately it’s not working on my end.

I’m currently testing with “=E33+E34” and i’m getting the error:

!ERROR! E33 does not contain a number or expression

These are the values:

E33= 68,096
E34=119,035

I also have a question: is there a way to sum up several cells at a time? like in MSExcel?

“=SUM(E2:E34)”

Many thanks

Hi,

the problem in this case are the thousand separators. Unfortunately, formulas can’t handle these, so you will have to remove all “,” from the cells.

And yes, =SUM(E2:E34) is possible. For the other possible functions, please see the list in the link above.

Regards,
Tobias

Hello Tobias,
Oooops, I think we cannot use other separator than a colon for figures representing quantities over a thousand. Period is only used for decimals.

83,649 (Eighty three thousands, six hundreds and forty nine)

83.649 (Eighty three, sixty four)

This column on the table represents money. I cannot change the separator and will be ideal to be able to sum column up. Did i hit a limitation? Any ideas?

many thanks. Francis

Hi,

yes, you basically ran into a limitation here. Formulas do not support any separators at this time, so you would have to write the number as

83649

The formulas will then work, but I acknowledge that this doesn’t look very nice, without formatting.

Now, I could imagine that it’s possible to format the numbers before they are printed to the page, i.e. that in the backend and in the formulas, the numbers are written as 83649, but when printed to the page, they appear as 83,649. Unfortunately, I don’t have the code for this readily available at the moment, as my time is limited.

Regards,
Tobias

Hi Tobias, I understand, no problem. As for now, I will not be able to use formulas this way.

Will you include this feature in future releases? that’ll be a great addition to an already great add-on. Thanks for your time!

Francis

Hi,

unfortunately, I can’t give an estimate of if or when this functionality might be available. It depends on the time I find to implement this, or whether someone sponsors it as a TablePress Extension.

Regards,
Tobias