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