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]
