Maximum of formulas in one table

Resolved ihlonline
(@ihlonline)

10 years, 7 months ago

I am so sorry for asking the third question in short time, but this will be my last one I guess.

I implemeted easy going formulas in my table. Via row filter I show smaller versions of my tables. Everything okay, but:

In the smaller versions just some rows make the code working. I doublechecked the formula and it is allright. In my main table these formulas are working (image 1). In the filtered tables it is just working for some rows. What the hell is the mistake I cannot find?

Image 1: http://www.ihlonline.de/img/Bildschirmfoto%202013-09-11%20um%2010.42.52.png

image 2: http://www.ihlonline.de/img/Bildschirmfoto%202013-09-11%20um%2010.43.15.png

You can take Buffalo as an example. In image 1 it is working perfectly, in Image 2 it does not work at all (everywhere a “0” is appearing, there is code in there which does not work.)

Sorry for heaps of questions

http://wordpress.org/plugins/tablepress/

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

Thread Starter ihlonline
(@ihlonline)

10 years, 7 months ago

Okay, I see:

The table take over the commands 1 by 1 from the main table what means,that it calculates with cells which are not appropriate any longer. While Detroit is in row 6 in the main table it got a new row parameter in the smaller one. This is a problem for which I dont know a solution…

Do you?
Plugin Author TobiasBg
(@tobiasbg)

10 years, 7 months ago
Hi,

thanks for your question, and sorry for the trouble.

Yes, your analysis is correct. The formulas are evaluated after the rows that don’t match the filter word are removed, and because of that, the cell references in the formulas don’t match the intended cells.

To change this, you could modify the Row Filter Extension to do the filtering after the formulas have been evaluated. To do that, in the file “tablepress-row-filter.php”, please change line 41 from
```
add_filter( 'tablepress_table_raw_render_data', array( __CLASS__, 'filter_rows' ), 10, 2 );
```
to
```
add_filter( 'tablepress_table_evaluate_data', array( __CLASS__, 'filter_rows' ), 10, 3 );
```
and line 96 from
```
public static function filter_rows( $table, $render_options ) {
```
to
```
public static function filter_rows( $table, $orig_table, $render_options ) {
```
Regards,
Tobias
Thread Starter ihlonline
(@ihlonline)

10 years, 7 months ago

Okay,

its awesome what you can change just with a few characters in a PHP Script. Dont ask why, but it is working now. Hopefully that was my last question.

I am ahsamed of asking so much “basic” questions. However: You did it (again)

Thank you very much, appreciate it!

Plugin Author TobiasBg
(@tobiasbg)

10 years, 7 months ago

Hi,

don’t worry, that’s definitely not a “basic” question! 🙂

Good to hear that this worked!

Best wishes,
Tobias

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

The topic ‘Maximum of formulas in one table’ is closed to new replies.