Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Visual Basic
  4. y something wrong after passing 10 row of line to EXCEL? [SOLVED!][modified]

y something wrong after passing 10 row of line to EXCEL? [SOLVED!][modified]

Scheduled Pinned Locked Moved Visual Basic
helpquestion
18 Posts 5 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Offline
    C Offline
    campbells
    wrote on last edited by
    #1

    I not sure y everytime i pass the data from DATAGRID to EXCEL above more then 10 row then the datagrid pointer will skip after row 10 until the end. So my excel will look like this let said u use number as the data value.i showing 1-15 data. 1 2 3 4 5 6 7 8 9 10 15 15 15 15 15 I just found the solution , wat a crazy solution i never expect. I just drag the datagrid height longer then solve the problem .HAH!;P -- modified at 21:16 Thursday 7th December, 2006

    C L 2 Replies Last reply
    0
    • C campbells

      I not sure y everytime i pass the data from DATAGRID to EXCEL above more then 10 row then the datagrid pointer will skip after row 10 until the end. So my excel will look like this let said u use number as the data value.i showing 1-15 data. 1 2 3 4 5 6 7 8 9 10 15 15 15 15 15 I just found the solution , wat a crazy solution i never expect. I just drag the datagrid height longer then solve the problem .HAH!;P -- modified at 21:16 Thursday 7th December, 2006

      C Offline
      C Offline
      ChandraRam
      wrote on last edited by
      #2

      You have asked this question any number of times... did you actually debug and see what happens when the row becomes 10 or 11?

      C 1 Reply Last reply
      0
      • C campbells

        I not sure y everytime i pass the data from DATAGRID to EXCEL above more then 10 row then the datagrid pointer will skip after row 10 until the end. So my excel will look like this let said u use number as the data value.i showing 1-15 data. 1 2 3 4 5 6 7 8 9 10 15 15 15 15 15 I just found the solution , wat a crazy solution i never expect. I just drag the datagrid height longer then solve the problem .HAH!;P -- modified at 21:16 Thursday 7th December, 2006

        L Offline
        L Offline
        leckey 0
        wrote on last edited by
        #3

        Looking at some of your previous questions you have a habit of adding 'urgent' to the title.

        ____________________________________________________ If at first you don't succeed, skydiving might not be for you.

        P C 2 Replies Last reply
        0
        • L leckey 0

          Looking at some of your previous questions you have a habit of adding 'urgent' to the title.

          ____________________________________________________ If at first you don't succeed, skydiving might not be for you.

          P Offline
          P Offline
          Paul Conrad
          wrote on last edited by
          #4

          leckey wrote:

          some of your previous questions you have a habit of adding 'urgent' to the title.

          I know, it's getting old. Hey, I need financial freedom [Urgent] :->


          You will see a delete button on each of your posts. Press it. - Colin Angus Mackay

          1 Reply Last reply
          0
          • L leckey 0

            Looking at some of your previous questions you have a habit of adding 'urgent' to the title.

            ____________________________________________________ If at first you don't succeed, skydiving might not be for you.

            C Offline
            C Offline
            campbells
            wrote on last edited by
            #5

            cause is very urgent, but anyway i solve most of it myself. maybe just to express some stress in the forum then

            D P 2 Replies Last reply
            0
            • C ChandraRam

              You have asked this question any number of times... did you actually debug and see what happens when the row becomes 10 or 11?

              C Offline
              C Offline
              campbells
              wrote on last edited by
              #6

              there is no coding error at all i found out ! i solve it by only draging the data grid height longer! oh my..:laugh:

              C 1 Reply Last reply
              0
              • C campbells

                cause is very urgent, but anyway i solve most of it myself. maybe just to express some stress in the forum then

                D Offline
                D Offline
                Dave Kreskowiak
                wrote on last edited by
                #7

                Well, "urgent" doesn't have any meaning in the forums. Noone is going to scan the subjects and immediately go to the ones that say "urgent!". Noone just sits here waiting for the next post to show up so they can just jump right on it. If your question was that urgent, your best source of information is Google or staying up yourself until 3:00am pounding on the problem until you get it solved. Actually, putting "urgent" in your subject line, or anywhere else in your post, will likely get you ignored for a while!

                Dave Kreskowiak Microsoft MVP - Visual Basic

                C 1 Reply Last reply
                0
                • D Dave Kreskowiak

                  Well, "urgent" doesn't have any meaning in the forums. Noone is going to scan the subjects and immediately go to the ones that say "urgent!". Noone just sits here waiting for the next post to show up so they can just jump right on it. If your question was that urgent, your best source of information is Google or staying up yourself until 3:00am pounding on the problem until you get it solved. Actually, putting "urgent" in your subject line, or anywhere else in your post, will likely get you ignored for a while!

                  Dave Kreskowiak Microsoft MVP - Visual Basic

                  C Offline
                  C Offline
                  campbells
                  wrote on last edited by
                  #8

                  i learn to put this urgent is because i saw ppl do it. sure i woundnt sit and wait anwser while i doing research and i wait anyone able to find out the solution more faster then me, anyway now this question i got my own solution from myself. so i dont mind they ignore my question or watever, as long as i happy to reless some of my recent problem here , maybe is a kind of way to reless my stress. And i more and more like to put bracket [xxx] anything inside, so is easy for me to know where is my post . FORUM FREEdom anyway ;P

                  D P 2 Replies Last reply
                  0
                  • C campbells

                    there is no coding error at all i found out ! i solve it by only draging the data grid height longer! oh my..:laugh:

                    C Offline
                    C Offline
                    ChandraRam
                    wrote on last edited by
                    #9

                    Are you sure just increasing the height would do it, then? What happens if the number of rows increased to, say, 100?

                    C 1 Reply Last reply
                    0
                    • C ChandraRam

                      Are you sure just increasing the height would do it, then? What happens if the number of rows increased to, say, 100?

                      C Offline
                      C Offline
                      campbells
                      wrote on last edited by
                      #10

                      yes, recently the data i passing not really reach until 100. But u r, u may try go to the datagrid properties change the row length small, normally is 200 so maybe u try 100-50 u can see the row size was squez smaller. so that mean the Height of ur datagrid can contain more row inside. Cause i found out if my height is smaller then the data which suppose to show. Let said My datagrid height just able to show 10 row at one time.Even datagrid able for u to click scroll down to next row but it will have problem when passing to EXCEL. so i just drag the height higher to able to show all the data out without using the scoll. Hope u understand wat i mean... :)

                      C 1 Reply Last reply
                      0
                      • C campbells

                        i learn to put this urgent is because i saw ppl do it. sure i woundnt sit and wait anwser while i doing research and i wait anyone able to find out the solution more faster then me, anyway now this question i got my own solution from myself. so i dont mind they ignore my question or watever, as long as i happy to reless some of my recent problem here , maybe is a kind of way to reless my stress. And i more and more like to put bracket [xxx] anything inside, so is easy for me to know where is my post . FORUM FREEdom anyway ;P

                        D Offline
                        D Offline
                        Dave Kreskowiak
                        wrote on last edited by
                        #11

                        campbells wrote:

                        i learn to put this urgent is because i saw ppl do it.

                        Then you've also seen us tell other people NOT to do it.

                        Dave Kreskowiak Microsoft MVP - Visual Basic

                        C 1 Reply Last reply
                        0
                        • D Dave Kreskowiak

                          campbells wrote:

                          i learn to put this urgent is because i saw ppl do it.

                          Then you've also seen us tell other people NOT to do it.

                          Dave Kreskowiak Microsoft MVP - Visual Basic

                          C Offline
                          C Offline
                          campbells
                          wrote on last edited by
                          #12

                          so sorry didnt seend b4 this is the first time. just knew it. but wats the big deal? just an extra word anyway. to express some mood.

                          P 1 Reply Last reply
                          0
                          • C campbells

                            yes, recently the data i passing not really reach until 100. But u r, u may try go to the datagrid properties change the row length small, normally is 200 so maybe u try 100-50 u can see the row size was squez smaller. so that mean the Height of ur datagrid can contain more row inside. Cause i found out if my height is smaller then the data which suppose to show. Let said My datagrid height just able to show 10 row at one time.Even datagrid able for u to click scroll down to next row but it will have problem when passing to EXCEL. so i just drag the height higher to able to show all the data out without using the scoll. Hope u understand wat i mean... :)

                            C Offline
                            C Offline
                            ChandraRam
                            wrote on last edited by
                            #13

                            That is not really going to solve your problem, I think. What if you are unable to predict the number of rows that your data grid will display? You cannot infinitely decrease the row height...

                            C 1 Reply Last reply
                            0
                            • C ChandraRam

                              That is not really going to solve your problem, I think. What if you are unable to predict the number of rows that your data grid will display? You cannot infinitely decrease the row height...

                              C Offline
                              C Offline
                              campbells
                              wrote on last edited by
                              #14

                              can predict by some measurement of course, anyway is already solve already been tested the system.thanks anyway.

                              1 Reply Last reply
                              0
                              • C campbells

                                cause is very urgent, but anyway i solve most of it myself. maybe just to express some stress in the forum then

                                P Offline
                                P Offline
                                Paul Conrad
                                wrote on last edited by
                                #15

                                campbells wrote:

                                anyway i solve most of it myself

                                Good for you :)

                                campbells wrote:

                                just to express some stress in the forum

                                But most people in these CP forums do not respond well to "urgent."


                                Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

                                1 Reply Last reply
                                0
                                • C campbells

                                  i learn to put this urgent is because i saw ppl do it. sure i woundnt sit and wait anwser while i doing research and i wait anyone able to find out the solution more faster then me, anyway now this question i got my own solution from myself. so i dont mind they ignore my question or watever, as long as i happy to reless some of my recent problem here , maybe is a kind of way to reless my stress. And i more and more like to put bracket [xxx] anything inside, so is easy for me to know where is my post . FORUM FREEdom anyway ;P

                                  P Offline
                                  P Offline
                                  Paul Conrad
                                  wrote on last edited by
                                  #16

                                  campbells wrote:

                                  i learn to put this urgent is because i saw ppl do it.

                                  And you haven't seen some of the nasty replies?


                                  Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

                                  C 1 Reply Last reply
                                  0
                                  • C campbells

                                    so sorry didnt seend b4 this is the first time. just knew it. but wats the big deal? just an extra word anyway. to express some mood.

                                    P Offline
                                    P Offline
                                    Paul Conrad
                                    wrote on last edited by
                                    #17

                                    campbells wrote:

                                    just an extra word anyway. to express some mood.

                                    Though it is just a word, it is seen as being rude.


                                    Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

                                    1 Reply Last reply
                                    0
                                    • P Paul Conrad

                                      campbells wrote:

                                      i learn to put this urgent is because i saw ppl do it.

                                      And you haven't seen some of the nasty replies?


                                      Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

                                      C Offline
                                      C Offline
                                      campbells
                                      wrote on last edited by
                                      #18

                                      wat nasty replies happen recently in the forum? I guess maybe the codeproject adminstration should give some notice to the member what should write and what whould not in the forum.

                                      1 Reply Last reply
                                      0
                                      Reply
                                      • Reply as topic
                                      Log in to reply
                                      • Oldest to Newest
                                      • Newest to Oldest
                                      • Most Votes


                                      • Login

                                      • Don't have an account? Register

                                      • Login or register to search.
                                      • First post
                                        Last post
                                      0
                                      • Categories
                                      • Recent
                                      • Tags
                                      • Popular
                                      • World
                                      • Users
                                      • Groups