CSV output

[Richard Kreiss]

> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of Walter Vaughan
> Sent: Friday, February 25, 2011 5:05 PM
> To: filePro
> Subject: Re: CSV output
> 
> Richard Kreiss wrote:
> 
> >Have not tried this yet.
> >
> >Is there a way to export a formula as part of a csv output for input
> >into Excel?
> >
> There always is a way....
> save this below as .cvs file
> 
> 1000,2000
> 1500,2500
> =SUM(A1:A2),=SUM(B1:B2)
> 
> work for you?

Walter,

Thanks for the answer.  I test putting a formula in a specific cell before I
read this response.  It worked.

Foobar(28)="=sum(Y280:AF280)"

When I opened the csv file, in OpenOffice.orgs spreadsheet program, it had
calculated to total.

The only problem, as I see it, is knowing where one will locate the formula
if it isn't at the end of the row or column.

Richard