[RBASE-L] - RE: Printing a Report to XLS File

[beyring]

Jason,

 

Thanks for the reply.

 

It's when I print a report. It seems it wants to put a blank column "I" between Columns "H" and "J" . there is no data for column "I". Column "I" should not be there. I need to use a report as there is a first column with line descriptions. Columns B through K should be contiguous, there are no blank data columns. It seems Excel is formatting the report and inserting column "I" for some reason.

 

Maybe there is a formatting option that will eliminate the blank column when printing ?

 

There is no problem with Gateway or CSV.

 

Bill

 

 

-------- Original Message --------
Subject: [RBASE-L] - RE: Printing a Report to XLS File
From: "Kramer, Jason J" <jjkra...@udel.edu>
Date: Wed, July 23, 2014 6:52 am
To: rbase-l@rbase.com (RBASE-L Mailing List)

Dear Bill,

                Do you have the same problem if you do a GATEWAY EXPORT instead of PRINT?  Do you get a blank column if you use a CSV file instead of an Excel file?  Is  the terminal character in column 5 something that R:BASE in interpreting as a delimiter and making an extra column (is the last character being dropped from column 5)?

                                                                                Jason

 

Jason Kramer

University Archives and Records Management

002 Pearson Hall

(302) 831 - 3127 (voice)

(302) 831 - 6903 (fax)

 

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of beyr...@lampsoftware.com
Sent: Wednesday, July 23, 2014 9:34 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Printing a Report to XLS File

 

I have a report which prints to an XLS file.

 

Everything comes through to the XLS file with one exception;

 

The report can have between 7 and 11 columns depending on the data.

 

When the XLS file opens there is a blank column inserted between columns 5 and 6. Now I know I could just delete the column on edit, but I would rather see that inserted column gone with all columns being contiguous.

 

Here is my code to print to an XLS file;

 

print SalesGrid10 +
OPTION XLS +
|FILENAME .vFile +
|SHOW_CANCEL_DIALOG OFF +
|ALL_TEXT_IN_GENERAL_FORMAT OFF +
|CELL_ATTR ON +
|INCLUDE_IMAGES OFF +
|INCLUDE_LINES OFF +
|INCLUDE_RICH_TEXT ON +
|RICHTEXT_ENCODING_TYPE IMAGE +
|INCLUDE_SHAPES OFF +
|LINE_SPACE 0 +
|ONE_SHEET_PER_PAGE ON +
|OPEN ON

 

Any suggestions ? Thanks.

 

Bill Eyring