Un-subscribe
From: [email protected] [mailto:[email protected]] On Behalf Of John Docherty Sent: Saturday, April 18, 2015 8:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Exporting to Excel with embedded formulae Thanks Bruce. So far I have only managed to make this work using File Gateway 'manually' and exporting to an XLSX Workbook. (I will try a few more options. Using a command file I have just ended up with the formula but no calculations in Excel.) Regards, John Docherty From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Sunday, 19 April 2015 1:42 p.m. To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Exporting to Excel with embedded formulae John: That's just HOT. Makes perfect sense. Thanks Bruce Chitiea SafeSectors, Inc. From: [email protected] <mailto:[email protected]> [mailto:[email protected]] On Behalf Of John Docherty Sent: Saturday, April 18, 2015 5:14 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Exporting to Excel with embedded formulae This may come as no 'surprise' to many but I thought I would mention it just in case it helps anyone wanting to export data to an Excel file, and create calculated columns, as it only just occurred to me. (Maybe I am just slow.) By including a text column in the table which includes Excel formulae, (e.g. =+A2*B2), when this is exported to an Excel file the calculated columns are created in the spreadsheet. The format needs to be set in Excel, but at least the calculated values appear. By using a view I assume one could include totals etc. for the rows as well. Regards, John Docherty
