Category Archives: Miscellaneous

Microsoft Excel and OpenOffice CALC – Association and Saving

Posted on by

I was recently asked two questions regarding Microsoft Excel files and OpenOffice.

“Why can’t I open an Microsoft Excel file, sent via e-mail, even though I have OpenOffice 2.0 installed?”

The person asking the question does not have Excel installed on their computer.

The most likely reason is that OpenOffice is not set up as the default for opening Excel files.

The easiest way to associate the .xls extension with OpenOffice in Windows XP, assuming that you have saved the file to your computer is:

  • Locate the appropriate file in My Documents or whatever else it was you saved it.
  • Right-click the file you want to open in a different program, and then click Properties.
  • On the General tab, click Change.
  • Click the name of the program in which you want the file to open.

This will make it so that any files with an .xls extension will not automatically be opened by OpenOffice CALC.

Note: Use the same procedure to change the association with other extensions and the programs you want to have them automatically open in.

“How do I save an OpenOffice spreadsheet in Microsoft Excel format, to send via e-mail?

This is much easier to answer.

When you are finished creating or editing the OpenOffice spreadsheet use the Save As and select the appropriate format from the drop down menu.

Internet – Selecting Text For Copying

Posted on by

Have you ever had the problem of using the mouse to highlight text on a site and getting portions of other text you did not want? This is usually because the site is using tables or columns you can not see to display its content.

Instead of using the mouse to drag across the text to be selected, position the cursor at the beginning of the first word, hold down the Shift key and position the cursor at the end of the last word. All the text between these positions will now be selected and can then be copied and pasted wherever it is you want to place the text, without any of the items you do not want.

I know this is really a basic thing but, I see a lot of my co-workers having trouble selecting only the text they intend.

By the way, the same technique works in most instances of Windows selection, providing more control over selection.

XP On Screen Keyboard?

Posted on by

Do you want to use an on screen keyboard?

Honestly, I don’t know why I would use it but, Microsoft includes a utility in XP, that displays a virtual keyboard on the computer screen as an accessibility tool.

To turn on the On-Screen Keyboard click on Start, All Programs, Accessories, Accessibility, On-Screen Keyboard. Or even easier, click on Start, select Run, type osk and click on OK

For more detailed information on this and other XP accessibility options see Windows
XP Accessibility Tutorials.

Some of these accessibility options, might be useful, for those who can not see or hear well and those who have trouble using a keyboard or a mouse; give them a try before looking for expensive ways to do the same type of thing.