John -
In addition to Gary's suggestions, a) I've found it's also helpful to left-align the values in all column headings as well as the data fields and align the column heading directly above the data field. That way Excel knows for sure where each new column starts. You may have to jimmy around with the distance between each column to eliminate the extra blank spaces b) Remove any page headers/footers so there isn't anything that prints every 60 or so lines - put column heads in the Report Header section and totals in the Report Footer section ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Wendike Sent: Tuesday, September 30, 2008 12:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Extra columns in XLS spreadsheet John, what I have had to do in the past is create a specific xls report. The xls report had to have the locations of columns adjusted in order to correctly lineup within the spreadsheet. Then number of columns and required spacing may change the size of page. Use what is necessary to print the report to the xls spreadsheet. The key is to line up the columns as to how they will fit in the Excel spreadsheet. I would recommend you use a very common font...example - Arial 10. You also can eliminate some of the lines that you would draw on a report for separation they won't transfer as you want. Gary ----- Original Message ---- From: John Engwer <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, September 30, 2008 9:37:50 AM Subject: [RBASE-L] - Extra columns in XLS spreadsheet I am creating a one sheet XLS spreadsheet and I am getting a blank column after each data column. All of the data is there. Here is my print command: PRINT mailer_xls_out OPTION XLS + |FILENAME C:\OSSA\MAILER\MAILER.XLS + |SHOW_CANCEL_DIALOG OFF + |CELL_ATTR ON + |INCLUDE_RICH_TEXT OFF + |RICHTEXT_ENCODING_TYPE IMAGE + |LINE_SPACE ACTUAL + |ONE_SHEET_PER_PAGE OFF |OPEN ON How can I eliminate the blank columns? John
