Hi,
I'm evaluating 7.0.1 and using Excel 2010 and have hit a strange issue.
I have a formula issue when I'm inputting a matrix of formula.
when I open the xls the first inserted formula says #NAME with the error "The formula contains unrecognised text"
However,
if I give the cell focus and press enter it works.
if I reverse the insert order ( same data order ) then the cell is fine and the error moves to the new first cell which was previously ok
if I inset the formula twice it works. ( obviously not ideal! )
Results
insert order 1..4 | #NAME? | -3.0145423 | 53.181667 | 0 | 0 |
insert order 4..1 | -385 | -3.0145423 | 53.181667 | 0 | #NAME? |
Java snippit...
... // list of formula e.g. "-50*(BDP("ED1 FUT","LAST_PRICE")-BDH("ED1 FUT","PX_LAST",$A$1))" List values = item.getValues(); ... int originRow = 5; int colOffset = 2; for (int j = 1; j < values.size(); j++) { |
data
=-50*(BDP("ED1 FUT","LAST_PRICE")-BDH("ED1 FUT","PX_LAST",$A$1))
=-0.391499*(BDP("ER1 FUT","LAST_PRICE")-BDH("ER1 FUT","PX_LAST",$A$1))
=6.90671*(BDP("L 1 FUT","LAST_PRICE")-BDH("L 1 FUT","PX_LAST",$A$1))
=0*(BDP("BA1 FUT","LAST_PRICE")-BDH("BA1 FUT","PX_LAST",$A$1))
=0*(BDP("BA1 FUT","LAST_PRICE")-BDH("BA1 FUT","PX_LAST",$A$1))
Any suggestions as this is a pretty decisive issue for what to now has been a pretty good evaluation.