Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    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

    Thread Starter KingShinobi

    (@kingshinobi)

    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 🙂

    Plugin Author TobiasBg

    (@tobiasbg)

    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

    Plugin Author TobiasBg

    (@tobiasbg)

    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 http://tablepress.org/download/tablepress-dev.zip and replace your “tablepress” folder with that from the ZIP archive.

    Regards,
    Tobias

    Thread Starter KingShinobi

    (@kingshinobi)

    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.

    Thread Starter KingShinobi

    (@kingshinobi)

    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.

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

    Plugin Author TobiasBg

    (@tobiasbg)

    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

    Thread Starter KingShinobi

    (@kingshinobi)

    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.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    ok, that could indeed mean that there’s a JavaScript problem. Please try checking for script errors with the instructions on http://codex.wordpress.org/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

    Thread Starter KingShinobi

    (@kingshinobi)

    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: http://www.apl-online.at/paintballbundesliga.at/wp-content/plugins/tablepress/admin/common.min.js?ver=0.9-RC
    Zeile: 1
    Plugin Author TobiasBg

    (@tobiasbg)

    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

    Plugin Author TobiasBg

    (@tobiasbg)

    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

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘math sum function with empty cells’ is closed to new replies.