Some months ago you solved an export issue with this:
Try something like this: from Invoice Table: Go to related records, sort by Invoice No and then export the Line Table.
We have the same export issue: we have some blanc cells in our excel export file. When an Invoice consists of more than 1 item, the excel file contains several records for that Invoice but the Invoice No is listed in just 1 record. That is wrong. We need the correct Invoice No to be listed in every single excel record.
We do not understand your solution for this.
Can you explain in detail what has to be done to get the complete excel file?