Excel export enter gives new line?

Hi,

When i export entries to an excel file the enters in textarea's gives new lines? Is it possible to solve this?

Kind regards,
Alco

Yes, I have fixed it:
add the follow lines to functions.php

add_filter("gform_save_field_value", "save_field_value", 10, 4);
function save_field_value($value, $lead, $field, $form){
$new_value = str_replace(array("\n", "\t","\r"), ' ', $value);
return $new_value;
}

Hi Matthijs,

Thx for the solution!

Although its maybe a better idea to call a simalair function when the excel export is made? (maybe a function that makes it possible to choose?)