Support » Plugin: TablePress » Adding formulas to table

Viewing 7 replies - 1 through 7 (of 7 total)
• Plugin Author TobiasBg

(@tobiasbg)

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: http://wordpress.org/support/topic/how-to-do-formulas

Regards,
Tobias

elevensuns

(@elevensuns)

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

Plugin Author TobiasBg

(@tobiasbg)

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

elevensuns

(@elevensuns)

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

Plugin Author TobiasBg

(@tobiasbg)

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

elevensuns

(@elevensuns)

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

Francis

Plugin Author TobiasBg

(@tobiasbg)

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

Viewing 7 replies - 1 through 7 (of 7 total)
• The topic ‘Adding formulas to table’ is closed to new replies.