• Resolved mmartinp

    (@mmartinp)


    Hi,

    I have this formula ={SUM(C2:C12)} in my table “row 13 column C”.

    I installed the extension “Single Cell Content Shortcode” to show just the result of this cell “C13”, but when I use the shortcode [table-cell id=8 cell=C13 /], it show me the formula instead of the result ??

    I appreciate your help in advance.
    Martin

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Unfortunately, I’ll have to disappoint you again. The Single Cell Shortcode Extension extracts the raw table data, before any formulas are evaluated. Thus, it can only retrieve the formula here, but not the calculated result.

    Regards,
    Tobias

    That’s too bad. I would have liked to have done that. Is there the possibility to adjust the extension like this: Parse shortcodes after formulars?

    Thanks and keep on your good work!

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no, sorry, I can think of a way to achieve that ??

    Regards,
    Tobias

    Hi,
    Something strange occurs on my site formation06.fr
    I use some table press IDs for the chapter “Tutoriels”
    My custom CSS is :
    .tablepress-id-3 tbody td,
    .tablepress-id-4 tbody td,
    .tablepress-id-5 tbody td {
    margin: 0 auto 1em;
    width: 1000px;
    border: 1px solid black;
    }

    .tablepress-id-3 .column-1,
    .tablepress-id-4 .column-1,
    .tablepress-id-5 .column-1 {
    width: 450PX;
    font-size: 14px;
    font-weight: bold;
    text-align: left;
    }

    .tablepress-id-3 .column-2,
    .tablepress-id-3 .column-3,
    .tablepress-id-3 .column-4,
    .tablepress-id-3 .column-5,
    .tablepress-id-3 .column-6,
    .tablepress-id-4 .column-2,
    .tablepress-id-4 .column-3,
    .tablepress-id-4 .column-4,
    .tablepress-id-4 .column-5,
    .tablepress-id-4 .column-6,
    .tablepress-id-5 .column-2,
    .tablepress-id-5 .column-3,
    .tablepress-id-5 .column-4,
    .tablepress-id-5 .column-5,
    .tablepress-id-5 .column-6 {
    width: 110PX;
    text-align: center;
    border-style: dotted;
    border-width: 1px;
    }

    .tablepress-id-3 .row-1,
    .tablepress-id-4 .row-1,
    .tablepress-id-5 .row-1 {
    font-size: 16px;
    font-weight: bold;
    text-align: center;
    }
    Table 5 refuses to react as 3 and 4
    Table 5 is located at
    https://formation06.fr/mathematiques-financieres/

    I really cannot understand.
    Thanks for your help

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    please uncheck the “Horizontal Scrolling” checkbox on the “Edit” screen of table 5.

    Regards,
    Tobias

    Hi Tobias,
    Thanks, this solutions works even if I do not understand why ?!
    Yoour extension is really great !
    All the best for you.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! ?? Good to hear that this helped!

    Best wishes,
    Tobias

    I have found a workaround, displaying just one cell with the result of a SUM formular. I used the normal table shortcode [table id=2] not the extension and did hide all the colums and rows I did not need, like this [table id=2 hide_columns=”2,3,4,5″ hide_rows=”2,3,4,5″].

    This example will only show the result of cell A1.

    Works for me and maybe for you as well @mmartinp

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    awesome, great idea!

    Best wishes,
    Tobias

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Single Cell Content Shortcode’ is closed to new replies.