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.
[Solved] Very strange behavior of IF
-
- Posts: 32
- Joined: Thu Aug 12, 2010 11:40 am
[Solved] Very strange behavior of IF
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
- Hagar Delest
- Moderator
- Posts: 32627
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Very strange behavior of IF
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.
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
Re: Very strange behavior of IF
Two possible causes that come to mind:
- Automatic recalculation is switched off.
Press F9 to recalculate manually. Switch auto recalc on in the menu: Tools - Cell content. - 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
-
- Posts: 32
- Joined: Thu Aug 12, 2010 11:40 am
Re: Very strange behavior of IF
The cause was indeed #1. A simple Tools -> Cell Contents -> click AutoCalculate solved everything.
It appears that the learning process never stops.
Thanks.
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