How to do formulas?

Hi Clifford,

thanks for your question!

Yes, using formulas is not yet documented. I just didn’t have the time yet :-/

But it’s not really difficult, and it works very similar to Excel:
A formula starts with an = and then contains a mathematical expression, in which you can also reference values from other cells, by using their cell name. Here are two basic examples:

=A1+B3

will sum the cells A1 and B3.

=AVERAGE(C3:C10)

will calculate the average value of the cells from C3 through C10.

Other math functions that can be used are

sin, sinh, arcsin, asin, arcsinh, asinh, cos, cosh, arccos, acos, arccosh, acosh, tan, tanh, arctan, atan, arctanh, atanh, sqrt, abs, ln, log, exp, floor, ceil, average, max, min, mod, pi, power, round, sum, rand_int, rand_float

Does that help?

Regards,
Tobias

P.S.: And thanks for your donation, I really appreciate it!

Hi,

sure, no problem! You are very welcome! 🙂

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Hi Clifford,

thanks for your feedback on the formulas feature!

I’ll answer your questions one by one:

1. TablePress does auto-update formulas. For example, if a cell references another cell C5, and C5 moves for some reason, then that is automatically updated in the first cell. If the first cell moves, but C5 remains in the same place, nothing changes of course. I’m not sure though how you got that error from the screenshot after a drag and drop. Cell A1 is the top left cell, which says “Header”, and that’s obviously no expression or number. Also, note that fixed cells like A!1! or A1! or A!1 are not supported. This would require a much more sophisticated logic which I’m not capable of implementing right now :-/
2. No, I’d rather not offer such an option. Usually, the person editing a table (and the formulas in it) is the person who checks a table (the “Preview” is very handy for that), so that such errors can be spotted and fixed immediately, before the changes to the table go live.
3. Yes, cell references need to be capitalized, as the column labels are also capital letters only. Adding support for lowercase references would probably be possible, but I’d much rather keep things consistent.
4. This is going to be tough, but unfortunately, I have to disappoint you: TablePress tables can not be edited by a visitor, but only on its “Edit” screen. That’s simply the purpose of the plugin (showing static data, but not really offering dynamic behavior). User-editable tables are not possible, sorry.
   A calculator should probably be possible in plain JavaScript, and there is likely code available for that in the web. It might just not yet be readily usable as a WordPress plugin (at least I don’t know any calculator plugins).
5. Yes, Editor for DataTables has a different purpose/use case and will not really help you here. Also, it can not be used in TablePress at this time.
6. For the “Print” option, I’d recommend TableTools actually. In fact, TableTools is available as a TablePress Extension. Unfortunately I had to take it offline for now, as it contains an issue, due to which it can not be used right now. (This announcement about TablePress’ predecessor WP-Table Reloaded, in which I also had to remove TableTools, gives you a clue.) I hope to be able to make it available again in the near future, and it will then be available on the TablePress Extensions page on the plugin website.

Regards,
Tobias

Hi,

no problem at all! Sorry though that I couldn’t help with that calculator idea…

Best wishes,
Tobias

Hi Per,

well, what’s the content of cell C2? According to that error message, it is not a number or math formula, so you need to fix that.

Regards,
Tobias

Hi Per,

you’ll need to write that as 5650.95.
The formulas do not support commas as the decimal separator right now, as they require the English number format.
I’m thinking about a solution, but it’s not trivial…

Regards,
Tobias