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
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
