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. The Lounge
  3. Bug in Excel 2007

Bug in Excel 2007

Scheduled Pinned Locked Moved The Lounge
help
21 Posts 17 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.
  • S Shree

    850 x 77.1 = 100000, not 65535!!

    S Offline
    S Offline
    Sathesh Sakthivel
    wrote on last edited by
    #6

    For me it is 65535.

    SSK. Anyone who says sunshine brings happiness has never danced in the rain.

    A E 2 Replies Last reply
    0
    • S Sathesh Sakthivel

      For me it is 65535.

      SSK. Anyone who says sunshine brings happiness has never danced in the rain.

      A Offline
      A Offline
      Andy_L_J
      wrote on last edited by
      #7

      100000 for me. I tried the examples in the blog and they all worked as stated - good to see Microsoft is 'rushing a fix' in 8 to 10 weeks.

      Kea Kaha

      1 Reply Last reply
      0
      • S Shree

        850 x 77.1 = 100000, not 65535!!

        M Offline
        M Offline
        malharone
        wrote on last edited by
        #8

        Valid bug! I can reprod it.

        1 Reply Last reply
        0
        • S Shree

          850 x 77.1 = 100000, not 65535!!

          P Offline
          P Offline
          Pete OHanlon
          wrote on last edited by
          #9

          Repost[^]!

          Deja View - the feeling that you've seen this post before.

          S 1 Reply Last reply
          0
          • P Pete OHanlon

            Repost[^]!

            Deja View - the feeling that you've seen this post before.

            S Offline
            S Offline
            Stephen Hewitt
            wrote on last edited by
            #10

            So. The most reposted posts are posts which which say "Repost"!

            Steve

            P P 2 Replies Last reply
            0
            • C Chris Maunder

              It's 65535 for me

              cheers, Chris Maunder

              CodeProject.com : C++ MVP

              N Offline
              N Offline
              NormDroid
              wrote on last edited by
              #11

              It seems it's differents results on different machines. If I type this formula =850*77.1 in A1 I get 100000, I reckon it could be a locale problem.:~

              Chuck Norris counted to infinity - twice.

              K V 2 Replies Last reply
              0
              • S Stephen Hewitt

                So. The most reposted posts are posts which which say "Repost"!

                Steve

                P Offline
                P Offline
                Pete OHanlon
                wrote on last edited by
                #12

                Stephen Hewitt wrote:

                So. The most reposted posts are posts which which say "Repost"!

                And the second most reposted are the posts that say that the most reposted posts are the posts which say Repost.

                Deja View - the feeling that you've seen this post before.

                S 1 Reply Last reply
                0
                • P Pete OHanlon

                  Stephen Hewitt wrote:

                  So. The most reposted posts are posts which which say "Repost"!

                  And the second most reposted are the posts that say that the most reposted posts are the posts which say Repost.

                  Deja View - the feeling that you've seen this post before.

                  S Offline
                  S Offline
                  Stephen Hewitt
                  wrote on last edited by
                  #13

                  I sense the possibility of infinite recursion.

                  Steve

                  V 1 Reply Last reply
                  0
                  • N NormDroid

                    It seems it's differents results on different machines. If I type this formula =850*77.1 in A1 I get 100000, I reckon it could be a locale problem.:~

                    Chuck Norris counted to infinity - twice.

                    K Offline
                    K Offline
                    kadvekar yogi
                    wrote on last edited by
                    #14

                    100000 me tooo

                    Yogesh Kadvekar

                    1 Reply Last reply
                    0
                    • S Shree

                      850 x 77.1 = 100000, not 65535!!

                      S Offline
                      S Offline
                      stevepqr
                      wrote on last edited by
                      #15

                      and yet 850 * 77.100000001 = 65535, strange! interesting but totally useless information unless you happen to ever want to calculate 850*77.1...

                      Apathy Rules - I suppose...

                      1 Reply Last reply
                      0
                      • S Stephen Hewitt

                        So. The most reposted posts are posts which which say "Repost"!

                        Steve

                        P Offline
                        P Offline
                        Patrick Etc
                        wrote on last edited by
                        #16

                        Stephen Hewitt wrote:

                        The most reposted posts are posts which which say "Repost"!

                        chika chika chika [head explodes]


                        The early bird who catches the worm works for someone who comes in late and owns the worm farm. -- Travis McGee

                        S 1 Reply Last reply
                        0
                        • S Sathesh Sakthivel

                          For me it is 65535.

                          SSK. Anyone who says sunshine brings happiness has never danced in the rain.

                          E Offline
                          E Offline
                          El Corazon
                          wrote on last edited by
                          #17

                          Vri SSK wrote:

                          For me it is 65535.

                          ditto for me, I have the correct answer. I guess my puns scared away the bugs.

                          _________________________ Asu no koto o ieba, tenjo de nezumi ga warau. Talk about things of tomorrow and the mice in the ceiling laugh. (Japanese Proverb)

                          1 Reply Last reply
                          0
                          • N NormDroid

                            It seems it's differents results on different machines. If I type this formula =850*77.1 in A1 I get 100000, I reckon it could be a locale problem.:~

                            Chuck Norris counted to infinity - twice.

                            V Offline
                            V Offline
                            Vasudevan Deepak Kumar
                            wrote on last edited by
                            #18

                            No. It is 65535 for me. It is Excel 2003 here. However, as some user pointed out, if I use x, then the Office Assistant (Rocky) is barking indicating a wrong formula and proposing to correct it as * rather.

                            Vasudevan Deepak Kumar Personal Homepage Tech Gossips

                            1 Reply Last reply
                            0
                            • S Stephen Hewitt

                              I sense the possibility of infinite recursion.

                              Steve

                              V Offline
                              V Offline
                              Vasudevan Deepak Kumar
                              wrote on last edited by
                              #19

                              Letz have a consensus on that which is on par SQLServer strategy which allows a recursion till 32 and then throws this exception: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)

                              Vasudevan Deepak Kumar Personal Homepage Tech Gossips

                              1 Reply Last reply
                              0
                              • C Christian Graus

                                This is where the OP replies with 'made you look !!!'

                                Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

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

                                Christian Graus wrote:

                                This is where the OP replies with 'made you look !!!'

                                Baaaah, I didn't even bother to look :->

                                "Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus

                                1 Reply Last reply
                                0
                                • P Patrick Etc

                                  Stephen Hewitt wrote:

                                  The most reposted posts are posts which which say "Repost"!

                                  chika chika chika [head explodes]


                                  The early bird who catches the worm works for someone who comes in late and owns the worm farm. -- Travis McGee

                                  S Offline
                                  S Offline
                                  Sathesh Sakthivel
                                  wrote on last edited by
                                  #21

                                  Patrick Sears wrote:

                                  chika chika chika [head explodes]

                                  :-D

                                  SSK. Anyone who says sunshine brings happiness has never danced in the rain.

                                  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