a LotusScript routine creates an Excel file by entering values and formulas. This has been working fine in R5.0.9
The customer now complains (and this is reproducable), that instead of seeing the values of a formula, “#NAME?” is displayed in that cell.
The only way to fix this, is IN EXCEL to manually edit the formula (simply press F2 and Enter) - nothing for an automated process.
Also, RANGE definitions do not work anymore.
Stefan
Subject: URGENT: Error in OLE automation
If you are creating the formulas using script, it suggests that the formula is using a now-missing name. Perhaps the worksheet tab names on the template you are using have been changed?
Certainly not a Notes issue, in any case. Check your script and any formulas that pre-exist in the sheet, as well as all defined names.
Subject: RE: URGENT: Error in OLE automation
thanks for the feedback.
given that it DID work in 5.0.x I still suggest, that it’s a Notes bug - nothing changed except the Notes version → not a Notes issue???
Subject: ERROR somewhat connected to language version
the problem seems to be nailed down (credit to Mr. Jean-Etienne FUDRAL).
In the previous Notes Version (5.x) I had entered the Excel formula according to the installed language version (german, french respectively) of Excel, i.e. “=SUMME(B5:B12)”.
As reported before, after having installed Notes 6, this resulted in an error being displayed in the Excel cell.
The problem is resolved, when using the english writing, i.e. “=SUM(B5:B12)” - even though the installed Excel version is german.
Stefan
Subject: RE: ERROR somewhat connected to language version
It seems you’ve used excel into Notes formula before. I need help with Excel type of calculating formula with a FORM in Notes. For example;
Field_C := @SUM(Field_A + Field_B)
such that the value in Field_C would be
changing realtime as the figures in Field_A
and Field_B get altered. Needed for reviewing
proportion of sales to other costs before
saving entries. The Designer help
only gives import function into a VIEW.
Any help?
Thanks,
ED
Subject: don’t understand your question - more details required
Eric - do you want to do this calculation in Excel and the result should be stored in Notes or do you just want to add two field values in a Notes form into a third field inside this same Notes form?
For the first, you could use Notes f/x (field exchange) - has been introduced in the Notes 3.x time and I haven’t used it since 
but it was working great then.
What I’ve been doing was the other way round: taking values from Notes into an Excel sheet using OLE. This was done in a LotusScript agent (in my case).
Stefan