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
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
