With this patch (thanks Matthew), most simple formulas will display correctly when opened in excel. However, functions which expect reference class paramerters (eg, ROW() ) will now show #VALUE! in excel. Also, I havent changed the Area references (particularly since i figured that code to read value and array area tokens did not exist in the first place)... so no guarantees about that.
Over the next few days, i'll work on fixing this. This however also gets us into the whole class shift mess, so might take some time. Cheers - Avik PS. While i wait for my Excel dev kit to negotiate its international shipping course, can anybody send me a list of expected param types of all excel sheet functions .. it does not seem to be documented in the openoffice doc. thanx. Quoting [EMAIL PROTECTED]: > avik 02/05/06 11:23:24 > > Modified: src/java/org/apache/poi/hssf/record/formula Ptg.java > ReferencePtg.java > src/testcases/org/apache/poi/hssf/usermodel > TestFormulas.java > Log: > committing patches supplied by Matthew McClain for bug 8757. This will > handle most cases, since majority formulas expect value class params. Ptgs to > be refactored for full functionality > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
