Hello,
Can I use formulas in excel using HSSF?
I want to restrict the user from entering value in
more than 1 column.(say coulumns H to R)
I use the formula :
=SUM($H1:$R1)<=1.
But when I use this formula, the excel gets formula
=SUM($H1:$R1)
i.e <= 1 goes away.
I have pasted my Java Code for doing this and the
excel file generated is attached
IS there any way I can do this using HSSF?
Please let me know
Thanks,
qgh
Below is the Java code for the above:-
====
while (rownum <60)
{
// create a row
r = s.createRow(rownum);
String formula =
"SUM($H"+rownum+":$R"+rownum+")<=1";
System.out.println("*****formula =" + formula);
cellnum = 0;
// create a numeric cell
c = r.createCell(cellnum);
c.setCellValue( "abc"); //1
cellnum ++;
c = r.createCell(cellnum);
c.setCellValue( "xyz"); //2
cellnum ++;
c = r.createCell(cellnum);
c.setCellValue( "pqr"); //3
cellnum ++;
c = r.createCell(cellnum);
c.setCellValue( "some dfs");
//4
cellnum ++;
c = r.createCell(cellnum);
c.setCellValue( "some pqr");
//5
cellnum ++;
c = r.createCell(cellnum);
c.setCellValue( "dsgfs"); //6
cellnum ++;
c = r.createCell(cellnum);
c.setCellValue("sdfghgds");
//7
cellnum ++;
c = r.createCell(cellnum);
c.setCellFormula(formula); //8
cellnum ++;
c = r.createCell(cellnum);
c.setCellFormula(formula); //9
cellnum ++;
c = r.createCell(cellnum);
c.setCellFormula(formula);
//10
cellnum ++;
c = r.createCell(cellnum);
c.setCellFormula(formula);
//11
//And similarly other rows....
=======
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
