Reading an Excel Template

[Qgh Rohgy <qu...@yahoo.com>]

Hi,

I manually create (not through HSSF) an Excel
file(template) with the formula/features that I need.

Using HSSF , I read this template and fill in the data
and save it as another xls file (mytempworkbook.xls)

In my template, I have the =SUM($H3:R3)<=1 for the
first row cells  and all other row cells also.

But this constraint is not enforced properly when I
open my newly saved populated excel file generated
using this template. i.e =SUM($H3:R3)<=1 applies to
some cells only .

Attahed is the excel file to demonstrate this
behaviour.
Note that cell I3 ALSO has this constraint but it is
still possible for the user to enter a 1 in the cell
when H3 already has a 1.

Please HELP ! I need to use this feature and I have
not yet found a solution for this. :(

Thanks,
qgh

__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com