Results 1 to 5 of 5

Thread: Problem with LibreOffice Fromula and Formatting

  1. #1
    Join Date
    Nov 2008
    Beans
    224

    Problem with LibreOffice Fromula and Formatting

    Refering to Screenshot1, the formula: =IF(A8<A9,(A9-A8)*N9,(A8-A9)*N9) in Cell O9, should give a positive answer. What I get is a negative answer in black. I format the Cell 09 as in Screenshot2 where a minus should be in Red. Some other cells with minus are also formated to be in Red but they are in black.
    Is there any explanation for this.
    I am using Ubuntu 10.04 and Libreoffice 4.0.2.2.
    Attached Images Attached Images

  2. #2
    Join Date
    Jan 2013
    Location
    Eastern Europe
    Beans
    Hidden!
    Distro
    Lubuntu

    Re: Problem with LibreOffice Fromula and Formatting

    I understand your problem. There is no logic.

    But there are other red negative numbers, why are they red?

  3. #3
    Join Date
    Nov 2008
    Beans
    224

    Re: Problem with LibreOffice Fromula and Formatting

    Quote Originally Posted by Locus Kiesselbachi View Post
    I understand your problem. There is no logic.

    But there are other red negative numbers, why are they red?
    All the red negative numbers are all originally in red when I formatted them to be in red with negative numbers.
    After I backup the file to another harddisk, some of them are red and some are black.
    I checked their cells formatting and all of them are supposed to be in red with negative numbers.

  4. #4
    Join Date
    Nov 2008
    Beans
    224

    Re: Problem with LibreOffice Formula and Formatting

    Quote Originally Posted by wstay View Post
    All the red negative numbers are all originally in red when I formatted them to be in red with negative numbers.
    After I backup the file to another harddisk, some of them are red and some are black.
    I checked their cells formatting and all of them are supposed to be in red with negative numbers.
    I used luckyBackup 0.35 from Ubuntu to backup my file onto another hard-disk.

  5. #5
    Join Date
    Aug 2011
    Location
    52° N 6° E
    Beans
    2,610
    Distro
    Xubuntu 14.04 Trusty Tahr

    Re: Problem with LibreOffice Fromula and Formatting

    It's strange. I tried to reproduce your problem on libreoffice 3.5.7.2 (running 12.04 LTS) and I can't. Apart from the fact the if statement doesn't work for me (remarkable, but somewhat understandable as its dutch translation "als" does work and I use the dutch language), I have to use semicolons instead of commas. When I use commas I get "error:508", when I use semicolons (as in "=als(A8<A9;(A9-A8)*N9;(A8-A9)*N9)") it works and I get the correct result. Even that could have something to do with my locale settings, as I use the comma as radix character and the period as thousands separator, so maybe the comma as argument separator works for you.

    Besides, instead if this if statement you could use "=abs(A8-A9)*N9". It's mathematically identical and somewhat clearer. Maybe it works better.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •