Solved

programming with lotus compnent spreadsheets

Posted on 2000-04-08
2
415 Views
Last Modified: 2013-12-18
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 :(
0
Comment
Question by:sbaek
2 Comments
 
LVL 1

Accepted Solution

by:
asselin earned 30 total points
ID: 2716055
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
 

Author Comment

by:sbaek
ID: 2725250
Thank You for the help
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now