I have a script that loads data from excel and then generates a new formula column. The column appears empty however, even though my formula preview shows values. Once I copy/paste the column into the same datatable suddenly the values appear. What's going on here?
Easiest demo is through the gif below. I also added the script and excel sheet.
Names Default To Here( 1 );
//Prompt to select and open an MS Excel file
path = Pick File( "Select Excel File", "$DOCUMENTS", {"Excel Files|csv;xlsx;xls", "All Files|*"}, 1, 0 );
fname = Word( 1, Word( -1, path, "/" ), "." );
//Let the user choose the name of the datatable
w = New Window( "Choose datatable name", // opens a window with a title and this content...
<<MODAL></MODAL>
Edit: Ok I see now, I'm changing the variable name later in the script. So the Force column name reference is not correct at the time of creating the column.
It seems like your force column's name is wrong in the formula until you rename it.
Column Die strength Formula Interrupted
Name Unresolved: Force at row 1 in access or evaluation of 'Force' , :Force/*###*/
Formula evaluation errors have been ignored
