I have NEVER tried that! Think I'll play around with it!
Karen -----Original Message----- From: John Docherty <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Sat, Apr 18, 2015 7:14 pm 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
