Format table cells with?

Bill Vlahos bvlahos at mac.com
Thu Feb 2 11:09:42 EST 2006


Jeanne,

Thanks for the info. This pretty much how I wanted it to work.

Is there a way to have it flag when what was entered isn't a valid  
date? For example February 32, 2006 or Fuberry 2, 2006.

Bill Vlahos

On Feb 2, 2006, at 7:05 AM, Jeanne A. E. DeVoto wrote:

> At 11:43 PM -0800 2/1/2006, Bill Vlahos wrote:
>> The table object has the ability to format cells several ways  
>> including Date. There is a field to the right of this choice in  
>> the Properties Palate but I don't know what information should go  
>> in there. I wasn't able to find any references to it in the Help.
>>
>> What I want is to validate and format the cell information so that  
>> it is a correct date. Is this how it is supposed to work? If so,  
>> what do I put in the field?
>
> It's a date modifier (short, abbrev, long, or system). For example,  
> if you set the combobox to "Date" and enter "short" in the field,  
> then if you enter "Feb 6, 2006" in a cell in the formatted column,  
> then click out of it, the cell is changed to read "2/6/2006". From  
> the (old) docs (this seems to have gotten dropped out of the docs  
> at some point):
>
> -
> How to format numbers in a table field:
>
> To control the format of numbers in a table field, you specify a  
> format, along with the cells you want to apply the format to, in  
> the field's property inspector. To choose a format, follow these  
> steps:
>
> 1.  In the "Table" pane, check the "Cell formatting" box.
>
> 2.  Choose a column number from both menus labeled "Format Column".
>
> 3.  From the "Using" menu, choose the format you want to use. In  
> the "With" box, enter a prefix or suffix, a number of decimal  
> places,  a percentage value, or "short", "long", "internet", or  
> "system" for a date.
>
> 4.  Press the Tab key, then click "Add" to apply the format.
>
>   Note:  You can apply only one format to any particular cell.
> -
> -- 
> jeanne a. e. devoto ~ revolution at jaedworks.com
> http://www.jaedworks.com
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




More information about the use-livecode mailing list