Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - [Answered] Code loop through columns/rows for h/w
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

[Answered] Code loop through columns/rows for h/w

 Post Reply Post Reply
Author
Message
wakerunner View Drop Down
Groupie
Groupie


Joined: 29 September 2007
Status: Offline
Points: 85
Post Options Post Options   Thanks (0) Thanks(0)   Quote wakerunner Quote  Post ReplyReply Direct Link To This Post Topic: [Answered] Code loop through columns/rows for h/w
    Posted: 06 April 2011 at 2:10pm
Could anybody give me a pointer on the easiest way to loop through all columns and rows to get the height and width of each cell?
Product: Xtreme SuitePro (ActiveX) version 13.3.1
Platform: Windows 7 64 bit
Language: Visual Basic 6.0


Back to Top
wakerunner View Drop Down
Groupie
Groupie


Joined: 29 September 2007
Status: Offline
Points: 85
Post Options Post Options   Thanks (0) Thanks(0)   Quote wakerunner Quote  Post ReplyReply Direct Link To This Post Posted: 06 April 2011 at 6:04pm
I came up with this, there may be better ways but this works.
 
For C% = 0 To Ctrl.Columns.Count - 1
        Cwidth = Ctrl.Columns(C%).Width
        Cwidth = Cwidth * Screen.TwipsPerPixelY
            For a% = 0 To Ctrl.Rows.Count - 1
            Call Ctrl.Rows.row(a%).GetRect(T1, T2, T3, T4)
            Cheight = T4 - T2
            Cheight = Cheight * Screen.TwipsPerPixelX
            Next a%
                        
Next C%
       
Product: Xtreme SuitePro (ActiveX) version 13.3.1
Platform: Windows 7 64 bit
Language: Visual Basic 6.0


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.172 seconds.