I was usign a view to OLE to an Excel spreadsheet. It has always worked very well for me in the past but now I have a view with 30+ columns and it seems that when it reaches column 26 and after it shows the data of column 25 over and over again, i.e., columns 26,27,28,29, and 30 all have the same data as column 25 (even though I have not written any data to these columns (fields).
Is there a limitation in the number of columns a notes view can support?
ST
Subject: Maximum columns in a view?
I made a simple view and it worked with over 40 columns. One thing that can make this behavior is if you copy columns, sometimes the programmatic name doesn’t change. Look at the column properties and the last tab to compare the names.
Subject: RE: Maximum columns in a view?
I agree with this suggestion.
Another thing to think about – if the only reason you need all these columns is to do an occasional export via OLE, then you will be better off for performance to read the values from the NotesDocuments instead of from the view entries. Big views slow down every part of your application.
Subject: RE: Maximum columns in a view?
Mats, I did copy/paste them. I think you’re right, it just might be the programmatic name…
thanks
ST
Subject: Maximum columns in a view?
According to our Domino Limits resource, the limit is:
289 ten-character columns; dependent upon # or characters per column