?
Solved

programming with lotus compnent spreadsheets

Posted on 2000-04-08
2
Medium Priority
?
421 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
asselin earned 120 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month8 days, 21 hours left to enroll

764 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