Excel Problem

HCL Domino Domino Forum
1

Hi,

I have a database where there are many excel reports run. For each type of a report there is an excel template.

What i have done is while uploading the Excel template to the Database, i have given formulas to some columns. When i run the report, the excel is downloading fine from the Database, and report is generated. But, for the columns that i given the formula for, the columns are showing empty and also the formulas that i have written for the columns also disappear. Can you please let me know why this happens and what is a preferred solution for this.

Thanks in advance.

2

Subject: Excel Problem

How are you collecting the information?

There are two methods for pulling the data one is by collecting the documents and accessing the ColumnValues property and the other is by using NotesViewEntries.

I remember that one of the methods will return blanks in some cases and the other returns the values for all columns. Unfortunately it’s been a while so I’m not sure which is which off hand.