CellEntry

New to Analytica 5.0

CellEntry( allowExpr, allowNumber, allowText, )

(Note: It would be unusual for a model builder or user to make use of this function directly).

Specifies whether a general expression can be entered into a definition or table cell, or whether entry is restricted to literals like numbers or text. When restricted, it reduces the chance that text form a valid expression, or accidentally match an identifier.

This cell format predicate is set within the Att_CellFormat attribute when you configure the Entry type on the Alignment tab of the Cell format dialog. It can be used in a computed cell format, but this direct use is rare. See the description of Text entry on the Cell format dialog page for more details.

Set «allowExpr» to false to restrict entry to literals.

Set «allowNumbers» or «allowText» or both to specify whether numbers or text are allowed. When numbers are not allowed, then an entry such as 15 will be interpreted as the text "15".

Use in computed formats

A Cell Format Expression can make use of this attribute to control entry type, and in that context, the properties could be computed dynamically. This would only make sense in an edit table, and by default, the Cell Format Expression does not apply to edit tables; hence, for any effect, you would need to configure it to apply by setting the 1 bit of CellFormatFlags.

I have not encountered a compelling use case yet for using this from Computed cell formats.

See also

• Cell format dialog
• Computed cell formats
• Cell Format Expression