On Sun, 26 Oct 2014 19:02:44 +0100 Johnny Rosenberg <[email protected]> wrote:
> 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 > ジョニー・ローゼンバーグ > I rarely use styles in calc so this response may be invalid for you. I notice there is no "-" for UnderTot as you showed. Is this intentional? > Here are the number formats: > ÖverTot: "+"# ##0,00" "[$kr-41D] > Example: +2 345,67 kr > Colour: Custom red. > > UnderTot: # ##0,00" "[$kr-41D] <<<<<<<< no "-" >>>>>>>> > Example: -2 345,67 kr > Colour: Custom green. Tom -- Failure seldom stops you. What stops you is the fear of failure. - Jack Lemmon ^^ --... ...-- / -.- --. --... -.-. ..-. -.-. ^^^^ Tom Taylor KG7CFC openSUSE 13.1 (64-bit), Kernel 3.11.6-4-default, KDE 4.11.2, AMD Phenom X4 955, GeForce GTX 550 Ti (Nvidia 337.19) 16GB RAM -- 3x1.5TB sata2 -- 128GB-SSD FF 27.0, claws-mail 3.10.0 registered linux user 263467 -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
