exporting invoicelines to excel vs save as excel

[Joost Miltenburg]

FM13v5

MacOSX 10.10.1

 

LS,

 

Strangest thing. 

 

I am exporting invoice lines with some invoice header date ( print_date, invoice_number ). I have done this dozens of times, but after export the excel opens with hundreds of white lines between records.

When I us save this file with 'save as excel' the data contains no white lines.

 

I added portals to the lines to see if there are one to many relationships, but there are none.

 

Any ideas as where to look ?

 

TIA

[No_access]

have you tried trimming the whites paces, here is a custom function that I use from briandunning.com

 

http://www.briandunning.com/cf/166

[Lee Smith]

@no_access, The Trim4  is a very useful custom function that I use often. However, I’m not sure how it comes to play when working with exports to Excel.

 

@Joost,  what’s the purpose of exporting to Excel? Maybe more information on what you’re trying to accomplish could help us. Also if this is a scripted process a copy of your script and or file might help us as well.