Adding " " sign to positive values?

  • Resolved Northwave

    (@northwave)


    13 years, 1 month ago

    Hi!

    Is it possible to get the “+” sign added in front of positive results, when adding two cell values together?

    If I add cell-values with i.e. “+4” and “-7”, I get the negative result of “-3”. Which is of course okay. But when the result is positive, say with values “+5” and “-2”. Then I would like the result to show like “+3” and not as usual “3”.

    Thanks in advance!

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 1 month ago

    Hi,

    there’s no built-in functionality for this, but you could use a plugin filter hook to check the table for numbers and add a “+” in front of every positive number.

    I’ve turned this functionality into a TablePress Extension. To use it, just install and activate http://tablepress.org/download/extension/tablepress-plus-sign-positive-numbers.zip like a regular WordPress plugin and extend your table’s Shortcode with another parameter, like

    [table id=1 plus_sign_positive_numbers=true /]

    After that, all positive numbers in that table will get a “+” sign before them.

    Regards,
    Tobias

    Thread Starter Northwave

    (@northwave)

    13 years, 1 month ago

    Wow, very nice, thanx! 🙂

    Sorry not to have mentioned before, but I would need that “+” sign only to apply in one specific column, not in the whole table. Is it easy to change the Extension-code to apply that functionality?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 1 month ago

    Hi,

    ah, ok 🙂

    I’ve extended the Extension so that it now accepts a column number (or even range), so that you can specify on which columns you want this.
    Just replace your current version of the Extension with that from a fresh download (same URL as above). After that, you can use a Shortcode like

    [table id=1 plus_sign_positive_numbers="3,4,5"/]

    which accepts a list of column numbers (and single values of course).

    Regards,
    Tobias

    Thread Starter Northwave

    (@northwave)

    13 years, 1 month ago

    Hi,

    thanks again! I’ve tested the updated Extension and it almost works 🙂

    If I add two values, for example “4” and “-2”, it returns the correct value of “+2”. But, if I add the values “+4″ and “-2” it gives an error of !ERROR! unexpected operator '+'. Any solution for this?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 1 month ago

    Hi,

    yes 🙂 Don’t put in a value like “+4” 🙂 Can’t you just leave it as “4”? The extension will add the “+” automatically when the cell is displayed.

    Regards,
    Tobias

    Thread Starter Northwave

    (@northwave)

    13 years, 1 month ago

    Hi,

    yeah, that came into my mind also. Just wondered if there was a simple solution into the code 🙂

    But no worries, I’ll modify my tables so that they will work, thanks a lot!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    13 years, 1 month ago

    Hi,

    no, sorry, I don’t have a solution to this, as that could again interfere with the process of adding the “+” to the calculation results.
    Modifying the numbers so that they are without “+” signs initially is the best way to go here.

    Best wishes,
    Tobias

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Adding " " sign to positive values?’ is closed to new replies.