Negative results not in red color

Discuss the spreadsheet application
Post Reply
vowelowl
Posts: 2
Joined: Sat Jan 13, 2018 3:56 am

Negative results not in red color

Post by vowelowl »

My formulas are workinf, but I cannot get the negative results to show in red color. I have formatted my numbers with currency and highlighted asll of thr variations of red in the format cell .
OpenOffice 4 on Windows 8.1
User avatar
robleyd
Moderator
Posts: 5084
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Negative results not in red color

Post by robleyd »

Try the format settings shown in the screen capture below. Make sure you check the Negative numbers red box.
Format for currency with negative numbers displayed in red.
Format for currency with negative numbers displayed in red.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
vowelowl
Posts: 2
Joined: Sat Jan 13, 2018 3:56 am

Re: Negative results not in red color

Post by vowelowl »

This block has been checked, unchecked and rechecked.
I have tried all of the red number variations.
This was not a problem until I downloaded OO 4.1.5
Do I download the previous version, am I the only one with this anomily?


Regards,
Jens L Jergens
OpenOffice 4 on Windows 8.1
User avatar
robleyd
Moderator
Posts: 5084
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Negative results not in red color

Post by robleyd »

Can you upload a sample file showing the problem? [Forum] How to attach a document here Note maximum file size is 128K. If your file is larger, use a file sharing site such as Mediafire. The link also contains information on how to anonymise your document if it contains confidential information.

You may wish to edit your previous post and remove your email address, unless you wish to receive more spam as email addresses get harvested from sites such as this.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Post Reply