Kevin J Cully wrote on 2016-08-18:
> Thank you for the help with that class Christof. I've converted it to be
used in Xojo as well.
>
> Is there a way to do calculations into a cell in the export? Example: To
put the formula "=SUM(D2:D10)" into a cell so Excel evaluates the
expression?
>
> -----Original Message-----
> From: ProFox [mailto:[email protected]] On Behalf Of Wollenhaupt,
Christof
> Sent: Thursday, August 18, 2016 2:00 PM
> To: [email protected]
> Subject: Re: Flat file to Excel....but it's got more than 255 columns!
>
>>
>> I think Christof had a posting a couple of years ago with a VFP class
>> that would allow for some formatting (Bolds, colors, etc.) of the XML
>> so it looks "nicer" when opened. I think you can even put formulas in
>> the XML and have Excel honor it.
>>
>>
> Indeed. The white paper is still on our web site:
>
> http://foxpert.com/docs/excel.en.htm
>
> A sample program is at the bottom
>
> --
> Christof
>
Kevin,
I liked the idea of creating an xml file that Excel could open. So I tested
and found a way to use a formula. (I saved a worksheet with a formula to the
XML format.)
<Cell ss:Formula="=COUNT(RC[-1]:R[9]C[-1])">
<Data ss:Type="Number">0</Data>
</Cell>
You can also use a formula in a single-mapped cell, if the cell is mapped to
an XML element with an XML Schema Definition (XSD) data type that Excel
interprets as a number, date, or time.
Pulled from here:
https://support.office.com/en-us/article/Overview-of-XML-in-Excel-f11faa7e-6
3ae-4166-b3ac-c9e9752a7d80
Tracy Pearson
PowerChurch Software
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
