Booleans used in openoffice not recognizable in excel

[Matuna]

Recently, my evaluation of MS Office expired at the worst possible moment (as is usually the case) so I resorted to using openoffice as a temporary replacement while I gather the money to purchase the real deal.

I created a spreadsheet which I needed to distribute to some friends, I found openoffice's spreadsheet (almost distastefully) identical to excel 2003 so I was able to finish up quickly, I saved it as an .xls and sent it out.

The following day I received emails stating that the spreadsheet was not working properly. After a couple of hours of checking and double checking I noticed that open office saves boolean values as 1 or 0 (as expected) however uppon opening the file in excel it was considering these values not as boolean values (true or false) but literally as numerical 1 or 0 making most expressions incalculable or providing false conclusions.

I checked to see if this also occured the other way around (creating a file in excel and opening it in openoffice), the values were correctly identified as booleans.

Im not sure if this is a bug on behalf of MS excel or openoffice and if there's any way around it.

[martindwilson]

got an example that doesn't work?

[Matuna]

A really basic example, but it shows what I mean.

[martindwilson]

hmm you need to coerce the value
=IF(--C2=1,"one is one","one is not one")
or just use
=IF(C2,"one is one","one is not one")

[Matuna]

That works.

Thanks.