Format table cells with?

Jeanne A. E. DeVoto revolution at jaedworks.com
Thu Feb 2 10:05:38 EST 2006


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



More information about the use-livecode mailing list