Show SUM-shortcode in summary table

  • Resolved xanderdekker

    (@xanderdekker)


    10 years, 4 months ago

    The use of shortcodes works perfect, but there is only one thing that’s not working for me…

    I created 9 specific tables, with 2 columns and 10 rows.
    The 1st row / 2nd column has the formula: ={SUM(B2:B10)}
    – This formula works

    Then I created 1 summary table with 10 rows, 2 columns:
    The first column contains teamnames, the second column contains the shortcode: [table-cell id=15 cell=B1 /] –> This to show the B1 cell of Table 15.

    Instead of showing me the SUM of the values in B2:B9 from Table 15 it shows the Formula again ( ={SUM(B2:B10)}).

    The shortcode of the table on my wordpress page is: [table id=1 shortcodes_before_formulas=true /] –> And yes, I installed and activated the shortcode plugin and the Parse Shortcodes before Formulas plugin.

    What am I doing wrong, or is this just not going to work?

    https://wordpress.org/plugins/tablepress/

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

    (@tobiasbg)

    10 years, 4 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Sorry, this is not going to work like this. 🙁 The TablePress Single Cell Shortcode will only print the raw table data, but not the evaluated formular.
    For that, you could basically show this as a “mini table”, with just one row/column, e.g. with

    [table id=15 hide_rows=all hide_columns=all show_rows=15 show_columns=B /]

    Regards,
    Tobias

    Thread Starter xanderdekker

    (@xanderdekker)

    10 years, 4 months ago

    Hi Tobias,

    I don’t get it….
    What do I have to do with the code you send me?

    When I use it in a tablecell or on a homepage it just shows a blank cell / space.

    Is there no formula that I can use like: SUM(table id=15 B1:B10) ?

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    10 years, 4 months ago

    Hi,

    ah, sorry, my suggested Shortcode contains a mistake. Please try again with

    [table id=15 hide_rows=all hide_columns=all show_rows=1 show_columns=B /]

    That is basically the equivalent of

    [table-cell id=15 cell=B1 /]

    but instead of just showing the cell content, it has some extra HTML code around it (to create a 1×1 table).

    The alternative for the summary table would be to include the full formula there, like this:

    ={SUM([table-cell id=15 cell=B2 /],[table-cell id=15 cell=B3 /],[table-cell id=15 cell=B4 /],[table-cell id=15 cell=B5 /],[table-cell id=15 cell=B5 /],[table-cell id=15 cell=B7 /],[table-cell id=15 cell=B8 /],[table-cell id=15 cell=B9 /],[table-cell id=15 cell=B10 /])}

    Regards,
    Tobias

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

The topic ‘Show SUM-shortcode in summary table’ is closed to new replies.

Tags