WANG, Xiaoyun arsnova at gmail.com writes:
I have cells whose contents are a reference to a cell in
another sheet plus a suffix of a number. So it goes like this:
=ANOTHERSHEET.CELLnumber. I want to fill a series of cells with the
same expression with only incremental/decremental changes
On Mon, 2006-08-21 at 13:49 +1000, Ross Johnson wrote:
Barrie Backhurst wrote:
Linux Format magazine(www.linuxformat.co.uk) has been running a tutorial
on OOo macros, written by Mark Bain. The 5th and final installment is
included in the latest issue(lxf84, October 2006), which I received
Should it take 5 hours to download open office?
Hi,
I am using version 2.0 of Open Office and
my problem is:
I had recently download a MS Power point
presentation (size 55Mb) and found that manypictures can not be
opened with Open office Impress.
Please advise what is the possible cause
and how can I use Open office to correct these
Hello!
I finally get managed to upload the latest binaries of OpenOffice.org
Premium version 2.0.3. Please test it with us and share your experience.
If no problems occur this will be the final 2.0.3 of Openoffice.org
Premium release.
The installer kits (for Linux and Windows in English,
Hello,
I apologize for this email since the answer is probably in the website but I
want to make sure that I am not doing anything wrong. I own a business with 6
employees. I would like to use Open Office in all the computers at my company.
Is it legal to use Open Office for my company? I
Hi,
When I try and download Open office all I get is an Unknown file, something
to do with BT torrent.
I am running windows XP home, BT broad band.
Any ideas or suggestions
Many thanks
Stan
Sehr geehrtes openoffice-team,
ich habe versucht mehrmals Sprachen-dictionaries herunterzuladen so
wie beschrieben. Leider bekomme ich keine Verbindung mit dme dazugehörigen
Server.
Die Meldung erscheint, dass keine Internetverbindung besteht, wel. jedoch der
Fall ist.
Was kann
when I try to start OpenOffice.org
2.0.app I get an error window with the text: Can't make alias
Are you running OpenOffice.org 2.0.app (the application icon) from
within the Applications folder?
Yes.
It appears that X11 is not starting. Can you confirm that X11 is
working on your system
Good morning.
On 20/08/2006, at 17:38, MICHELE GRISHAM wrote:
Should it take 5 hours to download open office?
Well, that depends on the connection that you have to the internet.
If you have a slow connection, it can take that long.
---
Shoshannah Forbes
http://www.xslf.com
MICHELE GRISHAM wrote:
Should it take 5 hours to download open office?
If you have a 56 kilobit modem connection it will take about 5 hours -
provided you aren't surfing the web at the same time.
Here's how you can estimate it:
I think the Windows version is roughly 100 Mbytes, which is
Hi Celal.
On 20/08/2006, at 23:08, Celal Gurcuoglu wrote:
I would like to use Open Office in all the computers at my
company. Is it legal to use Open Office for my company?
Yes, it's legal. You can install it on as many machines as you like,
give it out to your clients etc.
You can find
Celal Gurcuoglu wrote:
Hello,
I apologize for this email since the answer is probably in the website but I
want to make sure that I am not doing anything wrong. I own a business with 6
employees. I would like to use Open Office in all the computers at my company.
Is it legal to use Open
Maurice, as no one else has answered this yet I'll just say what little I
know.
On Saturday 19 August 2006 16:16, Maurice Batey wrote:
[...]
(2) Under 'HTML Source Text, the help info says:
In HTML Source mode, you can view edit the gags of HTML.
Save the doc as a plain text
Dear Sir or Madam,
I have got a Apple CoreDue with Mac OS X 10.4 and I would like to install
OpenOffice. Unfortunately, I can not install X11 because
the Apple write that I have got a newer version. What can I do ???
Best regards
Thorsten Maxara
Kirill S. Palagin kpalagin at phxint.ru writes:
Page 205 of User Guide:
Assume the user has hidden are a few rows or columns
visible cells are to be copied.
Calc behaves differently depending on the method
the intended action to be performed upon them.
Its that selecting
On 8/21/06, Terry [EMAIL PROTECTED] wrote:
To prevent the cell reference changing, you will need to use absolute references
such as =Sheet2.$A$1 The $ signifies that the reference is absolute. If you
are only dragging down, only the row number needs to be absolute. If you are
only dragging
On Sun, 2006-08-20 at 12:38 -0700, Christian Mainusch wrote:
ich habe versucht mehrmals Sprachen-dictionaries herunterzuladen so
wie beschrieben. Leider bekomme ich keine Verbindung mit dme
dazugehörigen Server.
Die Meldung erscheint, dass keine Internetverbindung besteht, wel.
jedoch der
On Mon, 2006-08-21 at 10:30 -0400, Randy Jonasz wrote:
Hey everyone,
Has anyone had experience with printing from Open Office to a HP 1320
Laser Printer? The problem I have is that every time I want to print
from OO, the error light flashes on the printer. The print job
doesn't start
Celal:
According to the LGPL under which OpenOffice.org is released, you are not
limited to the number of computers you can install it on.
Please reply to the users@openoffice.org mailing list. only.
James M.
-Original Message-
From: Celal Gurcuoglu [EMAIL PROTECTED]
Sent: Aug 20,
On 8/21/06, G. Roderick Singleton [EMAIL PROTECTED] wrote:
On Mon, 2006-08-21 at 10:30 -0400, Randy Jonasz wrote:
Hey everyone,
Has anyone had experience with printing from Open Office to a HP 1320
Laser Printer? The problem I have is that every time I want to print
from OO, the error
On Mon, 2006-08-21 at 11:08 -0400, Randy Jonasz wrote:
On 8/21/06, G. Roderick Singleton [EMAIL PROTECTED] wrote:
On Mon, 2006-08-21 at 10:30 -0400, Randy Jonasz wrote:
Hey everyone,
Has anyone had experience with printing from Open Office to a HP 1320
Laser Printer? The problem I
I'm having the same problem. When I try to install the X11 under
options on the Tiger CD (or from downloads on the Apple site), it
says that I can' because I already have a newer version of X11 --
which must have arrived with one of the software updates
(perhaps???). Spotlight finds X11
On Mon, 2006-08-21 at 11:56 -0400, Fran Mennick wrote:
I'm having the same problem. When I try to install the X11 under
options on the Tiger CD (or from downloads on the Apple site), it
says that I can' because I already have a newer version of X11 --
which must have arrived with one of
All,
Cédric Bosdonnat has once again won the Developer Article contest
with a superb article on UNO, Understanding UNO. What is UNO? As
Bosdonnat explains, UNO is the central concept in OpenOffice.org
because it manages all the OpenOffice.org internal objects UNO
provides a way to
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
=CONCATENATE(0;G3)
where G3 is the column with zip codes. (The data was brought into a
numeric field, hence the leading zero fell off.) But this only shows
this formula in
I'm not a Mac user yet (very soon, hopefully) but check Apple support article
at
http://docs.info.apple.com/article.html?artnum=301229 which states the
following:
Want to reinstall a part of Mac OS X 10.4 after it's already installed?
It's
easy!
1. Insert your Mac OS X 10.4
Hi
I have a lot of blank pages in a Writer project that remained after I deleted
all the text in them. Can you please tell me how I can get rid of all the blank
pages?
Thanks
Phil
Hi,
I have seen many JAVA and VB examples with Openoffice, but it would be
really helpful if you can provide us some information on POWERBUILDER
with Openoffice. Especially OLE automation concepts connecting
Openoffice spreadsheets to poweruilder application.
Regards
REDDY
This email and
Sehr geehrte Damen und Herren,
ich nutze Open Office.org, und bin damit sehr zufrieden. Eine Frage habe ich
allerdings. Wie kann ich die Sprache von Englisch auf Deutsch umstellen ?
Ich Nutze den Writer.
Gruß: Oliver Hausen
schöne bunte Bilder... by Oliver Hausen
Hi,
I have two questions, the first is if we are able as a corporation to use
this product for office use or is it limited to residential use?
My second question is If we are able to use this product we wish to make a
contribution to support your association, is there a location on
Hi,
I am using OO 2.0.3 and have questions aboutusing
toolbars in Draw:
1. The help document explains that one can add toolbars to the
list under "View" - "Toolbar" by selecting Customize. When I do that on
that pop-up screen, e.g. the "Circles and Ovals", and click OK, that
toolbaris not
I wish to choose the UK spelling dictionary.
In Writer, via tools spellcheck options, I select the UK
dictionary, which works during that checking session.
However, next time I run a check (or when the program checks
automatically) it has reverted to the US spellings.
The same for the
On 8/21/06, G. Roderick Singleton [EMAIL PROTECTED] wrote:
On Mon, 2006-08-21 at 11:08 -0400, Randy Jonasz wrote:
On 8/21/06, G. Roderick Singleton [EMAIL PROTECTED] wrote:
On Mon, 2006-08-21 at 10:30 -0400, Randy Jonasz wrote:
Hey everyone,
Has anyone had experience with printing
Which mailing list should I subscribe to for security bulletins?
On Monday 21 August 2006 11:55 am, CarlP wrote:
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
=CONCATENATE(0;G3)
where G3 is the column with zip codes. (The data was brought into
a numeric field, hence the leading
- Original Message -
From: CarlP [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Monday, August 21, 2006 5:55 PM
Subject: [users] Concatenate a string in Calc
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
On Mon, 2006-08-21 at 14:11 -0300, Roger Comeau wrote:
Hi,
I have two questions,
the first is if we are able as a corporation to use this product for
office use or is it limited to residential use?
You not only can use OOo in this environment you are encourage to give
it to
- Original Message -
From: Dan Lewis [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Monday, August 21, 2006 7:00 PM
Subject: Re: [users] Concatenate a string in Calc
snip
Why not just format the column for US Zip Codes in the first
place?
If you want just the first 5
On Monday 21 August 2006 12:11 pm, Roger Comeau wrote:
Hi,
I have two questions, the first is if we are able as a
corporation to use this product for office use or is it limited to
residential use?
My second question is If we are able to use this product we
wish to make a
- Original Message -
From: Bill Piper [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Monday, August 21, 2006 6:37 PM
Subject: [users] Making the UK dictionary permanent.
I wish to choose the UK spelling dictionary.
In Writer, via tools spellcheck options, I select the UK
Thanks for the pointer.
Unfortunatly solution with macro is not very easy to sell to users after
they are spoiled by competition.
I will keep it in toolbox for special cases.
WBR,
K. Palagin.
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of Terry
Sent: Monday,
After inserting the correct diacritecs, using Insert/Special Character, into a
document I decided to change fonts by using the stylist. It did not change the
font
used for the diacritics. I did not discover this until I printed the whole
document,
wasting a bunch of paper. Why does inserting
Am Montag, 21. August 2006 12:41 schrieb Oliver Hausen:
Sehr geehrte Damen und Herren,
ich nutze Open Office.org, und bin damit sehr zufrieden. Eine Frage habe
ich allerdings. Wie kann ich die Sprache von Englisch auf Deutsch umstellen
? Ich Nutze den Writer.
Es kommt auf die Version von
Try a datapilot instead of subtotals.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
CarlP wrote:
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
=CONCATENATE(0;G3)
Your cell is formatted as text or ToolsOptionsCalcViewShow
Formulas is checked.
Oliver Hausen wrote:
Sehr geehrte Damen und Herren,
ich nutze Open Office.org, und bin damit sehr zufrieden. Eine Frage habe
ich allerdings. Wie kann ich die Sprache von Englisch auf Deutsch
umstellen ? Ich Nutze den Writer.
Hallo,
Wie Deine Installation von OpenOffice.org ist diese Liste
Am Montag, 21. August 2006 21:07 schrieb Guido Pinkernell:
Am Montag, 21. August 2006 12:41 schrieb Oliver Hausen:
Sehr geehrte Damen und Herren,
ich nutze Open Office.org, und bin damit sehr zufrieden. Eine Frage habe
ich allerdings. Wie kann ich die Sprache von Englisch auf Deutsch
Am Montag, 21. August 2006 17:58 schrieb Phil Moseley:
Hi
I have a lot of blank pages in a Writer project that remained after I
deleted all the text in them. Can you please tell me how I can get rid of
all the blank pages? Thanks
There is a FAQ entry which you could try. If it doesn´t work
Dan Lewis wrote:
On Monday 21 August 2006 11:55 am, CarlP wrote:
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
=CONCATENATE(0;G3)
where G3 is the column with zip codes. (The data was brought into
a numeric field, hence
Andreas Saeger wrote:
CarlP wrote:
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
=CONCATENATE(0;G3)
Your cell is formatted as text or ToolsOptionsCalcViewShow
Formulas is checked.
Ah, it is formatted as text, as
Barrie Backhurst wrote:
Unfortunately, I had only scanned the article when making my original
post. Having digested it further, the original developer is Noel Power
[...]
Thanks a lot Barrie. Useful information!
Cor
--
Cor Nouws
Done a test ride and want to keep the car?
See
Harold Fuchs wrote:
- Original Message -
From: CarlP [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Monday, August 21, 2006 5:55 PM
Subject: [users] Concatenate a string in Calc
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
Now I see that my expectations were a bit off (actually by a lot). I
have filed RFE
http://www.openoffice.org/issues/show_bug.cgi?id=68841
And in the mean time will try using macro in Writer.
Thanks a lot!
WBR,
K. Palagin.
-Original Message-
From: Ross Johnson [mailto:[EMAIL
Short answer is no. You cannot use writer to compose emails from
within Outlook. You can of course compose emails in writer (using
spell check,etc...) then copy and paste the text into an outlook 'new
mail'.
/paul
ps, its best not to ask your whole question in the subject line...
On 8/22/06,
You'd be best to check out the license that comes with OOo, but if
your asking can you use and distribute OOo free of charge, the answer
is YES.
OOo can be obtained free of charge (apart from any download / CD
purchase costs - which would be negligible). You can then replicate
OOo onto as many
CarlP wrote:
Andreas Saeger wrote:
CarlP wrote:
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
=CONCATENATE(0;G3)
Your cell is formatted as text or ToolsOptionsCalcViewShow
Formulas is checked.
Ah, it is formatted
On Mon, 2006-08-21 at 21:26 +0200, Guido Pinkernell wrote:
Am Montag, 21. August 2006 21:07 schrieb Guido Pinkernell:
Am Montag, 21. August 2006 12:41 schrieb Oliver Hausen:
Sehr geehrte Damen und Herren,
ich nutze Open Office.org, und bin damit sehr zufrieden. Eine Frage habe
ich
Boa tarde,
Instalamos o openoffice 2.0, em 03 computadores de rede na nossa empresa em
16/08/06.
O pessoal não está encontrando dificuldades para usá-lo.
Hoje surgiu uma dúvida: Na rede temos algumas pastas com senha para abrir, e
todas as pastas que abrimos a partir do computador que tem o
Am Montag, 21. August 2006 22:41 schrieb G. Roderick Singleton:
Sorry for this addendum but I found it difficult to find info about
changing language settings in version 2.0.3. Apparently nothing on the
main site of openoffice.org, I am afraid. So I thought a link to this
German info page
On Thu August 17 2006 03:23, juan abba wrote:
Once I open a PPS file with POWER POINT, just pressing F5 will start the
slide show, automatically changing the slides, one after the other and
playing sound if it exists without interruption.
If I do same with IMPRESS, F5 will do following,
On Wed August 16 2006 16:11, + John Stewart wrote:
When I try to install OpenOffice version 2.0.0 or 2.0.3 I get this error
message:
Internal Error 2755.110, [path]/openofficeorg20.msi
I've tried running it from my desktop and from program files. It also
said something about J2SE 5
On Mon July 24 2006 12:28, + sasi wrote:
[ MODERATED ] ***
Dear sir,
good morning please let us know whether openoffice will suppport the
msoffice merged document if yes how we have to activate that.
it is indeed supported. It is also free to download so that you can test
On Mon July 24 2006 15:28, + William Woolrich wrote:
[ MODERATED ] ***
Forgive the newbie question but I've looked and looked and can't seem to
find the answer in any faq. I'm trying to transition to openoffice from
MS Office. I have a Calc list that, when using excel, I
Please do *not* start a new question by replying to an old one as this causes
several problems:
1) most email software will correctly think that your email is a response to
the email you are replying to, and will indicate this by displaying your
email as a child of the original email
2) because
On Mon, 2006-08-21 at 23:00 +0200, Guido Pinkernell wrote:
Am Montag, 21. August 2006 22:41 schrieb G. Roderick Singleton:
Sorry for this addendum but I found it difficult to find info about
changing language settings in version 2.0.3. Apparently nothing on the
main site of
On Mon, 2006-08-21 at 22:07 +0100, CPHennessy wrote:
On Wed August 16 2006 16:11, + John Stewart wrote:
When I try to install OpenOffice version 2.0.0 or 2.0.3 I get this error
message:
Internal Error 2755.110, [path]/openofficeorg20.msi
I've tried running it from my desktop and
On Fri August 18 2006 07:57, + samuel anwar wrote:
well the first thing you have asked about copying only text from firefox to
writer works finebut the second thing u have mentioned does not
works...even when i try to save a web page containing images and txt by
doing File-- Save Asit
Larry:
I think something here is missing. You must be logged in as an administrative
user or know the credentials of an administrative user in order to install or
re-intall software on the Mac OS X platform.
See my note below where you should be asked this question.
James M.
-Original
On Tue August 15 2006 18:25, + NORMAN T ROTHWELL wrote:
[ MODERATED ]
Dear Open Office,
I have Open Office on my computer and today I tried to access my writing
program and it said that there was a configuration data problem and to call
you guys HLP!
Hi,
On Tue August 15 2006 22:43, + Andy Ligas wrote:
[ MODERATED ] ***
Feeling dumb. I launch OpenOffice into the default app, Writer. I have
no problems toggling among a Writer document, a text document, and the
xterm window. However, I can't toggle to a Draw, Base, Impress,
On Wed August 16 2006 02:44, Philip Rhoades wrote:
CPHennessy,
On Tue, 2006-08-15 at 22:40 +, [EMAIL PROTECTED]
wrote:
On Fri August 11 2006 07:36, Philip Rhoades wrote:
People,
I have a large number of SO7 sxw files that are templates for a
command line, mail merge
On Thu August 17 2006 00:40, + mariopena33 wrote:
[ MODERATED ]
I am using version 1.1 of OpenOffice.org. My problem is excel spread sheet
files .XLS : We have microsoft excel 2000 at work. The Open Office software
opens the excel file, but some of the formula boxes in
On Thu August 17 2006 02:57, + khairul wrote:
How can I get more templates in my OpenOffice.org Impress
As you are not subscribed you may not have seen that:
On Thu August 17 2006 21:07, G. Roderick Singleton wrote:
Start with
http://documentation.openoffice.org/Samples_Templates/index.html
On Fri August 18 2006 20:06, + Paul Young wrote:
[ MODERATED ] ***
I am using OpenOffice 2.0 on a PC. I will shortly be switching to Mac
(OSX) and would like to know if there is a relatively painless method
of doing so.
The documents should open perfectly on the Mac
On Fri August 18 2006 20:08, + Quintin Riis wrote:
I have some files from gamefaqs.com, plaintext files... I want to shrink
the font size, then remove the hard newlines that are present in the file
so it is smaller when I print. Is there an easy way to do this in
openoffice? note that only
On Sat August 19 2006 14:53, + U.Hesse wrote:
[ MODERATED ]
I am using version X.Y of OpenOffice.org. My problem is :
i can´t in a dokument include a bitmap or other grafik, it´s coming X
Grafik,no bitmap, wat can i do?
kann in Dokument keine Bilder einfügen, kommt nur
Andreas Saeger wrote:
CarlP wrote:
Andreas Saeger wrote:
CarlP wrote:
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
=CONCATENATE(0;G3)
Your cell is formatted as text or ToolsOptionsCalcViewShow
Formulas is
snip
When you format a cell as text it will treat any input as text, even if it
is numeric or starting with a =.
Is that really true? I've not been able to confirm that.
Anyway, I've also not been able to replicate the original problem which is
showing the formula rather than the result.
CarlP wrote:
Harold Fuchs wrote:
- Original Message - From: CarlP [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Monday, August 21, 2006 5:55 PM
Subject: [users] Concatenate a string in Calc
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as
Bob Long wrote:
Andreas Saeger wrote:
When you format a cell as text it will treat any input as text, even if it
is numeric or starting with a =.
Is that really true? I've not been able to confirm that.
Yes, it's true, and I'm guessing that this is the only time you need to
use
On Tue, 2006-08-22 at 10:10 +1000, Bob Long wrote:
Andreas Saeger wrote:
CarlP wrote:
Andreas Saeger wrote:
CarlP wrote:
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
=CONCATENATE(0;G3)
Your cell is
Sigve:
Thank you for the update on the status of your installation of
OpenOffice.org for MacOSX Intel. I use the same release and was
the individual who QA'd and released it. See my comments on your
problems below after your last comment. I have removed the other
information as it is correct.
CPHennessy wrote:
On Fri August 18 2006 20:06, + Paul Young wrote:
[ MODERATED ] ***
I am using OpenOffice 2.0 on a PC. I will shortly be switching to Mac
(OSX) and would like to know if there is a relatively painless method
of doing so.
The documents should
Has anyone here made a CD cover in OpenOffice 1.1.1? The only thing I
found in help was CD labels - I need a *cover* (back and front). I
searched the Internet and only found a marketing cover for burning
copies of OpenOffice. I am making my own music CD and want to create a
cover.
Chris
Chris Aitken wrote:
Has anyone here made a CD cover in OpenOffice 1.1.1? The only thing I
found in help was CD labels - I need a *cover* (back and front). I
searched the Internet and only found a marketing cover for burning
copies of OpenOffice. I am making my own music CD and want to create
Hi,
I'm a newbie but could not find an answer to this. Is it possible to use
only selected OO applications (Draw, Impress) while still using other
MS Office apps like Word and Excel? TIA.
-
Yahoo! Messenger with Voice.
On Monday 21 August 2006 11:16 pm, Oscar Renter wrote:
Hi,
I'm a newbie but could not find an answer to this. Is it possible to use
only selected OO applications (Draw, Impress) while still using other
MS Office apps like Word and Excel? TIA.
Of course, but once you use the
On Friday 02 June 2006 09:57, Immanuel CRC Office wrote:
Sven and Doris wrote:
Hi Guys
Just wanted to ask whether you are going to develop a email
client like Outlook 2003 cause I want out of MS Office.
Sven:
There are many free and good email clients out there, so rather
than
-Original Message-
From: Fred A. Miller [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 22, 2006 7:36 AM
To: users@openoffice.org
Subject: Re: [users] Using MS Office with selected OO packages?
On Monday 21 August 2006 11:16 pm, Oscar Renter wrote:
Hi,
I'm a newbie but
Sure, why not.
Just properly associate file extensions with applications.
-Original Message-
From: Oscar Renter [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 22, 2006 7:17 AM
To: users@openoffice.org
Subject: [users] Using MS Office with selected OO packages?
Hi,
92 matches
Mail list logo
