Posted 4 August 2017, 2:47 pm ESTHi,
when exporting a report to xls we encounter the problem that tiny lines are created.
All the fields are positioned by a pgm and have all the same .top value
1) The tiny extra rows for all ARCHES records
2) Why only ARCHES, not others
3) Why is line 20 in xls created like this? Row height far too big (it't coming from group footer).
Set myExcelExport = New ActiveReportsExcelExport.ARExportExcel
myExcelExport.Version = 8
myExcelExport.FileName = fSaveAsDlg.saveAsDlg.FileName
myExcelExport.AutoRowHeight = False 'True
'myExcelExport.BorderSpace = 0
myExcelExport.TrimEmptySpace = False ' important! '
myExcelExport.MultiSheet = True
myExcelExport.ShowMarginSpace = True
myExcelExport.DoubleBoundaries = True
myExcelExport.MinColumnWidth = 500 ' do not make it larger (colour problems otherwise) '
myExcelExport.MinRowHeight = 50 '25
The attached file includes screen shots and .rpx
Any ideas to overcome these problems?