buying it? Well, donations are
probably welcome, but that isn't buying, as far as I know.
And it isn't ”our” office suite. I, for example, am a user, just like
most people on this list, and just like you.
Regards
Johnny Rosenberg
- Original Message - From: John Meyer pueblonat
tried it) on OpenOffice.org 3.2 RC1:
=IF(OR(F8=yellow;F8=y);5;0)
=IF(OR(F8=yellow,F8=y),5,0) on the other hand, gives ”Err:501”.
I don't know what build you have. Maybe you use Excel? Excel accepts
commas, as far as I've heard.
Regards
Johnny Rosenberg
Wade
--
Registered Linux User
to pay anything.
Regards
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
start when opening a certain document. I have
written a few (simple) macros that reads from the clipboard, but I am
definitely not some kind of guru or something…
Regards
Johnny Rosenberg
-Eric Wood
CTO
International Plastics, Inc
there.
As someone already mentioned, the syntax is:
=IF(Condition;Value/statement if condition is true;Value/statement if
condition is false)
You can have an IF condition inside another one and so on:
=IF(A1-15;A1 ℃ is rather cold;IF(A135;A1 ℃ is hot;A1
℃ is quite allright))
Regards
Johnny
box.
Any suggestions?
If the receiver is not supposed to edit the document, export to PDF.
If editing should be possible, use the ISO/IEC 26300:2006 format (ODF)
and thee the receiver to install an ODF plugin to their MS Office
suites.
Regards
Johnny Rosenberg
Bob
--
Registered Linux User
2010/1/18 Bob Williams li...@barrowhillfarm.org.uk:
Hi Jonny,
On Monday 18 Jan 2010 18:17:47 Johnny Rosenberg wrote:
2010/1/18 Bob Williams li...@barrowhillfarm.org.uk:
Hi,
I'm using OpenOffice 3.1.1 on openSUSE 11.2. A lot of my correspondents
are stuck with MS Office, so I'm having
2010/1/15 Guy Garside garside...@yahoo.com:
will all the programs you mention open the files and attachments that you
recieve from microsoft programs.?
Most of them.
Regards
Johnny Rosenberg
-
To unsubscribe, e-mail: users
the OpenOffice.org way
with styles…
Regards
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
2010/1/16 Cor Nouws oo...@nouenoff.nl:
Hi Johnny,
Johnny Rosenberg wrote (16-01-10 20:42)
1. Open an empty spreadsheet (or any other spreadsheet)
2. Shift+F11
3. Give your new template a name
4. Hit ↵
5. An error message pops up, reading something like (and I translate
from
2010/1/16 Johnny Rosenberg gurus.knu...@gmail.com:
2010/1/16 Cor Nouws oo...@nouenoff.nl:
Hi Johnny,
Johnny Rosenberg wrote (16-01-10 20:42)
1. Open an empty spreadsheet (or any other spreadsheet)
2. Shift+F11
3. Give your new template a name
4. Hit ↵
5. An error message pops up, reading
Word you
should search for a forum or mail list for Word, not for
OpenOffice.org.
Regards
Johnny Rosenberg
Kind regards,
Tia Danning.
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e
*.deb”, then cd to
the desktop integration folder and run the same command again. Before
I did the last step there was no icons or anything, so the last step
seems to be ”the thing to do” in this case.
Regards
Johnny Rosenberg
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
2010/1/10 Programmer In Training p...@joseph-a-nagy-jr.us:
On 1/9/2010 6:47 PM, Johnny Rosenberg wrote:
2010/1/10 John Boyle jbo...@harbornet.com:
To Users: I use WIN XP, and today at my computer club, we had a presentation
of WIN 7 and the FACT that MANY programs are NOT compatible
. When I said you would have to BACK UP your hard drive,
I meant TOTALLY , not just daily backups, especially when doing the actual
upgrade! This has nothing to do with the dailys you may be doing anyway! :-)
And exactly WHY do you have to do that?
Regards
Johnny Rosenberg
desktop and one Eee PC each), so
there should never be a reason for me to use Windows, unless my
employer forces me to do it, but so far I have used my Eee PC at work
(which has Ubuntu 9.10 installed).
Sorry for being off topic again.
Regards
Johnny Rosenberg
Bob
2010/1/10 Gene Young n2...@cfl.rr.com:
Johnny Rosenberg wrote:
2010/1/10 John Boyle jbo...@harbornet.com:
To ALL: Whether you like it or not, here it is, and you can get angry at
me
for sending it to you, BUT THIS I BELIEVE!!! :o
Yet another reason not to send the crap to this list
. You OpenOffice.org version
3. In which part of OpenOffice.org your problem appears (Calc, Writer,
Draw etc.)
4. What kind of problem you have
Please write back with that information and I am sure someone can
identify your problem and help you solving it.
Regards
Johnny Rosenberg
, as far as I
found out.
But what would I know? Never been there.
Johnny Rosenberg
Or the
Laotians. You can start your search here:
https://www.startpage.com/ (I'd provide a link to results but they don't
do arguments through the url).
--
PIT
2010/1/10 John Boyle jbo...@harbornet.com:
To ALL: Whether you like it or not, here it is, and you can get angry at me
for sending it to you, BUT THIS I BELIEVE!!! :o
Yet another reason not to send the crap to this list then.
Regards
Johnny Rosenberg
haven't used Windows since summer 2007 and I will
never use it again.
Regards
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
, it wasn't aimed at him at all, not even indirectly; it was
aimed at John. That's why he wrote ”John”…
Regards
Johnny Rosenberg
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
commands, e-mail: users-h...@openoffice.org
It might depend on whether you're using ascii or unicode?
Well, it's 2010 now so I guess ASCII is out of the question since 10
years ago or so.
Johnny Rosenberg
Just a thought.
Twayne
2010/1/8 Web Kracked webmas...@krackedpress.com:
Johnny Rosenberg wrote:
Well, I downloaded OpenOffice.org 3.2 RC1 from the
http://www.openoffice.org/ site, unpacked and installed from a
terminal with ”dpkg -i *.deb” in the DEBS folder and then the same
thing in the ”desktop-integration
2010/1/7 TomW tomw...@ctel.net:
Cor Nouws wrote:
Johnny Rosenberg wrote (06-01-10 12:58)
So it seems to be a problem in OpenOffice.org rather than my system, I
believe.
Forgot to mention my OS, by the way. It's Ubuntu 8.10.
Hmm.. since I run 9.10, it *could* be Ubuntu ...
Any other
this is
quite a bit annoying.
Am I the only one who have seen this problem?
Regards
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
2010/1/6 Cor Nouws oo...@nouenoff.nl:
Hi Johnny,
Johnny Rosenberg wrote (06-01-10 10:23)
I have a medium large spreadsheet (maybe 5 sheets, most of them with
around 2000 rows, maybe 10 columns, but I don't think this is a size
issue anyway) and it contains a few buttons, macros
2010/1/6 Cor Nouws oo...@nouenoff.nl:
Johnny Rosenberg wrote (06-01-10 12:58)
So it seems to be a problem in OpenOffice.org rather than my system, I
believe.
Forgot to mention my OS, by the way. It's Ubuntu 8.10.
Hmm.. since I run 9.10, it *could* be Ubuntu ...
Still, we are not running
in October 2009
and the next release will be 10.04 in April 2010 and so on.
If the repositories of Ubuntu 10.04 doesn't contain OpenOffice.org
3.2, Ubuntu 10.10 will, unless there is an even newer version by that
time.
Johnny Rosenberg
2010/1/6 Web Kracked webmas...@krackedpress.com:
Cor Nouws wrote:
Johnny Rosenberg wrote (06-01-10 16:54)
2010/1/6 Cor Nouws oo...@nouenoff.nl:
Johnny Rosenberg wrote (06-01-10 12:58)
So it seems to be a problem in OpenOffice.org rather than my system, I
believe.
Forgot to mention my OS
2010/1/3 jonathon jonathon.bl...@gmail.com:
On Fri, Jan 1, 2010 at 21:34, Johnny Rosenberg wrote:
I actually think it's a good thing that missing characters are substituted.
It is a really bad idea, because it encourages non-portable
documents, with the document creator not knowing why
Okay, that was a lot of text… ;D
2010/1/2 John Jason Jordan johnjas...@gmail.com:
On Fri, 1 Jan 2010 22:34:03 +0100
Johnny Rosenberg gurus.knu...@gmail.com dijo:
I don't know what operating system you are running, but in mine,
Ubuntu 8.10, the character map (gucharmap) is installed by default
has.
No, but there are tons of them out there waiting for you to search for them.
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
2010/1/1 NoOp gl...@sbcglobal.net:
On 12/31/2009 04:13 PM, Johnny Rosenberg wrote:
2009/12/31 NoOp snip:
On 12/31/2009 11:12 AM, NoOp wrote:
On 12/31/2009 10:27 AM, Johnny Rosenberg wrote:
...
I am on Ubuntu 8.10,by the way, I'm not sure I mentioned that… My
other machine, which is running
2010/1/1 Johnny Rosenberg gurus.knu...@gmail.com:
2010/1/1 NoOp gl...@sbcglobal.net:
On 12/31/2009 04:13 PM, Johnny Rosenberg wrote:
2009/12/31 NoOp snip:
On 12/31/2009 11:12 AM, NoOp wrote:
On 12/31/2009 10:27 AM, Johnny Rosenberg wrote:
...
I am on Ubuntu 8.10,by the way, I'm not sure I
2010/1/1 John Jason Jordan johnjas...@gmail.com:
On Fri, 1 Jan 2010 17:19:36 +0100
Johnny Rosenberg gurus.knu...@gmail.com dijo:
2010/1/1 Johnny Rosenberg gurus.knu...@gmail.com:
2010/1/1 NoOp gl...@sbcglobal.net:
On 12/31/2009 04:13 PM, Johnny Rosenberg wrote:
2009/12/31 NoOp snip:
On 12
2009/12/30 NoOp gl...@sbcglobal.net:
On 12/30/2009 01:57 PM, Johnny Rosenberg wrote:
I have a calc document created with earlier versions of
OpenOffice.org, for example OpenOffice.org 3.1. When I opened the file
with OpenOffice.org 3.2 RC1 I noticed that some characters was
”invisible”. I
2009/12/31 NoOp gl...@sbcglobal.net:
On 12/31/2009 03:49 AM, Johnny Rosenberg wrote:
2009/12/30 NoOp ...
Works for me when entered directly and/org when copied from your message
into Calc Writer.
$ cat /opt/openoffice.org/basis3.2/program/versionrc
[Version]
buildid=320m8(Build:9472
AND to me.
I am subscribed, so you don't need to add me to the ”to:” field.
Regards
Johnny Rosenberg
On 12/31/2009 12:33 PM, Johnny Rosenberg wrote:
2009/12/31 Programmer In Training p...@joseph-a-nagy-jr.us:
snip
Have you considered that the issue might be with Ubuntu 8.10 and not
OOo
2009/12/31 NoOp gl...@sbcglobal.net:
On 12/31/2009 10:27 AM, Johnny Rosenberg wrote:
2009/12/31 NoOp :
Works for me. FreeSans and FreeMono have the underlining issues, but
other than that they all seem to render OK.
So some characters are missing when underlining? Well, then SOMETHING
2009/12/31 Johnny Rosenberg gurus.knu...@gmail.com:
2009/12/31 NoOp gl...@sbcglobal.net:
On 12/31/2009 10:27 AM, Johnny Rosenberg wrote:
2009/12/31 NoOp :
Works for me. FreeSans and FreeMono have the underlining issues, but
other than that they all seem to render OK.
So some characters
2009/12/31 NoOp gl...@sbcglobal.net:
On 12/31/2009 11:12 AM, NoOp wrote:
On 12/31/2009 10:27 AM, Johnny Rosenberg wrote:
...
I am on Ubuntu 8.10,by the way, I'm not sure I mentioned that… My
other machine, which is running OpenOffice.org 3.1, has Ubuntu 9.10,
and no issues with FreeSans
(or deny) that this is a bug in OpenOffice.org 3.2 RC1?
Regards
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
, select ”cell value is” and
enter the following (for A2 in this case):
=A1
Then select your new style that should be selected if the statement is true.
Johnny Rosenberg
A reminder in either case would be helpful -- am starting to get
frustrated.
--
Regards Bill
Fedora 12, Gnome 2.28
Evo
won't
work. Then you have to use your web browser and download it manually
from the OpenOffice.org web page, and it all will be slightly more
complicated.
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr
not optimal…
As I said, I always do this kind of stuff on a copy of the original
file, so I can be quite experimental without losing anything.
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional
2009/12/20 Jean-Baptiste Faure jbf.fa...@laposte.net:
Le 20.12.2009 12:35, Johnny Rosenberg a écrit :
I have an ODT that is a mess. Originally I used Arial and Courier New
as the two main fonts in it, but since I found that FreeSans and
FreeMono are more suitable for me, I changed all styles
2009/12/20 Jean-Baptiste Faure jbf.fa...@laposte.net:
Le 20.12.2009 12:35, Johnny Rosenberg a écrit :
I have an ODT that is a mess. Originally I used Arial and Courier New
as the two main fonts in it, but since I found that FreeSans and
FreeMono are more suitable for me, I changed all styles
2009/12/20 TomW tomw...@ctel.net:
Johnny Rosenberg wrote:
2009/12/20 Jean-Baptiste Faure jbf.fa...@laposte.net:
Le 20.12.2009 12:35, Johnny Rosenberg a écrit :
I have an ODT that is a mess. Originally I used Arial and Courier New
as the two main fonts in it, but since I found
- ∞, but not before that date (Excel thinks that 1900 is a
leap year). So I guess this was the reason for having 1899-12-30 as
day 0 instead of 1899-12-31, right? At least it makes sense.
Johnny Rosenberg
-
To unsubscribe, e-mail
2009/12/19 Brian Barker b.m.bar...@btinternet.com:
At 14:07 19/12/2009 +0100, Johnny Rosenberg wrote:
I have two dates and I want to calculate how many days, hours and minutes
it is between them. The dates are 2009-12-22 16:00 and 2010-01-04 07:00,
and as all of you
already know it's 12
an array
with all the numbers, but no '. The same thing with getFormulaArray()
for some reason… So I actually don't know how to find the damn ' in
your file with a macro. Seems like a huge bug to me. That is if there
is no way to detect the ', not just that I couldn't find it.
Johnny Rosenberg
)
where ”value” is a value, for example:
=SUMIF(F2:F1388; 3; G2:G1388)
or
=SUMIF(F2:F1388; A1; G2:G1388)
The last one concatenates ”” with whatever is in A1. I think A1
needs to be a number, though.
Johnny Rosenberg
Thanks in advance.
--
Dotan Cohen
http://what-is-what.com
http
*always*
means Alt and the letter. If OOo does not follow this convention then I
think its authors are in breach of covenant. Can't comment on Linux or Mac
though.
Seems to be Alt on Linux too.
Johnny Rosenberg
--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org
2009/12/11 M Henri Day mhenri...@gmail.com:
2009/12/10 Johnny Rosenberg gurus.knu...@gmail.com
2009/12/10 James Wilde james.wi...@sunde-wilde.com:
On Dec 10, 2009, at 08:27 , Thomas Lange - Sun Germany - ham02 - Hamburg
wrote:
Hmm... In that case it must be either my Sun Keyboard
the locale settings?
That's strange. I have Ubuntu 8.10 and OpenOffice.org Calc 3.1
(vanilla version - not the Ubuntu version) and the default format
seems to be YY-MM-DD, which indeed is the Swedish default format.
Which OpenOffice.org language pack is installed on your system?
Johnny Rosenberg
I
, I cannot find it. Thanks.
I remembered it wrong: I didn't write the bug report, someone else
did. I just commented it (my nick=”guraknugen)… Anyway, here it is:
http://www.openoffice.org/issues/show_bug.cgi?id=47906
Johnny Rosenberg
--
Dotan Cohen
http://what-is-what.com
http
with no bar!
As I said, it's not a very hard work to make your own keyboard layout
in Linux. I did and I have the ”|” at Shift+/. The ”/” is located
where normal layouts has ”7” (I keep all my numbers at the numerical
part of the keyboard and nowhere else). And yes, I have a Swedish
keyboard.
Johnny
like it would be a rather
common operation.
Maybe that's what I already did a couple of years ago…
Johnny Rosenberg
If you can accept a few more characters than just ”14”, you should
know that you don't need 00 for the minutes; 14:0 will work. Or 14:7
for 14:07 and so on.
It is not much
+/: ÷ (That is ”/” on the
numerical part of the keyboard).
And I hate to use an x for a multiplication sign, so I added × and · as well.
And so on…
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional
will display
14:00.
If you can accept a few more characters than just ”14”, you should
know that you don't need 00 for the minutes; 14:0 will work. Or 14:7
for 14:07 and so on.
Not what you are looking for, I know, but as far as I can get without
using extra cells and things like that…
Johnny Rosenberg
2009/12/8 John Meyer pueblonat...@opensuse.us:
I have several sheets in a workbook with data in the same format (same
columns). I want to take that information from all the sheets and put it in
a new sheet. The data is in the same format, but I want a column on the
side that tells me from
fast it is, and what version he decides to use. This
sounds like a OpenOffice.org matter to me, at least.
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h
of functions is that? Is it the Ctrl+F2 dialogue? Well,
probably not, since that dialogue has a Cancel button…
But more details would be nice. Maybe you could upload a screen shot
somewhere and give us a link to it?
Johnny Rosenberg
Many thanks, James
2009/12/6 John Gilchrist ooo.for...@gmail.com:
Thank you!
This sounds too simple!!!
If it sounds too simple, it's probably wrong… But hopefully not in this case…
Regards
Johnny Rosenberg
J. Gilchrist
On 12/5/09, Johnny Rosenberg gurus.knu...@gmail.com wrote:
2009/12/5 John Gilchrist
to Open
Office to gain insight into what to expect.
thanks!
Dan
And the obvious question now is: How can he chat with those?
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e
saying this.
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
. Double click a style to apply the style to the
currently selected page. If more questions, get back here… ☺
Johnny Rosenberg
Sincerely,
J. Gilchrist
On 12/4/09, Guy Voets nimant...@gmail.com wrote:
2009/12/4 Jay Gilchrist ooo.for...@gmail.com:
Dear OOo Users,
I want to combine
very wrong. Has that
been required too in the past?
Johnny Rosenberg
Sweden ≠ Switzerland…
2009/12/5 James Wilde james.wi...@sunde-wilde.com:
Sorry to barge in here, but in normal usage you are right, Michael, that two
spaces after a full stop and colon are no longer required.
However, I
2009/12/5 Clayton ccorn...@openoffice.org:
Johnny Rosenberg wrote:
As a non English speaking person that's very interesting. In Swedish
there has never been an extra space required and I started to learn
English at school in 1975, and nobody ever mentioned an extra space.
So exactly when did
Rosenberg
Alex
Johnny Rosenberg gurus.knu...@gmail.com [Thu, 3 Dec 2009 17:59:46 +0100]:
2009/12/3 Ярослав Райченко gruz...@rambler.ru:
thank you for reply,
i simply trying out linux as it is on my older pc (P1, 120mhz, 200M)
than
this redhat release to decide if it is ok for me
?
Alex
Johnny Rosenberg gurus.knu...@gmail.com [Thu, 3 Dec 2009 17:59:46
+0100]:
2009/12/3 Ярослав Райченко gruz...@rambler.ru:
thank you for reply,
i simply trying out linux as it is on my older pc (P1, 120mhz,
200M)
than
this redhat release to decide if it is ok for me. for instance, i
2009/12/2 newroz suer newroz...@hotmail.com:
What is calc?
OpenOffice.org Calc is the OpenOffice.org spreadsheet application. The
corresponding MS Office application is called ”Excel”.
Johnny Rosenberg
Date: Wed, 2 Dec 2009 12:40:47 +0100
From: josefu...@gmail.com
To: users
, I think both are included in
Puppy Linux by default.
But as soon as you need to do something advanced, none of these will
be a good choice.
Johnny Rosenberg
the main idea is to put to life old gear by means of linux due to
supposedly linux's better performance. with modern gear i am ok
Swedish: Du vet väl att det finns en svensk lista också?
us...@sv.openoffice.org
Johnny Rosenberg
Hallunda (för tillfället)
2.
I have problem with nummerlisting, suddenly it don't work
3.
My tabel in atachement have colapsed, se atyached file
Have a nice day
Mansoor
, som inte kan
något nordiskt språk, och som kanske har samma problem, har ju svårt
att tillgodogöra sig såväl fråga som svar…
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e
there is no
attachment. Please upload your file somewhere and give us a link to
it.
Johnny Rosenberg
With Regards,
SUBRATA NATH
SNX27, Silchar
accept Microsoft Word format. They
want you to convert it to RTF. Yes, Microsoft was involved in that
format to in some way and destroyed it badly, but when you say
”Microsoft Word format” I think most people think you mean DOC or DOCX
format.
Johnny Rosenberg
last time. What more could
you possibly want?
Sorry for not understanding your problem.
Johnny Rosenberg
I appreciate your response to this request and hope to soon see, via an
E-mail, a detailed explanation on how to activate OpenOffice.Org Calc Paste
Special as simply and as well
2009/11/16 NoOp gl...@sbcglobal.net:
On 11/16/2009 09:00 AM, Johnny Rosenberg wrote:
2009/11/16 James Knott james.kn...@rogers.com:
Kelly wrote:
I had used Browse on this website to upload a resume later rec'd an
email from USA Gov saying: Why did it not work? Can you send attachments
could temporary change my operating system to English and see what
happens if you want to (it requires a logout - login), to verify that
what I'm saying here is true…
Johnny Rosenberg
Thanks.
--
Dotan Cohen
http://what-is-what.com
http://gibberish.co.il
2009/11/15 James R. Liebert jiml...@neo.rr.com:
Users may set a Windows system to -MM-DD. All applications
depending on the default system date format then will so display.
At Calc _T_ools menu: _O_ptions: OpenOffice.org Calc: Calculate, OO
users may set default Date format to one of
2009/11/12 Walter Hildebrandt wh2...@gmail.com:
I am still confused of the semicolons. The following is a color coded
summary of what you have said.
1st IF
=IF(ISBLANK(A1) ;*Empty*;*IF(A1=0;no Div;A1-40+STYLE(IF(A140;RedText*
IF(ISBLANK(A1) (test)
*Empty (True)*
*IF(A1=0 ;no
)
2 → no Div (if 1 → true)
3 → A1-40+STYLE(IF(A140;RedText;Default)) (if 1 → false)
4 → A140 (condition)
5 → RedText (if 4 → true)
6 → Default (if 4 → false)
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr
the Delete button (or Backspace).
Johnny Rosenberg
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
--
Zhengquan
only be meaningful
if you had *named* something (like a print-range) O.
Why don't you use the Conditional Formatting menu to do what you want?
--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org
Johnny Rosenberg
that anyway.
I didn't mean to confuse you, sorry if that happened.
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
A:
This
is
is
interesting
The result of this should look like this:
This
is
interesting
Anyone?
Regards
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h
2009/11/7 Brian Barker b.m.bar...@btinternet.com:
At 18:45 07/11/2009 +0100, Johnny Rosenberg wrote:
Create a new style. Call it Invisible and enter in the formatting
code field. Select column A except A1. Make sure A2 is the selected cell of
that range. Conditional formatting - Cell value
… → Font effects. Is the font
colour set to red? Change it back to Automatic.
Does it stil not work? Please send me the whole spreadsheet, or a
similar one that doesn't work, and I will try to debug it for you.
Johnny Rosenberg
When creating the RedText style, I clicked on the “Font Effects” tab
.
Johnny Rosenberg
On Sat, Nov 7, 2009 at 12:10 PM, Brian Barker
b.m.bar...@btinternet.comwrote:
At 11:21 07/11/2009 -0700, Walter Hildebrandt wrote:
I created a test spreadsheet and put 50 in cell A1, 30 in cell A2, and 40
in cell A3. Putting the formula
A1-40+IF(A140;STYLE(RedText);0
this message).
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
2009/11/7 Johnny Rosenberg gurus.knu...@gmail.com:
2009/11/6 Walter Hildebrandt wh2...@gmail.com:
Cell A1 has a number.
Cell B1 is to have how much less, or much more, A1 is than 40.
When A1 is less than 40 the answer in B1 is to be in black.
When A1 is more than 40 the answer in B1
There is no such functionality in OpenOffice.org Calc.
He he… only kidding…
File → Page Preview → Adjust the scale directly by moving that thing
you see between ”Margins” and ”Close Preview”. For more options, click
Format Page and look around among the tabs in the dialog that pops up.
Johnny Rosenberg
it, what do you expect to happen and exactly what actually happens
instead?
Are you trying to do a regular expression search? Do you search in
formulas or in values? Etc etc etc…
Johnny Rosenberg
-
To unsubscribe, e-mail: users
values or vice versa.
But as I said, it's only a guess and nothing more.
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Well, the simple answer would probably be to sort columns D and E.
Johnny Rosenberg
2009/10/26 Walter Hildebrandt wh2...@gmail.com:
My question is, how can I do the following?
There are 200 rows involved. The following explains the question.
Cell A1 has the number 1 in it, cell A2 has 2
2009/10/26 James R. Liebert jiml...@neo.rr.com:
Its = property of it
It's = it has; it is: contraction of it and verb.
Where are the police when you really need them?
Well, we all know this, don't we? So why are you writing this? Does
OpenOffice.org handle this the wrong way?
J.R.
201 - 300 of 759 matches
Mail list logo