Page 1 of 1

Parentheses are stripped off in Excel

Posted: Sat Feb 10, 2007 8:34 am
by calvin888
I need to extract calculated data from many Microsoft Excel files.
The data need to be calculated in complex formula not in Excel files.
When RoboTask pass the formula as keystrokes of into blank cells
 in Excel files, the parentheses in the formula are stripped off,
ended formula errors as results.

Parentheses are stripped off in Excel

Posted: Tue Feb 13, 2007 1:36 am
by Oleg
We shall investigate the problem.
Try to use the +(9) and +(0) combinatioins (Shift-9 and Shift-0) instead of the parentheses. This must work.