A little off-topic...
>From universe, I am creating a sequential file which is formatted as a CSV
file, in other words each field is quoted and separated from each other by
commas, for example:
"John","Jacob","Dingleheimer Schmidt"
The intent is that the resulting file is opened with Excel.
You can force any cell into multiple lines by embedding a CHAR(10), for
example:
WRITESEQ \"John","Jacob","Dingleheimer\:CHAR(10):\Schmidt"\ TO MY.CSV.FILE
THEN NULL
...when viewed in Excel will give you...
John Jacob Dingleheimer
Schmidt
...which is a great way of expressing multi-values.
Finally I arrive at the crux. When you open such a document in Excel, it
only displays one line per row even if a cell in that row contains multiple
lines. To see all lines you have to select all and hit FORMAT | ROW |
AUTOFIT. My users seem to be incapable of dealing with that, so...
...does anyone know if it is possible to embed some kind of command in a CSV
file that will get Excel to autofit those rows automatically?
Barry Brevik
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
