programming with lotus compnent spreadsheets

I am trying to add rows dynamically into a lotus spreadsheet component imbedded into a form using the following code but it does not seem to do anything.  I can not see anything past the first 30 lines of the spread sheet which is how many rows I created in the form.

Call CCsheet.InsertRange(CCrow, 1, CCrow, 7, 2)

I've tried to auto size the spreadsheet using the following code before I save the document at the end but that didn't seem to do anything at all.

 Row1 = -1    
     Col1 = 1    
     Row2 = CCsheet.DisplayRows
     Col2 = CCsheet.DisplayCols    
     SetDef = True
     Call CCsheet.SetColWidthAuto(Row1,Col1,Row2,Col2,SetDef)    
     Call CCsheet.SetRowHeightAuto(Row1,Col1,Row2,Col2,SetDef)

Any help anyone could give would be appreciated.  Thanks!!!
Sorry only have 30 points :(
sbaekAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
asselinConnect With a Mentor Commented:
Add these two lines to your code (this suppose you're adding one line at a time):

CCsheet.MaxRow = CCsheet.MaxRow + 1
CCsheet.DisplayRows = CCsheet.MaxRow
0
 
sbaekAuthor Commented:
Thank You for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.