Doc? I hardly know what that is :) My method is try something and see
what happens. Some googling.
On 3/24/2021 5:08 PM, Paul Gilmartin wrote:
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
