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 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