Avik Sengupta wrote: >Cool. looking forward to that. > >
+1 >Quoting Werner Froidevaux <[EMAIL PROTECTED]>: > > > >>Hi, >> >>OK. I will start with a simple implementation which >>is working as external program using the setter/getter >>of Cells. In a second step we can think about how >>to integrate it into the existing poi framework. >> >>If we only implement the "Date and Time", "Logical", >>"Lookup and Reference", "Math and Trigonometry" and >>"Text and Data" functions these should be doable in >>a finite amount of time. >> >>-werner. >> >> >> >>>-----Original Message----- >>>From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] >>>Sent: Dienstag, 28. Mai 2002 14:31 >>>To: POI Developers List >>>Subject: Re: recalc for sheets >>> >>> >>>I humbly suggest that this is needed, but furthermore the >>>following use >>>case be considered. >>> >>>XML ------> HSSF -----------> XLS >>>| >>>| >>>| >>>XSL >>>| >>>| >>>| >>>XHTML >>> >>>In this case we are outputting to XLS for one edition of our >>>spreadsheet >>>and XHTML for another (or PDF, or whatever). XHTML does not support >>>formulas, and lets say we want to output the result. I think our >>>calculation engine should support this scenario as I think it >>>will be a >>>common one. >>> >>>Regardless, I totally think we need one. >>> >>>-Andy >>> >>>Avik Sengupta wrote: >>> >>> >>> >>>>>I'd like to use poi in the following scenario: >>>>> >>>>> >>>>> >>>>> >>>>That is certainly a very common requirement. In the past, we have >>>>either used >>>>VJ+ - COM integration (if you are on windows) or JIntegra Bridge >>>>VJ+ successfully >>>>for such scenarios. >>>> >>>> >>>> >>>> >>>> >>>>>But this does not seem very adequate in >>>>>server environments. >>>>> >>>>> >>>>> >>>>> >>>>Yeah, but if you want to use excel as your calculation >>>> >>>> >>>engine, you take >>> >>> >>>>what >>>>you get :) >>>> >>>>As Andy mentioned, having hooks into excel from poi is >>>> >>>> >>>certainly not a >>> >>> >>>>good >>>>idea. >>>> >>>> >>>> >>>> >>>> >>>>>But what would be really >>>>>helpful is a hook where a calculator could be installed >>>>> >>>>> >>>>> >>>>> >>>>If there is an open source java calculator available .. or somone is >>>>willing to >>>>write one .. , we could certainly look at integrating with >>>> >>>> >>>it. I would >>> >>> >>>>certainly be willing to help in writing any such hooks. >>>> >>>> >>>However, I dont think a >>> >>> >>>>generic interface to ANY calculator will work, without >>>> >>>> >>>knowing what/how such a >>> >>> >>>>calculator does/works. >>>> >>>>Regards >>>>- >>>>Avik >>>> >>>> >>>> >>>>Quoting Werner Froidevaux <[EMAIL PROTECTED]>: >>>> >>>> >>>> >>>> >>>> >>>>>Avik, >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>>files, and not a functional replacement for Excel/Word etc. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>I'd like to use poi in the following scenario: >>>>> >>>>>- The user creates sheets with formulas, etc. he/she can >>>>> test them all within excel. >>>>>- tested sheets are then deployed into a running >>>>> (java) application. >>>>>- The application (e.g. EJB) is using the sheets as >>>>> calculator. When invoked it can set predefined fields in >>>>> the sheet, do a recalc() and return the results to >>>>> the calling client application. >>>>> >>>>>This way the user does not have to write java programs for >>>>> >>>>> >>>specifying >>> >>> >>>>>calculations. >>>>> >>>>>An alternative scenario would be to call Excel through >>>>>OLE automation. But this does not seem very adequate in server >>>>>environments. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>>We depend on Excel >>>>>>automatically recalculating the sheet on open. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>Not very useful in the scenario described above (or >>>>>users do manually a recalc on every EJB invocation). >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>>I dont know if it should be any other way. do we want to have >>>>>>an implementation >>>>>>of MMULT for example in poi? >>>>>> >>>>>> >>>>>> >>>>>> >>>>>Not really ;-) See your point. But what would be really >>>>> >>>>> >>>helpful is a >>> >>> >>>>>hook where a calculator could be installed (for example a >>>>>setCalculator() on the workbook). A >>>>>recalc() method on the workbook could walk the cells >>>>>(don't know excactly the strategy of excel), manage >>>>>a calculation stack, call the calculator and assign the calculated >>>>>values to the cells. >>>>> >>>>>-werner. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>>-----Original Message----- >>>>>>From: Avik Sengupta [mailto:[EMAIL PROTECTED]] >>>>>>Sent: Montag, 27. Mai 2002 13:33 >>>>>>To: POI Developers List; [EMAIL PROTECTED] >>>>>>Subject: Re: recalc for sheets >>>>>> >>>>>> >>>>>>Werner, >>>>>> >>>>>>Thanks for your patches. >>>>>> >>>>>>Abt recalc .. actually, poi does not have any "calc" >>>>>>functionality as yet. The >>>>>>idea (at least mine :) is that poi is an api for reading and >>>>>>writing Excel/OLE2 >>>>>>files, and not a functional replacement for Excel/Word etc. >>>>>> >>>>>>As per this philosophy, poi at the moment just writes the >>>>>>formulas in a string >>>>>>as per the excel format, but does not actually calculate the >>>>>>result value of >>>>>>the formula. the cell value record is set to 0 (of course, >>>>>>we need to change >>>>>>that for string formulas .. but thats another story). We >>>>>>depend on Excel >>>>>>automatically recalculating the sheet on open. (This happens >>>>>>on office 2000+, >>>>>>there is a record we can set to ensure it happens on 97 as well. ) >>>>>> >>>>>>I dont know if it should be any other way. do we want to have >>>>>>an implementation >>>>>>of MMULT for example in poi? >>>>>> >>>>>>That having been said, if you have a better idea, please, >>>>>> >>>>>> >>>fire away. >>> >>> >>>>>>Regards >>>>>>- >>>>>>Avik >>>>>> >>>>>> >>>>>>Quoting Werner Froidevaux <[EMAIL PROTECTED]>: >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>>Is there a way to recalc() a sheet? I've found some >>>>>>>hints in the FormulaRecord class but I'm not sure >>>>>>>whether this is the right place to look at. >>>>>>> >>>>>>>If there is no recalc() function yet, where is the >>>>>>>right place to add it. >>>>>>> >>>>>>>-werner. >>>>>>> >>>>>>> >>>>>>>-- >>>>>>>To unsubscribe, e-mail: >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>><mailto:poi-dev-> [EMAIL PROTECTED]> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>>For >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>additional commands, >>>>>>e-mail: >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>><mailto:[EMAIL PROTECTED]> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>-- >>>>>To unsubscribe, e-mail: >>>>> >>>>> >>><mailto:poi-dev-> [EMAIL PROTECTED]> >>> >>> >>>>>For >>>>> >>>>> >>>additional commands, >>>e-mail: >>> >>> >>>>><mailto:[EMAIL PROTECTED]> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>>-- >>>>To unsubscribe, e-mail: >>>> >>>> >>><mailto:poi-dev-> [EMAIL PROTECTED]> >>> >>> >>>>For >>>> >>>> >>>additional commands, >>>e-mail: >>> >>> >>>><mailto:[EMAIL PROTECTED]> >>>> >>>> >>>> >>>> >>>> >>>> >>> >>> >>>-- >>>To unsubscribe, e-mail: >>><mailto:poi-dev-> [EMAIL PROTECTED]> >>>For >>>additional commands, >>>e-mail: <mailto:[EMAIL PROTECTED]> >>> >>> >>> >>-- >>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >> >> >> > > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
