Re: A question

[Brian Barker]

At 13:39 14/11/2016 +0700, Paul Itipong wrote:
I would like to know if I can change the font color by using IF 
Function as an example below.

=if((a1+b1)<5;red(a1+b1);green(a1+b1))


You probably know the answer is No! But you can achieve this 
differently but very easily. In the cell itself, just put the formula as usual:

=A1+B1
Then format the result cell or cell range:
o Go to Format | Cells... | Numbers | Format Code (or right-click | 
Format Cells... | Numbers | Format Code).

o Enter: [RED][<5]0;[GREEN]0 for the Format Code.

You can adjust the numeric format code - shown as "0" above - as 
desired, of course.


You can do more complex things using Format | Conditional 
Formatting..., but that is not necessary here.


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

A question

[Itipong (Paul)]

Dear Sir or Madam

I would like to know if I can change the font color by using IF Function as an 
example below.

=if((a1+b1)<5;red(a1+b1);green(a1+b1))

I cannot find a solution or an example on the OpenOffice Help.  So please 
advise.

Your assistance is much appreciated.

Sincerely,
Paul

Re: Problème de dictionnaire

[Hagar Delest]

Hi,

This is an English speaking list.
French dic is installed by default if you've installed the French version of 
the installer.
In such case, just reset your profile: 
https://forum.openoffice.org/en/forum/viewtopic.php?f=74=12426#p58403

Beware, you're not subscribed to the list. You may miss other replies.
See: http://openoffice.apache.org/mailing-lists.html#using-mailing-lists

Hagar

Le 13/11/2016 à 15:40, nicole rulmont a écrit :

Bonjour,
J'utilise OpenOffice depuis de nombreuses années, avec beaucoup de plaisir.
J'ai téléchargé la dernière version, mais le dictionnaire français est absent! 
Le correcteur orthographique souligne tous les mots en rouge...
Doit-on  télécharger le dictionnaire français séparément ou s'agit-il d'un 
oubli de programmation?
Merci de votre attention,
Nicole Rulmont




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Problème de dictionnaire

[nicole rulmont]

Bonjour,
J'utilise OpenOffice depuis de nombreuses années, avec beaucoup de plaisir.
J'ai téléchargé la dernière version, mais le dictionnaire français est 
absent! Le correcteur orthographique souligne tous les mots en rouge...
Doit-on  télécharger le dictionnaire français séparément ou s'agit-il 
d'un oubli de programmation?

Merci de votre attention,
Nicole Rulmont

--
Nicole Rulmont
6 rue du Verger
THEVRAY
27330 MESNIL-EN-OUCHE
Tél: 06 06 45 81 73
Mail: nicolerulm...@yahoo.fr


---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel 
antivirus Avast.
https://www.avast.com/antivirus


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Neue Version und Probleme

[Martin Wening]

Hallo,

ich nutze seit Jahren OpenOffice. Seit ich die neue Version heruntergeladen
habe, und ich habe diese auch mehrmals dann de- und neuinstalliert,
funktioniert die Rechtschreibprüfung nichtmehr. Also ist alles rot
hinterlegt, und ich bin für das Studium auf Rechtschreibfehlerfreiheit
angewiesen...

Unten steht Deutsch standard, bei Lunguistik ist auch alles ok laut
Internet... aber es ist offensichtlich kein Lexikon oder so hinterlegt und
ich bin da absolut überfragt wie ich das hinbekommen soll... normal sollte
ja bei Neuinstallation alles passen... aber es geht auch im Falle der
Neuinstallation nicht...

Ich würde mich über Hilfe sehr freuen


Martin Wening

Re: spell check

[Hagar Delest]

Try to reset your profile as described here: 
https://forum.openoffice.org/en/forum/viewtopic.php?f=74=12426#p58403

Beware, you're not subscribed to the list. You may miss other replies.
See: http://openoffice.apache.org/mailing-lists.html#using-mailing-lists

Hagar

Le 13/11/2016 à 15:17, tfe...@nycap.rr.com a écrit :

I use and have love your product. I cannot seem to get the spell check to work. 
Help
Thomas A Ferri
tfe...@nycap.rr.com

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: spell check

[Rory O'Farrell]

On Sun, 13 Nov 2016 14:17:42 +
 wrote:

> I use and have love your product. I cannot seem to get the spell check to 
> work. Help
> Thomas A Ferri
> tfe...@nycap.rr.com
> 

The normal cure for this problem is to delete or rename your OpenOffice User 
Profile.  Details of the User Profile for various operating systems are given in

https://forum.openoffice.org/en/forum/viewtopic.php?f=74=12426

If you are using Windows close OpenOffice and the Quickstarter. Open File 
Explorer. Copy and paste %appdata%\OpenOffice\4 in the File Explorer Address 
Bar and press Enter. Rename the "user" folder. Start OpenOffice.

This cures most spellcheck problems

It can sometimes happen that an installation produces a faulty user profile 
"out of the box". The above fix works in the vast majority of cases.

-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

spell check

[tferri]

I use and have love your product. I cannot seem to get the spell check to work. 
Help
Thomas A Ferri
tfe...@nycap.rr.com

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org