Keyboard shortcuts for keyboard navigation, in OpenOffice Writer and Calc

« Printing a selected print range in OpenOffice Calc spreadsheets | Main

October 05, 2009

Keyboard shortcuts for keyboard navigation, in OpenOffice Writer and Calc

I'd like to suggest that everyone check out the keyboard shortcut features under Tools > Customize, Keyboard tab. Try for Writer and for Calc. Just select the Navigate item in the left hand side and scroll through all the possibilities.

You don't need to change the keyboard shortcuts. Just check out all the possibilities.

Posted at 10:36 AM in Calc: 2009, Configuration and Setup, OpenOffice.org: 2009, Writer: 2009 | Permalink

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341cdb1753ef0120a5be9317970b

Listed below are links to weblogs that reference Keyboard shortcuts for keyboard navigation, in OpenOffice Writer and Calc:

Comments

Verify your Comment

Previewing your Comment

Posted by:  | 

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:

Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

via feedproxy.google.com

Posted via web from sefcug's posterous

Miscellaneous - USB and Portable Application Presentations

I have been preparing two presentations to be given this evening at the BPCA general meeting.

The first "5 Things You Can Do With a Portable USB Drive" is a revised version of that presented by Jerry Naditch of the Viscaya Computer Club. Thanks to Jerry for his permission to revise and use as needed. All editing and additional material done using OpenOffice.org Portable v2.0.3 components.

The second "Portable Applications" was completely written using OpenOffice.org Portable v2.0.3.

Both will be available through the BPCA website, after publication of the November 2006, C:\BPCA News, in both OpenOffice.org Impress and Microsoft PowerPoint formats.

In the course of my research, for the "Portable Applications" presentation, I became aware of a portable version of Scribus v1.3.3.4, an open source desktop publishing application. I have installed it on one of my USB thumb drives, and intend to check it out for suitability of use in publishing further editions of C\BPCA News and other computer user group publications. If this works out, it will be a much cheaper alternative to the retail desktop publishing such groups must purchase.

If anyone has used the standard Scribus v1.3.3.4 or the portable version, for such a purpose, I would like to hear from you about your experiences or any suggestions.

Open XML Spreadsheet in Excel

I was at my Business Agent's office the other day and she was emailed a file, which she could not open after saving to her desktop.

The file in question contained spreadsheet information so she was double clicking on the file, thinking it would open up in Microsoft Excel but, it would not open.

She was on the phone with the sender, trying to resolve the problem.

I happened to see that the file had an .xml extension and when she hovered over the file name, the file properties showed it as being an "XML Spreadsheet". These clues told me that the file had been sent in an XML (EXtensible Markup Language) format, not Microsoft Excel.

I told her to:

• Open her Excel applications.


• Go to the File menu.


• Select Open from the drop down menu.


• Navigate to the file on her desktop that needed to be opened.


• Select the file (Change the File Type to All Files, if necessary).


• Click Open.

This opened the file in Excel and she was able to access the information. I say that she was able to access the information because the XML file only contains the information with minimal set up; she ended up having to go in and setting up the header, footer, repeating row, etc. to manipulate the information.

This worked because she had Excel 2003. From what I have found Microsoft Office 2003 and above includes XML reading capabilities. OpenOffice is also capable of reading XML files.

XML is a much more involved subject than can be handled in a blog like this. Also, I am just now reading about XML and doing a little experimentation on utilizing it.

From what little I have read about XML and its implementation, XML will be more prevelant in the very near future, as the information needs to be written only once and then can be presented in many different ways very easily. For an overview of XML check out this information at the Wikipedia site: Extensible Markup Language.

Microsoft Excel and OpenOffice CALC - Association and Saving

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 whateverelse 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: The same procedure is used 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.