I appears that the required cell width is not being recognized by Excel when the data is passed from a report. If the data is wider than the default cell width in Excel, then an extra column is inserted. If the data width is =< the default no extra column is not created.
The Excel width automatically adjusts if you export the same data via the browse or gateway. John From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Engwer Sent: Tuesday, September 30, 2008 2:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Extra columns in XLS spreadsheet Thanks Gary and Sami, I am using Arial 10 and I have tried other fonts also. At this point, I have no title, no column names; just data in the report and I still get the extra columns. If I export the same data to XLS using browse, there are no extra columns. I can't think of anything else to do. Maybe the print to XLS is not working properly. I will play with it a little more before I give up. John From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Wendike Sent: Tuesday, September 30, 2008 1: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
