Re: Formula in HSSF

[Danny Mui]

I didn't look at your problem with 100% focus but I have a gnawing 
suspicion that the < operand is the culprit.  We currently have a 
pending patch for the >/< operators so that MAY help you here.  Please 
write a testcase and submit it to bugzilla with your formula and we'll 
see if it's fixed after the >/< patch is committed.  You probably want 
to patch TestFormulaParser.java to add your test.

http://jakarta.apache.org/poi/getinvolved/index.html

danny

Qgh Rohgy wrote:

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:-

====
 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]