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:[email protected]] On Behalf Of Paul Gilmartin Sent: Wednesday, March 24, 2021 5:08 PM To: [email protected] 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 [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
