Solved

programming with lotus compnent spreadsheets

Posted on 2000-04-08
2
410 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
Comment Utility
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
Comment Utility
Thank You for the help
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

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…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

763 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

7 Experts available now in Live!

Get 1:1 Help Now