Extracting string values from Cells

[Akshay Arora]

When doing engine.GetValueFromArg( s ) it does not return anything when the cell value is a string. I have not specified a CellType for any of these cells. They return numerical data fine, but not string values.

Instead I''ve used this.gridExpiry[ this.engine.RowIndex( arg[ i ] ), this.engine.ColIndex( arg[ i ] ) ].Text to get the value I am looking for, which works, but I doubt that it is optimal. Is it?

Thanks,
Akshay

[Administrator]

Our gridformula engine does not currently support strings which sounds like what you are trying to get.

In that case, what you are doing is the only way to do this currently. If this is a custom function, you are free to use any kind of argument list you want. So, instead of passing one argument as, for example, A12, you could pass two as 12, 1. These two arguments would be more efficient as you could parse them immediately as int 12 and int 1 without using the engine.GetColIndex and engine.GetRowIndex calls which do take some time.