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. Excel 2007

Excel 2007

Scheduled Pinned Locked Moved The Lounge
csharphtmlcomtoolsquestion
14 Posts 9 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.
  • B Bassam Abdul Baki

    Anyone seen it yet? Heard that they upped the number of rows and columns and I'm curious to know if the column names are still letters :) and how it handles backward compatibility in that regard.


    "Religion is assurance in numbers." Web - Blog - RSS - Math - LinkedIn - BM

    C Offline
    C Offline
    Chris Meech
    wrote on last edited by
    #5

    Bassam Abdul-Baki wrote:

    they upped the number of rows and columns and

    The original spec used the term googleplex, but someone from marketing said no way. :)

    Chris Meech I am Canadian. [heard in a local bar] Nobody likes jerks. [espeir] Hey, I am part of a special bread, we are called smart people [Captain See Sharp] The zen of the soapbox is hard to attain...[Jörgen Sigvardsson] I wish I could remember what it was like to only have a short term memory.[David Kentley]

    B 1 Reply Last reply
    0
    • C Chris Meech

      Bassam Abdul-Baki wrote:

      they upped the number of rows and columns and

      The original spec used the term googleplex, but someone from marketing said no way. :)

      Chris Meech I am Canadian. [heard in a local bar] Nobody likes jerks. [espeir] Hey, I am part of a special bread, we are called smart people [Captain See Sharp] The zen of the soapbox is hard to attain...[Jörgen Sigvardsson] I wish I could remember what it was like to only have a short term memory.[David Kentley]

      B Offline
      B Offline
      Bassam Abdul Baki
      wrote on last edited by
      #6

      Not enough protons in the universe for a googol, let alone a googolplex. How many protons in a byte? Besides, Microsoft probably won't use the original Google. :)


      "Religion is assurance in numbers." Web - Blog - RSS - Math - LinkedIn - BM

      1 Reply Last reply
      0
      • S Sean Cundiff

        I always set my columns to numbers. I find the R1C1 reference system *much* easier to use.

        -Sean ---- Shag a Lizard

        B Offline
        B Offline
        Bassam Abdul Baki
        wrote on last edited by
        #7

        In VBA code, I do, but R12345C12345 becomes too big.


        "Religion is assurance in numbers." Web - Blog - RSS - Math - LinkedIn - BM

        1 Reply Last reply
        0
        • C Charlie Williams

          Columns and rows are still lettered and numbered, respectively. Capacity has indeed been increased and you can now have up to 4 bajillion rows (or something like that).


          if(!curlies){ return; }

          J Offline
          J Offline
          Jim Crafton
          wrote on last edited by
          #8

          Charlie Williams wrote:

          4 bajillion rows

          Holy shit, I can see the code now:

          #define FOUR_BAJILLION 0xFFFFFFFF * 0xFFFFFFFF* 0xFFFFFFFF* 0xFFFFFFFF //Take THAT OpenOffice!!!

          ¡El diablo está en mis pantalones! ¡Mire, mire! Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Techno Silliness

          J 1 Reply Last reply
          0
          • B Bassam Abdul Baki

            Anyone seen it yet? Heard that they upped the number of rows and columns and I'm curious to know if the column names are still letters :) and how it handles backward compatibility in that regard.


            "Religion is assurance in numbers." Web - Blog - RSS - Math - LinkedIn - BM

            R Offline
            R Offline
            Rob Graham
            wrote on last edited by
            #9

            According to this[^] 1 million rows by 16,000 columns. A spreadsheet large enough to walpaper ah house and still be illegible.

            J 1 Reply Last reply
            0
            • B Bassam Abdul Baki

              Anyone seen it yet? Heard that they upped the number of rows and columns and I'm curious to know if the column names are still letters :) and how it handles backward compatibility in that regard.


              "Religion is assurance in numbers." Web - Blog - RSS - Math - LinkedIn - BM

              S Offline
              S Offline
              Stephane Rodriguez
              wrote on last edited by
              #10

              2^20 rows and 2^14 columns per worksheet tab.

              B 1 Reply Last reply
              0
              • J Jim Crafton

                Charlie Williams wrote:

                4 bajillion rows

                Holy shit, I can see the code now:

                #define FOUR_BAJILLION 0xFFFFFFFF * 0xFFFFFFFF* 0xFFFFFFFF* 0xFFFFFFFF //Take THAT OpenOffice!!!

                ¡El diablo está en mis pantalones! ¡Mire, mire! Real Mentats use only 100% pure, unfooled around with Sapho Juice(tm)! SELECT * FROM User WHERE Clue > 0 0 rows returned Save an Orange - Use the VCF! Techno Silliness

                J Offline
                J Offline
                Jorgen Sigvardsson
                wrote on last edited by
                #11

                Err.. that's not 4 bajillion.

                #define FOUR_BAJILLION 0xFFFFFFFF * 0xFFFFFFFF* 0xFFFFFFFF* 0xFFFFFFFF //Take THAT OpenOffice!!!
                #define REALLY_FOUR_BAJILLION (4 * FOUR_BAJILLION) // Jim screwed up!

                :-D

                -- Touch eyeballs to screen for cheap laser surgery

                1 Reply Last reply
                0
                • R Rob Graham

                  According to this[^] 1 million rows by 16,000 columns. A spreadsheet large enough to walpaper ah house and still be illegible.

                  J Offline
                  J Offline
                  Jorgen Sigvardsson
                  wrote on last edited by
                  #12

                  I wonder what the upper limit is for sheets per book? Enough to wallpaper a skyscraper? :~

                  -- Transmitido en Martian en SAP

                  1 Reply Last reply
                  0
                  • S Stephane Rodriguez

                    2^20 rows and 2^14 columns per worksheet tab.

                    B Offline
                    B Offline
                    BadJerry
                    wrote on last edited by
                    #13

                    Hi Stephane! Ever thought of doing a powerpoint export as good as your excel one? If you do, please keep me posted! Regards, Jerry

                    S 1 Reply Last reply
                    0
                    • B BadJerry

                      Hi Stephane! Ever thought of doing a powerpoint export as good as your excel one? If you do, please keep me posted! Regards, Jerry

                      S Offline
                      S Offline
                      Stephane Rodriguez
                      wrote on last edited by
                      #14

                      Hi, I've done some market research and this is a no-go. After all, Powerpoint slides can easily be replaced by web pages. I guess that's what everybody does.

                      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