On 08/28/2010 09:49 PM, Johnny Rosenberg wrote:
2010/8/28 Andy Chaplinperfect-engl...@gmx.de:
On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/28 Jean-Baptiste Faurejbf.fa...@laposte.net:
Le 28/08/2010 16:44, Andy Chaplin a écrit :
Hi all
As far as I
2010/8/29 Andy Chaplin perfect-engl...@gmx.de:
On 08/28/2010 09:49 PM, Johnny Rosenberg wrote:
2010/8/28 Andy Chaplinperfect-engl...@gmx.de:
On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/28 Jean-Baptiste Faurejbf.fa...@laposte.net:
Le 28/08/2010 16:44, Andy Chaplin a écrit :
On 08/29/2010 11:35 AM, Johnny Rosenberg wrote:
2010/8/29 Andy Chaplinperfect-engl...@gmx.de:
On 08/28/2010 09:49 PM, Johnny Rosenberg wrote:
2010/8/28 Andy Chaplinperfect-engl...@gmx.de:
On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/28 Jean-Baptiste
2010/8/29 Andy Chaplin perfect-engl...@gmx.de:
On 08/29/2010 11:35 AM, Johnny Rosenberg wrote:
2010/8/29 Andy Chaplinperfect-engl...@gmx.de:
On 08/28/2010 09:49 PM, Johnny Rosenberg wrote:
2010/8/28 Andy Chaplinperfect-engl...@gmx.de:
On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/29 Johnny Rosenberg gurus.knu...@gmail.com:
2010/8/29 Andy Chaplin perfect-engl...@gmx.de:
On 08/29/2010 11:35 AM, Johnny Rosenberg wrote:
2010/8/29 Andy Chaplinperfect-engl...@gmx.de:
On 08/28/2010 09:49 PM, Johnny Rosenberg wrote:
2010/8/28 Andy Chaplinperfect-engl...@gmx.de:
I found the solution – WITHOUT a macro and listeners and shit…!
I found it in one if the bug reports. It seems to be an undocumented feature.
Here's the steps to success, please tell me if this does not work:
1. Create the different styles, named the same as the possible cell
contents, I
2010/8/29 yahoo-pier_andreit pier_andr...@yahoo.it:
I found the solution – WITHOUT a macro and listeners and shit…!
I found it in one if the bug reports. It seems to be an undocumented
feature.
Here's the steps to success, please tell me if this does not work:
1. Create the different
2010/8/29 yahoo-pier_andreit pier_andr...@yahoo.it:
I found the solution – WITHOUT a macro and listeners and shit…!
I found it in one if the bug reports. It seems to be an undocumented
feature.
Here's the steps to success, please tell me if this does not work:
1. Create the different
Using suse 11.3 ooo from suse (probably gooo) it doesn't work
I am in OpenSUSE 11.2 right now (restarted my computer since last
message) and my OpenOffice.org version is OOO310m21 (Build 9319) and
it's the Novel version, I suppose that's the same as Go-OO, right?
Anyway, my solution
2010/8/29 Drew usersl...@paintedfrogceramics.com:
Using suse 11.3 ooo from suse (probably gooo) it doesn't work
I am in OpenSUSE 11.2 right now (restarted my computer since last
message) and my OpenOffice.org version is OOO310m21 (Build 9319) and
it's the Novel version, I suppose that's
2010/8/29 Johnny Rosenberg gurus.knu...@gmail.com:
2010/8/29 Drew usersl...@paintedfrogceramics.com:
Using suse 11.3 ooo from suse (probably gooo) it doesn't work
I am in OpenSUSE 11.2 right now (restarted my computer since last
message) and my OpenOffice.org version is OOO310m21 (Build
Howdy,
Just tried the forumla technique above with Ubuntu 10.04 and the gooo
3.2.1 from the 'proposed' repository - not sure when that is going to
roll to GA, but soon...anyway works like a charm here.
Drew
Sorry for my ignorance, but what is GA…?
Oh sorry - the proposed
Il 29/08/2010 20:29, Johnny Rosenberg ha scritto:
2010/8/29 Drewusersl...@paintedfrogceramics.com:
Using suse 11.3 ooo from suse (probably gooo) it doesn't work
I am in OpenSUSE 11.2 right now (restarted my computer since last
message) and my OpenOffice.org version is OOO310m21 (Build 9319)
2010/8/29 Drew usersl...@paintedfrogceramics.com:
Howdy,
Just tried the forumla technique above with Ubuntu 10.04 and the gooo
3.2.1 from the 'proposed' repository - not sure when that is going to
roll to GA, but soon...anyway works like a charm here.
Drew
Sorry for my ignorance,
2010/8/29 yahoo-pier_andreit pier_andr...@yahoo.it:
Il 29/08/2010 20:29, Johnny Rosenberg ha scritto:
2010/8/29 Drewusersl...@paintedfrogceramics.com:
Using suse 11.3 ooo from suse (probably gooo) it doesn't work
I am in OpenSUSE 11.2 right now (restarted my computer since last
message)
Hi all
As far as I can see it's only possible to have 3 levels of conditional
formatting. Does anyone know of a trick or workaround to get more
conditions to apply. Ideally i would like six and any suggestions would
be gratefully appreciated.
Le 28/08/2010 16:44, Andy Chaplin a écrit :
Hi all
As far as I can see it's only possible to have 3 levels of conditional
formatting. Does anyone know of a trick or workaround to get more
conditions to apply. Ideally i would like six and any suggestions
would be gratefully appreciated.
2010/8/28 Jean-Baptiste Faure jbf.fa...@laposte.net:
Le 28/08/2010 16:44, Andy Chaplin a écrit :
Hi all
As far as I can see it's only possible to have 3 levels of conditional
formatting. Does anyone know of a trick or workaround to get more
conditions to apply. Ideally i would like six
On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/28 Jean-Baptiste Faurejbf.fa...@laposte.net:
Le 28/08/2010 16:44, Andy Chaplin a écrit :
Hi all
As far as I can see it's only possible to have 3 levels of conditional
formatting. Does anyone know of a trick or workaround to
2010/8/28 Andy Chaplin perfect-engl...@gmx.de:
On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/28 Jean-Baptiste Faurejbf.fa...@laposte.net:
Le 28/08/2010 16:44, Andy Chaplin a écrit :
Hi all
As far as I can see it's only possible to have 3 levels of conditional
formatting.
2010/8/28 Johnny Rosenberg gurus.knu...@gmail.com:
2010/8/28 Andy Chaplin perfect-engl...@gmx.de:
On 08/28/2010 05:45 PM, Johnny Rosenberg wrote:
2010/8/28 Jean-Baptiste Faurejbf.fa...@laposte.net:
Le 28/08/2010 16:44, Andy Chaplin a écrit :
Hi all
As far as I can see it's only
2009/9/27 Brian Barker b.m.bar...@btinternet.com:
At 17:30 26/09/2009 -0500, Wade Smart wrote:
My question is - I have 36 different cells to apply pretty much the same
conditional formatting to. Is there a way to do this without doing it to
each and every one?
Yes: you need just to select
Wade Smart wrote:
OMG!!! hours and hours of work done in like an hour :D
Great!
... My question is - I have 36 different cells to apply
pretty much the same conditional formatting to. Is there a way to do
this without doing it to each and every one?
My guess:
1. Select the cell with the
OMG!!! hours and hours of work done in like an hour :D
I have been cleaning up my sheets to make them easier to read now that
these formulas from today are working.
Last thing I want to do is format the background of the cell to one of
two colors based on a series of numbers.
I have that
At 17:30 26/09/2009 -0500, Wade Smart wrote:
My question is - I have 36 different cells to apply pretty much the
same conditional formatting to. Is there a way to do this without
doing it to each and every one?
Yes: you need just to select all the cells at once before you apply
the
Is it not possible in Calc to conditionally change the background colour
of a cell? I see that it is possible to change the text style, but I
cannot find where/how to change the colour.
Thanks,
Keith
-
To unsubscribe,
2009/9/10 Keith Clark keithcl...@k-wbookworm.com
Is it not possible in Calc to conditionally change the background colour
of a cell? I see that it is possible to change the text style, but I
cannot find where/how to change the colour.
Thanks,
Keith
It certainly is possible.
1. See
On Thu, 2009-09-10 at 14:59 +0100, Harold Fuchs wrote:
2009/9/10 Keith Clark keithcl...@k-wbookworm.com
Is it not possible in Calc to conditionally change the background colour
of a cell? I see that it is possible to change the text style, but I
cannot find where/how to change the
Hi everyone
I have a problem with conditional formatting in Calc.
I want to apply a style to a cell if the value in another cell meets a certain
criteria. For example, I want the style in cell A1 to change if A2 is greater
than 100.
As far as I can see, it is only possible to apply the
-engl...@gmx.de]
Sent: Wednesday, August 12, 2009 1:44 PM
To: users@openoffice.org
Subject: [users] Conditional Formatting
Hi everyone
I have a problem with conditional formatting in Calc.
I want to apply a style to a cell if the value in another cell meets a certain
criteria. For example, I want
Hello ,
Can anyone let me know how to change the font weight of a text in a Table -
Cell in Open Document Template based on a condition.
Basically i want the Cell value to be bold when the cell content starts with
'C#'
Colene Merrilda :
Can anyone let me know how to change the font weight of a text in a Table -
Cell in Open Document Template based on a condition.
Basically i want the Cell value to be bold when the cell content starts with
'C#'
I've not used conditional formatting in OOo before today, but
On 22/07/2008 15:54, Colene Merrilda wrote:
Hello ,
Can anyone let me know how to change the font weight of a text in a Table -
Cell in Open Document Template based on a condition.
Basically i want the Cell value to be bold when the cell content starts with
'C#'
Create a style having the
At 16:54 22/07/2008 +0200, Colene Merrilda wrote:
Can anyone let me know how to change the font weight of a text in a
Table - Cell in Open Document Template based on a condition.
If you really mean a table cell - a cell in table in a Writer
document, that is - then I don't see that there is
I wanted to do this on a writer document. as Brian said.
On Tue, Jul 22, 2008 at 8:49 PM, Brian Barker [EMAIL PROTECTED]
wrote:
At 16:54 22/07/2008 +0200, Colene Merrilda wrote:
Can anyone let me know how to change the font weight of a text in a Table
- Cell in Open Document Template based
Can you do it in a Calc spreadsheet, then insert said spreadsheet into
the Writer document?
Colene Merrilda wrote:
I wanted to do this on a writer document. as Brian said.
On Tue, Jul 22, 2008 at 8:49 PM, Brian Barker [EMAIL PROTECTED]
wrote:
At 16:54 22/07/2008 +0200, Colene Merrilda
On Jan 31, 2008 2:12 PM, Brian Barker [EMAIL PROTECTED] wrote:
At 12:40 31/01/2008 -0500, you wrote:
... I also have to share it with others who use MS Office. If I save
my ods sheet to MS Excel 2003 xml file, ...
Why are you using that format?
That is the only format that gets opened with
Hello,
I am making a small spreadsheet which does some calculations on given
data. However, I also have to share it with others who use MS Office. If
I save my ods sheet to MS Excel 2003 xml file, all the important stuff
works if somebody opens the xml file in MS Office 2003. However,
Hi,
I am trying to conditional format a cell in Calc. In excel, for
instance I can format a
cell to show a function result, if it is greater than 0 only. It goes
somethin like this IF(SUM(A1+B1)=0; ;SUM(A1+B1))
I tried this in Calc, but it just shows the formula, nothing else. Yes
I un chcheked
At 16:05 21/11/2007 -0500, Henning von Roeder wrote:
I am trying to conditional format a cell in Calc. In excel, for
instance I can format a cell to show a function result, if it is
greater than 0 only. It goes something like this
IF(SUM(A1+B1)=0; ;SUM(A1+B1))
I tried this in Calc, but it just
On 21/08/07, Sander Marechal [EMAIL PROTECTED] wrote:
Hello,
Is it possible to apply conditional formating to table cells in Writer?
The ODF specification does seem to allow for it.
--
Sander Marechal
Product Developer
[EMAIL PROTECTED]
Tribal Internet Marketing
Internet MARKeting
yes you can do that.
import a table from a folder.
then place it
From: Harold Fuchs [EMAIL PROTECTED]
Reply-To: users@openoffice.org
To: users@openoffice.org
Subject: Re: [users] Conditional formatting in Writer tables
Date: Wed, 22 Aug 2007 09:14:22 +0100
MIME-Version: 1.0
Received: from
On 22/08/07, Yang Sean [EMAIL PROTECTED] wrote:
yes you can do that.
import a table from a folder.
then place it
snip
Huh?
--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org
Harold Fuchs wrote:
On 21/08/07, Sander Marechal [EMAIL PROTECTED] wrote:
Is it possible to apply conditional formating to table cells in Writer?
The ODF specification does seem to allow for it.
I don't know if it will do what you want but read the Help under
Conditional Styles. It seems you
Hello,
Is it possible to apply conditional formating to table cells in Writer?
The ODF specification does seem to allow for it.
--
Sander Marechal
Product Developer
[EMAIL PROTECTED]
Tribal Internet Marketing
Internet MARKeting van Werven
Larenweg 24
5234 KA 's-Hertogenbosch
The Netherlands
Is conditional formatting possible in Writer? I am working on a
terminology assignment. Each term must have 3 definitions from 3
separate sources. As the document is growing quite long, it would be
wonderful to set up a visual clue as to which definitions have the
necessary number of
mpkirby wrote:
Okay more futzing. Turns out I have some complex macros, so I turned off
automatic updating. But at the time I was manually recalculating. It turns
out that manual recalculation does update macros, but not conditional
formatting.
Further, when you turn recalculation back on
Niklas Nebel wrote:
mpkirby wrote:
Okay more futzing. Turns out I have some complex macros, so I turned off
automatic updating. But at the time I was manually recalculating. It
turns
out that manual recalculation does update macros, but not conditional
formatting.
Further, when you turn
I'm using neo office (open office 2.0.3 based), and I'm having difficulty
with conditional formatting.
I want the text in a cell to be red if the value in it is more than 10% over
the value in the neighboring cell.
So I do something like Cell Value, greater than, m5*1.1 (or whatever the
On Sunday, December 03, 2006 10:19 PM [GMT+1=CET], mpkirby
[EMAIL PROTECTED] wrote:
I'm using neo office (open office 2.0.3 based), and I'm having
difficulty with conditional formatting.
I want the text in a cell to be red if the value in it is more than
10% over the value in the neighboring
Joe Smith-4 wrote:
First you have to define a named style. You can format a cell as you
want it to look, then use the Stylist (F11) to define a style from the
current cell. Give your style a name, e.g. GE10.
In the Format Conditional Formatting dialog, choose Cell Value ...
is
mpkirby wrote:
Joe Smith-4 wrote:
First you have to define a named style. You can format a cell as you
want it to look, then use the Stylist (F11) to define a style from the
current cell. Give your style a name, e.g. GE10.
In the Format Conditional Formatting dialog, choose Cell Value
contender wrote:
Conditional formatting recalculates normally.
I found an instance where it does not. That was a case where the cell
contained a formula referencing the last cell in a column. When the
column was extended (so that, consequentially, a different cell became
the
mpkirby wrote:
contender wrote:
Conditional formatting recalculates normally.
I found an instance where it does not. That was a case where the cell
contained a formula referencing the last cell in a column. When the
column was extended (so that, consequentially, a different cell
Message-ID: [EMAIL PROTECTED]
Date: Wed, 15 Nov 2006 14:46:34 +1100
From: Terry [EMAIL PROTECTED]
MIME-Version: 1.0
To: users@openoffice.org
Subject: Re: [users] Calc -Conditional formatting
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Hello Terry/
G. Roderick Singleton wrote at 7:36 on 16 Jul 2006:
On Sat, 2006-07-15 at 14:41 -0700, James E. Lang wrote:
Given that nobody has responded to this in the more than 72 hours that have
passed since I posted it I am going to assume that what I'm trying to do is
so
exotic that nobody
Hi Jim,
James E. Lang wrote:
I am using Calc from the Novel Edition of OpenOffice.org 2.0 (build 2.0.0.1).
[...]
In cell AN2 I normally have 4.00 pt automatic color borders top and left. In
that cell I selected Conditional formatting ... from the Format menu. I
then selected Condition 1
Given that nobody has responded to this in the more than 72 hours that have
passed since I posted it I am going to assume that what I'm trying to do is so
exotic that nobody else on this list has ever tried it. Thus I now ask a new
question. Is there a better place to post my original message?
Hi James,
James E. Lang wrote:
Given that nobody has responded to this in the more than 72 hours that have
You've probably missed my post from 21:17 today, that has been deliverd
about one and a half hour ago.
Greetings,
Cor
--
Cor Nouws Office
www.NouEnOff.nl
Hi Jim
Given that nobody has responded to this in the more than 72 hours that
have
passed since I posted it I am going to assume that what I'm trying to do
is so
exotic that nobody else on this list has ever tried it. Thus I now ask a
new
question. Is there a better place to post my
I am using Calc from the Novel Edition of OpenOffice.org 2.0 (build 2.0.0.1).
I want to eliminate all borders in certain cells when another cell contains the
text Special Case and in order to accomplish this, I defined a style
borderless using a blank cell in which I had eliminated all borders.
Venky --
I can't remember if I replied or not to this issue, but I would look
into using absolute reference instead of relative references.
HTH,
Peter
venky swaminathan wrote:
Hi sir ,
thanks for helping me sir ,
the issue is
i have entered a data for 50 lines ( and i have put
Venky --
I don't fully understand what happened, but look into using absolute
references instead of relative references. You can check the help for
this information. If you need more help, let me know.
Peter
venky swaminathan wrote:
I have major doubt in using calc ... plz help me
issue
Hi sir ,
thanks for helping me sir ,
the issue is
i have entered a data for 50 lines ( and i have put conditional
formating for all the 50 lines ) ...
then i insert a new row after 25 , after insertng the row
all the conditional formating is changed from 25th to 50th line ...
thanks for
I have major doubt in using calc ... plz help me
issue is :
First i create a data for the 50 lines i have put ( conditional formatting )
for all the 50 lines ]
After that i insert a new row after 25 th row .. conditonal format has gone
from 26th to 50 ...
give me a solution for
Hi!
When I press the help button in conditional formatting dialog editor I get a
page with this:
Could not find Help page.
Unfortunately the Help page you selected was not found. The following data
could be helpful in locating the
error:
Help ID:
Doug Thompson wrote:
The problem I'm having is that the address of the cell being tested
(flag) for Conditional Formatting doesn't change relative to the cell
being formatted when the formatting is copied. Thus, a test in B1 when
copied to B2 still evaluates cell A1. What I'm trying to find
On Sunday 13 March 2005 19:59, Doug Thompson wrote:
I have a spreadsheet which contains the results of exporting the
contents of a DB as a *.csv file.
A small number of the records repeat the value of one field, for
example, companyname while the other fields contain unique values
pertaining
68 matches
Mail list logo