Solved

programming with lotus compnent spreadsheets

Posted on 2000-04-08
2
416 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Email Message Background Color 4 133
Work Space in Lotus Notes cannot found 6 170
Lotus notes send email with attachments 8 168
Inconsistent date field in Lotus Notes 6 94
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

773 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