Year-end offer: Save 50% on Able2Extract Professional single license purchases before December 31!

How To Export Open Office Files To Google Docs

Working via the cloud is unavoidable these days. Thanks to mobile devices, we’re finding more efficient ways of working while away from the office.  In fact, a common productivity habit these days is to send the document you’re working on to Google Docs so you can edit them from anywhere.

Well, if you’re using Open Office to create those documents, we’ve got a great productivity tip for you. In addition to helping you convert PDF to Open Office, we came across an Open Office extension that will let you instantly export your Open Office files to Google Docs: OpenOffice.org2GoogleDocs (OOo2GD).

OpenOffice.org2Google Docs is an extremely handy plug in that allows you to export, import and update your Writer, Calc, and Impress files to and from Google Docs.

The best part about this extension is that it simplifies the entire process and lets you do it right from within the Open Office suite itself. Take a look.

Installing OpenOffice.org2GoogleDocs

To start exporting your files, you’ll obviously need to install the plug in first.  To do so, follow these steps:

1. Download the OOo2GD extension by clicking on the Get it Now button. Save the extension to a location you will remember.

2. In Open Office Writer, go to Tools>Extension Manager…

Accessing OpenOffice Extension Manager

3. In the Extension dialog, click on Add. Then browse, locate and select the OOo2GD extension you saved in step 1.

Adding OpenOffice Extensions

Once installed you should see it enabled in the extension list:

OOo2GD Toolbar AddOn

4. Restart Open Office. You’ll find the OOo2GD Add-On ready for you to add to your regular toolbar for quick one-click access to the functionality. Place it on your toolbar by clicking and dragging it to an empty spot on your toolbar.

OOo2GD Toolbar AddOn

Note: This is toolbar is optional. You can also access the functionality via File > Google Docs & Zoho.

How To Export Your Open Office Files to Google Docs

Now that you have the extension installed, you’re ready to start exporting your files to Google Docs. We put a quick step-by-step tutorial to help guide you through the process. To export your Open Office document,

1. Open the file you wish to export and click on the Export to Google Docs button:

Exporting OpenOffice to GoogleDocs

2. In the pop up dialog, enter your Google Docs Account credentials

Entering GoogleDocs Credentials

3. Select Convert to Google Docs format and Autoupdate. This will allow you to automatically set your file up for syncing and editing within Google Docs.

4. Click on OK.  OOo2GD will then start uploading your file to your Google Drive.

5. Sign into your Google Drive account and locate the file

OpenOffice file in GoogleDrive

6. Click to open the file and you can then edit the document as needed within Google Docs

Editing OpenOffice in GoogleDocs

You can also quickly import Google Docs into Open Office in a similar manner. After clicking on Import to Google Docs, just input your credentials, click on Get list and you can select which file you want imported. Click on Open. 

Importing GoogleDocs to OpenOffice

This extension is perfect and convenient for worker bees who need to take their work home with them. It eliminates the hassle of a USB key and toggling back and forth between saved copies.  Do you have a favourite OpenOffice extension yourself? Which one helps you out the most?

How To View PDF Files In Mozilla Firefox

With over 80% of non-HTML documents on the web consisting of PDF documents, viewing PDFs in browsers has become a common user behavior among web surfers.  You can come across anything in the PDF format: manuals, quick start guides, white papers, ebooks—the list goes on.

So it’s not surprising that browsers are trying to fill that need with built-in PDF viewing features. We’ve already covered Chrome’s native PDF viewer when it first came out. And other browsers, like Mozilla Firefox, have since followed suit.

Thus, it’s high time we took a look at how you can use Firefox’s PDF viewing feature that was added in the latest version of Mozilla Firefox.

Getting Started

The convenience of these built-in PDF viewers like Firefox’s is that it allows users to open and view PDF files online without a plug-in. The viewer is on by default, so you don’t have to worry about enabling it.  All you have to do is click on the link of the PDF file. And just like that, you can view PDFs directly within the browser.

Viewing PDF In Firefox

Overall, the interface is sleek and simple, and the minimalist approach offers a clean PDF viewing experience.  Although Firefox PDF viewer worked well with the PDFs tested, it gave us a warning that “this PDF document might not be displayed correctly” and offers up a quick click solution to use a different viewer.

Firefox PDF viewer warning

Depending on the complexity of the PDF you’re trying to view, you might want to take advantage of this.  Otherwise, you can close this pop-up and continue to view your PDF.

PDF Viewing And Functionality

Once you have a PDF opened in Firefox, you can accomplish the most common tasks with the file from the toolbar.

Thumbnails:  Navigate through the PDF with the built-in viewer’s sidebar navigation.  You can toggle between a thumbnail or outline view

Page Up/Down: In addition to scrolling, you can manually go page by page through your PDF

Firefox-PDF-Page-Navigation

Page Navigation: Jump to and from a specific page in the file

Zooming: For zooming in and out on your PDF content. Click on the drop down box and you can specify the page size and display

Firefox PDF Zooming Options

And like most PDF viewers, you get features to help you take that file offline or view it more easily:

Firefox PDF File Options

  • Full Screen Mode: View your PDF document in full screen mode
  • Printing: Print a copy of the PDF. From the Print dialog you can select the printer drive, the range of pages and the number of copies you want
  • Downloading: Download and save the PDF to your computer
  • Copy Current View:  Allows you to open the current view in another tab or window

Dealing With PDF Viewing Issues

Considering this feature is only a few months old, you may experience some bugs, slow rendering, or even blank PDF pages.  As such, you may want to use Firefox’s built-in PDF viewer sparingly or only on more simple PDF files.

You can also disable the viewer and resort to using your regular PDF plugins or PDF viewers to open PDF files. To do this, follow these steps:

1. In the Tools menu, select Options

2. In the Options dialog, go into the Applications tab

3. Search for and select Portable Document Format (PDF) in the Content Type list

4. In the Action list, click on the drop-down arrow. Here you can specify how you want Firefox to handle PDF files.

Adjusting Firefox Viewing Options

To try Firefox’s PDF viewer yourself, head over to the Mozilla.org site to download the latest version.

5 Great Ideas For Creating A Personalized Mother’s Day Message

No matter how you decide to celebrate Mother’s Day this year, there will always be one thing you’ll give your mother without fail: your Happy Mother’s Day greeting message.

Yet, however you send it to your mother online, whether it’s in an email, an e-card, or posting up a simple “Happy Mother’s Day” message on her Facebook page, it just doesn’t seem enough. Ever think that it could use a personal touch? That it could be made even more special?

Why not take your Mother’s Day message to the next level this year? Make sure it’s a special day with a message specially crafted for her. Here are a few ideas to jazz up your Happy Mother’s Day greeting with a few tips and tools.

1. Digital Photo Albums

Mother's Day Photo Album

Sometimes the best gift you can give is a collection of good moments, and a Mother’s Day Album is a great way of getting them into one single package. When creating it, try getting a good collection of photos over the year since last year’s Mother’s Day. Each year is unique and with it you’ll want to capture the best moments and memories of each one.

Tools: jAlbum, Photobucket, Flickr

Tip:  Since albums are ultimately a collection of captured moments, an album collecting different facets of your mother as a person is a great way to show your appreciation for the person she is.  For this, create one that has multiple sections. Within each section, designate a category like “mother,” “best friend,” or even “super hero.”  Then include photos that show her in different moments, representing those traits throughout the year.

2. Photo Collages

Mother’s Day Photo Collage

We’ve all had those moments we wish we had kept in a bottle, and surely your mother has had them too.  Photo collages can be a perfect way to “bottle” those moments up.  The best part about collages is that you can be as artistically creative with them as you’d like. Add pictures not normally associated with each other or arrange them in different patterns. See where the collage takes you!

Tools: Fotor, PhotoCollage, Photovisi, Canva

Tip:  In your collage, mix in images that you associate with those moments, whether it’s a picture that sets a mood or one that evokes a special meaning to you both. It’s a visually challenging project, but an effective one that doesn’t need words to get your message across.

3. Word Clouds

Word Cloud for Mother’s DayJust like a collage, word clouds can express your Mother’s Day message with a visual mash up of ideas. This is perfect as a family project as every member can contribute their own words as well.  Online word cloud generators are flexible enough to work with websites, documents, and text. In most cases, you can even tailor the shape of your word cloud.

Tools:   Wordle, WordItOut.com, Tagxedo

Tip:  Fit in words that pertain not just to your mother, but to your relationship as well. For instance, adding nicknames or places that are special to you both will add a nice touch to remembering the memorable tidbits in your lives.

4. Audio Recordings

Mother's Day Audio Recording

A simple post that states “Happy Mother’s Day” just isn’t enough. And let’s face it. A written message doesn’t have the same authenticity or weight than a real live voice. Hearing those words from the mouths of loved ones themselves is priceless. So why not make an audio recording of your Mother’s Day greeting? Add sound effects, special messages or even make a song out of your Mother’s Day greeting.

Tools:  Apowersoft, Vocaroo, Chirbit

Tip:  Ever hear of that TV show “This is Your Life”?  This is a perfect opportunity to replicate that same spotlight on your own mother in audio format. Record every family member’s anecdotes which involve your mother. Then put it all together. The result? Your mother gets to hear some great memories from the people who matter the most.

5. Multimedia Presentations

Mother's Day Presentation

Who says presentations are only for professional purposes?  Make a presentation listing all the great things about your mother.  This is a more flexible greeting format as you can decide how you want it to look, what you want it to contain and which sorts of media to add—images, audio, text, and even video.

Tools: Prezi, MS PowerPoint, GoogleDocs Slides, Moovly

Tips:  Don’t forget that you can also set up presentations as a slideshow. As such, try formatting the presentation as a narrative so it can simply play and take your mother through it.  She can watch her mother’s day gift like it’s movie night at home.

How To Install Able2Extract 8 On Ubuntu

Right now, open source is on the rise, and adding to the already growing list of Ubuntu supporters is China. Canonical, the company behind Ubuntu, has been collaborating with the Chinese government to develop a standardized operating system known as Ubuntu Kylin, which will be released later this week on Thursday.

Ubuntu already offers a Chinese Edition of the OS, but Ubuntu Kylin will be a new version significantly aimed at supporting how Chinese people work on computers. Among other things, it will integrate pre-installed localized tools, offering easy access to web services and software they commonly use right from the Dash.

This is great news for the open source community and Chinese users looking for alternatives they can start using effortlessly.  If this latest development has you wanting to find out more about Ubuntu before the big day arrives, this is certainly a perfect time to test it out.

Able2Extract 8 For Ubuntu Users

Well, for all you Able2Extract users wanting to switch over—or for those who need a PDF converter on Ubuntu, we have just the thing. We put together a quick tutorial on how to install Able2Extract 8 on the open source system.  With Able2Extract 8 you can convert PDF to Open Document Formats and more.

This tutorial was written using Ubuntu 12.10. For instructions on installing the latest version, visit Ubuntu’s Installation Help page.  Once you have it installed and all set up, follow these steps.

1. Go to the Investintech.com site and download the latest version of Able2Extract 8 for Ubuntu.

2. Click on Open with Ubuntu Software Center.

Download installation file

3. Access the installation file through your dashboard. Click on Install.

Installing Able2Extract

If you have a password for administrative purposes, enter it in and authenticate the installation to continue.

Authorizing Able2Extract Installation

4.  When the installation is complete, accept the terms of the End-User License Agreement to get started with Able2Extract 8 on your computer.

Accept Able2Extract EULA

And that’s all there is to it!

Converting PDF on Ubuntu

Will you make the switch to Ubuntu or try Ubuntu Kylin?  Jump in on our Google Plus discussion on this topic and let us know your take on the latest development.

Able2Extract 8 Tip: How To Get Accurate Excel Spreadsheet Calculations During Tax Season

Using Excel is a great way to keep things organized during tax season.  The popular spreadsheet program has advanced features that let you work with your financial data as accurately as possible.

And that’s important.

Half the battle for tax filers every year is making sure that the numbers on those tax forms are correct.  The nitty-gritty calculations can be especially tedious if those numbers are generated from PDF conversions.

Fortunately, Able2Extract can refine the conversion process right down to the cell content.  Honourably mentioned by AccountingToday.com, the PDF converter was recognized for its PDF to Excel spreadsheet conversion and aiding in auditor control.  Now it’s time for you to get that same control over your taxes.

Introducing Able2Extract’s MS Excel Conversion Parameters

On top of the custom PDF to Excel conversion features you already know about, you can take advantage of conversion parameters to ensure that the converted PDF data falls in line with your tax spreadsheet analysis right from the start. The following options are located under View > Options…

PDF to Excel Conversion Parameters

Reposition The Minus Sign

In certain financial documents or reports, the minus sign symbol trails to the right of the number that it is associated with (e.g. “4,560-“ instead of “- 4,560”). Converting negative numbers where the minus sign trails to the right of the number can cause the resulting conversion to Excel to place these numbers as text, rather than numbers.  Move those trailing minus signs to the beginning of the number by selecting the Trailing Minus Sign Treatment. This will prevent it from being converted to textual items in Excel.

Keep The Dollar Sign Separate

Certain financial documents may contain dollar signs. Unfortunately, sometimes the dollar sign ($) creates a challenge in the way the program interprets column structure. Thus, the default is to meld the dollar sign into the same column as the number next to it.

PDF to Excel - Retaining the Dollar Sign

But if you wish to retain the dollar sign in its own separate column, check the Retain Dollar Sign as Separate Symbol option before converting.  Excel will treat the sign in the column as text.

Work With European Numeric Formatting

There are cases where some countries use European number formatting (1.234.567,89 vs. the North American equivalent written out as 1 234 567.89). However, PDF data in this format may be incompatible with your auditing tools or with some region specific versions of Excel.

You can change this easily with Able2Extract 8.  By selecting the European Continental Settings option, you can convert documents that adopt the decimal comma and “period” thousand separators to Excel formatted numbers correctly.

Display Your Data Differently

Sometimes you may need tabular data displayed differently to focus on specific areas.  For example, you may want to interpret data in terms of weekly revenue rather than by product.

PDF to Excel - Enable Table Unfolding

To transpose the data and move the data in columns to rows and the data in rows to columns, use the Enable Table Unfolding option. When selected, Able2Extract will generate output from a PDF in column structure to Excel in row structure or vice versa.

Enable Table Unfolding

Rotate Text into Excel

With pesky PDFs you may come across text in a table that has been rotated in a certain direction which would pose a problem for existing formatted Excel spreadsheets. Checking the Rotate Text into Excel box in the options menu will convert the rotated text into Excel upon conversion.

Just keeping a few of these options in mind can greatly lower the amount of stress you’re already going through with tax season. After all, it’s the simplest adjustments that can mean the difference between getting severely audited and getting a healthy tax return.