$ as text in cell

Hi,

thanks for your question!

Unfortunately, I don’t have a solution to this yet, sorry ?? Formulas always use the entire cell, so it’s not possible to put extra characters into those cells. And as the formulas themselves don’t work with strings/other characters in them, it’s not possible to achieve something like this ??

The best choice to achieve this would be to use a plugin filter hook and then add the $ with some PHP code afterwards. That will require a little bit of custom coding though.

Regards,
Tobias

I am always up for a challenge. So time to start learning! Thanks.

Hi,

the best way should then be to use the tablepress_cell_content filter, and then check for table ID, column number, and row number, and if everything matches, change the cell content, and return that.
The TablePress Extension from https://tablepress.org/extensions/php-in-tables/ should be a good template (everything except the actual content/body of the function, but just the “structure” of how that filter is used).

Regards,
Tobias

Hi,

good news: I just came up with another solution ??
I added some code to the formula parser that now allows using formulas within strings. That change will be part of TablePress 1.1, which should come out next weekend. If you want to use it now, you can install the current developer version from https://tablepress.org/download/tablepress-dev.zip .

After installing that, you can use your current formula like this:

=${SUM(B3:B4)}

As you can see, the actual formula just needs to be wrapped in { and }, and the entire cell has to start with a = (just as now) to indicate that the cell contains a formula. The rest of the cell (i.e. everything outside of the {...}) will be treated as text and will stay around the formula result.

Regards,
Tobias

Wow. Now that is support. I just sent you $20.00 Keep up the great work.

Hi,

no problem, you are very welcome! Good to hear that this helps!
And thanks for the donation, I really appreciate it! ??

Best wishes,
Tobias