Month: November 2009

Microsoft Word and its accessibility

Posted by – November 22, 2009

When you think ‘word processor’, you think ‘MS Word’. Come on, admit it. Despite the availability of so many word processing software, a lot of it freeware, MS Word retains its position as the best known word processor one can get. It’s no surprise, owing to its popularity, it has monopolized the text document format – the standard format for most documents is ‘.doc’.

One of the reasons MS Word is so well known and not just a little respected amongst its competitors is, its versatility. PDF files, XML files and even HTML files can be created from Word documents. There are many methods of improving the accessibility of Word-based documents or files. One of the things that can be done is to make documents that are structured. The right method of structuring in MS Word is the usage of Word styles, instead of merely performing formatting changes such as bold, font-size increase, etc.

The versions of MS Word, over the years, have had varying but not dissimilar methods of getting structured. For example, in MS Word 2000-2003, you can make true headings from the styles list, and you also get to work with any custom style you might have fashioned. So why does a Word file need true structure in the first place? That’s because of its usefulness – if you export the file to HTML, the structure will remain unchanged, allowing people to read it online, as it was created. The same holds true when it comes to exporting .doc files as PDF. Now, in Word 2007, you’ll find an improvement, in that, more than adequate attention has been given to appropriate styling.

Let’s consider the case of Word 2004 for the Mac. Word 2004 for Mac thankfully has a dropdown list of styles quite like the one in Word 2000 and 2003 for Windows. In the 2004 version for Mac, styling can be performed through the formatting palette. Now let’s shift pay attention to the method of providing alternate text in all the versions of Word for Windows mentioned above. In Word 2000 – 2003, you need to right-click the image and choose ‘Format Picture’, then select the Web tab in order to provide the alternate text you want. Unfortunately, it’s more complicated with Word 2007. If you want to add alternate text, you’ll have to begin by right-clicking on the image and selecting ‘size’. After which you’ll select ‘Alt Text’. What happens here is, the filename of the image gets entered into the field by default, and this is a problem owing to the fact that the image filename is not the right alternative text. You can remedy this if the filename is replaced with the correct alternative text.

Moving on now to data tables and issues with accessibility, you should know that it is not possible to assign the table header element to table-cells in MS Word. It’s possible to specify that a row must ‘repeat as header on the top of each page’ in ‘Table Properties’, you won’t get the correct table headers.

  • Share/Bookmark

Alternatives to Microsoft Excel

Posted by – November 12, 2009

If you’re looking for free, open-source spreadsheets, some of which are web-based, as an alternative to MS Excel, then have a look at this top-ten list:

1. OpenOffice Spreadsheets

OpenOffice Calc is an extremely popular substitute for Microsoft Excel as most of its features mirror those of the latter. Another plus point is its interface which is quite user-friendly. With OpenOffice Spreadsheets, you can source data from numerous corporate databases, perform cross-tabulation and many, many more things. All in all, an excellent piece of software.

2. Gnumeric

Gnumeric is a useful alternative to MS Excel. Referred to by some as ‘Gnome Office Spreadsheet’, Gnumeric includes mostly every single worksheet function that Excel offers. What makes Gnumeric better – and this is a contentious topic – than Excel is that is offers one hundred and fifty four other functions that the aforementioned software does not.

3. Abykus 2.0

A lot of people use Abykus 2.0 for many purposes, most of them scientific and business-related. Abykus 2.0’s interface is very intuitive which makes it easy for first timers. Calculations of many sorts are possible with the Abykus 2.0.

4. CleanSheets

CleanSheets is another independent alternative to MS Excel. Just a word of caution – make sure you have JRE running on your computer, otherwise this software will not work. What sets CleanSheets apart from others like it is the fact that its formula language is quite similar to that of MS Excel.

5. Numbers

Numbers’ is a handy Macintosh alternative to MS Excel. Loaded with templates, and a part of Apple’s iWork suite, ‘Numbers’ is quite different from its Windows counterpart, but it’s simple enough to get used to in very little time.

6. Google Docs –Spreadsheet

Google Docs – Spreadsheet is also quite good. A web-based substitute, it is definitely lacking in extensive functionality, but it’s meant for basic spreadsheet-work anyway. This software allows you to do the usual things you’d expect from an Excel substitute – use formulas, create and edit worksheets, make charts, etc., but what’s noteworthy is that you can share your work with others through an internet connection.

7. Spread32

A very basic program that allows you to work with spreadsheets, Spread32 provides free panes, key sorting, etc. With Spread32, you get 256 columns x 65536 rows x 255 sheets. It is meant for the simplest of calculations and tasks.

8. Thinkfree cal

Another Java-based app., Thinkfree cal is an alternative to MS Excel that works with most all OS. Basic, but useful.

9. Zoho Sheets

Yet another web-based substitute for MS Excel, Zoho Sheets is simple but reasonably powerful software. Its advantage is that a lot of people can simultaneously work on a single spreadsheet.

10. KSpread

The freeware KOffice suite runs on Unix and Unix-like OS, and KSpread is its answer to MS Excel. It’s not that great in comparison with most commercial spreadsheet software in that it doesn’t have what most of the others do. However, what redeems KSpread is that it offers features like formatting, conditional coloring, graphs, etc.

  • Share/Bookmark