microsoft office

Google Drive Can Now Edit Office Files From the Web

Google Drive web opening docx, Office files in editing mode - 9to5Google:

Google’s editing applications can open and edit Microsoft files, with that capability recently coming to Android. When opening Office files from the Drive web client, Google will now directly open them in editing mode. 

I would guess this is one more small nail in the coffin for my school district never using anything other than Google Drive again. Most of my colleagues have moved their docs, tables, and presentations to Google’s suite of apps. For the few hold-outs who still email Word docs instead of Google Doc links, it looks like this will allow them to continue editing comfortably in Microsoft Office, while enjoying the benefits of organizing their work in Google Drive and sharing it with others.

I have been outspoken about enjoying native apps over web apps but online teaching has forced me to depend on my Mac and Google Chrome much more. The more I get used to doing my work in a web browser, the less I mind it.

I still do most of my work in Apple’s iWork suite because it is nicer, easier, prettier, faster, and better integrated with Apple platforms. Something tells me iWork isn’t getting the option to edit from the Google Drive interface any day soon. 

🔗 Omni Apps are Adopting Apple’s Standard iOS Document Browser this Fall

Adopting Apple’s Standard iOS Document Browser - The Omni Group

In 2019, we think it’s time to retire our custom document browser in favor of using Apple’s built-in document browser—and with our iOS 13 updates this fall we’ll be doing just that. Instead of seeing our custom file browser, you’ll be presented with the standard iOS document browser—just like in Apple’s own iWork apps. Using Apple’s browser, you’ll be able to store and sync your documents using Apple’s built-in iCloud Drive, or third-party commercial options like Box—or even in cloud- or self-hosted collaborative git repositories using Working Copy.

As a user of OmniFocus, OmniGraffle, and OmniOutliner, I am grateful that the OmniGroup is making this change. The Files app on iPad works very similarly to the Finder on Mac these days. So when I open or save a document on an iPad, I want to see that same interface. It's exactly the same as if I were on a Mac. I would never go to the File-->Open menu and expect to see anything other than the traditional Save/Open dialogue box that I see for every other app. This is standard on Mac. (Mostly. Some apps like Microsoft Office still refuse to use it.) So it is only fitting that in iOS, document based apps display the system provided interface for interacting with files.

In apps like Pages, for example, opening a new document displays an interface that looks and behaves like the Files app.

In apps like Pages, for example, opening a new document displays an interface that looks and behaves like the Files app.

MindNode is an example of a third party app that uses the same Files interface as Apple’s own apps.

MindNode is an example of a third party app that uses the same Files interface as Apple’s own apps.

Apps like OmniOutliner show a custom interface. Fortunately, OmniGroup is changing this behavior in the fall.

Apps like OmniOutliner show a custom interface. Fortunately, OmniGroup is changing this behavior in the fall.

PDF Expert is another example of an app that does not use the native file picker. Hopefully they will get the message and adopt it soon.

PDF Expert is another example of an app that does not use the native file picker. Hopefully they will get the message and adopt it soon.

🔗 Microsoft Office for iPad now supports opening files from the Files app more directly

Microsoft Office and the Files App Finally Play Nice Together:

Today Microsoft updated its Office suite for iOS, with Word, Excel, and PowerPoint all reaching version 2.12. Office updates rarely receive detailed release notes, and today was no exception, but user Teddy Svoronos discovered that the updates brought 'Open In' capabilities to the share sheet, which previously only enabled making a copy of an Office document. The 'Copy to' option has now been removed, replaced by the more convenient 'Open in.'

After seeing Teddy's tweet, I did a little playing around in the Files app and discovered that, while Excel and PowerPoint documents accessed in Files will load Quick Look previews and require tapping 'Open in' from the share sheet, the experience is even better with .docx files. Those Word-associated documents open directly in the Word app with just a single tap from the Files interface – no need to open the share sheet first.

It is really nice to see proper use of the Files app user interface being adopted into apps by third party developers. The more time passes, hopefully we will see this adoption so wide that opening documents using the native file browser will feel no different on an iPad than it does on a Mac. It always feels jarring on Mac when the “Open” option doesn’t show the Finder. On iPad, custom “open” UIs have been standard since its beginning. Hopefully the Files app introduced this past fall with iOS 11 will continue to change that. 

What I really thought was interesting about this article was something I have been wondering about the Files app since the summer. 

Update: One of the developers working on Office has confirmed my suspicions: the reason Word files open for me with a single tap while Excel and PowerPoint files do not is that I haven't opened those files enough for iOS to know that I would prefer to bypass the share sheet.

I had noticed that tapping on files in the Files app could open them within third party apps but I never understood how iOS knew which apps to use. (For example, standard text files were opening in Byword on my iPhone and 1Writed on my iPad for a time.) It seems that the user can to some extent control these apps by using the “Open In…” option from the Files app and choosing the desired app frequently. Still though, I would love the option to set default apps on iOS. I can tell my Mac which app I want to open PDFs. Why not on my iPad Pro?

Brief Thoughts on Apple’s Education Event

Well it has taken me long enough… This past week, Apple held an education event. Below are some brief thoughts on the subject. Chris Russell is coming on my podcast later this week to talk about all of the details. Keep in mind, I do not work in a school with 1:1 iPads or any kind of deployment strategy. But I am very seriously invested in Apple’s role in education and their vision for how their products fit into the classroom.

New iPad

This device looks great. Adding the Apple Pencil to this model will be an asset for schools. But will schools really pay 89 dollars for a pencil after just having purchased numerous 250 dollar iPads? 

The thing that gets me most excited about this device is its consumer potential. I am tempted to buy one for myself as a (more) mobile counterpart to my larger 12.9 inch iPad Pro.

iWork Updates

Apple Pencil support. FINALLY. This was my favorite announcement of the day. I anticipate editing Pages documents, scribbling on bus attendance lists made in Numbers, and annotating Keynote slides at the front of the classroom on a daily basis. I hate to be cynical (which the rest of this post will be), but Microsoft Office for iPad has had the ability to write on documents with an Apple Pencil since the Apple Pencil launched, two years ago. 

iBooks Author

Seems like the Mac app is no longer going to receive development. All book publishing features have been moved to Pages for iOS and Mac. It doesn’t appear that the new feature does everything that iBooks Author can do. Hopefully this is like when Apple rewrote Final Cut Pro X, took away some features, but then eventually added them back. Or when iWork was rewritten to be the same for iOS and macOS, stripping AppleScript features from the Mac, but eventually bringing them back. I would hate to see iBook authors unable to use workflows they have in the past using iBooks Author for the Mac. 

Classroom App for Mac

Apple’s learning management system comes to the Mac. Great! But what took so long? And can Apple keep up with the vastly more mature and flexible Google Classroom? (See conclusion below)

School Work App

An app for teachers to give assignments to students, check their progress, and collect it back. School Work can route students to other apps to do their assignments using the ClassKit API which is very cool. But why is this separate from the Classroom app? And where does iTunes U fit into all of this?

Conclusion

Apple is making a lot of solid efforts here but a lot of it it feels like too little too late, especially the student and learning management software. I really do hope they can keep up with Google Classroom who has been eating everyone’s lunch for years. Apple will have to be aggressive about adding new features to all of these new apps and making sure that their app ecosystem is flexible enough to compete with Chromebooks which use browser based software. Yes, there are way more apps on the App Store than there are Chrome based apps, but in education (and especially in music education) a lot of the big players are writing for Chrome OS. To me, the draw of Chromebooks in education is not their price, but the flexibility of web based software.

Apple’s software engineers seem spread very thin and unable to balance the release of various applications, consistently over time. This is true of many of Apple’s consumer apps. Mail and Reminders, two tentpole productivity apps have fallen way behind the competition. Calendar has not seen any more than a few major feature updates since I started using the Mac back in 2006. Apple’s apps are part of the “nice” factor of being in the ecosystem. Sometimes an app like Notes will get some major new features, but then we won’t hear from it for a few years. Google’s apps, by contrast, lack the same design sense, but are constantly being updated with new features. And they are not locked into annual OS updates like iOS is. In my opinion, this is Apple’s biggest problem right now.

Ironically, software is still my draw to Apple products. Even though their hardware is the most indisputably good thing they are doing right now (I am nearly without complaint of my iPhone X and the iPad 10.5 is perfect), it is the software that locks me in. In other words, I am much more committed to macOS and iOS than I am Mac and iPhone. This leaves me with some long term concern about my interest in continuing to use Apple products. And great concern about any educational institution who jumps on the iPad bandwagon just because apps are bright and colorful and demo well on stage. Apple has to show continual support for their education software if their dream for the classroom is to come true.