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: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
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
