I'm at my first company that uses Google apps and it's been a bad experience. There's so much about email and calendaring that Outlook/Exchange got right that it's hard to be without it after taking it for granted.
Using a native rich application is always going to be superior to building a web app on top of a browser. Once you're used to real applications, Gmail and the other apps aren't suitable for anything more than light usage. It's not just the features that are missing, it's UI responsiveness and usability. Hosting an application inside a browser is so awkward in ways that real applications aren't. I can't assume I can right click and get anything useful, I don't know if I'm going to get the browser's menu or the app's. The concept of a consistent menu bar you can access with hotkeys is gone. Online/offline will never be seamless and consistent across apps. And the input lag is intolerable.
Having all of my documents stored centrally is a real, but small, convenience to get in exchange for everything that's given up. And as far as cost goes, I'd prefer that any money my company might be saving be deducted from my paycheck if it would mean they'd get off of Google apps.
I recently went through an acquisition where we transitioned from Google Apps to the Microsoft suite. I do not share your love of Microsoft's suite.
Among the many problems I have with the Microsoft suite, Outlook is at the top of my list for generating the most frustration. GMail's priority inbox and new-style inbox where machine learning is used to sort out mail is a productivity booster for me. With Outlook, I regularly lose important mail because it is buried under the difficult to filter masses of other email.
I could go on about how the lack of robust collaboration facilities are a direct time waster for my team, but I don't want to hijack this thread further...
To the OP, insisting that apps running in browsers will never match native apps in terms of UX, that's a very audacious claim.
There are many powerful, competent, and well-funded entities with a vested interest in improving the web app experience (including Google). I wouldn't claim they're doomed from the start. This could be just another example of a disruptive technology, that's initially lacking in certain conventional metrics, but has a lot of room for improvement above and beyond the entrenched competition.
> There are many powerful, competent, and well-funded entities with a vested interest in improving the web app experience (including Google). I wouldn't claim they're doomed from the start.
I've been using gmail for almost 10 years. I liked it from the start. But it's getting worse, not better. It's extremely slow compared to what I'm used to with Exchange and Outlook, and navigating around is more of a chore. How do I, for example, see who's in on an email list? I can't just right-click on the name of the list and see the members? (And don't even get me started on the new compose experience mess.)
If Gmail was being continuously improved, I'd have a reason to be optimistic about it. I like being given free storage, but as far as usability goes, I have fonder memories of Eudora.
A lot of it is due to the limitations of HTML. For example, HTML is why Gmail paginates about as well as PHP app from 1998, instead of allowing you to just scroll through all of them like a native client.
Nonsense. FastMail's webmail allows you to scroll continuously through (or jump to any section of) your mailbox, even when they have 100,000+ messages in them. (Disclaimer: I work for FastMail). This is not an inherent limitation of the underlying technology, just one of implementation.
> For example, HTML is why Gmail paginates about as well as PHP app from 1998, instead of allowing you to just scroll through all of them like a native client.
No, its not. HTML + JS, via AJAX, supports infinite scroll with a finite amount loaded at any given time. IIRC, Google has used that on Google Image Search and some other properties.
There may be web platform associated performance or other considerations behind pagination, but its not a fundamental can't-do limit of the technology.
Pagination does have it's advantages, namely:
- Linking
- Easier to grok where you are in the result set ( 3 out of 5 instead of the scroll bar that changes height)
That could definitely be part of it. Outlook isn't dumbed down because it's not primarily aimed at home users. Maybe Gmail makes sense for few people in the office the way Outlook makes sense for few people at home. That doesn't change the fact that the bandwidth/latency profiles are different going to the server room in the building than going out to the internet. But I might see a big improvement over what Gmail is now if Google was being designed for business users.
For starters Google could of kept compatibility with the activesync protocol instead of making calender sync with outlook the horrific monster it is today. Actions like this are just one of the multiple reasons I tell people to not invest invest Google business products.
Because I could then build the entire interface client-side in a browser?
Don't get me wrong, I'm not a webdev guy. I have no front end/fullstack experience. I'm a longterm sysadmin/DevOps person. But if you're a power user, you want control over your mail interface/workflow. In that case, all your mailserver should be doing is accepting email for you, storing and indexing it, and serving it via API to clients you're using. I like IMAP, but it doesn't easily support some Gmail conventions (multiple labels per message).
IMAP and SMTP could easily be condensed into an XML/JSON API that could be done over HTTPS; I'm not familiar enough with CalDAV to say that though.
I believe ops point was that any stable api would be preferable to: "Yeah, there's an api, but we refuse to document it, and we'll randomly depricate stuff if you try to use it to build something that isn't gmail". The team behind gmail is probably one of the best qualified to hammer out a working api for email of json (what we have + a bit of what we want + stability and versioning). No reason why they couldn't publish that as an RFC and let people implement a front end for dbmail or whatnot that spoke the same api.
Gmail should not be indicative of whether or not web apps can match desktop apps. It should be indicative of whether or not the engineers behind Gmail have focused on making it work as well as a desktop app (they have not).
They've spent a lot more time making Gmail Offline work well. Maybe sometime in the future they'll spend time optimizing; but it's probably not a priority
>> It's extremely slow compared to what I'm used to with Exchange and Outlook, and navigating around is more of a chore.
Its performance is fine from what I see every day. Plus it integrates with my phone and my home Linux desktop via the browser very nicely. Navigating is different but not worse than Office by any stretch, just my opinion.
Some of us don't like any of the current alternatives.
In my opinion Gmail beats Outlook for mail, but Google apps are not really enterprise-ready for calendar and docs. Editing a document offline is not a feature that should just now be becoming sort of usable, it should have been fundamental from the beginning. Confusion between Google Apps and personal Google logins is common. Managing a Google calendar is painful, and basically has not improved at all in years.
I have no desire to go back to using Office for everything, but I have very little confidence that Google is actually going to spend much effort in getting things right for these use cases either.
They are set back and certainly extremely limited from the start. Native means you have almost unlimited capabilities for interacting with the user and their system. A browser application by definition is much more limited. The experience is always improving but it's to get the point that native applications have always had -- and they still have a long way to go. And the nature of browser based applications might mean that it can never happen. The browser is layer between the solution and the user and it will always interfere in some way.
Not having to attach files for even the slightest change is so much better. I really miss working for a company that uses google apps.
Everything was online and centrally controlled. Jira, Confluence, AWS, Github, MediaWiki (some of these were self-hosted), and google apps.
I have always preferred centralised computing, you can visually see the headaches and frustration drop for IT support technicians when they don't have to deal with minor printer, file, or collaboration issues. The kind of issues that were created by the "PC" in the business environment.
> I'd prefer that any money my company might be saving be deducted from my paycheck if it would mean they'd get off of Google apps.
Sysadmin here. How much are you willing to pay? I'll need at least 2 domain servers, exchange server, backup server/device/nas/tapes, etc to give you a stable and recoverable environment. I'll need an air conditioned server room/closet as well and a decent UPS. We'll need to pay for offsite data storage as well. How many people? We'll need CALs for each user. Licensing even for a trivial environment is easily 5 figures. Not to mention my salary.
I guess you could go with some shitty MSP and small business server, but not if you actually value your company, uptimes, and data.
Cloud services aren't big because they're good. They're big because they're cheaper than guys like me and all the stuff we work with. Your boss understands this. He's expecting you to deal with it.
If he's unhappy with cloud responsiveness, I doubt he'll be happy with yet another remote provider. Considering google apps are best in class, I'm not sure anything but a local approach would work here.
>so there is no need for a local installation.
At the very least, bossman would have to spring for some Office licenses. Oh, and probably a TS server and other toys so Joe Worker can work from home.
Maybe office365 would work better for them? On /r/sysadmin its nothing but horror stories though. Also who do you fire when they lose all your data or you can't get mail for a week? MS's techs will be happy to write "please do the needful" helpdesk responses and laugh because you're such small potatoes to them.
I would agree with you that excel is still more powerful than google spreadsheet but I don't agree that's because of native vs web type of app, because gmail is more powerful (and faster) than outlook. So let's call it subjective and give it a rest.
The main reason we switched to google apps is collaboration: all the features in the world do not really matter when the whole team can open and edit a document at the same time and work on it seamlessly.
How is Gmail faster than Outlook? I've used both for as long as they've existed, and both for work and personal use, and don't see where or how Gmail is faster.
Not going to bother with the more powerful comment. This being HN and all I'll give you the benefit of the doubt and assume you're simply not familiar enough with Outlook, rather than trolling.
I've switched to gmail some 4 years ago and before that was Outlook user since the 90es; that means I'm not familiar with the latest office version but it's not like I'm speaking without any experience.
Gmail has one of the best keyboard shortcuts ever, thing that always anoyed me with Outlook was that focus would get stuck between two panes and the only way out was to click with mouse. With few labels, powerful filter and incredible search, yeah I would say gmail is more powerful than Outlook. But like I said in previous comment, let's all agree that it is subjective.
What's definitely not subjective is Gmail being faster in search which still baffles me (outlook being slower). But having more than 10GB of email being searched almost instantly is something that I never managed to do with Outlook (and no, I never did have nor wanted to manage exchange server).
To play devil's advocate - isn't the reason you're sorting so that you can find information more easily? Aren't you manually performing search yourself?
While not perfect, I think searching for "from:sender" is more efficient than sort by sender.
Yes, my thoughts exactly. Gmail has a different philosophy of working with data (search instead of sort) and I've noticed more than once that some people refuse to make that mental switch.
Ever wondered why sorting is an option at all? Search requires you to know something explicit about what you're looking for (without a search term you have nothing).
How about sorting by subject, email size or whether an attachment exists or not? Search is great, but only brings you to the item you want. After that you might want to explore related items (such as a mail from x that contained attachment y you can't remember the name of).
Outlook has a different philosophy of working with data (sort instead of search) and I've noticed more than once that some people refuse to make that mental switch.
What's happening here is consistency - our nearly obsessive desire to be (and appear to be) consistent with what we have already done. Once we've made a choice, we encounter personal and interpersonal pressures to behave consistently with that commitment. Usura sung a great song once. It was called "Open your mind".
So you're saying that when you don't have a suitable search term, you can sort a really long list of messages in such a way that scrolling through the whole thing is an efficient use of your time? Or is that even when you do have a suitable search term?
I'm saying that others' reality isn't always like mine. That there are many ways to skin a cat. That every point has a counterpoint and when I get an email from someone called Diue Donne or something which I always misspell that it's easier to soft by sender, hit D and scroll for a bit.
If they're not using a machine with SSD drives, then searching in Outlook can be slow. Otherwise I'd agree that Outlook is snappier except for the abominable keyboard shortcuts (and the hoops you have to jump through to set up anything approaching gmail-style/vim-style keyboard shortcuts).
At my last job I used Outlook and was very frustrated by the speed of searching my mail. Outlook seemed to take ages; Gmail on the other hand excels at searching.
Disclaimer: I don't have as much experience with Outlook as I do with Gmail. And it could very likely have been the backend at my last place.
Searching always been pretty much instantaneous for me at work. But when I used Outlook for my personal email it was terrible and I now use Thunderbird at home for superior searching. So I don't know -- probably everyone here is right.
Maybe Gmail can be fast when you have a small inbox and a low-latency internet connection. I don't remember complaining about the performance early on. But now it takes 3-10 seconds to switch to a label.
I'll give you maybe Excel, but for a standard document (and really most spreadsheets, which for me admittedly aren't very complicated and the real-time sharing is more important) Google Drive kills Microsoft's offerings to me.
Especially mail. Gmail and its web interface are far superior to Outlook in usability, far less frustrating experience to me.
Basically I disagree that 'native' apps will always be superior here. Docs and Gmail are already superior on the web IMO.
This is how a disruptive technology starts. Google Apps doesn't have to be better, but the idea is that one day, you'll find Google Apps "good enough", with all the benefits of being online (and now offline, too). You're just on the higher end of the power-user curve, but your "good enough" day is approaching.
I'm not sure why we give so much credence to legacy users complaining about new software (tech in general). Specific use cases are either adaptable or they'll work their way into the new whatever as demand grows. For example, I never dreamed of using my iPad w/ usb keyboard as a laptop replacement. It's not perfect, but it's rapidly becoming my preferable method of computing when I'm not at home.
I agree completely. Google apps have already come a long way. Even right out of the box, I liked the spreadsheet functionality. Excel is great for complex projects but for simple data storage, I find docs to be easier to use.
I believe they were the first to auto sum columns in the bottom right hand corner, a feature which excel later added (feel free to correct me if i'm wrong). Something simple like this can be great for quick projects. I also like the ability to share within a group and allow multiple people to edit it. Imagine how much longer it takes to pass an excel sheet to 10 people and have them edit things.. I like the new update to edit without making instant changes that others will see.
More to your point, I would say that the spreadsheet app is definitely "good enough" for basic use but the word copy in docs needs some work. I like the share-ability feature, but I think word is better in almost every way.
Exactly how I see it, Google sheets is adequate for my useage and if I need more then I can download a .xlsx or .csv and do more but so far, for my use case, that's unnecessary.
I completely agree. I'm not impressed by the new features of Google sheets when desktop apps have had these features (and much more) for years and years. Sure, Sheets runs in a browser which is an impressive feat, but it can't match the speed, responsiveness, or the much richer interactions possible with a desktop app.
Plus, if I'm running a desktop app I can be pretty sure it's not tracking and recording my every action. Can the same be said for when you sign into to use Google Sheets?
They (Google Apps, and Office) are different. People who cannot take the time to adapt to different will always find the 'other' system inferior to the one they know.
That's very specious to claim that's why someone would disagree with you, but I didn't have an opinion about Google Apps at first. It was only after spending a year using it and learning its differences and limitations that I thought it was inferior. As a software developer for 15+ years, learning new applications is not a difficult thing.
Fair enough. This is how I reason to that particular statement. My observation is that the judgment of 'superior' or 'inferior' requires a standard. In the absence of an unbiased exemplar, the first exposure and use becomes the 'default' standard. Further, that exposure tunes the work flow to minimize 'pain' which creates a pattern of behavior that achieves an objective at reduced pain (a trained workflow).
On the exposure to a new system, the combination of using the previous system as the default exemplar, and using the trained work flow that the previous system encouraged, results in the second system being rated 'inferior' to the extent that it does not exactly duplicate specific characteristics or support exactly similar workflow.
Sure, people, including myself, do find the familiar appealing. But you can't extrapolate that to assume that any/most preference for existing standards is based on that instead of an actual understanding of which standard one prefers.
It would be equally wrong and cynical for me to discount opinions for imagined reasons like, people who fit a younger or tech-friendly profile latch on to new technologies for the sake of being cutting edge, or that people in an industry that benefits from adoption of web apps would be biased towards Google apps. (Though the temptation exists.)
I don't think I've ever disagreed with a statement that stated "System A is different than System B, and I prefer {A/B} because I find it easier to use." My comment simply disagrees with adding an unqualified ranking to a system. "A is inferior", "B is superior" without some definition of an exemplar. Someone could say "Windows Office is superior to Google Apps when working on documents without network connectivity." That is a ranking, and a basis for the ranking. I can agree or disagree with the choice but I understand it.
To the extent that I could understand it, the OP argument was that it was worse because it was different. And it is that claim I disagree strongly with.
I agree with you and have often thought that this dynamic drives programmer psychology as well. It explains a lot about, e.g., programming language adoption, that is puzzling otherwise.
I'm also at a company that's a 100% Google Apps and so have been forced to make a good go at it.
- Gmail is great for near-term communications, having chat in the same place makes it a nice communications hub for immediate and near-term communications. I like it better than Outlook and it seems much snappier in day-to-day use.
But I find it almost unusable when looking for emails from a while ago. It's so bad that I connect to my mailbox with Thunderbird and use Thunderbird's search to find anything. The problem is with the threaded conversations, I'll get search results, with the result buried somewhere in 1 of a 100 different emails in the conversation and as far as I know there's no easy way to sort through that pile.
- Calendar is actually pretty good. For my use as good as Outlook. It integrates nicely with Gmail and gets the job done. It's also pretty snappy in day-to-day.
- Document is okay for very simple things. Collaboration is a killer feature. But it's missing many of the things that makes Word superior. It's bad enough that people in my company who interact with anybody outside of the company are on the list for a personal MS-Office license...pretty much just for Word. The review functions (comments, change tracking etc.) in Word is absolutely needed if you work on any kind of contract/proposal paperwork. I find that I quickly exceed the formatting abilities of of the web app without getting into anything too fancy.
- Sheets is also okay for very simple things. However, my accounting department sends me a pretty simple traditional spreadsheet showing timetracking for my staff and it's totally unviewable in the web app. I'd rather just use the web app then firing up Excel, but I simply can't.
- I don't think I've ever bothered with the presentation app or anything else in the suite, but that's all I really need to use. TBH, it's actually a pretty nice suite that gets me about 70% where I need to be. However, all our internal tracking tools (Atlassian tools) really want documents instead of links to shared on-line docs so you end up importing/exporting everything as word docs anyways.
but I have to say I think that this (2nd, 3rd?) rewrite of sheets looks really good. I'm going to try it out the next time I need to deal with staff time.
If you can't find it in GMail, then how on Earth do you find things by Googling them?
Ten minutes spent learning how operators works will save you hours of time. Google was right when they said 'archive everything' and that folders were a terrible idea.
For #1, Hit the "Expand all" button (it's the one to the left of the print button at the top of the entire conversation. Then use Ctrl-F to search within.
I'll be honest, I had not thought to look next to the print icon for an expand all button and unless you told me what that was I would have had no idea what it was for.
> I'll get search results, with the result buried somewhere in 1 of a 100 different emails in the conversation and as far as I know there's no easy way to sort through that pile.
Expand the conversation and use the built-in browser search.
As a power-excel user I agree with you that Sheets isn't quite there yet. Trying to use the same shortcut keys that I'm used to often makes me want to bang my head against a wall, either because they don't work at all or because even if they do, it's not as responsive.
However, the pace of improvement is one that I think you should definitely consider before saying "never." Excel hasn't fundamentally changed for me since 2003 (outside of being able to more easily handle larger datasets from 65K+), so it seems like a fixed target while sheets continues to move closer (still with large gaps ahead!).
If I need to do financial modeling, I'll likely continue to use excel. However, for many low-touch projects, I've almost completely switched over to sheets, which wasn't the case even a year ago.
We use excel with pivot tables to explore data. The previous google sheets had such low limits it was pointless. The new one helpfully says "Sorry, an error occurred when opening this file. Please try again." on trying to open a 40MB uploaded CSV. Back to Excel I guess. I also LibreOffice on my Linux machines, but it is slow, single threaded and harder to use with pivot tables.
People forget that you used to boot your PC into a game disk to play a game. When people started playing games in Windows (full-screen), people like the grandparent poster would RAIL that booting to a game disk would always be superior to building a game on top of Windows.
We still have consoles, which get much better performance for the given hardware. True they can't compete with desktops even with the inefficiencies built in, but that is not relevant.
The web faces fundamental limitations as long as it is built on the current architecture of JavaScript, CSS, and HTML. Windows, being a general purpose OS like Linux, has far less restrictions.
Honestly, I'm always surprised that games can even run on top of windows and all its accouterments: anti-virus, indexing, random services, etc. I'm assuming there's some API in windows that lets games tell Windows to chill while the game is running.
In 20 years I predict I'll still prefer executing code at the local OS level to thin client code hosted within an application running in the local OS. And having the application state updated after accessing local memory rather than after communicating across a network. We don't have to wait 20 years to experience the benefits of hosted applications, we have them today. And they sounded good to me. But after enjoying those benefits, I'd still give them up for the reliability and responsiveness of native applications.
what about gigabit net connections? When you run into the limit of a single worker's capability, you employ a second worker! (that's the reasoning behind modern processors btw). And thus, speed of light isn't an issue....
I wouldn't count on this:
> Using a native rich application is always going to be superior to building a web app on top of a browser
I firmly believe there would be no "native applications" within 10 years of time.
Outlook is very easily the the application that I hate from bottom of my heart. You are correct that other alternatives are not that good either and that's why Outlook still lives on. Even in 2013, its search feature is laughing stock. It hangs all the time, takes up lots of memory, rules can't be other than presets, its ranking function is sort by date, it can't do spam, TODO list integration is mess, it blocks good attachments, it can't keep conversation togather, it screws HTML and even its spell check is straight from 18th century. If you look at release over release enhancements, it pretty much has remains same, as if there is no one really working on it. Outlook is a shame to human kind considering so many people has to use it despite of it being a pig.
Wow that is so far from my own personal experience it's difficult for me to understand. I am occasionally forced to use Outlook and/or Excel and it tends to ruin a large part of my day. Real time collaboration isn't just a cute convenience, it's the primary staple of my workflow. Strange to have such differing experiences.
That's interesting. We just went the opposite direction, from Office 365 to Google Apps and we couldn't be happier. Office365 was slow, riddled with issues and a poor experience for anyone who used a Mac. Literally awful; we often couldn't talk between offices on Lync because of "reasons" according to Microsoft.
Switching to Google was like a fresh breath of air.
> Using a native rich application is always going to be superior to building a web app on top of a browser.
Depends on how you define "superior."
Word has a lot more features that Google Documents, but if I don't need them...
Personally, I am more than happy to use Google Docs over MS software. Google stuff doesn't take 45 seconds to load. Formatting rarely goes awry. It has the features need. I can access docs from anywhere and share with anyone and they don't have to install anything or even load an application to view it.
I'm not here to defend Google apps (although I use them everyday) as much as web apps in general.
> Once you're used to real applications
What makes an application 'real' as opposed to 'not real'? Did you mean 'native'?
> It's not just the features that are missing
One potential upside to web apps is that, by constraint, a lot more thought needs to go into what should be included and what should be left out. For example, I find a lot of features in Word, Excel, etc. to be completely unnecessary and, moreover, counterproductive. A stripped-down interface, and even functionality set, does have some advantages.
> I can't assume I can right click and get anything useful
Often the case for native apps, although - admittedly - less so
> The concept of a consistent menu bar you can access with hotkeys is gone
Ditto. OSX almost solves the former at the expense of the latter. Applications like Chrome break the single-menu paradigm, though. Windows has a host of applications that invent their own menu styles/behaviours.
> And the input lag is intolerable.
Which specific file type? I rarely have problems with documents or spreadsheets.
> Having all of my documents stored centrally is a real, but small, convenience
It's a massive convenience for me. Dropbox is a good alternative, but I never want to go back to the days of having to remember to carry a specific USB stick everywhere I go and/or using network drives that are a nightmare to access anywhere but the office.
I've had the opposite experience while working with a company of <200 employees and several locations needing to have a set of communication tools to efficiently collaborate in real time. We're using the query functionality in Google spreadsheets to automatically parse data input by a variety of staff through Google forms for meetings gathering people often through Google hangouts. We're also able to make instantaneous and ubiquitous changes to training documents, policies, and other items (e.g. procedures) without worrying about versioning or if an old photocopy of a policy is still be used. I can't speak highly enough Google apps in this type of environment. We seriously considered Office 365 (which seems to focus almost entirely on getting you back to the desktop) but the inability to real-time collaborate on documents (at least at the time) was the first of many strikes against that suite as a viable option. YMMV depending on what you need to do, but for fast-paced collaborative work I can't imagine working without Google apps.
> I can't assume I can right click and get anything useful, I don't know if I'm going to get the browser's menu or the app's. The concept of a consistent menu bar you can access with hotkeys is gone.
These are differences in the web UX paradigm, not differences in the capabilities of the technology. If Google wanted to build a web app "for people who were used to native apps," it could work and act exactly like this.
In fact, web apps built to work inside native-app containers (Adobe Air, node-webkit, etc.) frequently do do this, and it's quite hard to tell that the result is a web-app at all. See, for example, Light Table.
care to elaborate what things you're missing? I'm using Outlook/Exchange at work and find it extremely painful to work with. in Gmail i can get everything accomplished w/out using a mouse, it's really easy to label and go to labels, perform advanced searches sand easily create filters out of those. I'm using some Outlook plugins (i.e. ClearSight) to ease the pain but those have problems of their own. Even silly things like replying to an email in "sent" folder to include my previous response, Outlook defaults to replying to me so i have to "reply to all" and manually remove myself.. where as in gmail i can just hit "a" or "r" and it will know what i'm trying to do .. it's quite beautiful when you utilize more of the keyboard shortcuts.
I have to say that I find the gmail experience vastly superior to thunderbird with my work email. There is something to be said for having a server do all the work instead of my desktop.
Thunderbird is currently my #4 memory hog, behind java and firefox, on a computer that routinely hits 100% memory usage.
Is it possible that maybe you're jus tnot a GMail power user? Given the choice between Gmail and Outlook, I choose former seven days a week, and twice on Sunday.
I went from a fully MS Office company, to a different company that used Google Apps, which was recently bought by another company that uses MS Office (that we are now moving to). I've had extensive experience with both products at this point.
===Outlook vs Gmail===
Outlook has a lot of things going for it. One of my main complaints is the functionality difference between the PC and OSX versions of Outlook. Outlook on the Mac just isn't as polished and is missing a number of features that the PC version has. On the plus side of Outlook, it has much more powerful searching/sorting abilities. You can sort messages by a large number of fields. Searching allows you to filter on different fields as well. The big part of searching is that Outlook will do substring searching (gmail will only match on whole words).
Gmail excels at labels and visual presentation. As it is geared towards the basics that a user will need, a lot of data that you just may not care about is hidden away. This makes the bulk of what is important more visible. Also, I feel it presents long email threads in an easier-to-follow manner. Plus, once you learn keybinds in Gmail, it works the same on PC and Mac (which is totally different for Outlook). The other big plus for Gmail is proper handling of HTML. Outlooks HTML engine is pretty atrocious.
Calendars: both are pretty comparable to one another. Outlook is nice as you get desktop alerts even with Outlook closed (google can do this with the 3rd party apps). But Google is nice in that you can set multiple people as being able to edit/update an event, so management of events can be easier.
=== Word vs Docs ===
I'd say the only way Google wins in this is collaboration. Being able to work on the same document with multiple people at the same time is such an amazing feature, I'm sad to lose it. But at the same time, there is so much that Google Docs just can't do. So much advanced formatting, numbering bullets, and layout that it just isn't all that great at. If you just need simple documents, Google Docs can handle it, just don't expect anything too fancy.
=== Excel vs Sheets ===
Sort of the same argument as Word vs Docs. Collaboration is amazing in Sheets, but it misses a lot of advanced functionality and formatting. It's ok for basic stuff, but don't try to do anything to advanced.
Funny enough, in this category I feel Apple's Numbers is a really great tool. The D&D game I'm part of uses a Numbers sheet to handle characters, and one of the big features I like is embedding multiple tables into a single view (something Excel or Sheets can't do).
=== Powerpoint vs Presentation ===
Powerpoint again is similar to the Word vs Docs argument. Collaboration is the one main feature Google wins at. Google Presentation has 2 major issues for me: 1) it doesn't auto-resize text if you go beyond the size of the box (it just overflows). 2) layout of slides can slightly differ between edit view and presentation view, which can be very annoying.
=== Word vs Docs ===
I'd say the only way Google wins in this is collaboration. Being able to work on the same document with multiple people at the same time is such an amazing feature, I'm sad to lose it.
You can collaboratively edit Word documents in Word 2010 and SharePoint:
Office 365 Word does it without the need for SharePoint (both in the Word web interface and the Desktop app). It's terrible, I can't recommend it. The number of crashes and sync-losses we had was ridiculous.
Am I the only one that is distracted by the name "Google Sheets?" It doesn't exactly roll of the tongue, awkward to say and doesn't exactly scream "spreadsheets" when placed next to other Google Docs (Drive?) products. It can just as easily have been a presentation tool, or something else entirely. Although, it's probably ambiguous only to me and for most other people, sheets == spreadsheets.
Ha, no you aren't. Has it always been called that? My first reaction to the submission title was "what in the world is google sheets?"
I almost always use the word processing part of Docs, and maybe 10% spreadsheets (and maybe like .5% presentations), but I guess I just always refer to "google docs", saying "make a spreadsheet in docs" if I have to be more specific (or "in drive", though I'm still resisting that for going less descriptive of what I actually do with it with the new name).
Eg, to add 30 rows, select 30 random rows, no matter what they are, as long as your selection is 30 high. Then you right click the row area, you get the option to insert 30 rows.
Who does UX for these products? Surely this didn't test well?
Thanks for the tip! That's faster than what I do. I still wish they add a dedicated shortcut for it though so that I can do it with one keystroke (like the Ctrl + Shift + "+" in Excel).
Have you tried it? You select N rows, it then says Insert > N Rows Above and Insert > N Rows Below. I've never had any problems inserting rows, but perhaps I'm not using the product the way others do.
I didn't look it up at all. Took me a few seconds initially to acclimate to the UI, find the "Insert" menu and try a couple things. I don't feel like their methods for inserting make perfect sense, but I've never had a problem with it.
I agree that selecting rows via the column headers makes sense a one way to insert N rows, but having a general Insert context menu for unselected usage would also be helpful.
It works almost just like in Excel.
Select row (or 30 if you need them, "shift + space" is the shortcut, same as Excel) Then go to Insert menu (Ctrl + ⌥ + I) and then W.
It's been years and still Google only implements offline mode in docs for Chrome? This looks shameful, but perhaps there is some reason that Google people reading HN can explain?
From what I can tell this requires a Chrome app from the Chrome Web Store. So it is not standard HTML5 stuff. Does Google intend to fully support non-Chrome browsers? This behavior seems to show otherwise.
While it is hard to say what Google expects to do or not to do, it does seem like Google are building an app platform on Chrome in parallel to the so called web app platform (HTML5 + Javascript).
Spreadsheets had (view-only) offline capability via Gears as far back as 2008 (see http://googledocs.blogspot.co.uk/2008/04/view-your-presentat...) but this was then discontinued in favour of the standards methods. FWIW, they have been helping with the HTML5 storage APIs from the beginning.
If it worked in Chrome outside of the store, it would be more plausible. But requiring the Chrome Store seems to indicate it is not using just standard HTML5 stuff like appCache. The issue of limited storage or not seems insufficient to explain this.
With DART and Go and Google Fiber, all one company. It kind of worries me to be honest. Overall though as long as Larry and Sergei are there it should be OK I think.
Google can't force other browsers to implement features. If it's only available for Chrome, it is possible that the features they need are not available elsewhere.
fast - check. Powerful - check. Works offline - check.
Let's get a little closer to google docs...
Works online - check. Edit in browser - check. Edit on mobile device - check. Share with other people - check. Cheap - check (o365 sub is really cheap per seat). Can customise the UI - check. Can deal with huge sheets - check. Can extend, script etc - check.
I use MS Office occasionally at work but even that small amount of usage has me wanting to use Google Docs instead.
-Someone has the Excel file open on the network? Oh, read-only for you my friend. Have to save? Better track down whoever has it open.
-No revision/change tracking. Have to always be alert as to who is changing what and when. Often simpler just to make a new file and add to the clutter on the network folder.
Actually this is a hang back from the COM interface. There is a Name property which is used to uniquely identify the document.
To be fair, I don't think I've ever had a problem with this unless I was being thrown Sheets/Docs via email which is a really bad thing to do to start with. Email is not a suitable document archival system!
Have you actually used office? It has change tracking, diff and merge and has done for over 10 years. The problem here is network locking which is totally different.
Yes if you want it you can. Then again you can also enforce change tracking by policy.
Regarding SkyDrive, you're talking rubbish. It's been there for literally years.
Right click a document in skydrive and select "Version history". You can review every version, restore earlier versions and open the changes up in Word if you have it installed and review there.
If you go "big" and use O365 you can review and accept, annotate all changes and commit to sharepoint for example from your desktop app.
You can even wire it into review workflows so that commits are staged and reviewed by an editor, people are notified etc. This is great for legal documents, contracts etc.
Have you used Google Docs collaboratively with another person? While I type, I see what you're typing.
If you instead use Excel files stored on the network, and you and I want to "collaborate" on a document, at best we're ping-ponging the file back and forth to each other. Sometimes we collide, and have to Merge - which is very painful if we've made any kind of extensive changes.
Suggesting Sharepoint / SVN is a reasonable solution to how to collaborate is like suggesting one telegraph system over another. It's not remotely the same thing, at all.
Office 365 is much better, granted. But the SkyDrive interface is no better (and in many ways worse) than Google Docs.
Yeah I have actually. It's horrible and really unreliable when document sizes get realistic (40+ pages). Not only that it's so easy to fuck up the document structure badly.
I wouldn't use Excel files on a network. I'd use a database or chuck the xlsx into SVN. Changes to complex data need to be managed. Don't expect miracles. There are edge cases where Google Docs will get this wrong. Sync needs human decisions made occasionally.
See my other comments about usage of SVN/Sharepoint and the use cases.
Office 365 is sharepoint. Skydrive is actually a variety of sharepoint. The interface isn't great but neither is google docs, which is why larger companies tend to just use Sharepoint Workspace which is a desktop app for accessing sharepoint portals.
Isn't that just another point in his favor? It's easy to say "you're doing it wrong, just learn how to use these other technologies so Office works correctly", but most users would obviously prefer a product where "doing it right" is the default behavior. I'm speaking of course only with respect to the feature being discussed here (collaborative editing); I don't have much of an opinion on Office vs Drive overall.
Not really. It's a known problem since the dawn of computing: How do you control multiple users accessing a binary file cleanly over the network?
The solutions that are generally accepted as the right solutions are:
1. Version control systems. So in this case, SVN or Sharepoint (yes it is a version control system for documents).
2. Collaborative editing.
3. Synchronisation.
In favour of point 1 which I always suggest using, history is possible to tie to a user always, centrally controlled, archivable on your own site, actually really easy to manage and allows people to work entirely offline. It scales to mega-sized documents as well. Imagine our typical formal specs (sorry we're too finicky about quality to do agile) which are 200-280 pages long in Google Docs?
Point 2 can lead to odd corruption. If you've ever actually done any collaborative editing with 2 or more people on Google docs or dealt with the crock of shit that is Numbers or Pages and iCloud on the Mac you'll know where I'm coming from.
Point 3 is just the transport layer for 2 and 1. OneNote does this, very well.
So the point is moot. Just because it complains at you that you're doing it wrong, doesn't mean the technical solution doesn't require some work on your part.
The $0 Google Docs is correctly priced for what it offers: spreadsheet functionality for the lower 80% of the market that doesn't use advanced features and most likely wouldn't pay for a solution
I don't know if you just really like the platform, or you're on Microsoft's payroll (as this is HN, I'm guessing the second), but you're coming across as the hard-shill.
Good to see filtering is finally a client-only action. It always struck me as strange that what was effectively a view change (on the order of scrolling through the document or changing the active page) propagated to other collaborators.
Big fan of gdocs here. Some of the new functions are going to really be great. My only complaint is the display changes. The default row size has increased to 21 from 17 and size 10 font no longer fits in a 17 pixel row. The best option now is size 9 font on 19 pixel rows. It may seem nitpicky, but when I design a spreadsheet, I use a lot of screenspace and this really adds up.
I'm skeptical of the claim that it's more powerful. Running a simple performance test, 10,000 formulas of the form:
B1=MOD(A1+32,1000)
re-evaluation takes about a second, which is slightly slower than the old version. For reference, Excel can do 1,000,000 of these formulas, significantly faster.
As an ex-excel power user, this is a huge step in the right direction. F4/F2 now seem to work. Unfortunately there is no way to turn of editing directly in cells. There are strange bugs like auto column sizing doesn't work correctly. Merging cells is a cancer, it would be nice if the drop down offered centering across selection.
While this is still not Excel for windows, it feels better than Excel on the Mac. I think I will start using it.
Spreadsheets have pretty much been the same for the past 10 years so it's good to finally see some movement in this area. For a time being, I was sure that Google gave up on spreadsheets.
I am curious: are documents in Google Sheet scanned by Google's software bots to determine stuff about me? I can't seem to find a Privacy Policy document specific to documents in Google docs. How about if I pay for the service (can I pay for the service)?
- I can explicitly name and lock a given version (i.e. a checkpoint). This is a huge missing feature at my company, where we rely on collaboratively-edited spreadsheets
I've used ms office and google apps for years. For lightweight day to day use, google, hands down. Nearly every document I create is shared, and MS as of a few years back doesn't compare. I haven't tried the new office.
For serious spreadsheet work with layout requirements, Numbers, easy. Yes, Numbers. For super-serious something or other I hear Excel is unbeatable, but I don't know what functions Excel has that google doesn't, let alone Numbers, and Numbers has the one feature every spreadsheet should have and almost none do (certainly not excel/google): allow two sheets on a single page. How often do you have to juggle column widths/cell merges to get different layouts in two parts of your worksheet? No more! With Numbers you can draw out multiple separate sheets, each with their own column widths/row heights and other formatting, no problem.
And for large data sets, or data that requires extensive filtering or specialized presentation, FileMaker, no question. It blows all spreadsheets away when it comes to: hundreds of thousands of rows (or millions), and it supports limitless separate views of the same data. Anyone who does serious work in excel that includes large data, normalize-able data, or extensive presentation or filtering, you owe it to yourself to check out FileMaker.
I really appreciate the performance boost. We have a quite complicated sheet before and adding 20 more rows at a time is annoying. Yes I know there are ways to add 20+ but the default low limit shows how slow it is. With this new system, Google is confident enough to allow user to add 1000 rows at a time (default value). Scrolling seems to be very smooth too. Overall a great upgrade!
Personally I'm more interested in projects like Webodf (http://webodf.org/) and it's integration with OwnCloud 6 (http://owncloud.org/). Stick it on a Synology NAS at home and I've got my own office suite in the cloud.
Offline is awesome; obviously because it means it works anywhere, but also I presume this means that all formula evaluation is now done locally, i.e. "instantly". I am pretty sure that before the server was involved in (some?) recalculation, which caused sluggishness.
I still find it bizarre that the actual files still aren't synced in the google drive desktop app. Instead they are synced and stored in the browser. I'm assuming this means you have to go into the browser and get the latest versions before you go offline, rather than the desktop app keeping you in sync. The desktop app really feels neglected, like it's a checkbox feature to compete with Dropbox.
> I still find it bizarre that the actual files still aren't synced in the google drive desktop app.
I suspect one of the reasons for that is that the native storage isn't a file format at all, and that all of a users sheets (and other files for the Google apps) are stored in a set of entries in an online database.
> The desktop app really feels neglected, like it's a checkbox feature to compete with Dropbox.
The ability to store traditional files in Drive and access them through the same web UI is a feature that was added, I suspect, to make the Drive interface usable as a one-stop browser-based information access point (a "My documents" for Chromebooks, in a sense), and the desktop app is a feature that provides syncing to encourage people to store desktop files in a way which also makes them readily accessible to that interface, as well as a me too feature to compete with Dropbox.
> I suspect one of the reasons for that is that the native storage isn't a file format at all, and that all of a users sheets (and other files for the Google apps) are stored in a set of entries in an online database.
If the DB entries can be duplicated to the users browser, then they could be serialized to a file in the users google drive. This would allow people to back up their files, move files out of google drive when it gets full and move them back in when they need them. That guy that lost all his files a few months ago would have been ok. I can't see a good reason the .gsheet files are just bookmarks. I want my files.
Also, if somebody from Google is reading this, please add a reconnect option to Google drive. Exiting and re-running drive is a pain after every network failure, hibernation, etc.
Recently I have been working on a project with a client where we have been using SkyDrive and its online Excel for simple and basic collaboration on a few documents.
The thing that I love about this setup is having the original Excel document sat there on the skydrive ready to be edited in the full Excel when more advanced editing is required and seamlessly updated on the web (although not at the same time, which is something I hope will be possible in the future).
I have tried multiple times to use Outlook and Exchange based email, most recently a couple months ago. I do not like it. At all. If I was offered a job that forced me to use Outlook, I'd probably turn it down (or bribe IT to make my email accessible through Gmail).
For all of it's flaws, I frikkin' love Gmail. Perhaps my favorite parts are the spam filtering and the filters.
I don't use Google docs/sheets/gmail/... due to their terms of service. Why give Google a perpetual right to do anything they want with any content put in a Google app?
https://www.google.com/google-d-s/terms.html
Because web? Can I open my LibreOffice documents from a new machine without even installing an app?
Obviously there are reasons to use LibreOffice, like you said. But don't try to pretend there's no reason to use Google's office suite over LibreOffice.
Neato. Does it lock or allow concurrent simultaneous editing? Does OwnCloud integrate LibreOffice yet? A one-stop locally-hosted OSS Google Drive replacement would be nifty.
For me: collaboration. For personal stuff, I can create small sheets and share with family. They will be updates instantly.
For work: we use google spreadsheet for a lot of different status reporting. Allowing multiple people to edit it at once (and view all the changes immediately) can be really nice for certain use cases.
It is convenient. But I am surprised so many people are willing to put their business's data into a spreadsheet where they can't even get the native files. If this takes off it's going to be lock in 100x worse than Excel ever was.
When documents are converted formats features, formatting etc will be lost. If you export everything as CSV you loose all your formulas etc. xlsx and ods are better, but not perfect.
If you could export all your documents in the native format and import them into LibreOffice you'd still lose features, but as LibreOffice improved it's import you'd lose less.
With convert at export data is permanently lost. With convert at import, no data lost permanently lost, it just may not be currently available.
Also if you could backup in native format you could import into a google account if your first account is blocked/lost, instead you have to go through the import/export conversion twice.
Also, with Excel, once you have a computer running Windows / Excel, you can't lose data if a feature is changed / dropped. Just don't upgrade. With Google Docs, you have no choice to upgrade to the latest version. It may not even be a dropped feature, you spreadsheets may accidentally rely on a buggy feature, and when it's fixed your spreadsheets behave differently with no warning.
Google Spreadsheets is VB/DBase/FoxPro for the web and like them, you can build a nice-sized product or company and upgrade to a "real" database for the tables you need, e.g. enterprise search on SOLR/Lucene. Specifically, you get super flexible, shareable, cheap cloud database with built-in UI, APIs, version and access control and more. Little or no training required.
My company has over 3,000 sheets (7,500+ worksheets) and over 100 "types" of tables. Compared with companies that used traditional RDBMS+app architectures, we've saved big $ between data entry and engineering. It allowed us to skip VC financing and win our market bootstrapping to profitability.
hope this helps,
adam
world's leading source for specialty/artisan products
Definitely. Though I often wonder how much Google's apps strategy is a direct-compete with office for now?
I have a sneaking suspicion it's similar to Microsoft's Bing strategy. It feels like Bing was created to annoy Google and keep them focused on search. Microsoft could afford to throw a few billion at something to keep Google out of it's bread-and-butter. It feels like Google's doing the same with apps.
Of course, given enough time to gain feature parity, both GApps and Bing could be true competitors.
Maybe because not everyone wants their spreadsheet with sensitive data on Google's servers. Also, I seriously doubt this thing is up to feature parity with Excel.
Because Excel is the backbone of how most organizations do "computation". For example, if you look at any financial services company, you will find not only Excel everywhere, but tons of VBA code in those spreadsheets which also turn around and talk to various compute clusters that they use (both Windows HPC server and LOTS of Linux). Excel isn't going away anytime soon.
I've worked with one organization that uses Excel sheets to model product mathematics for gaming (gambling) equipment. They won't even use the Macintosh version of Excel since they can't be sure the math will come out exactly the same as the PC version, and the PC version is what has gotten them approved by the gaming boards before.
Call it superstitious, but they don't have the time or expense to sit there and prove that another spreadsheet works 100.00% identally to PC Excel. So now they run Excel in VMWare on OSX. There's irony there, but what can you do?
Most people I know who sit in Excel all day use Windows Excel on a Mac. OS X is a better platform (it's nice to have the terminal right there) but Mac Excel is trash, and Microsoft knows it.
having worked at a multinational for some years where excel was the bread and butter: privacy, power features (e.g. tables, goal seek, etc), and custom-built (corporate) plugins are the three biggest reasons I can think off.
Using a native rich application is always going to be superior to building a web app on top of a browser. Once you're used to real applications, Gmail and the other apps aren't suitable for anything more than light usage. It's not just the features that are missing, it's UI responsiveness and usability. Hosting an application inside a browser is so awkward in ways that real applications aren't. I can't assume I can right click and get anything useful, I don't know if I'm going to get the browser's menu or the app's. The concept of a consistent menu bar you can access with hotkeys is gone. Online/offline will never be seamless and consistent across apps. And the input lag is intolerable.
Having all of my documents stored centrally is a real, but small, convenience to get in exchange for everything that's given up. And as far as cost goes, I'd prefer that any money my company might be saving be deducted from my paycheck if it would mean they'd get off of Google apps.