[opensuse] TW: LibreOffice Calc : Negative Numbers in Red not working
Hello List , TW - LO Calc refuses to display Negative Numbers in Red : Formatting Cell to display Negative Numbers in Red results in Black , not Red any ideas ? thanks .... -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 2017-03-03 12:05, ellanios82 wrote:
Hello List ,
TW - LO Calc refuses to display Negative Numbers in Red :
Formatting Cell to display Negative Numbers in Red results in Black , not Red
Checking an old sheet, it works fine on Leap 42.2, LO 5.2.3.3 Creating new sheet, enter some numbers, change style to monetary... negatives display in red. Perhaps you can share a sample sheet with the problem. -- Cheers / Saludos, Carlos E. R. (from 42.2 x86_64 "Malachite" (Minas Tirith))
On 03/03/17 13:16, Carlos E. R. wrote:
On 2017-03-03 12:05, ellanios82 wrote:
Hello List ,
TW - LO Calc refuses to display Negative Numbers in Red :
Formatting Cell to display Negative Numbers in Red results in Black , not Red Checking an old sheet, it works fine on Leap 42.2, LO 5.2.3.3
Creating new sheet, enter some numbers, change style to monetary... negatives display in red.
- thank you Carlos : tried New Sheet : : enter some numbers, change style to monetary... negatives display in red however : No Joy : negative numbers all black ......... regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 2017-03-03 13:14, ellanios82 wrote:
On 03/03/17 13:16, Carlos E. R. wrote:
Creating new sheet, enter some numbers, change style to monetary... negatives display in red.
- thank you Carlos : tried New Sheet :
: enter some numbers, change style to monetary... negatives display in red
however : No Joy : negative numbers all black
Upload it somewhere so that we can try. -- Cheers / Saludos, Carlos E. R. (from 42.2 x86_64 "Malachite" (Minas Tirith))
On 03/03/17 14:16, Carlos E. R. wrote:
Upload it somewhere so that we can try.
- looked at SusePaste.org , but seemed unsuitable : what is suitable site ? - thanks regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 2017-03-03 13:33, ellanios82 wrote:
On 03/03/17 14:16, Carlos E. R. wrote:
Upload it somewhere so that we can try.
- looked at SusePaste.org , but seemed unsuitable :
what is suitable site ? - thanks
I thought susepaste. Google drive might be another. But it is a small file, 14 KB, simple to email to those wanting it. I opened your file, and here negative numbers show in red. I thought it might be a locale related problem, but the settings for cells are "default locale", so here it uses Spanish. -- Cheers / Saludos, Carlos E. R. (from 42.2 x86_64 "Malachite" (Minas Tirith))
On 03/03/17 15:14, Carlos E. R. wrote: > On 2017-03-03 13:33, ellanios82 wrote: >> On 03/03/17 14:16, Carlos E. R. wrote: >>> Upload it somewhere so that we can try. >> - looked at SusePaste.org , but seemed unsuitable : >> >> what is suitable site ? - thanks > I thought susepaste. Google drive might be another. But it is a small > file, 14 KB, simple to email to those wanting it. > > I opened your file, and here negative numbers show in red. I thought it > might be a locale related problem, but the settings for cells are > "default locale", so here it uses Spanish. > - thank you : i tried deleting at my XFCE DE .config files for libreoffice : but , negative numbers still appear in Black , not Red ........... - seems curious that OpenOffice can open this same file , and display negative numbers correctly in Red ....... thanks regards ... -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
On 03/03/17 15:23, ellanios82 wrote: > On 03/03/17 15:14, Carlos E. R. wrote: >> On 2017-03-03 13:33, ellanios82 wrote: >>> On 03/03/17 14:16, Carlos E. R. wrote: >>>> Upload it somewhere so that we can try. >>> - looked at SusePaste.org , but seemed unsuitable : >>> >>> what is suitable site ? - thanks >> I thought susepaste. Google drive might be another. But it is a small >> file, 14 KB, simple to email to those wanting it. >> >> I opened your file, and here negative numbers show in red. I thought it >> might be a locale related problem, but the settings for cells are >> "default locale", so here it uses Spanish. >> > - thank you : i tried deleting at my XFCE DE .config files > > for libreoffice : but , negative numbers still appear in Black , not Red > > ........... > > - seems curious that OpenOffice can open this same file , and display > negative numbers correctly in Red > > ....... - as you suggest : could be that this is a Locale related problem { perhaps Greece is hyper-allergic to Red-Ink Negative Numbers and budget deficits} ...... cheers ... -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
participants (2)
-
Carlos E. R.
-
ellanios82