Technology and Tools Online – The Cometdocs Blog

How to Insert Text Into Your Images on Android

June 28, 2012 Documents

Adding text to photos is one of the most widely used effects. People do this when they want to create image quotes, improvethe look of the image, insert explanations, create tutorials, and more. There are plenty of software and web tools which will allow you to do this. However, there are still not many that allow you to do it on Android. Since the Android OS is being used more and more in the smartphone realm, we are going to present you today with four apps that allow you to insert text into pictures when using an Android-based device.

1. PicSay

picsay How to Insert Text Into Your Images on Android

PicSay is one of the best photo editing tools for Android. Even though the free version is a bit limited compared to its pro version, it still has amazing abilities. You can add word clouds, text titles and stickers to your images. There are multiple fonts and colors to choose from. Additionally, this app has multiple effects one can add to a picture, for example

2. Fotolr

fotolr How to Insert Text Into Your Images on Android

This app allows you to add Text anywhere you want on the image. Also, it allows you to quickly take a photo and immediately edit it on site. Just click on Word, and type the message you want to add, change the font color, size and position. You can even rotate the text. Adding text is just one of the many possibilities you have with this app.

3. AddWatermark

addwatermark How to Insert Text Into Your Images on Android

AddWatermark is specifically designed to help you in adding text to protect your images. There are lots of differents colors and fonts to choose from. Images can be saved in .jpg and .png formats.

4. Photo Editor

photoeditor How to Insert Text Into Your Images on Android

This app is extremely simple to use, sspecially the function of adding text to images, which is very intuitive. Choose which photo you want to use and you’ll see a list of available effects at the bottom. Choose the Text option and you are ready to go. You can choose diffrent colors for you text box, as well as different text angles, sizes and more. You can also use your fingers on the touchscreen to resize your text.

How to Work with Different Languages in Google Spreadsheets

June 25, 2012 Excel, Free Tools, Online Tools, PDF, Tips

In today’s globalized world it is a pretty common occurrence to have to deal with documents in different languages. But since technology is progressing as a fast rate as well, we are usually able to work with those documents even if we don’t speak the language. There are aids that can help us get over the language barrier.
Modern technology enables you to translate foreign text extremely easily and without losing time or decreasing your productivity.
We will show you today how you can work with different languages in Google Spreadsheets.
One of the major advantages of Google Spreadsheets is the ability to integrate it with Google Translate. Google translate is a great tool for translating between almost every major world language.

1. Detect language

Say that you have received spreadsheets in a language you are unfamiliar with and you are not sure what language it is. You can easily solve this problem by using the Detect Language function. This function is: =DetectLanguage(“text”)
For example, if you want to detect a language in cell number A5, you can type: =DetectLanguage(A5)

Google will use a short code to display what language you are working in. For example, English is EN, German is DE, and French is FR. The list of codes is based on ISO standards.
Here is how it looks in an example:

detectcelllanguage How to Work with Different Languages in Google Spreadsheets

2. Translating Cells

Google Spreadsheet can also translate cells. The function for this is: =GoogleTranslate(“text”, “source language”,”target language”).

For example, if you want to translate text from cell number A5, you would type =GoogleTranslate(A5, “en”, ”ru”)

You can see in this example, how we translated the text from English to Russian:

translatecellgooglespre How to Work with Different Languages in Google Spreadsheets

How to Convert Excel Spreadsheets into HTML tables

June 12, 2012 Documents, Excel, Free Tools, Online Tools

When working on an online document, presentation, or webpage, we sometimes need to present the data in the form of a table. Instead of manually writing out the HTML code for a webpage, we can convert existing data directly into HTML with just a couple of clicks and save time significantly. For doing this, you don’t even have to have MS Excel – the most widely used software for creating tables – installed. We have selected a couple of the best ways to do it, one of which should definitely work for you and satisfy your needs.

1. Convert directly from MS Excel

Go to your existing spreadsheet, click on Save As, and choose the Web page option, like on the photo. You can see that there are options for saving the whole workbook or only a selected part. You can also adjust the document’s title.

saveashtmlexcel How to Convert Excel Spreadsheets into HTML tables

2. Google Docs

Google Docs is an excellent tool for creating tables and sharing them online. After you finish editing and calculating your data, go to File – Download As – HTML format like you see on the photo. It is very simple. The document gets downloaded to your computer immediately.

googledocssaveashtml How to Convert Excel Spreadsheets into HTML tables

3. Tableizer

tableizer How to Convert Excel Spreadsheets into HTML tables

Tableizer is an online tool which can help us to convert table data into HTML directly online. Paste the data into the conversion box, choose the font size and color and you’ll get your HTML right away.

4. WordPress

If you regularly work in WordPress, you’ll find that it is very easy to convert Excel data into HTML. Just copy the data you want to convert and paste it into a new post. Click on HTML tag and you’ll find get perfectly editable HTML code as a result. In the options view, you will be able to see the direct results of your edits.

excelwordpresshtml How to Convert Excel Spreadsheets into HTML tables

In conclusion, if you have tried all of these and are not satisfied with the final output, you can open the data in an HTML editor and perform little tweaks as you find suitable. It is definitely better and saves time compared to having to do the whole job in an HTML editor and start from scratch.

How to Disguise Social Media Sites as MS Word and Excel Files

June 4, 2012 Documents, Excel, Free Tools, Online Tools

Using social media at work is a pretty controversial issue. Bosses think that it interferes with work, while workers say that it helps them to concentrate better and stay in touch with the latest trends and news. But if you have a boss or co-worker who will nag you when they see you are spending time on Twitter or Facebook, we have selected some of the best tips for avoiding this problem and looking more productive by disguising your social media activity as work being done in an MS Office application.

1. Hardlyworking

hardlyworkinexcel How to Disguise Social Media Sites as MS Word and Excel Files

This website allows you to log in to your Facebook and Twitter account and follow the latest updates and news. However, what is special about this app is that it looks like MS Excel. So your co-workers might think you are sorting out an Excel table, but really you are spending time on Facebook or Twitter. Go to the website, log in with your either your Facebook or Twitter account, authorize the app, and you are ready to browse freely.

2. Spreadtweet

spreadtweets How to Disguise Social Media Sites as MS Word and Excel Files

Spreadtweet is an Adobe Air application which allows you to follow Twitter updates. It is also disguised as Excel. There are no images, everything is displayed as text, and you can choose from a couple of skins, to better camouflage your activities. There are both online and offline versions, if you are not allowed to install additional software at work.

3. MsWorddit

msworddit How to Disguise Social Media Sites as MS Word and Excel Files

MsWorddit is Reddit disguised as a Word document. If you are addicted to this website, you’ll definitely find this tool useful. It is mostly suitable for following comments and discussions. When you want to open a stream of comments, click on “Open in new tab” to read them without leaving a current page.

4. Import Web Data into Excel

Everybody agrees that MS Excel is an amazing peace of software. One of the many possibilities that it offers is the ability to insert and regularly refresh data from the Web into Excel spreadsheets. You can read more about it here, but we will show you how you can import somebody’s tweets into excel and follow them.
First you have to build an RSS feed for a desired account. Just add your username at the end of following string:

http://api.twitter.com/1/statuses/user_timeline.rss?screen_name=

In our case it looks like this http://api.twitter.com/1/statuses/user_timeline.rss?screen_name=cometdocs
Now go to your Excel table and click on “Data – From Web”.

excelimportwebdata How to Disguise Social Media Sites as MS Word and Excel Files
Paste this URL and click “OK.”
You will now be able to see a list of all tweets coming from this account in your Excel document.
Click on “Data – Refresh All” to import the latest data.

How to follow a Facebook page via RSS feed

May 25, 2012 Tips

Whether one likes Facebook or not, one can’t deny the fact that there are plenty of great Facebook pages. Some are funny, some educational, and they try to engage their audience with constant updates. However, following these pages without having a Facebook account isn’t easy.

We will show a nice workaround which can help you stay in touch with updates without having a Facebook page.

Go to the desired page, selects its logo (profile picture not timeline) and copy its address or open it.

cometdocsrss How to follow a Facebook page via RSS feed

Now find the last group of numbers after the period and before “&type” in the address.

You can see how it looks on this picture.

urlcometdocsfacebook How to follow a Facebook page via RSS feed

Now copy the numbers and add them to the following string.

http://www.facebook.com/feeds/page.php?format=atom10&id=259747060709130

Add your numbers instead of the underlined ones.

Now add the URL into your RSS reader, and just like that, you are now able to follow your favorite pages anonymously.

Technology and Online Tools – Cometdocs Blog