math sum function with empty cells

Hi,

thanks for your post.

That’s an interesting question.
I have never really though about treating empty cells as 0. While it might make sense, I’m not sure if I can implement that, but I’ll take a look!

Until that, you’ll have to remove the “D5” from the formula.

Regards,
Tobias

ok i will leave them out for now. maybe a solution could be to alter the “empty cells on the bottom sorting” by sorting first and then giving those cells the value “0”, but without displaying it.

maybe it’s total nonsense what i just wrote ??

Hi,

no, that won’t work, unfortunately ?? The sorting is done via JavaScript in the browser, when the math formulas have already been evaluated (by PHP on the server).

The question really is, if I can let the math evaluation library treat empty cells as 0, but still display them as empty.

I’ll take a look and keep you updated here.

Regards,
Tobisa

Hi,

good news: I’ve added a change to the latest development version, that treats empty cells as 0. ??

I would be happy if you could test this! Just install the development version from https://tablepress.org/download/tablepress-dev.zip and replace your “tablepress” folder with that from the ZIP archive.

Regards,
Tobias

hi,

I installed the new version, but since i’m not running wp 3.5, it says my wordpress version is too old. the problem is, that 3.5 broke some plugins i used, but i hope that 3.5.1 got rid of this problems.

ok i updated wordpress and it seems to run fine.

good news: the math function seems to work fine.

bad news: i cannot save changes anymore to my table and the sorting arrows are also screwed up.

https://www.apl-online.at/paintballbundesliga.at/tabellen/

Hi,

ah, sorry, I should have mentioned that the new version 0.9-RC requires WordPress 3.5. Sorry about that. But great to hear that you were able to update.

And thanks for checking the math functions ??

About the bad news:
– The problem with saving changes might be related to a JavaScript conflict. Do you see any error messages when saving? And can you please try to find out if there are JavaScript errors reported on the “Edit” screen, with the help of this codex page.
– The sorting arrows are mixed up due to a change in the HTML markup and the default CSS for them (because the sorting arrows now use an icon font, as mentioned in the TablePress 0.9-RC release announcement). You’ll have to redo parts of your “padding” CSS. As a start, please remove the lines

padding:8px 0px 0px 15px;

and

padding:8px 5px 0px 0px;

from your “Custom CSS.

Regards,
Tobias

ok so the error is not browser specific. tested in firefox and chrome. when clicking on the “save changes”, nothing happens. after adding

define(‘SCRIPT_DEBUG’, true);

to the wp-config.php, the problem is gone and works fine in both browsers. i hope that helps.

Hi,

ok, that could indeed mean that there’s a JavaScript problem. Please try checking for script errors with the instructions on https://codex.www.ads-software.com/Using_Your_Browser_to_Diagnose_JavaScript_Errors

If you have trouble with that, please contact me via email, with the details to your WordPress admin area, and I will have a direct look. (The address is in the main plugin file “tablepress.php”.)

Regards,
Tobias

i get two errors:

Fehler: TypeError: e is undefined
Quelldatei: .../wp-admin/load-scripts.php?c=0&load%5B%5D=jquery,utils,plupload,plupload-html5,plupload-flash,plupload-silverlight,plupload-html4,json2&ver=3.5.1
Zeile: 2

Zeitstempel: 28.01.13 11:00:23
Fehler: TypeError: postboxes is undefined
Quelldatei: https://www.apl-online.at/paintballbundesliga.at/wp-content/plugins/tablepress/admin/common.min.js?ver=0.9-RC
Zeile: 1

Hi,

ok, thanks for checking. That could mean that there’s another plugin interfering with the JavaScript.

If possible, I’d like to take a direct look at this, to maybe find out more. Can you please contact me via email, as mentioned above?

Thanks!
Tobias

Hi,

just as an update for everybody:
After working with KingShinobi directly on this, we found that the plugin “LambertGroup – AllInOne – Banner Rotator” was inserting its JS into the TablePress pages and caused this issue. Turning it off fixed things.

Regards,
Tobias