Results 1 to 14 of 14
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    A spreadsheet larger than Excel (Excel (All))

    Does anyone know of a spreadsheet with more columns than Excel?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A spreadsheet larger than Excel (Excel (All))

    Catharine,

    I found this information at:
    http://www.alamopc.org/PCAlamode/reviews/c.../rev030206.html

    "Today, Quattro Pro comes bundled as one of the business tools in WordPerfect

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: A spreadsheet larger than Excel (Excel (All))

    hey - thanks! <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    I never thought of QP.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Another question

    Just a followup - I found and downloaded from the Corel site a trial version of Corel Office, sorry WordPerfect Office 11. One of the interesting things I noticed while browsing around is that this version of WP Office uses [b]Visual Basic
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another question

    Thus should be a separate thread and in the VB forum.

  6. #6
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Another question

    Possibly, but I'd like to see what the Excel loungers have to say. Have you programmed in Quattro Pro?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Another question

    Nope.

    On Windoze systems, only in Word, Excel, Powerpoint, Oulook, Front Page, Access and VB.

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Another question

    Catherine ,

    VBA can be licensed by software developers for inclusion in their products. A list of companies integrating VBA in their products can be found here .

    I have dabbled with Corel's implementation in Corel Draw, but never in QP or WP. I have also worked with Business Objects implementation.

    The key to using VBA is to know the object model of the application. Given the differences in Microsoft's own implementations in the Office products, you can take nothing for granted.

    Andrew

  9. #9
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Another question

    Hey, thanks that's useful info. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: A spreadsheet larger than Excel (Excel (All))

    I have to ask, Catharine. Why would you *need* more columns? It sounds like that would create an unhold spreadsheet! <img src=/S/flee.gif border=0 alt=flee width=25 height=25>
    Charlotte

  11. #11
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: A spreadsheet larger than Excel (Excel (All))

    You can see I'm still on the subject here <post#=252392>post 252392</post#>.
    I'm working with data derived from DNA Microarray analysis (a flash movie describes the process ). Huge datasets can be generated. I've written an Excel addin that does some statistical manipulation of the data, but this was written before I knew how big the dataset could be <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>. So first I have to get it into Excel - then I'll have to update my addin <img src=/S/headthrob.gif border=0 alt=headthrob width=15 height=15>.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  12. #12
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,815
    Thanks
    132
    Thanked 479 Times in 456 Posts

    Re: A spreadsheet larger than Excel (Excel (All))

    ..split the data across 1000 sheets - then you'd have over quarter million columns.
    Excel has no limit on number of sheets (limited by memory)

    zeddy

  13. #13
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A spreadsheet larger than Excel (Excel (All))

    Maybe (since you're doing stats...) you should consider using STATISTICA (www.statsoft.com), which:

    - Handles huge datasets (which XL doesn't)
    - Has reliable stat functiions (ditto!!)
    - has VBA.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  14. #14
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: A spreadsheet larger than Excel (Excel (All))

    Is there no mileage in doing the 'transpose' bit, if the data source has fewer than 256 rows (and fewer than 65000 columns!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •