DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8757>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8757 Formula results in "#VALUE!" in Excel ------- Additional Comments From [EMAIL PROTECTED] 2002-05-04 18:04 ------- in org/apache/poi/hssf/record/formula/ReferencePtg.java: change sid to 0x44 from 0x24 public final static byte sid = 0x44; I also "hacked" org/apache/poi/hssf/record/formula/Ptg.java to compile and recognize both 0x24 and 0x64 as well (like before) final int valueRef = ReferencePtg.sid - 0x20; final int arrayRef = ReferencePtg.sid + 0x20; I think this stems from using the NUMBER field where Excel usually uses MULRK (at least in the handful of spreadsheets I've looked at with the BIFFViewer). Both sum(a1,b1) and a1+b1 work with this.
