I am trying to write a formula in an excel spreadsheet that will be opened in a Bloomberg Terminal. There are "custom" api in the Bloomberg terminal that can understand formula like:
=BLP("CER SP EQUITY","LAST_PRICE")
But when I write this using jxl I get the following error. =1 ERROR()
My code looks something like this:
_formula is the variable for the string as follows:
It seems you are using opensource jexcelapi project but not our JExcel library. This forum is intended for support of TeamDev products (www.teamdev.com) only.
To resolve this issue you need contacting with jexcelapi team on project web site: http://tech.groups.yahoo.com/group/JExcelApi/. Please address all your questions related to usage of jexelapi product to corresponding site of product owner. I hope this helps.
If you have any questions related to usage of our JExcel product, please let us know and we will be happy to help.
