Slashdot Mirror


Visual Tour of Office 2007 Beta 2

feminazi writes "Computerworld has a review and visual tour of the newest installment of Office. No more toolbars & menus; those have been replace with 'ribbons.' Of the various products in the suite, Word is the most changed. Styles are easier to invoke, but no easier to create or understand. A couple of the redeeming characteristics is the ability to save as PDF and XPS and an improved Track Changes. Bigger spreadsheets are available in Excel -- over 1 million rows and over 16,000 columns per worksheet -- and new and better visualization abilities. Lots new in Outlook including multiple calendars and direct support for RSS feeds. And the apps all work together better than before. From the article: 'The major change in Beta 2 was the introduction of Office SharePoint Server.' This means that Sharepoint Server is required, but it also means more & better collaboration and advanced search abilities are supported."

495 comments

  1. Requires Sharepoint Server? by metasecure · · Score: 5, Insightful

    I believe the summary is misleading - Office 2007 will not require Sharepoint server (i.e. for an individual/independant user), though it will be needed to take advantage of it's collaborative features.

    1. Re:Requires Sharepoint Server? by Anonymous Coward · · Score: 0, Insightful

      Not exactly misleading. You just have to misread it. At any rate, you will need the SharePoint server (can anyone say point of failure?) in order to use some of the biggest features Microsoft is touting. I am not sure why people are so eager to spend money on this? Does anyone know?

    2. Re:Requires Sharepoint Server? by Ajehals · · Score: 3, Informative
      he major change in Beta 2 was the introduction of Office SharePoint Server.' This means that Sharepoint Server is required,

      May be misleading but so far if you want to utilise all the features of this office package you will probably need:

      Exchange
      Share point
      Rights Management
      Active Directory

      Plus the associated CALS, and OS licenses, the technical staff, the hardware and the training for your user base. Oh and there are NO alternatives for use with MS Office (correct me if I am wrong), Personally I'd rather build my own out of the bits that are available in OpenSource land, use the features that I (my company) needs and lump the rest, but thats not everyones cup of tea. All I really want in life is Visio for linux, or a decent clone, preferably with the network architect toolkit or similar.

      I'll live in hope or maybe I should learn a real programming language and spend some time...

    3. Re:Requires Sharepoint Server? by rosewood · · Score: 1

      Also, multiple calendars have been available in Outlook for ages. Multiple calendar viewing has been available since 2003 as well. Not the best summary in the world. It doesn't even mention where you can download the beta! That way you can just see for yourself!

      http://www.microsoft.com/office/preview/beta/getth ebeta.mspx -- but if the server is busy...

      Product Keys:
      Microsoft? Office Professional Plus 2007: MTP6Q-D868F-448FG-B6MG7-3DBKT http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/OPPLUS-EN.EXE

      Microsoft? Office Visio? Professional 2007: QB6MH-Q82HX-BFWPK-8TXTY-HHJT6 http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/OVP-EN.EXE

      Microsoft? Office Outlook? 2007 with Business Contact Manager: Not Applicable http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/BCM-EN.EXE

      Microsoft? Office Project Server 2007: BWPMX-XY8XF-KGBQ6-XKT8R-GHXD3 http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/OPS-EN.IMG

      Microsoft? Office Project Professional 2007: GP24P-FC3DP-HXY7Q-YG3JR-J4G3G http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/OPP-EN.EXE

      Microsoft? Office Groove? 2007: R83W8-GJQ82-GJ378-XQW9W-JBYKT http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/OG-EN.EXE

      Microsoft? Office Groove? Server 2007: PGT8R-VBMBC-6V7GY-TW3HT-8FP36 http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/OGS-EN.IMG

      Microsoft? Office OneNote? 2007: TFKGD-9VXBG-T22DK-FQB9P-MBPG6 http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/OON-EN.EXE

      Microsoft? Office SharePoint? Designer 2007: VQCR8-6KP8Q-Y2FTW-3YQD7-R22G6 http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/SPD-EN.EXE

      Microsoft? Office SharePoint? Server 2007 - Enterprise: FDJDK-66WCT-2HD9C-4TY63-38C4G http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/SPS32-EN.IMG

      Microsoft? Office SharePoint? Server 2007 - Enterprise(x64): FDJDK-66WCT-2HD9C-4TY63-38C4G http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/SPS64-EN.IMG

      Microsoft? Office Forms Server 2007: FDJDK-66WCT-2HD9C-4TY63-38C4G http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/OFS32-EN.IMG

      Microsoft? Office Forms Server 2007 (x64): FDJDK-66WCT-2HD9C-4TY63-38C4G http://download.esd.licensetech.com/Microsoft/DMMS O12B/PRO/AKAMAIFILES/OFS64-EN.

    4. Re:Requires Sharepoint Server? by gwayne · · Score: 1

      All I really want in life is Visio for linux, or a decent clone, preferably with the network architect toolkit or similar.

      It's called Dia

    5. Re:Requires Sharepoint Server? by TheNetAvenger · · Score: 4, Informative

      May be misleading but so far if you want to utilise all the features of this office package you will probably need:

      Exchange
      Share point
      Rights Management
      Active Directory

      Plus the associated CALS, and OS licenses, the technical staff, the hardware and the training for your user base. Oh and there are NO alternatives for use with MS Office (correct me if I am wrong), Personally I'd rather build my own out of the bits that are available in OpenSource land, use the features that I (my company) needs and lump the rest, but thats not everyones cup of tea. All I really want in life is Visio for linux, or a decent clone, preferably with the network architect toolkit or similar.


      Um, No... Oh and also NO....

      Where do people get this information? Are you really in the beta, because if you are, meet me in the groups and we can discuss this, because what you wrote is about as insane as it gets.

      Just for an example:
      Outlook works and 'collaborates' quite well with ANY Mail server, you can eve do Office forms, Replies and a lot of the other features, including LDAP support all with a simple and even FREE mail server softare. If your Mail server supports POP3 or IMAP, you are quite set with Outlook.

      Sure Outlook is ALSO an exchange client and will use the exchange features, but NEITHER require each other, understand?

      As for these others:
      Share point
      Rights Management
      Active Directory


      Do you even know what you are talking about? Active Directory is something not even used by Office unless you are running a SERVER VERSION of Office, which 99.9% of the people using Office do not. Also the 'Active Directory' requirements are NOT even exclusive to Windows Server Active Directory Server.

      As for the CALS, do you NOT realize that each VERSION of Office is its own CAL? That is what it is, a client application, there are no additional server CALs needed. Even Outlook qualifies to be a full CAL for Exchange.

      You need to read up quite a bit before making outlandish posts.

      Oh, also you state 'rights management' WTF are you even talking about?

    6. Re:Requires Sharepoint Server? by poolmeister · · Score: 2, Informative

      Dia doesn't support the Visio file format though so if Ajehals doesn't mind dumping all of his existing charts and giving up the ability to share his charts with Visio users, Dia would be fine.

      --
      CN=poolmeister.OU=lurkers.CN=slashdot
    7. Re:Requires Sharepoint Server? by Anonymous Coward · · Score: 0

      I think you're in a pretty small minority there. However, minority or no, I'd like to point out that MS Office, Corel WordPerfect, and a number of others have been out for a very long time now. If you don't like OpenOffice.org, DON'T USE IT!

    8. Re:Requires Sharepoint Server? by Ajehals · · Score: 1, Informative
      Alright, fair enough, however;

      Outlook works and 'collaborates' quite well with ANY Mail server,

      In reality to use Exchange to its full potential you need an exchange server, if you are realistically deploying Exchange you will be using Active Directory, if you want centralised Rights Management you need the centralised server component, if you want the nice new collaboration tools you need sharepoint. Hell you also need to be running Windows (presumably XP).

      Now I know that you don't need all this, however if you want to maximise the potential of this office suite, thats what you need. I have implemented many IMAP Servers (mainly Cyrus) and have had people using Outlook with them, but it isnt the same as having exchange, frankly for all this collaberation junk you are better off setting up a true GroupWare environment of some sort and just using your office apps for producing documents.

      Now again I realise that you recieve a CAL for exchange when you buy Outlook, and you probably get a SharePoint CAL too, but last time I checked (and its been a long while, + we used per processor licensing wherever possible..) for every client capable of accessing a server you technically require a CAL, including for File Servers, i.e. plain old NT/2k/2k3 server which you dont get with Office.

      So in short if you are already using MS kit this probably isnt a bad thing, just another upgrade on the road to paradise(?) but if you dont use all and possibly only Microsoft technology, this isnt a plus. It is all about lock in to Microsoft technologies.

      But yes I see your point, you dont need anything, but if you want to make the most out of your software you really do need a lot of kit.

    9. Re:Requires Sharepoint Server? by Anonymous Coward · · Score: 3, Informative

      As for the CALS, do you NOT realize that each VERSION of Office is its own CAL? That is what it is, a client application, there are no additional server CALs needed. Even Outlook qualifies to be a full CAL for Exchange.

      You need to read up quite a bit before making outlandish posts.

      As do you. Buying a copy of Office is NOT the same as buying an Exchange CAL. You're horribly confusing software licenses with client access licenses... And further, if you use Sharepoint or Exchange, or other authenticated services, you pay a server license fee, for the server application.

      To wit, the original poster is closer to the truth. To fully leverage the MS Office Suite (mostly Outlook), you need Exchange, which requires Active Directory, and you need Sharepoint if you want to use any of the "collaborative" features. If you're corporate or academic, you can volume license CALs but if you go that route, you need 1) Office CAL (covers Office suite), 2) Core CAL (covers Exchange, Sharepoint, SMS, other authenticated Windows services), 3) Windows Server OS licenses, and 4) server application licenses. Buying #1, the Office CAL, does not entitle you to any of the other three....

    10. Re:Requires Sharepoint Server? by Chanc_Gorkon · · Score: 1

      Um....understand this...your typical office worker barely understands e-mail let alone "collaborative" environments. Most can barely understand what a network drive menas. Most still can't manage to use Exchange correctly to send appointments. Now sure, I ain't using every possible feature there is to use on Office 2004 or Office 2007 but who the bloody hell does?? I still can E-MAIL any Office Document and that's fine for 90 percent of the people out there. My point is your only tied to this if YOU CHOOSE TO BE! You CAN use Office 2007 just fine without Sharpoint and all the rest of that mularky.

      --

      Gorkman

    11. Re:Requires Sharepoint Server? by maxhead · · Score: 1

      <Nelson> *Slugs parent in the gut" "Ha, ha! Windows Dork!" </Nelson>

    12. Re:Requires Sharepoint Server? by colinrichardday · · Score: 1

      Then how is Office 2007 better than Office 2003? Is the difference worth the upgrade?

    13. Re:Requires Sharepoint Server? by Anonymous Coward · · Score: 0
      1) Office CAL (covers Office suite)

      Office is an Application. You need a license, not a CAL.

      2) Core CAL (covers Exchange, Sharepoint, SMS, other authenticated Windows services),

      Core CAL includes Server, Exchange, SMS, and Sharepoint CAL. Each is available seperately, but "Core CAL" is only available to sites with more than 250 users, after which its priced slightlty blelow the cost of 3 of those CALs (Think buy 3 get 1 free). Other authenticated Windows services are extra.

      If you're corporate or academic, you can volume license CALs but if you go that route

      Don't forget government and non-profits. Anyone can Volume License, but if you aren't dealing with an organization of a certains size, why would you bother? To fully leverage the MS Office Suite

      This is perhap the dumbest statement ever. To fully leverage Linux, do you need a dozen or more NUMA servers to create a Beaowulf cluster attached to a SAN while plugged into a 10GB switch fabric? Because if you aren't using every feature available in the kernel, you're not "fully leveraging" linux?

      You can hapily use Outlook with and SMTP/POP3/IMAP server, and many of the collaborative features will work just fine, though some won't be. You can schedule meetings with Bob, but you can't check his calendar to see what time he's free. If this functionality is worth an investment in Exchnage, then invest.

    14. Re:Requires Sharepoint Server? by Anonymous Coward · · Score: 0
      Dude, it has ribbons! Ribbons!

      From TFA:
      For the individual user struggling to use Word, an intermediate user who wants to get more done with Excel or an office worker who could benefit from seeing multiple calendars at once, Office 12's new interface and updated graphics are welcome, but may not be sufficiently compelling to justify an upgrade.

      Of course, this could be said of every version since 97.
    15. Re:Requires Sharepoint Server? by ddopson · · Score: 1

      Don't forget Terminal Server CAL's. My team has to make money too!

    16. Re:Requires Sharepoint Server? by tokul · · Score: 2, Interesting

      Do you even know what you are talking about? Active Directory is something not even used by Office unless you are running a SERVER VERSION of Office, which 99.9% of the people using Office do not. Also the 'Active Directory' requirements are NOT even exclusive to Windows Server Active Directory Server.

      Some Office features require sharepoint server. SharePoint Portal Server 2003 requires "one of the following servers: Microsoft Windows Server 2003 Standard Edition, Windows Server 2003 Enterprise Edition, Windows Server 2003 Datacenter Edition, or Windows Server 2003 Web Edition, plus the latest service pack (see Other for additional requirements). Running SharePoint Portal Server 2003 on Windows Server 2003 Web Edition requires SQL Server 2000 to be installed on a separate computer.". And in order to use clients with Windows Server, you will need server cals or Windows 2000/XP Pro license for each client workstation.

      As for the CALS, do you NOT realize that each VERSION of Office is its own CAL? That is what it is, a client application, there are no additional server CALs needed. Even Outlook qualifies to be a full CAL for Exchange.

      Nope. Exchange CALs give right to run Outlook. Outlook or Office itself does not provide Exchange client license.

    17. Re:Requires Sharepoint Server? by TheNetAvenger · · Score: 1

      Some Office features require sharepoint server. SharePoint Portal Server 2003 requires "one of the following servers: Microsoft Windows Server 2003 Standard Edition, Windows Server 2003 Enterprise Edition, Windows Server 2003 Datacenter Edition, or Windows Server 2003 Web Edition, plus the latest service pack (see Other for additional requirements). Running SharePoint Portal Server 2003 on Windows Server 2003 Web Edition requires SQL Server 2000 to be installed on a separate computer.". And in order to use clients with Windows Server, you will need server cals or Windows 2000/XP Pro license for each client workstation.

      Ok read this to yourself, please... Unless you are planning on running Office 2007 on Wine, you will HAVE a Windows CAL, as Home Edition of XP won't even work in a Domain environment in the first place...

      Nope. Exchange CALs give right to run Outlook. Outlook or Office itself does not provide Exchange client license.

      Exchange has two TYPES of CALs. One is the server side license and the other is the client.

      And again, my point is that YOU DO NOT NEED EXCHANGE to use Outlook, and YOU DO NOT NEED ANY SHAREPOINT SERVER to use Microsoft Office UNLESS you are specifically USING THE SHAREPOINT SERVER 'SHARING' Features...

      People arguing that you 'need' a Sharepoint server for Office is like arguing that you need a print server for the new Ink jet you just purchased, which is pretty ridiculous.

      Sure if you are using the Sharepoint SERVER FEATURES that OFFICE CAN ACCESS then of course you would need a Sharepoint Server. Geesh...

      Most people and even MOST companies don't need the Sharepoint Server features, and additionally, if they are already running a Windows Server, dropping sharepoint server services on it is not a big task.

    18. Re:Requires Sharepoint Server? by Yer+Mom · · Score: 1

      ObSpinalTap: This one goes up to 2007.

      --
      Never mind Spamassassin. When's Spammerassassin coming out?
    19. Re:Requires Sharepoint Server? by deltx · · Score: 1

      Totally agreed but if you do not use the exchange, sharepoint etc. services what is the attraction to purchase. Increasing expenses, have a ribbon based program ?? Also the tech support is going to be interesting switching gears call by call to ribbons and menues. MS needs to remeber that just because you can radically change something it does not make it superior and there is an entire re-education process that may not be justified. "Because you can do it does not make it worth it"

    20. Re:Requires Sharepoint Server? by Watts+Martin · · Score: 1

      I think you and some of the other people are arguing at cross-purposes.

      You're right in that Office doesn't require any server support to be a functional office suite for individuals. To be a good tool for collaboration in an actual office, however, the more Microsoft Server technology you have behind it the better off you are. Outlook may be a perfectly serviceable mail client when it's not talking to Exchange, but the resource scheduling and its tight integration with calendar and mail functions is lost. Sharepoint Server certainly isn't required, but there's a range of functionality relating to web publishing/sharing that's lost.

      This is all entirely by design, and I have absolutely no doubt that there's even more of this in Office 2007 than there is in the current Office 2003 iteration. No matter how neato keen the new ribbon interface may be in practice, that alone is not going to get a company with 1000 (let alone 10,000 or more) desktop licenses to rush out and upgrade. "Look at all the neat stuff Office's integration with our server technologies gives you" is a more compelling case.

      Sure, you're right, nobody has to buy those server technologies to use Office 2007: but if they don't, they may decide they don't have to buy Office 2007 at all. And I think that's mostly what people are saying here. We're all aware that a guy off the company LAN is still likely to be able to use Office without any issues -- it's just that he may decide it's not worth bothering, and for Microsoft, that's a big issue.

    21. Re:Requires Sharepoint Server? by TheNetAvenger · · Score: 1

      Sure, you're right, nobody has to buy those server technologies to use Office 2007: but if they don't, they may decide they don't have to buy Office 2007 at all. And I think that's mostly what people are saying here. We're all aware that a guy off the company LAN is still likely to be able to use Office without any issues -- it's just that he may decide it's not worth bothering, and for Microsoft, that's a big issue.

      It is like this... People are putting WAY TOO MUCH EMPHASIS on the Server technologies of Office. It is VIRTUALLY NO DIFFERENT in 2007 than it was in Office 2000 even.

      Office 2000 had sharepoint server side components, and outlook worked with exchange then as well.

      This really has VERY little to do with the functionality of Office, trust someone that uses it BOTH senerios.

      Microsoft surely wants you to use Office and the Server side 'features' are BONUS features for offices to make things easier, but are NOT a requirement.

      Even the scheduling and calendaring that you mention would be lost is NOT true, you can still use these features even without any Server collaboration software. The second part is you are NOT locked into the MS technologies if you want to use the SERVER side features. Go look at IceWarp and their software, it offers many of the server side features that INTEGRATE with Office just as if it was a MS product running on the server.

      I also think people DO NOT FULLY understand what SharePoint is and WHY it is... Sharepoint is FREE if you are running a Windows Server, and its SOLE purpose is in creating a Web Internet/Intranet WITHOUT programming or HTML knowledge, that gives companies a place to share ideas, tasks, and documents. It has been around for a long time, and sure the newest version has some really keen features that are appealing, but linking this to Office as some sort of knock to Office or saying it is a 'requirement' for Office is COMPLETELY FALSE.

      I don't totally disagree with you or many others here, but the level of misunderstand or importance placed on the server side features that Office can use are OVERLY stated to the point of being ridiculous.

      As for people rushing out to Upgrade to Office 2007, I think you are right that people with Office 2003 will probably not be the first mass group to upgrade. However for people that are still using OfficeXP or earlier, this is a good point to upgrade for them, and that would more of the target market. If you watch MS and the Office product lines, their upgrade clients on their products are usually from the a couple of versions prior to the current product release.

      Also Office 2007 is not a dud, as witnessed by the Mac and Windows community for the last 20 years. Of all the 'teams' at Microsoft, the Office teams seems to be one of the most consistent at 'innovation' and putting out solid releases. The only other team at Microsoft I have this high of respect for would be the compiler and development tool nerds.

    22. Re:Requires Sharepoint Server? by TheNetAvenger · · Score: 1

      In reality to use Exchange to its full potential you need an exchange server, if you are realistically deploying Exchange you will be using Active Directory, if you want centralised Rights Management you need the centralised server component, if you want the nice new collaboration tools you need sharepoint. Hell you also need to be running Windows (presumably XP).

      1) This is not about exchange and needing outlook for exchange. Besides, you REALLY don't, the Web Mail inteface for the latest Exchange is quite rich if you want to go that route.

      2) You don't need MS server products to use the Office collaborative features, products like Merak and IpSwitch offer quite nice collaboration suites for the server that are very cheap, and INTEGRATE with Office and Outlook.

      3) The 'Nice New' collaboration tools are NOT truly new. Microsoft Office has shipped with Sharepoint and Server side collaboation features since Office 2000. These are just the 'newer' versions of them. Which is why stating that Office 2007 needs the server crap to work any differently than Office for the last 7 years is insane.

      We have been testing Office 2007 in both senerios, with the server side Exchange, Sharepoint all the bells and whistles. We also have been testing it without ANY MS on the servers still share files and even non run from non-MS mail servers. Guess what, there is virtually no difference, even for the hard core Office employees.

      The only real difference to the employees is the Sharepoint Site, which is something that you don't even need Office to run, it is a free download for any Windows Server. And it is not a 'tool' of Office, but a tool to create a Company Web/Intranet Site without any HTML coding. Sure Office can use it to save a file to the sharepoint site, just like in previous versions, but that doesn't have really anything to do with Office unless the people are already using Sharepoint Sites for their Intranets.

      People are way to uptight about any 'server' side requirements for functionality in Office 2007. It isn't any different than Office for the last 7 years, truly, and you aren't 'losing' features by not having a MS server with Sharepoint and Exchange, they are 'external' to Office in this sense.

    23. Re:Requires Sharepoint Server? by Anonymous Coward · · Score: 0
      Don't forget Terminal Server CAL's. My team has to make money too!

      TS CALs were never mentioned in the Core CAL sales pitch. If its part of Core CAL, you need to get on those reps to mention it. The one thing I know is that XP Pro "included" a 2000 TS CAL that could not be used with 2003 TS

  2. I guess it HAS to be better to sell it by yagu · · Score: 2, Insightful

    Here's a laundry list, but I don't think the stains will come out:

    • For example, the Home ribbon in Word offers shortcuts for the clipboard (cut, copy, paste) and font formatting (font and font size, underlines and superscripts and so on) -- the kind of everyday tasks most of us use in Word. If you click inside a table, Word presents a special ribbon with just table options. When you move away from the table, the ribbon disappears. It's a good example of providing help right when you need it and staying out of the way when you don't.

      This is an extension of the abstration of the chevron menus... alter the user's environment based on usage. It doesn't work. I've used environments like this and it takes getting used to. You think it was confusing trying to show people how to use Microsoft products when the pulldown menus changed seemingly randomly? Wait until their "ribbons" change based on cursor position.

    • For instance, the Heading 3 style icon shows a small, plain (that is, not bold) font. These style buttons work in tandem with a "what you see is what you get" feature. Select some text (or an entire document) and hover over the Heading 3 style icon, and Word immediately applies the Heading 3 style in a "preview" mode...

      Hover mode for tooltips, maybe. But this will confuse users. I think it's clever, but I don't need clever. Also: ..., The preview mode is also available with other icons in the ribbon, such as font and font size, but oddly not for the paragraph-control icons.... So, a potentially confusing behavior (feature) of the new WORD is inconsistent. So, for those who recognize and like the style "preview" can be confused by the styles not given preview stature for their icons.

    • Excel 2007 now supports over 1 million rows and over 16,000 columns per worksheet.

      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

    • (From the Slashdot article): And the apps all work together better than before. From the article: 'The major change in Beta 2 was the introduction of Office SharePoint Server.' This means that Sharepoint Server is required, but it also means more & better collaboration and advanced search abilities are supported.".

      Microsoft trots this out every new release. It's never turned out to be true, it won't be true this time. Microsoft does however get the added benefit of requiring yet another additional piece of software (SharePoint Server) tying customers more tightly with the Microsoft leash.

      NOTE: do not confuse greater interaction functionality with work together better. This is an important distinction.

    Go read the seven page article. It describes an ugly mess of a new suite of products. When customers ask for simpler, noone listens, at least not Microsoft. For example, you want simplicity? You now must choose from one of seven bundling options (sounds like the new Vista): Basic; Home and Student; Standard; Small Business; Professional; Professional Plus; and Enterprise.

    The listed prices range from $149 (student) to $499 (Professional Plus) with no price listed for the required SharePoint Server (volume licensing only). Oh, subtract $170 or so for the upgrade version.

    If you or your company considers this, get ready for more incompatiblities with previous generations, and retro installation of plugins. That's okay within a company (to some), but think carefully about the impedance mismatch with the rest of the world.

    1. Re:I guess it HAS to be better to sell it by bryan_is_a_kfo · · Score: 1

      > WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database. It's not the people in IT you have to worry about, it's analysts with 1MM row datasets. At first my thought was "the horror of a 1MM row spreadsheet! blashpemy!... but now I'm thinking at least they wont be as tempted to us MS Access..

    2. Re:I guess it HAS to be better to sell it by JDAustin · · Score: 1

      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      The problem isnt having 1 million rows available but that the current 65k row limit is not enough.

    3. Re:I guess it HAS to be better to sell it by Volante3192 · · Score: 2, Funny

      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      But I REALLY need to let Nina in Corporate Accounts Payable be able to =SUM(A1:A1000000)...

    4. Re:I guess it HAS to be better to sell it by Red+Flayer · · Score: 4, Insightful

      "WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database."

      It's not the IT guys you have to worry about, it's the beancounters.

      /recovering accountant here.

      And yes, we had several databases that started as an useable Excel spreadsheet and blossomed into ridiculous rowcounts. And no, management wouldn't let us convert to a real database, Excel was the only approved file format in accounting.

      --
      "Trolls they were, but filled with the evil will of their master: a fell race..." -- J.R.R. Tolkien on Olog-hai
    5. Re:I guess it HAS to be better to sell it by stinerman · · Score: 5, Funny

      The listed prices range from $149 ... subtract $170 or so for the upgrade version

      Sold!

    6. Re:I guess it HAS to be better to sell it by jasonmicron · · Score: 0

      All that's missing from your rant is the line, "Just get OpenOffice 2.0. It's free".

      Sheesh. A lot of those features look really awesome and could work great together if utilized with Sharepoint. I'm not a fan of having to buy a 2nd Microsoft product to produce the best productivity from the 1st one but it _is_ rather cool. I've seen several of the demos on Microsoft's website and, if utilized the way M$ advertises will help me immensely with several regular tasks.

      And if anyone upgrades their enterprise to this new version without getting rid of the older version(s), well, they need a new IT director. You _always_ upgrade everyone / everything at once to the same version. Anomolies should be kept to a minimum.

    7. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0
      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      It is not so much about the million as increasing the limit of 64k. That said, even if the data is in a database, dumping them to Excel for flexible end user analysing/pivoting/reporting is not without merit.

    8. Re:I guess it HAS to be better to sell it by poster.poster · · Score: 1

      Excel 2007 now supports over 1 million rows and over 16,000 columns per worksheet.

      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.


      This is what I've been waiting for. I write programs that deal with scientific data and this issue has come up again and again for pretty much everyone that uses our data. I try my best to force things to use databases, but sometimes it just doesn't work with the way the current environment is built...and when that happens, the current limits of Excel make the job completely suck. This reason alone is the reason that I'm excited for the next version to come out.

    9. Re:I guess it HAS to be better to sell it by jxyama · · Score: 5, Insightful
      >WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      You are aware the previous limit in Excel was 65k rows. There's a lot of area between 65k and 1M which is handled better by a spreadsheet rather than a database.

      MS expanding the limit (granted 10 years overdue) and offering the flexibility is a good thing no matter how you may want to spin it otherwise.

    10. Re:I guess it HAS to be better to sell it by mikesmind · · Score: 5, Interesting
      The listed prices range from $149 (student) to $499 (Professional Plus) with no price listed for the required SharePoint Server (volume licensing only). Oh, subtract $170 or so for the upgrade version.

      While this may be slightly off-topic, hopefully it is interesting. Someone I know at work was looking to buy a used copy of MS Office. I suggested that he download OpenOffice.org. When I asked him about it a week later, he told me that he had downloaded it and was now using it. OpenOffice.org did everything he needed it to do and he really liked the price tag!

      Now I will try to relate this back to the topic at hand. Now that Microsoft is radically changing Office, it is a great time to switch to OpenOffice.org. The interface is close enough to Office, that retraining is minimal. It is questionable how many companies will use the collaboration features. Generally features are used as justification for upgrading but often the additional features are not well-utilized.

      --
      www.mikesmind.com - www.daddyworkathome.com - www.freetofarm.org - www.tenfoottable.com
    11. Re:I guess it HAS to be better to sell it by guitaristx · · Score: 1

      Yes, apparently Office products are tons more feature-rich than their open-source equivalents....

      --
      I pity the foo that isn't metasyntactic
    12. Re:I guess it HAS to be better to sell it by Rude+Turnip · · Score: 1

      FWIW: =sum(A:A) is a little more "future proof."

    13. Re:I guess it HAS to be better to sell it by Rakshasa+Taisab · · Score: 1

      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      If anyone spent that long to implement an upgrade to a paltry 1M x 16K spreadsheet size, I'd seriously consider demoting them to janitors.

      --
      - These characters were randomly selected.
    14. Re:I guess it HAS to be better to sell it by babbling · · Score: 1

      Yeah, this new Office might be "improved" for you, but what about people who are not comfortable using computers? That's the majority of the population, last time I checked, by the way...

      Many people who currently use Office have memorised what they need to click on to do a particular set of tasks rather than having learnt how to use a GUI to do any task. For these people, the new Office will be unusable without them being trained how to use a computer all over again.

      The original poster is right. Microsoft don't seem to understand the needs of their users. It's absolutely incredible that they don't, but it seems to be the case. Big UI changes should be a no-no, but I suppose it is rather difficult to improve a program without changing the UI.

      We're not arguing that the new Office isn't improved for people who can use it, but that it will be a distaster because lots of people won't know how to use it.

    15. Re:I guess it HAS to be better to sell it by christopherfinke · · Score: 4, Interesting
      It's not the IT guys you have to worry about, it's the beancounters.
      Exactly. My wife just called me from work (she's an accountant) and asked if I knew how to get around this error: "Spreadsheet is full." I asked her how many rows it had: "About 100,000." Apparently this isn't that uncommon...
    16. Re:I guess it HAS to be better to sell it by ahsile · · Score: 2, Funny

      Corporate accounts payable, Nina speaking. Just a moment.
      Corporate accounts payable, Nina speaking. Just a moment.
      Corporate accounts payable, Nina speaking. Just a moment.
      Corporate accounts payable, Nina speaking. Just a moment.
      Corporate accounts payable, Nina speaking. Just a moment.
      Corporate accounts payable, Nina speaking. Just a moment.
      Corporate accounts payable, Nina speaking. Just a moment. ...

    17. Re:I guess it HAS to be better to sell it by babbling · · Score: 1

      You're right. The collaboration features will be too complicated for the majority of office workers. Imagine someone who isn't comfortable using computers trying to understand what CVS does and how the CVS system works. I'm sure Microsoft have tried to make the collaboration as simple as possible, but if it's too simple, it won't be powerful. If it's powerful, it won't be simple.

      A collaboration tool that is both simple and powerful is extremely difficult to do, if not impossible. At best, companies might be able to train computer illiterates to make it work more or less by accident. More likely is that people will just use internal email, as they currently do for collaboration, though.

    18. Re:I guess it HAS to be better to sell it by thePig · · Score: 1

      The listed prices range from $149 (student) to $499 (Professional Plus) with no price listed for the required SharePoint Server (volume licensing only). Oh, subtract $170 or so for the upgrade version.

      Ooh!! Are they going to pay me then if I upgrade to a student version ??
      Should I do a deal with the devil -- sell my soul for $21 ...
      ---What the heck!! Soul cant buy be 2 med sized pizzas...
      YYo Vista ..

      --
      rajmohan_h@yahoo.com
    19. Re:I guess it HAS to be better to sell it by CableModemSniper · · Score: 1

      I wonder if there's a market for a spreadsheet that uses database-style storage and memory management. Sort of of half-way between Excel and a real db. It could include all the shiny mathematical, statistical, and financial functions of a spreadsheet, with a spreadsheet interface but take advantage of a database style backend. And of course there would be a shiny "Migrate" button that would convert your spreadsheet into a SQL db (or alternatively, have two interfaces the SQL style and the spreadsheet style to the same data.)

      --
      Why not fork?
    20. Re:I guess it HAS to be better to sell it by StarvingSE · · Score: 0, Redundant

      I doubt anyone ever needed or will need 1 million rows. Its called Marketing Speak 101. OMG Look!!! We have ONE MILLION ROWS!!! SOOOO MUCH BETTER THAN THE 65K IN THE PREVIOUS VERSION.

      They have to have justification for a new version somehow, so that you can feel good about giving them more $$$ for something you basically already have.

      --
      I got nothin'
    21. Re:I guess it HAS to be better to sell it by caluml · · Score: 5, Insightful
      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      Yeah, but if it couldn't support many, you'd be the first saying: Heh look at teh l4me Excel. It's because evil M$ wantz joo to buy SQL server. Evil, evil.

    22. Re:I guess it HAS to be better to sell it by Red+Flayer · · Score: 1

      What did you tell her? Without knowing the specifics of the ss, it's hard to figure out the best solution, but we often classed the records and split the ss according to classes. Kind of a PITA, especially the labeling, but filtering and copy/pasting helped, as did sort and fill.

      --
      "Trolls they were, but filled with the evil will of their master: a fell race..." -- J.R.R. Tolkien on Olog-hai
    23. Re:I guess it HAS to be better to sell it by VertigoAce · · Score: 4, Interesting

      This is an extension of the abstration of the chevron menus... alter the user's environment based on usage. It doesn't work. I've used environments like this and it takes getting used to. You think it was confusing trying to show people how to use Microsoft products when the pulldown menus changed seemingly randomly? Wait until their "ribbons" change based on cursor position.

      I just gave this a try in Word 12. It is a lot less drastic than you imply. If I have a word document with a bunch of text and a table in the middle, changing the cursor position does not change the current tab (where each tab is basically a set of toolbars grouped by task). All that changes is a little section of the window is highlighted indicating which tabs are related to table design. It's not intrusive, but conveys the point very clearly.

      Office 12 does a lot to expose existing functionality to the typical user. Things that used to be buried deep in menus and dialog boxes are presented in a much more intuitive way. Try it out some time if you get a chance. Yes, the UI is different from most other applications, but it seems to be a model worthy of consideration for other applications.

    24. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 1

      And no, management wouldn't let us convert to a real database, Excel was the only approved file format in accounting.

      Tell me about it. Most of the accountants I know write their emails in Excel.

    25. Re:I guess it HAS to be better to sell it by Aram+Fingal · · Score: 1

      I've run into the same problems you have with scientific data but I would rather see these applications improved to more easily utilize databases rather than try to improve spreadsheets to accomodate the scientific applications. Databases offer so much more flexability to do things like view statistics calculated on the fly from raw data stored from multiple experiments.

      There are a number of Perl modules which can be used for analysis and graphing of scientific data from databases. Obviously, you don't want to have to write your own program every time you want to process data but maybe it would be feasable to set up a framework for scientific data analysis kind of like the way Catalyst works for setting up web sites. Then you could have some standard applications based on that framework. --Just thinking out loud about one way to make this happen. The important thing is the concept that scientists would really be better served by changing this paradigm.

    26. Re:I guess it HAS to be better to sell it by panaceaa · · Score: 1

      How many KB should be enough for everybody? 640! Not 655!

      What's the limit in Excel rows? 64k, not 65k!! :( Slashdot needs more geeks.

    27. Re:I guess it HAS to be better to sell it by Typhon100 · · Score: 1

      I don't claim to know which is better, but I do know that MS spends tons of money and resources on usability studies. If you think the ribbon is just some designer's pipe dream, I don't think you're giving MS enough credit (if you're willing to give them any credit whatsoever). They wouldn't be doing this if they didn't think it was worth it.

    28. Re:I guess it HAS to be better to sell it by rueger · · Score: 1

      In related news, if you embed audio files in your spreadsheet you will now be able to turn the volume up to ELEVEN!

    29. Re:I guess it HAS to be better to sell it by PrvtBurrito · · Score: 1

      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database. I hope you are not a developer because an attitude like this makes software less useable. Frankly, nobody cares what you think (and I hope you realize that there is a point there). As computers get bigger and faster, the software should also grow to accommodate more resources. The fact of the matter is, people hit the limit on excel all the time, and my IT group has to deal with that bs. It wastes my productivity (and my teams), and I have absolutely no say in the matter. You may be right, but that approach is idealistic and not realistic.

      --
      Laboratree - Scientific collaboration based on OpenSocial.
    30. Re:I guess it HAS to be better to sell it by bheer · · Score: 2, Interesting

      This is an extension of the abstration of the chevron menus... alter the user's environment based on usage. It doesn't work. I've used environments like this and it takes getting used to. You think it was confusing trying to show people how to use Microsoft products when the pulldown menus changed seemingly randomly? Wait until their "ribbons" change based on cursor position.

      Are you saying that based on assumption or actual use of the product? I've been using beta 1 for some time and it seems quite natural to me. In particular this is dead wrong: "This is an extension of the abstration of the chevron menus". It isn't. 'Chevron menus' did not appear, you had to basically do a show-all and then choose an item, after which it would be visible until it fell into disuse. The ribbons have a tab strip above them so it's easy to see the ones NOT in front. The ribbons feel like the old Lotus SmartIcons *done right* (unlike the ghastly implementation in some Lotus products like Notes).

      > The listed prices range from $149 (student)

      Office 2002 and 2003 have been available at the same list price ("student and teacher edition"), and Amazon sells 'em for $99 (valid on _three_ PCs if anyone in your home is a student or teacher).

    31. Re:I guess it HAS to be better to sell it by wanerious · · Score: 1

      Yep. For example, my students in physics and engineering will occasionally use Excel for fairly simple numeric computations --- figuring out dynamics from equations of motion, and so on. It's perfectly ligitimate to have 100,000 - 500,000 time steps for accuracy.

    32. Re:I guess it HAS to be better to sell it by SerpentMage · · Score: 2, Insightful

      The one million rows is a relief.... Wanna know where people use that many rows? Financial services! Traders, etc like using Excel to do mathematical analysis, and I don't blame them. Excel is easy to automate and to do things over and over again.

      Some may say, "Oh but get a programmer". Oh yeah, and wanna see the costs as a result of getting a programmer involved? Traders wanna try out scenarios where the maths constantly change. Excel is perfect!

      That's why you need 1 million records.

      --

      "You can't make a race horse of a pig"
      "No," said Samuel, "but you can make very fast pig"
    33. Re:I guess it HAS to be better to sell it by Imsdal · · Score: 1
      Yeah, this new Office might be "improved" for you, but what about people who are not comfortable using computers? That's the majority of the population, last time I checked, by the way...

      The majority of people in the world are definitely not comfortable using a computer. However, the majority of users of Office 2K7 are, in fact, reasonably comfortable using computers. That's what counts, and what a billion chinese think of the matter isn't important.

    34. Re:I guess it HAS to be better to sell it by teal_ · · Score: 1

      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      Well, sometimes that's how it is with legacy systems that have been in place for 10 years and you haven't had the time or money to devote to doing it "right". There are many, many applications out there that have a giant Excel spreadsheet in the thick of it getting data from here and exporting it to there.

      The person you want to demote left the company 8 years ago and we don't have the money to hire a contractor for 60 bucks an hour for 3 months to make it a spiffy LAMP application. Not to mention the cost of bringing the idiot back to fix his own bugs for 100 bucks an hour.

      So in this case, I think you're being a bit harsh on MS, a lot of people will appreciate this as applications age and spreadsheets grow.

    35. Re:I guess it HAS to be better to sell it by Coryoth · · Score: 1

      It is easy to do analysis and plotting of scientific data from databases. All you have to do is actually use the right tool for the job. Do you have gobs of numerical data that you want to crunch, analyse and plot? Then you probably want Matlab or R. Is that data in a database? Then you'll probably be using Matlab's database toolbox or R's database connectivity to import and export data (based on whatever database query you care to use - you can import whole tables easily if you like). Once the data is imported (which is trivial) you have no shortage of tools to process, munge, analyse, and plot to your heart's content.

      Jedidiah.

    36. Re:I guess it HAS to be better to sell it by Red+Flayer · · Score: 1

      "Tell me about it. Most of the accountants I know write their emails in Excel."

      Of course, how else can we maintain metrics of email efficiency? I regularly email directly from Excel when I need to shoot a quick analysis to someone for review. Also, a lot of accountants who have very specific roles tend to use Excel as their calendar tool, as their scheduling tool, basically as their desktop.

      --
      "Trolls they were, but filled with the evil will of their master: a fell race..." -- J.R.R. Tolkien on Olog-hai
    37. Re:I guess it HAS to be better to sell it by AtomicBomb · · Score: 1

      In addition to accountant, there is another type of animal known as engineer in the jungle. In more traditional sectors, e.g. civil and chemical engineering, Excel rules.

      Sometimes, Excel is used to do quick and dirty calculation (turn the cells into matrices....). Yes, it is not the most suitable tool... But, if you don't have specialist numerical package and you are *not* allowed (or able) to write program from scratch, Excel is the most powerful tool available around town (literally, if you have ever worked for chemical factory in the middle of nowhere)....

      So, it is a good news...

    38. Re:I guess it HAS to be better to sell it by Teun · · Score: 1
      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      No, we don't want nor need a database.
      I use battery powered remote data recorders, they typically record a set of probes and real time calculated results (~2-200 colums) every second.
      Once recovered we like to do a few simple (or not so simple) things with the data, all very well possible with Excel. But the present 65,000 rows allows less than a day of data.

      I'd like something that handles 2 weeks worth (1,300,000 rows), with some intelligent reduction the 1 million will do nicely!

      --
      "The likes of Facebook and WhatsApp are free to those whose privacy is of zero value."
    39. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0

      Good, yes. Useful? Not really. By the time you get to 65,000 rows you really should be using a database.

    40. Re:I guess it HAS to be better to sell it by Y0tsuya · · Score: 1
      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      Those in the scientific/engineering community could really use the larger limit. That feature is not aimed at you IT guys.

    41. Re:I guess it HAS to be better to sell it by jp10558 · · Score: 1

      I thought so. Here I was thinking ... "Wait - this isn't new, I've seen this before", and I have, in Lotus Word Pro since ~ 1996. I think in this version, Word might catch up with Word Pro 9.8. That said, I already own Word Pro 9.8, and paid the princly sum of $40 for it. If I wanted to entirely migrate to a different document format and interface, I'd use the free Open Office I think.

      --
      Opera, Proxomitron-Grypen,GPG 0x0A1C6EE3
    42. Re:I guess it HAS to be better to sell it by Angostura · · Score: 2, Interesting

      Actually I am going to disagree with you. I found the Chevron menu system execrable, I turned it off immediately, functions that Microsoft thought I might not want disappeared. It was patronising, comfusing and slowed down my work.

      However, with the ribbons (which I have not used, I'm on a Mac here) they might have got it right. Whereas the chevrons left you with a 'where have my menu items gone' feel, the contextual ribbon changes should be instantaneous, and pretty intuitive - you click on a table and instantly the table-relevant tools appear in ribbon. There is no way a user can really miss, or misunderstand what happened. Interestingly MS introduced something akin to this in Office for Mac OS X in 2001 - the formatting palette is context sensitive.

      Likewise, the format preview thing sounds eminently discoverable and understandable to me - not to mention a timesaver.

      There will be plenty of opportunities for MS to shoot itself in the usability foot, but I don't think these are them.

    43. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0

      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      Maybe. But often we do dumps of the database to .csv files, and... well... folks (non-technical type) would like to view the data... and they would like to view it in Excel.

      I'm actually surprised they put -any- limit on such things at all... why not make it unlimited rows/columns??? (or at least, limited by the amount of time/memory you're willing to give it?)

    44. Re:I guess it HAS to be better to sell it by Pyrowolf · · Score: 1

      Actually, it's 65,535 rows. The "K" has nothing to do with the translation to "k" as in kb, 640 vs 655, or whatever other voodoo you're dreaming up. Geeks a plenty 'round here.

    45. Re:I guess it HAS to be better to sell it by Kevin+Stevens · · Score: 1

      I am not a business type at all, but I bump into the 65k row limit often. We do analysis on our applications to see things like utilization %, and this is an app that is up 24 hours a day, and we want a per/second granularity in the statistics we do. 60seconds * 60minutes *24hours = 86,400 records. We get around the problem usually by just chopping off the slow early morning hours that we know aren't going to be a problem, but its a pain to work around, and as our business is becomming increasingly 24/7, those "dead hours" are becomming more dangerous to ignore. This type of stuff is throw away data, and makes no sense to put in a DB at all. We do the analysis, make sure we are meeting our internal QOS standards, and if we start exceeding them we look to add capacity. In addition, we are talking about 7 columns worth of data that we do analysis on.

      I know of many other scenarios in my group where we have lots of datapoints (1-200k+), but maybe only 3 or 4 different fields (columns) of data, which just need to be analyzed to produce a human readable representation of our system's performance. A database would never, ever, make sense to use in this scenario. It is an order of magnitude times slower to develop an app that will write to it (as opposed to a simple script that will just output a csv file), and usually an order of magnitude slower to RUN such an application.

      It is probably always going to be the case the programmers will overuse databases, while business types will always overuse spreadsheets. However, anyone that makes the blanket statement that anyone that needs a million row spreadsheet is an asshat, really needs to look into the mirror to see the asshat.

    46. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 1, Insightful

      "The problem isnt having 1 million rows available but that the current 65k row limit is not enough."

      - Agreed, especially when exporting data from a database for analysis. Sometimes the raw data provided by accounting systems far exceeds what you need.

    47. Re:I guess it HAS to be better to sell it by Blakey+Rat · · Score: 1

      Wow, you're the most negative person in computing. Not a single, "maybe once we use it, we'll see it works better than this summary makes it seem..." No, every single feature is crap! Even a feature which indisputably makes the product better (more rows in Excel) is crap because in your little world, nobody should be using more than 65k rows. (BTW, Excel is the classic example of the application that few people use for what it was original designed to be... it's used more for list-making now than anything else.)

      Anyway, how about a little bit of balance in your outlook?

    48. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0

      Accelerometry.

      At 10000 Hz, 65000 samples is less than 10 sec of data

    49. Re:I guess it HAS to be better to sell it by yagu · · Score: 1
      Anyway, how about a little bit of balance in your outlook?

      That's going to be difficult, I don't use outlook. ;-)

      After seeing all of the replies to my post, I may concede one "negative" and consider it positive: the >1,000,000 rows for Excel. I still don't want it in an IT shop when it really should be a database, but as pointed out by others, often these are outgrowths of something created outside IT purview. Is a spreadsheet ever okay with >million rows? Let the users decide, I agree, the higher limit is better.

      I stand by my original post on most other points. I'm not saying features are crap (your words), I'm pointing out Microsoft's tendency to jump back and forth, creating "improvements" which are merely different presentations. I've never been satisfied with user ergonomics in general, but I'm also not convinced (yet) the new Office addresses usability. YMMV.

      As for being "the most negative person in computing", you must not be reading a lot of /. posts... ;-)

      I have worked IT for almost thirty years, I think I've earned the right to the negativity. There are improvements over these last thirty years, but I think the biggest drag on progress over the last twenty years has been Microsoft's focus on world domination (I know, I've sat in on meetings there) and complete (almost) ignorance of real world computing needs.

      Cheers.

    50. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0
      Here's a laundry list, but I don't think the stains will come out:
      Yes, because a company that spent some serious $$$ on Office 2007 usability tests with thousands of different people of various expertise surely knows worse than a Slashdot poster. Please forsake this nickname and register yourself as HCI & Usability God.

      Of course, when OO.o duplicates the ribbon in ten years, you'll jump right up and praise them for innovation!
    51. Re:I guess it HAS to be better to sell it by IntlHarvester · · Score: 1

      My boss sent me a XLS "mockup", and I was shocked to learn that Excel contains a pretty complete paint program.

      --
      Business. Numbers. Money. People. Computer World.
    52. Re:I guess it HAS to be better to sell it by mattspammail · · Score: 2, Funny

      And the next version will have

      ** 100 BEELION ROWS **

      mwaha ha ha

      --
      Now accepting PayPal donations!
    53. Re:I guess it HAS to be better to sell it by trogdor633 · · Score: 1

      I find it hard to believe that having a programmer on hand to generate targeted reports from a database for you application monitoring, wouldn't be better then having (how many people do you need to parse through a 86,400 record spreadsheet, looking for important rows?). No, at least for your example, database would absolutly be better, no question. As far as it being throw away data, you just clear the table. Hell the database can have triggers based on the data, then you don't need anyone to parse through the doc, then it could archinve those trigger points. Dude, do you need a contract software developer? I could be available.

    54. Re:I guess it HAS to be better to sell it by Schraegstrichpunkt · · Score: 1
      Also, a lot of accountants who have very specific roles tend to use Excel as their calendar tool, as their scheduling tool, basically as their desktop.

      Sounds familiar.

    55. Re:I guess it HAS to be better to sell it by object88 · · Score: 1

      The collaboration features will be too complicated for the majority of office workers.

      Just out of curiosity, how do you know this? I haven't seen the tour referenced in the article, but I attended the Office (SharePoint) conference in Bellevue last week, and with some clever app designers, the collaboration tools could go a long way.

      No, I'm not a fan of Microsoft, but I am impressed by some of what they've got going on.

    56. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 1, Insightful

      Where is it written that large data sets should be in a database rather than a spreadsheet?

    57. Re:I guess it HAS to be better to sell it by UnderC0ver · · Score: 1

      Ditto here. I work in tech support, and was called to a desktop by a someone who said the spreadsheet on the network was "loading slowly." It took almost 8 minutes to fully open. Hmmm....says I, maybe a slow network connection? No - everthing else opens up reasonably quick from the server.

      Turns out the spreadsheet is about 40 megs, and contains (well, I forget how many rows exactly it contained) macros, tons of tabs, special formatting with BMP's embedded in the spreadsheet, and God knows what else. I mentioned that once a spreadsheet gets this large, it is always better to use Oracle, or at least Access, to address reponsiveness, as well as making the spreadsheet a tad more ready for use in a networked environment.

      He shrugged and said - "we've been using this for years, and I don't think they're going to change."

      --
      The MacSaber
    58. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0
      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.


      Well not everybody uses Excel for IT purposes. I often use it for quick plots of massive amounts of data generated in my simulations. I rarely need 10^6 rows but any improvement over the current 65k is welcome.
    59. Re:I guess it HAS to be better to sell it by iNetRunner · · Score: 1
      The listed prices range from $149 ... subtract $170 or so for the upgrade version

      Sold!

      Unfortunately for you the field was unsigned int, and you now owe $4,294,967,274!
      --
      Store with salt
    60. Re:I guess it HAS to be better to sell it by Weh · · Score: 1

      Measurement data used by engineers/scientists often has more than 65k records and it doesn't make sense to have datasets in data-bases as the data can't be moved around as easily (it's a lot easier for the average user to copy/paste an excel file from the network to his/her laptop than it is to copy from one db to another). Personally I prefer csv files to excel files but that's another topic.

    61. Re:I guess it HAS to be better to sell it by msuarezalvarez · · Score: 1

      Do you do something apart from those few things with the data? Something that would not be better done by, say, a 3 second script?

    62. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 1, Insightful

      Agreed.

      The power for me of Excel is not that it can hold that much data but that that many cells can hold equations. When testing financial models with multiple tweaks, etc. it's nice to change one input or change one step of a 10 step process in two seconds and immediately analyze the results. This isn't so easy via SQL. Especially since, if I ran a query I'd want to drop the results into Excel to analyze them anyway, so why not just start there?

    63. Re:I guess it HAS to be better to sell it by poot_rootbeer · · Score: 5, Insightful

      There's a lot of area between 65k and 1M which is handled better by a spreadsheet rather than a database.

      If the data set is better handled by a spreadsheet than a database, then it shouldn't matter how many records there are.

      Inversely, if a data set is better handled by a database than a spreadsheet, then it shouldn't matter how few records there are.

      They're different tools, and they serve different purposes. I have to wonder where this problem came from where people so often use the wrong tool for the job. Is it because Excel and Access both display data in grid format? Is it because spreadsheets made headway into personal computing space long before RDBMS's did?

      It's fine and dandy that Microsoft is re-compiling the Excel source with larger values for the MAX_ROWS and MAX_COLS constants. But there's no technical reason why such fixed limits should still even exist anymore. Can't they devise a way to allow spreadsheets to be limited in dimensions only by the available resources of the machine? Or will we have to wait and buy Office 2010 to get the ability to have 32,000 columns instead of just 16,000?

    64. Re:I guess it HAS to be better to sell it by TwelveInches · · Score: 1

      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database. No way man- Not all PC users are database eggheads. I happen to need spreadsheets that big. The fancy actuarial mathematics I use them for is so much easier on a spreadsheet and, frankly, I'd rather not add data base manipulation to my already sexually appealing list of skills- like differentiation, integration, and stochastic modelling.

    65. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0

      Why? Don't the anti-MS astroturf sponsers pay you enough?

    66. Re:I guess it HAS to be better to sell it by poolmeister · · Score: 1

      I work in a team responsible for systems, platforms, feeds & databases involved with investment management, performance measurement, securities trading etc. etc.. for an investment bank.
      If anyone was trying to handle a 65000 row spreadsheet in MS Excel, they'd deserve a kick up the arse.

      Beleive it or not financial companies have dedicated systems for reporting, analysis and all that mathematical hocus-pocus.....

      N-No, really!!

      --
      CN=poolmeister.OU=lurkers.CN=slashdot
    67. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0

      And why is the limit 65,535? When you figure that out you can turn in your geek badge.

    68. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0

      I guess none of you have ever run into the 256 column limit.

      Excel is perfect for quick scientific number crunching. SYSTAT is where its at for stats but suffered similar limitations in the last version I used.

      A lot of the time it just does not make sense to setup a database or write an application for a one time use.

      16000 columns will definitely come in handy.

      I agree that if you need a 1M rows then you should definitely consider a database or your own custom file format and application to handle it.

    69. Re:I guess it HAS to be better to sell it by shroudedmoon · · Score: 1

      Aren't you proving the GPs point, though? Why should he/she need to have (and pay for) a software developer to write a database that does nothing other than parse through throw away data. I, too, frequently come up with datasets of throw away data that are 2-3 columns * 65000+ rows. If I told my boss that I need extra time to analyze it by importing to a DB, etc, rather than pasting into excel and doing a sort, she'd laugh at me.

    70. Re:I guess it HAS to be better to sell it by vleck · · Score: 0, Redundant

      Excel 2003 only supports 65536 rows (2^16) and 256 (2^8) columns...

    71. Re:I guess it HAS to be better to sell it by vleck · · Score: 1

      Here here! The more rows the merrier. I had to learn SAS to do stuff on datasets larger than 65k or so (ok 65536). SAS is powerful, but so ugly and cumbersome (syntax wise and presentation wise). Usually you have to PROC EXPORT the results into Excel to make it pretty anyway - why not do everything in Excel!
      Now us VBA'ers can challenge the SAS programmers in doing analysis on datasets below 1 million lines. VBA/Excel is so much faster (and more presentational) than SAS in getting to the final product.

    72. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0

      What's wrong with plain Perl for this? Save your stuff to CSV, let Perl rip through it, and produce the output you need. You can even get Perl to create an Excel spreadsheet with minute or hourly summary rows, and stick an icon on the desktop to regenerate it in seconds.

      If you DID move to a database, you could easily get the output you want with only a slightly non-trivial SQL query, and it would run very fast on the server side. You could even build a view out of it, such that "SELECT * FROM QOS_ANALYSIS;" gives you the exact summary statistics you want. All through the 80's and early 90's the database vendors put very deep analysis functionality in their products, you just have to find the manual and dig into it.

    73. Re:I guess it HAS to be better to sell it by Kevin+Stevens · · Score: 1

      You are right on target, thats exactly what we use. A perl script outputs a csv file. Then an excel macro does analysis and makes pretty graphs that my boss likes. The total development and automation time took half a day at most. Your last sentence is the exact reason why we did not use the DB approach.

    74. Re:I guess it HAS to be better to sell it by Kevin+Stevens · · Score: 1

      I find it hard to believe that having a programmer on hand to generate targeted reports from a database for you application monitoring, wouldn't be better then having (how many people do you need to parse through a 86,400 record spreadsheet, looking for important rows?). No, at least for your example, database would absolutly be better, no question. As far as it being throw away data, you just clear the table. Hell the database can have triggers based on the data, then you don't need anyone to parse through the doc, then it could archinve those trigger points. Dude, do you need a contract software developer? I could be available.

      A programmer on hand to generate targeted reports? My perl +csvfile + excel macro solution does that every day and was developed in about half a day. Its fully automated, no human intervention is required. Triggers? parsing through data? This is starting to sound like a resource requiring project... Perl + regex did this all for me already. This is data gleamed from pure raw log files that aren't clean, half the time was spent figuring out the regex's to use to get the data I need. No, writing all this log output to a database is not feasible, and its also unnecessary. The log files measure GB's of data per day for some components. I think you may have missed the point of the spreadsheet, it is not for anyone to read the actual data, just as a dataset from which to use excel's analytical tools to produce data that people will actually use (IE pretty graphs, percentages, and the variance of the data).

    75. Re:I guess it HAS to be better to sell it by Toddlerbob · · Score: 2, Informative
      This is an extension of the abstration of the chevron menus... alter the user's environment based on usage. It doesn't work. I've used environments like this and it takes getting used to.

      WordPerfect has had something like this for many years. Actually only the tool bars, but not the menus, change when you change to different tasks, such as tables. Compared to the new Word, then, WordPerfect again has the best of both worlds. (And it is actually still being sold, by the way, in case anyone was wondering)

      Also WordPerfect has for many years had the automatic text preview feature for things like font changes. Once again Microsoft steals good ideas from WordPerfect (though perhaps other programs I don't know of also have this feature.)

      There are probably even more features that WordPerfect had first and better, but the ComputerWorld site is running so slow (due to Slashdotting, I presume) that I finally gave up reading the rest of the article.

    76. Re:I guess it HAS to be better to sell it by Master+of+Transhuman · · Score: 1


      Yes, it is, if you're not a moron.

      No one should ever put 65,000 rows of data in a spreadsheet. It's braindead. Anything over ten thousand is a database problem - in some cases, less than ten thousand is a database problem.

      If you need to be having multiple components on one page, use other worksheets - that's what they're for, compartmentalizing. linking and summarizing.

      People need to remember how spreadsheets were first used - with paper and pencil. Going massively beyond that metaphor is a recipe for trouble.

      The problem is that small business - and department users in larger businesses - can't get their IT people to produce databsses and reports fast enough, so they try to do mission-critical tasks with crippled tools.

      This is a recipe for future disaster, not to mention vendor lock-in.

      Stop using the wrong tools.

      If you don't have an IT department, hire a consultant to tell you how to do it right using existing tools, or if necessary, to design your applications properly.

      Granted, finding a consultant who won't take you to the cleaners or do a piss-poor job is another problem...

      I've got a client now that I'm having fun with their lame little Access database application, because as usual the person who set it up had no knowledge of relational database theory, no knowledge of an appropriate GUI interface for the end user, no automated backup/compaction/recovery options, etc., ad nauseum.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    77. Re:I guess it HAS to be better to sell it by Kaenneth · · Score: 1

      The Real Question is:

      1,000,000 rows

      or

      1,048,576 rows?

    78. Re:I guess it HAS to be better to sell it by Master+of+Transhuman · · Score: 1

      "the data can't be moved around as easily (it's a lot easier for the average user to copy/paste an excel file from the network to his/her laptop than it is to copy from one db to another)"

      Horsehockey. The only reason that is even remotely true is that the end user learned Excel instead of a database because MOST of his work CAN be done in a spreadsheet.

      It also means their IT department, if they have one at all, is not training anybody OR automating the end user environment the way they should be.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    79. Re:I guess it HAS to be better to sell it by JDAustin · · Score: 1

      So, If I have a 100k line log file to parse out I should be expected to create a DB, write an import script, write script to read through each line and then only export the relevant data?

      Ok, whos going to pay for this?

      Especially when I can do it 5 times faster in excel?

      BTW, I'm very well knowledge on relational database design (as I do SQL programming on a daily basis). But I also understand that a database is not a sledgehammer for every task you want to do.

      Sometimes it is just faster and cheaper to do it in excel.

    80. Re:I guess it HAS to be better to sell it by Master+of+Transhuman · · Score: 1


      Heh, heh, at which point I would have said, "Well, you for one should welcome your eight-minute-opening spreadsheet overlords!"

      Working with idiots is never a pleasure.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    81. Re:I guess it HAS to be better to sell it by Master+of+Transhuman · · Score: 1

      "A lot of the time it just does not make sense to setup a database or write an application for a one time use."

      Except it never turns out to be "one time". That's the excuse. It always turns out to be annually, then monthly, then weekly, then daily, then hourly - but the system never changes.

      The first time the boss says it's "one time". The next time, it's "remember that one time thing? Well...we gotta do it again." The third time, he's "aren't we doing this...?"

      If you do something more than TWICE, automate it - because if you do it more than twice, you're going to do it forever.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    82. Re:I guess it HAS to be better to sell it by Master+of+Transhuman · · Score: 1

      "They wouldn't be doing this if they didn't think it was worth it."

      MOD THIS POST "+5 FUNNY"!!!

      "Worth it" to Bill Gates means more pointless features to fool the customer into giving him their money...

      It's that simple.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    83. Re:I guess it HAS to be better to sell it by colinrichardday · · Score: 1

      And just what are you looking for? Awk and grep my not be as polished, but what is Excel giving you for the price?

    84. Re:I guess it HAS to be better to sell it by colinrichardday · · Score: 1

      Or I will flood Redmond with red hot MAGMA!

    85. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0
      Except it never turns out to be "one time". That's the excuse. It always turns out to be annually, then monthly, then weekly, then daily, then hourly - but the system never changes.

      Obviously you've never worked in scientific research.

      P.S. Does anybody else find this absolutely fucking ridiculous?:

      Slow Down Cowboy!

      Slashdot requires you to wait between each successful posting of a comment to allow everyone a fair chance at posting a comment.

      It's been 10 minutes since you last successfully posted a comment


      10 fucking minutes! I gave up and renewed my IP address to post this comment. Sheesh.
    86. Re:I guess it HAS to be better to sell it by GaryPatterson · · Score: 1

      WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      You're probably right - if anyone in *IT* puts a million rows of data into a spreadsheet they're probably better off with a database. The only spreadsheets I've ever seen the IT department use are lists.

      Some people, like myself, occasionally need a few hundred thousand rows of data for complex calculations, something databases are generally weak at (certainly any SQL-based ones).

      Want to calculate percentiles over a database in SQL? Want to use data between multiple rows without linking a table to itself? Want a running total or cumulative average?

      Databases are great for queries, but awful for calculations.
      Spreadsheets are great for calculations but awful for queries.

      The solution isn't based on the number of rows, but on the purpose of the data and how you're going to use it.

      I don't work in IT, but I do manage a *lot* of data.

    87. Re:I guess it HAS to be better to sell it by DrEasy · · Score: 1
      It's fine and dandy that Microsoft is re-compiling the Excel source with larger values for the MAX_ROWS and MAX_COLS constants. But there's no technical reason why such fixed limits should still even exist anymore. Can't they devise a way to allow spreadsheets to be limited in dimensions only by the available resources of the machine? Or will we have to wait and buy Office 2010 to get the ability to have 32,000 columns instead of just 16,000?
      I guess they wouldn't want files created given one machine's resources to be unpredictably unopenable on another machine. With a fixed value they can specify the minimum resource requirements for installing Excel that guarantee any file to be usable anywhere.
      --
      "In our tactical decisions, we are operating contrary to our strategic interest."
    88. Re:I guess it HAS to be better to sell it by Knutsi · · Score: 1

      Working in a research institute with loads of quantifiers, I've also seen this happen every now and then with researchers and their datasets or other lists. Especially students, as none tells them Excel has limitations in information amounts.

      Maybe the problem simply is that Excel does't come with a big red sticker on its box that warns of this.

    89. Re:I guess it HAS to be better to sell it by jimmypw · · Score: 1

      # Excel 2007 now supports over 1 million rows and over 16,000 columns per worksheet. WTF? If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.

      I see your angle but do you think it's practicle or even possible to do accounting in a raw database?

    90. Re:I guess it HAS to be better to sell it by 16K+Ram+Pack · · Score: 1
      1 million rows?

      Great. Even more users have a reason for thinking they can create their own little unstructured spreadsheets residing on their machines, with no backups. Which later can't be used for things like statistical analysis, because there's 101 ways of saying "Account Closed" instead of it being defined and validated data.

      Spreadsheets were originally about financial analysis. That people could run projections and the like. And they serve that purpose well. Otherwise, there's this thing called a database.

    91. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0

      Dude! You should've told them that you never use the network for such stuff - what's that shiny-new billion-dollar color laser printer at a blazing 100 sheets a second for? :P

      To confirm you're not a script,
      please type the word in this image: melted

      Appropriate???

    92. Re:I guess it HAS to be better to sell it by 16K+Ram+Pack · · Score: 1
      Personally, for quick and dirty databases, I use MS Access. It's not fantastic, but it gives you a proper relational database, and is far superior to Excel for complex querying.

      Using Excel for a database is moronic.

    93. Re:I guess it HAS to be better to sell it by Daltorak · · Score: 1

      It's a lot harder than a "re-compiling with larger values". The "OLE container"-based Excel file format (XLS) stores row numbers in a two-byte field, thus creating a hard limitation of 65,536 possible values. In-memory representations of large spreadsheets are easy, of course, but you do have to be able to save these files... that's why Excel 2007 has an entirely new XML-based file format (XLSX), so they don't get stuck in this kind of situation again.

      To see what I mean about this limitation (and others) with the binary-based format, you can read the Excel file format specification that the OpenOffice folks published. It's here: http://sc.openoffice.org/excelfileformat.pdf

    94. Re:I guess it HAS to be better to sell it by Anonymous Coward · · Score: 0

      10 print "laugh"
      20 goto 10

    95. Re:I guess it HAS to be better to sell it by jabelson · · Score: 0

      Switching to OO is fine if you're not exchanging work with others - I installed it for my wife, who emailed out a bunch opf stuff to various clients and so forth - she got back quite a few responses asking for documents that opened properly from Word with the proper formatting. Proceed with care - and if your livlihood depends on document exchange, shell out the bucks for the industry standard...

    96. Re:I guess it HAS to be better to sell it by Teun · · Score: 1

      We're mainly interested in some pre-processing and graphical presentation for some quick and dirty quality control and low-level analysis. The real stuff is done in dedicated proprietary and very expensive software that's only available to a few.

      --
      "The likes of Facebook and WhatsApp are free to those whose privacy is of zero value."
  3. No one cares. by Anonymous Coward · · Score: 0, Insightful

    Really.

  4. million-row spreadsheets by bryan_is_a_kfo · · Score: 5, Insightful

    if your data set is a million rows, you probably want to consider using something other than spreadsheets. I'm fond of the current limit on excel, it forces analysts to think about their tool selection sometimes.

    1. Re:million-row spreadsheets by poopie · · Score: 1

      I'm guessing that they plan to use sharepoint server with a database backend and ODBC on the users' spreadsheets to allow users to treat databases as spreadsheets. Spreadsheets really are an intuitive inteface for updating data. Distributed storage of critical data is the dumb thing.

      But... we all know that what is going to end up happening is that .xls files will grow from 400mb to 45gb with embedded videos, dynamically updated rss tickers inside of cells, and a million rows of junk formatting with different background colors, fonts, outlining, and custom ribbon menus.

    2. Re:million-row spreadsheets by Neil+Blender · · Score: 1

      I am routinely foiled by 00s 32,000 limit and my version of excel's 64,000 row limit. In bioinformatics, I frequently see files that exceed 64,000 rows. For any real analysis, of course you use other tools but you need spreadsheets if you want to quickly look at a large tab delimited text file to see what's what. I look forward to the increase and hope the OO people will at least go to 128K.

    3. Re:million-row spreadsheets by bryan_is_a_kfo · · Score: 1

      no matter what arbitrary limit is set, someone is going to hit the boundry and be upset because they could use "just a little more". I hate recommending the use of something like Microsoft Access, but it's hard for me to imagine Excels interface actually help you accomplish much with tens of thousands of rows of data - that couldn't be accomplished much easier with a query tool. Of course if the tool works for you, then keep on rockin' it. Inspecting big delimited text files is ridiculously easy in a tool like Access if you've never tried it, just fyi.

    4. Re:million-row spreadsheets by Biff+Stu · · Score: 1

      How about data analysis software geared for scientists such as Matlab or my favorite, Igor Pro?

    5. Re:million-row spreadsheets by bryan_is_a_kfo · · Score: 2, Funny

      I think you just described a new circle of hell, I could hear faint shrieking in my head as I read that.

      Do you have any kind of basis for the distributed data assumption? That doesn't seem like an easy feature to sell to consumers, let alone the MS developers who would have to implement it...

    6. Re:million-row spreadsheets by Anonymous Coward · · Score: 1

      I guess you've never used a spreadsheet, know what it's used for, or understand that it's far more flexible and easier to put together than a custom app with SQL.

      People who don't use Excel in real-life situations love to parrot these brainless "if you need that many rows get a DB" responses.

    7. Re:million-row spreadsheets by bryan_is_a_kfo · · Score: 1

      I work with both databases and spreadsheets to pay the bills. They serve very different purposes, I dont have much to say other than what a friend once told me in the early days of my developer when all I knew was perl on Linux

      "When all you have is a hammer, everything looks like a nail."

      If you're dealing with sizeable datasets on a regular basis, it helps to know the tools that were designed to handle them.

    8. Re:million-row spreadsheets by ElleyKitten · · Score: 1

      I guess you've never used a spreadsheet, know what it's used for, or understand that it's far more flexible and easier to put together than a custom app with SQL.

      If you're using Excel, chances are the first thing you think of when you hear "database" is not "make a custom app with SQL".

      I use Access and Excel everyday at work, and I couldn't imagine working with the huge tables we have in Access in just Excel. The data is just too much to comprehend all at once, but with Access you can chop down the data with queries and other tools to see exactly what you want (and then export that to Excel, to show everyone else). While you can do some of the same things in Excel, it's much faster and simplier just to do it in Access.

      People who don't use Excel in real-life situations love to parrot these brainless "if you need that many rows get a DB" responses.

      Maybe you don't use a DB in real-life situations and so you don't know how powerful it can be?

      --
      "What is Internet Explorer 7? Are you saying we can't access the normal internet?" - I love tech support. Really.
    9. Re:million-row spreadsheets by syphax · · Score: 1


      It's the 256 column limit that's a bitch. Fairly often, I have datasets that are 200-500 rows x 200-500 columns or so. These are datasets for which a spreadsheet is the right tool, provided that I could frickin' shoehorn them into one worksheet.

      Also, I find that there are rare occasions when Excel *is* the right tool for datasets with ~100,000 rows (much more than that, I agree, run away).

      --
      Simple Unexpected Concrete Credible Emotional Stories
    10. Re:million-row spreadsheets by cyber-vandal · · Score: 1

      Can't you do that already? I'm sure in one of the millions of menus I saw something about pointing to a DB. In any case you can, provided the .xls is simple, use Excel as a simple DB, it's very handy for data-driven VBA/VBScript where having to start Excel to access the data would be ridiculously CPU-intensive.

    11. Re:million-row spreadsheets by 1000101 · · Score: 4, Informative
      The company I work for develops and sells a database reporting tool. This tool allows the user to build reports in .pdf or .xls format. When using Excel, the user can build any design they want using macros, formatting, etc. All of the 'data' is stored in seperate sections and the main output is a clean, functional, interactive report with all of Excel's bells and whistles. Our software puts no limitation on a date range that a user runs a report against. So, if a user has a *large* database (SQL or ORACLE) and runs a report for a large time span, a million rows could theoretically be used. The end report result could just be a summary of the data, but the supporting data set could easily have hundreds of thousands of rows. We use a database to store the client's data but the report queries this data and dumps the result set to the Excel spreadsheet.

      My point is that not everyone uses Excel as a database and this is a welcome change for us.

    12. Re:million-row spreadsheets by Red+Flayer · · Score: 1

      "Spreadsheets really are an intuitive inteface for updating data. Distributed storage of critical data is the dumb thing."

      Already happening. Witness newest versions of Best MAS90/200 -- they tout their 'grid entry' for accelerated data entry of source documents.

      Form entry is still much better for data entry, though. Really cuts down on mistakes (and their impact!) as users can only affect one record at a time.

      I regularly used Crystal Reports to embed data in Excel spreadsheets from our central ODBC database for reports. Ugly, yes. Awkward, yes. Adhering to company policies on application use? Yes.

      --
      "Trolls they were, but filled with the evil will of their master: a fell race..." -- J.R.R. Tolkien on Olog-hai
    13. Re:million-row spreadsheets by bryan_is_a_kfo · · Score: 1

      Wow, generally what kind of dataset has 500 columns? Cant that be denormalized in any way? Do you seriously scan through a list of 500 elements to pick which columns you're interested in at any given point in time? I've worked with a few 500 column oracle tables, but they were the result of poor design without any rational scalability.

    14. Re:million-row spreadsheets by spectecjr · · Score: 1

      Wow, generally what kind of dataset has 500 columns? Cant that be denormalized in any way? Do you seriously scan through a list of 500 elements to pick which columns you're interested in at any given point in time? I've worked with a few 500 column oracle tables, but they were the result of poor design without any rational scalability.

      Try the output from a prototype CCD array. Typically, that's 1024 columns of data - or more.

      --
      Coming soon - pyrogyra
    15. Re:million-row spreadsheets by bryan_is_a_kfo · · Score: 2, Insightful

      I appreciate that this response made me think about a fundamental difference between spreadsheets and databases.

      A spreadsheet is a matrix of cells which can refer to any data or formula in any other cell arbitrarily (ot it can contain static data itself...). A dataset in a flat file or a database is an array of typed (all text if flatfile) columns that can either contain data (such as reference data to other columns, etc...). The overhead required to enable arbitrary cell references from any atom in a dataset is too much for large data sets. This definition of large is different for everyone of course, but in a 1,000,000 row dataset the need for arbitrary cell referencing is 99.999% of the time : overkill.

    16. Re:million-row spreadsheets by bryan_is_a_kfo · · Score: 1

      that's a good point, being able to arrange test output in a cell structure much like a spreadsheet would absolutely be useful for smoke testing there.

    17. Re:million-row spreadsheets by revlayle · · Score: 1

      Wow, you think non-developers or non-IT types can DO or even want to MESS with de-normalization? Not the most easy task for the average "office" user to do with an already large, pre-existing dataset.

    18. Re:million-row spreadsheets by bryan_is_a_kfo · · Score: 1

      most likely not. I try to put myself a few years back in my head though, and I think if I had encountered a 500 column dataset before I knew anything about data architecture it only would have accelerated my desire to learn.

    19. Re:million-row spreadsheets by syphax · · Score: 1


      A list of 500 entities with 250+ performance measurements and derived metrics. No. Yes, they have names.

      --
      Simple Unexpected Concrete Credible Emotional Stories
    20. Re:million-row spreadsheets by bryan_is_a_kfo · · Score: 1

      I would be really suprised if you couldn't model that data to be scalable with rows instead of columns. That's not to say I haven't been suprised before :)

    21. Re:million-row spreadsheets by Blakey+Rat · · Score: 1

      Removing limitations in software is always good, regardless of how the anti-Microsoft crowd likes to spin it. If this was Firefox increasing the maximum number of bookmarks from 255 to 65k, this same community would be cheering it on.

    22. Re:million-row spreadsheets by bryan_is_a_kfo · · Score: 1

      There's some truth to that, but as a daily professional spreadsheet and database user I dont believe it's in hardly anyone's best interest to increase the (already giant) possible size of the most commonly used spreadsheet. I'd argue that 99.999% of the time the only thing this upgrade is going to do is increase excels capacity for abuse. Excel sheets are an extremely high-overhead storage method for matrixes of data that simply dont need the functions that excel provides for that cost.

    23. Re:million-row spreadsheets by Anonymous Coward · · Score: 0

      So you're suggesting that when your dataset becomes too big for Excel, you should just spend $500+ and learn a new tool (which may not even have the features you need)?

      dom

    24. Re:million-row spreadsheets by syphax · · Score: 1


      Oh, I *could* normalize it and reduce it to 3 columns: Name of entity, name of measure, value. But that would be utterly useless for my needs, and a total PITA to handle. And yes, I could take that structure and make a cross-table in Access or whatever, but then I still need to do some analyses and dynamic what-ifs on the resulting table that are at best quite cumbersome to implement in Access or an equivalent, but are a snap in Excel.

      --
      Simple Unexpected Concrete Credible Emotional Stories
    25. Re:million-row spreadsheets by nukular · · Score: 1

      I can say that where I work (economic legal consulting) we OFTEN get data that comes in too big for Excel, but we have many many people that use Excel as their main data analysis tool... Usually we have to get somebody (such as me) who programs in SAS who can import the raw comma-delimited data to Access..so anybody can do anything with it...usually still breaking it down to an Excel level... Or we need people to program to break out chunks for people to work with in Excel. All this HOURLY billing occurs because of the rather pathetic limit of 65K rows that Excel has had for far too long.

    26. Re:million-row spreadsheets by Anonymous Coward · · Score: 0

      "I'm fond of the current limit on excel, it forces analysts to think about their tool selection sometimes."

      And since you're in the tool selection business having the analysts think about it adds money to the bottom line that you don't get when they just crunch the numbers in excel.

    27. Re:million-row spreadsheets by dodobh · · Score: 1

      Sometimes, just sometimes, a spreadsheet is the right tool for the job. A spreadsheet is a good analysis tool, it is not a database.

      --
      I can throw myself at the ground, and miss.
    28. Re:million-row spreadsheets by Anonymous Coward · · Score: 0

      So you're suggesting that when your dataset becomes too big for Excel, you should just spend $500+ and learn a new tool (which may not even have the features you need)?

      No, you spend at most $50 on a SQL book and use the free database servers out there to learn what you need to do your effin' job. The tools were out there (and free, and had reasonable introductory documentation) ten years ago. Where have you been?

    29. Re:million-row spreadsheets by Anonymous Coward · · Score: 0

      Or, you could use a database reporting tool that doesn't rely on excel to do the heavy lifting for it.

    30. Re:million-row spreadsheets by aug24 · · Score: 1
      Quoth the gp:

      I'm fond of the current limit on excel, it forces analysts to think about their tool selection sometimes.

      Which in answer to you, I would change to:

      I'm fond of the current limit on excel, it forces users to think about their data needs sometimes.

      No-one, but no-one, needs a million lines of detail. They will not read them. They need to find a better way of reporting if they are generating this much data.

      Justin.

      --
      You're only jealous cos the little penguins are talking to me.
    31. Re:million-row spreadsheets by Chelloveck · · Score: 1
      No-one, but no-one, needs a million lines of detail. They will not read them. They need to find a better way of reporting if they are generating this much data.

      Spreadsheets are used for more than just financial data, you know. Nor are they necessarily intended to be read line-by-line. As I was mentioning here the other day, I've routinely hit the current limit of rows when importing data from digital scopes or logic analyzers. No, I don't intend to look at each and every value, but Excel's graphing tools are adequate to produce a nice view of a waveform, fit a trend curve to it, and forecast behavior outside of the sample range. There may be better tools, but Excel is convenient and adequate for a lot of jobs. The ability to handle more data is a good thing.

      --
      Chelloveck
      I give up on debugging. From now on, SIGSEGV is a feature.
    32. Re:million-row spreadsheets by aug24 · · Score: 1

      I very much doubt you ever need a million points to do that... I suspect that if you are ever used more than the current 65k then you would just be wasting your own time waiting for the graph to be generated!

      Justin.

      --
      You're only jealous cos the little penguins are talking to me.
  5. All You Need To Know: by thatguywhoiam · · Score: 3, Interesting

    "Ribbons" = "Tabs"

    --
    If Jesus wants me it knows where to find me.
    1. Re:All You Need To Know: by GeckoX · · Score: 1

      No, they aren't actually, making them potentially more problematic since there is a now proven likelihood that people will confuse the two.

      --
      No Comment.
  6. try it for yourself... by theheff · · Score: 4, Informative

    The public beta 2 is actually availableto the public today.

    1. Re:try it for yourself... by Anonymous Coward · · Score: 0

      Looks like their server is having problems (site responds alright, however the download page times out), must be running on Windows...

    2. Re:try it for yourself... by ElleyKitten · · Score: 4, Funny

      The public beta 2 is actually availableto the public today.

      Well, it was available, until you told slashdot...

      --
      "What is Internet Explorer 7? Are you saying we can't access the normal internet?" - I love tech support. Really.
    3. Re:try it for yourself... by wbren · · Score: 2, Funny

      I downloaded my preview weeks ago from this website.

      --
      -William Brendel
    4. Re:try it for yourself... by rduke15 · · Score: 2, Funny

      They don't seem to have the Beta 2, but I noticed on left side of the screen a few gorgeous women who just happen to live in my area! I'm off to get in touch with them... They look much better than some unfinished computer program.

    5. Re:try it for yourself... by moonbender · · Score: 1

      You must live in the same area as I do! What a small world!

      --
      Switch back to Slashdot's D1 system.
    6. Re:try it for yourself... by LifesABeach · · Score: 1

      How do you down load it? I've tried:

              apt-get install officeBeta2007

              apt-get install microsoftOfficeBeta2007

              apt-get install office2007

      WTF?! It doesn't install properly.

    7. Re:try it for yourself... by Anonymous Coward · · Score: 0

      If you have any trouble with downloading our Beta 2 right now, please follow this instructions:

      1. On the Outlook 2007 Edit ribbon, click Search.
      2. In the Search subribbon, select Usenet as the Field of Interest.
      3. In the Search Usenet dialog, type microsoft office 2007 beta 2.nzb and click Search.
      4. In the Usenet Search Results dialog, select microsoft office 2007 beta 2.nzb in the alt.binaries.x group.
      5. Click Download and Install.
      6. Select Start, Programs, Microsoft Office and choose the appropriate Product.

      --
      Anonymous Coward
      Microsoft MVP
      Windows Vista - User Experience
      Microsoft Newsgroups

  7. Ribbons! by Whiney+Mac+Fanboy · · Score: 0, Flamebait
    They sound revolutionary:
    For example, the Home ribbon in Word offers shortcuts for the clipboard (cut, copy, paste) and font formatting (font and font size, underlines and superscripts and so on) -- the kind of everyday tasks most of us use in Word.
    *snort*

    Seriously - MS, openoffice is carving away the "Office 97 provides all our needs" segment & the collaboration market you're so eagerly chasing is... well lets say I don't think its got the potential you think it does.

    I have a request tho' - I'd like the click+scrolly wheel zooms in a different direction for word & ie bug fixed. Please?
    --
    There are shills on slashdot. Apparently, I'm one of them.
    1. Re:Ribbons! by CyberSlugGump · · Score: 2, Funny


      Ctrl+scrollUp in Internet Explorer 7 beta now matches the behavior in Office 2003 (zoom in). Let's just hope that someone didn't "fix" Office 2007 to match IE 6....

    2. Re:Ribbons! by WarForge · · Score: 1

      I have a request tho' - I'd like the click+scrolly wheel zooms in a different direction for word & ie bug fixed. Please?

      If you were using Firefox like a proper /.'er, then your ctrl+scrlUp in your browser would be the same as Office.

      But more seriously, this has been fixed in IE7b2 with ctrl+scrlUP zooming into the document just like Word (2003 at least).

      --SqrlMasta

    3. Re:Ribbons! by pintpusher · · Score: 1

      Word offers shortcuts for the clipboard (cut, copy, paste)

      how exactly is a widget on a ribbontab thingy a shortcut? This is stupid writing at best. First thing I saw in the article and I had to dump it. What happened to Ctrl-[x|c|v]? those are shortcuts.

      --
      man, I feel like mold.
    4. Re:Ribbons! by Blakey+Rat · · Score: 1

      What collaboration features does OpenOffice offer? Last I checked it, 1.1.2 I think, it was far behind Microsoft Office in change tracking.

    5. Re:Ribbons! by Whiney+Mac+Fanboy · · Score: 1

      If you were using Firefox like a proper /.'er, then your ctrl+scrlUp in your browser would be the same as Office

      If you were using Firefox like a proper /.'er, then you'd know the ctr+scrl behaviour is the same in IE & firefox ;-)

      Seriously, I was hoping they'd fix office to match the rest of the universe, rather then breaking IE....

      --
      There are shills on slashdot. Apparently, I'm one of them.
    6. Re:Ribbons! by Whiney+Mac+Fanboy · · Score: 1

      What collaboration features does OpenOffice offer?

      No idea - my point was the collaboration market was smaller then MS thinks & OO is starting to make ground on the "I just want a basic Word Processor" market.

      --
      There are shills on slashdot. Apparently, I'm one of them.
  8. article is.... by Dance_Dance_Karnov · · Score: 1

    spread out over seven pages. Why don't we get a warning for that in the summary, like we do with sites that require registration? like "SITE.COM[in desperate need of increased pageviews]"

    1. Re:article is.... by frostfreek · · Score: 1

      No kidding.
      Every page is 90% ads and crap, with the text in a teeny little column.
      The animated ads were too distracting to bother reading past 2 or 3 pages.

    2. Re:article is.... by Eideewt · · Score: 1

      It would be nice if people would check for a link to an all-on-one-page printer friendly version and include that too when they submit articles to Slashdot. Not because I want to print it, but because I don't want to click through to read the whole thing.

  9. Argh... by avalys · · Score: 1

    This is going to confuse every single non-technical user on the planet, while benefiting pretty much no one. I can hear the questions now: "Where did they put the File menu?"

    --
    This space intentionally left blank.
    1. Re:Argh... by FyRE666 · · Score: 1

      You're right - I'm a programmer and I hate having to use Word for documentation. I use it so seldom that it takes me all bloody day to get a decent layout.

      I've found a workaround though, I just create an HTML page with some CSS, and put my documentation in that, then save it and open it in Word to save it again (making it about 10 times the size) - works great and the docs look nice without me having to fight with 10,000 menus that seem to have different bloody options every time I open them!

    2. Re:Argh... by Bing+Tsher+E · · Score: 1

      It does sound like a nightmare. Where are the keyboard shortcuts if there isn't a menu on top?

      I run Excel mostly without using the mouse at all. People who mope around with a mouse pointer remind me of the kid who pushed the peas around on his dinner plate.

      I've heard it said that at one top accounting firm, they 'test' new hires by requiring them to run Excel without a mouse for a short period when first hired.

      This 'ribbon' thing sounds like negative evolution.

    3. Re:Argh... by Anonymous Coward · · Score: 0

      The ribbons have shortcuts too. If you hold down Alt it pops up tooltip-like things with the magic key for each tab, and once you select a tab it shows the shortcut keys for options within.

      For example, to insert an unordered list, Alt+HU (activates Home tab, selects Unordered lists). This actually drops down the list of bullet types (circles, squares, ponies, etc.) which you can select with the arrow keys or tab + enter.

  10. 1 million row spreadsheets? by LordKazan · · Score: 1, Flamebait

    Bigger spreadsheets are available in Excel -- over 1 million rows and over 16,000 columns per worksheet

    what kind of a jackass ....? use a fucking relational database! I don't want to think how blazingly slow that big of a spreadsheet would be, not to mention any dataset that large is going to almost certainly be something that is supposed to be used by more than one person at a time

    --
    If you cannot keep politics out of your moderation remove yourself from the Mod Lottery.. NOW!
    1. Re:1 million row spreadsheets? by Anonymous Coward · · Score: 0

      Uhh..no. Get a clue. I've been waiting for a larger spreadsheet for a while. I don't want to have to teach my collegues to use a db when all they want to do is =A1*B1 down a column. We have datasets closing in on 100k rows but all we do with it is reduce it down to a report friendly format. So basically once and done with it. I don't want to use a db for that. Don't be close minded on the tools availiable to you.

    2. Re:1 million row spreadsheets? by oldwarrior · · Score: 1, Informative

      I'm one of those J-A's Thank You Kindly. Data analysis in memory and the ability to chart interactively is the reason for this feature. If I have the GHZ, cpu's, and the RAM, I do not want no stinkin' SQL crawler to beat my hard drives to sift through relational cruft if I can have my data right there in memory where I need it. Tables are for payroll records - my statistics (probed network data and FFT sensor inputs) are simple but numerous and the old limits meant having to right C++ code to crunch and graph/chart this in real time.

      --
      If it were done when 'tis done, then t'were well it were done quickly... MacBeth
    3. Re:1 million row spreadsheets? by GeckoX · · Score: 2, Insightful

      That's fine, as long as you realize you're using a hack...you are absolutely NOT using the 'correct' tool for the job here.

      It may work, and it may be done a lot, but there are actual tools for doing this sort of thing.

      Part of the problem though is that a lot of people believe that every tool available for use on a computer is to be found in MS Office, somewhere. It's not.

      To prove this, here's a thought excercise for you: Given the raw data you're crunching in excel briefly...describe how you would come to the same end result WITHOUT A COMPUTER. Would you pull out a ledger? Didn't think so. It's the wrong tool for the job.

      Now, what people should keep in mind though, is it isn't _always_ wrong to use the wrong tool for the job. Sometimes the wrong tool works good enough or the right tool is too expensive or complicated or limited in it's availability for use. It's just usually wise to know when this is the case however and not start believing you are using the 'right' tool when you aren't.

      The problem is, MS knows this very VERY well. Thus, MS Office products are chock full of every conceivable 'feature', hoping that you'll find a way to do what you need to do somewhere in there without going to someone elses software...damned if it's the right tool or not.

      --
      No Comment.
    4. Re:1 million row spreadsheets? by cyngus · · Score: 1

      You'd be surprised what Excel is used for. I know for a fact that a certain very large insurance company relies on Excel sheets and macros for some of its policy price calculation tools. I'm not saying its right, I was shocked as well, but the fact is that almost everyone knows how to use Excel and the knowledge required to move a macro-based Excel application to even use Access is large (and Access is nearly useless on 1M rows).
      One point that is missed here is that the previous limit (65K rows) was ludicriously small for a dataset by today's standards.

    5. Re:1 million row spreadsheets? by babbling · · Score: 1

      Office workers don't know about databases, and I very much doubt any of them want to know about databases.

    6. Re:1 million row spreadsheets? by Rude+Turnip · · Score: 1

      There's a lot of people on /. getting off and feeling high and mighty by recommending the use of databases for damn near anything involving numbers. I have the (mis)fortune of working with large datasets sometimes for financial analysis. Hundreds of Excel tabs...hundreds of small companies under one umbrella. The fact of the matter is that despite the great quantity of data, I don't always need the complexities of a database app. The data is going to be swirled around and looked at from many different angles. If anything needs to be aggregated or searched, there are incredibly simple formulas that can be used.

    7. Re:1 million row spreadsheets? by Itninja · · Score: 1

      I had a customer that used Excel to create a timeline for a major construction project. Nothing but dates and timelines. I told that was what MS Project was for, but he was happy with Excel. All 64,000 rows of it.

      --
      I judt got a nre Kinesis keybiartf so please excusr ant egregiou typos.
    8. Re:1 million row spreadsheets? by LordKazan · · Score: 1

      People could nagivate a php-generated website controlling/accessing a relational database even easier :D

      that being said i once heard of a bank that used multi-gigabyte .mdb's for EVERYTHING.

      --
      If you cannot keep politics out of your moderation remove yourself from the Mod Lottery.. NOW!
    9. Re:1 million row spreadsheets? by LordKazan · · Score: 1

      given the table

      create table `sometable`
      {
      `ColA` int(10) unsigned,
      `ColB` int(10) unsigned,
      }

      all you have to do is
      SELECT `ColA`*`ColB` as AB FROM `sometable`

      I'm not being "closed minded" - i'm dismissing the WRONG TOOL for the job because it's a piece of shit and highly prone to error, can only be used by a single user at a time, etc.

      Who the fark said it had to be a RAW DATABASE?! Ever heard of Database manipulation softwarwe? display software? the software exists for you to use the system with much more ease than you use it already - you just have been too lazy to go and figure that out

      --
      If you cannot keep politics out of your moderation remove yourself from the Mod Lottery.. NOW!
    10. Re:1 million row spreadsheets? by arivanov · · Score: 1

      Stroll around the S&M and business development department in 99% of the companies out there, multibillion PLCs notwithstanding. Find a relational database being used for any "business modelling" and "forecasting" (quotes intentional). You will not find any. It is all excel and some of the excel abuse in these circles will scare the shit out of any IT professional.

      On top of that none of these MBA tagged excel jokeys has the faintest clue regarding software quality assurance and testing of their creations. This does not prevent them from forcing business decisions worth millions and often billons based on a "business model" which is nothing but a buggy excel spreadsheet.

      This is a segment of the market which Microsoft has managed to capture and is keeping captive to ensure that any other parts of the business will not drag anything non-Microsofty.

      It is not surprising that it is trying to keep it and roll back any of the wins achieved by Cristal and Oracle in this area. Not surprising at all.

      --
      Baker's Law: Misery no longer loves company. Nowadays it insists on it
      http://www.sigsegv.cx/
    11. Re:1 million row spreadsheets? by Anonymous Coward · · Score: 0

      That's because Project sucks for everything except generating ghant charts.

    12. Re:1 million row spreadsheets? by LiquidCoooled · · Score: 1

      Hang on, your query will return no records.

      With the excel version you just double click on the CSV file and put a formula in column C.
      If theres another type of dataset, you just rinse/repeat.

      Need to show a graph? no problem.
      Sum those fields? done.
      Arrange them? ok
      Merge with that one? alright
      Save them in this format? ok
      email the results? yer ok

      I realise using Excel might be a hack, but its a damn sight better than your inflexible solution.

      --
      liqbase :: faster than paper
    13. Re:1 million row spreadsheets? by LordKazan · · Score: 1

      how is my solution inflexible because you're too lazy to familiarize yourself with programs that will do all those things you want right there via a GUI for you using a relational database to store the data?

      --
      If you cannot keep politics out of your moderation remove yourself from the Mod Lottery.. NOW!
    14. Re:1 million row spreadsheets? by LiquidCoooled · · Score: 1

      If the results were needed on a regular basis then I would agree with you, but for sheer speed and flexibility you honestly cannot beat excel.

      If I had to sit down for even 15 minutes writing an import for whichever data* I have been asked to process then its a waste, because in that 15 minutes I have gotten the answers to the direct question asked.

      I'm certainly not going to go to the hassle of setting up a database structure and importing the fields and designing an output query just so I can find whatever I've been asked (trends, totals, graphs etc).

      The job is usually a throwaway and I'll be damned if I'm going to waste my life fucking around with things for a one off.
      There are times however that I see multiple files in the same format (from the same customer) or require more advanced processing work, this is where the database solution comes in.

      *which can come from anywhere, anytime and (now) almost any size

      --
      liqbase :: faster than paper
    15. Re:1 million row spreadsheets? by ClosedSource · · Score: 1

      "That's fine, as long as you realize you're using a hack...you are absolutely NOT using the 'correct' tool for the job here."

      Well, at least you put the word "correct" in quotes. Internet applications like Slashdot are a hack too but it doesn't stop you from using it.

    16. Re:1 million row spreadsheets? by ClosedSource · · Score: 1

      The purpose of computers is to satisfy lazy people. Non-lazy people just perform the work with pencil and paper.

    17. Re:1 million row spreadsheets? by cr0sh · · Score: 1
      A one-off, done by a single person, is one thing - the real problem comes when you have multiple people all mucking about with the data, which is what you generally see in most businesses.

      It starts out with a simple Excel "data model" somebody does, replete with formulas and macros to make things "fun" - to allow you to try out all sorts of scenarios. Then, the inevitable happens:

      The spreadsheet gets emailed...

      Between people, between departments - multiple people play with it, save it to their local hard drive, copies end up on the network file server(s), and it is emailed some more. Maybe a few sneakernet transfers are made via thumbdrive or CD-R - who knows, who cares? Nobody! Multiple people play with it - some even change the formulas just slightly before passing it on. It is saved some more, passed some more, modified some more...

      Then the "big day" comes - decisions are made by people, each with their own version of the spreadsheet. Which is "final version"? Which is the most realistic portrayal for the model? Which is the latest? Nobody knows! Worse, nobody cares! Descisions get made...

      The meeting happens, and they all pull out their copy of the sheets - whoops! Nothing matches up with anyone else's copy! What is going on!? Panic? What decisions have been made? What promises must now be kept? Who should be fired?

      Most likely, the guy who originally modelled it - how could it be anyone else's fault...?

      --
      Reason is the Path to God - Anon
    18. Re:1 million row spreadsheets? by Anonymous Coward · · Score: 0

      Try doing actuarial analysis across a 10 year span of automobile casualties and see if you think large spreadsheets are the wrong tool...

      Admittidly it is easier to do it with programming, but a spreadsheet is great for non-programmers.

    19. Re:1 million row spreadsheets? by Bing+Tsher+E · · Score: 1

      IT is not a profession.

      Data janitors, really.

    20. Re:1 million row spreadsheets? by Bing+Tsher+E · · Score: 1

      You're thinking like someone whose focus is to move the data around, not like somebody who uses the data to relate to the outside world.

      'The Company' has licenses for everybody for Excel. Likely in an Open Source world they would have OpenOffice Calc widely deployed. It makes no sense at all for them to train their analysts in Database Programming.

    21. Re:1 million row spreadsheets? by GaryPatterson · · Score: 1

      SQL is weak at statistics and crippled for inter-row calculations. It's not what the language was designed for, and it's certainly not what it does well. Making it go there is exactly as bad as making relational databases in Excel.

      I speak as an SQL Server developer here, and a data administrator and a former corporate reporting person.

      Databases are perfect for filtering sets of data and simple calculations, but they're painfully bad for complex calculations.

      Sometimes a database is the right solution, sometimes not. The thing is to look at the purpose and use of the data, not the row count.

    22. Re:1 million row spreadsheets? by advocate_one · · Score: 1
      The problem is, MS knows this very VERY well. Thus, MS Office products are chock full of every conceivable 'feature', hoping that you'll find a way to do what you need to do somewhere in there without going to someone elses software...damned if it's the right tool or not.

      correct, that's why they stuck those crappy graphic tools in word for producing org charts, flow charts etc... to stop people from using Visio... it worked well enough for Visio to give up and sell out to Microsoft...

      did you know that Office has speech recognition built in? They licensed that from L&H (stupid idiots) and effectively killed the speech recognition market

      About speech recognition
      This feature is available in the Simplified Chinese, Traditional Chinese, English (U.S.), and Japanese language versions of Microsoft Office.

      You can use speech recognition to dictate text into any Office program. You can also select menu, toolbar, dialog box (U.S. English only), and task pane (U.S. English only) items by using your voice.

      Speech recognition is not designed for completely hands-free operation; you'll get the best results if you use a combination of your voice and the mouse or keyboard.

      To use speech recognition for the first time, install it by clicking Speech on the Tools menu in Microsoft Word, or by doing a custom installation. After speech recognition is installed, it is available on the Tools menu in any speech-enabled Office program.

      and the vast majority of users don't even realise they've got it...

      --
      Donald 'Duck' Dunn: We had a band powerful enough to turn goat piss into gasoline.
    23. Re:1 million row spreadsheets? by LordKazan · · Score: 1

      nobody said they would have to - there are fucking gui tools to do the work for them - the database would just be the storage backend - why don't you read this entire thread before replying next time

      --
      If you cannot keep politics out of your moderation remove yourself from the Mod Lottery.. NOW!
  11. yuck! by Garabito · · Score: 2, Insightful

    UI looks like MSN Messenger!

  12. Look and Feel by charleste · · Score: 3, Insightful

    Is it just me, or do these new "ribbons" look alot like Apple Works? I RTFA, and it didn't seem to justify upgrading for the average user - which although a geek, I include myself (I still prefer my text editor!). Office 2007 appears to be Office 2000 (98 too) with a tighter leash to M$, with a few bells and whistles most people won't use.

    1. Re:Look and Feel by icensnow · · Score: 1
      Is it just me, or do these new "ribbons" look alot like Apple Works?
      Agreed, except that Apple Works begat iWork, and these ribbons look like the Inspector to me.
    2. Re:Look and Feel by Gilmoure · · Score: 1

      Meh. I still use Word 5.1a. Is going to suck when I switch to an Intel Mac.

      --
      I drank what? -- Socrates
    3. Re:Look and Feel by Anonymous Coward · · Score: 0

      The "ribbon" is a replacement for menus and toolbars because they just don't scale to a thousand features. I don't know how you would even do this on a Mac, because you can never escape the ever-present menu bar.

      Maybe AppleWorks is a boring program or it's just exceedingly hard to make a screenshot on MacOS, but Google didn't show anything useful in a search for "AppleWorks.X screenshot".

      Apple's site had a few small screenshots, but nothing that looked like Office 2007. Obviously they all used a standard menu like they have been for 22 years.

      dom

    4. Re:Look and Feel by atrocious+cowpat · · Score: 1
      "Is it just me, or do these new "ribbons" look alot like Apple Works?"
      Do not speak the Names of the Walking Dead! It bodes Evil!

      --
      sig? Oh, that sig...
    5. Re:Look and Feel by Bing+Tsher+E · · Score: 1

      Why would you switch?

      You can get an excellent legacy Powerbook for pennies. If you're involved mostly in creative writing, you can have a wonderful experience off in your retreat area with an SE/30. For those REAL retreats, pick up a spare Powerbook 165 or something of equal vintage. Eventually the classic Mac machines will have the feel to those who use them of writers who work on old portable non-electric typewriters.

    6. Re:Look and Feel by TouchOfRed · · Score: 0

      Before you go shooting your mouth off with the same "Its just word 97 made too look fancier" bullshit, go and look under the hood of office 2007, and it is leaps and bounds ahead of its predecessors. Its integration into sharepoint services makes sharing documents within a business a lot more organized and structured, as well as documents in office 2007 look a lot better, and print a lot better(on vista at least) with the new xml based printers. As well, well beneath the hood the vba scripting has become more and more powerful with each release. Not to mention outlook, powerpoint, access, excel, and visio are extremely powerful i couldnt imagine living without, or having to use their alternatives.

      Office is a great piece of software, no matter how much ms bashing you do, and the market will back me up on this one.

    7. Re:Look and Feel by Gilmoure · · Score: 1

      I currently use a PowerBook G3 Pismo. It runs the latest version of OS X. I also have a working PowerBook Duo 270c. It's a little slow for surfing the web but running System 7.1, it runs Word 5.1a real quick. Makes for a nice writing tool, as well as Maelstrom player.

      --
      I drank what? -- Socrates
    8. Re:Look and Feel by michaeldot · · Score: 1

      There's a emulator called SheepShaver which will emulate a PowerPC Mac running System 7.5 thru 9.0.4, and it has been ported for Intel Macs.

      Here's a support thread with guys talking about the practicalities of using it as a Classic environment on their Intel Macs:
      http://www.macosxhints.com/article.php?story=20060 509180914879

    9. Re:Look and Feel by Anonymous Coward · · Score: 0

      It looks more like Blender3d to me.

  13. Developers on Suicide Watch by Anonymous Coward · · Score: 0

    I heard that the level of depression on the Office team is so bad that many have had to seek professional counciling. There are been a number of attempted suicides and most of the team just wants to leave.

  14. Spreadsheets != DBs AND DBs != Spreadsheets by Anonymous Coward · · Score: 0

    If I've got anyone in IT putting 1,000,000 rows in a spreadsheet, I'm seriously considering demoting them. If you're going to have a million rows, get a database.


    So those guys in R&D doing basic signal analysis should be demoted because they're using excel to plot some quick-and-dirty graphs using the 1M data points they've collected? Interesting.

    1. Re:Spreadsheets != DBs AND DBs != Spreadsheets by Anonymous Coward · · Score: 1

      So those guys in R&D doing basic signal analysis should be demoted because they're using excel to plot some quick-and-dirty graphs using the 1M data points they've collected? Interesting.

      Well, as OP said, anyone in IT, so the answer to your question is "No".

    2. Re:Spreadsheets != DBs AND DBs != Spreadsheets by GeckoX · · Score: 1

      Yes, probably. Right tool for the job.

      If you're on a construction site and you always use your crowbar to drive nails, expect to get fired. It might work in a pinch, but it is deffinately NOT the right tool for the job.

      Any sort of analyst plotting a million data points knows the right too for the job, and here's a hint: It's NOT a spreadsheet.

      --
      No Comment.
    3. Re:Spreadsheets != DBs AND DBs != Spreadsheets by Coryoth · · Score: 1

      So those guys in R&D doing basic signal analysis should be demoted because they're using excel to plot some quick-and-dirty graphs using the 1M data points they've collected?

      Given that any R&D department that does signals analysis worth its salt will have a copy of Matlab on hand for all their numerical and plotting needs... Yes? There are various tools that are suitable for various jobs. If you are doing number crunching or plotting with datasets of that size then Excel is not the right tool for the job. Try Matlab, Mathematica, R, or similar.

      Jedidiah.

    4. Re:Spreadsheets != DBs AND DBs != Spreadsheets by Anonymous Coward · · Score: 2, Insightful

      Eh, not really. Excel is quick and it handles unformatted data quite well without having to write a script. Hell, sometimes I use Excel to "tame" a dataset before moving to another program. If I want to do a quick plot without dealing with importing lots of data, Excel is often the easiest option. If I'm dealing with a whole lot of data I'll set up a workflow with sigma or IDL and handle everything that way. Not everything is as black and white as you might think. I don't care about the 'elegant' solution, I care about the best solution, which for me means the fastest one that will get the job done right.

    5. Re:Spreadsheets != DBs AND DBs != Spreadsheets by ClosedSource · · Score: 1

      Not all companies that do R&D signal analysis are large enough to have an R&D department or can afford to provide MATLAB for all engineers.

    6. Re:Spreadsheets != DBs AND DBs != Spreadsheets by Coryoth · · Score: 1

      And I take it R is too expensive as well?

      Jedidiah.

    7. Re:Spreadsheets != DBs AND DBs != Spreadsheets by ClosedSource · · Score: 1

      I don't know anything about R, so I can't comment on it.

    8. Re:Spreadsheets != DBs AND DBs != Spreadsheets by udham · · Score: 1

      Then there is also GNU-Octave (www.octave.org) and Scilab. If you know Matlab, you will be right at home with either of the two. Now if you are a Simulink user like I am, then... -a.

      --
      What garlic is to food, insanity is to art.
    9. Re:Spreadsheets != DBs AND DBs != Spreadsheets by WilliamSChips · · Score: 1
      If you're on a construction site and you always use your crowbar to drive nails, expect to get fired. It might work in a pinch, but it is deffinately NOT the right tool for the job.
      But what if I'm Gordon Freeman?
      --
      Please, for the good of Humanity, vote Obama.
    10. Re:Spreadsheets != DBs AND DBs != Spreadsheets by Anonymous Coward · · Score: 0

      Come on, if you're storing that much data in a spreadsheet, it's GOING to cause troubles. Whether office 95 or 2007, it's going to be a problem one way or the other. If you have that much data, you need to clear it up properly. The thing that so many of you seem to be forgetting is it's not Excel or database. You can have Excel AND database. If you do it PROPERLY and put the data in a database, where it belongs, you can get the parts you need in Excel when you need them via a simple query then do whatever little thing you need to do. It is faster, more efficient, more reliable, and just general good sensible practice. If you throw all that data into a spreadsheet blossoming into > 20MB sizes and decide to solve the problem by buying Office 2007 just so you get more rows, you WILL regret it down the road. Not might, will. Eventually you'll find out the hard way why it's such a bad idea to do it this way.

      And, btw, I don't understand that earlier comment about compatibility. Databases are about as compatible as you get. I mean, when even spreadsheet programs can run database queries I just don't understand what more compatibility you could want. A simple command line can create a simple text file for import into whatever doesn't support standard database commands even. It's so easy you can set up a simple little batch file that a user can double click and presto, they have the latest work data saved to a file on their flashdrive to take home and work on.

      Spreadsheet programs like Excel were not designed for the kinds of things that need more than 65535 lines. They were designed for quick and dirty little things. That's why MS didn't care enough to increase the limit sooner. This is why the thread ancestor said that anyone using spreadsheets for such a purpose should really be demoted. Once a thing is adobted it's very hard to make people switch away and this theoretical person has chosen to adopt a tool which can do the task but must be kind of hacked at (much like hammering in a nail with a crowbar is kind of a backwards way of doing it.) When he was picking out the tool that not just himself, but, others would use for the job, he didn't necessarily have to pick an air compressed fast acting hammer (which may even be too much for the job) but, even if that would have helped, he could have at least bought hammers instead of crowbars. Frankly, I would have considered firing him instead of demoting.

    11. Re:Spreadsheets != DBs AND DBs != Spreadsheets by spectecjr · · Score: 1

      Then there is also GNU-Octave (www.octave.org) and Scilab. If you know Matlab, you will be right at home with either of the two. Now if you are a Simulink user like I am, then... -a.

      Yay! A tool you need to program to do simple data analysis! That's so much easier than opening a CSV file in Excel, and creating a chart on another sheet.

      Sheesh... you know, sometimes, it's about convenience, and how well you can get something up easily and quickly. NOT about how "the right way" is.

      --
      Coming soon - pyrogyra
    12. Re:Spreadsheets != DBs AND DBs != Spreadsheets by Coryoth · · Score: 1

      If you have a large amount of numerical data (hundreds of thousands of rows worth) then I assure you that Matlab, R, Mathematica, or even Gnuplot will be a the fastest way to "get something up easily and quickly". Just because you've never used them (apparently) and thus don't know how very easy they are to use for anyone who does any sort of numerical work, doesn't make them harder. The fact that they are incredibly powerful and permit far more complex number crunching and data manipulation due to a programmable interface doesn't make them any harder to use either - if all you want to do is plot then gnuplot can do it for you in a single command, no need to load speadsheet programs, import CSV files, and click through various graph making tools.

      Jedidiah.

    13. Re:Spreadsheets != DBs AND DBs != Spreadsheets by spectecjr · · Score: 1

      If you have a large amount of numerical data (hundreds of thousands of rows worth) then I assure you that Matlab, R, Mathematica, or even Gnuplot will be a the fastest way to "get something up easily and quickly". Just because you've never used them (apparently) and thus don't know how very easy they are to use for anyone who does any sort of numerical work, doesn't make them harder. The fact that they are incredibly powerful and permit far more complex number crunching and data manipulation due to a programmable interface doesn't make them any harder to use either - if all you want to do is plot then gnuplot can do it for you in a single command, no need to load speadsheet programs, import CSV files, and click through various graph making tools.

      I see you're not talking about GnuOctave then. Pity, because I was. As was the post I was replying to.

      And no, not all I need to do is plot. I need a variety of statistical tools as well.

      --
      Coming soon - pyrogyra
    14. Re:Spreadsheets != DBs AND DBs != Spreadsheets by Coryoth · · Score: 1

      I see you're not talking about GnuOctave then. Pity, because I was. As was the post I was replying to.

      Given that Octave is Matlab workalike that uses Gnuplot for plotting I think we're close enough to talking about the same thing. Besides this whole discussion started with regard to the right tool for the job, the claim originally being that if you need to deal with hundreds of thousands signals analysis data points then Excel is great. It isn't. Matlab is great. The person then complained that Matlab was too expensive. Someone pointed him to Octave. And now you come up with:

      And no, not all I need to do is plot. I need a variety of statistical tools as well.

      For which, indeed, Octave probably isn't the ideal tool. The better tool for that job is obviously R which can suck in files in just as many formats (or more) than Excel, has far better (and more numerically accurate I might add), and far far more statistics functions, is actually designed from the outset to do high powered statistics on such massive datasets and, what do you know, let's you plot in a dozen different ways with a single command.

      Jedidiah.

    15. Re:Spreadsheets != DBs AND DBs != Spreadsheets by Master+of+Transhuman · · Score: 1


      If you're plotting a million data points, pretty much by definition you're not that interested in any given data point, right? Plus how many variables are involved in each of those data points? 16,000 columns worth? Kinda doubt it. It's probably one or a few numbers, right?

      But one hundred thousand rows of customer contact data, yeah, you're interested in specific rows.

      Manipulating THAT sort of thing in a spreadsheet is braindead.

      Using a spreadsheet as a complicated stats calculator with a lot of rows is okay. Like I said, I'm not in favor of arbitrary limits on software.

      But that's not the same thing as incorrectly using a spreadsheet as a database.

      It's not the row count we're objecting to, per se, it's the type of data people are putting in them.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    16. Re:Spreadsheets != DBs AND DBs != Spreadsheets by Master+of+Transhuman · · Score: 1


      That's the point - you were never told that there's a better tool, so you end up using a crippled tool.

      This is why people do what they do - their IT support (and general managerial support) is so weak they end up using crippled tools to do their jobs.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    17. Re:Spreadsheets != DBs AND DBs != Spreadsheets by udham · · Score: 1

      spectecjr,

      My post was in repsonse to the guy who said that not everyone has the budget to buy (rather pricey) Matlab licenses. Well, GNU project to the rescue! Try GNU-Octave, a fine software with a similar interface.

      Now, to address the point you tried to make:
      If you want to plot Column E vs Column C in Excel, to the best of my knowledge, you are SOL in Excel (You can plot C vs E though). The fix is to copy/move columns to do that. Same thing if you want to plot abs or sin of any column, or any other function for that matter.

      To plot in octave/matlab, the steps are
      >> x = load('filename.csv');
      >> plot(x(:,1),x(:,2); # Column A vs Column B
      >> hold;
      >> grid;
      >> plot(x(:,5),x(:,3)); # Column E vs Column C

      Pros:
      1. No arbitrary limits on the number of columns/row, besides your hardware
      2. Save these few commands in a script .m file, you you now have a programming interface.
      3. No change in user interface is going to stump you when Office 2012 comes out
      4. More power: you can plot rows against rows rather than just doing columns against columns, etc etc (plot x(1,:),x(2:,)) will do the trick
      5. Amenable to piping, scripting and all the good stuff. Want to read n different files , plot some variables stored in the said files, and print them all out with consistent formatting into a n page or a n/2 page pdf that you can quickly look through? In alphabetical order of the filename? In chronological order? No problemo, done in 5 minutes. Want to do it for every file in your home or project directory?
      6. The data is stored in ieee-754 floats to save space, no problemo. Interleaved ieee-754 floats with variable interleave factor? No problemo.

      I could go on and on really.

      Cons:
      1. Some sort of a learning curve, but with a much higher reward

      My claim is that for anything but the most trivial tasks, excel is not a tool, it is an obstruction. The user is much better served by learning

      Having said that, my excel and office experience is limited, so there is every chance that what I have said is wrong/biased. You might be able to do some things in Visual Basic, but is it cross platform? Will it work 10 years from now?

      LaTeX + Gnuplot is all that I need anyway, with a smattering of perl/octave.

      Thanks
      -a.

      --
      What garlic is to food, insanity is to art.
    18. Re:Spreadsheets != DBs AND DBs != Spreadsheets by EvanED · · Score: 1

      Come on, if you're storing that much data in a spreadsheet, it's GOING to cause troubles

      You mean it DID cause troubles; there's no reason why it must.

      The thing that so many of you seem to be forgetting is it's not Excel or database. You can have Excel AND database.

      You don't always need both. Just like Excel isn't a hammer that shouldn't be used to do everything, nor is Excel+DB. For something quick and dirty, Excel alone might do all right, and be worth not going through the overhead of using a db.

      If you throw all that data into a spreadsheet blossoming into > 20MB sizes and decide to solve the problem by buying Office 2007 just so you get more rows...

      True, this is a lousy reason to upgrade. But it's still a worthwhile and potentially useful improvement. ...you WILL regret it down the road.

      What if there is no "down the road" and it's just a one-off thing?

    19. Re:Spreadsheets != DBs AND DBs != Spreadsheets by EvanED · · Score: 1

      Try GNU-Octave, a fine software with a similar interface.

      If all you do is stick to the text part of Matlab. There's a lot of helpful guides (menus and such) that come with Matlab.

      (I've only used either a small amount, so I didn't always know it as well as I'd like and the aids came in handy.)

      If you want to plot Column E vs Column C in Excel, to the best of my knowledge, you are SOL in Excel

      You're not SOL. Excel uses the same idiom as almost every graphical toolkit on every OS for doing multiple selections, ctrl+click. Want to select A1 and C3 only? Click A1, ctrl+click C3. Want to select columns A and C? Click the column header for A, then ctrl+click the column header for C.

      Granted, I think this is not common knowledge and MS odesn't go out of their way to make it known, but the actual process I think can't be improved.

      (Incidentally, in Word you can select discontiguous regions in the same manner.)

      Oh yeah, and I think you could also manually type in the ranges in the chart wizard, though I'm too lazy to try that now.

      No arbitrary limits on the number of columns/row, besides your hardware

      You sure about that?

      I bet that if I were to take a look at the Octave source (or Matlab), that 1, 2, 3, and 5 you entered are stored as ints. That means an artifical limit of 4 billion.

      Granted, it's a damn high artifical limit, but it's an artifical limit nonetheless.

      4. More power: you can plot rows against rows rather than just doing columns against columns, etc etc (plot x(1,:),x(2:,)) will do the trick

      If you put 1/10 the time you spent learning the matlab into just playing with Excel's, you'd know that plotting rows vs. rows is just as easy as columns vs. columns. If you choose a X-Y scatter plot and have, say, a 2x3 area selected, it will plot the top row as X and bottom row as Y. If you have 3x2 selected, it'll plot the left column as X and right column as Y.

      If you have a 2x2 square selected... a radio button selection "series in ()row ()column" works "right".

      You might be able to do some things in Visual Basic, but is it cross platform? Will it work 10 years from now?

      I have a suspicion that everything I said here is applicable to almost every decent spreadsheet out there. For instance, the only change if you move to OpenOffice Calc is that if your data is in rows it won't detect it and you have to manually change to series in rows.

      LaTeX + Gnuplot is all that I need anyway...

      LaTeX is my God. :-p

    20. Re:Spreadsheets != DBs AND DBs != Spreadsheets by Anonymous Coward · · Score: 0

      So those guys in R&D doing basic signal analysis should be demoted because they're using excel to plot some quick-and-dirty graphs using the 1M data points they've collected? Interesting.

      While I agree with what you're saying in principle, you chose a bad example. Excel cannot plot more than 5000 points on a graph... that is the limit (give it a try if you don't believe me), more than a few hundred points and it bogs down quickly anyway.

      There are far better programs to plot/model data.

    21. Re:Spreadsheets != DBs AND DBs != Spreadsheets by ClosedSource · · Score: 1

      By crippled tool do you mean MATLAB?

    22. Re:Spreadsheets != DBs AND DBs != Spreadsheets by GeckoX · · Score: 1

      If you find yourself at the brink of the end of the world, and all you have is a crowbar, well, I won't tell your boss :)

      --
      No Comment.
  15. more than a desktop app by nostriluu · · Score: 1


    People are going to think of ms office as much more than a set of standalone desktop applications, and more of an end to end system.

    This makes sense in this day, and is a very effective way for MS to retain traction. The fact is that while the diversity of non-MS and particularly open source solutions is great, it's also a huge detraction since many people may choose an almost as good, almost as open solution over a confusing array of alternatives.

    The last time I dabbled in the MS world, it wasn't particularly cohesive, but I have to wonder if MS is making strides with everything less "hack-y" under the covers. I notice more cohesion in the open source world as well, and am looking forward to what the future may bring in terms of rich content editing and collaboration, which will surely be exciting as long as the milieu remains open and competitive.

  16. Non-standard UI by Abcd1234 · · Score: 1

    On the one hand, people complain about how Swing "looks funny" on Windows. Meanwhile, every damn release of Office has Microsoft deviating further and further from their stock UI...

    1. Re:Non-standard UI by astrosmash · · Score: 1

      It seems the MS Office team are the only group within Microsoft that provide any meaningful UI and usability innovation, and it's the type of innovation that is sorely lacking on Windows.

      The whole MDI thing with its bunch of tiny, rearrangeable menu bars with tiny little buttons was a bad idea in 1991, and it's bad today. And the menu bar only makes sense when it's attached to the top of the screen. If it's attached to the window then there's absolutely no reason to constrain it to a single like of text.

      I am by no means a big Microsoft fan, but I really like what they've done with the Office UI. It should have happened a long, long time ago.

      --
      ENDUT! HOCH HECH!
    2. Re:Non-standard UI by Eideewt · · Score: 1

      My thought as well. I hear people complaining about how Apple has adopted a random mix of its brushed metal skin and that other one, or how their KDE apps don't look right in Gnome (or vice versa). It's about time Microsoft got with the program. Come to think of it, they're doing pretty well. The control panel in XP looks like nothing else on the system, tray icons have those funny little speech bubbles that don't appear elsewhere, Windows Media Player has its own interface, Office is bizarre and unique, and who knows what else is coming in Vista. I don't know if it all means that consistent UIs are over-rated or that everyone is horrible at interface design.

    3. Re:Non-standard UI by man_of_mr_e · · Score: 1

      So, change is bad? UI Standards evolve. You seem to think that the UI was perfected in 1985 and should never change.

    4. Re:Non-standard UI by Abcd1234 · · Score: 1

      I said no such thing. If you re-read my post, you'll see I made no judgement one way or another. I simply brought up that point that critics seem a little hypocritical when it comes to UI consistency. On the one hand, they criticize Linux (the mixture of KDE/Gnome/etc) and Java/Swing for being inconsistent, while at the same time lauding the efforts of Microsoft when they rev their UI.

    5. Re:Non-standard UI by man_of_mr_e · · Score: 1

      There's a difference. Linux developers all have differing opinions on what the UI should be, and they all write their apps differently. Apple and Microsoft define a single UI standard that "most" apps follow. When Microsoft Rev's the standard, the apps follow suit... not so with Linux. Well, actually, that's not true.. many of them follow Microsoft or Apple as well ;)

    6. Re:Non-standard UI by man_of_mr_e · · Score: 1

      Actually, the Windows UI has largely been driven by the Office team for... well, as long as there's been an Office team. 3D buttons? Word had that before Windows. Common Dialogs? Again, Office. Movable tool bars? Office.

      Note, i'm not saying Office or MS invented these things, just that Office had them before Windows, and Windows adopted them to adapt to Office.

  17. Re:first post by Anonymous Coward · · Score: 0

    1st response for a lame post

  18. WTF (interface changes)? by linguae · · Score: 4, Interesting
    Right from the start, you'll notice the most significant change to Word, Excel, PowerPoint, Access and many screens in Outlook 2007. Gone are the familiar toolbars and menus; they've been replaced by "ribbons" that house a variety of buttons, icons and graphics (see Figure 1). The ribbons have a dual purpose: to highlight features that users are likely to use most often or want most (but have trouble finding), and to promote features at the point they're most useful.

    WTF? But I like my menu bars and toolbars, thank you very much. Menu bars has been a part of Windows since 1985 (and the Mac since 1983 thanks to the Lisa). I think most users would have a hard time understanding "ribbons"; I don't like it when programs try to be "smart" and hide features away from me. There must be an option to use the old menus and toolbars in Office 2007; if not, then I'm not buying it.

    I find that Vista and Office 2007 seems to change menus around and get rid of long-standing GUI features for no apparent usability reason. What's wrong with the old Windows interface? To me, the Windows 2000 interface was the perfect user interface; I still use Classic on my Windows XP partition, and even my KDE desktop on FreeBSD is reminiscent of Windows 2000. I used Vista for a while; I'm not too impressed. Microsoft can take my copy of Office 2000 (I'd still happily be using Office 97 if somebody didn't give me his upgrade disks) and Windows XP when it pries it from my cold, dead fingers. When XP and Office 2000 become obsolete, I would have long switched to FreeBSD and OS X with OpenOffice by then (I'm already a FreeBSD user, too; I just need to buy a Mac to make the switch complete).

    Why must they change the interface when the old one worked so well?

    1. Re:WTF (interface changes)? by cortana · · Score: 1
      Why must they change the interface when the old one worked so well?
      To differentiate their product from Openoffice.org.
    2. Re:WTF (interface changes)? by babbling · · Score: 1

      Imagine trying to sell a new version of Windows/Office that looks exactly the same as the previous version of Windows/Office. They have to do something to make them look different.

    3. Re:WTF (interface changes)? by Anonymous Coward · · Score: 2, Interesting

      Why? Because you are not the target audience. You are a furry toothed hairy little man who can't live outside his comfort zone and doesn't like anyting "newfangled". This is designed for the average cube-drone to be able to use. The new interface is about making the software discoverable and making easy things fast, hard things easy and WTF stuff possible. Something FOSS has yet to grasp as an important feature.

      Having actually used the product, unlike the rest of the fudraisers in this thread, it does all that very well.

    4. Re:WTF (interface changes)? by linguae · · Score: 1
      Imagine trying to sell a new version of Windows/Office that looks exactly the same as the previous version of Windows/Office. They have to do something to make them look different.

      Yeah, I agree, but I wish they made themseleves look different in a better way. Look at how Apple made the switch from OS 9 (an already excellent interface, IMO) and NeXTSTEP (I would like to try out NeXTSTEP or OPENSTEP for Intel just to see if the praise for this interface is true) to OS X (an even more excellent interface with a combination of OS 9 ideas, NeXTSTEP ideas, and new ideas such as Aqua). In comparison, compare Windows 2000 (the high water mark of Windows, IMO), to Windows XP's Luna (I hate it; I use Classic on all XP machines I see), to Vista (which, although nicer looking than Luna, has too many gratitious menu changes and other annoyances for me to like).

      I'd buy a new version of Windows only if the architecture behind it substantially improves. If MS used WinFS or some other innovative file system, learned a few things from Apple and worked on improving Windows Classic even further instead of adding gratitious changes, added real security, came with a good command line (MS is working on one, I believe), and worked fantastically well on a 950MHz Duron with 384MB RAM, I'd be the first in line to buy that version of Windows. The sad thing is that Vista was supposed to be all of things (and more), but most of the interesting, architectural stuff was gutted out.

    5. Re:WTF (interface changes)? by Haeleth · · Score: 1

      To differentiate their product from Openoffice.org.

      Their product is already very well differentiated from OpenOffice.org.

      Microsoft Office is the one that works. OpenOffice.org is the one that doesn't understand all the VBA macros your office has accumulated over the years, making it completely useless in the real world.

    6. Re:WTF (interface changes)? by Billly+Gates · · Score: 2, Insightful

      Microsoft has complained for years that most users request features that Office already has but can't find them according to their usability labs.

      FIrst ms tried to hide the complexities with menu's that delete uncommon features unless you put the cursor over the arrows in the menu. That failed.

      So MS is redoing the UI. Also even for non novices like you and I its a pain to do things like custom graphics for presentations and documentation in word.

    7. Re:WTF (interface changes)? by msuarezalvarez · · Score: 1

      Well, that argument sort of works, I guess, provided you have lots and lots of VBA macros accumulated over the years. Maybe OpenOffice.org will work for your newly bred competition: when you see them, send my best wishes.

    8. Re:WTF (interface changes)? by Blakey+Rat · · Score: 4, Insightful

      You know that Microsoft does usability tests, right? They don't just randomly place things (well, they did in Office for a long time, which is why they're fixing that now), and they don't just rip-off other programs like open source projects to. You can bet your ass that if Microsoft is making a change for usability reasons, they have documented, repeatable, scientific evidence that the new version is better.

      What you're griping is basically, "but I don't like to learn new things!," which is the opposite of how most Slashdotters seem to be... for instance, a lot of Slashdotters recommend starting with Gentoo when switching to Linux you can see how Linux works, or learning the CLI even if you're already experienced at a GUI interface.

      Of course, with Microsoft involved, you know that 80% of these comments are saying it'll be a crappy product without even having tried it.

    9. Re:WTF (interface changes)? by 0xABADC0DA · · Score: 1

      The fundamental problem with all of these crappy gimmicks to improve efficiency and usability is that they don't solve the problem. When I'm writing I always have something I am trying to do and this usually involved only a few actions of the thousands available to choose from and I usually do it over and over again.

      So I have N actions I am doing over and over again and to be efficient I want them all on the screen at the same time so I can click once per action. These actions will often not be easily categorized or grouped, and will change from time to time. For example, I may be accepting changes then putting the changed text in a different color/font/style and adding a footnote explaining the change (maybe to make a public release of a reviewed document). Then I am using three completely separate actions and with *any* of the existing attempts such as disappearing menus, context toolbars, or ribbons I have to jump through hoops to do it.

      The solution I think is just have a thin bar with the last N actions the user performed. This means for *any* task requiring N or fewer actions, they are all on the screen at once so are easy to find and only need 1 mouse click each. When the user performs a new action, the most unused on the bar gets pushed off. Yes it can be as confusing as the other methods, but for a expert it means that it is always 1 click to perform the actions they need and they are always grouped together in one place. For instance, one could have a menubar and a thin, 1-action high toolbar and the rest of the screen could actually show the text and this would be perfectly usable if not more so.

    10. Re:WTF (interface changes)? by perkr · · Score: 1

      That's the most insightful comment in this whole sad thread I've seen so far. If you don't know how the interface works and behaves what are you complaining about? And come on, complaining that they increase the row and column limits? It's riddiculous!

    11. Re:WTF (interface changes)? by VGR · · Score: 2, Interesting
      WTF? But I like my menu bars and toolbars, thank you very much. Menu bars has been a part of Windows since 1985 (and the Mac since 1983 thanks to the Lisa). I think most users would have a hard time understanding "ribbons"; I don't like it when programs try to be "smart" and hide features away from me. There must be an option to use the old menus and toolbars in Office 2007; if not, then I'm not buying it.
      Hear, hear! One of the first rules of UI design is, don't move things around and don't change the layout. It's a lot easier to familiarize myself with a static layout than one that shuffles itself around. And how will I know to use functions I can't even see until I'm lucky enough to "trigger" the appearance of the controls which activate them?

      An interesting book, About Face 2.0, makes a good point: Significant change must be significantly better. (There's a lot of things in the book with which I disagree, but I agree strongly with this one.) Ribbons are different but they're not better.

      Menu bars alone are neither good nor bad; it's all in the organization. Organize a menu bar well, and it is a perfect UI: for any given function, the user should be able to intuit which menu will lead to that function, and the words that make up the menu path should, as closely as possible, form a phrase describing the function. (For instance, "Go --> Home" in a browser.)

      Every time Microsoft tries to innovate for real, they fall flat on their face, because they're so used to buying up others' products that they don't know how to create anything original which is actually good. If "ribbons" are a true attempt at improving the interface, they are a miserable failure. Of course I'm more inclined to believe the whole thing is just a way to convince less-savvy users that Word 2007 really is a new product which is worth a few hundred of their dollars.

      --
      The Internet is full. Go away.
    12. Re:WTF (interface changes)? by 3mpire · · Score: 1, Informative

      they have a "classic" option for crybabies just like yourself ;)

    13. Re:WTF (interface changes)? by VGR · · Score: 1
      You know that Microsoft does usability tests, right? They don't just randomly place things (well, they did in Office for a long time, which is why they're fixing that now), and they don't just rip-off other programs like open source projects to. You can bet your ass that if Microsoft is making a change for usability reasons, they have documented, repeatable, scientific evidence that the new version is better.

      What you're griping is basically, "but I don't like to learn new things!," which is the opposite of how most Slashdotters seem to be... for instance, a lot of Slashdotters recommend starting with Gentoo when switching to Linux you can see how Linux works, or learning the CLI even if you're already experienced at a GUI interface.

      As I said in another post, it's not just about being different. A very good policy for UI design is that significant change must be significantly better. If a bunch of geeks, a large percentage of whom are early adopters, are resistant to a new interface, what hope is there that regular users will tolerate it?

      However, if the interface were good and intuitive, then that would trump the whole fear of new things, because it would require almost no time to learn.

      The problem here is that ribbons aren't significantly better than menus. In my opinion they're not better at all. A menu is an organized list; a ribbon is a jumbled box full of functions which are barely in any order at all. But I will admit they're better than toolbars, whose horizontal layout is slightly less readable than a long line of words with no punctuation or capitalization, except the words aren't text, they're hieroglyphics. (Those icons may look nice, but they suck at conveying information. Most icons do.)

      Microsoft holds usability studies, but so does Apple, and yet we see radically different results (at least until Microsoft gets around to copying each Apple product). Why? Well, I've worked at a number of places which had QA, but somehow we always ended up making crappy software, because QA wasn't given any power of enforcement. Decisions like "We need to ship right now, meeting our arbitrarily set deadline with a load of critical bugs is more important than robust software" effectively neutered the QA people. (Not surprisingly, QA had a high turnover.) Similarly, it's fairly evident Microsoft does the same thing with usability. Their driving force may not be deadlines, though; I think the need to keep a tight grip on the market governs a lot of their seemingly baffling decisions.

      My point being that just because there are usability studies being done, doesn't mean they're being heeded.

      --
      The Internet is full. Go away.
    14. Re:WTF (interface changes)? by oliderid · · Score: 2, Insightful

      You forgot something. it's a Microsoft product :-). Anything coming from Microsoft is de facto bad on slashdot.

      I'm glad they are trying to improve the UI. Things are too complex for the average Joe.

      The only problems for me are :

      The price (first version at $149 is way too expensive)

      The number of versions. Student, standard, pro, pro+ and enterprise (?).

      When you see 5 different versions for the same product with different limitations set by the marketing department. There is clearly a problem.

      Do you remember the difference between XP pro and XP home? Sincerily I don't. They will select just one version in the retail shop. They won't waste their time trying to explain limitations to a lambda user.

      The price is the biggest problem for me . I will stick to open office with thunderbird. It's free and I don't think that the new Ms office features are worth $200 (I'm not a student). Tell me $75 and I may consider it.

    15. Re:WTF (interface changes)? by Blakey+Rat · · Score: 1

      Yes, but we're back to "in my opinion..." Your opinion in usability doesn't matter. (And I'm not insulting you personally, nobody's opinion matters.) Usability is notoriously counter-intuitive, and the only thing that really matters when coming up with a great user interface is *real* studies with *real* users.

      Microsoft's done that; check out Jensen Harris' blog on the subject. You haven't. Therefore, when Microsoft says it's better, I'm going to trust that more than "in my opinion..." and so should everybody reading this article.

    16. Re:WTF (interface changes)? by ElleyKitten · · Score: 2, Interesting

      I just wonder, with geeks complaining about it changing so radically, how will normal users be able to deal with it? The other day the receptionist at my job was wondering how to check her yahoo mail at work. She had a yahoo toolbar, but appearently had never thought to try the "mail" icon. So many non-geek users are just used to going through their routine of what they know and have no idea what to do beyond that. How are they going to deal with a completely changed interface?

      --
      "What is Internet Explorer 7? Are you saying we can't access the normal internet?" - I love tech support. Really.
    17. Re:WTF (interface changes)? by Anonymous Coward · · Score: 0

      This is essentially what the ribbon does. It groups functionality, arranges it very carefully, then presents in a consistent, fixed manner.

      Read Jensen Harris' blog on the subject.

      They've analyzed thousands of datapoints collected from the Office Experience program (that annoying bubble that pops up in Office 2k3), identified the most popular functions, and designed the UI around that. None of the mystery of 20-year-old menus, or the voodoo of the magic menu system. Very cool stuff.

    18. Re:WTF (interface changes)? by Anonymous Coward · · Score: 0, Flamebait

      I like to learn new *useful* things, not things that are only new because of some goofy-ass arbitrary decision to change things around.

    19. Re:WTF (interface changes)? by VGR · · Score: 3, Informative

      You're right; it would be absurd for me to think my dogma outweighs usability studies.

      But I've read a lot of usability studies. Mostly from Apple and NextStep, but I actually did read two Microsoft ones. And I've read the human interface guidelines from Apple, Microsoft and Sun, cover to cover. Even the accessibility parts. Oh, and I've read a few books on the subject, too.

      So when I say that ribbons aren't significantly better than menus, I don't mean that I dislike ribbons; I mean that ribbons don't address the issues which have been raised in the usability studies I've read over the last twenty years or so. I mean that, based on what I've read about the expectations of most users, I believe ribbons will not enhance productivity and may very well take away from it.

      I wonder if a Microsoft usability study was what led to the introduction of "personalized menus." That may have addressed a need of users, but it didn't address it at all well.

      UI design is largely about the art of communication, and ribbons don't seem to communicate available options very well. I believe Microsoft either has done or will do a usability study on that very subject, but I doubt that study will carry the weight it should. It certainly appears to have been pushed to the side where other Microsoft products are concerned.

      When Microsoft says it's better, I'm afraid I don't trust them, because they have a history of not putting the users' experience at the front of their list of priorities.

      --
      The Internet is full. Go away.
    20. Re:WTF (interface changes)? by Anonymous Coward · · Score: 0

      I don't like it when programs try to be "smart" and hide features away from me.

      That's not what this is. They found that many feature requests where for things that were already there, so they're trying to hide *LESS*. Furthermore, the program isn't trying to be smart at all. The command layout has been hand tuned by actual people using real usability test data.

      I'm not gonna say that they're 100% successful (haven't tried it...), but this is NOT like that nasty "personalized menu" thing.

    21. Re:WTF (interface changes)? by mingot · · Score: 1

      You know that Microsoft does usability tests, right? They don't just randomly place things (well, they did in Office for a long time, which is why they're fixing that now), and they don't just rip-off other programs like open source projects to. You can bet your ass that if Microsoft is making a change for usability reasons, they have documented, repeatable, scientific evidence that the new version is better.

      They have a guy over there who blogs the hell out of the whole office usability thing. Very interesting stuff.

      Jensen Harris: An Office User Interface Blog

    22. Re:WTF (interface changes)? by mingot · · Score: 1

      They've analyzed thousands of datapoints collected from the Office Experience program

      Billions, actually. Agree about how interesting it is, though.

    23. Re:WTF (interface changes)? by Frederico+Camara · · Score: 1

      > You know that Microsoft does usability tests, right? They don't just randomly > place things (well, they did in Office for a long time, which is why they're > fixing that now), and they don't just rip-off other programs like open source > projects to. And what is Microsoft Office but a giant ripoff? Spreadsheet, Word processing, E-mail, Presentation software. Is Windows a copy of some other product, huh? What about Internet Explorer? Visual Basic? Media Player? These damn open source projects rip everything! New IE has tabs and they copied it BEFORE Microsoft even thought of putting them in, outrageous! BTW they have "documented, repeatable, scientific evidence" that it would confuse people, but people grew accustomed to it, thanks to these damn open source projects. Rest assured Office 2007 is a great product. I don't even have to try it to know. I own one of their previous versions' ripoffs, and it's a great product, why the company that invented it all would have less?

    24. Re:WTF (interface changes)? by omicronish · · Score: 1

      Why must they change the interface when the old one worked so well?

      Office developer Jensen Harris explains in his series Why the New UI? Fascinating read. His blog is also a great source for Office UI discussions.

    25. Re:WTF (interface changes)? by Anonymous Coward · · Score: 0

      Learn to read. Seriously.

      So ribbons group the functionality very carefully. So what? That's what menus do. That's what toolbars do. Jensen's blog includes a story on shapes and users having to keep switching between tabs. The solution? Put the shapes panel on both tabs.

      Sorry but that's f'ing dumb.

      What I'm talking about is "Recent Documents" or "Favorites" or "Recent Programs" you've run or anything of the sort, only for word actions. Maybe you guys at Microsoft tried that and it was too hard for an average joe to grasp, I don't know, but it's pretty sweet for anyone who can.

    26. Re:WTF (interface changes)? by Anonymous Coward · · Score: 0
      No they don't.

      Hide the Ribbon You can hide the Ribbon by double-clicking the active tab. Keyboard shortcut: To hide the Ribbon, press CTRL+F1. There is no way to delete or replace the Ribbon with the user interface from the earlier versions of Office.

  19. TAP User by pkcs11 · · Score: 1, Informative

    My company is a TAP and early adoption program member.
    Been using Office 12 for about 2 months and so far I've got mixed feelings. The GUI is, well, pretty....people see it and immediately want to beta test it but then get all pissy when Outlook tasks won't synch up with their PDA.
    Its nice, but is far from stable.

    --
    "I have an odd craving to whisper about those few frightful hours in that ill-rumored and evilly shadowed seaport of dea
    1. Re:TAP User by MSFanBoi2 · · Score: 1

      Outlook task wont synch? Well DUH... ActiveSynch doesn't yet support Office 2007. Why is that Office's fault. You know ActiveSynch will get updated shortly...

  20. XPS? by rduke15 · · Score: 3, Insightful

    So Word 2007 introduces yeat another obscure acronym?

    What the hell is XPS?

    Google says X-Ray Photoemission Spectroscopy. That is it's ony result, and it is taken from the place I would have gone next: http://en.wikipedia.org/wiki/XPS.

    1. Re:XPS? by Mattb90 · · Score: 1

      You didn't look very far. On that very Wikipedia page you linked to is what Microsoft are using in Office 2007 (not just Word): "XML Paper Specification". It's MS' e-paper format, and could be classed as a rival to PDF. It'll also be in Vista, which could leave Adobe as annoyed as Symmantec about AV in Vista...

      --
      Mattb90
      Editor, allaboutgames.co.uk
    2. Re:XPS? by Anonymous Coward · · Score: 0
    3. Re:XPS? by FirstTimeCaller · · Score: 4, Informative

      What the hell is XPS?

      It stands for XML Paper Specification and is Microsoft's answer to PDF for document archival and printing. In fact, the whole Vista printing architecture centers around it. All Office applications will be able to save to it and there will be a viewer for non-Vista systems. It's pretty open (especially in Microsoft terms) and overall a good thing (IMHO). See Wikipedia Entry.

      --
      Wanted: witty unique signature. Must be willing to relocate.
    4. Re:XPS? by EraserMouseMan · · Score: 1

      I wonder if /.ers will be mad about XPS just like they don't like the Mono project. When an open project is created that allows Microsoft products to be used on Linux the Linux people don't like it. Why do you think that is?

    5. Re:XPS? by Alioth · · Score: 1

      Because Microsoft patent encumbers them. Get a significant amount of useful Linux apps that depend on Mono (or in future, XPS), and Microsoft can simply pull the rug from under Linux users with a patent suit.

    6. Re:XPS? by 99BottlesOfBeerInMyF · · Score: 1

      It's[sic] pretty open (especially in Microsoft terms)

      So instead of implementing an open standard already adopted by users everywhere, already used for archival purposes, and already implemented by dozens of vendors, MS decided to make up their own format that is "pretty open" whatever that means. Gee I'm thrilled. And this is, of course, bundled with their monopoly OS, further breaking anti-trust laws while insuring that Adobe will lose market share, regardless of which format is superior. Great.

      After dozens of "pretty open" things to come out of Microsoft, you'll have to forgive me for being just a teensy bit skeptical that this will have all of the advantages of a truly open standard. Are there any patents involved? Is it ISO approved? Can it be implemented by GPL programs without reverse engineering? Is each version free in perpetuity or can MS cancel their license, when they come out with a newer version breaking archival uses for other implementations?

      We've seen all of these hidden caveats with their new Word document format and I have little doubt they are up to the same old tricks. Fool me once... shame on you. Fool me consistently for decades... well, you can't fool me that often. Leave it to MS to rip-off a feature from OS X and at the same time manage to do it in such a way that both breaks the law and introduces a new anti-feature way to lock people in.

    7. Re:XPS? by Anonymous Coward · · Score: 0

      It's[sic] pretty open...

      It's. Contraction for It is. What is un-grammatical about that? You are perhaps confusing the rule about the possesive form of it where the usual apostrophe is not used.

    8. Re:XPS? by FirstTimeCaller · · Score: 1

      So instead of implementing an open standard already adopted by users everywhere, already used for archival purposes, and already implemented by dozens of vendors, MS decided to make up their own format...

      What standard would that be? Surely not PDF?
      From Wikipedia:

      Portable Document Format (PDF) is a proprietary file format developed by Adobe Systems
      ...
      --
      Wanted: witty unique signature. Must be willing to relocate.
    9. Re:XPS? by 99BottlesOfBeerInMyF · · Score: 1

      If you finished reading that paragraph you'd read, "PDF is also an open standard in the sense that anyone may create applications that read and write PDF files without having to pay royalties to Adobe Systems."

      It is an ISO certified standard with both a reference implementation and multiple open and closed source implementations. If you can show any way in which it is not open or a standard, do tell.

    10. Re:XPS? by 99BottlesOfBeerInMyF · · Score: 1

      Hmm, I have no idea why my brain flagged that one. I must need more coffee.

  21. Wow... by ceeam · · Score: 1

    This new set of MS software (Vista, New Office) that they've been working hard on for the last 5 years looks really impressive! It can even beat.. I dunno.. Intel Itanium CPU in adoption speed and popularity! Good luck to them!

    (Long sound of ship-horn. Bubbles) /me goes to Apple store to salivate a bit more over higher-end MacBooks

  22. why bother? by Surt · · Score: 3, Funny

    I mean, there's nothing there that OpenOffice hasn't had for like -3 years.

    --
    "Who is the Journal of Quantum Physics going to believe?" --Stephen Hawking
    1. Re:why bother? by RangerRick98 · · Score: 1

      I mean, there's nothing there that OpenOffice hasn't had for like -3 years.


      OpenOffice.org! So advanced the software has features from 2009!
      --
      "You're older than you've ever been, and now you're even older."
    2. Re:why bother? by Surt · · Score: 1

      I meant to imply that OO was only 3 years or so behind.
      But I didn't get any funnies, so I guess it didn't connect.

      --
      "Who is the Journal of Quantum Physics going to believe?" --Stephen Hawking
  23. Given all the rant about new features... by jxyama · · Score: 4, Insightful

    I assume OO.o won't be "copying" any of them, correct?

    1. Re:Given all the rant about new features... by jxyama · · Score: 1
      Obviously, I'm being a flamebait. However, at least in the UI aspect, I haven't seen anything new in OO.o and it is the most significant change in this version of Office.

      If it's well received - my experience is that it definitely improves feature discoverability - will OO.o copy the UI or invent something new?

    2. Re:Given all the rant about new features... by MAXOMENOS · · Score: 1

      What's the obvious thing to do?

      If MS's new approach works better, then it only makes sense that OOo -- KOffice, and Lotus -- will follow suit. These projects need to be useful to ma and pa kettle, and if they expect an MS clone, they'd better get one.

    3. Re:Given all the rant about new features... by rilister · · Score: 1

      Isn't this a great opportunity to push 'old' OpenOffice?

      "Less user training, greater productivity if you switch to OpenOffice than Office 2007"

      I think a lot of people will be scared of change (they always are) and there's probably never been a better time to suggest the 'consistency' of OO.

      --
      'This writing business. Pencils and what-not. Over-rated if you ask me. Silly stuff. Nothing in it' - Eeyore
  24. Difficult Styles by outZider · · Score: 1

    If there is one thing Apple Pages got right (and trust me, there is only one or two things), it's the implementation of styles. I don't think I ever touched them in Word until Pages made the whole thing a lot clearer.

    The scary thing is that the concept isn't exactly foreign to me -- anyone who has used CSS knows the principle. I just can't believe I ignored it for so long.

    --
    - oZ
    // i am here.
    1. Re:Difficult Styles by IamTheRealMike · · Score: 1

      What did it get wrong?

  25. Compatability and support by Douglas+Simmons · · Score: 1
    Like many consumers, the only reason I'd buy this is I wouldn't want to risk compatability issues in the arms race of upgrading to the latest technology. Similarly, the only reason I'd buy SharePoint is to use this software. I'm not going to buy it because I think it will make me so much more productive to justify the cost.

    I think when a company has this kind of leverage over consumers, it should be considered anticompetitive and illegal. What's the downside to tightening the threshold of the definition of monopoly?

    1. Re:Compatability and support by MarkByers · · Score: 1

      What's the downside to tightening the threshold of the definition of monopoly?

      There's nothing wrong with the current definition of a monopoly.

      The problem is that noone is taking any action. The few organisations that are powerful enough to do anything about it (governments) choose not to. The EU is too scared of upsetting Microsoft that they still aren't collecting any money from the fines they imposed ages ago.

      Meanwhile customers are happy to pay up, so life goes on. Microsoft's only problem is that their older products are sufficiently good (in most people's eyes) that people would rather keep using what they have and not upgrade. The best way Microsoft can force people to upgrade is to change the file format to make it incompatible with older versions, and encourage people to start distributing documents in the new format. I'm sure we will see them pushing their new 'open' (patented) document format.

      Don't wait for the government to save your arse. Vote with your wallet today.

      --
      I'll probably be modded down for this...
  26. The appearance is rarely the complaint. by Anonymous Coward · · Score: 1, Insightful

    Having developed a number of Swing-based applications used internally at an insurance company (by people in various departments), the main complaint was not about the look or feel of Swing. Instead, most users complained how long it took to start up the apps, and how slow unresponsive the GUIs would be.

    In short, most of the complains were those that are leveled against Java in general. I'm well aware that a decent Java VM with a JIT compiler can outperform C++ in some cases, and that fairly fast Swing interfaces can be created with much care and effort. However, in the real world we don't have weeks to fine-tune and optimize our Swing UIs.

    It is good that Microsoft is willing to experiment with this new UI approach. They do have the resources to do so. If it turns out to be beneficial, then similar work can be done on OpenOffice. If it turns out to be a major hassle for most people, then OpenOffice is already ahead. Either way, it will be a useful experiment, for both Microsoft and the open source community.

    There hasn't been GUI hegemony within the Windows community for ages. At least with Windows 3.1 it was mostly the Common Controls and OWL. But since Windows 95 we have had some GTK+ apps, Java-based apps, WinForms apps, iTunes, WinAmp, RealPlayer, and a host of others with their own GUIs. There hasn't been a consistent GUI on Windows for over a decade.

    1. Re:The appearance is rarely the complaint. by Decaff · · Score: 3, Informative

      However, in the real world we don't have weeks to fine-tune and optimize our Swing UIs.

      And you really don't need to. I find it astonishing the way that criticisms of Swing that were fair 4-5 years ago are still being repeated. Swing has been fast since the later releases of Java 1.4. Swing has no performance issues on Java 1.5, and Java 1.5 apps start fast (I have just opened JEdit on my laptop PC. It started up faster than IE or Acrobat on the same machine. The menus and controls are instantly responsive).

      If you have any issues with performance, get an up-to-date Java. Java 1.5 has been around for 18 months - there is no excuse!

    2. Re:The appearance is rarely the complaint. by Blakey+Rat · · Score: 1

      Try it on OS X, then come back. It's tolerable on Windows, but it's not even remotely close on OS X. Drag&drop doesn't work; the integrated spell-checker doesn't work; the Services menu doesn't work; it's ugly as hell and generally un-Mac-like (i.e. the editFields are wrong, the Preferences aren't in the Application menu, etc.)

    3. Re:The appearance is rarely the complaint. by rmdir+-r+* · · Score: 1
      I don't know what version of the JRE you're using, but here, I'm using 1.5, and guess what? It's still slow. JEdit does _not_ launch instantaneously, it takes almost twice as long as firefox. Not only that, but I frequently have problems with swing apps not repainting the screen when they're doing something, leaving nasty looking artifacts everywhere. This includes JEdit, Azureus, and Frostwire- flagship Java applications.

      Apparently the new Java evangelism strategy is lying. There are lots of nice things about Java, and if you have alot of hardware, it scales well. But its still not `ready for the desktop', get over it.

    4. Re:The appearance is rarely the complaint. by Decaff · · Score: 2, Insightful

      Apparently the new Java evangelism strategy is lying. There are lots of nice things about Java, and if you have alot of hardware, it scales well. But its still not `ready for the desktop', get over it.

      Sorry, but I am using Java for desktop applications that are used on a daily basis. No issues about performance; no issues about repainting. It seems to me that part of the continuing anti-Java envangelism is obviously lying.

      JEdit does _not_ launch instantaneously, it takes almost twice as long as firefox.

      And this is an example of the blantant lying. No-one was claiming that JEdit launched '_instanteously_'. The claim was that it was no slower than some other typical Windows applications. Simply working through a list of Windows applications until you happen to find one that starts faster than JEdit is not evidence against this, only evidence that you are desperate to try and prove Java slow, for whatever reason.

    5. Re:The appearance is rarely the complaint. by Decaff · · Score: 1

      Try it on OS X, then come back. It's tolerable on Windows, but it's not even remotely close on OS X.

      Then blame Apple. They write the OS/X versions of Java.

    6. Re:The appearance is rarely the complaint. by Bing+Tsher+E · · Score: 1

      I'm well aware that a decent Java VM with a JIT compiler can outperform C++ in some cases

      Yes, all the Object Oriented bloat of C++ does make it as terrible as Java sometimes.

      Nice for the programmers to maintain. And great for promoting DRAM and CPU upgrades.

    7. Re:The appearance is rarely the complaint. by Bing+Tsher+E · · Score: 1

      Let's just focus on a small subset of Windows applications. How about just editors.

      TextPad comes up in a blink on my Windows box. And you know how I first found out about TextPad? It was recommended by Sun's Java Development scheme, back in the early days of Java.

      You're desperate to prove Java is up to the task. Really, you just seem like a Java troll. Shouldn't you be fighting the good fight on a Usenet advocacy newsgroup or something?

    8. Re:The appearance is rarely the complaint. by rmdir+-r+* · · Score: 1
      Simply working through a list of Windows applications until you happen to find one that starts faster than JEdit is not evidence against this, only evidence that you are desperate to try and prove Java slow, for whatever reason.

      I used firefox as an example because I never use internet explorer, and am commenting from a box that doesn't have windows. The parent said 'it starts as fast as IE', and I figured Firefox would have a roughly comparable start time (my windows using friends tell me it takes longer). In any case, on the machine I am on, from a cold start, JEdit takes 14 seconds to start up, firefox 6.

      Now, this isn't very accurate, the test consisted of me counting slowly after launching the app and stopping when I could see it, so feel free to come up with a better one, preferably one that is automated, and we can have a regular pissing match.

    9. Re:The appearance is rarely the complaint. by Blakey+Rat · · Score: 1

      Excuse my Java ignorance, but I thought that Swing was made by Sun and Apple's involvement was only creating the Virtual Machine that Swing and the Java apps ran in?

      If Swing is, indeed, developed by Apple, and if Swing has hooks into Java apps for them to take advantage of features like drag&drop, the spellchecker, etc, then yeah, I agree that it's Apple's fault.

      However, whether it's Apple's fault or Sun's fault, the fact is that Java GUI apps look and run like ass on OS X and I avoid them whenever possible because of that.

  27. Clippy! by Tackhead · · Score: 4, Funny
    > Bigger spreadsheets are available in Excel -- over 1 million rows and over 16,000 columns per worksheet
    >
    > what kind of a jackass ....? use a fucking relational database! I don't want to think how blazingly slow that big of a spreadsheet would be, not to mention any dataset that large is going to almost certainly be something that is supposed to be used by more than one person at a time

    It looks like you are trying to implement a relational database in Excel!

    Would you like to...

    • Add another 100,000 rows to the worksheet? (You're my kind of jackass!)
    • Use a fucking relational database? (but not MySQL or Oracle!)
    • Suck it, Ellison!, and don't show me this tip again or I'll throw a chair at you. (I'm still bitter about the year you beat me.)
  28. It's all about the target audience... by ndykman · · Score: 3, Insightful

    I'm sure there will be lots of interesting commentary here on Office 2007, and I'm sure a lot of it will be along the lines of "New interface is goofy/sucks/bad for users/too different/etc." and/or "OpenOffice rules, why go MS?" and so on.

    Which is all fine and good. Really. But the changes in Office aren't targeted at power users. In fact, it probably is true that the new UI will frustrate power users. So, why did MS bother?

    Because for every power user, there are 100s of regular users. They want to do more with Word, Excel, etc, but have a hard time finding the features they want. So, this is the first step in this direction. It won't be perfect, but what does do is break from tradition in some interesting ways.

    Believe me that MS has been sticking this in front of users and doing usability studies. And I'm willing to bet that enough regular users think that the new UI isn't so bad, that it's pretty cool after you get used to it, and it's easier to find features and play around with them.

    All the live preview featues and ribbon bars and so on are to make it easier to regular users to goof around with changes without making them permanent. Also, remember that this is Beta2, so it isn't clear that all the live preview features are in yet, so it could very well be that paragrpah sytle previews will be in the final product.

    Finally, I think it is important to note something about the ribbons. The ribbons don't change. This is not the custom menu idea, where menus "adapted to users" whihc just translated to stuff moved on the menus, and you don't know why. You choose a ribbon, you get the tools for that ribbon period. They don't move around.

    Will it work? Hard to say. But I like the idea that the idea of Office applications is being looked at in a fresh way.

    1. Re:It's all about the target audience... by oh_my_080980980 · · Score: 1

      Put down the bong pipe and walk away.

      Apperantly you have not read the comments about newbies using the new UI. This is in no way for them. It will be harder for them to use. Why...

      BECAUSE THEY CHANGED THE LAYOUT!!!

      People expect things to be a certain way in Word. Now Microsoft changed that. Who exactly is this suppose to be easy for? Someone who has used Office 2003-2000-'97? Anybody who has used a previous Office product will be at a lost. Hell anyone who has used ANY Windows program won't know what to do because the UI has changed!

      Now you may pick up your bong.

    2. Re:It's all about the target audience... by linguae · · Score: 3, Insightful
      Because for every power user, there are 100s of regular users.

      Problem is, most of those regular users are already accustomed to the Windows 95-esque and Office 97-esque interface, not this newfangled Vista stuff. For example, my parents are regular users and they still use Windows 95 and Office 97. Yet they have no trouble using Word, Excel, and those applications. Same with my siblings who, while very computer literate, they don't plan on coding and all of that other fun stuff. They can use classic Windows with very little difficulty. The classic Windows interface just works. Throw most regular users this Vista stuff with no menus, reorganized icons, and other stuff, and they will have to do a lot of retraining (just like how Windows 3.1 users had to switch to Windows 95, except I believe the XP-Vista switch of interfaces is worse compared to the 3.1-95 switch). It is a completely different OS; you might as well hand them a Mac (which has familiar menus, toolbars, a dock, and other features) or even KDE/GNOME (which is even more Windows-like; and no, this isn't a slam).

      Don't think that regular users are cavemen and cavewomen who barely know how to use a computer. Regular users have a lot more computing experience than most of us CSers, UI people, and other computer professionals think. That's the problem with UI people; they want to design UIs for complete noobs, yet most people aren't complete noobs (but not exactly power users, either). I say, keep the old Office interface that we've been using since 1995. It works, and it works quite well. Any gratitious changes (like Office 2007 and Vista) would just make users think twice about getting a PC and think more about getting a Mac or switching to *nix (hey, you already have to learn a new interface with Vista; some people might as well switch OSes).

    3. Re:It's all about the target audience... by chadliness · · Score: 1

      Believe me that MS has been sticking this in front of users and doing usability studies.

      I'd almost be willing to go along with you on this except they put copy and paste at the top of the "most used items" ribbon. Even regular users use the keyboard shortcuts for these. As such, I'm more willing to believe it was redesigned just to make it different than the open source equivalents (and hence, harder to switch).

    4. Re:It's all about the target audience... by atrocious+cowpat · · Score: 2, Insightful
      "[T]he changes in Office aren't targeted at power users. In fact, it probably is true that the new UI will frustrate power users. So, why did MS bother? Because for every power user, there are 100s of regular users."
      This reminds me strongly of the discussions (flamewars) we had, when Apple completely overhauled the Mac GUI in the transition from OS 9 to OS X.

      I admit: I (having been one of them "classic" Mac OS "Power-Users") hated it at first. Hated it deeply. "Where are all my beloved shortcuts (etc. etc.)? Where have my (almost brain-hardwired) Mouse-Click-Cascades gone?" I used to wail.

      Then I watched my mother work on her "new" system (she, too, had used Mac OS 8/9 for about 6 years). Thing is: she hardly even noticed. What I noticed, however, is that she took to the new UI like a duck to water, found stuff much easier and basically became more in command of her computer than she had ever been before.

      So my point is: a radical change in the UI isn't necessarily a bad thing, if it's done right. And pissing off "power-users" isn't too bad either... heck, if you're really smart enough to call yourself a "power-user" you should also be able to adapt easily (I did).

      Just my (anectodal) 2 cents (Euro).


      P.S.: To make this clear: of course I'm not saying, that Microsoft got the new Office-UI right (time will tell on this), just that a radical change isn't necessarily bad, even... nay: especially when it annoys the "power-users".
      --
      sig? Oh, that sig...
    5. Re:It's all about the target audience... by ndykman · · Score: 1

      Well, I can't discount that as a factor, to be sure. There is "change for the sake of change" here, but I don't think that all there is to it. It's the "we think we have a better way" and "we will go to the mat to try and prove it". Will it work? I dunno. I don't think it will be as bad as some predict, but not as smooth as MS would like either. I mean, there was a time when word processors just had text menus and you had to use lots of shortcuts. There was time when Office 95 was new and different and it still worked.

      But, at least copy and paste are most used.

    6. Re:It's all about the target audience... by siphoncolder · · Score: 1

      Did you forget that some of the target audience are only JUST coming into computers now?

      Oh yeah. So sure, some people are going to have to learn to adapt. Life sucks, get a helmet. But for schoolchildren and people new to Office, what do you think would be easier - the ribbon bar or the menu?

      A lot of the target audience has yet to use Office. Don't be so shortsighted.

      --
      i'm amazed that i survived - an airbag saved my life.
    7. Re:It's all about the target audience... by CrazyWingman · · Score: 1

      Of course, some other fairly important people (Jeff Raskin, Donald Norman) argue that it's a faulty design to target new users. Designs aimed at new/inexperienced users are rarely any help to power users, and are often a detriment to them, as these designs tend to hide/disable many advanced features. Designs aimed at power users, however, allow frequent users to learn and adapt to get the most from their tools. Sure, a new user will often take a little longer to learn a power-user interface, but once they take their first step, they are able to grow and learn. A newbie interface just stifles everyone.

      Another, not necessarily equivalent, way of saying this is that newbie users have no clue what they want and can deal with just about any interface. Power users, however, have very specific demands and suffer great losses to productivity when their interfaces change.

      A great example is keyboard layout. It has been shown that an alphabetic keyboard layout gives new users only a slight speed advantage over a QWERTY layout (if any at all). Typists, however, are much faster on QWERTY than alphabetic - even after weeks of practice, IIRC. (Anyone remember if this example was in DOET or THI? I thought I remembered reading this one on the web, but I can't find the reference at the moment.)

      Important Note: Please notice that I am not relating the new Office design to this discussion. I have not had the chance to use it, and I can not speak for how it feels. Like others here, I'm sure that MS has done usability studies on this design. Hopefully they have learned their lesson, did the study correctly, and are following the guidelines they extracted from it.

  29. Longstanding problems fixed? by Frequency+Domain · · Score: 4, Informative

    McCullough and Wilson wrote a paper about Office back in 1997 which ripped Excel to shreds on its statistical accuracy and random number generation. They reissued the paper in 2002, and Excel still had the same problems in Office2000 and OfficeXP. Many of the worst problems were still there in Office2003. Have they actually fixed the horrible errors?

    1. Re:Longstanding problems fixed? by IamTheRealMike · · Score: 1

      I have heard on the grapevine that the numerical core of Excel is ancient and still written in K&R C ... a bit like the dynamic linker on Windows the engineers don't like to touch it as the only people who truly understood it have long since moved on. Also there may be spreadsheets relying on the inaccuracy (perhaps).

    2. Re:Longstanding problems fixed? by Billly+Gates · · Score: 1

      If you need custom statistics with very accurate results then you shouldn't use Excel. ITs the same thing argument with excel supporting 1 million rows vs using a database.

      I believe OO spreadsheet program is nowhere close to excel but I could be wrong.

    3. Re:Longstanding problems fixed? by ClamIAm · · Score: 1

      I remember reading about how Gnumeric has developed a niche among those who use spreadsheets for things that require more mathematical accuracy. I wonder if MS is basically trying to stay bug-for-bug compatible with themself...

    4. Re:Longstanding problems fixed? by Anonymous Coward · · Score: 1, Interesting

      McCullough? Bruce McCullough?

      I took a statistics class at Drexel he taught. He is a scary, scary man. Uses his class to reaffirm his belief in statistics. And I wasn't even a business or economics major!

  30. Some interesting new changes in word by vivek7006 · · Score: 4, Informative

    1) Word's default font is now Calibri, not Arial. Calibri is a highly readable font.

    2)The File menu is gone; now you have to somehow guess that the big icon in the upper left corner is its replacement.

    3)The "most recently used" list is no longer limited to the last nine files

    4)Track Changes now won't flag as "different" text that is simply moved, which is smart.

    5) Ability to export documents to PDF and to their own pdf-like format, whatever that is.

    1. Re:Some interesting new changes in word by Keith+Russell · · Score: 2, Informative

      Some of the changes make more sense when you pair Office 2007 with Windows Vista. It took me a while to figure out the Big Office Logo Sphere Button until I saw a screenshot of Word 2007 on Vista. Vista's Start button is now a Big Windows Logo Sphere Button in the bottom left corner of the screen. So I guess that means that the Big Office Logo Sphere Button in the top left corner of the screen is Office's "Start button". See, it all makes sense in a "the designers are insufferably happy, and we get to show everybody that we kinda, sorta understand Fitts' Law" way.

      Another change that only makes sense in the context of Vista is how Outlook has been dropped from the Student edition. The new Windows Calendar would take care of task and calendar functions. The oft-neglected Outlook Express has (supposedly) been given an overhaul, and is now known as Windows Mail. I still wouldn't trust it with plain-text emails from a whitelist, but that's just me.

      --
      This sig intentionally left blank.
    2. Re:Some interesting new changes in word by jez9999 · · Score: 1

      One thing that DOESN'T seem to have changed, judging by a screenshot, is the silly page numbering limitation Word gives you. You can only have a unique header for the first page, and optionally odd/even pages. You can't have several different sets of page numbers within one document, or start page numbering from page x, or have custom headers/footers for any page you choose. Madness, I tell you; why haven't they fixed this yet? I don't want to number my table of contents, nor create 2 separate documents!

    3. Re:Some interesting new changes in word by spectecjr · · Score: 2, Informative

      One thing that DOESN'T seem to have changed, judging by a screenshot, is the silly page numbering limitation Word gives you. You can only have a unique header for the first page, and optionally odd/even pages. You can't have several different sets of page numbers within one document, or start page numbering from page x, or have custom headers/footers for any page you choose. Madness, I tell you; why haven't they fixed this yet? I don't want to number my table of contents, nor create 2 separate documents!

      You don't know how to use Word, don't you?

      Try looking up Section Breaks, Link To Previous, and Format Page Number. EVERYTHING you're asking for is in there.

      For example, put your TOC in a separate section to your main doc, et voila!

      --
      Coming soon - pyrogyra
    4. Re:Some interesting new changes in word by jez9999 · · Score: 1

      Then what's with the 'different first page' option then? That seems obsolete if you can use sections. Maybe if it hadn't been there I would've looked up the proper way to do it.

    5. Re:Some interesting new changes in word by reclusivemonkey · · Score: 1
      1) Word's default font is now Calibri, not Arial. Calibri is a highly readable font.
      I guess now everyone who doesn't have Calibri installed will be labelled a "dinosaur"...
    6. Re:Some interesting new changes in word by Hillgiant · · Score: 1
      3)The "most recently used" list is no longer limited to the last nine files

      Yay, my #2 pet peeve with Word is fixed. Note to UI designers: If you want to limit the choices to 0-9, do not provide a 5 digit field. Now, if only ctrl-tab would do something useful, I might actually be happy.

      --
      -
  31. Ribbons sound like Office for the Mac by vijayiyer · · Score: 1

    These "Ribbons" sound like the changing palettes in Office 2004 for the Mac. I hate them. Because the palettes change, you have different functions in the same place depending on what you're doing. This makes it very difficult to get used to where you need to put your mouse. It's for that reason that programs are supposed to grey out menu items rather than change the menu - you get used to locations for a specific item and can quickly navigate there. Menus have the advantage of being out of the way, displaying the keyboard equivalent, etc. Palettes are great for tools that need to display visual feedback (such as a color picker), not as replacements for menu items. Look at Photoshop - practically no menu items are duplicated in palettes. Yet again, Microsoft shows a lack of understanding of basic human interface elements.

    1. Re:Ribbons sound like Office for the Mac by Anonymous Coward · · Score: 0

      Ribbons are completely new, replacing both menus and toolbars. They do not change depending on context (albeit some items may be disabled or enabled). What does change is whether or not a ribbon bar appears. Word has a thousand features. If they were all visible at once, they would require huge menus, most of which would be disabled most of the time. Why would you want menus for graphics, tables, equations, change-tracking, and mail merge all visible at once if you can't actually use them?

      The problem with having features on toolbars or in palettes that aren't in the menus is that now you have no reasonable way to search for a feature you may be looking for. The ribbon gives you a very simple linear search, like menus with before they were hierarchical.

      Photoshop is even worse in this respect because some features are only available by holding down a shift key with your mouse in the right place! I count over 600 menu items in Photoshop CS2, over 250 palette menu items, and about 70 tools. Much like the current version of Office, some commands are only in menus, some are only on a palette, and some you have to know where to click in your document to get them. I've been using Photoshop since 1993, and I'm still discovering features that have been there for years.

      Office has similar problems, with Microsoft frequently receiving requests for features that are already in the product. How do you solve that? By making the features more discoverable. Those palettes in Photoshop are fine, but it would be nice if there were some way to figure out what features are available without having to try every combination of clicking and shift keys. The Ribbon solves this problem.

      dom

    2. Re:Ribbons sound like Office for the Mac by man_of_mr_e · · Score: 1

      There is actually significant debate about the utility of 'greying' versus 'hiding'. Users are often confused by greying. Oh, sure, they know it's disabled, but they don't know WHY it's disabled. so it frustrates them when they want it un-disabled and they can't figure out what incantation to give to make it do that. Hiding causes uses to focus more on the context than the function.

    3. Re:Ribbons sound like Office for the Mac by AJanuary · · Score: 1

      "Menus have the advantage of being out of the way, displaying the keyboard equivalent, etc." Actually, hover over an item in the ribbon and it will display the keyboard shortcut. Press Alt and little letters and numbers appear over every componant in the ribbon. Press that letter/number to use that componant. The keyboard accessability is very good in Office12.

  32. ..fairly fast Swing interfaces can be created by oldwarrior · · Score: 0

    HOHOHOHOHOHOHAHAHAHAHAHAHAHAHAHEEHEE...Snort.. Sniff, whew! Stop it. Your killing me.

    --
    If it were done when 'tis done, then t'were well it were done quickly... MacBeth
  33. Actually, it is useful. by technoextreme · · Score: 1
    what kind of a jackass ....? use a fucking relational database! I don't want to think how blazingly slow that big of a spreadsheet would be, not to mention any dataset that large is going to almost certainly be something that is supposed to be used by more than one person at a time

    Actually, this is kind of handy despite what you are thinking. I once had to chart a large amound of data that was just x and y values. I needed to dump that data into some statistical program just to seperate it into useable values. A specialized program designed for processing data couldn't handle all of that data. Then again this was a special occasion.
    --
    Ooo man the floppy drive is broken. No wait. The computer is just upside down.
  34. Training costs = One Platform by gsfprez · · Score: 2, Insightful

    me: "Why can't we use Macs or other word processors at least?"
    IT: "training costs. Costs too much to show people how to use different software. that's why we're all Office and all microsoft."

    "training costs" excuse.... we hardly knew thee...

    --
    guns kill people like spoons make Rosie O'Donnell fat.
    1. Re:Training costs = One Platform by protohiro1 · · Score: 1

      I gather that this interface is meant to be much easier to use for novices. (I like the "task based" idea for that goal) That said, the problem with Word is that it does WAY to much. Most of the features people don't use are, in fact, useless. (word art...) I think what Word does wrong is that it lets its features get in the way of doing the real work of word processing. I would prefer a word processor that focuses on the job at hand. No layout or drawing tools other than tables. Basic, basic formating options and a simple, open XML format. Then another tool (publisher I suppose) can open this document and you can style and layout to your heart's content. Or maybe that is a bad idea. Just a thought anyway.

      --
      Sig removed because it was obnoxious
    2. Re:Training costs = One Platform by Anonymous Coward · · Score: 0

      Depending on the size of the shop, this can be very true. "Here's your new Copy of Office '07" "I don't understand this new shit" "Get used to it." And that will be it. And of course, on that premise, you could also Crossgrade to OpenOffice. But nobody was ever fired for buying Microsoft.

    3. Re:Training costs = One Platform by pintomp3 · · Score: 1

      still have the "support costs" excuse. as well as the "bulk-licensing" costs excuse.

    4. Re:Training costs = One Platform by jb.hl.com · · Score: 1

      Actually WordArt is, for better or for worse, a very used feature. School projects and things for noticeboards for a start.

      Anyway, there already is such a word processor. It's called "WordPad".

      --
      By summer it was all gone...now shesmovedon. --
    5. Re:Training costs = One Platform by protohiro1 · · Score: 1

      But wouldn't it be nice if WordPad output clean xml with XSLT styles?

      --
      Sig removed because it was obnoxious
    6. Re:Training costs = One Platform by I'm+Don+Giovanni · · Score: 1

      My mom uses Word Art all the time to make brochures for her sorority. It's not useless just because you can't find a use for it.

      --
      -- "I never gave these stories much credence." - HAL 9000
    7. Re:Training costs = One Platform by jb.hl.com · · Score: 1

      It'd sure be lovely, but up til then RTF is the best you're gonna get.

      --
      By summer it was all gone...now shesmovedon. --
  35. Monolithic cultures are vulnerable by ianscot · · Score: 1
    And if anyone upgrades their enterprise to this new version without getting rid of the older version(s), well, they need a new IT director. You _always_ upgrade everyone / everything at once to the same version. Anomolies should be kept to a minimum.

    I work at a company with well over 25,000 employees. Way to plan for catastrophic failure and massive support problems. I think we will pass on this dictum of yours -- based as it is on the presumption of incompatibility, which we really ought not to be accepting.

    Like any monoculture, IT monocultures are vulnerable to attack, as well. Not that someone using Windows would have any trouble with that...

    --
    "Fundamentalism" isn't about divine morality. It's about human authority.
  36. Outlook requiring Exchange? by rduke15 · · Score: 2, Interesting
    From 2007 Microsoft Office Release System Requirements:
    "Microsoft Exchange Server 2000 or later required for Outlook 2007 users."


    So they are still trying to lock everyone into Exchange?

    I predict this will not work. If the email in Outlook 2007 doesn't get much better IMAP support, I will push harder in my network to abandon it and replace it with Thunderbird or something else. And if the Outlook calendar doesn't fully support iCalendar for import, export AND remote WebDAV/CalDAV calendars, then it will not be hard to convince users that the limitations of Outlook are much worse than the bugs in Sunbird or Google Calendar.
    1. Re:Outlook requiring Exchange? by whichpaul · · Score: 1

      Yeah, I'm hardly holding my breath to see improved IMAP support! :-P

    2. Re:Outlook requiring Exchange? by killjoe · · Score: 1

      Does anybody use outlook for anything other then exchange? Exchange is really lame, it doesn't actually do much, it's outlook that does all the heavy lifting. Exchange without outlook is useless, outlook with without exchange is a giant pig without legs.

      OTOH I am glad outlook has after years gotten multiple calender support and RSS feeds just like evolution has. Maybe one day it will be as fast as evolution but I am not holding my breath.

      --
      evil is as evil does
    3. Re:Outlook requiring Exchange? by pintomp3 · · Score: 1

      i work at a university and we have standardized on thunderbird for imap. we have a couple users who insist on eudora and outlook. eudora because of familiarty; outlook because it lets you modify attachments (it does it in a very funky way by sending yourself a new email and deleting the old one). some users treat their inbox like their "my documents" folder.

    4. Re:Outlook requiring Exchange? by rduke15 · · Score: 1

      eudora because of familiarty

      Eudora is by far the most administrator-friendly software I know.

      - No install required. Just copy the directory to some folder, and create a shortcut.

      - All configuration in an .ini file (for the younger /. crowd who may have spent too much time with XML or the Windows registry and doesn't quite understand: this means you can compare 2 .ini files with your favorite diff tool, edit them with your favorite editor and/or your favorite scripting language, add 12 similar email accounts with Ctrl-C/Ctrl-V in your editor, search for a specific setting or value with grep/your editor/whatever, etc.)

      - Data is separated from the program, and can be moved anywhere. Just start Eudora with "c:\path\eudora.exe d:\path\to\my\eudora" and it works. Move the folder elsewhere, you only need to change the shortcut to give the correct folder as an argument. 10 years ago, I set it up in a company with shortcuts pointing to "...eudora.exe \\server\%username%\eudora", and it Just Worked, even for Windows 95 clients.

      - The icing on the cake for an admin is the settings through clickable <x-eudora-option:xx=yy> links. Instead of guiding someone on the phone through the menus, you send an email template and tell the user to click the link(s). If only Firefox and Thunderbird had that, it would be so much easier to support in a corporate environment.

      And as user, I'm actually still on Eudora myself, despite the limitations (bad HTML support, and worst of all: no UTF-8 support), because no other email client I have tried had such powerful and easy to use search and filtering. It even supports regular expressions. I have not used it often, but the few times when I did, no other email client would have found what I was looking for.

    5. Re:Outlook requiring Exchange? by pintomp3 · · Score: 1

      don't forget the wonderful adware

    6. Re:Outlook requiring Exchange? by Duhavid · · Score: 1

      Yes. It does ( did? ) POP and IMAP.

      --
      emt 377 emt 4
    7. Re:Outlook requiring Exchange? by I'm+Don+Giovanni · · Score: 1

      Besides Exchange, Outlook supports POP, IMAP, and Hotmail.

      --
      -- "I never gave these stories much credence." - HAL 9000
    8. Re:Outlook requiring Exchange? by I'm+Don+Giovanni · · Score: 1

      The "Exchange 2000 requirement" listing is meant to convey the fact that Outlook 2007's Exchange-specific features require Exchange Server 2000 rather than earlier versions of Exchange. You can still use Outlook without Exchange altogether, but if you do use it with Exchange, you must use it with Exchange 2000 (or later).

      --
      -- "I never gave these stories much credence." - HAL 9000
    9. Re:Outlook requiring Exchange? by smash · · Score: 1
      You forgot to add "badly".

      :D

      smash.

      --
      I run: Windows, OS X, Linux, FreeBSD. Just because you have a hammer, doesn't mean everything is a nail.
    10. Re:Outlook requiring Exchange? by tylersimon · · Score: 1

      Plenty of folks use Outlook without Exchange. Exchange is just awlful - expensive and hard to administer. We use it at work with Gordano messaging suite. Does all the stuff that Exchange does, is cheaper, faster and dead easy to use. There are plenty of other servers out there doing similar stuff. Simon PS - best description of Outlook I've read in years. It is truely a giant pig without legs and I would guess Outlok 2007 has put on weight :-)

    11. Re:Outlook requiring Exchange? by killjoe · · Score: 1

      Sure but it refuses to 80% of the things it's capable of if you are not using exchange. As a pure pop or imap client it's a pig without legs. You are much better off with thunderbird.

      --
      evil is as evil does
  37. Makes my documents LOOK GREAT! by TimmyDee · · Score: 2, Funny

    Wow! I can't wait for all these great new features that Office will let me do to make my documents look great!

    1. Change my fonts.
    2. Change my font sizes.
    3. Tell Word where a picture should sit on the page (c00l!)
    4. Change my margins (I never new I could do that!)
    5. 1 million rows in Excel so I can finally tell my database to kiss off.

    All this and more with a great, sure-to-be-lagless preview as I mouse over EVERYTHING!

    But don't take my Word (tehe) for it. This video tells me how my documents can LOOK GREAT!

    --
    Per Square Mile, a blog about density
    1. Re:Makes my documents LOOK GREAT! by msuarezalvarez · · Score: 1

      Urgh. How can anyone say `look great' that many times!

  38. One more version. by hullabalucination · · Score: 1
    Basic; Home and Student; Standard; Small Business; Professional; Professional Plus; and Enterprise

    I've heard that there is also going to be an Iconoclastic Demagogue version for the folks who don't fit into any of the other catagories.

    * * * * *

    I've had a perfectly wonderful evening. But this wasn't it.
    --Groucho Marx

  39. Hiding unused features: Catch-22 by ianscot · · Score: 1
    I don't like it when programs try to be "smart" and hide features away from me.

    Me too. I've never run into anyone who wants the menu items they don't regularly use to "vanish" or be available only when you choose to manually expand them. We all hate this feature. It doesn't simplify things, it complicates them by making us guess where everything is. Duh. Hint to MS and anyone else: When it's a feature we rarely use, we want to be able to find it on the occasions for which we do need it.

    Another hint: people don't honestly need a "cut" and "paste" icon on your ribbon or toolbar or whatever. Even the people who use those wouldn't miss them much. Heck, Ctrl-X and Ctrl-V and so on are among the only UI elements that are relatively consistent across windows apps.

    Now we've got "ribbons" and right-click menus and so on all changing according to contexts that we can't always guess at. Do I have a set of "paragraph" options for this text in my table, or will this border be for the table cell? Ack. Pfft.

    --
    "Fundamentalism" isn't about divine morality. It's about human authority.
  40. Re:There is a reason for this price by MikeB0Lton · · Score: 0

    You stated this suite is an ugly mess, but I must disagree. Microsoft's reasoning for making the Office product suite so large is to assist businesses. If you don't require anything beyond a basic spreadsheet and word processor, why did you purchase MS Office? Word Perfect and Quattro Pro work fine if you want to spend money, or download one of the free substitutes. The public confuses this product as something they need, instead of as a major business productivity enhancement. MS Wordpad is fine for the Junior High book report. The public is asking for simpler because nobody is learning the new features! By using SharePoint with office, you can implement a decent document library system in minutes. I guess just look at the rest of the features and see why they charge so much for this.

    My point is, if it doesn't suit your needs, don't purchase it. But please don't dog on an otherwise decent product. I do have to agree on your comment about Excel spreadsheets though :-)

  41. OOo Delay? by Clazzy · · Score: 1

    Damn, we won't get the ribbons until 2017! I may as well go out and buy copies of Office 2007 for all my OpenOffice-using friends now!

    --
    If we can hit that bull's-eye, the rest of the dominoes will fall like a house of cards... Checkmate.
  42. OOo and copying by m874t232 · · Score: 1

    Probably OOo will copy some of the new UI features. Even if the features are not a good idea, Microsoft users will expect the UI to look that way, so OOo will have to follow.

    I don't see what problem anybody would have with that. Microsoft copied liberally from its competitors to create Microsoft Office; now that they have a near-monopoly, why should other people be prevented from copying from them?

    1. Re:OOo and copying by jxyama · · Score: 1
      There's nothing wrong with copying, of course. However, one aspect of open source that's often mentioned is innovation. I'd like to see OO.o evolve beyond simply being an Office clone. Given the magnitude of the people involved, I'd like to see something innovative that's ahead of Office.

      Don't play down to cloning Office so that people would adopt it. Get ahead of the game, set the direction of the development with innovative features so that people will start saying "Hey, OO.o has these awesome features Office doesn't. And it's free. Wow, why would I bother with Office now?"

  43. Clippy? Is that you? by gregleimbeck · · Score: 0

    From TFA: "The ribbons have a dual purpose: to highlight features that users are likely to use most often or want most (but have trouble finding), and to promote features at the point they're most useful." Aparrantly Clippy is now a "ribbon". I, for one, am glad they have included this feature. Clippy always knew what I wanted to learn about in Office, and I am sure this will be just as helpful and un-annoying.

    --

    P.S.,

    This is what part of the alphabet would look like if Q and R were eliminated.

  44. Test Pattern. by Anonymous Coward · · Score: 0
    Do the test pattern: #15388865 #15388937 #15389082.

    God does not exist.

    Help each other, for god helps no one.

  45. CNET has them as well.. by Mz6 · · Score: 2, Informative
    Since the site seems to be slashdotted, CNET also has pictures of Office 2007.

    Word
    Outlook
    Excel
    Powerpoint

    --
    Hmmm.
  46. Swing slow? by MarkByers · · Score: 1
    --
    I'll probably be modded down for this...
  47. Get Use To It... by shoma-san · · Score: 1

    ...because most companies are going to adopt it if they haven't already purchased a Software Assurance agreement with Microsoft. It's the way of things - assimilate. Resistance is futile.

    But all kidding aside, most people in the business world can't find or have to be trained to find the features in Office that they have been paying for the last 10 years. Ever met an Excel guru? They're few and far between and usually harassed by everyone in their department or company. That's not a problem with most slahdot'ers so there's no possible way any of you will benefit from the new features.

    But you will assimilate. Oh yes... you will assimilate.

  48. Data processing by Colin+Smith · · Score: 4, Insightful

    I used spreadsheets to process loads of data samples, hundreds of thousands of points and frankly excel or any spreadsheet is ideal for preliminary data processing, as long as it handles the data. The grandparent should get his prejudices out of the way the fewer arbitrary limits any software has the better, what it's actually used for is irrelevant and up to the users.

    --
    Deleted
    1. Re:Data processing by Red+Flayer · · Score: 1

      Interesting point. Though, in that case, why not have a universal database and just different front-ends for how you manipulate or process the data? Like using Access and Excel, for different purposes, with the same data? EG, Access for data entry and maintenance, Excel for analysis?

      --
      "Trolls they were, but filled with the evil will of their master: a fell race..." -- J.R.R. Tolkien on Olog-hai
    2. Re:Data processing by Otter · · Score: 1

      Two more reasons why this is great news:

      1) When I get sent a huge datafile with no (or inaccurate) specifications, I can open it in Excel, examine the structure and then decide how to import it into SAS. No more messing around with less and wc.

      2) When I screw up step 1, due to a regex error or off-by-one, I can open the faulty file in Excel and quickly find the problem.

    3. Re:Data processing by ClosedSource · · Score: 1

      If the data is generated (by a data acquistion system for example) rather than entered by humans, the database just adds an unnessary step. It typically isn't very useful to process such data using SQL.

    4. Re:Data processing by IntlHarvester · · Score: 1

      Good question. I am thinking that a database table probably is not the most effiencent format for the only mildly structured spreadsheet data.

      I could care less about how people use Excel, but one thing that's always bothered me is that the database-like functions (HLOOKUP, VLOOKUP,etc) are very slow compared to a SQL query. It would be nice to be able to select a range and push a "Make DB Table" button and then be able to write SELECT type SQL statements. I'm a database developer and even I think building a schema is overkill for many tasks.

      --
      Business. Numbers. Money. People. Computer World.
    5. Re:Data processing by Colin+Smith · · Score: 2

      Because as a scientist I couldn't be arsed with the IT side of it. I had data logged in text files. Data which needed relatively simple processing. I could either have spent days writing code to load the data process it save it or I could do the same job in an hour in a spreadsheet. No brainer. Spreadsheet's easier (It wasn't excel btw because of the size of the data set).

      You can't assume tools are necessarily going to be used the way you intend them, so don't include arbitrary limits.

      --
      Deleted
    6. Re:Data processing by Master+of+Transhuman · · Score: 1


      I agree that software should generally not have arbitrary limits.

      Not relevant to the issue of putting really stupid amounts of data into an analysis medium which is not designed for it.

      Whatever analysis you're doing, odds are there is a better way to do it than using spreadsheets for that volume of data.

      The problem is: nobody ever told you, or provided you one, so you never learned to use it.

      I suppose in some cases the data being analyzed is so weird nothing but a very ad hoc method of analyzing will work with it, and in such cases perhaps a spreadsheet can be used. I find it hard to visualize this case, however.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    7. Re:Data processing by Master+of+Transhuman · · Score: 1


      If the data has any recognizable structure at all, a relational database can handle it.

      The SQL queries admittedly CAN get VERY hairy. I had a SQL instructor show us the query for a database system for engine testing data - it was ridiculous - had to be a full page of nested functions, nested SELECTS, etc. A nightmare to debug and maintain. She should have been shot for writing it.

      That sort of thing should really be decomposed into an application - and that's not a problem for any database, as almost any programming system today can access almost any database.

      Now, for playing "what if" with test data, that's another story. Still, there are tools for that purpose that work with databases.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    8. Re:Data processing by Peter+Mork · · Score: 1

      However, by locking the data into a spreadsheet, reuse is much harder. By organizing the data in a database it is easier to combine results in new ways.

    9. Re:Data processing by ClosedSource · · Score: 1

      Well, I didn't say that a database couldn't be used. I just said that it wasn't necessary or particularly useful in some scenarios.

    10. Re:Data processing by Red+Flayer · · Score: 1

      That would be nice added functionality to Excel, but if you're doing a lot of that stuff, it's easy enough to export into a DB.

      --
      "Trolls they were, but filled with the evil will of their master: a fell race..." -- J.R.R. Tolkien on Olog-hai
  49. Why all the fud here? About damn time MS innovated by Billly+Gates · · Score: 2

    MS Word is a pain in the butt to do custom graphics with menu options all over for the most basic styles. Infact there is one post here about someone writing documentation in html and just saving it as a .doc.

    The site is down so I can't see these new features like the ribbons. One of the common complaints about MS-Office is that many users request features that are already there but just hidden under a sea of menu's. MS tried with office2k and 2k3 to delete uncommon menu items in order for users to see the more options which utterly failed. Lets hope Ribbons work. I hope more advanced features like graphics and styles will be easier to implement as a result.

    BUsinesses still use Office97 so of course MS wants to innovate to help users switch. Good for Microsoft.

    I would rather have MS try to redo Office in order to sell more copies to corporate america rather than raise licensing costs in order to force upgrades.

    As much as I dislike windows and Microsoft's business practices I will say MS Office is a wonderfull app and one of their gems. It needs a UI overhaul and more groupware collaboration is what alot of IT departments need. I hope with VBA you can customize it too.

    No I am not a MSFan boy either if you read my other posts.

  50. Gee, Office 2007 .... by Compulawyer · · Score: 0, Flamebait
    .... looks just like Mac OS X 2001!

    The more things change, the more things stay the same. Plagarism is the sincerest form of flattery. Insert your own snide copy-related wisecrack here.

    --

    Laws affecting technology will always be bad until enough techies become lawyers.

  51. Available? Not quite! by rduke15 · · Score: 3, Informative
    After being bothered with the requirement of a Passport account, filling out stupid forms, click a link received in a confirmation email, you finally come to Server Too Busy which shows:
    Server Error in '/SHOP' Application.

    Server Too Busy

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Web.HttpException: Server Too Busy

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [HttpException (0x80004005): Server Too Busy]
          System.Web.HttpRuntime.RejectRequestInternal(HttpW orkerRequest wr) +146

    Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300


    So it looks like we may have to wait for Beta 3...
    1. Re:Available? Not quite! by BenHoltz · · Score: 1

      Looks like Microsoft botched the outsourcing on this one..... They should try a company in india next time.

    2. Re:Available? Not quite! by owlstead · · Score: 1

      Ha, now they know why Java does not let you conveniently forget to handle most exceptions. Unhandled exception, eh? Well, at least they now have reflection, so they know where to look.

    3. Re:Available? Not quite! by ergo98 · · Score: 1

      Ha, now they know why Java does not let you conveniently forget to handle most exceptions. Unhandled exception, eh? Well, at least they now have reflection, so they know where to look. .NET has always had reflection. Secondly, the exception in question occurred before the user code was even entered. Normally remote users would get a standard error reply with no technical details, however the developers on this site (probably lazily) enabled remote error viewing.

    4. Re:Available? Not quite! by simscitizen · · Score: 1

      Go to digg and read the comments. All the serial numbers and download links they give you are fixed so it doesn't matter anyway.

  52. Reasonable Limits Aren't by HTH+NE1 · · Score: 1

    no matter what arbitrary limit is set, someone is going to hit the boundry and be upset because they could use "just a little more".

    AKA "Reasonable limits aren't."

    It is better to make your limits be unreasonably large than to discover they were unreasonably small. Best is to not have them at all.

    --
    Oh, say does that Star-Spangled Banner entwine / The myrtle of Venus with Bacchus's vine?
    1. Re:Reasonable Limits Aren't by bryan_is_a_kfo · · Score: 1

      It's hard to come up with a good analogue to this problem, but if you give people the ability to store their massive datasets in Excel, they'll do it. A person might never ask the question "is there a way to do this already that considers the problems that arise when one does this?" My lack of knowledge surrounding the xls file format is going to bite me here, but the ability to arbitrarily reference any other "cell" in a spreadsheet would appear to build-in an unnecessary amount of overhead for any kind of large scale dataset storage or processing.

    2. Re:Reasonable Limits Aren't by HTH+NE1 · · Score: 1

      if you give people the ability to store their massive datasets in Excel, they'll do it.

      It is accepted wisdom that programs, and thus generally data, will expand to fill all available memory.

      Of course, if someone figures out a way to use the Internet itself as a nigh-infinitely expanding storage medium for virtual memory....

      --
      Oh, say does that Star-Spangled Banner entwine / The myrtle of Venus with Bacchus's vine?
  53. XPS defined! by Equis · · Score: 2, Informative
  54. Forward Compatibility by buckhead_buddy · · Score: 2, Insightful
    yagu wrote:
    If you or your company considers this, get ready for more incompatiblities with previous generations, and retro installation of plugins. That's okay within a company (to some), but think carefully about the impedance mismatch with the rest of the world.
    It's not just backward incompatibility. In this case, doing away with the traditional menu and toolbar structure is going to seriously impact forward compatibility as well.

    A spatial interface like the ribbon will require serious retraining whenever that spatial interface changes. Microsoft may change it for non-productive reasons like adding more eye candy to boost sales or for more significant reasons like adding (and removing) functionality. Whatever the reason, the interface will change in the future and any motor memory you have built will be lost (or worse cause you to select unintended options).

    Most of the user interface studies Microsoft quotes describe how easy it is to adapt to the interface from a menu based system. But that's as shortsighted an argument as judging 'file format' compatability based only on whether a new verison of Word can easily convert your old documents. While that is an issue, compatability judgement should consider the future and how much has to be thrown away when future changes come around. No doubt the 'ribbon' has two dozen patents on it so only Microsoft will be able to provide true forward compatability, but with something like a Word processor I don't think MS will have the patience, restraint, and concern to make sure future interface changes are as motor-friendly and compatible with older interface users.

    While I'm sure it's fun to play with for a few days, the Office 'ribbon' is not a tool that I'd want to get hooked on. To my knowledge, the ribbon tech is unique to Microsoft Office. Will we be seeing ribbons in Print Shop Pro and Mathmatica using standard OS services? Will the ribbon organization be consistent across applications? Why would Microsoft want to chuck and undermine the standard GUI on their OS product with a horribly non-standard, incompatible interface like the one in Office? Because it will become like an addiction. Users will be unable to get along without it and unable to give it up for something else.

    Perhaps we'll need to start a twelve step program like Office Anonymous to get people onto a forward compatible product.

    1. Re:Forward Compatibility by Anonymous Coward · · Score: 1, Insightful

      To summarize your lame arguement:

      I don't like change. Change is always bad. New ideas are changes, and are never better than old ideas.

  55. Actually Pages pretty good by SuperKendall · · Score: 1

    At first I didn't like Pages either when I started working with it. But after using it pretty havily I think they just took a different approach on some things and I really like it now.

    One of the things I like is how you can have images fixed and located on a given page, or floating along with text. That makes it useful as a DTP or as a Word replacement that handles images more reasonably.

    I do also like how they did styles and how quickly you can build an index based on them.

    --
    "There is more worth loving than we have strength to love." - Brian Jay Stanley
  56. That would make for an interesting comparison by SuperKendall · · Score: 1

    I would be really interested to see a comparison of Office on the Mac and this new Office, you're right that it seems really similar. Could it be that new Windows Office users will see the same UI mac users have been using for some time now?

    --
    "There is more worth loving than we have strength to love." - Brian Jay Stanley
  57. User interface by mlow82 · · Score: 1

    Everyone seems to complain about the new UI. But is it possible to revert back to the old UI, the same way that Windows XP lets you change the UI back to the old Windows 95 user interface? (Go to Display Properties and change the theme to "Windows Classic")

  58. The spirit of Clippy by SuperKendall · · Score: 2, Funny

    Yes, I think the spirit of Clippy lives on in the new Office, which is why your document changes as you mouse over ribbon items - it's like a high-tech Ouija board where clippy tries to send you messages from the Great Digital Beyond via subtle font changes.

    --
    "There is more worth loving than we have strength to love." - Brian Jay Stanley
    1. Re:The spirit of Clippy by IgLou · · Score: 1

      HAHAHAHAHA! I can just see it now!

      "Clippy are you with us?"
      "It's focused on the help ribbon! It means he wants our help!"

      --

      Oops, how did this get here?
      09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0
  59. UI Changes... by yobtah · · Score: 1

    Does anyone else think MS changed the UI more to differentiate Office from OpenOffice or StarOffice than to increase usability. I'm not convinced the new UI is more intuitive or easier for new users, but it definitely looks different from other competing (mainly free) office suites. It almost makes me think that's the primary purpose of the new version.

  60. Office 2007 must be a dupe! by DragonHawk · · Score: 3, Insightful

    rosewood: "Also, multiple calendars have been available in Outlook for ages. Multiple calendar viewing has been available since 2003 as well. Not the best summary in the world."

    Yah. I also noticed this:

    TFA: "Among the more significant new features: Excel 2007's new ways of visualizing data. For example, you can use conditional formatting to color the background of cells based on their value..."

    That's present at least in Excel 2003, and I think maybe as far back as 2000.

    How can someone review Office 2007 for what's new if they don't even know what's in the older versions?

    --

    dragonhawk@iname.microsoft.com
    I do not like Microsoft. Remove them from my email address.
    1. Re:Office 2007 must be a dupe! by wintermute1974 · · Score: 1

      TFA: "Among the more significant new features: Excel 2007's new ways of visualizing data. For example, you can use conditional formatting to color the background of cells based on their value..."

      That's present at least in Excel 2003, and I think maybe as far back as 2000.


      It goes back further than that. Conditional formatting works in Excel 97 as well.

      I just used that feature in Excel 97 today. As far as I could tell, Office 97 was the last version of MS Office to have significantly new features that anyone would want. After that, the programmers decided to play with the UI instead.

    2. Re:Office 2007 must be a dupe! by Anonymous Coward · · Score: 0

      The conditional formatting is of a far better calibre than before - "temperature" gradients, automatic range detection etc. Take a look at this video for a quick tour:

      http://channel9.msdn.com/Showpost.aspx?postid=1778 27

    3. Re:Office 2007 must be a dupe! by Peteee · · Score: 1
      TFA: "Among the more significant new features: Excel 2007's new ways of visualizing data. For example, you can use conditional formatting to color the background of cells based on their value..." That's present at least in Excel 2003, and I think maybe as far back as 2000. How can someone review Office 2007 for what's new if they don't even know what's in the older versions?

      I didn't know it was in there either, because I COULDNT FIND IT!

      I disovered this feature within 1 minute of opening excel.

      This is the reason the new UI is there, All the features are there, just no-one could find it.

      Point in case What do the following Word 2003 features have in common?

      * Find out the current number of words in the document

      * Use voice recognition to control Office

      * Create a Document Workspace

      * Print envelopes

      * Open the Visual Basic editor to write macros

      * Hyphenate the text in your document

      * Merge the contents of multiple documents

      * Start a video conference using NetMeeting

      * Tweak your AutoCorrect settings

      The answer is they are all in the tools menu!!!

      I also find it hilarious how MS 'dont innovate' and when they do, they get slated for it.

    4. Re:Office 2007 must be a dupe! by GaryPatterson · · Score: 1

      First Excel I used was '97 and I'm pretty sure it had conditional formatting. I know Excel 2000 does it (I did it yesterday).

    5. Re:Office 2007 must be a dupe! by AJanuary · · Score: 1

      "Also, multiple calendars have been available in Outlook for ages. Multiple calendar viewing has been available since 2003 as well. Not the best summary in the world." You can now overlay them (not sure if that was in there before. Don't think it was). "Among the more significant new features: Excel 2007's new ways of visualizing data. For example, you can use conditional formatting to color the background of cells based on their value..." Surely the most significant new feature in Excel are the tables? You can now turn sections of your spreadsheets into tables, which allow you to manipulate them as tables. There is alot surrounding tables that I wouldn't be able to cover well here, but they are *very* useful and are by far the biggest change in Excel. If you use Excel every day, your now going to use the tables feature every day.

    6. Re:Office 2007 must be a dupe! by Politburo · · Score: 1

      97 doesn't have evaluate formula (came in XP iirc) and may not have solver (came in 2000?). Both are very useful tools. Also 2003 introduced "compare side by side" which is a trivial feature but can save a lot of hassle.

    7. Re:Office 2007 must be a dupe! by Anonymous Coward · · Score: 0

      You are correct in that conditional formatting existed previously and this is an extension of that. Consider a cell with a percentage value in it. The new features enable a different colour at a given percentage, so sub 20% could be green background, 20-40 orange, and >40, red.

      Throw in in-cell bars to represent precentages or icons such as Up, Down, no change, and that's what they mean. It is a simple evolution and one wonders why these weren't there before, but for people that do dashboard type documents, they're going to be a real time saver.

      Microsoft have and will continue to cop a lot of flak about the radical change of the user interface, but it was about time, and I think that usage patterns have evolved somewhat. I'm mostly Windows-centric (ducks), but not exclusively so and firmly believe the office suite products have taken a significant leap forward with this iteration. There's a lot of good info on the MS website and channel9.msdn.com is usually full of video from the programming teams.

      For Excel (demonstrating some of the new conditional formatting stuff and the new Pivot Table stuff try http://channel9.msdn.com/Showpost.aspx?postid=1778 27)

      Hope that helps a bit (though far short of the requested review)

  61. MSFT patented them by melted · · Score: 0

    MSFT patented the new UI, broadly and thoroughly, Apple-style. So if OO.o has the balls to copy it (and face the patent infringement lawsuit immediately), they're welcome to it, I guess.

  62. Hey by kentrel · · Score: 1

    What's the fuss? I thought we all used OpenOffice, don't we? DONT WE? Free software is better right...right???

    1. Re:Hey by Anonymous Coward · · Score: 0

      I'm not a Windows(tm) guru, I just play one at work.

      However, my attempts to convert excel into a relational database with a VBA implementation of sed did the job well enough: ever tried to get the right tools for the job when that's not how things are done? Besides I don't mind that MS Office is a little hacky- I'm a geek, right?

      However, it's nothing I couldn't do in OO.org (and I could use the right tools for the job if I had *nix, for free). But what has convinced me that OO.o is a proper suite: I had to avoid editing a powerpoint presentation with macros, as PP would slow to a bizarre crawl and let me edit, but not let me see. Out of interest, I tried opening it at home (I don't have Windows(tm) installed anymore). OO.org "I can't believe it's not powerpoint" (I don't do names) asked me if I wanted the macros ("sure!") and displayed and edited the presentation with no problems.

      In other words, openoffice, in my experience, is as compatible with MS Office as MS Office is. If I find some .doc that crashes openoffice, that's a draw (and a sad statement on software in general). I'm not saying openoffice is as good as microsoft office (I'm one of the minority on slashdot that lacks omniscience), but it would work as well for me, working in a large organisation, working with other large organisations that use MS Office.

  63. Toolbars Are Now Ribbons by Kozar_The_Malignant · · Score: 2, Funny

    In related news, Microsoft has announced the when Vists is eventually released, icons will be called symbols.

    --
    Some mornings it's hardly worth chewing through the restraints to get out of bed.
    1. Re:Toolbars Are Now Ribbons by oahazmatt · · Score: 1

      In related news, Microsoft has announced the when Vists is eventually released, icons will be called symbols.

      Make it easier on everyone who has to provide tech suport for a 70 year old grandmother and just call icons "little picture thingies".

      --
      Those who believe the Internet is private,
      find their privates are on the Internet.
  64. Re:the Zimbra options by Anonymous Coward · · Score: 0

    Zimbra has collaboration software...

    http://zimbra.com/

    pieces of it are free, too.

    it looks like a nice product.

  65. Nice Theory, but reality is different by Serapth · · Score: 4, Interesting

    Thats the worst put, some of these Excel people can be dumb as dirt, but when it comes to Excel, my god they can perform wizardry. As an actual example ive seen at work, there are spreadsheets that hit the 65K limit but they are so key to peoples job functions they find "work arounds", like creating "archive" spreadsheets once they hit the fixed limit and starting a new copy of the sheet that cross references all the archives.

    Hell, ive seen people in excel basically create relational databases WITHIN excel. Dont under estimate what these people can come up with, some of its pretty damned scary.

    Plus, atleast where I am, we have HUNDREDS of Excel workbooks and pidly ass Access databases that really should be in Oracle or SQL, but at the same time, they work. Our IT department is nowhere big enough to port and maintain each of these solutions to a more robust system. Plus, people creating these systems are pretty damned good at taking ownership of them. However, if they dont create the sheet/DB that last thing they want to do is maintain it. A double edge sword really.

    For the most part both Excel and Access are necisarry evils, unless you have a huge IT budget.

    1. Re:Nice Theory, but reality is different by bryan_is_a_kfo · · Score: 1

      Yeah I hear that. I've seen some pretty amazing cobbled together stuff in Excel/Access running on some savant's desktop here and there... I guess if it works and it's cheap-as-in-free for essentially the same end result as a costly database, I cant really tear that down.

      just remember to look-real-busy when the regulators show up and start asking about quality control

    2. Re:Nice Theory, but reality is different by Serapth · · Score: 2, Interesting

      Yeah, the worst part is, if you tear down that savants Access DB or Excel spreadsheet, you had better replace it with something functionally superior. Im not saying technically superior, end users dont care about that. Im say it has to be feature complete with less bugs then the earlier system. Bug wise its normally not a problem, but feature wise it can be a nightmare. On of the biggest strengths and weaknesses of adhoc Excel solutions is the ease of customizations without involving IT. That is very hard to replecate in code, atleast in a time efficent manor. In the end, your solution may be more robust, scale better and be more tolerant to failure. Yet, if the end user finds his/her job harder, they are going to resist like you couldnt believe.

      As to audits, yeah, that becomes a bitch. Then again, half the audits out there are easy to pass with a bit of sleight of hand. Many audits have conditions like "have or are implementing a solution that does blah blah blah". The are implementing part makes it really easy to get by without any real actual work.

    3. Re:Nice Theory, but reality is different by ElderKorean · · Score: 1

      Just wait till after that Excel wizz has finished work with the company and moved on....

      And then you clean out their account a few months later - delete that old spreadsheet that seems to contains hordes of un-labelled data. Only to have half the office suddenly say that they require that (in that location) database for their daily work and that some of the data now needs to be updated.

      Fortunatly our resident programmer was able to (eventually) figure out all that the spreadsheet did and was required for. He then merged most of its functions into our own (now commented) applications.

      Neither of us had any knowledge of how old that spreadsheet was, and how important it had become to the company. We had even more fun when we started going through some of the ancient access databases around the place - mostly written by people with next to no programming style though with some skills. Not a meaningful table or query name to be seen.... That was fun...

  66. Its dead by simonjp · · Score: 1

    Due to high demand the site is temporarily unavailable. Please try it again later.

    --
    , , , , , karma elon
  67. Stupid by IntlHarvester · · Score: 0

    Its called Marketing Speak 101. OMG Look!!! We have ONE MILLION ROWS!!! SOOOO MUCH BETTER THAN THE 65K IN THE PREVIOUS VERSION.

    I remember people complaining about Excel's row limits in like 1992. It's been the #1 complaint for years, and we're long past the point where you could pretend that it is a hardware issue or something. This single thing is going to sell more upgrades than the last 200 feature combined.

    Bottom line is that "marketing speak" (give the users what they want) is better than "programmer speak" --- OMG! INTERNAL LIMITS!!! TOTALLY IMPOSSIBLE!!! USE A DB LOLOLOLOL!!!

    --
    Business. Numbers. Money. People. Computer World.
    1. Re:Stupid by mycall · · Score: 1

      interesting.. it is almost like Microsoft has been holding out on this "trumpcard" just for this 2007 release.. I wonder what they have planned for the next version?

  68. Why not an integrated document type? by Anonymous Coward · · Score: 0

    Imagine that you open the Office application.
    Imagine that you open Your Document, and you see tabs on the top

    Imagine a 3d logical structure: each tab contains... A DOCUMENT!

    Put all in one: One tab is your presentation letter, the second is your several spreadsheets on project A, the third spreadsheets on project B, the fourth Visio Graphs, the fifth Visual Basic code of the macros in the document, the 7th the HTML version, the 8th, finally, you presentatation of it all.
    A dynamic interface that lightly changes depending on the sheet and on the presumed intentions of the creator, one common single file compressed as much as possible, one single application to open. That would be an OFFICE.

    1. Re:Why not an integrated document type? by Duhavid · · Score: 1

      So, like, get busy? :-)

      --
      emt 377 emt 4
  69. Swing complaints by steve_l · · Score: 2, Informative
    You are right -people are still complaining about old bugs. Let's pick on Java1.5 swing defects.

    1. Leaks 5+MB of memory every time a laptop resumes.
    2. It often seems to lose focus on dialogs, keyboard input only comes back if you switch away to a legacy (non-java) app and back again.
    3. GTK look and feel is laughably bad.
    4. The whole GUI development model has inadequate support for testing, at least by modern (junit) processes. SwingUnit looks like the only hope there, and it still feels a bit of an afterthought.

    There, much better, a whole new set of complaints.

    1. Re:Swing complaints by Decaff · · Score: 1

      Let's summarise:

      You are worried about a possible 5MB memory leak, on machines which have typically 50 or 100 times as much memory.

      You are worried about issues of GTK look and feel on a system that has hundreds of possible free look-and-feel options.

      You are worried about minor details of testing of Swing apps, because it lacks the ability to be tested in ways that have never been available in any other GUI system.

      Is that is all you can come up with?

      I have never seen such few and trivial complaints about any development system, and I have been developing GUI systems for nearly 30 years.

      There seems to be some very strange thing about Java that means that even though, by any standards, it is the most robust and portable system ever developed, posters to Slashdot still complain.

    2. Re:Swing complaints by Bing+Tsher+E · · Score: 1

      I wouldn't say by 'any' standards.

      It's terribly non-portable to some systems.

      In the context of this thread, which is apparently machines capable of running Office 2007, you are correct.

    3. Re:Swing complaints by steve_l · · Score: 1

      the 5MB memory leak is not "5MB per process", it is "5MB every time a laptop resumes from suspend", or otherwise recreates a graphics context. That's not a minor problem, it means that the lifespan of an app is very limited if you are running it on a laptop.

      the GTK look and feal just exposes the fact that Swing is trying to emulate GTK, not integrate with it.

      I dont think testing is minor. I am a strong advocate of test driven development, and Swing is a nightmare to test. HttpUnit is much nicer for testing http pages, Xul and WinFX should be better, being more declarative. But testing swing? you'd be lucky. I can test SOAP servers hosted beyond the firewall with junit more easily than I can check that the 'commit' button on a dialog is disabled when there is nothing to commit.

      Incidentally, I didnt even get started on drag and drop between swing and the linux desktop. I think partly its a linux/X11 problem, but swing apps seem to suffer from it more than most.

      This does not mean that I dont like Java; I think it is great for coding big, complex, networked apps in. I just dont think that Swing or AWT are any good, and I have yet to come to a conclusion about SWT. The nice thing about SWT is that it is open source, though now that Harmony has a Swing implementation, maybe there is one out there I can fix.

      -steve

  70. For "regular users" by h2g2bob · · Score: 1

    For "regular users" read managers.

    Your manager will love the new "helpful" ribbon system. And soon as the salesperson comes showing them the wonderful features. "It highlights the tools you need" and "it lets you change the graph styles really easily"! ... sold!

    It's all marketing.

  71. Yes they should be demoted by aurelian · · Score: 1
    If someone in R&D can't figure out the correct tool for that job then I wouldn't trust the results of their work. If they don't have a copy of Matlab, they can use Scilab, R, Octave, SciPy, or any of a number of free and powerful tools.

    I know the syndrome: I work with a bunch of mechanical engineers and they cling to Excel like a comfort blanket because they'd rather use something they know, even if it involves tons of laborious mouse clicking for operations (like plotting graphs) that are repeated over and over again.

  72. Who Cares About Office 2007? by deathpulse · · Score: 1

    My current version works just fine - why would I pay to upgrade?

  73. Menus are Not Replaced! by DavidD_CA · · Score: 4, Informative

    I just want to point out that the menus (file, edit, view, etc) were not *replaced* by the new Ribbon.

    The old menus still exist, they are just turned off by default with the Ribbon enabled. For die-hard people who don't want to give the ribbon a try, the old interface can easily be brought back.

    I also want to point out that there was once a time when people thought WYSIWYG and icons were Bad Things. I see the Ribbon as a possible next step in the evolution of a GUI. Task Panes in 2003 were a great step forward and this might be too.

    --
    -David
    1. Re:Menus are Not Replaced! by smash · · Score: 1
      The old menus still exist, they are just turned off by default with the Ribbon enabled. For die-hard people who don't want to give the ribbon a try, the old interface can easily be brought back.
      So in other words, in the one arena where it will matter (i.e., in the corporate world where, if you don't know how to use office, and are required to, you just don't get the job), the "ribbons" will be disabled and the admin will do as much as possible to make it look like good ol' office 97/2k/xp/2k3.

      There's 3 things that make people buy office: compatibility with everyone else, because the cost of re-training is too much (which means they won't re-train for this) and excel. Microsoft could make office the most painful, dog of a program to use and people would still buy it...

      smash.

      --
      I run: Windows, OS X, Linux, FreeBSD. Just because you have a hammer, doesn't mean everything is a nail.
    2. Re:Menus are Not Replaced! by spuby · · Score: 0

      It was normal for them to give you the option to switch back to the classic view. I wonder if Vista has an option to "use classic Windows XP theme", kinda' the way XP has the option to use the classic start menu.

  74. Ribbons? by engagebot · · Score: 1

    Ribbons, eh? Well, where i come from, they're called tabs, and they're sooo 2005.

    I knew IE would be the last browser to ever get tabs, but jeez, i figured it'd have them at least before Word...

    --
    Han shot first.
  75. Nope by Anonymous Coward · · Score: 0
  76. What about assistive tech (screen-scrapers et al.) by LeRandy · · Score: 0

    Is it just me, or do you find that every version of Office seems to get further away from following the system's defined theme/UI.

    For example - how the hell does a screen-scraper work out that something looking like four crayon-ed squares is in fact a "File" menu?

    What about if you can't use a mouse? The menus let you get to the features anyway, but now there are no menus, are you supposed to remember the shortcuts?

    What if you have a limited visual field? Now instead of being able to put all the features you need on a daily basis in the same place so you can find them, they are consistently scattered about the program, meaning you have to switch modes all the time - and heaven forbid you mouse over a table while you are trying to peer at the icons...

    And if I have put a high contrast colour scheme in my setup - so that I can read the icons and menus easiest - why the hell should MS office be the only major business app to completely disregard my favoured system theme, and instead use its shiny corporate swoooshy effects on the toolbars, so I can't read them properly - every other major app seems capable of obeying the default system theme - If I use the "Windows Classic" theme, with non-standard colours, it might just be for a reason.

  77. office software commoditization by omz · · Score: 1

    IMHO this fundamental UI changes in Office have more to do with stop-the-office-software-commoditization reasons that graphical-user-interface-design ones

    so, what the final user likes or not will have minor impact in MS ( strategical ) product decisions

    1. Re:office software commoditization by Anonymous Coward · · Score: 0

      Absolutely accurate. Just a scam to keep corporate America's managers beholden to MS cutting checks for replacements of tools purchased just two or three years ago. Think about it, would you buy a replacement anything every two or three years in any other market space? But, since MS is a monopoly, they can just change the file format enought to invalidate the old tool that was sold just a couple years ago and force the upgrade expense on corporate America. No wonder the US is losing its competitive advantage.

  78. Re:What about assistive tech (screen-scrapers et a by spectecjr · · Score: 1

    Funny you should ask all this... given that Microsoft and the Office group are probably the most educated experts in the accessibility field.

    As for Screen Scrapers, try looking up something called "Active Accessibility".

    Not to mention that apparently you can turn all of this new UI flash off.

    Oh, and the high contrast scheme is a special setting in Windows - Office will obey it. Trust me.

    --
    Coming soon - pyrogyra
  79. Re:What about assistive tech (screen-scrapers et a by LeRandy · · Score: 2, Interesting

    Thanks for replying, I'll eat my words (mostly). Anyone with mod points feel free to mod down (my) OP.

    I did see somewhere that C|Net reckons the menus can't be forced to reappear - but you can hide the ribbon - but the proof is in the pudding.

    However, my comments about obeying the system theme remain. If you fit into one of the predefined categories eg. "High Contrast", then Accessibility will make Office obey - but what if, for example, you are dyslexic, but read better on a pink background. There is some evidence to support that simply changing the colour of "white" improves the ability to read the text. Office won't obey that, because it doesn't fit in to MS' idea of "assistive tech".

    I personally don't have too many sight issues, fortunately. However, with the switch from Office XP to Office 2003, I found that the gradient (coupled with the more cartoony look of the icons themselves) made it harder to discern what they were. And I found the blue toolbars when you have Windows in "Fisher Price - Blue" mode lurid, and overly distracting. I searched high and low to make the toolbars flat again so I could see what I was doing, but apparently MS knew better.

    Functionality wise, I'm happy with Word '03 - I don't hate the app. (I don't use it any more though - LyX is my new best friend - WISIWIM-U "What I see is what I mean - usually")

  80. Menus collapse under their own weight by koolraap · · Score: 4, Insightful
    The Office 12 blog http://blogs.msdn.com/jensenh/default.aspx is a good place to read the reasoning behind some of the design decisions. Whether you agree or not with the changes, their motivation seems to be sound: improve the user experience.

    Making features easier to find/discover is [apparently] one of the biggest benefits. Word has a zillion features, and most people use about 10.

    Anyway, I'd recommend the blog as an interesting read for those people interested in user interface design for a product with hunderds of millions of users.

  81. But she's got a new hat! by quickbrownfox · · Score: 1
    Seriously - MS, openoffice is carving away the "Office 97 provides all our needs" segment & the collaboration market you're so eagerly chasing is... well lets say I don't think its got the potential you think it does.
    Girl 1: They changed Malibu Stacy!
    Girl 2: She is better than ever!
    Lisa: She still embodies all the awful stereotypes she did before!
    Smithers: But she's got a new hat!
    --
    Repo man's always intense.
  82. NOT quite TRUE (in caps) by theolein · · Score: 2, Interesting

    Outlook works and 'collaborates' quite well with ANY Mail server I just spent a few months maintaining a Java application that sends, amongst other things, ICal attachments to Outllok clients attached to an Exchange server. ICalendar is an RFC, in other words a standard, and its been that way for years. But Exchange mangles any attachment that it sends on to Outlook (used to crash Outlook 2000, now just won't work in Outlook 2003/Exchange 2003) Exchange does not understand the mime type text/calendar. Neither does it accept standard fields in the ICal itself. The company for whom I was doing this application had a trouble ticket with Microsoft and Microsoft openly acknowledged that Exchange server does not understand standard calendar attachments, but that they would not fix it. EVER.

    The thing is, if Microsoft would bring out a version of Office that was bug free, no one would ever buy upgrades. Even with this snazzy new interface (or perhaps because of it) I cannot see it becoming an overnight success until years have passed and companies have to upgrade because Microsoft no longer offers support.

    OSS often is a royal pain in the arse, but Microsoft's marketing tricks negate a lot of the technical wizardry they otherwise show.

  83. this is heresy and must be stopped by SpaceballsTheUserNam · · Score: 0

    If we let them do away with the "file, edit, view, ...." standard then what are they gonna try to get away with next!?!?!?!?!?!

    --
    \.
  84. This is braindead by Master+of+Transhuman · · Score: 1

    "Bigger spreadsheets are available in Excel -- over 1 million rows and over 16,000 columns per worksheet"

    Anybody who puts that much data in a spreadsheet is a complete fucking moron.

    There's a time to give up spreadsheets and go to databases and that's about when the spreadsheet needs to be scrolled more than a few times in any direction...

    A spreadsheet is nothing more than a crippled visual database with the ability to automatically calculate calculated values. Duh...

    This is merely an example of adding "features" just to have a marketing bulletpoint.

    --
    Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
    1. Re:This is braindead by GaryPatterson · · Score: 2, Insightful

      This comes up again and again.

      As an SQL Server developer, an Excel 'power' user and someone who manages about 20GB of statistical and performance data, I reckon I've got a clue here.

      Show me a sample piece of SQL for calculating a cumulative average, without linking a table to itself, creating a new table or other weirdness. It's pretty hard.

      What about a running total for certain criteria? Or percentile calculations, or means, standard deviations and so on?

      SQL is just not good at statistics, even simple stats. It just can't do it without a *lot* of effort.

      SQL-based databases are ideal for filtering and simple calculations, but terrible at doing real work with numbers. Sometimes Excel is a far superior solution to the best and brightest database.

      A few pages in any direction? You've clearly never seen corporate spreadsheets or looked at numerical quality methodologies (such as Six Sigma)!

    2. Re:This is braindead by Master+of+Transhuman · · Score: 1


      Nobody said use SQL for statistics.

      You use SQL to withdraw data that matches certain characteristics.

      Then you pass that data to a tool that does statistics.

      It's that simple.

      And I've seen corporate spreadsheets - back in the mid EIGHTIES, I supported spreadsheets - up to 57 LINKED spreadsheets in one system - for Fortune 1000 Treasury customers for BofA. That's WHEN I learned you shouldn't do this crap.

      --
      Richard Steven Hack - This sig is TOO GODDAMN SHORT TO DO ANYTHING USEFUL WITH! MORONS!
  85. Re:Why all the fud here? About damn time MS innova by I'm+Don+Giovanni · · Score: 1

    The reason for all of the FUD here is that for all of the demands here that Microsoft "innovate", deep down, most slashdotters don't *want* Microsoft to innovate because that makes Microsoft all the more difficult to compete with. For example, Office 2007 makes OpenOffice.org look rather primitive, so many slashdotters feel compelled to belittle any and all of Office 2007's improvements. To put it in simple turms, Microsoft haters are scared that Office 2007 will blow the competition away.

    --
    -- "I never gave these stories much credence." - HAL 9000
  86. Nope - the old UI is too overburdened to maintain by I'm+Don+Giovanni · · Score: 1

    The features in Office already overburden the old UI as it is. So trying to maintain that old UI for Office 2007's new features and the features that will be added in subsequent releases becomes an exercise in futility. Also, Microsoft truly believes that after a short learning curve, the new UI blows the old one away, and want to encourage (if by force) people to use it. Otherwise, peeps would be tempted to stick with the old UI even if they would've vastly preferred the new one.

    --
    -- "I never gave these stories much credence." - HAL 9000
  87. Pine 'colaborates' quite well also by bogie · · Score: 2, Informative

    "Outlook works and 'collaborates' quite well with ANY Mail server,"

    Uh, no it doesn't. That's like saying Pine can collaborates quite well with any mail client.

    "if your Mail server supports POP3 or IMAP, you are quite set with Outlook."

    If by set you mean using only half of what Outlook offers I guess we agree. If everyone was quite "set" by using ANY mail server with Outlook why the heck do you think the OSS community has been going nuts for over 6 years trying to make a real exchange alternative?

    The grandparent is right. Bottom line is Outlook leads to Exchange, Windows 2003, AD, and a lot of other stuff. Your flat out lying if you say otherwise. It may not "require" it out of the box but that is where installs ends up going many times. Anyone whose been in IT for a few years and works with Microsoft products will back me up. Mind you I'm not even saying this is a bad thing, its just the way it is.

    --
    If you wanna get rich, you know that payback is a bitch
    1. Re:Pine 'colaborates' quite well also by Anonymous Coward · · Score: 0

      You're talking out of your ass.

  88. Java 1.5 is hardly an improvement. by Anonymous Coward · · Score: 0

    Actually, the last three deployments have been using Java 1.5. We got the exact same comments regarding the Swing applications feeling slow. This was coming from people who couldn't tell Mac OS X from Windows, let alone a Java app from a C++ app.

    While the 1.5.x JREs are indeed better than the earlier ones, they still are only approaching usable. Non-technical people do notice the difference, even if they have no idea what Java is, or even that it's being used. I really don't know what to tell you. You seem quite hard-set in your idea that it isn't a problem. But speaking from experience, it is a very real issue.

    It will be most interesting to see if Microsoft is able to make this new GUI design performant in any way. Does anyone know if this version of Office uses WinForms or .NET in any way? The one .NET/WinForms-based app we developed received many of the same complaints regarding performance as did the Swing-based apps. If they are using .NET, it may cause problems for those users who are still only running machines with 1 to 2 GHz processors, and only 512 MB of RAM.

  89. Re:XPS open? by Anonymous Coward · · Score: 0

    I go to their "Specification" page and have to go through a very ornery click-thru license agreement basically retaining all rights to Microsoft. Then I find the link, and it appears to be an .exe program that installs a Word file, and this is the specification itself. I'm on a Mac, so it appears that I am unwelcome.

    I don't want to hear about this thing again until either ECMA or ISO have voted.

  90. But I *did* try Office 2007, and was unimpressed by linguae · · Score: 1
    Of course, with Microsoft involved, you know that 80% of these comments are saying it'll be a crappy product without even having tried it.

    I'm not in that 80 percent, even though I don't know where you got those numbers from. I did try out MS Office 2007 Beta today. I was completely unimpressed. Simple things from items that used to be in the Standard and Formatting toolbar (such as Open and Chart in Excel) required two clicks instead of one. Some tab choices (such as in Excel, Chart was under Insert instead of Data or Formula; how intiutive is that? In Excel 97-2003, it is on the default toolbar) were completely unintiutive to me. Zero customization of toolbars and menus are allowed; if you don't like it, tough. Almost everything that can take me one click (or two clicks at the most) in Office 2000 required extra clicks in Office 2007. My text seemed double-spaced anything I pressed with ENTER by default (I had to click on a different style to get it to ). When I uninstalled Office 2007 and reinstalled Office 2000, I felt a sigh of relief. Office 2000 allows me to adapt the application to my needs (customizing toolbars, for example). Office 2007 wants to force me to do tasks the way that the "grand UI gods" want me to do it, whether it is suitable for me or not.

    I'm not opposed to learning new things. I'm currently learning LaTeX, which is a very good typesetting language and packages that produces high-quality documents. I constantly learn new programming languages and other subjects. Learning is my passion. However, when you are learning a tool, you want to work with tools that are best for you. MS Office 2007, frankly, doesn't cut it for me. It feels like a downgrade from MS Office 2000 (and some would say that MS Office 97 is the high water mark for Office, but I use 2000 instead of 97 because of better compatability with dealing with 2002 and 2003 documents).

    Now, in defense of Office 2007, I would say that they have done a spectacular job with font anti-aliasing; I felt that I was using an OS X machine (compared to Office 2000). Office 2007 did open my older Office documents quite well. However, it isn't worth the purchase to me, and I'll still hang on to my Office 2000 disk. Just like many WordPerfect 5.1 users still haven't "upgraded" to MS Word, I won't "upgrade" to MS Office 2007; if I must buy MS Office, I'd get the latest Mac version (provided that they don't Vistafy that version).

  91. YAY!!!!! by Anonymous Coward · · Score: 0

    I LOVE OFFICE!!! YAY!!!

  92. Ribbons =! Tabs by AnEmbodiedMind · · Score: 1
    Actually, in Office 12 ribbons are organised into tabs.

    Ribbons are better seen as toolbars on steroids.

    Each ribbon is accessed via a tab, hence your confusion.

  93. Another Ten Years by rssrss · · Score: 1

    So, I guess I will be using my copy of Office 97 for a while longer.

    --
    In the land of the blind, the one-eyed man is king.
    1. Re:Another Ten Years by Anonymous Coward · · Score: 0

      Or you can use OpenOffice instead

  94. Re: Bet it Shares Cust Info w Competitors Better by Anonymous Coward · · Score: 0

    Chances are it shares the confidential data of customers not key to the MS plan for global monopoly much better with competitors. How can it be that there are no competitors allowed to survive in this key desktop productivity space. A product consisting of several hundred, or even thousands of DLL's, is like a building with 8,000 doors: impossible to secure.

  95. Arm chair usability engineering by AnEmbodiedMind · · Score: 1

    As in your parent post, you should read Jenson Harris' blog.

    Until you've read the meat of that you really can't comment to intelligently on what their goals are for the massive user interface changes in Office 12.

    This is a real risky move for MS to move away from menus, and if you read the blog you can see that every decision they have made is carefully reasoned and then tested with users in the lab. They can't afford not to.

    They have also been conducting tests examining learning time and impact for new users - to measure the obvious confusion that will be caused by the change.

    The Office usability team have no problem with menus in general (or toolbars as long as they have text labels). They are trying to address a different problem - the fact that Office's rich and deep functionality has out grown those interface models. There is so much in the product that people can't find it all and there is nowhere to put new and useful functionality.

    (You can argue that Office just has too much functionality - which is probably true for some classes of user - but that is another argument!)

    This isn't about UI issues from the last 20 years. This is about issues for the largest and most complicated applications the world has ever seen being used by "every day" users, and how to expose only the functionality that they need when they need it.

    Ribbons are just toolbars on steroids, plus _CONTEXT_

    Why present the user with a table menu and all of it's functionality when you aren't working with tables?

    Time will tell if the ribbon solves these problems, or just causes more, but your arm chair judgements of their worthlessness based on your "20 years" of reading usability studies is pretty weak if you don't even seem to know they problems they are trying to solve.

    1. Re:Arm chair usability engineering by VGR · · Score: 1
      As in your parent post, you should read Jenson Harris' blog.
      I have read it. I read it yesterday, and I remember reading a few pages of his, some months back.

      I'm afraid the only thing I get from it is that he and his coworkers mean well.

      I see a lot of "we're doing this in the name of usability" but they don't seem to understand the point of usability. The point of usability studies is to find out if your software changes are helping the user's productivity, not to let the user chime in with a wishlist. At the risk of sound elitist, it is we the UI designers who should be deciding the look and feel of software, not the users.

      When I read such blogs with "we're doing this because the users demanded it" I get the sense that they're just taking the easy (or, more likely, cheap) way out instead of sitting down and thinking about how to address the user's concern in a way that's genuinely an improvement.

      I'm kind of reminded of that Simpsons episode where Homer's long lost brother (played by Danny DeVito) lets Homer design a car. Customers should be describing their needs, not telling engineers how to fulfill customers' needs. That's why we give engineers money: because they're supposed to be more schooled in designing products that meet customers' needs.

      --
      The Internet is full. Go away.
  96. Give me a fucking break. by Ayanami+Rei · · Score: 1

    If you're doing any kind of engineering analysis in Excel, you need to learn some new tools.
    It's called Matlab. If that's out of your reach, there's Scilab. Anything but Excel. Christ.
    That's like repairing a computer with a fisher price mallet.

    --
    THIS THING CAN TURN ON A DIME, MACROSSZERO STYLE ALSO FUCK BETA, ~NYORON
  97. Ah!!! by Anonymous Coward · · Score: 0

    You've never used it, but you hate it. You don't know why it was made that way, but you hate it. You don't care about the numbers behind it, but you hate it. You've never seen a returning using who found ten 'new' features that they have always wanted that have been in the app for years, but you hate it.

    You're journy to the Dark Side is compelete.

  98. Use Excel TO PARSE A LOG FILE???? by Ayanami+Rei · · Score: 1

    What are you, a fucking imbecile?
    It's called awk and grep. Jesus fucking christ.
    If you deal with log files on a daily basis then you better learn to use some decent text processing tools.

    --
    THIS THING CAN TURN ON A DIME, MACROSSZERO STYLE ALSO FUCK BETA, ~NYORON
  99. It's the same "draw" widget as the rest of office by Ayanami+Rei · · Score: 1

    nt

    --
    THIS THING CAN TURN ON A DIME, MACROSSZERO STYLE ALSO FUCK BETA, ~NYORON
  100. Durrr... by Ayanami+Rei · · Score: 1

    It's called head. And tail.
    Head and then open in Excel. Why would you try to open the whole thing at once?
    Use tail to get an idea of the range of record IDs or whatever.

    --
    THIS THING CAN TURN ON A DIME, MACROSSZERO STYLE ALSO FUCK BETA, ~NYORON
    1. Re:Durrr... by Otter · · Score: 1
      Let's start with two simple cases:

      1) I work with one application that takes textfile input with hundreds of thousands of columns. Even head -n 1 won't open in Excel.

      2) The error is in line 522,867 of 857,024. How am I going to find that in tail?

      Obviously I can do these things at the Unix command line, plus some scripting.But why should I, if there's an easier way?

  101. If you're guys in R&D... by Ayanami+Rei · · Score: 1

    ... can't work their way around a copy of R or Scilab (free), then I think they should be fired.
    That's like a administrative assistant who can't speak english but can sign ASL really well. *eye roll*

    --
    THIS THING CAN TURN ON A DIME, MACROSSZERO STYLE ALSO FUCK BETA, ~NYORON
  102. New UI is a huge improvement by MaxPower2 · · Score: 2, Insightful

    I do not believe that most people posting here have any idea of what makes up a good UI design. Microsoft has made a vast improvement over previous version of Office with this new UI. The interface is very intuitive and displays functions that can be used in well laid out way. There is great feedback from this user interface with most actions. They have almost eliminated difficulties that arise when using the mouse. Do you know what most users have a problem with when using a computer? I will give you a hint, it rhymes with "house". Why do you think that the mac OS places their menus at the top of the screen? It is so that a user can move the mouse all the way to the top of the screen and only have to worry about moving the mouse horizontally when selecting a menu (makes it a lot easier to select a menu this way). Back on topic, no more selecting menus and trying to position the mouse in the correct place to expand other sub menus. Functions are now quick and easy to select. When scrolling through areas such as fonts, the document is updated in real time. However, I do think the file stuff could be improved. The equation editor stuff is a good add to Word. How can you not like being able to quickly insert a integral symbol or many specific functions such as a Taylor Expansion? I believe that this new UI will be easy for all to use and will leave the user happy. Come on people, give some credit where some credit is due!!!!!!! Also, for those who are complaining about the Excel spreadsheets having too large of a capacity and that users should be using a database should do some homework before they post. Have you ever heard of Excel Lists? Guess what, you can make a Excel spreadsheet into a database. Plus, you should never place constraints on a user unless there is a good reason for it.

  103. "Making features easier to discover" by Error27 · · Score: 1

    Whenever I use office I'm like, "This thing has a blasted lot of features." I've never had a hard time discovering features. Even when I don't want to find features I discover new ones.

    Seriously, it does seem like the wrong goal.

  104. How many posters on this thread. . . by Anonymous Coward · · Score: 0

    are on the MSFT payroll? "I am on a mac but they may have gotten it roght"? puh-leeeeze.

  105. Re:Nope - the old UI is too overburdened to mainta by Anonymous Coward · · Score: 0

    No, if they keep the old version of the UI for compatibility, they will have a huge burden to maintain, and will never be able to get rid of it. To this very day you can hit slash in Excel to access the menus because that's the way Lotus users were used to doing it 20 years ago.

    Managing one UI for thousands of commands is hard enough; managing two is twice the work. Additionally, anybody making an add-in for Office 2007 or higher would have to make their UI twice because they don't know which mode their users would use.

    dom

  106. ms outlook by mcn · · Score: 1

    did i still see toolbars in outlook? and it was still the tube-based rounded ugly toolbar. why was ribbons not fully extended across all apps in office?

  107. Re: Is SlashDot Owned/Financed by Microsoft? by Anonymous Coward · · Score: 0

    How did this site evolve from a vendor-neutral discussion of information technology to become a forum for Microsoft to preach its religion? Seems like a few hours ago the lead headline was not "SharePoint Not Required", as it is now.

  108. Re:There is a reason for this price by Anonymous Coward · · Score: 0

    >> The public confuses this product as something they need, instead of as a major business productivity enhancement.

    Unless im mistaken and correct me if i'm wrong the .doc extension is a closed specification and the most widly used document extension. I am also aware that OpenOffice has incomplete compatability for the .doc extension. I've tried this and things go all over the place when you open a .doc file created in OpenOffice, in MS word. What are the larger companies going to think when they open the document and it's an ineligable mess? Their just going to get really pissed with each other and the IT dept cos' ITS ALWAYS THEIR FUALT REGARDLESS OF THE TCO WE SAVED.

    I'm trying to get at, yes they do need to buy microsoft office because the .doc extension is far to convenient to ignore.

  109. Excel is a DATA MINING tool by Habahaba · · Score: 1
    None of you do data mining?

    Excel is very widely used data mining tool (see: http://www.kdnuggets.com/polls/2006/data_mining_an alytic_tools.htm).
    It is used both to analyze smaller sets (less than 100 million rows :-) and preliminary reports from larger sets. In practice, the data is seldomly in the DB when it is being mined because that is just so darn slow (unless you have bought a multi million dollar systems - in which case you absolutely have to use is even though it sucks as otherwise somebody has made a stupid desision to buy it...). How long does it take to open small (60 000 rows - to be able to do it today) data set in Excel and then for example do a pivot to it to see all the combinations of the values? Not time at all. Now, import that to your relational database and do the same report from there.

    The 65k rows limit was very limiting. The first time I tried OpenOffice I immediately checked the limit there... my surprise was huge when the limit was 32 000 rows (not even 2^15 or 2^16 as in Excel). And as Excel 2000 otherwise beats OO in usability, I didn't look at OO any more.

    So, get rid of all the limits! Why should it not be more than about million rows? I can see no reason. (Yeah, if the computer is too small then it doesn't fit into the memory, but that's a different thing.)

  110. Contextual UI is NOT an adaptive UI by AJanuary · · Score: 1

    I have seen alot of people, and some people here, make parallels between the contextual UI and adaptive UI's and making the same conclusions as to the problems. They are, however, NOT the same thing and don't have the same problems. Adaptive UI's are constantly changing, so you cannot learn where things are because they will not be there the next time. Contextual UI's DO NOT CHANGE. All your old tabs are still there, all the Write, Review, Insert, all in the same place. If you need to get to something, it will always be in the same place. Contextual tabs just hide the things you don't need when you don't need it. Who the hell EVER needs to have the "Format Table" options unless you are inside a table? Ever? So why not hide it until you are in a table, and then show it? That is what the contextual UI does and that is how the improved vastly on the mass of toolbars of old. If you look at the research they did (echoed by many people), they found litteraly hundreds of people would have dozens of toolbars open because they were afraid if they close them, they would lose them and not be able to find them again. But most of them are things like Format Image, which are dissabled the whole time until you select an image. The new UI open and closes the relevent things for them, meaning the UI cleans up after them as they go, making the whole experience alot nicer.

  111. Bug in spelling setup by The+OPTiCIAN · · Score: 1

    There's some pretty snazzy features there.

    I wonder if they've gotten around to adding the feature where if you install Microsoft Office on a system set up for Australian English it installs the British English dictionary, rather than installing the American English dictionary and making you jump through hoops to get it to work the way that it should work by default. It perplexes me that they can do so much in the way of magic, yet after however many releases of the product something as basic as this remains broken.

    En-route you get to learn neat morsels about the way Word is architectured. For example - trying to fix it through one strategy it appears to keep 'losing' the setting you've set up. What's actually happening here is that the text already in your document has been localised as US English, and whenever you move into those blocks the setting reverts back to that based on context.

    The default is wrong on the oldish version I've tested it on for the Mac but it was a lot easier to fix than for Windows.

    Either way, I don't buy the "well it's possible to configure it" excuse for stupid defaults: in order to fix a default installation you need the original install CD (and I think you need admin privileges as well). Many users never bother and end up with documents that get frowned on because Australia is standardised on UK English. And when I'm that user and I don't have the ability to fix it and the local sysadmin thinks it's unimportant it annoys the hell out of me.

    --


    Believe with me, my saplings.
  112. Yet another lack of backwards compatibility by frdmfghtr · · Score: 1
    I found this little bit interesting:

    Though not new in Office 2007, the suite now uses a Zip-compatible XML-based file structure. In Office 2003, this format was available as an option; in Office 2007, it's the default. While you can still open and edit .DOC files in Word, files are automatically saved in DOCX format.

    These new file formats are not backward-compatible with earlier versions, though Microsoft has said that a conversion add-in will be available for Office XP and 2003 users.


    Note the lack of mention of saving in .doc format (although that doesn't mean it's not there). While I can't recall using a Word file that used features that weren't backwards compatible, I imagine that the "vendor lock-in" and "forced upgrade" arguments will fly far and wide with this one.
    --
    Government's idea of a balanced budget: take money from the right pocket to balance...oh who am I kidding?
    1. Re:Yet another lack of backwards compatibility by FrankNFurter · · Score: 1

      You can save files as Word 97-2003 .doc. You can even tell Word to use the old file format as default. Imagine that.

      --
      "Slashdot - the one place on the internet where guys brag about how small it is." - that IT girl
    2. Re:Yet another lack of backwards compatibility by frdmfghtr · · Score: 1

      I pointed that out already, as the article did NOT say that the .doc file tpe wasn't available. The lack of mention was conspicuous.

      --
      Government's idea of a balanced budget: take money from the right pocket to balance...oh who am I kidding?
  113. Bigger spreadsheets! Cooool! by LordSnooty · · Score: 1

    Cos I'm forever landing on cell IV16384 and wishing that I could add just one more column.

  114. Excel tables by DragonHawk · · Score: 1

    "Surely the most significant new feature in Excel are the tables? You can now turn sections of your spreadsheets into tables, which allow you to manipulate them as tables."

    Okay, that sounds interesting, I think, but isn't a spreadsheet already a table? Do you have a more in-depth explanation, or maybe a link to one?

    Thanks...

    --

    dragonhawk@iname.microsoft.com
    I do not like Microsoft. Remove them from my email address.
    1. Re:Excel tables by AJanuary · · Score: 1

      http://blogs.msdn.com/excel/ and search tables (the search isn't working atm, so I can't link you directly). That has several posts on tables.

  115. Risky, My Arse by pwhysall · · Score: 1

    It's not risky at all. The corporate world is so locked into Office that if MS decided that the Office UI were to be implemented in the the moon language of pink unicorns and the colour octarine, they'd still all buy it like clockwork - despite the protestations (correct or otherwise) of the Slashdoterati.

    Office 12 is going to continue the proud Office tradition of raking in the cash and keeping MS in the pink.

    --
    Peter
  116. Mmm... by Ayanami+Rei · · Score: 1

    Excel is for the VISUAL EDITING of a limited set of datapoints with manageable dimensonality.
    You aren't supposed to try to load your whole dataset at once into it, only a representative subset. Why would you use an application that tries to load every single datapoint into memory at once just so you can run batch processing type functions that operate on subsets at the data at a time? It's not like you are going to tweak any individual cell. It just seems ass-backwards.

    No, there are plenty of better tools. For example, Programmer's Notepad or Texpad, which will allow you to visually examine the head -1 to see the exact column layout and make a good guess as to the seperator between fields of various types.
    If your error is in the middle, (detected by WHICH program, I might add? How would you scan that many lines in Excel visually to find that problem anyway?) you could just use a sed statement with a line notation (or an expression that MATCHES the kinds of errors you're having) to elide the ill-constructed line.

    If you can't reasonably expect to spot the problem by visually scanning in Excel over the cells because you've got datasets that large, then you shouldn't be using a visual tool anyway.

    --
    THIS THING CAN TURN ON A DIME, MACROSSZERO STYLE ALSO FUCK BETA, ~NYORON
  117. a collaborating office suite? why not an O/S? by master_p · · Score: 1

    It's nice to have a collaborating office suite (sharing docs and all that), but wouldn't it be better if everything the O/S offers can be shared?

    For example, let's say that I want to make some game art. If the O/S was collaborative, I could be in one office painting the textures while at the other room the game developers test the textures in real time.

    That would be true innovation, Microsoft.

  118. Intuitive, yes (imho). New? No. by cyborat · · Score: 2, Interesting

    The concept of doing away with menus and making the available tools show in a sub-section of its own (what Microsoft here is calling 'ribbons') is nice, but not new.

    Autodesk, for example, had a very similar system down pat in 3D Studio Max years ago. I have seen many other apps utilizing this system through the years, and happen to like it.

    Of course, shortcut keys via keyboard are often the best for repetitive stuff, but for many re-used commands, it has always been an annoyance to repeatedly have to scroll through ever-lengthening menus to perform simple tasks.

    Having a nice layout of buttons available when in a 'menu mode' is a good idea. But it's not new. However, I wouldn't be suprised if Microsoft patents it.... *sigh* (or have they already?)

  119. MS Exchange Loving of iCal by SkiifGeek · · Score: 1

    I am sure that you are aware by now that MS06-019 specifically addressed a set of issues that Exchange had with iCal and vCal MIME types. Perhaps your attachments were somehow partially exploiting the vulnerabilities in Exchange and were thus being mangled on the way through.

  120. Thanks for the link (Excel tables) by DragonHawk · · Score: 1

    "http://blogs.msdn.com/excel/ and search tables (the search isn't working atm, so I can't link you directly). That has several posts on tables."

    Cool. Thanks for the link. A quick glance seems to indicate tables aren't anything new from a structural point of view, but rather, a lot of smaller features that make using a speadsheet a lot easier. Which is all to the good.

    --

    dragonhawk@iname.microsoft.com
    I do not like Microsoft. Remove them from my email address.