Turns out Gnumeric will treat the formulae right but Symphony won't. But exporting to ODS format from Gnumeric and opening in Symphony preserves the formulae.
(And, yes, Symphony's Help claims it would do the right thing.) Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: "Farley, Peter x23353" <peter.far...@broadridge.com> To: IBM-MAIN@listserv.ua.edu, Date: 09/14/2012 10:33 PM Subject: Re: Creating .xls on z/OS Sent by: IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu> Martin, I have no trouble with formulae in .csv, I do it all the time from Rexx on z/OS. I will generate two calculation cells like this, for instance: "=IF(D2>0,(F2-D2),"" "")","=IF(D2>0,(H2/D2),"" "")", I found that I have to surround the formula with double quotes (because of the embedded spaces) and double any embedded double quotes for Excel to interpret the CSV formula correctly and generate the calculated result. The above cells look like this once the file is downloaded from z/OS to the PC and opened by Excel: =IF(D2>0,(F2-D2)," ") =IF(D2>0,(H2/D2)," ") HTH Peter -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Martin Packer Sent: Friday, September 14, 2012 5:09 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Creating .xls on z/OS .CSV won't contain formulae. Don't know if that's what bothers the OP - but it bothers ME as I'd like to generate them in REXX. Cheers, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: "R.S." <r.skoru...@bremultibank.com.pl> To: IBM-MAIN@listserv.ua.edu, Date: 09/14/2012 08:23 PM Subject: Re: Creating .xls on z/OS Sent by: IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu> W dniu 2012-09-14 15:44, Walter Marguccio pisze: > Hello all, > > I've been asked if there is the possibility to create Excel tables (.xls) files on z/OS, > using a batch job. I've searched the archives, the developerwork IBM's site, redbooks, > but found no clue. > We run the XMITIP tool which is able to create .csv files, but this seems not enough. Just curious: why .CSV is not enough? What features do you expect? Drawings? -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN