WordPress.org

Ready to get started?Download WordPress

Forums

TablePress
[resolved] Adding formulas to table (8 posts)

  1. elevensuns
    Member
    Posted 1 year ago #

    Hi, we're using a table on which we wold like to perform a sum of rows,

    http://www.asensiopartners.com/?page_id=10

    "Tables can contain any type of data, even formulas that will be evaluated."

    I haven't found any information on how to add formulas to a table. Can you advise on this topic? thanks

    Francis

    http://wordpress.org/extend/plugins/tablepress/

  2. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

  3. elevensuns
    Member
    Posted 1 year ago #

    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

  4. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

  5. elevensuns
    Member
    Posted 1 year ago #

    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

  6. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

  7. elevensuns
    Member
    Posted 1 year ago #

    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

  8. TobiasBg
    Member
    Plugin Author

    Posted 1 year ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.