Removing HTML markup from exported file

Hi @verysiberian,

I’ve taken a very close look at this, but unfortunately I’m currently unable to produce styling inside the cell. This looks like a problem with the underlying library; and have opened an issue there in the hopes they can help.

In the mean time you can use the following snippet to at least remove the html tags from the output.

add_filter( 'gfexcel_field_value', function ( $value ) {
	return strip_tags( $value );
} );

Thank you, Doeke! I hope it works out. In the meantime, I added the filter you kindly provided, which at least improves upon having a bunch of HTML. ??

Best regards,
Very Siberian/Rob

Hi Rob,

Apparently I already had it figured out; it was simply using Numbers (on a mac) that did not show the correct styles. But the real Excel did! So you can use the following snippet to get (some of the) styling in the cell.

gfexcel_renderer_cell_properties_1 refers to form 1, so if your form has a different ID please update the 1 accordingly.

The 7 refers to the field id inside that form. Again, please update this to the correct field.

The nl2br call might be superflous, but you can always remove that if you get too many new lines.

I hope this helps you out.

PS, Like I said; it only shows some of the styling. It does the basic stuff like bold, italic, etc. But alignment does not work. But some is better than none I suppose? ??

Kind regards,

Doeke

add_filter( 'gfexcel_renderer_cell_properties_1', function ( $cell, $value ) {
	if ( $value->getFieldId() != 7 ) {
		return;
	}

	$content = $value->getValue();
	if ( $content != strip_tags( $content ) ) {
		// contains HTML
		$html = new PhpOffice\PhpSpreadsheet\Helper\Html();
		$cell->setValue( $html->toRichTextObject( nl2br( $content ) ) );
	}
}, 10, 2 );

Thank you very much! This is really helpful and improves the export greatly.

Best regards,
Rob