U/f string functions will require reworking the HSSF object model a bit You see currently and o.a.p.h.usermodel.HSSFCell maps directly to o.a.p.h.model.CellValueRecord -- it will now need to map to TWO at the same time! (one formula followed by a string)... that will break a few things -- not horribly but a bit of a task.
-Andy Avik Sengupta wrote: >Sounds good. As for formulas, the stuff in M1 is my current aim at the moment, >and we should certainly get that done by the first milestone. (If the write() >method of IntPtg/Add-Mult-Subract-DividePtg is correct, i suppose we have the >wherewithal to write simple formulas with integers at the moment. .. no??) > >I would like to have all internal (numeric) functions by M2, depending on how >much hand coding we need to do for each individual function, having got the >framework in place .. we should obviously try to minimise that. the primary >issue with 'IF' is to parse logical expressions .. once we write that out, IF >should fall in place with little more effort. > >Dunno enuf about the issues with string functions to comment on that one. will >have to read the book. > >- >Avik > > > > >Quoting "Andrew C. Oliver" <[EMAIL PROTECTED]>: > >>Glen, >> >>Lets do an RC tonight. I may not be able to post it until tomorrow but >>thats fine. >> >>Lets aim to get 1.5 out by the end of next week at the latest provided >>no serious showstoppers pop up. >> >>All, >> >>Lets set some milestones for 2.0. We'll have mini releases when the >>milestones happen. >> >>Suggestions: >> >>M1 - >>Graphing - all low level records implemented >>Formulas - defined approach and subset of read and write support for >>basic operators: >>add/multiply/divide/subtract/exponent as well as SUM/AVG/etc. (lets >>flush that out) >> >>M2 - >>Graphing - basic object model for graphing, read/write support for line >>graphs >>Formulas - expanded support including: IF/? >> >>M3 >>String formulas... >> >>Okay lets work on filling this out. Especially looking for some ideas >>from Libin and Avik and you of course Glen. >> >>Rainer, >> >>Any plans to add wite support for properties in HPSF 2.0? >> >>Thanks, >> >>Andy >> >> > > >
