Hi, Thanks danny, I just found the macro-hint in another discussion, too. What is the best way to embed a macro? Is there any way in poi to do this, instead of using a template-xls-file with the macro?
jpfi >> -----Urspr�ngliche Nachricht----- >> Von: Danny Mui [mailto:[EMAIL PROTECTED] >> Gesendet: Montag, 13. Dezember 2004 17:04 >> An: POI Users List >> Betreff: Re: SUMIF-Formular >> >> >> I don't remember the options flags exactly, does that have >> any effect? >> >> You can have a macro do the recalculation automatically. >> >> Pfitzner, Jan wrote: >> > hi, >> > >> > I tried to use the SUMIF-Formula, but Excel doesn't show the >> > value, but "0". >> > If I open the cell in Excel (doubleclick) and drop out, the SUMIF- >> > Formular is calculated correctly. >> > >> > When I use the BiffViewer I get following: >> > Before double-clicking: >> > >> > [FORMULA] >> > .row = 6c3 >> > .column = 4 >> > .xf = f >> > .value = 0.0 >> > .options = 2 >> > .zero = 0 >> > .expressionlength= 27 >> > .numptgsinarray = 4 >> > Formula 0=AreaPtg >> > firstRow = 1 >> > lastRow = 1729 >> > firstCol = 0 >> > lastCol = 0 >> > firstColRowRel= true >> > lastColRowRel = true >> > firstColRel = true >> > lastColRel = true >> > >> > 00000000 25 01 00 C1 06 00 C0 00 C0 %........ >> > >> > Formula 1=[ValueReferencePtg] >> > row = 1696 >> > col = -16384 >> > rowrelative = true >> > colrelative = true >> > >> > 00000000 24 A0 06 00 C0 $.... >> > >> > Formula 2=AreaPtg >> > firstRow = 1 >> > lastRow = 1729 >> > firstCol = 16 >> > lastCol = 16 >> > firstColRowRel= true >> > lastColRowRel = true >> > firstColRel = true >> > lastColRel = true >> > >> > 00000000 25 01 00 C1 06 10 C0 10 C0 %........ >> > >> > Formula 3=<FunctionVarPtg> >> > field_1_num_args=3 >> > name =SUMIF >> > field_2_fnc_index=345 >> > </FunctionPtg> >> > 00000000 42 03 59 01 B.Y. >> > >> > [/FORMULA] >> > >> > >> > After double-clicking diff shows following: >> > >> > 5,7c5,7 >> > < .value = 0.0 >> > < .options = 2 >> > < .zero = 0 >> > --- >> > >> >> .value = 2655.09 >> >> .options = 0 >> >> .zero = -51118068 >> > >> > 28c28 >> > < 00000000 24 A0 06 00 C0 $.... >> > --- >> > >> >>00000000 44 A0 06 00 C0 D.... >> > >> > >> > >> > Anny idea? >> > >> > thanks >> > >> > jpfi >> > >> > >> > >> > >> --------------------------------------------------------------------- >> > To unsubscribe, e-mail: [EMAIL PROTECTED] >> > For additional commands, e-mail: [EMAIL PROTECTED] >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
