[Solved] Very strange behavior of IF

Discuss the spreadsheet application
Post Reply
mmasroorali
Posts: 32
Joined: Thu Aug 12, 2010 11:40 am

[Solved] Very strange behavior of IF

Post by mmasroorali »

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,
oocalc1.png
oocalc1.png (34.31 KiB) Viewed 1224 times
one formula,
oocalc2.png
oocalc2.png (25.61 KiB) Viewed 1224 times
another result.



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

The
strangeif.ods
(13.17 KiB) Downloaded 140 times
offending file, boiled down from a large example is also attached.

Thanks in advance.
Last edited by mmasroorali on Thu Aug 12, 2010 12:48 pm, edited 1 time in total.
LibreOffice 3.3.2 OOO330m19 (Build:202) tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu5 in Ubuntu 11.04 - the Natty Narwhal
User avatar
Hagar Delest
Moderator
Posts: 32627
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Very strange behavior of IF

Post by Hagar Delest »

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.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
keme
Volunteer
Posts: 3699
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Very strange behavior of IF

Post by keme »

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. 
Apache OO 4.1.12 and LibreOffice 7.5, mostly on Ms Windows 10
mmasroorali
Posts: 32
Joined: Thu Aug 12, 2010 11:40 am

Re: Very strange behavior of IF

Post by mmasroorali »

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

It appears that the learning process never stops.

Thanks.
LibreOffice 3.3.2 OOO330m19 (Build:202) tag libreoffice-3.3.2.2, Ubuntu package 1:3.3.2-1ubuntu5 in Ubuntu 11.04 - the Natty Narwhal
Post Reply