On 25/08/07, Steve Domina <[EMAIL PROTECTED]> wrote:
>
> Question:
>
> I have a Excel file that I tried to open in OOoCalc/Math (spreadsheet).
> It has two conditional formulas in it.
> First time I tried to open it in Ooo, it crashed: hmmm...it also crashed
> the
> 2nd time.
> I commented those two formulas out, and tried to open it.
> After forever, it opened it up.
> However, when I tried to get there two Conditional formulas to work, they
> don't.
> (it was COUNTIF) Works fine in Excel.
> Dell Inspiron 1501, 1GB Ram, 80GB+ HD.
I don't know the syntax for COUNTIF in Excel . Check in Calc's Help for the
OpenOffice syntax for COUNTIF. I have a strong feeling it'll be different.
For example, Calc wants semicolons (";") between the arguments of a formula.
But then I've been wrong before ;-)
Just out of interest, how did you "comment out" the formulae without being
able to open the spreadsheet?
--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org
