Jump to content

exporting invoicelines to excel vs save as excel


Joost Miltenburg
 Share

This topic is 2904 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

@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.

Link to comment
Share on other sites

This topic is 2904 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.