On September 2, 2007, Joe Conner wrote:
The dollar sign is used for absolute reference. If you want each new
cell to have an adjusted reference then delete the dollar sign and then
the reference will adjust as you seem to want.
Ian Stephen wrote:
Hi users
I have a spreadsheet with
hi there,
i have a great problem. it was already mentioned, but i didnt find answers.
i have a large document wiith many images inserted as links to local files.
suddenly the links were broken.
they had been changed from file:///C:/pathname/filename.jpg to
file:///pathname/filename.jpg and dont
Hello,
Is there any language pack matching for the 2.3 developper snapshot
version ?
Where can I find it ?
Many thanks
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Betty Leach wrote:
I am using version 2.2 of OpenOffice.org. My problem is:
Understanding how to add web site address to the spell check
ignore list so they do not have red lines under them.
I will appreciate any help you can give me.
Betty
Hi Betty
Two possibilities
J.A. de Vries wrote:
On 2007-08-28 @ 16:53:22 (week 35) Sander Marechal wrote:
Is there a way to define new colors, or use RBG syntax in the
number-format to get a darker green?
As far as I know not.
To my knowledge only CYAN, GREEN, BLACK, BLUE, MAGENTA, RED, WHITE and
YELLOW are accepted
Hi
I'm trying to convert an openoffice writer document to docbook using the
built-in save-as export filter. My issue is that the conversion seems to mark
bulleted lists as ordered lists, rather than itemized lists. Because of
this my post-processing on the docbook produces numbered output
Hi
I'm trying to convert an openoffice writer document to docbook using the built-in save-as
export filter. My issue is that the conversion seems to mark bulleted lists as ordered
lists, rather than itemized lists. Because of this my post-processing on the
docbook produces numbered
Hi,
Give NeoOffice a go www.neooffice.org It is based on the same
source code but integrates better with Mac OS X and does not use X11.
See http://www.neooffice.org/neojava/en/features.php for more details.
Hope this helps
On 31 Aug 2007, at 03:36, Russell Evelyne Fowler wrote:
Hi,
I'm discovering the Xforms feature in OpenOffice, which I find quite
powerful. But the problem is that the people I will send a form don't
always have OpenOffice (and sometimes can't install it because of
administrative restrictions). I saw you can export an xform in PDF
format, but I
I've toyed with the XForms to PDF feature, and it seems as though these aren't
fully-featured XForms, but rather, Adobe-specific forms that require the payware
version of Acrobat to actually submit. Somebody please correct me if I'm wrong.
-Matthew Harrison
Quoting Boris Ratak [EMAIL
Hallo users,
I have a set of data which continually grows, with varying amounts
of data at varying intervals.
When I make an x-y chart, the data range gets limited to the last
entry in the data, so that I have to modify the range every time
I add data.
Is it possible to make the x-y chart so that
Hallo Hans,
[EMAIL PROTECTED] schreef:
I have a set of data which continually grows, with varying amounts
of data at varying intervals.
When I make an x-y chart, the data range gets limited to the last
entry in the data, so that I have to modify the range every time
I add data.
Is it possible
Hallo Cor,
Op maandag 03 september 2007 schreef Cor Nouws aan users@openoffice.org:
I have a set of data which continually grows, with varying
amounts of data at varying intervals. When I make an x-y
chart, the data range gets limited to the last entry in the
data
CN Issue
How do I vertically center text on a page?
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.
For either Linux or Windows, any fonts installed for the SYSTEM should
be available for use by OO. This includes any of the gazillion or so TTF
fonts available for download (free or paid) all over the web.
Depending on system, configuration, etc., it may require restarting OO
and/or rebooting
On Monday 03 September 2007 13:29:42 Henrich Pifko wrote:
hi there,
i have a great problem. it was already mentioned, but i didnt find answers.
i have a large document wiith many images inserted as links to local files.
suddenly the links were broken.
they had been changed from
On Monday 03 September 2007 09:36:21 am Joe Marks wrote:
How do I vertically center text on a page?
Either use blank spacing set at different font sizes above your text or
just use your printer controls through your printer driver so it will be
centered vertically when you print.
--
At 06:36 03/09/2007 -0700, Joe Marks wrote:
How do I vertically center text on a page?
There are messy ways of doing this: one is to adjust the spacing
above and below a paragraph (in Format | Paragraph...) in step - that
is, equally - until the next paragraph just spills over beyond the
hi fajar, thank you for your answer.
search/replace would be fine, but it works only with text (and the
problem is in the links, which are hidden for search - even in the
raw format of the .odt document, opened by a binary-code editor).
btw, in my case link change was only file:///C:/path...-
On September 3, 2007, Sander Marechal wrote:
J.A. de Vries wrote:
On 2007-08-28 @ 16:53:22 (week 35) Sander Marechal wrote:
Is there a way to define new colors, or use RBG syntax in the
number-format to get a darker green?
snip
To my knowledge only CYAN, GREEN, BLACK, BLUE, MAGENTA, RED,
Hi,
What you need to do is edit the handouts page. Click View - Handout
Page.
You can edit the number of slides and their size etc etc on this
page. The number of slides can be selected from the choice on the left.
To move or resize slides highlight a slide and click Format -
Position and
Hi,
I don't think there are any Open Source solutions for OCR. Well there
is one (Tesseract) but its installation/use on OS X is not well
documented or supported. If you have the stomach for it try http://
code.google.com/p/tesseract-ocr/
There's something about installing it here
Hi,
You can either scan the image in another application and then insert
the picture into OpenOffice. This will also allow you to edit the
picture before you insert it also.
The other solution I can suggest is to try NeoOffice, which is based
on the code of OpenOffice but integrates better
Hi,
To save the file as a PDF, which can then be printed from Preview
click File - Export as PDF
If this is not to your liking, the Aqua version of OpenOffice which
is better integrated with OS X is under development and will
hopefully be ready soon. In the meantime NeoOffice is much
Hi,
You don't provide any details of the problem or what system you are
using.
No-one can help you if they don't know what your problem is!
If you provide some details of what you are trying to do and what
goes wrong then someone will be kind enough to give you a hand.
On 30 Aug 2007,
Hi,
I'm not sure what OpenOffice2007 is... the current version is 2.2.1
as far as I am aware... and it is free to download from
www.openoffice.org
It sounds like the problems you are having might be due to trying to
install from a memory stick. Try copying the files to your computer
Hi,
I don't personally have any experience with Base but there should be
some information here http://dba.openoffice.org/
Hope this helps
On 29 Aug 2007, at 14:24, [EMAIL PROTECTED] wrote:
Hi
I Have downloaded OpenOffice 2.2.1 yesterday to attempt to rub a MS
access
97 database on new
Hi,
As no-one has answered your question, may I suggest trying NeoOffice,
which integrates much better with OS X and does not require X11.
It is based on the same code as OpenOffice and has all the same (and
actually a few more, http://www.neooffice.org/neojava/en/
features.php) and can be
Hi,
I have never used the password protection features of OpenOffice but
from what I understand its not worth risking mission-critical
information on it. Someone correct me if I'm wrong.
I don't know anything about your software and its implementation but
maybe a password protected
Use F1 to open Help. Then click the Index tab. Enter Navigator in the
Search term box. Finally, Look down the list for the word Navigator.
Double click it to get the information that you want in the right side of
the screen.
A detailed explanation of what the Navigator is and how you
Hi Hans,
[EMAIL PROTECTED] schreef:
This does not seem to be exactly what I tried to mean :)
Today I have for example 50 sets of data. When I make an x-y
chart, the range is limited to row 50. Tomorrow I may add
maybe 5 sets of data, next week 3 sets, the day after that
1 set. Every time I
Hi Hans,
[EMAIL PROTECTED] schreef:
This does not seem to be exactly what I tried to mean :)
Today I have for example 50 sets of data. When I make an x-y
chart, the range is limited to row 50. Tomorrow I may add
maybe 5 sets of data, next week 3 sets, the day after that
1 set. Every time I
I have been looking for instructions on dba.openoffice.org, but all I
can find are circular references that bring me back to the document
index. A search on postgres comes up with exactly one hit on a
discussion about templates.
I am running Slackware 11.0 with the XFCE X-Windows manager. I
Hello
Bob McConnell schrieb:
I have been looking for instructions on dba.openoffice.org, but all I
can find are circular references that bring me back to the document
index. A search on postgres comes up with exactly one hit on a
discussion about templates.
I am running Slackware 11.0 with
Hi,
Glad to hear the problem is solved, sorry I couldn't have been more
useful. You might want to post your solution by replying to this
email and putting users@openoffice.org in the To: field and
describing what it was you did that fixed the issue. That way, if
anyone else has the same
Hi,
See this thread http://www.openoffice.org/servlets/BrowseList?
list=usersby=threadfrom=1708803 for information on how to launch
differenct 'aspects' of OpenOffice on the mac without using blank
template documents, but rather actual shortcuts. Note: the solution
given was lacking a
On 3 Sep 2007 at 16:59, Henrich Pifko wrote:
hi fajar, thank you for your answer.
search/replace would be fine, but it works only with text (and the
problem is in the links, which are hidden for search - even in the
raw format of the .odt document, opened by a binary-code editor).
btw, in my
HELP WHEN I WANT TO SAVE A SPREADSHEET TO A CD OR FLOPPY DISK, I CALL
FOR THE SAVE AS , A BOX COMES UP WITH A HEADING OF SAVE AS. AND IN THE BODY
IT SHOWS C: /DOCUMENTS AND SETTINGS. IT LISTS THE DOCUMENTS, BUT THEY CANNOOT
BE BROUGHT UP. I GO TO MY DOCUMENTS AND DOWNLOAD A
1. Using capitals only is in most situations equal to shouting. It's also
hard to read.
2. What do you mean when you say that it will not respond to save as?
Exactly what did you do and exactly what happened? Often when using Save As,
you want to change the spreadsheet's name or file type. What
Mechtilde Stehmann wrote:
Hello
Bob McConnell schrieb:
I have been looking for instructions on dba.openoffice.org, but all I
can find are circular references that bring me back to the document
index. A search on postgres comes up with exactly one hit on a
discussion about templates.
I am
** Reply to message from Johnny Rosenberg [EMAIL PROTECTED] on Mon, 3
Sep 2007 22:30:25 +0200
1. Using capitals only is in most situations equal to shouting. It's also
hard to read.
2. What do you mean when you say that it will not respond to save as?
Exactly what did you do and exactly
I am using version 2.2 of OpenOffice.org. My problem is: I just downloaded
the program and was told that I could use this in place of Microsoft Word
and could e-mail it to another computer (w/o OpenOffice) and it could be
opened if they have Word. I tried this and it wouldn't open.
Since I am new
When adding text to a spreadsheet cell I do not want to start with a
capitol letter, How do I turn this off?
How do I turn off automatic line feed when pressing the enter key?
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
Hello,
Just installed Open Office but every time I attempt to open a RTF the
program crashes and gives me an error report.
Any idea what the problem is?
Thanks,
Chris Harvey
Hi. My name is Penny Ambler. I just purchased Office
Suite 2007 and I am having a real difficult time using
the program because I've never used Microsoft Office
and just don't know how. Could you please send me an
owner's manual? Thanks. penny
3941 Viceroy St.
Portage, IN 46368
Hi
I was wondering if anyone could help me with a query please? I am using
your open office and I am finding it really wonderful. My query is when I
am using the equivalent programme to Microsoft Excel and have a spread
sheet, I am unsure of which icon is used to find the sum of. With Excel
I use Lotus Smartsuite and there is a way of writing macros using {LEFT},
{RIGHT}, {END}{DOWN} and @ Functions.
Is there anything similar in Open Office, and if there is, please could you
give ma a simple way to get started?
Please bear in mind that I am by no means a computer Whizz kid!!
Dear All,
Please help.I have been working with the help files Writer-Forms.Following the
example instructions
for a drop down list without a connection to a database/table source .I ended
with a rectangular box with circle;triangle;etc on one line instead of each
shape on a new line in a drop
Looking for a word program that I can make and adjust schedules and forms.Can
you help?
Thanks
Ron
On Sunday 02 September 2007 07:12:00 pm Stan Goodman wrote:
What you got for your $20 was that you didn't have to download the
application yourself and burn it onto a DVD or several CDs. It did save
you some time.
OpenOffice.org will fit on one CD at least six times.
--
Jack Gates
On Sun, 02 Sep 2007 14:38:14 -0600
Richard Harper wrote:
I am using OpenOffice version 2.2. My problem is that I don't seem to
be able to open a WDB file.
What you are experiencing is an issue called Vendor Lockin. This
occurs when a company, in your case Microsoft, wants to keep all their
I am using Open Office 2.2.1 and my problem is the 64k of overflow.
I am writing many long and complex equations and can only input maybe 1/5th
of my formula; how do I over come this?
--
End Communication
My career adivser at the employment office told me about your site. She said
i could download a program for free instead of buying Word. Is it compatible
to Windows XP? I don't know what 2P2 is.
Thanks for your help,
Jane
On Mon, 3 Sep 2007 14:42:38 -0700
Donna Runnestrand [EMAIL PROTECTED] wrote:
could e-mail it to another computer (w/o OpenOffice) and it could be
opened if they have Word. I tried this and it wouldn't open.
After writing your document with OpenOffice, go to the save as menu and
tell the
On Mon, 3 Sep 2007 16:54:10 EDT
[EMAIL PROTECTED] wrote:
Just installed Open Office but every time I attempt to open a RTF the
program crashes and gives me an error report.
Any idea what the problem is?
Possibly a bad RTF file?
What does the error report say?
--
MELVILLE THEATRE ~
Pada tanggal 04/09/2007 4:42, Donna Runnestrand Menulis :
I am using version 2.2 of OpenOffice.org. My problem is: I just downloaded
the program and was told that I could use this in place of Microsoft Word
and could e-mail it to another computer (w/o OpenOffice) and it could be
opened if they
On Sun, 2 Sep 2007 18:28:45 -0500
Diana Workman [EMAIL PROTECTED] wrote:
Looking for a word program that I can make and adjust schedules and forms.Can
you help?
If by word program you mean a word processor, you just found it.
Go to http://www.openoffice.org and download and install
Pada tanggal 04/09/2007 3:04, Penny Ambler Menulis :
Hi. My name is Penny Ambler. I just purchased Office
Suite 2007 and I am having a real difficult time using
the program because I've never used Microsoft Office
and just don't know how. Could you please send me an
owner's manual? Thanks.
On Mon, 3 Sep 2007 17:38:47 -0700 (PDT)
Jane High [EMAIL PROTECTED] wrote:
She said i could download a program for free instead of buying Word. Is it
compatible to Windows XP?
Go to http://www.openoffice.org and download and install OpenOffice. You get a
word processor and several other
DICK KERN wrote:
When adding text to a spreadsheet cell I do not want to start with a
capitol letter, How do I turn this off?
Go to Tools Autocorrect Options, and uncheck Capitalize first
letter of every sentence
Also, you may want to go to Tools Cell contents and uncheck Autoinput.
Donna Runnestrand wrote:
I am using version 2.2 of OpenOffice.org. My problem is: I just downloaded
the program and was told that I could use this in place of Microsoft Word
and could e-mail it to another computer (w/o OpenOffice) and it could be
opened if they have Word. I tried this and it
Penny Ambler wrote:
Hi. My name is Penny Ambler. I just purchased Office
Suite 2007 and I am having a real difficult time using
the program because I've never used Microsoft Office
and just don't know how. Could you please send me an
owner's manual? Thanks. penny
3941 Viceroy St.
Diana Workman wrote:
Looking for a word program that I can make and adjust schedules and forms.Can
you help?
OpenOffice is a free office suite, incorporating word processor,
spreadsheet, database and graphics application. It's available for free
download from www.openoffice.org .
--
Jane High wrote:
My career adivser at the employment office told me about your site. She
said i could download a program for free instead of buying Word. Is it
compatible to Windows XP? I don't know what 2P2 is.
Thanks for your help,
Jane
You can download OpenOffice for free from
I believe what you want to do is uncheck the box at
Tools-Options-OpenOffice.org Calc-General = Press Enter to move Selection
HTH,
Donald.
Richard Detwiler wrote:
DICK KERN wrote:
When adding text to a spreadsheet cell I do not want to start with a
capitol letter, How do I turn this off?
Debbie Cooper wrote:
Hi
I was wondering if anyone could help me with a query please? I am
using your open office and I am finding it really wonderful. My query
is when I am using the equivalent programme to Microsoft Excel and
have a spread sheet, I am unsure of which icon is used to find
Jane High wrote:
My career adivser at the employment office told me about your site. She
said i could download a program for free instead of buying Word. Is it
compatible to Windows XP? I don't know what 2P2 is.
Thanks for your help,
Jane
I forgot to mention in my previous note.
hi
On 9/2/07, Adrian Try [EMAIL PROTECTED] wrote:
Hi Christian and everyone
On Sat, 2007-09-01 at 11:46 -0700, Christian Einfeldt wrote:
I need some help figuring out how to make OOo handle a massive 6
MB .xls file better.
And Ian Lynch replied:
My first reaction is that a
Full stop is what we in the States call a period or dot I believe Debbie
is entering dates as 2007.08.13 and seeing 8/13/07 (Very ugly, that.)
Anyway, to format dates, choose Format-Cells select the Numbers tab and the
Date Category, then enter .MM.DD in the Format Code box and click the
Jack wrote:
OpenOffice.org will fit on one CD at least six times.
That depends upon what the CD includes.
If all you are talking about is a binary for a single operating
system, then maybe. However that would probably also be an LGPL
violation.
It would be far smarter would be to include the
hi
On 9/2/07, jonathon [EMAIL PROTECTED] wrote:
Howard wrote:
And, fire the guy who made the decision to use a spreadsheet for this
kind of
As a first step, that would be fairly useful.
Demonstrate that there are real and practical consequences to using
the wrong tool for the job.
I hate top posting.
I just installed the Postgresql sdbc 7.5 driver in OOo 2.2.1 on
Slackware Linux. I now have blank icons on that setup as well. It
appears that this problem appears when that driver is installed.
Bob McConnell
N2SPP
OOo Mac User wrote:
Hi,
Does this only occur in Base
Sorry, no help on this; Winxxxe at work and Solaris at home. But to your other
point:
I'm a top poster. It's because I hate reading and re-reading and re-re-reading
the same old stuff. I know what has already been said; I want to know what's new.
Consider a conversation where everyone
On 09/02/2007 11:26 AM, Christian Einfeldt wrote:
On 9/2/07, Andrew Douglas Pitonyak [EMAIL PROTECTED] wrote:
My expectation is that if you solve this problem, then they will have
another blocker for you.
No, if it works better from a strictly functional point of view and costs no
money,
On Monday September 3 2007 13:04, Penny Ambler wrote:
Office Suite 2007 sounds like the microsoft product. You need to contact them
but I'd bet the manual is on the cd that the product came on. OpenOffice is a
free product you can download. If is not related to MS office but is abetter
product
On Tue, 4 Sep 2007 01:34:18 +
jonathon [EMAIL PROTECTED] wrote:
If all you are talking about is a binary for a single operating
system, then maybe. However that would probably also be an LGPL
violation.
No it would not be a license violation, as long as they provided A WRITTEN
OFFER to
On 08/31/2007 11:42 PM, Evelyn Guy wrote:
If open office is free, why did I have to pay $20 for it at Wal-Mart?
Evelyn Guy
Ummm... because you got a CD and also got a book with it?
From the Wal-Mart website:
Items 1-6 of 6 total
Practical OpenOffice.org with CDROM
$53.06
List Price: $53.95
Donald H Locker wrote:
Bob McConnell wrote:
I hate top posting.
If the reader doesn't know the current context, they can start at the
bottom and read up. For most people, reading [listening to] the current
comment is sufficient.
JMHO,
Donald.
No, you can't start at the bottom. You have
On Monday 03 September 2007 09:34:18 pm jonathon wrote:
Jack wrote:
OpenOffice.org will fit on one CD at least six times.
That depends upon what the CD includes.
If all you are talking about is a binary for a single operating
system, then maybe. However that would probably also be an LGPL
hi
Okay, so we have more testing, and I wanted to report the results back to
this list. Holden Aust saved the file as an .ods file. That .ods file was
about 343.5 kb, as opposed to the original 6 mb .xls file. Holden created
the .ods version of the file by copying and pasting to a new
hi
On 9/3/07, NoOp [EMAIL PROTECTED] wrote:
Despite your comments regarding Sun StarOffice, I still suggest that you
consider downloading and giving it a try.
I am having trouble finding a download page that is free as in beer, other
than a trial version. I don't like to use trial
hi
On 9/2/07, Adrian Try [EMAIL PROTECTED] wrote:
The idea is to use the Excel spreadsheet as a database, and access it
using Base.
Here is what I did with my experiment at work:
1. Open OpenOffice.org Base
I am going to give this a shot now. Thanks for setting out the steps so
clearly.
82 matches
Mail list logo