Software

High Hopes for Office Web Apps

Office 14 Web Word Office14 Web Excel Office14 Web PowerPoint

(click images to enlarge)

With Microsoft Office Web Applications, the productivity suite will have a real web-facing side for the first time. It will be released alongside Office 2010 and will be supported by all major browsers, including Mozilla Firefox, Internet Explorer, Apple Safari and Google Chrome. Anticipations and stakes for this release are high and I personally think it’s going to sweep current online productivity suites like Google Docs right off the table. Yes, I have extreme high hopes for Office Web Apps. And perhaps you should too.

Feature Set

While not much is known about the real specifics of the online Office suite, it is certain that the traditional desktop software applications like Word, Excel, Powerpoint and OneNote will certainly be represented in the online version of Microsoft Office.

Microsoft describes the suite as online siblings for its Office applications. They will be “lightweight versions of the applications from the desktop product”. According to the General Manager of the Office-project, users of the web applications will be able to “view, edit, and collaborate” on Office documents. The web-version of Office will also, most importantly, retain document fidelity to the fullest, allowing a user to view documents in full quality online, make alterations and save it again (online or off) without loss of quality. This is stellar functionality lacking currently in all  online productivity suites.

Google Docs – as a common example – incorporates support for Microsoft Office documents in rather shoddy way. After you upload your files – frankly – they become half-assed HTML variations of the originating document. Microsoft’s solution promises to retain all of the rich formatting, lay-outs, styling, charts, transitions and image quality.

This is obviously a big improvement over any of the current implementations. And it’s one with far-reaching ramifications.

High Hopes

If you have ever sampled an online productivity suite like Google Docs you instantly realize what a step back it actually is from Microsoft Office 2007. It’s slow and feature-impaired. In Google Docs’ case it feels more like a old Office 2003 replica, with the toolbar UI bringing back bad memories with every click. Support for pretty fonts and advanced page layout capabilities are simply neglected. There isn’t anything significant implemented around text styling, nor is the revisioning system in GDocs very much impressive. If we’re honest here, it’s a downright fluke. In my opinion, Google Docs is more reminiscent of an advanced WYSIWYG-editor for blogging purposes, rather than an online word processor. And it’s not even decently apt at producing the aforementioned blog posts, since the HTML it outputs is extremely semantics unfriendly.

Microsoft’s solution, however, could be a game-changer. It will feature the ribbon interface, albeit it less feature-rich, because some functionality simply doesn’t belong in a browser. It will support many of Office’s advanced presentational niceties, though. Couple this to the online storage we’ll be getting with Office Live and true cloud computing starts to show its colors.

Reduced Functionality

I talked about reduced functionality, but don’t let that scare you. The online version of Office will be feature-limited to the degree that the most used functionality will remain present. And since most Office-users only utilize a small percentage of the full suite’s feature-set, I don’t think there will be problems with using Office in its reduced form through Office Web Applications.

To me, this is all very exciting, but I realize I should reserve judgment until I can get my hands on it for some real experience. But what’s a geek to do? I just can’t help myself. Microsoft’s introduction of the ribbon interface to its Office line was big. And so will this be. I sure can’t wait to check it out.

Firefox Portable: Circumvent IE6 in corporations

Microsoft Internet Explorer 6 is the extremely antiquated web browser that up till today still manages to ascertain a significant chunk of browser usage share. Even though this browser is incompatible with a plethora of modern-day web applications and is holding the Internet back as a whole, a lot of big corporations still use it as their primary web browser.

IE6 is truly entrenched in corporate life and will most likely remain to uphold this position for quite some time to come. At least for now, many companies still use Windows XP with IE6 on most of their workstations, because they are convinced it is a proven technology. Additionally, it has been around for so long that every experienced IT-professional is comfortable with the management tools that come along with it.

Additionally, many in-house, custom-made software and web applications for corporations was built explicitly for IE6 and haven’t been brought up to date to be more web standards compliant and all-round more contemporary.

Thus, IE6’s usage continues to make up a significant chunk of the overall share. In most cases, the employees who still use IE6 in such companies are forced to do so because computers in such environments are extremely locked down. It is often the case that nothing additional can be installed to these systems. IT guys usually have their reasons [as stated above] to keep maintaining ancient software like IE6, but in this case it’s time for everyone to move on. Perhaps they will make the jump to Windows 7 when it reaches the SP1 milestone somewhere next year. Let’s hope so.

Install Firefox 3.5 without ‘installing’ it

Yes, you read that right and it’s actually very simple to accomplish. To achieve this, I grabbed the portable version of Firefox at portableapps.com/apps/internet/firefox_portable. Portable Apps is a suite of software retrofitted to run directly from a  USB thumbdrive. They don’t require installation at all: simply run the executable to extracts its contents to a folder of your choosing.

Naturally, portable apps don’t necessarily have to run from a USB key. They can just as well be run from an arbitrary directory on your Windows desktop. And I decided to go for that route, since many corporations are now also disabling the use of outside thumbdrives because they carry in computer viruses and worms.

While Portable Apps can be downloaded as a suite consisting of numerous applications, you can also pick and choose. And thank the heavens, Firefox is in the suite and is being kept current on par with Mozilla’s release schedule.

Note: Be sure to unpack the portable app to a location on the computer’s hard drive, avoid placing it on corporate network location because it will slow Firefox down. Moreover, extracting it locally has the benefit of IT-personnel not being able to peek inside its contents. You can easily permanently delete Portable Firefox’ folder without leaving traces on the corporate network – this way – too.

A quick how to

  1. Grab the latest portable release of Firefox at http://portableapps.com/apps/internet/firefox_portable.
  2. Run the .paf-file you just downloaded and specify the path for decompression.
  3. Navigate into the folder you just specified and run the Firefox executable.

In a corporate environment it may interesting to delve into Firefox’ preference panes to make sure Firefox doesn’t keep track of your browsing history. You can easily set it to ‘Never’, so it will operate in ‘Private Browsing Mode’ permanently, evidently wiping your tracks as you go and as you quit your browsing session. Don’t forget to check this option if you want to prevent your boss from finding out you have been wasting precious office-time on Facebook or YouTube.

Note: Many corporations intercept your traffic on its way out. If this is the case in your company, private browsing will not obscure your traffic data.

Getting Firefox to work behind a corporate firewall

Corporations usually have airtight IT-infrastructure in place, enforced by exceptionally stringent firewall policies. Internet Explorer 6 will usually be pre-configured to play nicely with the aforementioned setup, but Firefox most likely won’t be. It is oftentimes easy to do, however, so don’t despair (just yet).

Frequently, corporate workstations are behind a proxy-server, which is set up in one of the settings screens in IE6. A proxy-server is a server within the company’s IT infrastructure that intercepts every workstation’s internet traffic on the way out (and in) and consequentially relays all traffic. Companies primarily do this so they can monitor and control their employees’ traffic, possibly even blocking certain sites or services, or prioritizing traffic in favor of internal sites and servers.

All you need to do, in most cases, is enter this proxy server’s address into Firefox’ connection settings and you’re off. In a nutshell:

  1. Fire up good old IE6
  2. Go to ‘Tools’ > ‘Internet Options’ > Tab: ‘Connections’
  3. In the section ‘Local Area Network (LAN) Settings’ click the button ‘LAN Settings’
  4. In the section ‘Proxy Server’, make note of or copy to the clipboard the information listed there.
    The address-field is usually filled out with something similar to ‘proxy.companyname.com’ and the port number is usually 80.
  5. Next, open Firefox
  6. Go to ‘Tools’ > ‘Options’ > Icon: ‘Advanced’ > Tab: ‘Network’
  7. In the section ‘Connections’ click the button ‘Settings’
  8. Select the radio button ‘Manual configuration’
  9. Fill out the fields ‘HTTP Proxy’ and ‘Port’
  10. Most of the time you need to check the box ‘Use this proxy for all protocols’ to use the same proxy for all web protocols outside of regular protocols like SSL-enabled (secure) sites.

To find out whether you should tick the box in step 10 you can click the ‘Advanced’-button in the IE6’s ‘LAN Settings’ window. This isn’t usually necessary, but in case you need those settings, they’re right there.

Note: You can make an extra attempt eavesdrop-proof your connections to the outside world by using SSL. Make sure you use secure connections (SSL) whenever you can. Sites that contain your sensitive/personal information usually offer this ability. Make sure you make use of it by prefixing your URLs with https:// instead of the usual http://. Some sites will automatically switch you over to https if you don’t explicitly ask them to. Others only go secure for the log-on process, after which everything else is transmitted in the clear. Beware.

For example:

  • Go to https://mail.google.com instead of http://mail.google.com to make sure you’re always using a secure SSL-enabled (Secure Sockets Layer) connection.

These few steps should do the trick. The full Internet will once more be at your disposal :-) .

Free App/Win: Advanced window management with MaxTo

As screen sizes/resolutions continue to grow, more and more web users have stopped browsing the web in fullscreen mode. Since a lot of websites are designed in a fixed-sized fashion, they usually create humongous white space on either side of a site’s content pane. This is especially so at screen resolutions of 1680*1050 px and up.

Maxto Illustration

Windows Vista has a just a few  measures in place to order your windows in such a way that you can take advantage of your screen real-estate optimally. These measures are limited to stacking windows next to each other vertically and horizontally. With some manual juggling you can get the windows just right, but you’re bound to continually repeat yourself many a time since Windows doesn’t generally do a good job of remembering window positions (yes, even if you use the shift-click-close trick).

MaxTo is a free Windows app that has a more elegant take on efficient window management. This lightweight [free] piece of software provides a straightforward UI in which you can define so called “regions”. After having defined these, just place a window approximately within a region and hit the maximize-button. The window or dialog will maximize right up to the limits of the predefined region. This simple but ingenious concept will undoubtedly inspire a flurry of optimal workflows for your Windows PC. And if you do prefer a window to span the whole screen occasionally, just press and hold the shift key while maximizing a window.

More >

‘Direct Folders’ Makes Accessing Deeply Nested Folders a Breeze [Free]

Direct Folders MenuIf you’re like me and prefer to keep files and folders on your hard drive in an organized mess (i.e. a strict hierarchical structure) it may become a severe pain to access deeply buried locations. The golden rule in organization advises not to let folders become nested beyond eight levels, which may seem like a lot at first, but readily becomes trivial as hard-drives and data continue to grow beyond proportion.

Double-click & Go-To

ExplorerWindowTo remedy this, Code Sector has developed a small and free app called ‘Direct Folders’. After installation, you can double-click on an empty space in any Explorer-window (that includes the Desktop) and a list with saved folder locations will appear. This list looks like a regular right-click context-menu and is configurable in any way you prefer. Direct Folders will keep a list of your recently explored locations, which are accessible from the ‘Recent’ window.

Looking up locations in the ‘Open File’-dialog gets easier too, since you can take advantage of Direct Folder there as well.

More >

Finally a Fast PDF Reader: Foxit

PDF (Portable Document Format) is the omni-present file format for all important documents that need to travel from one place to an other. They work on every platform, so long as a reader is installed, and they aren’t editable. The key is that every PDF document comes across exactly the way the author intended it, save the infamous inconsistencies proprietary software like Microsoft Word often impose. PDF, in itself, is also proprietary, though. It’s not open. It’s just been around long enough to seem that way.

Adobe Reader (formerly known as Acrobat Reader) is the official reader software that accompanies PDF. Throughout the years, Adobe Reader has put on weight and has become increasingly bulky, and.. slow. Panning through a document containing more than a few dozen pages usually bogs down your system, peaking CPU performance along with it.

Foxit Reader You aren’t necessarily tied to Adobe’s own reader, though. There are dozens of other, faster applications that handle PDF fine and even provide a [roughly] comparable set of features.  I’m talking about Foxit Reader 2.3, in particular: A free application that incorporates nearly all of Adobe Reader’s features with gracious speed.

Foxit Reader

Foxit supports all the usual: bookmarking, commenting, magnifying, tabbed browsing, etc. And, best of all, no more panning through documents in slow motion.

Foxit Reader is available for free on Windows and Linux.

[rating:4.5]

Free File: Active@ ISO Burner

Active@ ISO Burner is a freeware application that does exactly one thing: burn ISO-images to disc. This app is great for people who don’t often use their burner and don’t feel like purchasing a whole Nero-suite or something similar. It will burn images to CDs and DVDs alike.

image

Additionally, command line is supported in order to enable automation.

If you insert a used re-writeable disc, it will automatically be erased (Quick Erase). Secure erasing is also possible using the free Active@ CD/DVD Eraser. ‘Secure’ in the sense that every sector on the surface will be overwritten with a neutral pattern, whereas ‘Quick Erase’ only modifies to file table to make whole disc seem empty (the actual data remains).

[rating:5]

Get both freeware applications at NTFS.com.

Free File: 7-Zip

7Zip is an open-source compression/decompression utility that supports most of the popular compression formats. In addition, it also introduces its own high-performing format called LZMA. According to the 7Zip, LZMA supports:

  • a high compression ratio
  • compression speed of 1MB/s and higher (based on a 2GHz CPU)
  • decompression speed of 10 to 20 MB/s (ditto)
  • low system requirements
  • multi-threading and hyper-threading

Not only does it support regular ZIP, its compression ratio for ZIP is 2 to 10% higher than the its commercial counterpart, WinZip. In true open-source fashion, 7Zip is available in more than 60 languages and can be used on older computers without too much trouble. Furthermore, it comes with a custom file manager that allows advanced functionality like:

  • splitting files
  • combining files
  • calculating checksums of files

If you’re not (or can’t be) tied to a single computer and you prefer to carry your applications around on a USB-stick, there’s a portable version available at PortableApps.com, too. Sure, it doesn’t support every single possible format like WinRAR does, but it does a heck of a good job. And hey, it’s free!

image

7-Zip is available for Windows, Linux, Mac and most other Operating Systems out there on their official download page.

Get the portable version of 7-Zip here (Windows Only).

Supported Formats

Compression and decompression:

  • 7z
  • ZIP
  • GZIP
  • BZIP2
  • TAR

Decompression only:

  • RAR
  • CAB
  • ARJ
  • Z
  • RPM, DEB
  • ISO
  • And others…

Free File: DAA to ISO converter 0.1.3

UPDATE: UIF (Universal Image Format) is another one of MagicISO’s proprietary image formats that no other software recognizes. You can easily convert these to standard ISO with Luigi Auriemma’s ‘UIF to ISO converter’!

.DAA is a proprietary image file format developed by PowerISO. It’s not free and is often used within filesharing communities to compress CD/DVD images. While it’s great for reducing file sizes, its exclusivity to PowerISO makes it horribly inaccessible. Wouldn’t it be handier to have it in the ubiquitous ISO-format instead? PowerISO provides a free converter for the Linux and Mac terminal, but it requires Windows users to buy the full version. Conversion of files works in the trial-version, though is limited to a maximm filesize of 300MB — a pathetic limitation, since CD images are generally larger than 600 Megs.

Luigi Auriemma has created a handy command line tool that converts .DAA to .ISO, which can be burned with any burner and mounted with free software like Daemon Tools. The latest version also includes easy-to-use dialog boxes for selecting source and destination paths.

Download (23.2 KB) from Luigi Auriemma’s webpage.
Linux and Mac versions here.

Free File: Taskbar Shuffle

The ultimate tool for control freaks: ‘Taskbar Shuffle’! Aside from being able to categorize your windows in virtual desktops with Vista/XP Virtual Desktops, you can also organize the buttons on the taskbar. Why would you want that? Don’t think there’s a real reason, other than being strongly clung to daily habits. Although, you could make a good case of improved productivity, too.

Taskbar Shuffle in action

After this gizmo’s installed, all you need to do to order the buttons differently is click and drag. It’s as simple as that. System tray icons can also be dragged around, if you hold the CTRL-button whilst doing so.

A great little tool for the frenzied computer user.

Sync iPhone/iPod Touch with Google Calendar

Update: Over-the-air synchronization available

You can seamlessly synchronize your Google Calendar and Contacts with a free service called NuevaSync, as discussed by me in this article. Google has also recently implemented its own version of OTA sync by licensing Microsoft ActiveSync technology. I’ll have a writeup on this soon. OggSync is still a viable alternative though, if you already incorporate MS Outlook in your workflow and don’t  mind the limitations this application causes.

Continued…

Synchronize multiple (primary and secondary) Google Calendars to Outlook and your iPhone/iPod Touch for free with OggSync.

The iPhone and iPod Touch don’t support calendaring very well out of the box. Apple provides some rudimentary implementation for Microsoft Outlook on the Windows side (the majority of the user base is Windows-users – after all). And that’s pretty much where it stops. Most likely, when the iPhone SDK makes its debut the tables will turn once the third-party developers get their foot behind the door, but for now we’re stuck with Outlook.

The only way to get your Google Calendar(s) onto the iPhone* (i.e. without hacking) is to go through Microsoft Outlook. This means you’ll have to subsequently synchronize your calendars with Outlook and then with the iPhone. Furthermore, the latest version of the ‘Home & Student’ edition of Office [2007] doesn’t come equipped with Outlook anymore, like previous iterations used to. If you’re a Windows user and want calendaring on the iPhone, you’ll have to acquire Outlook first.

Lame, I know.

The secondary calendars dilemma

The problem with Google’s own syncing app for Outlook is that it only supports 1 calendar, the primary calendar. If you like a certain structure in your events, like I do, this will rapidly become a problem. If you want, it is possible to merge all your calendars into one. In that case, you can go ahead and sync to Outlook with Google’s own app.

In order to accomplish a merged primary calendar, you can:

  • Move the events to your primary calendar, or
  • Export your entire secondary calendar and import them into your primary calendar

Google Calendar Sync

(Google promises to make the multi-calendar feature available in the future, but doesn’t specify a date)

OggSync (Google-Outlook Sync) to the rescue

image For those who refuse to make such a sacrifice (hell, I do) there’s a free app out there called OggSync. It’s an Outlook Add-In that supports primary and secondary calendars seamlessly and best of all, it’s free. It docks right into the standard Calendar view as a toolbar and provides you with a few options. Once you’re set, all you need to do is hit the ‘Sync’-button. Magically, GCal events will start to trickle into your Outlook Calendar…

After that, plug in your iPhone and sync away.

Pros:

  • Full support for all your calendars
  • Support for both Outlook 2003 AND 2007
  • Pro version available, but optional
  • Free!

Cons:

  • A bit of a hassle, but heck, it’s better than nothing, no?
  • No calendar coloring support [yet] in Outlook 2007
  • An occasional freeze, but they don’t usually linger for long

Download OggSync 3.22 for Outlook (direct link)

Notes

*: You can also access your Google Calendars via the Safari browser on the iPhone. However, this is a static view and means you cannot add or edit events. Furthermore, you will need WiFi availability in order for this work. Experience has shown you don’t usually have wireless around when you need that desperate peek at your calendar.