This thing happens in both Apache OpenOffice Calc and LibreOffice Calc which makes me thing I did something wrong, but after almost a year of debugging and trying some different approaches, I still have no idea what is going on.
I have a few styles that I made, but one of them keeps messing around. There are three cell that use this style, but only if the value is negative. When the value is positive, the numbers are supposed to be displayed in some custom red colour and when it's negative the colour is supposed to be some custom green (indicating that I am below budget, which in this case is good, hence green…). I use one style for each of these conditions, since I don't, and don't want to, use the standard [RED] and [GREEN] colours. The ”below zero” style is called ”UnderTot” and the ”Above zero” one is called ”ÖverTot”. The one that is messing with me is ”UnderTot”. I use conditional formatting for this. Here are the number formats: ÖverTot: "+"# ##0,00" "[$kr-41D] Example: +2 345,67 kr Colour: Custom red. UnderTot: # ##0,00" "[$kr-41D] Example: -2 345,67 kr Colour: Custom green. Steps: Make sure at least one of the three cells has a negative value. Save the file. Close the file. Open the file. If it still looks right, enter a new value in one of the three cells. Now the cell format of the ”UnderTot” style changed. Last time I tested, the format code was changed to ”Standard”, but different things happens different times. All the other styles works perfectly. The ”UnderTot” style is linked to a stylle called ”Under”, but ”Under” works perfectly. It's not just the format of the cells that are changed, I verified that the style actually changed itself. I just want some ideas what could have been wrong. I am sure I did something wrong but I lack more ideas what to look for, so any kind of idea is welcome. Thanks in advance! If someone wants the file for testing, let me know. I guess I can't attach it to this message anyway, so I won't even try that. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ
