On 03/03/17 15:54, Carlos E. R. wrote:

Try creating a new user, login, and then create or open that sheet. If black, change the user locale in the desktop or CLI, login again, try again the sheet.

Also, run the command "locale" and post the result here, so that we can also try.

- thank you Carlos : I'll give it a go meantime : #locale LANG=en_US.UTF8@euro LC_CTYPE=en_US.UTF8@euro LC_NUMERIC="en_US.UTF8@euro" LC_TIME="en_US.UTF8@euro" LC_COLLATE="en_US.UTF8@euro" LC_MONETARY="en_US.UTF8@euro" LC_MESSAGES=POSIX LC_PAPER="en_US.UTF8@euro" LC_NAME="en_US.UTF8@euro" LC_ADDRESS="en_US.UTF8@euro" LC_TELEPHONE="en_US.UTF8@euro" LC_MEASUREMENT="en_US.UTF8@euro" LC_IDENTIFICATION="en_US.UTF8@euro" LC_ALL= ......... regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On 03/03/17 15:54, Carlos E. R. wrote:

On 2017-03-03 14:36, ellanios82 wrote:

...

On 03/03/17 15:18, Patrick Shanahan wrote:

...

btw: your negative numbers show as red for me

- as Carlos suggested : maybe this might be a Greece Locale

problem , Try creating a new user, login, and then create or open that sheet. If black, change the user locale in the desktop or CLI, login again, try again the sheet.

Also, run the command "locale" and post the result here, so that we can also try.

- strike me pink : as Carlos suggested : created new user & flamed up LO and . . . created new spreadsheet : Negative numbers show up Red !! : brilliant - thank you. - can you imagine some method to persuade LO Red Negatives for my original user? thanks , regards ... -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On 03/03/17 20:55, Carlos E. R. wrote:

The brute force attack is to delete the entire libreoffice config directory

- i flamed up LO as root , and opened a new spreadsheet : Great Joy : Negative Numbers showed in Red. Next , i deleted entire ~/.config/libreoffice Finally , i copied /root/.config/libreoffice to my home directory ~/.config/libreoffice and did "chown" to myself Result : All Perfect Thank you so much , Carlos , and Patrick ....... regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

On 03/03/17 23:25, Patrick Shanahan wrote:
> * ellanios82  [03-03-17 16:22]:
>> On 03/03/17 20:55, Carlos E. R. wrote:
>>> The brute force attack is to delete the entire libreoffice config directory
>>   - i flamed up LO as root , and opened a new spreadsheet :
>>   Great Joy : Negative Numbers showed in Red.
>>
>> Next , i deleted entire ~/.config/libreoffice
>>
>> Finally , i copied /root/.config/libreoffice to my home directory
>> ~/.config/libreoffice  and did "chown" to myself
>>
>> Result : All Perfect
>>
>> Thank you so much , Carlos , and Patrick
> Why would you run libreoffice as root? (/root/.config/libreoffice)

   - no intention to do that : just tried LO as root : result

  Neg. Numbers in Red OK : then copied config files to myself as user


Now using LO as user : Neg Numbers in Red OK


thanks

.........



-- 
To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org
To contact the owner, e-mail: opensuse+owner@opensuse.org

On 03/03/17 23:43, Carlos E. R. wrote:

There was no need to be root. Simply exit LO, remove or rename ~/.config/libreoffice, then enter LO again.

- curiously , did that , but , Neg Numbers returned in Black ......... regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

* Carlos E. R. [01-01-70 12:34]:

On 2017-03-03 23:47, ellanios82 wrote:

...

On 03/03/17 23:43, Carlos E. R. wrote:

...

There was no need to be root. Simply exit LO, remove or rename ~/.config/libreoffice, then enter LO again.

- curiously , did that , but , Neg Numbers returned in Black

Ah, that's interesting. Yet the new user worked right, negs in red?

I'm about convinced that it is related to the locale defined in your desktop.

yes, perhaps locale=<choice> oocalc <spreadsheet> locale=en_US.UTF-8 oocalc <spreadsheet> locale=en_US.UTF8@euro oocalc <spreadsheet> your post/exampe err:

locale en_US.UTF8@euro locale: unknown name "en_US.UTF8@euro" even google fails to find it.

locale -a |grep euro br_FR@euro ca_ES@euro de_AT@euro de_BE@euro de_DE@euro de_LU@euro en_BE@euro en_IE@euro es_ES@euro eu_ES@euro fi_FI@euro fr_BE@euro fr_FR@euro fr_LU@euro ga_IE@euro gl_ES@euro it_IT@euro nl_BE@euro nl_NL@euro

maybe that be the problem pt_PT@euro sv_FI@euro wa_BE@euro and I may be all wet:

locale en_US.UFT-8 locale: unknown name "en_US.UTF-8" but google does not fail here

but that is what yast assigned my system(s). and my systems do not complain about it. but I am neither a lawyer or expert in the matter. https://gcc.gnu.org/onlinedocs/libstdc++/manual/localization.html -- (paka)Patrick Shanahan Plainfield, Indiana, USA @ptilopteri http://en.opensuse.org openSUSE Community Member facebook/ptilopteri Photos: http://wahoo.no-ip.org/gallery2 Registered Linux User #207535 Photos: http://wahoo.no-ip.org/piwigo @ http://linuxcounter.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org

> On 04/03/17 01:01, Carlos E. R. wrote:
>> I'm about convinced that it is related to the locale defined in your 
>> desktop
>
> - how best to do this ? [ believe i set it with yast ]
>
> .....
  - thanks : done that : now locale is :

# locale
LANG=en_US.UTF8
LC_CTYPE=en_US.UTF8
LC_NUMERIC="en_US.UTF8"
LC_TIME="en_US.UTF8"
LC_COLLATE="en_US.UTF8"
LC_MONETARY="en_US.UTF8"
LC_MESSAGES=POSIX
LC_PAPER="en_US.UTF8"
LC_NAME="en_US.UTF8"
LC_ADDRESS="en_US.UTF8"
LC_TELEPHONE="en_US.UTF8"
LC_MEASUREMENT="en_US.UTF8"
LC_IDENTIFICATION="en_US.UTF8"
LC_ALL=
.........

  have a good week-end
  cheers
...



-- 
To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org
To contact the owner, e-mail: opensuse+owner@opensuse.org