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
    Charlie Williams
    wrote on last edited by
    #2

    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 J 2 Replies 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; }

      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