marcrentschler

No, WordPress shows my code exactly like I use it. It works with both the entity code or the actual character.

Ah.. I understand now…

I tried both variants. Your code with ” and with & quot;. Both did not work. In my code I really use & quot; which is working fine.

” instead of "

OK… where would you use ” instead of ” ?

Thanks a lot for developing this code! Unfortunately it gives me again a formula error :/

But it pointed me into the right direction. I now make all calculations in PHP, store them in a variable and insert this variable into the cell. That is fine for me because the Excel table will not change after export. So a static value is OK.

This is the PHP code I am using right now:

add_action("woe_xls_print_footer", function($objPHPExcel,$formatter) {
  $sheet = $objPHPExcel->getActiveSheet();
  for($i=2;$i<=$formatter->last_row;$i++) {
	  	$dauer = $sheet->getCell(&quot;M$i&quot;)->getValue();
	  	$preis = $sheet->getCell(&quot;N$i&quot;)->getValue();
	  	$honorar = 0;
	  	if($preis <= ((76.7 / 100) * $dauer)) {
	  		$honorar = $preis - ($dauer / 90 * 23);
	  	} else {
	  		$honorar = $preis - (1 / 3 * $preis);
	  	}
	  	$honorar = number_format(round($honorar, 2), 2, ',', '');
		$sheet->setCellValue( &quot;Q$i&quot;, &quot;$honorar&quot;);
	}
},10,2);

Thank you very much for your instant help!

For testing purposes the formula now just is for the second row. In the next step I wanted to make it dynamic so that it works in the other rows. I do not know yet how to do that. But I wanted to test the export of the formula for the 2nd row and received the mentioned error.

Thanks for your reply! I tried with version 1.5.5 and 2.0.0. I get the same error in both versions.

If I change the formula to

=ROUND(IF(N4<=76,7%*42;N4-(M4/90*23);N4-(1/3*N4)),2)

I get the same error. Or what do you mean by

how will it work for 3,4,5th row?

I have the same issue. Can anyone provide a step-by-step tutorial on how to implement that filter? I would be very happy!! Thanks in advance!

Thank you very much for the quick update! All works fine now! I also see all images and headings! Very nice plugin!!

Mikko, thank you very much for your reply! We will find out.

Thanks for your reply! Could you please give me an example if possible? Which file would I have to edit?