Using Webfocus 7.6.10 gives me a problem when output goes as Excel formulas.

What happens

suppose the output should be

row/colum
  A           B
1
2
3 country     sales
4 ENGLAND     1000
5 FRANCE       500
6 USA         2000
7 SUM            0  

the result should be 3500
the formula you see now is '=SUM(B5..B7)' 
this should be    '=SUM(B4..B6)' 

I will send this is issue to IBI also, but be aware of this error.

This message has been edited. Last edited by: Kerry,

Frank, I just put 7.6.10 on my dev box and ran a test vs. my 7.6.5 prod installation. The results of both were the same and correct. This is the code I used:

TABLE FILE CAR
SUM SALES 
BY COUNTRY
ON TABLE COLUMN-TOTAL
ON TABLE PCHOLD FORMAT EXL2K FORMULA
HEADING
"7.6.10"
END

Is that similar to what you did? We have 262 programs currently using that syntax and I wouldn't want them to start failing after upgrade. But it doesn't appear that I am having the problem. Gives one pause, though.

Ginny

thanks for the answer...
after I posted this issue it come in to my mind that I not really tested this with the CAR db.
I did exactly what you did and also with subtotals and across and all worked well.

Then I got back to the original report where this issue appeared and no...big problem....
I tried the same with a few other reports.
I did not find exactly in what cases this problem occurs, it seems that it might be caused by subheadings, complex by statement with noprints in it and things like that.
Monday I will give this issue some more time. Meanwhile you might test it on some of your in house reports.

Have a nice weekend

Hi Frank,

I've opened up a case with techsupport about EXCEL formula on 10/12. Case status is in product division. In our testing, our Excel report have medium to heavy stylings and if I remove all the styles, it works fine.

Dan

Updated my signature.