At 11:56 am -0700 2/10/01, Geoff Canyon wrote: >At 10:53 AM -0700 10/2/01, F. Ricardo, Ph.D. wrote: >>Now, it does nothing about the "$" prefix, which if absolutely >>necessary would need implementation in something like the following >>abominable manner. In apps like Excel, the "$" in cells are not >>part of the data. Rather they are part of the metadata of a cell, >>which means that something similar would need to be reflected in >>MetaCard. Among the 2 options are to store the data in one (hidden) >>metadata field and to display the "pretty" version of it in >>another. This means building a 2-field management subsystem. The >>hidden metadata field would keep a totally different version of the >>data, for instance, >> >>cellH:A >>cellV:1 >>rect:25,50,65,80 >>val:25.50 >>prefix:$ >>name:Net Sales > >Instead of using another field, couldn't you simply use custom >properties of the field with the data in it? >
Or go one step further and use a setprop handler. Something like: setprop cpCurrencyValue pValue set the cpCurrencyValue of me to pValue put myNumberFormatFunction(pValue) into tData set the text of me to "$" & tData end cpCurrencyValue But this could probably be refined some. (After coffee perhaps.) Cheers Dave Cragg Archives: http://www.mail-archive.com/[email protected]/ Info: http://www.xworlds.com/metacard/mailinglist.htm Please send bug reports to <[EMAIL PROTECTED]>, not this list.
