Displaying Negative Numbers as red in Calc

users
#1

I have an iMac, System 10.6.8 and Libre 3.4.1

In Calc I have no problems with red negatives, two decimal places and comma
separated thousands when saved as odf
However, when saved as xls, the red negatives are all black, but the
thousand separator and the two decimals are OK.
In xml, fods, format, everything works OK.

Tink.

#2

Hi :slight_smile:
That sounds like a bug to me
http://wiki.documentfoundation.org/BugReport

On Ubuntu the LibreOffice 3.3.2 has no trouble. Can you try the 3.3.3 to see if
you have the same trouble?
http://wiki.documentfoundation.org/Installing_in_parallel

Regards from
Tom :slight_smile:

#3

Tom,

Yes, it appears to be a bug in 3.4.1. I uninstalled 3.4.1, installed 3.3.3
and the display now works as expected. I will submit a bug report in the
near future. Oh, and for what it is worth, I am running Windows 7 64-bit.

Thank you.

#4

Many thanks.
I have been having trouble with my downloads of late.

Tink.

#5

Hi :slight_smile:
The guide for installing 2 versions of LO on the same machine might need a bit
of thinking about but it should work
http://wiki.documentfoundation.org/Installing_in_parallel
It is possible to buy Dvd versions to avoid having to download and they tend to
be very reasonably priced
Regards from
Tom :slight_smile:

#6

I have just realised.
When showing negative numbers in Red, you should not prefix the number with
the minus sign.
This makes it a double negative, therefore making the number Red should be
minus the minus sign.
BTW. Is that a pun?

Tink.

#7

Hi :slight_smile:
I try to make it a triple negative by using red, brackets and a minus sign just
to equally annoy everyone
Regards from
Tom :slight_smile:

#8

Hi

On my XP SP3, LO 3.4. build 1OOO340m1 (Build:103) - the same as yours

I saved as .ods, .xls, .xls (95) .xml and .xmlx,

and they all came back perfect

Must be a Windows 7, and an iMac bug - worth a report.

regards

John B

#9

Tom

How do you do it?

I try to make it a triple negative by using red, brackets and a minus
sign.

Tink.

#10

Just a thought

I do not know if Widows 7 has compatibility mode, but if it does, try Windows XP compatibility and see if the problem goes away.

regards

John B