I am using the JExcelAPI to write and read Excel spreadsheets. I am trying to pass this formula to the sheet: -
=IF(A1=0;0;ROUND(ROUNDUP(A1;0);-(ROUNDDOWN(LOG10(A1);0)-2)))
as follows: -
CODE
Formula f=new Formula(1,0,"IF(A1=0;0;ROUND(ROUNDUP(A1;0);-(ROUNDDOWN(LOG10(A1);0)-2)))");
sheet.addCell(f);
but i get this errror, Lexical error at char 7. Does anyone know how i can solve this?
This post has been edited by gyron: 2 Jul, 2007 - 11:54 PM
2 Jul, 2007 - 11:50 PM
| 
