WordPress.org

Support

Support » Plugins and Hacks » TablePress » [Resolved] Adding formulas to table

[Resolved] 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

    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

    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

    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

    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 ‘[Resolved] Adding formulas to table’ is closed to new replies.
Skip to toolbar