velvet_ant

Hi Tobias,

We’re so close! That suggestion did display the value from table 12, cell B14 on the summary page. However, the cell of the table displayed on the summary page appears to have quite a bit of padding: https://labs.russell.wisc.edu/wirc/test-species-summary-page/

I imagine that there is some CSS code that could be used to remove the padding around the value?

Cheers,

Craig

Hello,

Yes, I thought my second problem might be an issue. It would be great if I could just total all the rows in a table, but unfortuantely not every row has a species. Some rows are used to list higher levels of classification like tribe or subfamily, so they would be excluded from the total number of species (you can see an example here: https://labs.russell.wisc.edu/wirc/non-type-holdings/coleoptera/family-buprestidae/).

I don’t suppose it’s possible to take the result of a formula in one cell and paste just the value in another cell? (In Excel, it would be analagous to the ‘Paste Special…’ option under the ‘Edit’ menu, where you can choose to paste just the value.)

Cheers,

Thanks for the quick responses, Tobias!

That seems to have fixed it! The extensions were active and the shortcodes_before_formulas=true parameter appeared to be added properly to the Shortcode. However, since it was still giving me an error, I deleted everything from the page and then used the ‘table’ button to re-add the table to the page. I then added the parameter setting and saved the changes. After that, it worked. (Maybe I had a typo before that I just couldn’t see…)

On this site I have many pages which are simple lists of insect species. I am using TablePress so I can have a total number of species at the bottom of each page. I figured out that I needed to have a hidden column to the right of the species names with either a 1 or a 0 so I could then sum the column and display a total for that page. Now, what I would like to do is call totals from many different pages and summarize them on a summary page. I just tried using ” =[table-cell id=12 cell=B14 /] ‘ in a cell on the summary page, where cell B14 in table 12 contains the sum function for that table (” =sum(C1:C13) “). However, this results in the same error message. Is there a way I can do this?

Cheers,

Hello,

I checked with our WordPress/Multisite administrator; this is what she said:

“I deactivated the plugin, pulled down
https://tablepress.org/download/tablepress-dev.zip, and replaced the old folder
on the server with the new dev one (unzipped). I reactivated the plugin, and in
the WordPress plugin page, the version still reads Version 0.9-RC.”

Cheers,

Hi,

I apologize in advance for simple questions; I’m fairly new to WordPress and to TablePress. I’ve used TablePress to create several tables and I’m interested in calling table cell values from one table and displaying them in another table. Our dept. admin has us running WordPress 3.5.1 on a Multisite, we’re running TablePress 0.9-RC plus the two extensions: Parse Shortcodes before Formulas and Single Cell Content Shortcode.

I cannot get values to display properly, I typed “=[table-cell id=12 cell=”A3″ /]” (without the quotes) in a cell in a new table, id=17, and when I view the page that has the shortcode for table 17, it displays the message ” !ERROR! Too many “=” “. Cell A3 in table 12 has the number 5.

I’m trying to display table 17 on this page ( https://labs.russell.wisc.edu/wirc/test-species-summary-page/ ); I tried using this short code: [table id=17 shortcodes_before_formulas=true /].

That probably wasn’t very clear, but please let me know what additional information you might need to help with my problem.

Thanks in advance!