Apache OpenOffice Community Forum

Dear All,
I have been using OpenOffice.org for almost a decade (previously StarOffice), but today I found a very strange behaviour from IF. See the attached images of the same file, one formula, another result.



Why it is always Smaller? In B6, is not it supposed to be Larger?

The offending file, boiled down from a large example is also attached.

Thanks in advance.

Hi and welcome to the forum!

I hit F9 and it updated fine. Note that you seem to use the Ubuntu version of OOo (it uses commas instead of semi colons), it may be a cause.

You can try to install the Sun version instead: [Ubuntu] Installing OOo on Debian and Co.

Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.

Two possible causes that come to mind:

1. Automatic recalculation is switched off.
   Press F9 to recalculate manually. Switch auto recalc on in the menu: Tools - Cell content.
2. The figures in column A are entered as text, and B1 contains a properly entered number value.
   Text is always considered "larger" than numbers when comparing/sorting.

Edit: Didn't see the attachment on first reading, sorry! The cause must be #1 above, as Hagar de l'Est also determined, it seems.

The cause was indeed #1. A simple Tools -> Cell Contents -> click AutoCalculate solved everything.

It appears that the learning process never stops.

Thanks.