How come I am getting error 508 and 501 with my formulas in OpenOffice? 

by on September 29, 2009

Q: In OpenOffice I am trying to use two formulas and the first one is giving me an error code of 501 and the second is giving me an error code of 508.

=IF(B2=””,””,CONCATENATE(“<a href=”””,A2,SUBSTITUTE($B2,” “,”+”),”””>”,B2,”</a><br>”)

=IF(B2=””,””,CONCATENATE(“”,B2,””)

How can I fix these so that they do not give me errors anymore?

 
 

Creating templates in OpenOffice that work in Word 

by on July 27, 2009

Q: We are using OpenOffice but our templates were all created in Microsoft Office 2003. When I edit the templates in OpenOffice and save them back as MS office files the TOI and other formatting is not working well. Am I missing any feature to use to not let this happen?

A: Older versions of OpenOffice are not very good at saving to Microsoft Office file formats. To figure out which version of OpenOffice you are using you can go to Help => About in OpenOffice. The most recent version, as of this writing, is OpenOffice 3.1 so make sure you are running that version or newer.

If upgrading to the most recent version of OpenOffice does not solve your problem then you should consider saving your template changes to an OpenDocument template. OpenDocument is OpenOffice’s set of default file formats. OpenDocument template file formats include: ott (word processing), ots (spreadsheet), and opt (presentations).

 
 

How come when I use OpenOffice to edit Microsoft Office 2003 templates they don’t save correctly? 

by on June 29, 2009

Q: We are using OpenOffice but our templates were all created in Microsoft Office 2003. When I edit the templates in OpenOffice and save them back as MS office files the TOI and other formatting is not working well. Am I missing any feature to use to not let this happen?

 
 

Free alternative to Microsoft Word 

by on June 22, 2009

Q: I can’t afford to buy Microsoft word. What is the best alternative that doesn’t cost an arm and a leg?

A: OpenOffice is one of the best free alternatives to Microsoft Word and Microsoft Office in general. It  can open most MS Office documents and it can save almost any document in any MS Office format so that you can be compatible with anyone that uses Microsoft Office.

 
 

Can Open Office save in a format that is compatible with Microsoft Office 2003? 

by on April 16, 2009

Q: Can Open Office save in a format that is compatible with Microsoft Office 2003?

 
 

Are OpenOffice and Microsoft Office documents compatible? 

by on February 11, 2009

Q: I have an HP Mini which does not have a CD Drive so I can not install my Microsoft Office software without first purchasing an external CD drive. I really don’t want to buy something I won’t use that often. Does anyone know if OpenOffice and Microsoft Office documents are compatible!