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

    C Offline
    C Offline
    Chris Maunder
    wrote on last edited by
    #2

    It's 65535 for me

    cheers, Chris Maunder

    CodeProject.com : C++ MVP

    C S N 3 Replies Last reply
    0
    • S Shree

      850 x 77.1 = 100000, not 65535!!

      R Offline
      R Offline
      RoswellNX
      wrote on last edited by
      #3

      I don't think you really want us to know about your insider trading schemes:wtf: Roswell

      "Angelinos -- excuse me. There will be civility today."
      Antonio VillaRaigosa
      City Mayor, Los Angeles, CA

      1 Reply Last reply
      0
      • C Chris Maunder

        It's 65535 for me

        cheers, Chris Maunder

        CodeProject.com : C++ MVP

        C Offline
        C Offline
        Christian Graus
        wrote on last edited by
        #4

        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 1 Reply Last reply
        0
        • C Chris Maunder

          It's 65535 for me

          cheers, Chris Maunder

          CodeProject.com : C++ MVP

          S Offline
          S Offline
          Steve Mayfield
          wrote on last edited by
          #5

          enter this formula =850 x 77.1 into an Excel cell...it displays 100000...there are several other combinations that also results in an incorrect value... see here[^] Steve

          1 Reply Last reply
          0
          • 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