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."

36 of 495 comments (clear)

  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. 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 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
    2. 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.

    3. 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.

    4. 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"
    5. 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.

    6. 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?

    7. 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?

    8. 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?

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

  5. yuck! by Garabito · · Score: 2, Insightful

    UI looks like MSN Messenger!

  6. 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.

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

  8. Given all the rant about new features... by jxyama · · Score: 4, Insightful

    I assume OO.o won't be "copying" any of them, correct?

  9. 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: 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.

  10. 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 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).

    2. 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...
  11. 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.
  12. 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.
  13. 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.

  14. 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
  15. 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.

  16. 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.

  17. 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.
  18. 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.

  19. 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.

  20. 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.

  21. 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.

  22. 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)!