Hi,
thanks for your post, and sorry for the trouble.
For that, you would have to use e.g. the NUMBER_FORMAT() formula: https://tablepress.org/tablepress-features-formulas/
=${NUMBER_FORMAT([table-cell id=123 row=3 column=3 /],0)}
Before this works, you will have to also install a TablePress Extension that is explained at https://ww.wp.xz.cn/support/topic/referencing-data-from-another-tables-and-formulas/#post-7012433 (which basically allows using the Shortcodes in formulas).
Regards,
Tobias
Thread Starter
Sam L.
(@scionet)
Hello
I install and activated the plugin: Parse Shortcodes before Formulas.
Then added your formula:
=${NUMBER_FORMAT([table-cell id=105 row=12 column=2 /],0)}
and got the following error message:
$!ERROR! illegal character ‘[‘
Any thoughts on if the formula is missing something? Thank you
Thread Starter
Sam L.
(@scionet)
Please disregard my last message. I figured out my error. This works perfectly! Thank you so much.
Hi,
no problem, you are very welcome! 🙂 Good to hear that this helped!
Best wishes,
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!
Thread Starter
Sam L.
(@scionet)
FYI. When I add the shortcode: [table id=1 shortcodes_before_formulas=true /]
all the other tables on that page that I use the Features of the DataTables JavaScript Library are automatically disabled.
I tried with to add [table id=2 shortcodes_before_formulas=false /] to the table that use Features of the DataTables JavaScript Library, but it does not work.
-
This reply was modified 8 years, 7 months ago by
Sam L..
Hi,
that doesn’t make sense. This Shortcode parameter on one table definitely has no influence on the other tables. Can you please post a link to the page with the table where this problem happens, so that I can take a direct look? Thanks!
Regards,
Tobias
Thread Starter
Sam L.
(@scionet)
This page DOES NOT have the shortcode [table id=1 shortcodes_before_formulas=true /]:
notice the Holdings table on the middle with sorting features.
This page DOES have the shortcode [table id=1 shortcodes_before_formulas=true /]
notice Holdings table on the middle does not have sorting features if when that option is selected. The shortcodes before formulas is placed in the table that has the header Market Data.
When I remove the shortcode before formulas, the page loads with all the features.
Thank you Tobias.
-
This reply was modified 8 years, 7 months ago by Sam L..
-
This reply was modified 8 years, 7 months ago by Sam L..
Hi,
it seems like you are entering the Shortcode into the “Custom Commands” text field. That’s the wrong place.
You should modify the Shortcode that you already have on that page.
Regards,
Tobias
Thread Starter
Sam L.
(@scionet)
Thank you!!! That worked. I so very much appreciate your help and this tremendous. Please look for a donation to your PayPal today.
Thread Starter
Sam L.
(@scionet)
Sorry, donation went to Amazon. We do not have a PayPal account – one must sign up for PayPal account donate to you.
-
This reply was modified 8 years, 7 months ago by Sam L..
Hi,
no problem, you are very welcome! 🙂 Good to hear that this helped!
And thanks for donating, I really appreciate it! 🙂
Best wishes,
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!
Hello
I’m using Single Cell Content Shortcode to get data from Table 1 to a webside. Content of the cell is a formula like ={SUM(C2:C11)} €
What is output is the text of the formula. What do I have to do to get the value?
Thank you!
Hi,
thanks for your question, and sorry for the trouble.
Unfortunately, this is not possible. The Single Cell Shortcode Extension can only retrieve the raw data, which is the formula. Sorry.
Regards,
Tobias
