Ha ha... I was thinking of some of my old CLIST's with half-a-dozen
apostrophes stuck together. There was some kind of deal on a personal
Office 2010 license we got through work - $10. That's about 83 cents a
year so far. I've sent files around to people running modern versions,
and there have been no complaints. Crossing fingers.
On 3/24/2021 5:33 PM, Charles Mills wrote:
And here I thought quadruple quotes were only a z/OS PARM= thing!
Is MS Excel 2010 cheaper than LibreOffice 7.0.4.2?
If you already have it then it's free.
Charles
-----Original Message-----
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf
Of Paul Gilmartin
Sent: Wednesday, March 24, 2021 5:08 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Creating XLS file
On Wed, 24 Mar 2021 16:25:21 -0700, Tom Brennan wrote:
I had to do 2 things to make your sample output work with MS Excel 2010
(yeah, it's old but I'm pretty cheap and it still works).
#1 Remove the spaces after the commas.
#2 Double up the quotes in the foobar cell. I have no idea why.
"=""12DE""","=""12DF""","=""12E0""","=""12E1"""
"=""12DE""","=""12DF""","=""12E0""","=""12E1""","=""foo""""bar"""
Extrapolating, the following works with LibreOffice:
"=""12DE""", "=""12DF""", "=""12E0""", "=""12E1"""
"=""12DE""", "=""12DF""", "=""12E0""", "=""12E1""", "=""foo""""bar""",
"=""x""""y""""z"""
4 quotes!? Didn't need to remove blanks.
Are you working from doc? You seem to be guessing. Like me.
Is MS Excel 2010 cheaper than LibreOffice 7.0.4.2?
-- gil
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
