I had not noticed that "quick formula" before, thanks for pointing it out! I think you've identified a bug @Wendy_Murphrey . Here's an extreme example:
New Table( "Untitled 7",
Add Rows( 1 ),
New Column( "abcdefghijkXXlmnopqrstuvwxyz", Numeric, "Continuous", Format( "Best", 12 ), Set Selected, Set Values( [1] ) ),
New Column( "abcdefghijkYYlmnopqrstuvwxyz", Numeric, "Continuous", Format( "Best", 12 ), Set Selected, Set Values( [1] ) ),
New Column( "Round[abcdefghi...mnopqrstuvwxyz]",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula( Round( :abcdefghijkXXlmnopqrstuvwxyz ) ),
Set Display Width( 201 )
),
New Column( "Round[abcdefghi...mnopqrstuvwxyz] 2",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula( Round( :abcdefghijkYYlmnopqrstuvwxyz ) ),
Set Display Width( 227 )
)
)
The XX and YY distinction is completely lost, and the resulting variable names, while still unique, are not very helpful. As a workaround, do it the old way: create a new column, then add the formula. Unfortunately that loses the really cool part of the quick formula that lets you select a bunch of columns and add the formulas all at once.
Craige