Re: [users] I-T-S

[rlshadow]

-Original Message-
From: James R. Liebert 
To: users@openoffice.org
Sent: Mon, Oct 26, 2009 2:25 pm
Subject: [users] I-T-S



Its = property of "it"
It's = "it" has; "it" is: contraction of "it" and verb.
Where are the police when you really need them?
--
I'm guessing you may have sent this to the wrong list?
If you intended to send it to this list (users@openoffice.org), please reply 
and 
clarify what this has to do with Open Office.

Re: [users] CAN YOU LIVE WITHOUT MICROSOFT OFFICE?

[rlshadow]

Can this thread be killed or moved to another list??

Re: [users] Re: PDF Forms

[rlshadow]

On Wednesday 25 June 2008 06:18:18 am P. De Buck wrote:
> 
It appears you are using Windows from the mail header. On Linux I use Scribus 
and/or OOo to generate PDF forms. I perfer Scribus as it is alittle easier. 
Both programs are avaliable free for windows. Only issue is saving the filled 
in PDF form same as Adobe Reader.

-- 
Russ
Linux register user 441463

-









 
Yes, but isn't this issue (the "only issue" you mention) exactly what the 
original poster was asking how to do?

Re: [users] excel

[rlshadow]

You'll need to go to the Microsoft web site to download Excel.

If you want to download OpenOffice, for free, go to OpenOffice.org.


-Original Message-
From: margaret bagnall <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Mon, 14 Jan 2008 10:15 am
Subject: [users] excel



i woudl like to download excell please help

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




More new features than ever.  Check out the new AOL Mail ! - 
http://webmail.aol.com

Re: [users] Re: Hyperlink is driving me nuts ??

[rlshadow]

 Wouldn't it be a lot easier just to copy, and then paste special > unformatted 
text?


 


 

-Original Message-
From: S Perry <[EMAIL PROTECTED]>
To: users@openoffice.org; [EMAIL PROTECTED]
Sent: Tue, 28 Aug 2007 2:11 pm
Subject: Re: [users] Re: Hyperlink is driving me nuts ??










Another quick method that will work in just about any program is to copy and 
paste the desired material into a text editor, such as Windows Notepad. You 
don't have to save it in Notepad. Then, recopy everything again and paste it 
into your OpenOffice document. The foray into Notepad will automatically delete 
any link material in the background.
  

John King <[EMAIL PROTECTED]> wrote:
  William Case wrote:

> Hi;
> 
> I have spent a couple of hours trying to solve this:
> 
> I have pasted a paragraph from a web site (WikiPedia) into a
> document.
> That pasted paragraph had several links in it. When I pasted
> it into my document it kept all the links but also turned the
> whole paragraph into
> a link of some kind. I have been futzing about (using Help)
> trying to
> turn off those links one-by-one or as a whole selected
> paragraph. I can get rid of the underline and colour
> formatting but I can't seem to remove the links.
> 
> Does anybody have any suggestions?
> 
> I will probably be pasting a lot of online stuff with links to
> my document and I would like to easily remove all the linkages.
> 
> 

Have you tried

Edit - Link - Break links
-- 

John

[EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



   
-
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out. 



 



Email and AIM finally together. You've gotta check out free AOL Mail! - 
http://mail.aol.com

Re: [users] Hide header on OOo Writer

[rlshadow]

 Why are you against changing the page style? That is how you have one page 
without a header and other pages with the header.


 


 

-Original Message-
From: Sam Warren <[EMAIL PROTECTED]>
To: User Group OOo 
Sent: Tue, 10 Jul 2007 12:51 pm
Subject: [users] Hide header on OOo Writer










Does anyone know how to hide a header on just one page without changing the 
page 
style? I don't want the first page of a chapter to show a heading.
   
  Sam Warren

 
-
Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo! Games.



 



AOL now offers free email to everyone.  Find out more about what's free from 
AOL at AOL.com.

Re: [users] Question on use of apostrophe in Calc to enter number as text

[rlshadow]

  Thanks for the responses. This definitely sounds like something odd going on 
with my home computer. And to answer Pradeep's question, I definitely was 
hitting Enter, and the apostrophe still appeared. 
 
 But right now I'm on my work computer, and it works like it should. So I need 
to figure out what it might be about my home computer.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thu, 12 Apr 2007 8:29 AM
 Subject: Re: [users] Question on use of apostrophe in Calc to enter number as 
text
 
  On Thursday 12 Apr 2007, Adrian Try wrote (regarding Re: [users] Question on 
use of apostrophe in Calc to enter number as text):
> > When I type in '0987 (using the key to the right of the semi colon as
> > the apostrophe), the apostrophe DOES appear in the cell.
> >
> > Does anyone else experience this? Is there a different key I should be
> > using as the apostrophe?
>
> I don't experience this. Just the number appears in the cell.

Well, it does appear *while* you type the 0987 in the cell, and disappears 
when you exit the cell.  Maybe, Adrian, the OP was seeing the apostrophe 
prior to exiting the cellOP, please confirm, and if I am not right, 
ignore this message

-- 
Pradeep Srinivas
Bangalore, India

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

   

AOL now offers free email to everyone.  Find out more about what's free from 
AOL at AOL.com.

Re: [users] OO being sold...

[rlshadow]

  Selling OpenOffice is completely legal.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Mon, 9 Apr 2007 6:45 AM
 Subject: [users] OO being sold...
 
  Gidday 
 
 Not sure where to send this info and would like to think that it has been 
brought to your attention already but there seems to be some people selling 
Open Office on Ebay 
 
 http://search.ebay.com.au/search/search.dll?from=R40&satitle=open+office 
 
 I guess that others with so many people doing it, it would be difficult 
keeping track of them and doing something about it (if its illegal that is) 
 
 cheers 
 
 col 
 
 - 
 To unsubscribe, e-mail: [EMAIL PROTECTED] 
 For additional commands, e-mail: [EMAIL PROTECTED] 
 
   

AOL now offers free email to everyone.  Find out more about what's free from 
AOL at AOL.com.

Re: [users] [moderated]only 30 numbers can be added in a column? Any fix?

[rlshadow]

I'm not sure I understand. There is no limitation on the number of numbers that 
can be summed in a column. 
 
If I have a column of numbers from, let's say, cells A1 through A1000, I could 
go to cell B1 and enter the following formula:  =SUM(A1:A1000)  and the formula 
would return the sum of the 1000 numbers.
 
How are you trying to sum the numbers?
 
(You appear to be unsubscribed, so I'm copying you on this reply. Please 
address any replies to users@openoffice.org only, not to me personally.)
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Sun, 4 Mar 2007 10:31 PM
Subject: [users] [moderated]only 30 numbers can be added in a column? Any fix?


Is there any way to get around the apparent limitation of only 30 numbers can 
be added in a column? 
 
- 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 
 

AOL now offers free email to everyone.  Find out more about what's free from 
AOL at AOL.com.

Re: [users] [moderated] YOU MUST GIVE A SUMMARY HERE

[rlshadow]

  Yes, OpenOffice can do this. Go to Help, click Index, and search on booklet 
printing for further information.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Wed, 28 Feb 2007 4:11 AM
 Subject: [users] [moderated] YOU MUST GIVE A SUMMARY HERE
 
  I wish to know if Open Office Write has booklet layout capabilities, 
specifically the abilities to place page numbers at the bottom of both columns, 
which represent two individual booklet pages, on a horizontal 11x 8 1/2 page, 
and also to re-arrange these virtual booklet pages (once layout is completed) 
into the proper sequence for creating masters for publication on copy machines. 
 
(For example, the first side of a master for a 72-page booklet would have to 
contain the booklet pages 72 and 1, the next -- pages 2 and 71, the next -- 
pages 3 and 70, and so forth.)

Word 2002 can do this; Word 97 (which I am using) cannot.

Thank you for your time.

Tim Hall
   

AOL now offers free email to everyone.  Find out more about what's free from 
AOL at AOL.com.

Re: [users] I am using version 2.1 of openoffice.org and cannot see how to make headings and captions extend over the full page of a two-column page

[rlshadow]

  Anthony:
 
 I'm not sure exactly how you tried to add the caption to your picture, but I 
have no trouble doing what it is that I think you're trying to do. Here are the 
stops that I take:
 
 1. I'm in the page with two columns. I select Insert > Picture > From file, 
and find the picture I want to insert.
 
 2. When it is inserted, I right click on it and select Wrap > Page Wrap.
 
 3. I re-size it and position it like I want it.
 
 4. I right click again, and select Caption. I type in the caption that I want 
and click OK.
 
 Let me know if the above steps work for you. 

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Mon, 19 Feb 2007 5:37 AM
 Subject: [users] I am using version 2.1 of openoffice.org and cannot see how 
to make headings and captions extend over the full page of a two-column page
 
  Help!

I am writing a book and the page is set in two columns separated by a gap of 
0,5 
cm.  While I can get pictures, inserted from file, to spread across the two 
columns I cannot do so with either captions to the illustrations or main 
headings.

The only way I have suceeded is to type the wording separately, photocopy and 
then transfer via JASC Paint Shop Photo Album.  This is cumbersome and the type 
appears heavier.

If I try to do this by scanning and transferring to JASC, I cannot get the 
image 
out again!

Grateful for your suggestions

Regards

Anthony Holmes-Walker
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Microsoft Word cannot read Open Office

[rlshadow]

Very true. There are multiple easy ways to avoid this problem, though:
 
1. If the recipient does not need to edit it (only needs to view or print it), 
probably the best method is to send the file as a pdf.
 
2. Or you can save the file in an MS Word format. (File > Save As)
 
3. You can save the file in a "universal" format like txt or rtf.
 
4. You can suggest that your recipient obtains OpenOffice.org.
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Fri, 16 Feb 2007 12:41 PM
Subject: [users] Microsoft Word cannot read Open Office


I'm am using 2.1 version of Open Office.

When e-mailing word documents to others, I'm learning they cannot be
read by Microsoft Word / Office users. 
  
  
  
  

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Selling your product on Ebay

[rlshadow]

This is perfectly legal and is not a "disgusting practice". For people without 
high-speed connections, making OOo available on CD is a valuable service. 
(Witness the number of postings from people who have trouble downloading the 
software.) 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Mon, 12 Feb 2007 10:42 PM
Subject: [users] Selling your product on Ebay


I believe you should be aware someone on Ebay is offering copies to disc of 
Open Office for $8.00 + shipping. 
 
It even has a Open Office label on the disc. 
 
This is a disgusting practice. However he does state he copies and sells it to 
save consumers the trouble of downloading  
 
Just thought you might like to know 
 
R.Gunn. 
 
- 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 
 

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Is OpenOffice Technology a part of OpenOffice.org?

[rlshadow]

Pradeep,
 
I'm sure you're right, and I mis-interpreted the note. Sorry for the confusion! 
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Cc: [EMAIL PROTECTED]
Sent: Wed, 31 Jan 2007 9:27 AM
Subject: Re: [users] Is OpenOffice Technology a part of OpenOffice.org?


On Wednesday 31 January 2007 19:49, [EMAIL PROTECTED] wrote (regarding Re: 
[users] Is OpenOffice Technology a part of OpenOffice.org?):
> Really? The license agreement says that OpenOffice software cannot be
> redistributed in any form??  And the next sentence says that you can't even
> "lend" it??
>
> This seems contrary to everything that I've assumed about OpenOffice.
> Although I have to admit to not reading the license agreement (reading
> through license agreements is not something that I've made a point of
> doing, but maybe I should start).
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
>
Uh, "rlshadow", I think Marc meant that the wordings on the 
openofficetechnology.com site had that clause - not the one OpenOffice.org.

Or am I mistaken, Marc ?
-- 
Pradeep Srinivas
Bangalore, India

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Is OpenOffice Technology a part of OpenOffice.org?

[rlshadow]

Really? The license agreement says that OpenOffice software cannot be 
redistributed in any form??  And the next sentence says that you can't even 
"lend" it??
 
This seems contrary to everything that I've assumed about OpenOffice. Although 
I have to admit to not reading the license agreement (reading through license 
agreements is not something that I've made a point of doing, but maybe I should 
start).
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Wed, 31 Jan 2007 8:50 AM
Subject: Re: [users] Is OpenOffice Technology a part of OpenOffice.org?


I do not know this organization, but in the "License Agreement" you find this: 
"5. You may make copies of the Software under this Agreement for Your personal 
use only. You may not redistribute the Software in any form. You may not lend, 
lease, rent, sublicense, modify, create derivative works from, transfer, sell 
or request donations for any information, software, products or services that 
are part of the Software." It seems to me contradictory with the notion of a 
Free Open Source Software. 
Marc H. 
 
 
Joe a écrit : 
 
> Dear all, 
> 
> I came across this site http://openofficetechnology.com that offers > 
> OpenOffice-Enterprise. 
> 
> Is this a part of OpenOffice.org and hence FOSS? 
> 
> 
> Thanks 
> 
> 
> Best regards 
> JOe 
> 
> - 
> To unsubscribe, e-mail: [EMAIL PROTECTED] 
> For additional commands, e-mail: [EMAIL PROTECTED] 
> 
> 
> 
> 
 
- 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 
 

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] need your help in emailing from openoffice.org writer

[rlshadow]

Very good point. I've been on this list for quite a while, and have heard the 
term tarball mentioned many times, but I have no idea what it might be or what 
I'd do with one if someone sent it to me. 
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Wed, 10 Jan 2007 12:26 PM
Subject: Re: [users] need your help in emailing from openoffice.org writer


What if the employer is using windows only? They probably won't 
even know what a tarball is. 
 
Dotan Cohen wrote: 
> On 10/01/07, James Knott <[EMAIL PROTECTED]> wrote: 
>> Peter Flynn wrote: 
>> > [EMAIL PROTECTED] wrote: 
>> >> I am using version 2.0 of OpenOffice.org. My problem is sending my 
>> >> RESUME via emails - 
>> >> the end user cannot open - what should I do? Please help. 
>> > 
>> > Save the document in PDF and send them the PDF file. 
>> > 
>> > Sending a resume as an editable document is not a good idea: it's too 
>> > prone to accidental (or even malicious) modification. 
>> > 
>> 
>> Many companies ask for a resume in specific formats. I've seen Word, 
>> RTF and plain text. If they specify a format, and you send other, it 
>> may affect your chances of landing that position. 
> 
> Send a tarball with plain text, html, pdf, odf, word, rtf, ps, and 
> even a png image of the resume. :) 
> 
> Dotan Cohen 
> 
> http://what-is-what.com/what_is/xhtml.html 
> http://lyricslist.com/lyrics/artist_albums/289/kansas.html 
> 
> - 
> To unsubscribe, e-mail: [EMAIL PROTECTED] 
> For additional commands, e-mail: [EMAIL PROTECTED] 
> 
> 
 
- 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 
 

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] need your help in emailing from openoffice.org writer

[rlshadow]

I would certainly not recommend telling a potential employer that they need to 
install a specific software package, which they presumably don't currently use, 
in order to read one's resume. 
 
It sounds like a fairly certain strategy for having your resume go unread.
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Wed, 10 Jan 2007 7:22 AM
Subject: Re: [users] need your help in emailing from openoffice.org writer


On 09/01/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: 
> I am using version 2.0 of OpenOffice.org. My problem is sending my RESUME 
> via emails - 
> 
> the end user cannot open - what should I do? Please help. 
> 
> thank you. 
> 
> 
 
Include a link to openoffice.org and explain to them why you do not 
use MS Office. Most people are very receptive to this, and even 
thankful. 
 
Dotan Cohen 
 
http://what-is-what.com/what_is/electromagnet.html 
http://olnu.com 
 
- 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 
 

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] [moderated]

[rlshadow]

  Yes, OpenOffice is totally free, no matter what the size of the corporation, 
or how many computers you're putting it on.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Fri, 5 Jan 2007 7:44 AM
 Subject: [users] [moderated]
 
  HI,

The company I work for was looking for a low-cost alternative to Microsoft 
Office. So I suggested the use of open office. But my director wanted me to 
assure that it was completely free, even for corporation. I guess you now know 
my question. Is open office free even for big corporation.

We want to install it on about 650 PCs.

Thanks for the information,

Sébastien Catudal
Technicien Informatique
Alimentation Couche-Tard, Inc.
Tel : 1-800-361-2612 ext : 4837
Cell : 514-978-8174

   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Recent Docunents

[rlshadow]

What version are you using? There was a bug in a recent version, 2.0.2 I 
believe, that caused the exact behavior that you describe. If you're on 2.0.2, 
I suggest upgrading to a more recent version, and the problem should be solved. 
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Mon, 1 Jan 2007 7:34 AM
Subject: [users] Recent Docunents


Open->Recent Documents has work as expected for a time. Suddenly the menu is
filled with files a have not use recently and saved files are not added to
the "Recent files"-list.
What to do?

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] [moderated] YOU MUST GIVE A SUMMARY HERE

[rlshadow]

 Jann: You can use OpenOffice.org for free, on as many computers as you need. 
This is the case for both non-profit and for-profit organizations, as well as 
for private parties.
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Tue, 2 Jan 2007 3:34 PM
Subject: [users] [moderated] YOU MUST GIVE A SUMMARY HERE


I have questions about cost of use of this program.  I'm at the University
of KY 4-H Youth Development office.  We are starting a Science, Engineering
& Technology (SET) for our state youth (200,000 youth).  One of our areas is
multi-media, we have 4 counties piloting with 120 counties having the option
in Fall, 2007.  

 

Do you give programs free to educational institutions for use?  We are a
non-profit organization.  Please let me know options on your software.
Thanks,

 

Jann Burks, Extension Specialist 4-H YD

University of Kentucky

212 Scovell Hall

Lexington, KY 40546-0064

Phone:  (859) 257-5961 x 249

Fax:  (859) 257-7180

4-H is a community of young people across America who are learning
leadership, citizenship and life skills.

 

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] software such as word, excel, powerpoint

[rlshadow]

Word, Excel, and Powerpoint are Microsoft applications. You'll need to go to 
Microsoft for these.
 
You can download OpenOffice.org from OpenOffice.org, though. OOo has word 
processor, spreadsheet, and presentation components.
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Wed, 3 Jan 2007 11:03 AM
Subject: [users] software such as word, excel, powerpoint


Am I able to download word, excel, powerpoint from openoffice.org
If so, how would I do this?
Thank you for your time.
Christine

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Just PDF writer?

[rlshadow]

OpenOffice does a nice job of easily creating PDF files from OpenOffice 
documents. However, it is not specifically a PDF writer. Meaning it's not the 
best application to use if you have a document in another application, such as 
Word for example, and you want to create a PDF file from it.
 
I would recommend that you consider switching to OpenOffice for all your needs, 
then creating PDF files will be easy.
 
But if you just want to create PDF files from existing (non-OpenOffice) 
documents, probably the most sensible approach would be to obtain a program 
that is specifically designed to create PDF files from any application.
 
I've used the free program PDFCreator, to do this, and it works well. I know 
there are others as well.
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Tue, 26 Dec 2006 10:36 AM
Subject: [users] Just PDF writer?


I've been looking for a PFD writer I can afford. I was directed to Open Office. 
Can I get just the PDF writer or do I have to install the entire Open Office 
suite? Please respond to [EMAIL PROTECTED] 
Thank you in advance. 
Dusty Foster.

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Re: Label Format Xref

[rlshadow]

Jessica: I suggest that you go to the following web page: 
http://documentation.openoffice.org/manuals/oooauthors2/index.html
 
... and see Chapter 11 of the Writer Guide (Using Mail Merge). 
 
(Here is the direct link to the Mail Merge chapter: 
http://documentation.openoffice.org/manuals/oooauthors2/0211WG-UsingMailMerge.pdf
  )
 
 
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Fri, 22 Dec 2006 9:29 AM
Subject: [users] Re: Label Format Xref


Hmmm. . . i've conqoured this problem ( i have no idea how). But It's
only producing one page of labels? I've read other people have had the
same problem, but i don't understand how i can get passed this problem.
I'm desperately trying to finish this as i have 24,000 labels to produce
and like everyone else i want to go home! 

On Fri, 2006-12-22 at 08:39 -0500, G. Roderick Singleton wrote:

> On Fri, 2006-12-22 at 12:29 +, Jessica Edwards wrote:
> > I'm in the process of trying to produce mailing labels from an
> > openoffice spreadsheet. Although it's only producing every other
> > address that i've selected in data source view.
> > 
> > Please can you help me - or direct me to someone who can?
> > 
> 
> Jessica,
> 
> Thank you for thinking of me but I have no idea what might be causing
> your problem. Your best source for this type of help is
> [EMAIL PROTECTED]  I have cc'd this list for you and recommend you
> subscribe and/or use the gmame newsgroup that is listed at
> http://www.openoffice.org/mail_list.html
> 
> Now the subject of your message refers to the cross-reference and I can
> say that the label cross-reference is just that a cross-reference so you
> can relate the built-in formats to other manufacturers products. If you
> need user documentation, please start with
> http://documentation.openoffice.org/manuals/OOo2.x/user_guide2_draft.pdf
> 
> Your description of the problem needs a bit more detail to offer any
> type of proper analysis. However, on a wild guess I would suggest that
> the data you are attempting to put into the label is overflowing into
> the next frame. You can check this by select View > Nonprinting
> Characters. 
> 
> The following offers some other references and resources:
> 
> For user level help, subscribe to users@openoffice.org 
> or use the newsgroup. You can find these listed at
> http://www.openoffice.org/mail_list.html . If you send a message please
> reply to the list and not directly to the person helping you. There are
> literally thousands of people participating in the mailing list. Others
> on the list can also help. 
> 
> Also, by replying to the mailing list, everyone benefits from the 
> questions asked and the solutions provided.
> 
> You can of course join our helpful community mailing lists - there is no
> cost and you are only required to restrict your emails to OpenOffice.org
> topics:
>   *  users@openoffice.org : for OpenOffice.org questions, or when
> you feel comfortable, replies to questions;
>   *  discuss@openoffice.org : for OpenOffice.org general
> discussions; 
>   *  dev@openoffice.org : for questions developing compiling
> OpenOffice.org; and
>   *  dev@api.openoffice.org : for programming using the
> OpenOffice.org APIs.
> 
> 
> There are several ways to participate in the mailing lists:
> - subscribe to the users mailing list by emailing
> [EMAIL PROTECTED]
>   NOTE: that the users@openoffice.org list has between 30 and 100 mails
> per day - most of which are interesting responses to answers. If you
> find that after awhile you are not comfortable with this volume of email
> then you can always be removed from the mailing list by sending an email
> to [EMAIL PROTECTED] AND DO NOT FORGET TO ALSO
> REPLY TO THE CONFIRMATION EMAIL! You might also try the digest version
> which bundles messages into groups by sending an email to
> [EMAIL PROTECTED]
> 
> - subscribe to the relevant newsserver gateway for the mailing list on
>   news://news.gmane.org/gmane.comp.openoffice.questions (i.e. 
>   users@openoffice.org)
> news://news.gmane.org/gmane.comp.openoffice.general 
>   (i.e. discuss@openoffice.org)
> 
> There is no compulsion to join the mailing list or the news server
> gateway.
> 
> If you only want to read replies without interacting with the mailing
> list then all you need to do is to use the websites :
>  - http://news.gmane.org/gmane.comp.openoffice.questions or
>  - http://www.openoffice.org/servlets/SummarizeList?listName=users
> 
> Simply look down in the list until you find your question. Often the
> answers are shown following the question. Sometimes however the answers
> get separated from the question, and show up separate in the list.
> Simply start at your question and then move forward in the time
> sequence.
> 
> The benefit of using this approach is, quite often the questions and
> answers are grouped together - either by question (on gmane.org) or in
> the order they were received (on t

Re: [users] Even More Odd Pagination Behavior

[rlshadow]

I can't help, other than to confirm that I've seen behavior like this myself. 
In my case, it involves a newsletter that I am editor of, and it has either 12 
or 16 pages depending on the issue. I've carefully gotten things to fit 
properly, then saved it and closed it, and when I re-opened it, there is 
sometimes (not all the time) one or two additional pages because page breaks 
are now occuring in different places. 
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Mon, 18 Dec 2006 9:05 AM
Subject: [users] Even More Odd Pagination Behavior


FC5 OS on a 64-bit system with OOo 2.02. I scrolled the document (and
have not added any new material nor made any changes) and now in page
preview the total no. of pages has jumped from 240 to 243. I see that at
least two blank pages have appeared (pp. 27 and 28) where there were
none before. I haven't upgraded this machine to a newer OOo because on
another almost identical 64-bit system, the bibliographic database does
not work in the newer OOo.

Rick

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] [moderated] Publisher/pdf conversion

[rlshadow]

Maybe I wasn't clear, but I wasn't suggesting that OpenOffice would convert the 
file. I was asking if Publisher itself can export as a pdf. But based on 
another response, Publisher is not able to. A pdf converter (some available for 
free, like PDF Creator) would be needed.
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org; [EMAIL PROTECTED]
Sent: Wed, 29 Nov 2006 11:18 AM
Subject: Re: [users] [moderated] Publisher/pdf conversion


How would you consider this possible? If it can't read them, how would 
OpenOffice then be able to convert it?? 
 
Arnold Huzen 
 
[EMAIL PROTECTED] schreef: 
> OpenOffice cannot read Publisher files. Does Publisher have an option to 
> export as a pdf? (I don't use Publisher so I'm not sure.) > > > -Original 
> Message- 
> From: [EMAIL PROTECTED] 
> To: users@openoffice.org 
> Sent: Wed, 29 Nov 2006 7:19 AM 
> Subject: [users] [moderated] Publisher/pdf conversion 
> 
> 
> I want to convert a publisher 2002 file to a pdf file - can Open Officer help 
> > with this please? 
> 
> Rusty 
>  
> Check out the new AOL. Most comprehensive set of free safety and security 
> tools, free access to millions of high-quality videos from across the web, 
> free AOL Mail and more. 
> 
>  
- 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 
 

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] [moderated] Publisher/pdf conversion

[rlshadow]

OpenOffice cannot read Publisher files. Does Publisher have an option to export 
as a pdf? (I don't use Publisher so I'm not sure.) 
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Wed, 29 Nov 2006 7:19 AM
Subject: [users] [moderated] Publisher/pdf conversion


I want to convert a publisher 2002 file to a pdf file - can Open Officer help 
with this please?

Rusty

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] ubuntu? linux?

[rlshadow]

What does this discussion have to do with OpenOffice? 
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Wed, 29 Nov 2006 7:03 AM
Subject: Re: [users] ubuntu? linux?


I just started researching linux. 
At first I tried damnsmalllinux livecd. 
and other small download linux livecd, puppy, slax, etc. 
Only damnsmalllinux, detected my cisco aironet 350 wireless pcmcia card. 
I've installed damnsmalllinux into my harddisk. 
But I can't get the usb thumbdrive to work. 
 
I've ordered free ubuntu cd from shipit. 
It has arrived. 
thank you shipit. 
However i tried to run the livecd. 
the linux failed to start. 
it is stop halfway detecting my hardware. 
 
My laptop is Compaq Presario 2819ap. 
It's about 4 years old. 
Pentium 4m 2ghz. 
768mb ram. 
30mb harddisk. 
Cdrom drive is hotswappable with diskette drive. 
How do I get my laptop to boot into ubuntu? 
 
I tried the livecd on my friend's pc. 
It booted up. 
But ubuntu did not recognise my thumbdrive as well. 
How do I get linux to recognise usb thumbdrive? 
 
So I read more into linux. unix, bsd, etc. 
gnome, kde, xfce. 
debian, slackware, redhat, suse, linspire, freespire, xandros, etc. 
but got confused. 
 
Why the need to have so many diff distribution? 
Are the software for one distro installable, usable on others? 
Why the need to have diff window manager? 
Are the software for gnome/linux, usable on gnome/bsd? 
 
I've recently discovered www.portableapps.com 
It's great, bought myself a external harddisk with casing. 
Now I'm back to using Windows. 
Attempts at linux unsuccessful. 
 
I'm a windows xp user. 
Office network file server is Windows Server 2003. 
10 workstation with a mix of win xp and win2k. 
Using dhcp. 
Using a small dedicated box as print server. 
Using a 4 port adsl router for internet access. 
I would like to recommend switching to linux. 
How do I trial run a linux server alongside the windows server? 
How do I setup the workstation to access both linux box and windows box? 
 
 
 
Keith Bates wrote: 
> On Wed, 29 Nov 2006 11:05:32 +0100 
> Marc Hug <[EMAIL PROTECTED]> wrote: 
> >> Hi. Someone answered a question regarding MS Vista by recommending >> 
> >> Ubuntu Linux. 
>> I really do not know much about Operating systems. If I would 
>> consider replacing MS Windows by a Linux system, my main question 
>> would be: will I be able to communicate with other people and read 
>> their files, let them read mine etc. ? If this rises problems that 
>> require specialized knowledge, I quit. 
>> Marc H. 
>> 
>> 
>> 
>> 
>> 
>> - 
>> To unsubscribe, e-mail: [EMAIL PROTECTED] 
>> For additional commands, e-mail: [EMAIL PROTECTED] 
>> 
> Hi, 
> > The short answer is: yes you can do all these things under linux. You 
> can even use quite a few programs such as open office, firefox, opera 
> etc which are all available in several operating systems. 
> > If you are into games, however, you are best to stick to windows (or 
> keep both windows and linux on separate machines, or even the same 
> machine) 
> > Of all the different "flavours" of linux, ubuntu is probably the 
> easiest to start off with. 
> > As this is an open office list, I had best just refer you to some other 
> links to do your own research: 
> > www.ubuntu.com 
> www.linux.org/lessons 
> www.linuxquestions.org 
> > Hope this helps to get you started on a great adventure! 
> >  
- 
To unsubscribe, e-mail: [EMAIL PROTECTED] 
For additional commands, e-mail: [EMAIL PROTECTED] 
 

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Calc -Conditional formatting

[rlshadow]

 Without knowing specifically what happened when you tried to do this, it's 
tough to know what is going wrong. I just worked through the example in Help 
and it "worked for me". I know this isn't very helpful. One thing that could be 
confusing things a little is the when using the random number formula, as 
suggested in the Help, whenever an entry is made in any cell, all of the random 
numbers are recalculated. Thus, the target is definitely a moving one. However, 
this does not seem to prevent this example from working.
 
 Please get back to the list with some more details of specifically what you 
did, and what the result was, and maybe myself or someone else can help 
determine what is going wrong.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 14 Nov 2006 1:44 PM
 Subject: [users] Calc -Conditional formatting
 
  I have been struggling to make use of the Conditional Formatting facility, 
but 
as yet haven't achieved an accurate result.
I have worked, step by step, through the example, in OOo Help (which is a very 
simple one) many times,  but the result that occurs is pure nonsense.
I am perfectly prepared to believe I am doing something wrong, as I dont think 
OO development would have reached as far as it has without a problem with this 
being spotted before, but at this stage I am completely baffled!
John Barman
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] [moderated] YOU MUST GIVE A SUMMARY HERE

[rlshadow]

  Yes, it is possible to purchase a CD with OpenOffice on it for a reasonable 
price. The OpenOffice.org web site has a link to suppliers. Also, if you do a 
search on E-bay, you should find quite a few people selling it, usually for $5 
or so including shipping.
 
 You might not want to rule out downloading it though, unless you're paying 
connection fees by the hour. The first two versions that I downloaded, I was on 
dial up. I would start the download before I went to bed, and it was done when 
I got up the next morning.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Thu, 9 Nov 2006 10:09 AM
 Subject: [users] [moderated] YOU MUST GIVE A SUMMARY HERE
 
  Hi, is it possible to receive a CD with the open office program? I'm on  dial 
up and it takes 12 hours to download it. :(
Thank you & God Bless- June Ingram
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Accept Button Disabled on License Agreement Page

[rlshadow]

 Scroll down. Then the Accept button can be clicked.
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Wed, 8 Nov 2006 11:15 AM
Subject: [users] Accept Button Disabled on License Agreement Page


Hello Users,
 
I have downloaded and successfully installed openoffice.org on our
Packardbell EasyNote R1900. My Operating System is Windows XP Home
(SP2). It is appearing on my start menu, however, when I try to use the
components for the first time, I am asked to accept the license
agreement again, this is fine and expected based on the instructions.
However, when I get to the second window, where I need to accept the
license agreement the Accept Button is disabled. I can not accept the
License Agreement and therefore cannot use any of the software.
 
Does anyone know why this button might be disabled. This is a major
problem as it is preventing me from using any of the components.
 
Any help would be greatly appreciated.
 

Avela Dlova


 


This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Can not open microsoft word

[rlshadow]

Maybe you should ask this question on a Microsoft web site?? 
 
 
-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Wed, 8 Nov 2006 10:55 AM
Subject: [users] Can not open microsoft word


when i try to open ms word it doesn't work it just make it look like all  
kinds of funny letters

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] how to turn off autonumbering?

[rlshadow]

 A nice thing about autonumbering, and many other OOo features that some people 
like but some find annoying, is that they're easy to turn off if you don't like 
them.
 
 In the case of autonumbering, go to Tools > Autocorrect. Click the Options tab 
(the middle tab). About 2/3 of the way down the list, there's a selection 
called "Apply numbering - symbol:*" Click the box to uncheck it, and your 
problem should be solved.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 31 Oct 2006 1:11 PM
 Subject: [users] how to turn off autonumbering?
 
  hi folks,

i really, really hate the numbering behavior. every time i start a line with
a number i start getting indents and the number becomes uneditable. i tried
setting indent=0 and some other tweaks in the numbering dialog but it made
no difference. what can i do to eliminate this behavior entirely and manage
my own lists?

thanks,
aaron.


 \\   aaron brick
 \\   [EMAIL PROTECTED]
 \\   http://www.lithic.org

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] CD?

[rlshadow]

  If you go into the OpenOffice.org web site, and click on "Get 
OpenOffice.org", you'll find a link to people selling CD's with OpenOffice.org. 
Or you can search on e-bay, there are usually people selling them there too. A 
reasonable price seems to be in the US$5-10 range.
 
 When I first obtained OpenOffice, I was on dial-up. I started the download 
before I went to bed, and got up the next morning and the download had 
successfully completed. So I wouldn't rule out downloading it. (Just don't do 
it when you're in a hurry!) 
 
 I'm cc'ing you because you may not be subscribed. Please direct any responses 
to the list (users@openoffice.org), not to me personally. By sending it to the 
list, I'll see it and so will many other people, many of whom can help you a 
lot better than I may be able to.
  
 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 31 Oct 2006 11:26 AM
 Subject: [users] CD?
 
  I have just heard about your program and am very interested in trying it.  I
am a Microsoft Office user.  Is it possible to get a copy of this program on
a CD. I live in the country and am on  dial up connection and it will take
forever for the program to download.  I will be very happy to pay for the
cost of mailing the CD.

Thank you in advance.

Ida Lowery

[EMAIL PROTECTED] 
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] PDF Form

[rlshadow]

 This zeroes in on where the assistance is needed. The problem isn't in getting 
a pdf document to recognize form fields from Writer (it will do that 
automatically), the problem is in creating the form in Writer in the first 
place.
 
 I suggest that you read OpenOffice.org Writer Guide, Chapter 15, Using Forms 
in Writer.
 
 Here is the link to this chapter: 
http://documentation.openoffice.org/manuals/oooauthors2/0215WG-UsingFormsInWriter.pdf
 
 I just took a simple form done in Writer, and exported it to PDF. I confirmed 
that using Adobe Reader 7.0, you can then open the pdf file and fill in the 
form fields, then print it out. (But not save it.)

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 31 Oct 2006 11:48 AM
 Subject: Re: [users] PDF Form
 
  On Mon, 30 Oct 2006 19:31:49 +1100
Terry <[EMAIL PROTECTED]> dijo:

> John Jason Jordan wrote:
> > I want to create a PDF where the user can open it in Adobe Reader,
> > enter data in fields I have created in the form, print it out, and send
> > it in. I could swear I have done this in Writer before, but I'll be
> > damned if I can remember how I did it. Can someone tell me which
> > buttons to push?

> File >Export as pdf.  They will have to print it, though, before filling 
> it in if they only have the reader.

No, Adobe Reader 7.0 has the ability to enter data in PDF forms. The
PDF file has to have been created as a form. That's what I'm trying to
remember how to do in OpenOffice.org. Once I create the form, then I
can export as PDF and the resulting PDF file can be filled in with just
Reader. But how do I create a form in Writer?

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Is it legal to sell Open Office?

[rlshadow]

 That's not how I understand it. I don't think there is anything that says that 
open source software shouldn't be sold at a profit. 
 
 I'm willing to stand corrected if otherwise, though.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 31 Oct 2006 9:57 AM
 Subject: Re: [users] Is it legal to sell Open Office?
 
 
 
 ...
 Usually, free software doesn't mean that acquiring it is free of cost anyways, 
 it rather means that copies shouldn't be sold at a profit. 
 ...
 
 
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] OpenOffice ROCKS: was: Re: Openoffice suck

[rlshadow]

 +1
 
 I like OOo a lot; I have used it at home for around 5 years. I have a part 
time job as an OOo trainer for a non-profit health care related company. I just 
recently started working another part time job at a for-profit company that I 
used to work full time for, which uses MS Office, so I need to re-learn how to 
use Word and Excel again. 
 
 I have to say, there are a number of things that work easier with MS Office 
than with OOo, especially with Excel vs Calc. There are also some things I 
prefer with OOo over MS Office. 
 
 Depending on one's needs, I can fully understand how some people might think 
that OOo is far superior, and that others might find out that they just can't 
get by with OOo, that they really need MS Office. To claim or imply that OOo is 
clearly superior in general is neither true nor helpful.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Thu, 26 Oct 2006 10:29 AM
 Subject: RE: [users] OpenOffice ROCKS: was: Re: Openoffice suck
 
  People using OO decided for themselves that OO is better in _one_ way or
another (license, price, portability, openness of development (which is
what attracts me), etc).

My point is - OO has it's own issues and we need to work on them, need
to push developers to improve OO and we should not lie to ourselves that
OO is better in every aspect. 

Claiming that OO is faster or that it does not crash or does not cause
data loss is big lie.

(Whether MSO is issue-free or not is unimportant even for those who use
it (let alone users of OpenOffice). What _is_ important to them is if it
has issues _affecting_ them personally, and if it has, then what are the
solutions).

Regards,
K. Palagin.

> -Original Message-
> From: Gregory Forster [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, October 26, 2006 5:32 PM
> To: users@openoffice.org
> Subject: RE: [users] OpenOffice ROCKS: was: Re: Openoffice suck
> 
> One point, and a very BIG point at that: I, as well as many, 
> many, many, many, many others can not possibly afford M$O, 
> let alone M$O Professional.  From reading this post, am I to 
> understand that M$O is entirely without issues? Un-Hunh! If 
> M$O was entirely without issues, then maybe a valid point 
> could be made and many more people would attempt to be able 
> to afford M$O.
> 
> Greg
> 
> "Kirill S. Palagin" <[EMAIL PROTECTED]> wrote: > 
> -Original Message-
> > From: news [mailto:[EMAIL PROTECTED] On Behalf Of RBL
> > Sent: Thursday, October 26, 2006 6:26 AM
> > To: users@openoffice.org
> > Subject: [users] OpenOffice ROCKS: was: Re: Openoffice suck I also 
> > find many things are simply easier to do in OpenOffice. Calc is 
> > tighter and faster.
> 
> Are you nuts? Excel is faster in every respect - starting, 
> opening documents, recalculating, saving. I have cases where 
> save/load in time Calc (with native formats) is 50 TIMES 
> longer then with Excel. And Calc uses several times more 
> memory with those files opened. 
> Operations that just work in Excel require many additional 
> steps in Calc (see issues 69690, 66052, 67528, 67851, 68515, 
> 68715, 70778, 67912, 35579, 27745, 33851)
> 
> > Configuring apps is
> > easier. Apps load and run faster. There's little non-functional eye 
> > candy. And overall, I find there's minimal bloat.
> 
> Bloat or not, OO is slower.
> 
> > 
> > MSFT Office does have some advantages, but they're outweighed by 
> > OpenOffice's advantages. And I have never lost data using 
> OpenOffice.
> 
> Yah, right. See issues 33851, 70320 and 69524.
> 
> > Then again, I have auto-backups turned on, and I hit Ctrl+S 
> every few 
> > seconds.
> > 
> > Lastly, show me where I can report MSFT Office bugs,
> 
> There are not that many left. Certainly less than in OO. And 
> fixing clear defects does not seem to be high on OO team agenda.
> 
> > or get
> > free online support 24x7?
> 
> In user forums. MS even hosts newsgroups for that purpose (in 
> addition to thousands of mailing lists, webboards etc).
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED] For 
> additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] general frustration

[rlshadow]

 Stephen,
 
 I share you frustration about learning Base. Like you, I don't have any 
experience with databases, so coming in with zero background doesn't help me, 
I'm sure. 
 
 Also, I feel that Base is the least well documented function of OpenOffice (as 
opposed to Writer, Calc, and Impress). So if it's any consolation, I think 
you'll have an easier time of learning the other parts of OpenOffice. 
Definitely take advantage of the documentation that is available through 
OOoAuthors and the Documentation group. 

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 24 Oct 2006 11:38 AM
 Subject: [users] general frustration
 
  I know this is supposed to be directed to your support forums but that
is not the point. I am trying to say that the lack of any basic tutorial
makes the dataBase software impossible to negotiate.

I am trying to understand how to use Open Office dataBase, but I am
finding the existing level of help opaque to the point of impossible. I
am a newcomer, I do not have any experience with databases. and so I do
not know what tables, queries, etc, really mean. for example tables in
Writer are simply a table as in html but in Base they are clearly
something quite different but there is no obvious description of what
they are. Also having persevered for a little while I find that when I
make up the headings for the table I cannot then come back and insert a
new row where I want it to go, it will only go at the end which is
pretty useless.

I've tried working with the bibliography database but I cannot find out
how to make any of the changes stick when I type in the details of a new
entry.

To put it plainly. I need a basic introduction to your database system,
with terms explained etc, and where you don't assume that the user is
already a master of the topic. The problem is you all know how to use
the stuff, but the average person out here in user space doesn't have
the background and needs to be given some sort of entry point to any of
the topics. I'm sure the problem will be the same when I tackle Impress
or Calc.

Stephen Jones


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Problem with Mail Merge in OO Document

[rlshadow]

 Last I heard, there was no readily known way to get that dialog to come back, 
once you tell it to go away. If there is a way, it may be very obscure, because 
I recall this discussion previously on the list, and no answer was forthcoming.
 
 You could possibly try uninstalling OOo and then reinstalling. Hopefully it 
won't remember that you said you didn't want that dialog to be displayed again.
 
 Sorry the news isn't better. 

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 24 Oct 2006 12:46 PM
 Subject: [users] Problem with Mail Merge in OO Document
 
  ...

When I got
the dialogue that asked if I wanted to go ahead and merge, I clicked on
the option that said do not display this again, thinking I would then go
straight to the Print dialogue.  Indeed, I do get straight through to a
Print dialogue, but it will no longer let me enter a range of records to
merge.  Instead, it asks me if I want to  print All or a page range,
just as it would with an non-merge document.  I can't seem to get back
to the Merge Print dialogue, even though I still have merge fields in my
document and am connected to a data source.

Can somebody help me, please?

Rosie

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Removing 2.0.4 and MS Office 2003

[rlshadow]

 (Sorry for the top post, the client I'm on right now doesn't do bottom posts 
well.) 
 
 It sounds to me like losing e-mails happens on many e-mail systems. I've had 
this happen to me twice with Thunderbird, which is often touted as a top notch 
e-mail system. 
 
 For what it's worth, in my previous job, we used Outlook, and I NEVER lost an 
e-mail in at least 8 years. So I wouldn't necessarily conclude that Outlook is 
"bad" for this issue and other systems are "good". 
 
 However, I've never tried Seamonkey, so if that IS in fact better than most, I 
may try switching from Thunderbird to Seamonkey on my home computer. (Before I 
once again lose a lot of e-mails that I really needed to keep.)
  
 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 17 Oct 2006 11:35 AM
 Subject: Re: [users] Removing 2.0.4 and MS Office 2003
 
  Marios Patrinos wrote: 
 > Hi Harold, 
 > > Thanks for the message - That seems to have solved my issues! 
 > > Through work, I can purchase low cost versions of office, also, it makes 
 > > it 
 > easier for me to collaborate and work as I'm very used to Office suite as 
 > have been using it since the '95 version. 
 > > I find, due to my experience with Office, I'm much more productive with it 
 > than having to learn how to do things differently in OOo. E.g. keyboard 
 > shortcuts are different, different icons, tables don't work as well etc. 
 > > Compatibility is not as good as some people think or as good as OOo says. 
 > Tables and other formats change even if you use the "save as .doc" function 
 > etc. 
 > > Though it is free and open source, which is great, I find for me 
 > > personally 
 > that it's easier to stick to Office - also, Outlook 2003 is far superior to 
 > any open source mail client (I've tried lots!). 
 
 Really? Have they fixed the problem with corrupt PST files, which cause you to 
loose all your messages? My work computer came with Outlook, but I switched to 
Seamonkey, because it is so much better. 
 
 - 
 To unsubscribe, e-mail: [EMAIL PROTECTED] 
 For additional commands, e-mail: [EMAIL PROTECTED] 
 
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] www.oooff.de sells your free product for money!

[RLShadow]

 
Not sure if this is a troll or not, but in case it's serious, it IS  
perfectly legal to sell OpenOffice.org, for whatever price the market will  
bear.
 
In a message dated 10/7/2006 12:15:58 P.M. Eastern Standard Time,  
[EMAIL PROTECTED] writes:

morning,
probably u already know, or at least its legal, but some  sucking company 
sells ooo for monay online. link is www.oooff.de
in my  opinion u should stop that and kick those asses.
greetz,  seb*

[users] Calc function question

[rlshadow]

 I am trying to do something that doesn't seem all that difficult, but I can't 
figure it out.
 
 I have two columns, let's say column A and column B. Cells in Column A contain 
a single letter, "A", "B", or "C". Cells in column B also contain a single 
letter, "Y" or "N". There are several hundred rows of data.
 
 I know I can use COUNTIF to count all of the "Y's" in column B. What I would 
like to do is count all of the instances where Column A is an "A" and Column B 
is "Y". (Then do the same for the other combinations of letters, but I do the 
extrapolation once I figure out how to do it with "A" and "Y".)
 
 I can think of some in-elegant ways of doing it, like sorting by column A, 
putting all of the rows with "A" into a separate sheet, etc., but I'd like to 
avoid that level of data manipulation if I could.
 
 Any suggestions would be apprectiated; thanks.
  

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Needing help - formulae

[rlshadow]

 Johans:
 
 I think this should be easy, if I understand it correctly.
 
 Let's say that cell C2 contains the number of hours Jenny worked. (5, 6, 7, 
etc.)
 
 In cell C3, put the following formula: =IF(C2<6;C2;C2-0.5)
 
 If the number of hours is less than 6, then C3 will be the number of hours. If 
the number of hours is 6 or greater, then c3 will be the number of hours minus 
0.5.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 3 Oct 2006 6:20 AM
 Subject: [users] Needing help - formulae
 
  
Hey there

Just one more question with formulaes...

I'm not very good with words so I'm going to state what I'm trying to do.

I'm trying to calulate employee's hours which with help from earlier have 
solved 
the problem. The thing is I need to deduct their breaks from the hours 
worked.

I have tried using an IF funcation but to no avial. Could you tell me which 
function to use for this following example and if possible could you fully type 
out the equation?

Any shifts that IS UNDER 6 hours will remain the same.

Any shifts that IS OVER 6 hours and ABOVE will need to be deducted 30mins from 
their total hours.

so Jenny who worked for 6 hours will have her break deducted hence her actual 
working hours was 5:30 hours

Kind regards

Johans
_
Try Live.com - your fast, personalized homepage with all the things you care 
about in one place.
http://www.live.com/getstarted
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

[users] Unexpected behavior with "hidden rows"

[rlshadow]

 I'm working on a spreadsheet that will have some columns of data, and some 
charts to illustrate the data graphically. There are certain rows that I want 
to use (as essentially column headers) for the charts, which I don't want to 
show in the spreadsheet when printed. There's nothing secret about them, 
they're just not needed and would clutter up the printed spreadsheet to have 
them shown.
 
 I know I can keep the contents of the rows from printing, and in fact I did 
that, but the way things were laying out on the sheet, it would be desirable to 
hide the entire row (not have a blank row printed).
 
 So I went to to Format > Row > Hide, and the row was properly hidden. What I 
DIDN'T expect, and what was very undesirable, is that the hidden row was no 
longer used by the chart. I checked the data range, and it said that this row 
was still included in the data range. But once it was hidden, the chart acted 
like there were no contents to this row.
 
 A less desirable work-around was to make the rows very short (a height of 
0.05" (about 1 mm) for example). Then they don't take up much space in the 
printout, and the chart still recognizes that they are there.
 
 It does not seem to me that hiding rows should make them invisible to a chart. 
It certainly doesn't make them invisible to formulas and functions, which is 
good.
 
 Does anyone know if this is intentional behavior (and if so, why?), or if it 
is a bug, or something else?
  

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users]

[rlshadow]

 The problem is, though, that the preview does not necessarily show you what 
will be printed. If you have multiple sheets, it will show in the preview all 
of the sheets, even if you want only one sheet printed.
 
   -Original Message-
  From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Thu, 28 Sep 2006 9:21 AM
 Subject: Re: [users]
 
 When I want to print from a spreadsheet, I go to a lot of trouble to make 
certain of what the outcome will be and rearrange material or print ranges to 
suit. 
 
 I select the range I anticipate printing and get a preview. If the preview 
isn't what I want, I change the layout or the selection. I don't go for the hit 
or miss strategy. 
 
 
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Calc, making "print only current sheet" installation default and applying it to "Page preview" too?

[rlshadow]

 I totally agree with kpalagin's description of the problems. And I know it's 
popular to bash Microsoft on this list, but Excel does not have these issues 
and in general handles printing much better than Calc. (For these reasons and a 
couple of others.) To me these seem like they should be easy to improve 
(although not being a developer, I really don't know for sure).
 
 1. Have the default be to print only the selected sheet(s).
 
 2. Have the page preview only show what will be printed when sent to the 
printer.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Thu, 28 Sep 2006 9:08 AM
 Subject: RE: [users] Calc, making "print only current sheet" installation 
default and applying it to "Page preview" too?
 
  Two problems:

1. After installation Calc defaults to printing of entire workbook. That
is easy to solve, but not having it to solve would be better.

2. "Page preview" and "Export to PDF" show all sheets in a workbook
regardless of  "Print only selected sheets" in Tools\Options\Calc. There
is no way for the user to solve this one. Behavior like this explicitely
tells users that "What you see is NOT what you get", which decreases
user confidence in tool and that is bad thing.

> -Original Message-
> From: SandyU [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, September 28, 2006 3:33 PM
> To: users@openoffice.org
> Subject: Re: [users]
> 
> Greetings.
> 
> On my system (2.0.2), the print preview shows a preview of 
> each page with the page number at the foot of the preview.  
> When I open the preview, it opens at the page I have in front of me.
> 
> The print dialogue gives me the option to select the pages to 
> be printed.
> 
> I regret that I am having difficulty identifying the problem.
> 
> Regards.
> 
> Richard Detwiler wrote:
> > I also agree, and in particular, I think that Page Preview 
> should show 
> > exactly what will be printed once you hit Print. I find it very 
> > disconcerting , on a spreadsheet with many sheets, to go to Page 
> > Preview and see a preview of, say, 50 pages, even though I 
> have it set 
> > up to only print the active page by default. It always gives me an 
> > instant of extreme concern when I actually print, whether it will 
> > respect my wished to print a single page, or whether it will really 
> > print what's in the page preview. Especially since there have been 
> > instances where the whole file gets printed, for some 
> reason I don't 
> > understand.
> >
> > To reiterate, it would be VERY helpful if Page Preview 
> really showed 
> > what was going to be printed.
> >
> > Richard Detwiler
> >
> > - Original Message - From: "arnold huzen" 
> > <[EMAIL PROTECTED]>
> > To: 
> > Sent: Thursday, September 28, 2006 5:59 AM
> > Subject: Re: [users]
> >
> >
> >> I agree with you. Especially on larger spreadsheet it's 
> impossible to 
> >> have to count the pages in your workbook to determine 
> which page(s) 
> >> you want to print.
> >>
> >> I definately think that the current sheet should be the default 
> >> printrange.
> >>
> >> Arnold Huzen
> >>
> >>
> >>>
> >>> van: "Kirill S. Palagin" <[EMAIL PROTECTED]>
> >>> datum: 2006/09/28 Thu AM 10:53:11 CEST
> >>> aan: 
> >>> onderwerp: [users]
> >>> Calc, making "print only current sheet" installation default and 
> >>> applying it to "Page preview" too?
> >>>
> >>> (Since developers are not interested in discussing this issue I 
> >>> would like to discuss it with fellow users) Dear colleagues,
> >>>
> >>> What do you think of default Calc's behavior to print complete 
> >>> workbook instead of just current sheet? Printing all sheets seems 
> >>> counterintuitive and wasteful in the age of "Reduce, 
> Reuse, Recycle".
> >>> There is very old issue
> >>> http://www.openoffice.org/issues/show_bug.cgi?id=10530 for that.
> >>>
> >>> If not this, at least making result of "Print" more 
> consistent with 
> >>> "Export to PDF" and "Page Preview" (last two do not 
> respect "Print 
> >>> only selected sheets" and output all sheets regardless) 
> would make 
> >>> behavior more logical and predictable to users. 
> Additional problem 
> >>> with current behavior is that page numbering in page 
> preview and on 
> >>> paper are likely to differ.
> >>>
> >>>
> >>> Please share your thoughts on the subject.
> >>>
> >>> Thanks a lot.
> >>> WBR,
> >>> K. Palagin. 
> >
> -- 
> 
> If you're seeking, check out http://www.rci.org.au
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED] For 
> additional commands, e-mail: [EMAIL PROTECTED]
> 
> 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality vide

Re: [users] Re: Two ways Microsoft sabotages Linux desktop adoption

[rlshadow]

 +1 

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org; [EMAIL PROTECTED]
 Sent: Tue, 26 Sep 2006 9:40 AM
 Subject: Re: [users] Re: Two ways Microsoft sabotages Linux desktop adoption
 
  This thread needs to STOP. 
 
 This is the users mailing list. It is for asking and answering user 
 questions about how to get/install/use OpenOffice.org - it is *NOT* a place 
 to promote Anti-Microsoft FUD, crackpot theories, or bashing MS at all. If 
 you want to do that, there are plenty of other places to do that - but the 
 users list of OpenOffice.org is not one of them. 
 [EMAIL PROTECTED] work - but not [EMAIL PROTECTED] Please kill this 
 thread. It's over. It never 
 belonged here to begin with. 
 
 Moderators, PLEASE KILL THIS THREAD. 
 
 8 days and 40 messages is ENOUGH. 
 
 -- - Chad Smith 
 http://www.chadwsmith.com/ 
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Calc -- Hide/Show

[rlshadow]

 No way to reshow it, once it's hidden, it's hidden forever -- just kidding. 
 
 What you need to do is highlight a column or columns to the left of the hidden 
column, then drag to the right so you have a column or columns to the right of 
the hidden column also selected. In other words, you've selected a block of 
columns, and within that block is your hidden column. Now right click, and 
select Show. Now your hidden column will re-appear. 

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 12 Sep 2006 8:07 AM
 Subject: [users] Calc -- Hide/Show
 
  Okay -- I guess I messed up.  I was in a spreadsheet and selected a column 
and 
hid it. Now I want to see it again. I pull up the menu for column and select 
show but my column remains hidden. I know there has to be a way to reshow the 
column but I don't see how. Someone got a clue? Thanks.
   

Check out the new AOL.  Most comprehensive set of free safety and security 
tools, free access to millions of high-quality videos from across the web, free 
AOL Mail and more.

Re: [users] Question about Open Office

[RLShadow]

 
In a message dated 9/4/2006 6:49:34 P.M. Eastern Standard Time,  
[EMAIL PROTECTED] writes:

I am  eager to try Open Office w/ my Mac, since most of my clients  are  PC.
I noticed on your website that you said a word-processing document CAN  be
saved as a "Word" doc.  Does the same hold true for the other  Microsoft
products?  Can the spreadsheet be saved as "Excel," or the  presentation
saved as "PowerPoint?"


 
Kat:
 
Yes, that is correct. A spreadsheet can be saved as Excel, and a  
presentation as Powerpoint formats.

[users] I'm getting very few OOo Users e-mails

[rlshadow]

 I'm not sure what has happened, but I seem to be getting less than 10% of the 
e-mails on this list. This started happening fairly abruptly, about 3 days ago. 
I still get an occassional note, maybe 3-4 a day, which suggests that I didn't 
get unsubscribed for some reason.
 
 I've checked my spam folder multiple times, and no e-mails from this group are 
winding up there.
 
 Does anyone have any ideas as to what could have caused this, and what I might 
do to fix it? If you respond, please send a copy directly to my address, 
because chances are that I won't receive it if you just reply to the list. 
Thanks.
  

Check out AOL.com today. Breaking news, video search, pictures, email and IM. 
All on demand. Always Free.

Re: [users] I am using version 2.0.3 of OpenOffice.org. My problem is :

[rlshadow]

 When you select File > Export as PDF, you will be given an opportunity to give 
the file a name, and to choose what folder to export it to. Once you've done 
that, and clicked Export, you'll be taken to a dialog box where you can make 
some choices, such as whether to export all pages vs selected pages, or what 
quality you want.
 
 It may seem that the dialog box should come first before where you name the 
file and click Export, but it doesn't. Perhaps you thought (understandably) 
that once you click Export, it will Export it then and there, without asking 
any further questions, and didn't go beyond that point. 

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Thu, 24 Aug 2006 7:47 AM
 Subject: [users] I am using version 2.0.3 of OpenOffice.org. My problem is : 
 
  I am unable to find the PDF export OPTIONS Dialog menu in the Writer.

When I   "Choose File - Export as PDF",   there is no choice or menu.
Help says:  "Click the icon to export the current document without an Options 
dialog. Choose the menu command for the PDF Options dialog":

I am unable to find the menu command for the PDF Options dialog.

Thank you for advising

C Mageroi
   

Check out AOL.com today. Breaking news, video search, pictures, email and IM. 
All on demand. Always Free.

Re: [users] Copy/Paste

[rlshadow]

 As I recall, there is no easy way to tell if you have 2.0.1 vs 2.0. However, 
if you have 2.0.2 or 2.0.3, it should say this when you go to Help > About 
OpenOffice.org 

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 15 Aug 2006 9:32 AM
 Subject: Re: [users] Copy/Paste
 
  So can someone tell me how to find out what version of OO I have? Is it 
2.0.1? 2.0.2? What? 
 - Original Message - From: "Mac McClain" <[EMAIL PROTECTED]> 
 To:  
 Sent: Monday, August 14, 2006 5:56 AM 
 Subject: Re: [users] Copy/Paste 
 
 > Thanks, you're right, tried that and got a little box that says version > 
 > 2.0 but I thought it needed something like 2.0.1 or 2.0.6 or something > 
 > like that. 
 > - Original Message - > From: "Jack Gates" <[EMAIL PROTECTED]> 
 > To:  
 > Sent: Sunday, August 13, 2006 7:59 PM 
 > Subject: Re: [users] Copy/Paste 
 > 
 > 
 >> On Sunday 13 August 2006 07:45, Mac McClain wrote: 
 >>> Version of OO is unknown, I'm sure there is a 
 >>> way to tell but I looked at help for 20 minutes without getting 
 >>> anywhere. 
 >> 
 >> Click on the help button and then about OOo and there is your version 
 >> in the box. 
 >> 
 >> -- >> Jack Gates http://www.morningstarcom.net/ 
 >> 
 >> - 
 >> To unsubscribe, e-mail: [EMAIL PROTECTED] 
 >> For additional commands, e-mail: [EMAIL PROTECTED] 
 >> 
 >> 
 > 
 > - 
 > To unsubscribe, e-mail: [EMAIL PROTECTED] 
 > For additional commands, e-mail: [EMAIL PROTECTED] 
 > 
 > 
 - 
 To unsubscribe, e-mail: [EMAIL PROTECTED] 
 For additional commands, e-mail: [EMAIL PROTECTED] 
 
   

Check out AOL.com today. Breaking news, video search, pictures, email and IM. 
All on demand. Always Free.

Re: [users] FW: Writer not saving settings and new info

[rlshadow]

 I'm not yet drawing a conclusion that 2.0.3 causes the list of recent 
documents to stop updating. I have a feeling if this were indeed the case, 
there would be a flood of reports of this problem, rather than the trickle that 
there has been. 
 
 All I can say for sure is that when I reverted to 2.0.2, this problem went 
away. But it may have been a bad download of 2.0.3 or bad install. I'm planning 
on re-downloading and re-installing 2.0.3 within the next week.
 
 But to answer your question -- if you still have the installation file for 
2.0.2, you're all set. You need to first uninstall 2.0.3. Exit out of your 
quick starter, if you have that running. Then use the normal way of 
uninstalling programs on a Windows computer.
 
 Then just do an install of 2.0.2, and you should be all set.
 
 If you don't have the installation file for 2.0.2, then you'll need to 
download it before doing any of the above. 
  
 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Thu, 10 Aug 2006 9:17 AM
 Subject: RE: [users] FW: Writer not saving settings and new info
 
  Hi Richard (Sorry)

I am using 2.0.3 with XP.  How does one revert to a previous version? Is
this problem likely to be fixed in the later version?

-Original Message-
From: Richard Detwiler [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 10, 2006 9:19 PM
To: users@openoffice.org
Subject: Re: [users] FW: Writer not saving settings and new info


Terence W C Warby wrote:
> I would also appreciate an explanation/solution to this. The question
> has been asked on a number of occasions over the past few weeks and no
> real answers have come back (none that I have seen anyway!).
> Thanks
> Terry Warby
>
> Ollie Olorenshaw wrote:
>> Thanks Roderick
>>
>> Is there an explanation as to why the RECENT DOCUMENTS is not
>> updating to
>> reflect recent documents used? The ones that show up are docs I haven't
>> looked at for a long time
>>
>>
>>
What version of OOo are you using? And what OS? When I installed 2.0.3
on my Windows XP computer, the recent documents stopped updating. I
reverted to 2.0.2 and all is well. I've been intending to try
re-downloading and re-installing 2.0.3 to see if it was a bad download,
but haven't taken that step yet.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Send instant messages to your online friends http://au.messenger.yahoo.com 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Send instant messages to your online friends http://au.messenger.yahoo.com 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

   

Check out AOL.com today. Breaking news, video search, pictures, email and IM. 
All on demand. Always Free.

Re: [users] Auto-expanding form field?

[rlshadow]

 
 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 8 Aug 2006 10:24 AM
 Subject: Re: [users] Auto-expanding form field?
 
  On Tuesday 08 August 2006 08:36 am, [EMAIL PROTECTED] wrote:
>  A co-worker has a form (in Writer) that I've helped her with.
>
>  She would like to have the verticial dimension of some of the form
> fields expand as needed to hold more lines of text. So if a certain
> field requires, say, 7 lines of text, the field will expand
> vertically to hold and display 7 lines.
>
>  I have not been able to determine a way to do this. Can anyone
> offer any suggestions? Thanks.

 Sorry, but I doubt that this is going to be easy to do. Obviously 
she does not want to use a scroll bar.
 Possibility: create a macro to do this. It should be assigned to 
the Text modified Event in the Event tab of the Properties window. 
(Use the Control icon in the Design toolbar to open the Properties 
window.) I have no idea as to what this macro should be nor if it is 
possible.
 One more note: This field is has enough space between it and the 
bottom of the page for the maximum number of lines she would be 
entering.
 
Dan




-

Dan: Thanks for the response. I've tried a scroll bar (that's how the form 

is set up now), but the problem there is that she wants to print the form, 

and if there is too much text to be displayed, it won't all be printed (even

though by scrolling, it can all be viewed).



I suspected that this might not be possible to do or at least not easy to

do, but thought I'd pose the question. (I'm not knowledgeable enough about 

macros to go that route, I'm afraid).



Dick

   

Check out AOL.com today. Breaking news, video search, pictures, email and IM. 
All on demand. Always Free.

[users] Auto-expanding form field?

[rlshadow]

 A co-worker has a form (in Writer) that I've helped her with. 
 
 She would like to have the verticial dimension of some of the form fields 
expand as needed to hold more lines of text. So if a certain field requires, 
say, 7 lines of text, the field will expand vertically to hold and display 7 
lines.
 
 I have not been able to determine a way to do this. Can anyone offer any 
suggestions? Thanks.
  

Check out AOL.com today. Breaking news, video search, pictures, email and IM. 
All on demand. Always Free.

Re: [users] Writer, pager numbering

[rlshadow]

 To have no numbers on the first two pages, with numbers starting on the third 
page, you need to use page styles. I'll assume you have some knowledge of page 
styles; if not, there is good documentation describing how to use page styles 
in the Users' Manual, and in OOoAuthors.
 
 Create a style that will be used for the first two pages. Apply this style to 
the first page and then to the second page. At the bottom of the second page, 
select Insert > Manual Break > Page Break, and for Styles, select Default (or 
some other style that is different from that you used for the first two pages). 
Then check the box that says Change Page Number, and for the number, select 1.
 
 Now create a footer, but only for the Default page style: Insert > Footer > 
Default
 
 Now all that is left is inserting the page number in the footer. Click in the 
footer field, and select Insert > Fields > Page Number.
 
 That should do it.

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Thu, 27 Jul 2006 9:44 AM
 Subject: [users] Writer, pager numbering
 
  How do I get my document to print page numbers, starting on the third page, 
but starting with the number one instead of three and incrementing from there? 
 
 Thanks 
 
 Mate 
 
 -- 
 "Careful. We don't want to learn from this." -- Calvin 
 
 - 
 To unsubscribe, e-mail: [EMAIL PROTECTED] 
 For additional commands, e-mail: [EMAIL PROTECTED] 
 
   

Check out AOL.com today. Breaking news, video search, pictures, email and IM. 
All on demand. Always Free.

[users] Document "hanging up" after many recorded changes

[rlshadow]

 I experienced some extremely slow response time this morning while working on 
a document that had many recorded changes. I was reviewing/revising a procedure 
at work. It is relatively short, around 4 pages, with no graphic elements. The 
file size is around 15K.
 
 Nearing the end of the document, it very suddenly started taking forever to 
respond. My definition of "forever" in this case: To insert a line break by 
pressing Enter took around 3 minutes. To save the document also took around 3 
minutes. I opened up, modified, and saved another document as a trial, and that 
was fine.
 
 I closed out of OOo, shut down, and restarted, and the problem persisted.
 
 Finally, I tried saving the document as a different name (which again took 
around 3 minutes), and in the new document, I went to Edit > Changes > Accept 
or Reject, and Accepted All of the changes. Now the document gave normal 
response time. So this was pretty clearly a result of the recorded changes.
 
 I estimate that I had approximately 80 recorded changes, which seems like a 
lot I agree. (There were a number of places where someone had put a list in a 
paragraph form (items separated by commas), and I changed those places to 
bulletized lists, which caused a pretty large number of separate changes to be 
recorded each time.)
 
 My question is whether this is to be expected (like is there a practical limit 
to the number of changes that can be recorded?). 
 
 I'm on OOo 2.0.2, Windows XP. It's a networked system rather than an 
individual PC so unfortunately I'm not sure of the memory. 
 
 Any thoughts would be appreciated. Thanks.
  

Check out AOL.com today. Breaking news, video search, pictures, email and IM. 
All on demand. Always Free.

Re: [users] "Recent Documents" list acting oddly

[rlshadow]

 Hi Andy,
 
 At first, I suspected something like that also (shutting down without closing 
OOo), even though I typically do not shut down without closing applications. 
But I thought that possibly I might have done so inadvertently. So once I 
became aware of this issue, I made a very deliberate point of first closing 
OOo, then shutting down. (And I did this for three days in a row, and had this 
problem consistently happen, before I submitted the question about it.) So this 
is not the explanation in this case, although I believe you're correct, if I 
had done that, I would see the behaviour that I'm noting.
 
 Dick

 -Original Message-
 From: [EMAIL PROTECTED]
 To: users@openoffice.org
 Sent: Tue, 18 Jul 2006 8:26 AM
 Subject: Re: [users] "Recent Documents" list acting oddly
 
  On Tuesday 18 July 2006 12:26, Richard Detwiler wrote:
> In the whole scheme of things, this is fairly trivial, but it's annoying
> (and puzzling), so I thought I'd ask to see if anyone had any ideas.
>
> There's one particular Calc file, which I've had reason to access
> frequently lately, which disappears from the list of Recent Documents
> (File > Recent Documents) after the computer is shut down and restarted.
> This happens consistently, it wasn't just once.
>
> When I open the file, modify it, and save it, it shows up at the top of
> the list of Recent Documents, as it should, but only until I shut down
> the computer and then restart the next day. Then it has vanished.
>
> Also, there's one file which I haven't accessed in a long time that
> shows up in the #2 spot on the list of Recent Documents, even though
> there are other files that I've accessed, modified, and saved much more
> recently, that appear further down on the list.
>
> Any ideas as to what can be going on?

This is a wild guess, and you may not be doing what I'm suggesting.

I'm guessing that you do not close OOo before shutting down the PC. In that 
case it is conceivable that your local status is not saved properly as the 
program is aborted rather than terminating normally. Have you tried quitting 
OOo and then restarting it to see whether the list is what you expect? If it 
fails after that test, then I don't know.

>
> I'm using OOo 2.0.3 with Windows XP, Service Pack 2.
>
> Thanks,
>
> Dick
>
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]

-- 
Andy Pepperdine

On this mailing list help is provided by volunteers.
Please subscribe to the mailing list to see all the replies to a query,
and reply only to the mailing list at [EMAIL PROTECTED]

For FAQ, userguide, see: http://documentation.openoffice.org/

For more information about the OOo licence here:
http://www.openoffice.org/license.html

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

   

Check out AOL.com today. Breaking news, video search, pictures, email and IM. 
All on demand. Always Free.

Re: [users] File->New Brings Up Existing Document

[rlshadow]

Glad the problem was found; that was the only thing I could think of 
when I first heard the problem description. But it sounded a bit 
far-fetched, because I know what is involved in saving a document as a 
template and then designating that template as the default. Not that 
it's highly complicated -- but it doesn't seem like something that 
someone would do by accident either. So it still seems unexpected that 
something like this would be done inadvertently. But I guess it did 
happen!


-Original Message-
From: Rich Shepard <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Tue, 27 Jun 2006 09:30:19 -0700 (PDT)
Subject: Re: [users] File->New Brings Up Existing Document

 On Tue, 27 Jun 2006, Rich Shepard wrote:

> A-ha! I'll bet that's it, Peter.

Yup. That's just what she did: saved it as a template rather than as a
document file.

Thanks,

Rich

-- Richard B. Shepard, Ph.D. | The Environmental Permitting
Applied Ecosystem Services, Inc.(TM) | Accelerator
 Voice: 503-667-4517 Fax: 503-667-8863

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




Check out AOL.com today. Breaking news, video search, pictures, email 
and IM. All on demand. Always Free.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Question on versions in Writer

[rlshadow]

Andy nailed it. The problem is that when you do a File > Save As, the 
versioning information is lost.


When I moved the file using Windows (right clicking on the file, 
selecting copy, going to the folder I wanted, right clicking, and 
selecting paste), then the versioning was maintained.


When I opened the file in OOo Writer, selected File > Save As, then 
navigated to the new folder, and selected Save, the versioning was lost.


Thanks for the help. Problem solved.

Dick Detwiler

-Original Message-
From: Andy Pepperdine <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Wed, 24 May 2006 13:56:39 +0100
Subject: Re: [users] Question on versions in Writer

 On Wednesday 24 May 2006 13:09, Richard Detwiler wrote:

[EMAIL PROTECTED] wrote:
> On Wed, 2006-05-24 at 07:01 -0400, Richard Detwiler wrote:
>> I've encountered an odd problem at work with versions. A secretary 

came

>> to me with this situation. She had a procedure in Writer that was
>> versioned, with an initial version and then one updated version. 

It was
>> fine on her computer. She saved the document to a shared folder, 

which

>> is necessary so other people could access it. When she did, the
>> versioning vanished.
>>
>> I asked her to send it to me. When I opened it up directly from the
>> e-mail, the versioning was there. I then saved it to my computer, 

opened

>> it, and the versioning was no longer there.
>>
>> I'm at a loss as to what could be going on. Any ideas?
>>
>> (FWIW, she said this happens on all the documents that she has 

tried, it

>> is not specific to this one document.)
>
> Dumb question. Are these saved in MSO formats?

Not a dumb question at all, because saving in MSO format will 

certainly

wipe out any OOo versioning. But these ARE saved in ODT format.
Otherwise, I wouldn't even have had versioning when I opened it from 

the

e-mail.


Quoting from the help pages:
If you save a copy of a file that contains version information (by 
choosing

File - Save As), the version information is not saved with the file.

My interpretation of this is that it should work if she saves the file 
to the
place she got it from, and then copies, using some command or file 
manager,

it to the shared folder later.

When you receive it, you will have to copy it to the place you want it, 
and

then open it with Writer.

I'm guessing that the reason for this is that it is assumed that if you 
save

it elsewhere, it is no longer a file that can be versioned. Versioning
applies to the master copy of anything only. All others are just the 
current

state that has been extracted. - but then I did not develop it.
--
Andy Pepperdine

On this mailing list help is provided by volunteers.
Please subscribe to the mailing list to see all the replies to a query,
and reply only to the mailing list at [EMAIL PROTECTED]

For FAQ, userguide, see: http://documentation.openoffice.org/

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Question on versions in Writer

[rlshadow]

Sorry for leaving out that information. I'm using OOo 2.0.2, and 
Windows XP SP 2.


-Original Message-
From: G. Roderick Singleton <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Wed, 24 May 2006 08:47:37 -0400
Subject: Re: [users] Question on versions in Writer

 On Wed, 2006-05-24 at 08:09 -0400, Richard Detwiler wrote:

[EMAIL PROTECTED] wrote:
> On Wed, 2006-05-24 at 07:01 -0400, Richard Detwiler wrote:
>
>> I've encountered an odd problem at work with versions. A secretary 

came

>> to me with this situation. She had a procedure in Writer that was
>> versioned, with an initial version and then one updated version. 

It was
>> fine on her computer. She saved the document to a shared folder, 

which

>> is necessary so other people could access it. When she did, the
>> versioning vanished.
>>
>> I asked her to send it to me. When I opened it up directly from 

the
>> e-mail, the versioning was there. I then saved it to my computer, 

opened

>> it, and the versioning was no longer there.
>>
>> I'm at a loss as to what could be going on. Any ideas?
>>
>> (FWIW, she said this happens on all the documents that she has 

tried, it

>> is not specific to this one document.)
>>
>
> Dumb question. Are these saved in MSO formats?
>
Not a dumb question at all, because saving in MSO format will 

certainly

wipe out any OOo versioning. But these ARE saved in ODT format.
Otherwise, I wouldn't even have had versioning when I opened it from 

the

e-mail.


OS and OOo release? I have tested on my FC4 box with official 2.0.2 and
on XP Pro and see versions in every case. So more info is needed.
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Finding and editing data ranges of charts

[rlshadow]

I also noticed the grayed-out "Data Sources" menu choice, and it seemed 
like that was just what I wanted -- if only it wasn't grayed out! I 
tried a number of things, including creating a very simple chart from 
scratch, and the selection was always grayed out.


-Original Message-
From: Guy Johnston <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Wed, 17 May 2006 19:41:22 +0100
Subject: Re: [users] Finding and editing data ranges of charts

  I'm not sure if the question about changing the source data is in the 
user
 guides. I've downloaded the most recent OOo general guide and its not 
in
 there, and there isn't one from OOoAuthors. I'm don't know how to do 
that
 either. When a chart is double-clicked for editing, a selection called 
'Data
 Sources' appears in the Edit menu, but it's greyed out. Maybe that's 
the way

to do it if you find a way so it's not greyed out.
Guy

On 17/05/06, G. Roderick Singleton <[EMAIL PROTECTED]> wrote:
>
> On Wed, 2006-05-17 at 11:14 -0400, [EMAIL PROTECTED] wrote:
 > > I have a situation where I'm attempting to help a co-worker with 
some
 > > Calc charts that she has done. Her file consists of many sheets 
and

> > many charts and much data, in a number of the sheets.
> >
 > > In Excel, you can select a chart and determine what its source 
data is.
 > > So far, I have not been able to determine how to do that in Calc. 
I

> > suspect there is a way, but I can't find it yet. Can anyone help?
> >
 > > A related question is how to edit the data range of a chart. Let's 
say
 > > I have a chart that uses the range A1:B8. Then I add two more rows 
of
 > > data, and I'd like the chart now to include the range A1:B10. How 
would

> > I go about doing that?
> >
>
> I believe all your questions are covered in the guides. See
> http://documentation.openoffice.org/
>
> --
> PLEASE KEEP MESSAGES ON THE LIST.
> OpenOffice.org Documentation Co-Lead
> http://documentation.openoffice.org/
>
 > 
-

> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>

  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[users] Finding and editing data ranges of charts

[rlshadow]

I have a situation where I'm attempting to help a co-worker with some 
Calc charts that she has done. Her file consists of many sheets and 
many charts and much data, in a number of the sheets.


In Excel, you can select a chart and determine what its source data is. 
So far, I have not been able to determine how to do that in Calc. I 
suspect there is a way, but I can't find it yet. Can anyone help?


A related question is how to edit the data range of a chart. Let's say 
I have a chart that uses the range A1:B8. Then I add two more rows of 
data, and I'd like the chart now to include the range A1:B10. How would 
I go about doing that?


Thanks,

Dick Detwiler

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] OpenOffice Write Page Numbering Help!

[rlshadow]

-Original Message-
From: Sara Stout-Grandy <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Wed, 10 May 2006 11:34:20 -0400
Subject: [users] OpenOffice Write Page Numbering Help!

 Hello,

 I am using OpenOffice 2.0 and am having trouble with page numbering. I 
have a document for which I would like the page numbering, in the 
header, to start at a number other than 1 (like say 5) and number all 
pages correctly. Right now I have inserted the page number in the 
header using the Insert-Field-Page Number menu selection. But I can´t 
figure out how to change the number to start at 5! What am I doing 
wrong??


Thanks,

Sara Stout-Grandy


  
-

-

Try this:

1. Place the cursor at the beginning of the page at which the page 
number has to be changed.

2. Choose Format > Paragraph.
3. Select tab Text Flow.
4. Under Breaks,
- check Insert
- for Type, choose Page
- check With page Style
- choose style Default (unless you want to switch to another page 
style, for example landscape)

- now set the Page number to whatever number you wish.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Merge to email

[rlshadow]

My apologies for the last post, right after hitting "Send", I saw that 
your question was specifically asking about e-mail merge, which this 
chapter does not cover.


-Original Message-
From: Gert Blij <[EMAIL PROTECTED]>
To: OpenOffice 
Sent: Mon, 24 Apr 2006 15:26:41 +0200
Subject: [users] Merge to email

 OOo 2.0.2 on WinXP

Merge to email was promised for 2.0.

I checked the manuals and the KB but couldn't find anything. Checking 
the
archives shows an enormous amount of frustration and one article 
describing

a scarily techie solution using some Python stuff.

Can anybody point me (a none-techie) to a way to get merge to email to 
work?


TIA
Gert



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Merge to email

[rlshadow]

Have you read the chapter on Mail Merge yet? If not, I highly recommend 
reading it, it should help you. Here is the link:


http://documentation.openoffice.org/manuals/oooauthors2/0211WG-UsingMailM
erge.pdf

-Original Message-
From: Gert Blij <[EMAIL PROTECTED]>
To: OpenOffice 
Sent: Mon, 24 Apr 2006 15:26:41 +0200
Subject: [users] Merge to email

 OOo 2.0.2 on WinXP

Merge to email was promised for 2.0.

I checked the manuals and the KB but couldn't find anything. Checking 
the
archives shows an enormous amount of frustration and one article 
describing

a scarily techie solution using some Python stuff.

Can anybody point me (a none-techie) to a way to get merge to email to 
work?


TIA
Gert



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Re: Creating labels from database - more records than fit a page

[rlshadow]

Bob: Very intriguing. It certainly sounds like you and I are doing the 
exact same thing, but getting different results. I'm hoping that 
someone will have some idea why. Ideas anyone?


Dick

-Original Message-
From: Bob <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Wed, 12 Apr 2006 10:20:31 -0400
Subject: [users]  Re: Creating labels from database - more records than 
 fit a page


 On 4/12/2006 9:56 AM, [EMAIL PROTECTED] wrote:
 > (Apologies for the top posting, the system I'm on at the moment 
doesn't > neatly do bottom posts.)
 > > Bob: Thanks for following the process in the Mail Merge guide, and 
for > providing feedback on the outcome.
 > > I'm puzzled as to why you are seeing all of the blank rows (out to 
> 65,535 presumably). I replicated what you were doing, as well as I 
could:

> > - I created a new spreadsheet with 34 records.
 > > - I went through the process of creating labels, as described in 
the > Mail Merge chapter.

> > - I clicked New Document.
 > > - I selected File > Print, and said Yes to the dialog asking if I 
wanted > to print a form letter.
 > > - At the next step, when you can select all records or certain 
records, > I scrolled down to the 34th record in the database, and 
there were no > blank lines beyond that record. This is different than 
what you observed.
 > > - I accepted the default selection to print All records, sent it 
to the > printer, and got two sheets of labels, the first sheet with 30 
labels (3 > columns times 10 rows), and the next sheet with the 
remaining 4 labels. > There was no indication that "label x of 65,535" 
was being created, > which occurred when you tried it.
 > > Maybe someone with more knowledge about databases than I have can 
> determine what could be going on. It almost seems like your database 
> thinks it has 65,535 records, with all records after the 34th record 

having no visible content, but still being recognized as records.

> > I'm using OOo 2.0.3 with Windows XP, by the way.
 > > What is your database source? (Calc spreadsheet, Excel 
spreadsheet, > other type of file?) If it's something other than a Calc 
spreadsheet, > maybe there is a clue there somewhere.


 A OOo Calc spreadsheet with 34 rows of data. I followed the directions 
in the Mail Merge Guide for linking to a database.


 I just now, as a test, created a new Calc spreadsheet by copying only 
the data from the original spreadsheet to a new one, then registering 
the new spreadhsheeet as the data source, creating new labels based on 
that spreadsheet. When I followed the Mail Merge guide, I got the same 
results - it wanted to create 65535 labels.


 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Re: Creating labels from database - more records than fit a page

[rlshadow]

(Apologies for the top posting, the system I'm on at the moment doesn't 
neatly do bottom posts.)


Bob: Thanks for following the process in the Mail Merge guide, and for 
providing feedback on the outcome.


I'm puzzled as to why you are seeing all of the blank rows (out to 
65,535 presumably). I replicated what you were doing, as well as I 
could:


- I created a new spreadsheet with 34 records.

- I went through the process of creating labels, as described in the 
Mail Merge chapter.


- I clicked New Document.

- I selected File > Print, and said Yes to the dialog asking if I 
wanted to print a form letter.


- At the next step, when you can select all records or certain records, 
I scrolled down to the 34th record in the database, and there were no 
blank lines beyond that record. This is different than what you 
observed.


- I accepted the default selection to print All records, sent it to the 
printer, and got two sheets of labels, the first sheet with 30 labels 
(3 columns times 10 rows), and the next sheet with the remaining 4 
labels. There was no indication that "label x of 65,535" was being 
created, which occurred when you tried it.


Maybe someone with more knowledge about databases than I have can 
determine what could be going on. It almost seems like your database 
thinks it has 65,535 records, with all records after the 34th record 
having no visible content, but still being recognized as records.


I'm using OOo 2.0.3 with Windows XP, by the way.

What is your database source? (Calc spreadsheet, Excel spreadsheet, 
other type of file?) If it's something other than a Calc spreadsheet, 
maybe there is a clue there somewhere.


Dick Detwiler

-Original Message-
From: Bob <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Wed, 12 Apr 2006 07:59:09 -0400
Subject: [users]  Re: Creating labels from database - more records than 
 fit   a page


 On 4/12/2006 2:52 AM, Cor Nouws wrote:
> Hi Bob,
> > Bob wrote:
> >> On 4/9/2006 4:36 PM, Cor Nouws wrote:
> > >>>
>> This is really frustrating. > > [...]
> >>
>> All I want OOo to do is create/print 34 labels.
>>
 >> I can't explain why the Mail Merge (with labels) wants to create 
65535 >> labels!

>>
> > No idea.
> There is a realy good step by step guide:
 > 
http://oooauthors.org/en/authors/userguide2/writer/published_final/0211WG

-UsingMailMerge.pdf
I think I've found the problem and a work-around solution.

 I followed the Mail Merge guide to register (reregister, actually) the 
database source, and then proceeded to Printing Mailing Labels (page 8 
of the guide; page 12 of 35 of the PDF file). Everything went smoothly 
until page 10 & 11 of the guide, at step 8. I originally clicked on 
Records/All, then OK (step 9). I did not select any records. At that 
point the Mail Merge box showed that it was creating page letter x of 
65535 and I stopped the process.


 The next time I clicked on Records/Selected Records, and highlighted 
all of the records (not any of the empty rows which followed the actual 
records). It created only the selected 34 records and printed them 
directly to the printer.


 I now realize the problem is that when the mail merge dialogue 
appears, it is "looking" at all of the rows in the OOo Calc spreadsheet 
(which is the database) - all 65535 of them! In the dialogue, I can 
scroll down through the empty rows; although I didn't go to the bottom, 
I suppose the number would have been 65535!


 I don't know if this is a bug in the 2.0.x (newest) version or if it's 
an anomoly with my system for whatever reason. Either way, I must 
select specific records, even if it is all of the records, in order to 
avoid creating 65535 labels (and I presume any other mail merge 
document) even when following the instructions in the Using Mail Merge 
guide. The guide itself implies in the Printing Mailing Labels section 
page 8 that if you want to print all of the records, you do not need to 
select any records.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] In Calc, carriage returns within a text cell?

[rlshadow]

Ctrl+Enter.

-Original Message-
From: Richard Connors <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Mon, 10 Apr 2006 10:58:27 -0400
Subject: [users] In Calc, carriage returns within a text cell?

  Using OO 2.0.2 and seeking to force carriage returns within a single 
text cell. Any ideas?


Dick

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[users] Mailing labels

[rlshadow]

There have been a number of postings recently about problems with 
creating labels. I recommend that anyone who is having trouble with 
labels refer to Chapter 9 of the Writer Guide: "Using Mail Merge". Here 
is the link:


http://documentation.openoffice.org/manuals/oooauthors2/0211WG-UsingMailM
erge.pdf

Better yet, before you have trouble, refer to this, it should save some 
frustration. I'm biased because I'm one of the authors, but I believe 
this describes a process that is relatively straightforward and which 
works.


From trial and error experience, my impression is that there are a 
number of ways that seem like they should work, but some of them just 
don't. Then there are other ways that do work but in my opinion, are 
more complicated than they need to be. It's not real intuitive to 
figure out how to do labels. I certainly had my share of frustrations 
(including the common problem of only one page printing out).


This chapter drew on the positive experiences of many people taken from 
this mailing list and other sources, ways that work well, but had not 
been captured in one place before.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[users] Re: calc - trimming extremes from a data set

[RLShadow]

 
I used to do things like screening for outliers all the time, but it's been  
a couple of years. I did a quick search and I found the following description 
of  a fairly well-accepted technique for outlier detection:
 
_http://mathforum.org/library/drmath/view/52794.html_ 
(http://mathforum.org/library/drmath/view/52794.html) 
 
This is based on the "inner quartile range" (IQR) which is the difference  
between the top of the 3rd quartile (the 75th percentile) and the bottom of the 
 
2nd quartile (the 25th percentile). Calc does have a useful function for  
implementing this algorithm (QUARTILE). 
 
For the heck of it, I used the IQR test on the numbers you gave as an  
example. It confirmed that the value of 98 is in fact a suspected outlier; 44 
is  
just inside of the criteria for a suspected outlier.
 
Hope this helps.
 
Dick Detwiler
 
In a message dated 4/3/2006 4:10:11 P.M. Eastern Standard Time,  
[EMAIL PROTECTED] writes:

Date:  Mon, 3 Apr 2006 15:51:13 -0400 (EDT)
From:  =?iso-8859-15?Q?Lars_D=2E_Nood=E9n?= <[EMAIL PROTECTED]>
To:  users@openoffice.org
Message-ID:  <[EMAIL PROTECTED]>
MIME-Version:  1.0
Content-Type: MULTIPART/MIXED;  
BOUNDARY="-745680126-1494253935-1144093676=:27338"
Subject: calc - trimming  extremes from a data set



How would I go about using Calc's  statistical functions to identify 
extreme values in a data set ?   e.g. in the following set, '98' is way out 
of line with the other  points.

1 2 3 4 5 6 7 8 11 12 13 15 16 18 21 29 34 36 44  98

It's been longer than I'm willing to admit since I've done any  statistics 
and never had any formal instruction.  Would standard  deviation be useful 
for that?  If so, how do I find the deviation for  individual points rather 
than the avg for the whole  set?

-Lars

[users] Re: Unexpected behaviour with print ranges in Calc

[RLShadow]

 
 
There are certainly work-arounds, and in the scheme of things, my complaint  
pales compared to people who can't get OOo loaded at all, can't get envelopes 
to  print no matter what they try, etc.
 
But still -- It doesn't seem like a great situation. I really like the  
default print ranges, in most cases they work well, and they have an advantage  
in 
that if I add a few rows, the range automatically expands to include the new  
rows. When I define a range, it often happens, due to my mental lack of  
astuteness I'm sure :), that I'll add a few rows and then forget to change the  
print range, and I don't realize it until I've wasted some paper and ink.
 
I also like having the ability to define a range when I wish to, for those  
sheets where I don't want the range chosen by default (ie, for those sheets, I  
don't want everything printed, I want to dictate what range gets printed). 
 
So the situation is that I can't do both in the same spreadsheet. If I have  
a 20-sheet worksheet, and the default range is what I want for 19 of the 
sheets,  and I want to define a range for the 20th sheet, I will lose the 
default 
range  for the other 19, and need to define a range for each one. Just doesn't 
seem  right to me, but that must just be how I approach things.
 
Thanks for the responses anyway.
 
In a message dated 3/13/2006 2:49:55 P.M. Eastern Standard Time, Joe Conner  
[EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])  writes:

Print ranges have "DEFINE", "EDIT" and "ADD"  commands.  For the second page, 
when you define
its print range use  "ADD" then you have what you are asking for.


Ross Johnson  wrote:  
On Mon, 2006-03-13 at 06:08 -0500, [EMAIL PROTECTED] 
(mailto:[EMAIL PROTECTED])  wrote:

  

I've observed something that seems odd or at least unexpected in  Calc.

 

I create a spreadsheet, with content on two of the sheets (Sheet1 and  

Sheet2).

 

First, I don's set any print ranges. When I print, or do a print preview,  

from either sheet, a default range is established by Calc that includes all 
of  

my content. Good, this is what I would hope for.

 

Second, I go into Sheet1 and manually set a print range. Sheet1 prints with  

that range. Also good, this is what should happen.

 

Third, I go to Sheet2, and don't set any manual range. Now nothing prints  

from Sheet2. Not good! Why does setting a print range in Sheet1 seem to wipe 
out 

 the default print range in Sheet2?

 

Can anyone else verify this behaviour? Is this an intentional feature, and  

if so, what would be the rationale for it?





I haven't explicitly verified it, but I'm not unhappy about that

behaviour. It does seem natural to me that if I define a print range,

that that would be just what I want printed. I recently defined print

ranges in a 12 sheet spreadsheet and didn't think twice about it, didn't

even think that it feels odd to do that. In fact, I kind of expected to

have to do it that way.



Maybe if it was the other way around I'd get used to it just as easily.



  

 

Dick Detwiler, Webster, NY

[users] Unexpected behaviour with print ranges in Calc

[RLShadow]

I've observed something that seems odd or at least unexpected in  Calc.
 
I create a spreadsheet, with content on two of the sheets (Sheet1 and  
Sheet2).
 
First, I don's set any print ranges. When I print, or do a print preview,  
from either sheet, a default range is established by Calc that includes all of  
my content. Good, this is what I would hope for.
 
Second, I go into Sheet1 and manually set a print range. Sheet1 prints with  
that range. Also good, this is what should happen.
 
Third, I go to Sheet2, and don't set any manual range. Now nothing prints  
from Sheet2. Not good! Why does setting a print range in Sheet1 seem to wipe 
out 
 the default print range in Sheet2?
 
Can anyone else verify this behaviour? Is this an intentional feature, and  
if so, what would be the rationale for it?
 
Dick Detwiler, Webster, NY

Re: [users] Questions on program

[RLShadow]

 
In a message dated 2/16/2006 3:30:36 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

Hi

Before I download the program I have some  questions.

1.  If I have Word, Works,  etc.  Will I still have these programs after 
downloading Open Office and  be able to still use them?

2.  Does this  program attach trackers to my browser?

3.   After downloading will there ever be a charge for using the  program?

Thanks

Linda  Miller







Linda:
 
1. Yes, you'll still have Word and Works after downloading OpenOffice.org,  
and you'll still be able to use them.
 
2. I'm not familiar with trackers so someone else will need to answer this  
question.
 
3. There will never be a charge for using  OpenOffice.org.

Re: [users] [moderated] YOU MUST GIVE A SUMMARY HERE

[RLShadow]

 
In a message dated 2/16/2006 3:08:10 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

I am using "windows 98SE" operating system & a 56K modem. This  download 
takes over 7 hours to download. My question is: Can I have or  buy a CD disk 
for 
this software. I was referred to this site by:  "Stratitec Inkjet Refill nKit". 
 
Thank-you in advance. Bill Baker
P.S. Please send an E-Mail to me to: [EMAIL PROTECTED] 
(mailto:[EMAIL PROTECTED]) .



--
Yes, you can purchase a CD. You can find sources (people, not officially  
connected with OpenOffice.org, who sell them) on the OOo web site. You can also 
 
do a search of E-Bay; last time I did that, I found multiple people selling 
CD's  for what seemed to be very reasonable prices ($5-$10 US including  
shipping).

Re: [users] [moderated]

[RLShadow]

 
In a message dated 2/10/2006 4:49:10 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

>Is  Open Office "free" to download & use for a small business (6  employees)?

>Thank you
>Pamela



---
We wish all questions were this easy. The answer is emphatically  "yes".

Re: [users] My husband screwed up my computer!

[RLShadow]

 
In a message dated 2/9/2006 6:53:42 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

My  darling hubby decided he wanted everything to work in MS Word again, and  
 
went to folder options and changed everything back to MS Word.

Now,  though, there are weird paragraph marks all over the documents.   I  
tried hitting setup in the Open Office file, and tried repair, but that  only 
 
makes the files open in Open Office again, and they still have  the weird PP  
marks 
all over.  Can this be fixed?   How?

Thanks.

Cindy Lee Haddock



-
Nope, nothing you can do, just delete the files and type them in again  
 
Just kidding. This should be easily fixed. Go to the View menu,  and click 
Nonprinting Characters to uncheck it. That should fix the  problem.

Re: [users] spreadsheet calculating

[RLShadow]

 
Try the following:
 
While in Calc, go to: Tools > Options, then expand OpenOffice.org Calc,  then 
click View.
 
Under "Display" the first item listed is "Formulas". Is the box checked? If  
so, that's the problem. Uncheck the box, click OK, and your problem should be  
solved.
 
---
In a message dated 2/8/2006 11:24:45 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

I am  using the 2.0 version of OpenOffice.org.  I have
been trying to get  the spreadsheet to calculate
formulas but with no luck.  I have even  followed the
example given under the Help topic of Calculating  in
Spreadsheets.  Allowing cells A3 & A4 to both be 1 and
cell  B4 to  be the example formula of =A3*A4/100 then
pressed enter. It did  not calculate the formula but
did print the formula in the cell.  I  have also
checked to make sure the AutoCalculate under Tools -
Cell  Contents has been turned on.  I am now stuck as
to what to  do.
Thank you for your help.
B Benington


 

Re: [users] Capitalisation

[RLShadow]

 
In a message dated 2/6/2006 3:31:23 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

I have a  spreadsheet in Open Office 1.1.2 which has been behaving well.
But since (I  think) last weekend when I enter a text letter such as 'a',
although it  displays in lower case when I enter it as soon as I move to
another cell  the letter capitalises.  Why does this happena and how do I
stop  it?  Any help greatfully received.

Simon


--
 
What you need to do is go to Tools > Autocorrect > Options, and  uncheck the 
box for "Capitalize the first letter of every  sentence."

Re: [users] Re: Smooth scaling of images

[rlshadow]

To keep the aspect ratio constant, hold down the shift key while 
re-sizing.


-Original Message-
From: Chuck <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent:  Mon, 06 Feb 2006 10:56:21 -0500
Subject: [users]  Re: Smooth scaling of images

 Adalbert Dawid wrote:

Hi list,

I'm working on a presentation for my employer and decided to do it 

with

OOo-Impress 2.0. This presentation includes a logo of the company I'm
working for, which has to be properly down-scaled by Impress.
Unfotunately, after scaling down the logo looks really bad in 

Impress, so
I started looking for some option to improve the scaling quality 

(e.g. by

turning on bilinear or trilinear smoothing), but found nothing so far.
In comparison, MS Powerpoint does the same scaling job *much* better.
Also, if I downscale the image with any graphics viewer (like gqview)
with bilinear scaling turned on, it looks pretty much the same as in
Powerpoint.

So here is my question: is there a way to improve the scaling quality 

of
images in the OOo suite? If not, I'll be forced to switch to 

Powerpoint,

which I really don't want to happen...

Thanks
Adalbert


I agree that image scaling is a weakness in OOo. In writer I've wanted
to resize an image by dragging the corner while keeping the aspect
ratio. There doesn't seem to be any way to do this.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[users] Question on OOo apparently tripping "Firewall"

[rlshadow]

Where I work is in the process of converting from MS Office to OOo. 
(It's going fairly well so far.) Not specifically related to work, but 
related to OOo, I received this note from a co-worker:


"I downloaded Open Office for my home pc (Windows XP).  I recently 
uninstalled it because my firewall constantly caught it trying to 
communicate via the internet.  I couldn't find any spyware through a 
variety of programs and wondered if you knew whether this is usual or 
unusual?"


In talking to her further, the firewall she has is Norton. The OOo 
version is 2.0. She said that when she did something quite simple, like 
changing the font on some text, the firewall would detect activity.


Does anyone have any insight into what could be causing this behavior?

Thanks,

Dick Detwiler, Webster, NY

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] writer issues

[RLShadow]

 
Just to clarify -- If you check Format > Autoformat and uncheck the  option 
While Typing, then no autoformatting will happen, including  autocorrection 
(correcting "teh" to "the" for example), which many/most people  think is a 
good 
thing. It also includes things like changing a double hyphen to  an em dash, 
changing quotes to smart quotes, etc.
 
What the OP wants to do is turn AutoCOMPLETE off. Go to Tools >  Autocorrect, 
click the Word Completion tab, and uncheck the box that says Enable  Word 
Completion.
 
In a message dated 2/3/2006 2:39:06 AM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

Hi  Mel,

mel wrote:

> I just started using open office writer and  the
> software is trying to finish words for me.  For
>  example, I key in inter and the programs pulls up ests
> highlighted to  create the word interests. I can type
> over top of it, but it is  driving me crazy.  How do I
> turn this feature  off?

Format|Autoformat| ... and check  off.

Greetings,
Cor

(_pls keep mailings on the  list_)

Re: [users] question about open office

[RLShadow]

 
First question: Yes.
 
Second question: Yes, but there have been a lot of questions regarding  
uninstallation. My understanding is that a key point that is not obvious is 
that  
one has to close the "quick starter" or it won't uninstall. The quick starter 
is  found (assuming you are on Windows, not sure how other OS's work) in the 
lower  right hand corner of your screen. It's called "OpenOffice.org 2.0 
Quickstarter".  You close it by right clicking and selecting "Exit 
Quickstarter."
 
In a message dated 2/1/2006 4:16:34 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

sorry if  my question seems trivial..

I'm assuming from reading the  information...

that you can open any Microsoft product (excel, ppt,  word)... modify it
using openoffice and then save it again to the Microsoft  file type?

also...
if you download a copy of open office and decide  you don't want it... or
don't like, does it uninstall  cleanly?

dan


 

Re: [users] cd, mailing labels

[rlshadow]

1. Question 1: Try going on E-bay and searching for OpenOffice.org. 
When I last tried this, I found a number of people selling CD's with 
OOo for what seemed to me to be very reasonable prices (like US$5.00 
including shipping).


2. Question 2: Take a look at the following chapter from the users' 
guide: 
http://documentation.openoffice.org/manuals/oooauthors2/0211WG-UsingMailM

erge.pdf

This should explain exactly what you need to do to print address labels 
from a spreadsheet.


Dick Detwiler, Webster, NY

-Original Message-
From: Rick Martin <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Wed, 01 Feb 2006 12:52:29 -0600
Subject: [users] cd, mailing labels

 Can I order an OO.org cd for my pc?  I downloaded the OO.org onto my
linux computer at work, and found it to be quite confusing.  In fact, I
got help from a linux-minded associate and he also had problems opening
and installing the new 2.0 version.  So I would like to get a cd for my
pc at home. I am already running OO.org at home, version 1.1, I believe.

Question #2: I need to run address labels from a spreadsheet.  Can you
please send me instructions on how to do this?  Thanks.

An OO.org fan,
Rick Martin

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] A few Newbie Questions -- Word Processing

[rlshadow]

One approach to try is typing in, on a blank line, three hyphens with 
no spaces in between (---), and then pressing Enter. That gives a 
horizontal line, and when I tried it just now, there was very little 
space between the line and the text above it.


-Original Message-
From: Steven Cox <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Mon, 30 Jan 2006 14:28:26 -0500
Subject: Re: [users] A few Newbie Questions -- Word Processing

  I think I'd probably use the Line tool to draw my horizontal line. If 
the draw tools aren't open at the bottom of the screen, go to View > 
Toolbars > Draw and turn 'em on.


 To constrain the line you hold the shift key down while drawing it. 
That keeps it horizontal or vertical.


Steve Cox


David Clark wrote:

 > To design a letterhead, in WP I've used a text box. That doesn't 
seem > to exist in OO, so I used a table and got the two lines of text 

inserted into that.

>
 > Now, I want to set a single horizontal line directly beneath the 
last > line of text just as though using the underlining text, but 
margin to > margin even if the text is not, which is easily done in WP. 
The only > thing I seem able to get from OO is a line feed and then a 
single line > using Horizontal Ruler and Gallery. I want to eliminate 
the line > feed. How do I do that? When I tried to create one in 
Gallery, it > wound up as two lines, not one.

>

 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Re: [Spam] Re: [users] Do not want openoffice to be default progr...

[RLShadow]

 
I agree it could be worded better, but just to clarify, OOo does not  
"convert" MS Office files to OpenOffice.org files. That's not what "associate"  
means.
 
In a message dated 1/29/2006 7:24:34 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

I  think  the message "When you install Open Office, it asks you whether  
you want to associate MS Office files with Open Office. In order to not  
associate these MS Office file types, you must uncheck the appropriate  
boxes before continuing." could be worded better for the general public  
to avoid mis-understandings.

It would be much better to state that  if you associate MS Office files 
with Open Office, that Open office will  become the Default Program and 
that it will convert MS Office files to  Open Office files.

A lot of people are going to mis-interperat the term  "associate"

Re: [users] Change delete selection in Calc

[RLShadow]

 
This may not totally be what you're looking for, but if you press the  
backspace key instead of the delete key, it deletes the cell without asking any 
 
questions.
 
In a message dated 1/26/2006 5:54:36 AM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

When I  press the delete key in Calc I get a number of default pre-ticked
selection  options. Is it possible to set OOo up in such a way that as the
default  only Delete All is ticked and all the other options are  un-ticked?

TIA
Gert 

Re: [users] Cursor Movement in Protected Sheet

[RLShadow]

 
Jeannie: I'm puzzled by the symptoms you describe. I've done data entry  
forms in Calc exactly like you describe and they're worked just like they're  
supposed to (like you describe Excel does). So my main input is that it SHOULD  
work in Calc, but that doesn't help you figure out why it doesn't. Possibly you 
 
could re-do the whole protection/unprotection process and see if that  helps.
 
Dick Detwiler, Webster, NY
 
In a message dated 1/24/2006 3:08:43 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

We have  both Open Office and Microsoft users in our organization.  I
have  constructed a form in Microsoft Excel.  The data entry field cells
are  formatted unprotected, all other cells protected.  Sheet Protection
is  turned on, with "Select Unlocked Cells" activated.  The result is
that  the cursor goes directly to the next unprotected data entry field
when the  Tab key is pressed.  Makes for very efficient data  collection.




Using this form in Open Office 2.0, Tab key  seems to move the cursor to
the protected cell immediately right of the  last input, and then to the
next unprotected data entry cell, but not  always.  The unpredictable
nature of the beast makes for ghastly data  entry.



Any suggestions?



Jeannie McQuaid,  CHRP

Supervisor, Human Resources

BELSHIELD ENTERPRISES  LIMITED



ph: (613) 966-3399 Ext.  272

fax: (613)  967-8948

email:  [EMAIL PROTECTED]   


 

Re: [users] Labels

[rlshadow]

Anne:

Did you use the path File > New > Labels? That should have pre-set 
formats for nearly any common type of label, with the correct width and 
height.


Getting OOo to make labels from a database isn't totally intuitive, so 
it would be helpful to read documentation about how to do it. A 
recently revised document that you can refer to is at:

http://oooauthors.org/en/authors/userguide2/writer/published_final/0211WG
-UsingMailMerge.pdf/view

Dick Detwiler

-Original Message-
From: Anne Herron <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Mon, 23 Jan 2006 09:43:56 -0600
Subject: Re: [users] Labels

 Peter,

 Thanks for your response! No, I'm not trying to create a table. I'm 
trying to print onto individual lables that will be used on manilla 
folders. You can customize the size that you print onto and I can 
adjust everything except the height and width. For some reason when I 
override those measurements, it defaults back to what was originally 
set up. I've used this feature alot with Word and it was very easy to 
adapt to changes.


Your input is appreciated!

Anne
 - Original Message - From: "Peter Hillier-Brook" 
<[EMAIL PROTECTED]>

To: 
Sent: Saturday, January 21, 2006 3:00 AM
Subject: Re: [users] Labels

> Anne Herron wrote:
>> Hello,
>>
 >> I'm trying to print small labels and am having difficulty adjusting 
the >> height and width measurement. It keeps defaulting to .04" when I 
>> override the number and won't let me use the up and down arrows to 

customize. Can you assist me?

>>
>> Thanks,
>>
>> Anne
 > A little more information would help. Are you trying to create a 
page (or > pages) with a table for the label positions? If you are, are 
you using > English measurements? If you are then you have run into a 
deficiency in > OpenOffice in that it presently will not function to 
the required degree > of accuracy in the user interface.

>
 > The workaround is to switch your default measurement units to 
metric, > create your table to the accuracy required and then revert 
your > measurement system to English - but DON'T make any further 
adjustments or > the problem will be resurrected!!

>
 > This is all caused by the user interface only offering 2 decimal 
point > accuracy, whatever the chosen measurement unit happens to be, 
and > hundredths of a millimetre are a lot smaller than hundredths of 
an inch. > Internally there is no problem with the desired degree of 
accuracy, so as > long as no further changes are made after using 
metric units to create > your table the accuracy will stick.

>
> Regards
>
> Peter HB
>
 > 
-

> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Is there anyway tot make timelines with OpenOffice.org?

[RLShadow]

 
Actually I think the closest Microsoft application to what is being asked  
for isn't Visio, but rather Microsoft Project. (Project-management software.) I 
 
dabbled using MS Project a few years ago; I found it fairly klutzy and  
non-intuitive but once one got to learn it, it certainly did what it was  
supposed 
to, and it definitely would be an application to use to prepare  timelines.
 
I'm assuming that there isn't anything in OOo that is remotely close to  
serving that function, but I may be mistaken.
 
In a message dated 1/17/2006 11:52:03 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

I think  he is referring to the ability to create what is basically a 
flow  chart.  E.g. plan a wedding and create a chart showing the timeline  
of events leading up to the wedding.  Probably the closest would be  
something similar to Visio, though MSO had some tools available to  
create basic graphics of a timeline.  I have seen people prepare  
timelines using a spreadsheet - very labor intensive, but it could  work.

Jeff Causey


 

Re: [users] How to check which OO version I'm running

[RLShadow]

 
I wasn't the original poster, but I did try the Help suggested. As far as I  
can tell, there is nothing using the method that tells me that I'm on 2.0.1 
even  though I'm quite sure I am. Help > About OpenOffice.org says I'm on 2.0.  
Pressing the Ctrl S D T key sequence will then give the build number but 
doesn't  seem to give the version number.
 
In a message dated 1/17/2006 7:23:52 AM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

On Tue,  2006-01-17 at 11:52 +0100, Nico De Ranter wrote:
> Hi,
> 
>  quick question: how can I check which exact version of OpenOffice I'm
>  running. I tried clicking on About but I get OpenOffice 2.0. Is this
>  2.0.0 or could it also be 2.0.1? How can I make sure which one it is?
>  
> Nico

Does Help > Contents > Index > Search term >  versions;OpenOffice.org not
give you results? Let us  know.

Re: [users] [moderated]

[RLShadow]

 
Save your file as .txt or .rtf, and it can be opened with Wordpad, which  
most Windows based computers have. Or save it as .doc and it can be opened with 
 
Microsoft Word.
 
In a message dated 1/16/2006 3:54:42 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

I have a  problem I hope someone can help me with.  I have a Compaq computer  
operating Windows ME.  I downloaded free version of Openoffice.org did  some 
word processing and put it on a floppy disc and gave it to a friend of  mine, 
but he cannot open it.  He has Windows XP.  He gets a message  that says 
Windows cannot open this program.  He tried to open it with  Microsoft Word, 
Microsoft Notepad and Microsoft Wordpad but nothing  works.  Will he have to 
download Openoffice.org to view the floppy disc  or is there something that we 
are 
doing wrong?  thanks for any help you  can give me.


 

Re: [users] 2 hours to set tabs :-((

[RLShadow]

 
It sounds like the use of paragraph styles would help significantly in what  
you're trying to do. If you're not familiar with styles, take a look at the  
users guide for OOo 2.0, which you can find at 
_http://documentation.openoffice.org/manuals/index.html_ 
(http://documentation.openoffice.org/manuals/index.html) The section on 
styles starts on page 65.
 
In a message dated 1/15/2006 8:31:34 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

Hi  again,
I'll be wearing out my welcome, but here I go
again. I was  presented with a 17 page list of
names and relevant page numbers. This  was
created: sometimes using spaces, sometimes
default tabs and  sometimes user defined tabs.
The whole looks like a dogs breakfast  and
foolishly I volunteered to tidy things up.
My approach was to use  just 3 tabs, the last a
right tab for the numbers and shift things into  
place by removing multiple spaces a.s.o.
But I couldn't set the tabs!  If I highlight the
text I can't set tabs, if I select one single line
at  a time I can set tabs, but as soon as I go 
to the next line I have to set  tabs over and
over again.

So how can I set fixed tabs for existing  text?
A solution really would restore my faith
in O  O.
Max.

Re: [users] Converting files from Works 3.0 to OpenOffice in Windows XP Home ...

[RLShadow]

 
>From within Works, you'll need to save the files in a format that OOo can  
read, such as RTF. OOo cannot read Works files directly. (For that matter, MS  
Office also cannot read Works files directly.)
 
In a message dated 1/15/2006 8:01:36 AM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

Good  morning!
Please give me advice on how to convert files produced on my old  notebook 
(Windows 95) in Works 3.0 into OpenOffice files (Windows  XP).
Thank you very much in advance for your kind help!
Best  regards,
Günter Langenberg

Re: [users] [moderated]

[RLShadow]

 
Yes, there IS a book titled OpenOffice.org for Dummies.
 
In a message dated 1/13/2006 11:18:41 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

Unfortunately I'm guessing there isn't even  a Dummies book on  Open Office. 
May be there is?


 

Re: [users] Help!

[RLShadow]

 
Janine -- not quite sure what you're asking. You have Word, and you're  
asking how to uninstall Microsoft Word? That's what you asked but I'm not sure  
it's what you meant. If it is, it doesn't seem like it should be hard to  
uninstall MS Word using the standard "Add/remove programs" assuming you're 
using  
Windows.
 
Maybe what you meant is that you want to uninstall OpenOffice.org  Writer 
(the OOo word processor) -- if this is your question, it is possible to  
uninstall the entire OpenOffice.org application (including spreadsheet,  
presentation, 
database, and word processor), but not just OOo Writer. But you  could do a 
full uninstall of OpenOffice.org, then do a custom re-install and  only specify 
the applications that you want, not installing Writer.
 
A question that I have, though, is why there is a strong need to uninstall  
OOo Writer at all. OOo Writer and MS Word can happily co-exist. 
 
Dick, Webster, NY
 
In a message dated 1/13/2006 11:18:04 PM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

Hi, can  someone tell me how to uninstall the Microsoft Word feature.   I
already have Word on my computer.  THanks! 



Janine  

[EMAIL PROTECTED]

Re: [users] Merging to Labels

[RLShadow]

 
Com,
 
Thanks for the response. Just a couple of more or less random thoughts from  
me -- 
 
>From my experience and from doing quite a bit of reading what others have  
written on this topic, there are numerous ways to create labels. Some work and  
some don't! But there are more than one way to successfully print labels. I  
think the objective of this chapter (I say "I think" because while I 
contributed  to it, and I have my own idea of the objective, I certainly wasn't 
the only 
 author, so I don't want to speak for the others) was to give one (or maybe 
two)  methods that work and are fairly easy to follow. So while the "Data to 
fields"  approach can work, and is a legitimate approach, I'm not sure it is 
the 
easiest  for most people. For you, it probably is; but I had some struggles 
with it  myself, and then found other approaches that to me seemed to make more 
sense and  worked OK.
 
I'm not sure I totally follow the statement "What most people mis (and  
reading her post, I gues its the same with 
Patty) is the step that once the  label-document is ready, they need to 
select data/rows and give a command to  have it placed in the labels." Can 
you (or Patty?) elaborate on this?
 
As far as the point about having a simple set of steps instead of a more  
wordy explanation with screen shots of each step -- I think this is an issue of 
 
different people absorbing information in different ways. From my (admittedly  
limited) experience working with people who either aren't terribly computer  
literate, or who have limited experience with a particular application, it's  
helpful to spell things out in a fairly detailed manner, and that pictures  
(screen shots) really DO help. I know when I'm learning a new application, I  
find it helpful to have a lot of screen shots. 
 
But other people, probably more experienced users, only need a simple set  of 
instructions and can find the extra words and screen shots distracting. So  
one size won't fit all.
 
Dick Detwiler
 
In a message dated 1/12/2006 8:13:55 AM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

Hello  Dick,

May I take *this* opportunity to give som feedback on the  document ;-) 
(Thanks for contacting me before - sorry I didn't answer  earlier).

I see that with letters, labels and envelopes the advice is  to prepare 
the document, save it, type Ctrl-P and choose Yes. Thus we get  the nice 
dialog we know from OOo 1.x.
Why not let the people save the  document, select their records in de 
datasource window, choose the icon  'Data to fields', type Ctrl-P and 
choose No?
It makes more use of one  data window.

That said, I find the instructions very good.
What most  people mis (and reading her post, I gues its the same with 
Patty) is the  step that once the label-document is ready, they need to 
select data/rows  and give a command to have it placed in the labels.

Maybe some more  emphasize on that aspect, could help.

A totaly different suggestion:  apart from the verbose explanation with 
screen shots of every window, I do  like to give explanation in just the 
main steps. Just as I did in my first  post to Patty (11-1-2006 22:22).
Maybe for each merge-document such a short  list could be included?

Pls let me know If you want some more  information.

Looking forward to your idea's.
Kind  regards,
Cor

Re: [users] Merging to Labels

[RLShadow]

 
Patty -- did you try reading the link I sent? (Shown below.) We really  tried 
to make this chapter a "stand-alone", one that had all of the information  
you need to successfully create labels. If you did read it and follow the  
guidance and are still having problems, we'd like to know some specifics about  
what you've done, maybe we can help further, and maybe it will point to  
something that needs to be changed in the chapter to make it clearer.
 
If you didn't look at it yet, please do. It's intended for situations like  
yours, people struggling to do labels and other mail merge operations.
 
Dick Detwiler, Webster, NY
 
Here is the link to this chapter:

http://oooauthors.org/en/authors/userguide2/writer/feedback/0211WG-UsingM
ailMerge_8Jan06_JHW.odt/view?searchterm=mailing%20labels

or  http://tinyurl.com/ccenm


In a message dated 1/12/2006 3:09:05 AM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

Thank  you for the input and link to the documentation.  I've downloaded many 
of  the label templates and that certainly helps, but when I do the merge, I 
only  get the first record and nothing else.  I've tried it with using  and filling in a separate set of fields for each label on the  sheet, 
but nothing.  Only the first record and all else is blank.   Also, OO has 
crashed several times during the merge.  Is there a helpline  I can call for 
tech 
help or another chat line -- possibly something for  bugs?

Thanks
Patty

Re: [users] Merging to Labels

[rlshadow]

This newly-revised chapter (which is still in the review stage) should 
offer some help:


http://oooauthors.org/en/authors/userguide2/writer/feedback/0211WG-UsingM
ailMerge_8Jan06_JHW.odt/view?searchterm=mailing%20labels

or http://tinyurl.com/ccenm

-Original Message-
From: [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Wed, 11 Jan 2006 13:08:15 +
Subject: [users] Merging to Labels

  I am frustrated in my attempts to merge a spreadsheet document in 
which I've put
my personal friends, etc. into a Writer template for Avery labels.  I 
downloaded
the new label templates and have gotten to the point of linking the 
spreadsheet
and inserting the fields from it into the label template.  But I have 
been

unable to figure out how to get the merge going.

I have not found a tutorial that explains this (tho, granted, I have 
not looked

minutely through all those listed on the website).

Can anyone help me?
Patty
--
Art in Pencil, Ink and Watercolor
http://www.pattycunningham.com

  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Less or Fewer Options?

[RLShadow]

 
Is there anything misleading about the term "Less options"?
 
In a message dated 1/6/2006 3:48:51 AM Eastern Standard Time,  
[EMAIL PROTECTED] writes:

Alec
As you're not subscribed to the list you may have missed the  following post.

n.b. from my understanding it is a defect  but...
WSP

Paul wrote:
> I would recommend an enhancement...  What is there makes sense, your
> just suggesting a way to make it  better.
>
> Reply to the list if you require assistance filing the  issue.
>
> /paul
>
> On 1/5/06, Alec McAllister  <[EMAIL PROTECTED]> wrote:
>   
>> In  OO Writer, Edit ... Find & Replace ... offers a button offering  More
>> Options. When that is selected, it changes to "Less Options".  I don't
>> suppose we can get that corrected to "Fewer Options", can  we?
>>
>> I've never filed an issue before; should this be  filed as an Enhancement
>> or as a Defect?
>>
>>  Alec McAllister

Re: [users] Top Posting especially/elaine

[rlshadow]

I also prefer top posting, so therefore it's comforting to hear me 
described as one who is "lazy, ill informed or think that their time is 
more valuable than that of many others". It is nice to hear, though, 
that I'm not the only one on this group who prefers top posting.


I'm not sure if I can generalize, but it kind of seems like top-posters 
are fairly tolerant of bottom-posters, but the opposite seems to be 
less the case.


-Original Message-
From: Alain Williams <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Fri, 30 Dec 2005 18:51:13 +
Subject: Re: [users] Top Posting especially/elaine

 People who thoughtlessly top post are either lazy, ill
informed
or think that their time is more valuable than that of many others.

--
Alain Williams
Parliament Hill Computers Ltd.
Linux Consultant - Mail systems, Web sites, Networking, Programmer, IT 
Lecturer.

+44 (0) 787 668 0256  http://www.phcomp.co.uk/

#include 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


  


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]