**- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -**

Incompatible Formulas in OpenOffice Calc and Excel

Posted By __April__ On February 28, 2011 @ 9:51 AM In __OpenOffice__ | __Comments Disabled__

**OpenOffice.org Calc: Why Are My Formulas Behaving So Badly?**

If you’ve used Excel in the past with any regularity, you may find yourself experiencing some difficulty with formulas – whether creating them in Calc or trying to open an Excel file in Calc.

While I can’t guarantee that I’ve got the answer to your problems, I can definitely make a pretty good suggestion as to what to check.

The two programs differ in the way they string together the arguments of a formula… let’s take a look.

Here’s the way Excel demonstrates how you should put together things in the average formula:

Not let’s examine the suggestion Calc gives you for the same formula:

See the difference?

It’s slight, but you’ll find that it’s definitely there… * Calc *uses

Not a real big difference when you or I look at it, but it’s a huge difference to Calc.

Next time you’re experiencing formula syntax issues, just take a second and double check yourself… which separator did you use?

~ April

Article printed from Worldstart's Tech Tips And Computer Help: **http://www.worldstart.com**

URL to article: **http://www.worldstart.com/incompatible-formulas-openoffice-calc-excel/**

URLs in this post:

[1] Image: **http://www.worldstart.com/incompatible-formulas-openoffice-calc-excel/mse_formula_argument_separa/**

[2] Image: **http://www.worldstart.com/incompatible-formulas-openoffice-calc-excel/oooc_formula_argument_separ/**

Click here to print.