Re: [Calc] Automatische Großschreibung

2017-01-22 Thread Wolfgang Jäth
Am 22.01.2017 um 14:24 schrieb Apo: > Wenn deine Tabelle textlastig ist: Evt. nicht Calc, sondern Writer > (Tabelle einfügen) verwenden. > Da funktioniert auch der "weiche" manuelle Zeilenumbruch wie in Writer. > > In Calc bliebe dann nur das sehr unbefriedigende Einfügen von > Leerzeichen, um

Re: [Calc] Automatische Großschreibung

2017-01-22 Thread Josef Latt
Hi, nur mal so nebenbei. Der erste Buchstabe einer Calc-Zelle ist immer klein. Nur bei Zeilenumbrüchen (Strg-Enter) werden die jeweils ersten Buchstaben groß geschrieben, was IMO keinen Sinn macht. Gruß - To unsubscribe,

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
On 1/22/2017 10:32 AM, VinceB. wrote: Hi Folks: I keep track of my bowling scores in a AOO 4.1.2 Calc file on WIN10 desktop. I take the time to enter scores above a certain threshold in Red font color. I would like to count the number of times a score within a range of cells is above

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Brian Barker
At 11:24 22/01/2017 -0500, Vince Bonly wrote: On 1/22/2017 10:46 AM, Brian Barker wrote: At 10:32 22/01/2017 -0500, Vince Bonly wrote: I keep track of my bowling scores in a AOO 4.1.2 Calc file on WIN10 desktop. I tried: =COUNTIF(D439:K453,>174), but that does not work and did not return any

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Rory O'Farrell
On Sun, 22 Jan 2017 11:24:13 -0500 "VinceB." wrote: > > > On 1/22/2017 10:46 AM, Brian Barker wrote: > > At 10:32 22/01/2017 -0500, Vince Bonly wrote: > >> I keep track of my bowling scores in a AOO 4.1.2 Calc file on WIN10 > >> desktop. I take the time to enter scores

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
Thank you. On 1/22/2017 11:28 AM, Wade Smart wrote: Error Codes https://wiki.openoffice.org/wiki/Calc_Error_Codes -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe,

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Wade Smart
Error Codes https://wiki.openoffice.org/wiki/Calc_Error_Codes -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
On 1/22/2017 10:46 AM, Brian Barker wrote: At 10:32 22/01/2017 -0500, Vince Bonly wrote: I keep track of my bowling scores in a AOO 4.1.2 Calc file on WIN10 desktop. I take the time to enter scores above a certain threshold in Red font color. You probably shouldn't "take the time" to do

COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Vince
Hi Folks: I keep track of my bowling scores in a AOO 4.1.2 Calc file on WIN10 desktop. I take the time to enter scores above a certain threshold in Red font color. I would like to count the number of times a score within a range of cells is above the specified threshold. For example:

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Brian Barker
At 10:32 22/01/2017 -0500, Vince Bonly wrote: I keep track of my bowling scores in a AOO 4.1.2 Calc file on WIN10 desktop. I take the time to enter scores above a certain threshold in Red font color. You probably shouldn't "take the time" to do this, but use conditional formatting to do it

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Wade Smart
Format > Conditional Formatting > Condition Cell Values is [greater than] value = 174 Apply Style {select new style, choose a color} Just select a range of cells to apply to. Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005

COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
Hi Folks: I keep track of my bowling scores in a AOO 4.1.2 Calc file on WIN10 desktop. I take the time to enter scores above a certain threshold in Red font color. I would like to count the number of times a score within a range of cells is above the specified threshold. For example:

Re: [Calc] Automatische Großschreibung

2017-01-22 Thread Jörg Schmidt
> From: Holger Schulz [mailto:q...@gmx.net] > Sent: Sunday, January 22, 2017 1:43 PM > To: users-de@openoffice.apache.org > Subject: Re: [Calc] Automatische Großschreibung > > > Am 2017-01-22 um 13:25 schrieb Jörg Schmidt : > > > Zwar finde ich es nicht so toll das wir

Re: [Calc] Automatische Großschreibung

2017-01-22 Thread Apo
Wenn deine Tabelle textlastig ist: Evt. nicht Calc, sondern Writer (Tabelle einfügen) verwenden. Da funktioniert auch der "weiche" manuelle Zeilenumbruch wie in Writer. In Calc bliebe dann nur das sehr unbefriedigende Einfügen von Leerzeichen, um auf die nächste Zeile zu kommen. Am

Re: [Calc] Automatische Großschreibung

2017-01-22 Thread Apo
Hallo Holger, wie erzeugst du den Zeilenumbruch? Wenn du ihn "erzwingst" mit Enter, ließe sich das Verhalten erklären, da so ein neuer "Absatz" generiert wird. Bei Einstellung "automatischer Zeilenumbruch" (Format>Zellen>Eigenschaften>Ausrichtung) solltest du eigentlich ununterbrochen vor

Re: [Calc] Automatische Großschreibung

2017-01-22 Thread Jörg Schmidt
Hallo, > From: Holger Schulz [mailto:q...@gmx.net] > > Wie geht das? Sobald Text im Spiel ist und der Text den > Zellinhalt (und keine > > Formatierung) repräsentiert ist der Beginn dieses Textes > eigentlich imnmer auch > > der Anfang eines Satzes. > > Nein. Ziemlich sicher nicht. Nicht

Re: [Calc] Automatische Großschreibung

2017-01-22 Thread Jörg Schmidt
Hallo, > From: Holger Schulz [mailto:q...@gmx.net] > > Extras | Autokorrektur-Optionen | Optionen | "Jeden Satz mit einem > > Großbuchstaben beginnen" > > Klingt komisch, weil es sich überhaupt nicht um einen > Satzanfang handelte. Wie geht das? Sobald Text im Spiel ist und der Text den

Re: [AOO-Templates]

2017-01-22 Thread Martin Groenescheij
On 22/01/17 3:12 PM, Harry Pearsall wrote: I hate this silly program I have apache open office 4 ; Using an application you hate is Silly. I's even more silly not to tell what your problem is because we're so stupid we can't guess it. I am tendering my CV which I have sent many

Thank You!

2017-01-22 Thread Georgy Rock
For Open Office. Thank you Very Much georgy -- Georgy Rock www.georgy-rock.com www.remember-freedom.com http://jubileestreet.blogspot.com/ PO Box 434105 Maplewood, MO 63143

[AOO-Templates]

2017-01-22 Thread Harry Pearsall
I hate this silly program I have apache open office 4 ; I am tendering my CV which I have sent many times in word but now I am not able to