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.
  • 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; }

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

    And columns? AAAAAAA...? :)


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

    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
      Sean Cundiff
      wrote on last edited by
      #4

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

      -Sean ---- Shag a Lizard

      B 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

        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