Note: This article was based on OpenOffice 3. Since this article was written, OpenOffice version 4 has been released. Click here to read the newer OpenOffice 4 article.

A client recently asked me if I knew of any alternative to Microsoft Office. As a firm believer in open-source software, I told him about OpenOffice.org 3 from Oracle. It is a complete office software suite with a word processor, spreadsheet, multimedia presentation, graphics, and database programs.

OpenOffice.org is Java-based and requires it to be installed. It is compatible with other commercial office software and can read/write various file formats. XSLT and StarOffice formats are supported, but you will need to choose the custom installation to enable these filters. You can also expand the functionality of OpenOffice.org by using third party extensions. And you can also export to PDF in all of the applications. And best of all, it's free.

OpenOffice.org 3's main screen

Programs included in OpenOffice.org

Writer
Writer lets you design and produce text documents that can include graphics, tables, or charts. You can then save the documents in a variety of formats, including the standardized OpenDocument format (ODF), Microsoft Word .doc format, or HTML. And you can easily export your document to the Portable Document Format (PDF).

Calc
Calc is a spreadsheet application that you can use to calculate, analyze, and manage your data. You can also import and modify Microsoft Excel spreadsheets.

Impress
Impress lets you create professional slide shows that can include charts, drawing objects, text, multimedia, and a variety of other items. If you want, you can even import and modify Microsoft PowerPoint presentations.

Draw
Draw lets you create simple and complex drawings and export them in a number of common image formats. You can also insert tables, charts, formulas, and other items created in OpenOffice.org programs into your drawings.

Base
With Base, you can access data that is stored in a wide variety of database file formats. Base natively supports some flat file database formats, such as the dBASE format. You can also use Base to connect to external relational databases, such as databases from MySQL or Oracle.

Math
Math provides numerous operators, functions, and formatting assistants to help you create formulas.

OpenOffice.org 3 is available for Windows, Linux, and Mac operating systems. For more information on OpenOffice.org 3, please visit their website OpenOffice.org.

When it comes to computer repair, you have to be a detective of sorts. And once in a while, I come across a really good mystery. I recently got an HP M7360N in the shop that would randomly freeze-up in Windows XP when you moved the mouse. It would run perfectly fine in Safe Mode. Maybe a bad driver?

A check of the event logs yields absolutely nothing, not a single error. I check Device Manager and find the hard drive controller listed under the Unknown category, even though it is correctly identified as an Intel controller. I uninstall it inside Device Manager and then scan for hardware changes. The hard drive controller reinstalls back into the Unknown category.

The system is still freezing up randomly when the mouse is moved. I tried a PS2 and USB mouse and got the same results with both. I disable all non-essential drivers and reboot with no change. I download the original and latest drivers for the system, trying all with no luck. Maybe a corrupt installation?

I create an image of the hard drive and then wipe it clean. Using the supplied recovery disks, I proceed to re-install the operating system and recovery partition. The system froze-up three times during reinstallation. But this time, the hard drive controller is under the correct category, IDE ATA/ATAPI controllers. It's starting to look like a hardware issue.

I run a few DOS-based utilities to test the memory, hard drive, etc. with no luck. I even try the HP recovery diagnostics. Every test I run tells me that there is nothing wrong with the hardware. Using the keyboard only in Windows, I can install another utility to test all of the motherboard components. I allow it to run for six hours, and the system passes every test.

The BIOS is the next place I look and find it's a few versions older than what is currently available for download. I download and install the latest BIOS version, and it still keeps freezing up randomly when the mouse is moved. I start searching the internet for clues.

After a few different search queries, I come across an article at Badcaps.net discussing symptoms of capacitor failure on motherboards, one being 'system randomly and frequently freezes'. I check the motherboard thoroughly and find no capacitors that look bad. I start checking the expansion (add-in) cards, and all at once, the mystery was solved.

There on the graphics card was a bank of capacitors that the tops were swollen.

Top view of the graphics card showing the difference between good and bad capacitors.

Side view of the graphics card showing the difference between a good and a bad capacitor.

The movement of the mouse on the screen was causing the graphics card to freeze-up. I re-assembled the system with a new graphics card, and the issue was gone. Another computer repair mystery was solved.

In a previous article, I discussed Microsoft Security Essentials (MSE). I like the ease of use, the integration with Windows Update, and the small footprint it has, especially on my netbook. Recently, Microsoft has released Microsoft Security Essentials Version 2 with some new features, including a new and improved protection engine, Windows Firewall integration, and a Network Inspection System.

A new look for MSE V2

As you can see, the user interface changed slightly, with a new color palette and mesh graphics. There are a few more options for the user to configure, but it is still one of the easiest anti-virus applications to setup. For more on the major improvements, here is a quote from the MSE web site:

Windows Firewall integration
Windows Firewall can help prevent attackers or malicious software from gaining access to your computer through the Internet or a network. Now when you install Security Essentials, the installation wizard verifies that Windows Firewall is turned on. If you have intentionally turned off Windows Firewall, you can avoid turning it on by clearing a check box. You can change your Windows Firewall settings at any time via the System and Security settings in Control Panel.

Network Inspection System
Attackers are increasingly carrying out network-based attacks against exposed vulnerabilities before software vendors can develop and distribute security updates. Studies of vulnerabilities show that it can take a month or longer from the time of an initial attack report before a suitable security update is developed, tested, and released. This gap in protection leaves many computers vulnerable to attacks and exploitation for a substantial period of time. Network Inspection System works with real-time protection to better protect you against network-based attacks by greatly reducing the timespan between vulnerability disclosures and update deployment from weeks to a few hours.

Award-winning protection engine
Under the hood of Security Essentials is its award-winning protection engine that is updated regularly. The engine is backed by a team of antimalware researchers from the Microsoft Malware Protection Center, providing responses to the latest malware threats 24 hours a day.

Now, in going through the program, I did find two options quite interesting...

Enable behavior monitoring and Enable Network Inspection System options in MSE V2

I did a little digging in the MSE V2 Help file and found this description of these features:

Enable behavior monitoring
This option monitors collections of behavior for suspicious patterns that might not be detected by traditional anti-virus detection methods.

Enable Network Inspection System
This option helps protect your computer against “zero day” exploits of known vulnerabilities, decreasing the window of time between the moment a vulnerability is discovered and an update is applied.

Here are a few of the other changes inside of MSE V2:

• Microsoft Security Essentials also supports Windows XP Mode in Windows 7
• The ability to limit CPU usage during scanning
• Automatic removal of quarantined files after a set amount of time
• You can now select between monitoring all files, incoming or outgoing

Microsoft Security Essentials Version 2 is available for Windows XP (SP 2 or SP 3)(x86), Windows Vista (x86, x64), and Windows 7 (x86, x64) and can be downloaded here.

Note:
The only issue I came across was that the update function inside Version 1 would not update the program to Version 2. I tried it on a couple of systems without success. I had to uninstall Version 1 first, then install Version 2.

Windows XP is currently the most popular operating system, with Windows 7 quickly catching up. As more and more people are moving from Windows XP to Windows 7, I thought I would spotlight a series of articles that I wrote a little while back. My move from Windows XP to Windows 7 was a 'side-by-side' migration, with two separate systems.

I, believe it or not, never used Windows Vista on any of my production systems. I ran Windows XP up until Windows 7 was released. I did run Windows 7 Release Candidates on a test system for several months before its release and was very happy with it. I even wrote a series of articles about it too. Here they all are.

Upgrading to Windows 7 from Windows XP

Upgrading from Windows XP to Windows 7 (Part 1)

Upgrading from Windows XP to Windows 7 (Part 2 - Drive Imaging)

Upgrading from Windows XP to Windows 7 (Part 3 - Hardware / Software Inventory)

Upgrading from Windows XP to Windows 7 (Part 4 - Windows 7 Installation)

Upgrading from Windows XP to Windows 7 (Part 5 - Applications and Settings)

Upgrading from Windows XP to Windows 7 (Part 6 - Epilogue)

Beta testing Windows 7

Beta testing Windows 7 - Part 1

Beta testing Windows 7 - Part 2

Beta testing Windows 7 - Part 3

Beta testing Windows 7 - Part 4 (Antec cases)

Beta testing Windows 7 - Part 5 (BIOS and installation)

Beta testing Windows 7 - Part 6 (software overview) (Video)

Beta testing Windows 7 - Part 7 (Photoshop Benchmark)

Network shell (Netsh) is a tool an administrator can use to configure and monitor network devices on Windows based computers at a command prompt. A common use of Netsh is to reset the TCP/IP stack back to default settings.

But not only will Netsh reset the TCP/IP stack, but it can also completely reset your network adapter(s). It will also display the network diagnostics page in Windows XP.

Using Netsh in Windows XP

To use Netsh, you will need to open a Command Prompt. There are two ways to do this:

• Click the Start button, then All Programs, then Accessories, then click on Command Prompt

or

• Press + R. This will bring up the Run dialog box. Type CMD and press OK

Netsh commands in Windows XP

The following is a list of the Netsh commands you can use to reset your Windows XP network adapter:

Resets network interface informationnetsh int reset all

Resets TCP/IP and related components to a clean state.netsh int ip reset c:\resetlog.txt

Resets IPv6 configuration state.netsh int ipv6 reset

Displays the web page user interface.netsh diag gui

Resets Winsock Catalog to a clean state. All Winsock Layered Service Providers which were previously installed must be reinstalled. This command does not affect Winsock Name Space Provider entries.netsh winsock reset