On 02/21/2016 02:52 PM, Patrick Shanahan wrote:
> * ellanios82  [02-21-16 07:30]:
>> Hello List ,
>>
>> LibreOffice Version: 5.1.0.3
>> Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
>> CPU Threads: 4; OS Version: Linux 4.4; UI Render: default;
>> Locale: en-US (en_US.UTF-8)
>> ..............
>>
>>   - am not able persuade Negative Numbers to show in Red
>>
>>   - any ideas please , how to fix
>>
>> thanks
> I have:
>   LibreOffice Version: 5.1.0.3
>   Build ID: 10m0(Build:3)
>   CPU Threads: 12; OS Version: Linux 4.4; UI Render: default;
>   Locale: en-US (en_US.UTF-8)
> libreoffice-5.1.0.3-1.1.x86_64
>
> format cells -> select appropriate format
>     user-defined
>     currency
>     number
> 	red negative numbers
  - many thanks

regards

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

On 02/21/2016 03:19 PM, Yamaban wrote:

On Sun, 21 Feb 2016 13:28, ellanios82 wrote:

...

Hello List ,

LibreOffice Version: 5.1.0.3 Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737 CPU Threads: 4; OS Version: Linux 4.4; UI Render: default; Locale: en-US (en_US.UTF-8) ..............

- am not able persuade Negative Numbers to show in Red

- any ideas please , how to fix

Idea: switch of OpenCL (has many bugs on many systems) Menu -> Extras -> Options (Dialog) Left side: - LibreOffice OpenCL

Right side: Remove mark on "allow use of OpenCL"

Store with "Ok"

Restart LibreOffice, Try again via "Cell Format", "show negative number in red"

Have a nice sunday, - Yamaban ...........

- thanks indeed OpenCL wrecked some straight-forward spreadsheet Formulae : LibreOffice Calc probs with formula : =SUM($E$9:E864)-SUM($J$9:J864) OpenCL was cause of problems ......... regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org