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 Offline
    S Offline
    Shree
    wrote on last edited by
    #1

    850 x 77.1 = 100000, not 65535!!

    C R S M P 6 Replies Last reply
    0
    • 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
                                          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