[users] Re: Where Do Base Reports Store The Desired Query?

2012-02-08 Thread Michael Reich
Girvin, thank you very much.   I never noticed that the query (field = 
xxx) was buried in that Content statement.   I made the change and it 
worked as expected in the report.   I am going to make sure I save your 
response for future reference.


On 2/7/12 6:36 AM, users-requ...@openoffice.org wrote:

Subject:
[users] Re: Where Do Base Reports Store The Desired Query?
From:
Girvin R. Herr girvin.h...@sbcglobal.net
Date:
2/6/12 6:30 PM

To:
users@openoffice.org




Michael Reich wrote:
I've been using a Base database for my stamp collection and each 
year, I copy the previous year's report structure to a new object for 
the current year.  At the same time, I copy/edit the previous year's 
Query to a current year query, and edit it to reflect selection of 
the current year () for the query.   The query then selects the 
right records.


However, each year I struggle with updating the report format so it 
knows to use the most current query to produce the report.   I have 
no idea how I managed to edit the previous report structures to do 
what I want, but I did.   Unfortunately, I'm stuck this year and 
can't get the report for 2012 to show the 2012 records (it shows the 
2011 records, because the 2012 query was a copy of the 2011 query).


I don't know why OO has to be as obtuse as it is in making such a 
basic edit in a report definition, but I can't find it.   How do you 
edit a report to change the query it should use (where is this 
setting hidden)?  Can someone point me in the right direction to make 
this edit? Thanks for any help!



Michael,
I have not had to do this yet, so this procedure is not proven and 
others in this group may add or subtract from it.  It does work when I 
copy a report or form and have to point the new report or form to 
another, identical structure, database.

Here is what I discovered:
Right click on the report name in the main window.  Chose edit.
When the report editing window comes up, left click somewhere in the 
center window, not on an object, just the background will do.
In the right pane, you should see tabs with General and Data 
names.  Click on Data.

Edit the Content field to your new query name.
That should do it, after you save the report.  Don't forget to click 
on the save icon in the main window also.  Both saves must be done to 
properly save the changes.


Note: this process should also work for forms, although I had to right 
click on an object in the form, not the background, in order to get 
the Data tab.  You must make sure the Data is for the entire 
report/form, not just the field.

HTH
Girvin Herr

--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] Where Do Base Reports Store The Desired Query?

2012-02-06 Thread Michael Reich
I've been using a Base database for my stamp collection and each year, I 
copy the previous year's report structure to a new object for the 
current year.  At the same time, I copy/edit the previous year's Query 
to a current year query, and edit it to reflect selection of the current 
year () for the query.   The query then selects the right records.


However, each year I struggle with updating the report format so it 
knows to use the most current query to produce the report.   I have no 
idea how I managed to edit the previous report structures to do what I 
want, but I did.   Unfortunately, I'm stuck this year and can't get the 
report for 2012 to show the 2012 records (it shows the 2011 records, 
because the 2012 query was a copy of the 2011 query).


I don't know why OO has to be as obtuse as it is in making such a basic 
edit in a report definition, but I can't find it.   How do you edit a 
report to change the query it should use (where is this setting hidden)? 
 Can someone point me in the right direction to make this edit? 
Thanks for any help!



--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] Re: Hyperlinks in docs

2011-08-18 Thread Michael Reich
On my Mac, I've found that I usually have to select the link text 
first (just left-click on it) and then Command-click to actually jump to 
the link.  


On 8/18/11 users-requ...@openoffice.org wrote:

 Subject:
 [users] Re: Hyperlinks in docs
 From:
 Guy Voets nimant...@gmail.com
 Date:
 Tue, 16 Aug 2011 10:46:42 +0200
 To:
 users@openoffice.org

 2011/8/15 Robert Peirce b...@peirce-family.com:
   Since my version of Word won't work in Apple OS 10.7, I am
 converting my
   doc files to odt.  I opened a file that has hyper-links and it
 said to
   command click the link, which I did, but it didn't take me there.
 Does
   something need to be changed to get these to work in OpenOffice? 
 I am

   running 3.3.0.
  

 Hello Robert,

 Yes, to activate a hyperlink on Macs, you use Command-click (next to
 space bar) in LibO and OOo.
 It works for me...
 Maybe take a look at menu EditHyperlink?



--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] Re: cancellation

2011-04-26 Thread Michael Reich

It's mind-boggling that people would pay $47 for free software for which
the vendor (http://www-openoffice.com/index.php) includes support that
consists of the ability to send them an email, Obtaining Help from the
Help Files Included with your Programs, and instructions on how to
print the help files.  But hey, the $47 is reduced for a limited time
from $59...


mike hopper wrote:
recently purchased your system but now realise that it does not fit 
my requirements, could you please let me know how to cancel and get 
credit.

CB-openoffice-1
ClickBank order number HJMM276D
thanks,
M.Hopper
 Perhaps this link may help: 
http://www.clickbank.com/refund_policy_faq.html.
This organization is NOT ASSOCIATED with www.openoffice.org. They have 
taken a product that can be downloaded for no cost, and they have 
decided to charge people to obtain it from them. While this is legal 
according to the license of the openoffice.org office suite, one 
questions the morality of the company that does so.


Dan 



--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] Re: cancellation

2011-04-26 Thread Michael Reich
It's mind-boggling that people would pay $47 for free software for which 
the vendor (http://www-openoffice.com/index.php) includes support that 
consists of the ability to send them an email, Obtaining Help from the 
Help Files Included with your Programs, and instructions on how to 
print the help files.  But hey, the $47 is reduced for a limited time 
from $59...



mike hopper wrote:
recently purchased your system but now realise that it does not fit 
my requirements, could you please let me know how to cancel and get 
credit.

CB-openoffice-1
ClickBank order number HJMM276D
thanks,
M.Hopper
 Perhaps this link may help: 
http://www.clickbank.com/refund_policy_faq.html.
This organization is NOT ASSOCIATED with www.openoffice.org. They have 
taken a product that can be downloaded for no cost, and they have 
decided to charge people to obtain it from them. While this is legal 
according to the license of the openoffice.org office suite, one 
questions the morality of the company that does so.


Dan 


--
-
To unsubscribe send email to users-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help


[users] New Mail List Software

2011-03-02 Thread Michael Reich
I presume the new software is also responsible for no longer displaying 
the digest version by thread?  It's ugly and difficult to read non-threaded.


--

To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: sy...@openoffice.org with Subject: help


[users] Re: Preload OOo on Mac

2010-01-25 Thread Michael Reich


On 1/25/10 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] Re: Preload OOo on Mac
From:
James Wilde james.wi...@sunde-wilde.com
Date:
Mon, 25 Jan 2010 09:45:39 +0100

To:
users@openoffice.org


On Jan 25, 2010, at 00:52 , Michael Reich wrote:

  
 
 On 1/24/10 users-digest-h...@openoffice.org wrote:
 You don't say what version of OSX you have or what type of Mac.On my MacBook running Snow Leopard (10.6.2) it doesn't take forever to start OOO or NeoOffice.   Provide a little info on your setup so someone can guess what the problem is, as well as where your applications are stored.  



Serious miss, Michael.  It's a MacBook Pro running Snow Leopard, 10.6.2 and as 
you probably guessed, it was a little frustration in excess of what the 
situation called for that prompted my original mail, so I apologise to the 
list.  If it hadn't been frustration, I would have remembered such obvious 
details.

  
 If you are running Tiger, Leopard, or Snow Leopard, you can add programs to the list of apps that run at startup (click the apple in the upper left corner, System Preferences, Accounts, and then select the Login items pane on the right.  You can add programs to the list by clicking the + sign.  



Thanks for this.  I really needed to know that.  I had been shown this by my 
son (who gave me his pensioned Mac) but had forgotten how to find it.

//J
No problem.   If you're a newcomer to Macs, the learning curve doesn't 
last too long.   I switched from Windows just a couple years ago, and 
now have a Mac and Ubuntu machines at home (with one tired old Windows 
2K machine for desperate times).




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: Preload OOo on Mac

2010-01-24 Thread Michael Reich


On 1/24/10 users-digest-h...@openoffice.org wrote:

Subject:
Preload OOo on Mac
From:
James Wilde james.wi...@sunde-wilde.com
Date:
Sun, 24 Jan 2010 12:36:18 +0100

To:
users@openoffice.org


Hi:

I feel incredibly stupid.  The first time I start OOo after a reboot it takes 
forever but I seem to remember that one can preload the basic functionality 
which means that, subsequently documents open quicker.  I've been looking 
around on my Mac and I just can't find where the programs are stored - I'm too 
new to the Mac - and come to think of it, I'm not sure I know how to place the 
appropriate program in some kind of startup folder.

If some kind Mac user can help me with these two points I'll be very grateful.

TIA

//James
You don't say what version of OSX you have or what type of Mac.On my 
MacBook running Snow Leopard (10.6.2) it doesn't take forever to start 
OOO or NeoOffice.   Provide a little info on your setup so someone can 
guess what the problem is, as well as where your applications are stored.  

If you are running Tiger, Leopard, or Snow Leopard, you can add programs 
to the list of apps that run at startup (click the apple in the upper 
left corner, System Preferences, Accounts, and then select the Login 
items pane on the right.  You can add programs to the list by clicking 
the + sign.  




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: users Digest 17 Dec 2009 14:58:35 -0000 Issue 7279

2009-12-17 Thread Michael Reich
You can certainly use regular expression to search for hard returns as 
Harold pointed out (\n).   In replace, you could insert a space or leave 
it blank.   Any word processor would then wrap the paragraph.  Would 
this give you what you want?


On 12/17/09 users-digest-h...@openoffice.org wrote:

Subject:
Change paragraph returns to soft returns
From:
Dotan Cohen dotanco...@gmail.com
Date:
Wed, 16 Dec 2009 09:24:07 +0200

To:
openoffice-users. users@openoffice.org


How can one change all the paragraph returns to soft returns
(shirt-return) in a selection? I know that I need to use a regular
expression, but I don't know the symbols for paragraph return and soft
return.

Thanks in advance.

-- Dotan Cohen http://what-is-what.com http://gibberish.co.il



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



Re: [users] my problem

2009-12-17 Thread Michael Reich
Penny, you simply need to locate the downloaded file on your Mac 
(possibly on the desktop) and right click on the file (CTRL-click with 
one button mouse).Then select Move to Trash from the menu that 
appears.


On 12/17/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] my problem
From:
Penny Larish penn...@mts.net
Date:
Wed, 16 Dec 2009 21:35:17 -0600

To:
OpenOffice users@openoffice.org


Thank you so much for your assistance.  I will try the download again 
since I am afraid to use it when I get that warning.
You are correct that I didn't have a chance to open it before the 
battery went dead.  Lesson learned for next time.
At the risk of proving how incompetent I am can you tell me how to 
delete the previous download ?


Penny



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Trolls

2009-12-08 Thread Michael Reich


On 12/8/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: Fw: [users] Labels
From:
James Knott james.kn...@rogers.com
Date:
Tue, 08 Dec 2009 10:51:34 -0500

To:
users@openoffice.org


Barbara Duprey wrote:

Joseph A Nagy Jr wrote:

michael considine wrote:

Usubscribe me turkey or I will keep on sending them back to you


You idiot, you have to unsubscribe yourself, just like you were 
subscribed.


This is almost certainly a troll. He's been given very explicit 
directions on how to unsubscribe, multiple times, including at least 
one offer of off-list help, but he prefers to stay subscribed and 
keep bombing the list.
I solve problems like him by adding his email address to a mail filter 
that sends him to my junk mail folder, which gets flushed occacionally.

Problem with the digest version, can't filter him out.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: users Digest 5 Nov 2009 20:03:27 -0000 Issue 7229

2009-11-05 Thread Michael Reich

John:

I'm not following your question completely, but when I insert graphics 
into documents using Writer, right clicking on the image and selecting 
Anchor gives me four choices: To Page, To Paragraph, To Character, and 
As Character.   Nothing shows to anchor To Frame.   I think the 
question is to what frame is the documentation referring?


Only after adding a caption (and after Writer creates the outer frame 
to hold the caption), does To Frame appear.   It seems to be referring 
to anchoring the image frame to the outer frame which holds the image 
and caption.  If you select the outer frame and right click, the To 
Frame option is not present.  That makes some sense because you can't 
anchor something that doesn't exist at that level (if frames within 
frames can be considered to have different levels).  The inner 
frame, the graphic, can't be anchored to a Frame if the outer frame 
doesn't exist.  If the outer frame does exist because you inserted a 
caption, then you see the option.


If some of your images have captions and others do not, that would 
explain the difference you're seeing.   Writer's use of the outer 
frame is not very intuitive and if you're not careful, you can easily 
select the image frame when you think you're selecting the outer frame 
(with caption and image).  In fact, it took me a long while to even 
realize that there was a second frame involved when adding captions.


HTH.

-Michael

Subject:
[users] Pictures inside frames - Anchor To Frame
From:
John Kaufmann kaufm...@nb.net
Date:
Thu, 05 Nov 2009 14:26:58 -0500

To:
users@openoffice.org


I tried this question six weeks ago and got no answer, but with the 
indulgence of the list I'd like to try it again, in the hope that 
someone might have a new thought about it:


According to the OO documentation (Working with Graphics), any 
picture inside a frame should have To Frame among its Anchor 
options.  In a document I wrote are ~30 pictures inside frames - but 
only half of them have the Anchor.. To Frame option.  After much 
study, I'm still unable to see the difference between those that have 
and those that do not have the option.  Even pictures side by side can 
be different.  Can anyone tell me what to look for to normalize this?


And - bonus question - since Writer believes that a picture with 
caption is lost without a frame (and thus supplies one automatically), 
why would the picture ever *not* be anchored to the frame?


John 



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: header and footers

2009-10-19 Thread Michael Reich

Jurgen:

You'll need to create two page styles: one for the first 3 pages without 
header/footer and page number, and one beginning with page four which 
has the desired header/footer and page numbering.  It's not very 
intuitive, but once you get the hang of it, it works pretty well.   
Create the styles first (use the Help function) and then apply them to 
the desired pages.


Look at the list archives; there are some detailed explanations of using 
styles for this purpose in the past 6 months or so.  HTH.


-Michael

On 10/19/09 users-digest-h...@openoffice.org wrote:

Subject:
header and footers
From:
Jurgen Heerink jurgen_heer...@hotmail.com
Date:
Mon, 19 Oct 2009 07:25:53 +

To:
users@openoffice.org


Hi,

 


Could someone pls help with with the following problem.

I am creating a report but I don't want to have a header and footer on the 
first 3 pages.

So from the 4th till the last, as well as the page numbering.

 


Thanks in advance,

 

 


Jurgen



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: header and footers

2009-10-19 Thread Michael Reich
Brian Barker posted some pretty detailed instructions on creating page 
styles to do what you need on July 11 (msg. 199958).



On 10/19/09 users-digest-h...@openoffice.org wrote:

Subject:
header and footers
From:
Jurgen Heerink jurgen_heer...@hotmail.com
Date:
Mon, 19 Oct 2009 07:25:53 +

To:
users@openoffice.org


Hi,

 


Could someone pls help with with the following problem.

I am creating a report but I don't want to have a header and footer on the 
first 3 pages.

So from the 4th till the last, as well as the page numbering.

 


Thanks in advance,

 

 


Jurgen



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Subject: Re: [users] Goodbye, OpenOffice.Org. I'm going back to MS Office

2009-10-01 Thread Michael Reich


On 10/1/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] Goodbye, OpenOffice.Org. I'm going back to MS Office
From:
Johnny Rosenberg gurus.knu...@gmail.com
Date:
Thu, 1 Oct 2009 22:16:40 +0200

To:
users@openoffice.org, fmil...@lightlink.com


2009/10/1 Fred A. Miller fmil...@lightlink.com:
  

 Goodbye, OpenOffice.Org. I'm going back to MS Office
 
http://ct.zdnet.com/clicks?t=440183855-f09aff1f3240c763b781087d83996fa3-bfbrand=ZDNETs=5

 For the last three years, I've been using a version of OpenOffice.org on
 all of my systems. I'm sad to say that I'm going to move back to Office
 2007 on Windows XP and Office 2008 on Mac OS X this week.



Well, everyone can do whatever they like, so do whatever you think is
best for you. I don't really see the point in writing about it; just
do it. ON the other hand I don't see the point in my post either…

J.R.
  
That was my reaction as well (why write about it). I suppose it's 
related to him being a big mucky-muck member of the senior management 
team. His observation at the end struck me as really meaningless: 
Microsoft’s Office seems to work with just about everyone’s system (if 
I stick to Office 2003 formatted documents). So, I’m going to install it 
on my systems albeit reluctantly. It seems to work on everyone's system 
that has MS Office _installed_... duh.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: users Digest 18 Sep 2009 01:14:17 -0000 Issue 7180

2009-09-17 Thread Michael Reich
Glad to be of assistance.   Installation was confusing to me when I 
migrated from Windows to OS X; I was used to much more complicated 
installation, so just dragging an application to the Application folder 
seemed way too simple.


I forgot to also suggest that after you're done with the installation, 
you can Eject the mounted image file and delete the dmg file.


On 9/17/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] Re: can't find the program on my macbook
From:
Eric David erich_da...@verizon.net
Date:
Thu, 17 Sep 2009 11:19:41 -0700

To:
users@openoffice.org


Michael: Many thanks for your clear reply. i followe the instructions 
and am all set up.


Eric David

Michael Reich wrote:
After downloading software, you need to install it before it can be 
used.   You should download software to a particular location, like 
your desktop or your Documents folder, so you can easily locate them.  
It sounds like you downloaded the installer, but didn't actually 
install the program.  If so, use the spotlight feature (the blue 
magnifying glass icon in the upper right corner of your desktop) to 
search for something like OOo_3.1.1_MacOSXIntel_install_en-US.dmg (see 
below).


When you download the OOO package from the web on a Mac, you should 
have an installation program which ends with a .dmg extension 
(OOo_3.1.1_MacOSXIntel_install_en-US.dmg).   Double-click this file 
and it will mount as a disk image on the Mac desktop.  It also 
should automatically open a window which displays an OpenOffice.org 
icon and another icon for your Applications folder.   Simply drag the 
OpenOffice.org icon and drop it on the Applications icon.   The 
software will then install in your Applications folder.   This is the 
standard way programs are installed in OS X.


After installation, you can launch OpenOffice by navigating to your 
Applications folder and double clicking the OpenOffice icon.


If you need more assistance, let us know.

I am new to Open Office and to macbook.  I downloaded Open Office 
yesterday.  When I went to use it today, I could not find it.


What did I do wrong?

user ID: nwkrug




[users] Re: can't find the program on my macbook

2009-09-16 Thread Michael Reich
After downloading software, you need to install it before it can be 
used.   You should download software to a particular location, like your 
desktop or your Documents folder, so you can easily locate them.  It 
sounds like you downloaded the installer, but didn't actually install 
the program.  If so, use the spotlight feature (the blue magnifying 
glass icon in the upper right corner of your desktop) to search for 
something like OOo_3.1.1_MacOSXIntel_install_en-US.dmg (see below).


When you download the OOO package from the web on a Mac, you should have 
an installation program which ends with a .dmg extension 
(OOo_3.1.1_MacOSXIntel_install_en-US.dmg).   Double-click this file and 
it will mount as a disk image on the Mac desktop.  It also should 
automatically open a window which displays an OpenOffice.org icon and 
another icon for your Applications folder.   Simply drag the 
OpenOffice.org icon and drop it on the Applications icon.   The software 
will then install in your Applications folder.   This is the standard 
way programs are installed in OS X.


After installation, you can launch OpenOffice by navigating to your 
Applications folder and double clicking the OpenOffice icon.


If you need more assistance, let us know.

I am new to Open Office and to macbook.  I downloaded Open Office 
yesterday.  When I went to use it today, I could not find it.


What did I do wrong?

user ID: nwkrug




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: users Digest 22 Aug 2009 12:19:09 -0000 Issue 7139

2009-08-22 Thread Michael Reich


On 8/22/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] Importing to Base - Solved (Mostly)
From:
Brian Barker b.m.bar...@btinternet.com
Date:
Sat, 22 Aug 2009 06:51:43 +0100

To:
users@openoffice.org


At 11:26 20/08/2009 -0500, Michael Reich wrote:
One thing I can't figure out at this point is how to get that new key 
field to auto-increment when adding a new record.   The help files 
talk about selecting an auto increment (or something like that) 
property, but I can't find that anywhere.   Sigh.


o  If you use the wizard to create your table, you will see Auto 
value boxes on the third panel (Set primary key).
o  If you create your table in Design View, any field to which you 
ascribe the Field Type Integer [ INTEGER ] will show AutoValue 
amongst the Field Properties at the bottom of the window.  (Select 
Yes.)
o  For an existing table, select it in the Tables panel and go to Edit 
| Edit... (or right-click | Edit) to reach the same view as above.  
Select the relevant (integer) field to see the AutoValue property.


I trust this helps.

Brian Barker
Thanks Brian.   Problem was I had the key field set to be a numeric, not 
integer.   When I changed it to integer, the property appeared as you 
described.  





Re: [users] Importing to Base - Solved (Mostly)

2009-08-20 Thread Michael Reich


On 8/19/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] Importing to Base
From:
Barbara Duprey b...@onr.com
Date:
Tue, 18 Aug 2009 22:02:55 -0500

To:
users@openoffice.org


Michael Reich wrote:

On 8/18/09 7:12 PM, Andy wrote:

Michael Reich wrote:



On 8/18/09 users-digest-h...@openoffice.org wrote:



This should self-correct once the above is working.


Hope this helps. 
Thanks, Andy, but as I said, I originally had a date field key set 
in the database, but when I deleted the key, I then got a different 
error and even less records pasted (see the second error message).





You mean that you do not have a backup of the database to work from? 
And the data field was the unique field?  I do not know Java but it 
would see that the lack of that field is causing the problem now.


Sorry I can not be of more help, maybe some of the database pros 
will jump in.


I've got the original database in Windows and the exported CSV file 
(which I pulled into Calc).   When I deleted the key in the Base 
file, I also deleted all the records from the Base file.   I did not 
delete the field, just the key.  Then I tried pasting the copied info 
again and got second error message.   It makes no sense to me, so 
maybe someone else will be able to shed some like on it.


Base really always needs some field defined as the primary key, and it 
sounds as if you left the date field but not as the key, so Base 
probably tried to establish an ID auto-increment field, right? Or did 
you do something else about a key? Base is pretty bad about the error 
handling, its messages (as you've found) are usually not particularly 
helpful, but it does seem to be convinced that the existing date field 
is supposed to contain unique values, and does not. Perhaps you'd get 
someplace it you made a copy of your Calc file and sorted on that 
field -- it might show one or more problems. 
Your response was a helpful clue, Barbara.   I went back and found that 
even though I'd deleted the original key, which was a date field, and 
created an additional field as key (just a number), the table still 
thought the original key was in there somewhere.   I created a new table 
and identified the numeric field as the key.  The pasting operation from 
the Calc spreadsheet then mostly worked, although the Java error 
mentioned in my original post still occurred.  That seems to be related 
to a relative handful of records not having field values that the Base 
table was expecting.   I've identified most of them and can work around 
this issue. 

So, it would appear that it's extremely important to create the correct 
key field from the outset in Base.   It does not seem to like having key 
fields altered after the table is created.


One thing I can't figure out at this point is how to get that new key 
field to auto-increment when adding a new record.   The help files talk 
about selecting an auto increment (or something like that) property, 
but I can't find that anywhere.   Sigh.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



Re: [users] Importing to Base

2009-08-18 Thread Michael Reich

On 8/18/09 7:12 PM, Andy wrote:

Michael Reich wrote:



On 8/18/09 users-digest-h...@openoffice.org wrote:



This should self-correct once the above is working.


Hope this helps. 
Thanks, Andy, but as I said, I originally had a date field key set in 
the database, but when I deleted the key, I then got a different 
error and even less records pasted (see the second error message).





You mean that you do not have a backup of the database to work from? 
And the data field was the unique field?  I do not know Java but it 
would see that the lack of that field is causing the problem now.


Sorry I can not be of more help, maybe some of the database pros will 
jump in.


I've got the original database in Windows and the exported CSV file 
(which I pulled into Calc).   When I deleted the key in the Base file, I 
also deleted all the records from the Base file.   I did not delete the 
field, just the key.  Then I tried pasting the copied info again and got 
second error message.   It makes no sense to me, so maybe someone else 
will be able to shed some like on it.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Importing to Base

2009-08-17 Thread Michael Reich
I'm having some trouble importing data into a new Base database.   I've 
had a database in a Windows program for many years and want to move it 
to something I can use on either my Mac (Tiger) or Linux, so Base seems 
like a good choice.   In following the tutorial on the NeoOffice wiki at 
http://neowiki.neooffice.org/index.php/To_Base_and_Back_Again, I did the 
following:


1. exported the data from my Windows application to a csv file
2. opened the csv file using OOO Calc
3. copied the rows from Calc (there are 664 records, or rows)
4. pasted the data into the Base table previously set up

The problem is that during the pasting, I'm getting an error message and 
not all the rows are showing up in the Base file.  The error is about 
Violation of unique constraint SYS_PK_61: duplicate value(s) for 
columns... and is viewable at 
http://s1019.photobucket.com/albums/af313/mareich/computer/?action=viewcurrent=ishot-7.jpg


Each time I try to paste the data, I get a varying number of records in 
the Base file.   One time it will be over 400 rows, another time 580, 
another time less.
I haven't yet slogged through the Base table to identify all the missing 
records, but at first glance they don't seem to be anything 
remarkable.   Some are early in the file, others later.   Also, if I 
copy a single record from the Calc file and try to paste that into the 
Base data, Base acts like it's working but nothing is pasted in the Base 
table.  The error seems to refer to duplicate records in a date field, 
but the first record in the Calc sheet has a unique value in that field, 
and it isn't being pasted into Base.  

If I delete the key in the database (to avoid the duplicate value 
error), the paste operation results in a warning message about java (see 
http://i1019.photobucket.com/albums/af313/mareich/computer/ishot-8.jpg).   
In this case, only about 24 records are pasted.


I'm mystified as to what's going on and if anyone can offer sugestions, 
I'd appreciate it.  I'd really like to be able to use Base so I can 
abandon my Windows database.   TIA.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



Re: [users] Editing picture captions

2009-08-16 Thread Michael Reich

John:
I too found pictures and captions in Writer to be somewhat baffling at 
first.   Perhaps my two cents will help.   I am not an OOO expert, and 
some of my references may not use the precisely correct terms, but I've 
learned how to work with pictures and captions. 

After you insert a picture into a Writer document, the image has an 
image frame with the usual corners and anchors.   As soon as you right 
click and add a caption, there is another frame in the mix and that's 
the one that confuses things.  The second frame is larger and includes 
the original frame containing the image.


The first frame with the image, contains the submenu for caption, and 
that submenu has the controls for the caption text and category.  Here's 
when you can select None for category and make the Illustration: 
prefix go away.  Writer defaults to something like Image 1 for the 
caption unless you specify other text. 

If you insert a picture and resize it, OOO behaves pretty nicely and 
allows you to drag the sizing handles or use the Size and Position 
menu to do so.   Once you've added a caption, resizing becomes a lot 
more complicated, because you must make sure you have the proper frame 
selected before resizing.  If you don't, the image is likely to get 
thoroughly distorted.  In fact, it's just easier to size and resize the 
image before setting a caption.  I've found similar complexities with 
moving the graphic after a caption is set.   To move it, you must make 
sure you're selecting the second (larger) frame.  If you don't select 
the second (larger) frame, you will be attempting to move the image 
around inside that larger frame, a largely pointless and frustrating 
activity.  The easiest method I've found is to click below and left of 
the caption (if it's at the bottom of the image) to select the larger 
frame.   This should make the anchor visible somewhere in your text.   
You can then drag that anchor to the desired location.


The second frame, the one with the caption, is visible as the frame 
anchored to the paragraph or character or whatever you chose as the 
anchor.   The first frame with the image, is within that frame.  If you 
want to edit the text of your caption, make sure neither frame is 
selected.   Then just click on the caption text as you would to normally 
select text.   That should put your cursor in the text of the caption 
and allow you to edit the text.


I hope this helps.   As I said, I don't consider myself an expert, but 
these are just some of the techniques I've discovered to make working 
with images and captions a little easier.   Once you get the hang of it, 
OOO Writer works pretty well with images; it does, however, have a 
learning curve.


-Michael

On 8/16/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] Editing picture captions
From:
John Kaufmann kaufm...@nb.net
Date:
Sun, 16 Aug 2009 01:22:51 -0400

To:
users@openoffice.org


In a message dated 2009.08.15 14:20 -0500, Brian Barker wrote:


Ah! Thanks!  Then
  Illustration Number range Illustration: 
becomes, on instantiation,
  Illustration Illustration number: 
That's easy enough to understand.  But what becomes of  range 
Illustration?


As I mentioned before, the whole of Number range Illustration is 
the name of the field.


Sorry I did not pick up on that properly before.  Of course every word 
processor must keep fields to enumerate things like illustrations, but 
I guess I'm so used to the user interface *not* showing the field name 
(that is, simply showing the result for that particular entity in the 
range) that I suffered a little cognitive dissonance at seeing the 
field name (for the entity number) rather than the entity number - 
probably mostly because I don't see any advantage to it, and it 
violates a common programming principle of information hiding (to 
simplify code maintenance).  Now that I finally get your point, I will 
keep that in mind.  Thanks.




I still don't see how to do that - how to select the text to edit.


Providing you don't have the picture selected (or even have the 
picture selected but not its caption), there's no problem, I think.  
Click somewhere else so that you see no green handles.  Then go to 
the caption text.


Here we come to what has taken me so long to reply to your advice:  
Where before I could not select just the picture (without the frame), 
now I can *only* select the picture, and cannot see how to select the 
frame.  Of course that takes care of my initial problem: I can now 
edit the caption. [And, BTW, with whatever changed, I now have 
essentially the Optimal Wrap (figure to right; text wrapping to the 
left of the figure) that I was seeking before - and I have no idea how 
that changed either. (I say essentially in the last sentence because 
the text spacing is not working, and because specifying non-zero 
spacing has no effect on the text spacing, but splits the caption 
between top and bottom - totally weird.)]


However, it's so 

[users] Re: Subject:,Problem with Word documents

2009-08-16 Thread Michael Reich


On 8/16/09 users-digest-h...@openoffice.org wrote:

Subject:
Problem with Word documents
From:
Neil Armstrong neila...@armstrong63.freeserve.co.uk
Date:
Fri, 14 Aug 2009 10:41:54 +0100

To:
users@openoffice.org


I was recommended to download Open Office as I needed to send Word documents as 
part of my exam work this year.  I had Word Viewer on my Dell computer but had 
been managing with Microsoft Works for word processing up to that point.  
However, things did not work out as anticipated! When I clicked on the Word 
documents I was sent, they opened via the Word Viewer.  I then copied these 
into Open Office and saved them as Word documents.  I then input my data and 
resaved them.  I then sent these documents to the Exam board but nothing 
arrived.  Whrn I attempted to print out the documents having been told of this 
problem I only got a blank page with the AQA logo.  Can you suggest what has 
happened and if there is a solution to my problem - other than buying Microsoft 
Office?
I am not great with technology, so can't cope with anything too technical!
Many thanks
Ann Armstrong
  
A couple of thoughts:  first, instead of double-clicking on Word 
documents to open, try right-clicking and using Open With.   Then you 
can specify to use OOO to open the documents to begin with, instead of 
fooling around with using the Word Viewer and copying to OOO.   Second, 
when you input your data and resave, use File-Save As rather than 
File-Save and ensure you are selecting the proper format under File 
type (near the bottom of the Save As dialogue).   Select a Word format, 
such as Microsoft Word 97/2000/XP that your correspondents can read.  
The default format for OOO is not a Word .doc format, so you need to 
make sure you're selecting one that will work for you. 

I don't know what the AQA logo means, but perhaps you are saving the 
revised document in the default OOO .odt format and then trying to open 
that in the Word Viewer?




[users] Printing Envelopes

2009-07-22 Thread Michael Reich
I'm havng some difficulty printing envelopes from OOO.   I can set up a 
#10 envelope (as a stand-alone document) with a text box for the 
addressee, and I can print the envelope, but for some reason, the 
printer is also printing a very fine line along the bottom edge of the 
envelope.  I can't figure out why this line is being printed or how to 
stop it.  The line is not printed on the section of the envelope where 
the addressee information is printed.


I'm using Ubuntu 8.04, OOO 2.4, and an HP All in One 6110 printer.  The 
line is a relatively minor issue, but it's annoying that I can't get rid 
of it.  Any suggestions will be appreciated.



--
-
My memory's not as sharp as it used to be.
Also, my memory's not as sharp as it used to be.
-
Michael Reich
Glendale Heights, IL 60139
blog: www.mike-reich.blogspot.com
-

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



Re: [users] Printing Envelopes

2009-07-22 Thread Michael Reich


On 7/22/09 9:02 PM, James Knott wrote:

Michael Reich wrote:
  

I'm havng some difficulty printing envelopes from OOO.   I can set up
a #10 envelope (as a stand-alone document) with a text box for the
addressee, and I can print the envelope, but for some reason, the
printer is also printing a very fine line along the bottom edge of the
envelope.  I can't figure out why this line is being printed or how to
stop it.  The line is not printed on the section of the envelope where
the addressee information is printed.

I'm using Ubuntu 8.04, OOO 2.4, and an HP All in One 6110 printer. 
The line is a relatively minor issue, but it's annoying that I can't

get rid of it.  Any suggestions will be appreciated.



This could be a mechanical issue with your printer.  Try printing your
envelope on a plain piece of paper.  If the line is not there, then it's
a printer problem with handling thick items.

  
I printed my envelope file on plain paper on the HP6110 and still get 
the line across the bottom.  I also printed it on plain paper on my 
Brother laser printer and there's no line, so it would appear to be some 
weird thing about the HP.  I believe the Ubuntu computer is using a 
Foomatic driver for the HP6110.  I'm beginning to think it's not the 
file or OpenOffice that's causing the problem, but something about 
either the printer or the driver.  I'll live with it. 

And in case you're wondering, most of the envelope printing I do is with 
printed stationery with a color logo, and Brother laser printer is 
apparently too hot and pulls the color logo off and prints it a few 
times down the paper (or envelope).  So I have to use the inkjet with 
the stationery... :-(


Thanks for your help.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



Re: [users] Writer - starting page numbers on second page

2009-07-13 Thread Michael Reich


On 7/13/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] Writer - starting page numbers on second page
From:
Brian Barker b.m.bar...@btinternet.com
Date:
Sun, 12 Jul 2009 23:48:41 +0100

To:
users@openoffice.org


At 16:17 12/07/2009 -0500, Michael Reich wrote:
I appreciate the short-cut to get page numbers to begin on the 
second page.  However, there's still an issue with a table of 
contents, because even with the -1 offset, the TOC is showing items 
as being on the physical page number, rather than what's showing in 
the header.


For example, if the first two pages consist of a table of contents, I 
can create a style for those pages without page numbering.   I can 
set physical page three to begin another page style (eg, Main 
Style) and include page numbering with an offset of -2 so physical 
page 3 displays Page 1.   However, the TOC still shows that the 
material on Main Style begins on page 3, not page 1.Is there a 
way to set a table of contents to obey the page numbering?


Yes.  In this situation, the break between the front matter and the 
main, page-numbered part with be at a defined point.  Don't use the 
Offset in the Edit Fields window.  Instead, at the end of the front 
matter, go to Insert | Manual Break..., select Page break, select 
the page style for the main part from the drop-down list under Style, 
tick Change page number, and set the first page number below to 
1.  Update the table of contents.


I trust this helps.

Brian Barker 
Yes, Brian, that addresses the problem for me.   Thanks, this has been 
something that's frustrated me for a long time and it's really a simple 
solution.   Just have to remember to insert that manual break when 
moving to the new style (page).   I think this is also how M$ Word used 
to work with sections, but it's been a very long time since I've 
actually used Word.  Thanks again.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



Re: [users] Writer - starting page numbers on second page

2009-07-12 Thread Michael Reich


On 7/12/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] Writer - starting page numbers on second page
From:
Brian Barker b.m.bar...@btinternet.com
Date:
Sat, 11 Jul 2009 16:31:42 +0100

To:
users@openoffice.org


At 15:03 11/07/2009 +0100, Gordon Burgess-Parker wrote:

OO 3.0.1 - is there now an EASY way of doing this?


Automatic page numbers need to be in headers or footers: that's how 
they work.  Headers and footers are properties of page styles.  So to 
get page numbers on some pages but not others you generally need 
different page styles for the different page ranges.  I sent you 
(privately) an easy way to do this four days ago - well, I consider it 
easy, but ease is in the eye of the user, of course.  Here it is again.


o  Click the Styles and Formatting button in the Formatting toolbar or 
press F11.
o  Click the Page Styles button at the top of the Styles and 
Formatting window.

o  Put the cursor into the first page of your text.
o  Double-click First Page in the list of page styles.  This sets your 
first page to have the First Page page style; subsequent pages 
automatically keep Default page style.
o  If preferred (for neatness), set an empty header or footer on the 
first page.


If you want the page numbers to start at 1 on page 2 (as you did 
before):
o  Double-click just to the left of the page number on the second page 
- currently 2 (or any subsequent page, in fact).

o  In the Edit Fields panel, change the Offset value to -1.

Actually, I've just spotted an easier way (but only if you want page 2 
to be labelled 1).  Forget the page styles.  Just make the change 
described in the last two lines above.  Instead of displaying 0 for 
the page number of the first page (as you might expect), the field 
appears empty - which is exactly what you need.


I trust this helps (further?).

Brian Barker 
I appreciate the short-cut to get page numbers to begin on the second 
page.  However, there's still an issue with a table of contents, because 
even with the -1 offset, the TOC is showing items as being on the 
physical page number, rather than what's showing in the header. 

For example, if the first two pages consist of a table of contents, I 
can create a style for those pages without page numbering.   I can set 
physical page three to begin another page style (eg, Main Style) and 
include page numbering with an offset of -2 so physical page 3 displays 
Page 1.   However, the TOC still shows that the material on Main 
Style begins on page 3, not page 1.Is there a way to set a table of 
contents to obey the page numbering?



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Subject:,Re: [users] Assign Title Case to Format - Change Case menu

2009-04-29 Thread Michael Reich


On 4/29/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] Assign Title Case to Format - Change Case menu
From:
TomW tomw...@ctel.net
Date:
Tue, 28 Apr 2009 18:29:40 -0400

To:
users@openoffice.org


Sean Carlos wrote:

Hello List,

OpenOffice has a nice title case function, but it is hidden... in OO 
3.1, I find it under


Format - Character - Font Effects - Effects - Title

rather than

Format - Change Case - (Title)

Has anyone added this title / proper function to the Format - Change 
Case menu?  A quick search leads me to the idea that it is going to 
entail a macro... working code / instructions would be appreciated.


Thank you and best regards,

Sean

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org


Sean:

In the 'Character section of Styles   Formatting, just create a 
style using 'Title Case, then assign a shortcut to it.  No macro 
necessary.  When you create a style, you can create a shortcut to it 
by drilling down to it by 'Customize | Function Section | Category 
List | Styles.  Once here find your named style and assign a shortcut 
key combination.  You can undo it by using the 'default formating' 
shortcut Ctrl M'


TomW 


Thanks to both of you for this info.   I couldn't figure out how to find 
this function until Sean pointed out the obscure place it's located.  

And thanks Tom for the work-around using the Styles menu.   It's not as 
smooth as putting the feature where it belongs (Format - Change Case - 
(Title) ), but it beats not being able to find it at all.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: Subject:,Re: [users] openoffice 2.4.0 (Mac) AND new issue

2009-03-01 Thread Michael Reich

Mike:
I've been using NeoOffice for several years on my MacBook with Tiger 
without problems.  I still have some of the earlier releases (2.2.3 and 
2.2.4).  If you want one, email me off list and we'll figure out how to 
get it to you.  I could probably send the dmg via Yousendit.com.


On 2/28/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: [users] openoffice 2.4.0 (Mac) AND new issue
From:
Mike Dawe ooo-u...@zacglen.com
Date:
Sat, 28 Feb 2009 22:01:21 +1100

To:
users@openoffice.org


Joe wrote:
  

 Mike,
 Thanks again for your help. We are getting further along with NeoOffice.
 Thanks for all of your advice.



Hi Joe. I do hope its working for your friend. Because it isn't working
for me  :-( 


I DL'd and installed NeoOffice 2.2.5 and installed it onto a Mac running
Panther to try it out. Everything seems to work and it looks really nice
BUT - If I type any text into Writer, the space bar doesn't work!
SentencesthatItypestarttolooklikethis - fubar! I updated it with the
latest patch and there was no improvement  :-( 


I've been trying to locate an earlier version but so far cannot locate a
repository of older versions for NeoOffice. Anyway, I hope you friend
hasn't struck the same problem as I have.

Regards

-- Mike Dawe OOo 3.0.1rc2 MacOSX PPC US English



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: Downloaded OO, want to use on a Mac...

2009-01-24 Thread Michael Reich
Josie, have you installed OOO on your Mac or just downloaded it?  It 
would help if you were more specific about what you need.  OOO handles 
Word .doc files and Excel .xls files very smoothly. 


On 1/24/09 users-digest-h...@openoffice.org wrote:

Subject:
Downloaded OO, want to use on a Mac...
From:
Josie Estill josieest...@mac.com
Date:
Mon, 19 Jan 2009 19:37:09 -0500

To:
users@openoffice.org


 but I can't see how to find out how to actually do anything.

My goal is to use Open Office so I can communicate better with the PC 
world.  I'm on a non-profit Board and have to use, forward, amend many 
documents that come in Word format.  Ditto for Excel worksheets.  They 
don't seem to transfer well to Apple Numbers.


Where do I go now to find out what to do next...
Thanks,
Josie 



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: installation problem - Mac OS X

2009-01-11 Thread Michael Reich
I stand corrected.  I did not see version that on the official OOO 
download page.


On 1/11/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: installation problem - Mac OS X
From:
Larry Gusaas larry.gus...@gmail.com
Date:
Sat, 10 Jan 2009 11:54:10 -0600

To:
users@openoffice.org
CC:
art...@rockisland.com


On 2009/01/10 8:34 AM  Michael Reich wrote:
What kind of Mac do you have?  I don't believe OOO ver. 3 runs on 
PowerPC Macs, only Intel.  You can download ver. 2+ if you're using a 
PPC.  http://download.openoffice.org/2.4.2/other.html#en-US

OO.o 3.0 for PowerPC Macs is available from good-day.
http://ooopackages.good-day.net/pub/OpenOffice.org/MacOSX/3.0.0rc4/

--

Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
An artist is never ahead of his time but most people are far behind 
theirs. - Edgard Varese 



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: installation problem - Mac OS X

2009-01-10 Thread Michael Reich
What kind of Mac do you have?  I don't believe OOO ver. 3 runs on 
PowerPC Macs, only Intel.  You can download ver. 2+ if you're using a 
PPC.  http://download.openoffice.org/2.4.2/other.html#en-US


On 1/10/09 users-digest-h...@openoffice.org wrote:

Subject:
installation problem - Mac OS X
From:
Arteen Wood art...@rockisland.com
Date:
Wed, 7 Jan 2009 14:35:35 -0800

To:
users@openoffice.org


Hello,

I'm attempting to intall Open Office on a Mac using OS 10.4.11.

I've followed the instructions and done the following:
- installed X11
- dragged the icon to the Applicaitons folder

when I double-click on the OOO icon it says You cannot open the 
application OpenOffice.org because it is not supported on this system.


I've searched the FAQs and cannot find any help.

If you are unable to help me, I'll have to give up and forget about 
using this software.


Thank you. 



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: OO 3 crashes and can't be killed

2009-01-02 Thread Michael Reich
And my post was in response to the OP who was having issues with OOO3 on 
OSX.  I have no idea how many folks are finding the Mac version a 
problem or not.   I only know of those who post here, and most of the 
Mac-related posts have not been positive.


On 1/2/09 users-digest-h...@openoffice.org wrote:

Subject:
Re: OO 3 crashes and can't be killed
From:
Larry Gusaas larry.gus...@gmail.com
Date:
Wed, 31 Dec 2008 22:58:10 -0600

To:
users@openoffice.org


On 2008/12/31 10:20 PM  Michael Reich wrote:
I guess I'm not all that concerned about who's giving what to whom.  
I find NeoOffice to be very stable and integrated in the OSX 
environment and OOO (pre-version 3) required use of the klunky X11 
system.  


I tried out NeoOffice and much preferred OO.o 3.  I still find it 
reprehensible for them to build on top of OO.o  code and not allow 
their code to be used by OO.o.


I tried OOO ver. 3 and found it buggy, prone to crashes, and worse, 
unkillable crashes.  I also didn't find the differences between ver. 
2 and ver. 3 on the Mac version to be all that compelling.  That's 
why I'm not going to wrestle with OOO3.  As stated earlier, I have 
neither the time or energy to wrestle with the flaws in the Mac 
OOO3.  Needing to use a variety of ways to kill a program/process 
smacks of Microsoft, not GNU and open source.


As I said before, I have had none of your problems. Neither have a 
huge number of other users. Did you try using a new profile? Profile 
corruption, especially if using one from an older version of OO.o.



As usual, your mileage may vary.


True. And that is why I am pointing out that for the vast majority of 
users, OO.o 3 is working well.





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: OO 3 crashes and can't be killed

2008-12-31 Thread Michael Reich
I guess I'm not all that concerned about who's giving what to whom.  I 
find NeoOffice to be very stable and integrated in the OSX environment 
and OOO (pre-version 3) required use of the klunky X11 system.  I tried 
OOO ver. 3 and found it buggy, prone to crashes, and worse, unkillable 
crashes.  I also didn't find the differences between ver. 2 and ver. 3 
on the Mac version to be all that compelling.  That's why I'm not going 
to wrestle with OOO3.  As stated earlier, I have neither the time or 
energy to wrestle with the flaws in the Mac OOO3.  Needing to use a 
variety of ways to kill a program/process smacks of Microsoft, not GNU 
and open source.


As usual, your mileage may vary.

On 12/31/08 users-digest-h...@openoffice.org wrote:

Subject:
Re: users Digest 30 Dec 2008 14:03:55 - Issue 6884
From:
Larry Gusaas larry.gus...@gmail.com
Date:
Wed, 31 Dec 2008 02:12:45 -0600

To:
users@openoffice.org


On 2008/12/31 12:35 AM  Michael Reich wrote:

Bob:
We had a discussion of OSX issues with Ver. 3 in early December, 
including the freezing and inability to force close.  OOO
Ver.3 for the Mac does not appear to be completely ready for 
primetime yet.  I'm sticking with NeoOffice


I've had very few problems using OO.o 3, very few crashes and always 
able to force quit if necessary (very rare occurrence). I also used 
the development version for several months before the final release 
and found it very reliable. It is definitely ready for prime time.


As for NeoOffice, they take the code from OO.o, modify it and release 
it using a different license that prevents OO.o using any of their 
code. They contribute nothing back to the OO.o project or to its 
future development. They only take and give nothing back.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: users Digest 30 Dec 2008 14:03:55 -0000 Issue 6884

2008-12-30 Thread Michael Reich

Bob:
We had a discussion of OSX issues with Ver. 3 in early December, 
including the freezing and inability to force close.  OOO
Ver.3 for the Mac does not appear to be completely ready for primetime 
yet.  I'm sticking with NeoOffice (a free implementation of OOO for OSX) 
which hasn't yet made the jump to Ver. 3.


See
http://www.openoffice.org/servlets/BrowseList?list=usersby=threadfrom=2161847

-Michael


On 12/30/08 users-digest-h...@openoffice.org wrote:

Subject:
OO 3 crashes and can't be killed
From:
Robert Peirce b...@peirce-family.com
Date:
Mon, 29 Dec 2008 12:18:16 -0500

To:
users@openoffice.org


I am running OO 3 on a Mac running OS X 10.4.11.  Occasionally the 
program will crash.  I don't like that but I can live with it.  What I 
can't live with is I have to restart the computer to kill the app.  
Force quit has no effect.


Is this the only solution or am I missing something?

  



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: OOo overpowering Mac?

2008-12-15 Thread Michael Reich

Kevin:
We had a discussion of OSX issues with Ver. 3 about a week ago.  OOO 
Ver.3 for the Mac does not appear to be completely ready for primetime 
yet.  I'm sticking with NeoOffice (a free implementation of OOO for OSX).


See 
http://www.openoffice.org/servlets/BrowseList?list=usersby=threadfrom=2161847


-Michael

On 12/15/08 users-digest-h...@openoffice.org wrote:

Subject:
OOo overpowering Mac?
From:
McLauchlan, Kevin kevin.mclauch...@safenet-inc.com
Date:
Mon, 15 Dec 2008 13:38:42 -0500

To:
users@openoffice.org


Hello group.

 


OOo 3 on MacBook Pro with OSX 10.5.5

 


I was given a simple, text-only spreadsheet, generated in MS Excel (2003
or earlier) on Windows XP, and I tried to double-click it to open in OOo
in OSX 10.5.5.

 


The program launched, but did not populate its window, nor present any
error messages.

 


It also appeared to cause some other transient problems with other apps,
so I tried to close it. 

No response. 


I tried Force Quit.  Nope.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org



[users] Re: Problems running 3.0.0 on Mac

2008-12-07 Thread Michael Reich

Dale:
I really don't know what's causing the crash/lockup problem (memory or 
disk activity) with OOO3.  I can say that the frequent program crashes 
come without any warning; that is, OOO seems generally to be doing fine, 
no significant slowdown, followed by a total crash, the OSX message 
about an application crash, and the aforementioned inability to actually 
close soffice.  I often have mulitple programs running, including 
Thunderbird, Firefox, and some of the OSX apps (addressbook, iCal). 

Like I said, I haven't investigated the issue because I'm happy using 
the NeoOffice implementation of the OOO software.  You're right, 
something has clearly gone wrong.  The behavior on the Mac OOO version 
is way too reminicsent of M$ software behavior (locking up, slowing 
down, inexplicable crashes) for me to mess with it. That's one of the 
reasons I switched to a Mac to begin with.  The need to use the power 
button to force a shutdown is especially disturbing.  I highly recommend 
NeoOffice for people using Macs (it's free, donations appreciated) and 
it looks like you'd expect OOO to look and runs without all these issues.


-Michael

On 12/7/08 [EMAIL PROTECTED] wrote:
I'm running OpenOffice 3.0.0 (build 9358) under OS X 10.4.11 on an old 
PowerBook (867 MHz/ 640 MB). Although I find the program sluggish at 
times, I haven't had anything like the problems discussed below. I do 
find it necessary to shut down Oo by hand when shutting down the 
computer.
A minor tune-up (running the daily, weekly, and monthly 
maintenance programs and DiskWarrior) seemed to help quite a bit. I 
also try to keep the number of programs that are active lower when Oo 
is running, and occasionally stop and restart the browser. Safari in 
particular seems to slow down over time, and shutting it down and 
restarting it seems a good idea,
Something has clearly gone wrong, as the machine described below 
has a lot more horsepower than mine.
Is the probram choking on memorym CPU or disk activity? (Have a  
peek with Activity Monitor).

Dale
On Dec 7, 2008, at 1:02, Michael Reich wrote:


I also have encountered similar problems with 3.0 on my MacBook 
running OSX 10.4.11.  I've used NeoOffice for a couple years instead 
of the X11 version of OOO, and I tried OOO Ver.3, but have pretty much 
abandoned it.  I experienced fairly frequent crashes in addition to 
the symptoms you described.  The worst part of the crashes is that OOO 
never completely shuts down, even after attempting to Force Quit using 
Finder.  It still remains in the Dock and the only way I have found to 
get rid of it is to reboot.   Even rebooting is a problem, because 
Finder still can't gracefully shut down soffice.  The only solution 
I've found is to hit the power button force shutdown.
I've never had such severe issues with NeoOffice, so I see no reason 
(nor do I have the time or energy) to struggle with OOO Ver. 3.


On 12/6/08 [EMAIL PROTECTED] wrote:
Subject:
Problems running 3.0.0 on Mac
From:
Maggie Koerth [EMAIL PROTECTED]
Date:
Sat, 6 Dec 2008 13:32:31 -0600

To:
users@openoffice.org


I recently replaced the X11 Mac version with 3.0.0 and it's been 
horrid for

me since day 1. The program operates like molasses half the time, like
delayed typing and having to wait for things to execute for a few seconds
after I make the command. Then there's the freezing. The thing has 
frozen on
me two or three times this month alone. It's really frustrating and I 
don't
know any other Mac users who are having these kind of problems with 
3.0.0.


Has this happened to anyone else? Any suggestions for getting better
performance out of it? Should I uninstall and reinstall?

For the record, I'm using a MacBook 2 Ghz Intel Core 2 Duo with 1 GB 
667 MHz

DDR2 SDRAM and running OSX version 10.4.11.

Any thoughts and help would be appreciated. Particularly if you can 
keep it

dumbed down. You can assume my computer knowledge is only about a step or
two above that of your mom.  :)



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



[users] Re: Subject: Problems running 3.0.0 on Mac

2008-12-06 Thread Michael Reich


I also have encountered similar problems with 3.0 on my MacBook running 
OSX 10.4.11.  I've used NeoOffice for a couple years instead of the X11 
version of OOO, and I tried OOO Ver.3, but have pretty much abandoned 
it.  I experienced fairly frequent crashes in addition to the symptoms 
you described.  The worst part of the crashes is that OOO never 
completely shuts down, even after attempting to Force Quit using 
Finder.  It still remains in the Dock and the only way I have found to 
get rid of it is to reboot.   Even rebooting is a problem, because 
Finder still can't gracefully shut down soffice.  The only solution I've 
found is to hit the power button force shutdown. 

I've never had such severe issues with NeoOffice, so I see no reason 
(nor do I have the time or energy) to struggle with OOO Ver. 3.


On 12/6/08 [EMAIL PROTECTED] wrote:

Subject:
Problems running 3.0.0 on Mac
From:
Maggie Koerth [EMAIL PROTECTED]
Date:
Sat, 6 Dec 2008 13:32:31 -0600

To:
users@openoffice.org


I recently replaced the X11 Mac version with 3.0.0 and it's been horrid for
me since day 1. The program operates like molasses half the time, like
delayed typing and having to wait for things to execute for a few seconds
after I make the command. Then there's the freezing. The thing has frozen on
me two or three times this month alone. It's really frustrating and I don't
know any other Mac users who are having these kind of problems with 3.0.0.

Has this happened to anyone else? Any suggestions for getting better
performance out of it? Should I uninstall and reinstall?

For the record, I'm using a MacBook 2 Ghz Intel Core 2 Duo with 1 GB 667 MHz
DDR2 SDRAM and running OSX version 10.4.11.

Any thoughts and help would be appreciated. Particularly if you can keep it
dumbed down. You can assume my computer knowledge is only about a step or
two above that of your mom.  :) 

  



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



[users] Re: Displaying File Extensions in Windows

2005-04-09 Thread Michael Reich
Joe:
Can't tell if anyone else responded to this, so here goes:


Most recent flavors of Windows do not display extensions ofknown file types 
by default.  Windows suppresses this display unless you turn iton.  To display 
extensions in XP: 1) open Windows explorer to any folder 2) click Tools-Folder 
Options 3) click on the View tab  4) scroll down the Advanced settings list to 
find the entry Hideextensions for known file types and uncheck the checkbox 
for thisentry 5) click Apply and OK.  All file extensions should now display 
inany Explorer window.
At 06:01 AM 4/9/2005, youwrote:Message-ID:[EMAIL PROTECTED]
Date: Fri, 8 Apr 2005 23:31:48 -0700 (PDT)
From: Joe Marks [EMAIL PROTECTED]
To: users@openoffice.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Subject: Re: [users] E-Mail attachments

--- Dan Lewis dldlewisedelewisom wrote:
 On Friday 08 April 2005 02:59 pm, Joe Marks wrote:
  I am using a WindowsXP computer with Firefox and
  Thunderbird I got an E-mail that hasaSNIP
 
 From one source I get Attached .sxw text files that
work fine.  The .sxc spreadsheet attachments comes
from another source (another sender).  In both cases
the extensions show up in the original E-mail itself
When I open the attachments to the E-Mail with the 
.sxw attachemnts, they open fine.  When I open the
attachments to the E-Mail with the .sxc attachments,
the .sxc file extension is gone.  In both cases I used
the same opening procedure.  With this new
information, can anyone say what the problem is?

How do I find the file extension preferences to see
what they are set at?

Joe 

-
Do you Yahoo!?
 Yahoo! Small Business - Try our new resources site! 

[users] Recent Files Macro also works in 1.1.3

2005-03-30 Thread Michael Reich
The macro also works with OOo 1.1.3
At 07:43 AM 3/30/2005, you wrote:
  
   Cheers
   Martin
  
  
  
   http://documentation.openoffice.org/faqs/various_topics/017.html
seems
   clear to me. What is the problem.
  
  
   The problem for me is that on the link you say,
   http ...
...snip...
   terminology as well(the slashes are backward.)
  
   locate  shows me three files ending Common.xcu, two of which
_could_
   be the one required.
  
   But then, I'm just a writer, with a smattering of Linux-knowledge,
and
   other people may know enough to make the right guesses first off.
  
   JimW
  
  
 ...snip...
   Should be the same path no matter what OS.
  
   Can you find it?
  
 
 
  I find two with that same sequence:
 
 
/home/jimw/.openoffice/user/registry/data/org/openoffice/Office/Common.xcu
 
/home/jimw/OpenOffice.org1.1.4/user/registry/data/org/openoffice/Office/Common.xcu
 
  Starting with /user.  of course, one of them is a hidden file
  (/.openoffice) But without knowing that the one I really want is in
the
  OpenOffice file, which the link does not make clear, I was left
confused.
 
  But you have just stated it's the OpenOffice file I want, which starts
  me out right.
 
  Thanks
 

Right. Which is why
 ...snip...
... different sizes of Picklists.
--
PLEASE KEEP MESSAGES ON THE LIST.
Documentation Co-Lead
http://documentation.openoffice.org/
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


Re: [users] Recent Files Macro also works in 1.1.3

2005-03-30 Thread Michael Reich


The macro also works with OOo 1.1.3

At 07:43 AM 3/30/2005, you wrote:


 Cheers
 Martin



 http://documentation.openoffice.org/faqs/various_topics/017.html

 clear to me. What is the problem.


 The problem for me is that on the link you say,
 http ...
...snip...
 terminology as well(the slashes are backward.)
 locate  shows me three files ending Common.xcu, two of 
which  _could_
 be the one required.
 But then, I'm just a writer, with a smattering of
Linux-knowledge, and
 other people may know enough to make the right guesses first off.

 JimW


   ...snip...
 Should be the same path no matter what OS.

 Can you find it?

   
   
I find two with that same sequence:
   

/home/jimw/.openoffice/user/registry/data/org/openoffice/Office/Common.xcu

  
/home/jimw/OpenOffice.org1.1.4/user/registry/data/org/openoffice/Office 
  
/home/jimw/OpenOffice.org1.1.4/user/registry/data/org/openoffice/Office 
/Common.xcu
   
Starting with /user.  of course, one of them is a hidden file
(/.openoffice) But without knowing that the one I really want is in 




__ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

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



Re: [users] word strikethrough

2005-03-20 Thread Michael Reich
Do you mean merely selecting strikethrough as a Font attribute?

1. select text you want to strikethrough
2. click Format-Character
3. select Font Effects Tab
4. open Strikethrough drop-down list
5. select type of strikethrough you want to use (single, double, bold,
with 
X, with /)
6. click OK

At 05:54 PM 3/20/2005, you wrote:
Subject: Re: [users] word strikethrough

Hi Gary
[EMAIL PROTECTED] wrote:

I previously found the way to strikethrough or line through selected
text in a document.
I like to use this to demonstrate text that is being deleted from a
section
of an organization's bylaws.
Could you help me get to that feature again.  The Help feature has not
helped me.




__ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

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



[users] Re: Icons Disappear from Toolbars

2005-03-18 Thread Michael Reich
Thanks for the suggestions, Matt.  I wasn't having a problem seeing the 
Application Data folder, there wasn't an OpenOffice folder within it.  The

computer where I'm running into this is a fairly new Compaq laptop with 
nVidia graphics.  I don't think that's the problem.

I'm not getting black blobs on the icons; they become blank grey 
buttons.  The buttons are there and showing, but they have no image.  I'm 
giving up on this because the developers aren't interested in looking into

it.  I'm going to reinstall OOo 1.1.3 which is not exhibiting this
behavior.

At 05:27 PM 3/17/2005, you wrote:
To: users@openoffice.org
From: Matt Needles [EMAIL PROTECTED]
Date:  Thu, 17 Mar 2005 13:23:00 -0500
Message-ID: [EMAIL PROTECTED]
Mime-Version:  1.0
Content-Type:  text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding:  7bit
Subject:  Re: Icons Disappear from Toolbars

Michael Reich wrote:
Today I tried to modify icons on the OOo function bar and managed to
lose 
several.  I opened the dialogue to add buttons to the tool bar and went
to
the icon menu.  When I selected an icon, the existing icon disappeared
but
was not replaced by the new selection.  What I have on the tool bar is a

blank button: I can point at it and get the pop-up explaining the
function
of that button, and the button will function correctly if I click on it,

but no icon is visible.
I'm running OOo 1.1.4 on Windows XP.  Any help in restoring my icons
will 
be appreciated.
I've found that messed-up icon display is caused by the video display or 
its driver.  E.g., I have an old Matrox Productiva G100 AGP (8MB), and 
often have problems with the icons becoming black blobs. When I pass the 
mouse pointer over them, sometimes they refresh, but not always.  I have 
1GB of RAM in my system, so I should try allocating more shared video 
memory and see if that helps.

Perhaps this gives you some clue as to solving your problem.

Matt Needles




__ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

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



[users] RE: Calc doesn't load CSV file

2005-03-15 Thread Michael Reich

I don't know if you already got an answer to this, but you should be able 
to make this work.  If  you use the quickstart to open document or
double click on the CSV file to open it, it will open in the Text module, 
NOT what you want.  You need to first open (run) Calc.  Then from Calc's 
File-open
dialogue point at the desired CSV file.  Calc should then invoke the text 
import dialogue as you expect.

At 04:23 PM 3/14/2005, you wrote:
 Message-ID: [EMAIL PROTECTED]
 From: J Shank [EMAIL PROTECTED]
 To: users@openoffice.org
  ...snip...
 Subject: Calc Doesn't Load CSV File
 
 I use OpenOffice version 1.1.4 with Microsoft XP-Home on an HP 3200+
with


 512 MB.  I am trying to open a .csv file in Calc.  According to the
 OpenOffice Help documentation, Calc should invoke the TextImport
dialog;
 however, when I open the file, it appears in the Text Document module
 rather than Calc and the TextImport dialog never appears.  Although I

have

 Excel (97 SR2) I don't want to have to load it into Excel and then save

in

 .xls format, then load it into OpenOffice.  That seems to be a very
long
 way around this problem.  What then is the simplest way to load the
data
 into OpenOffice Calc?
 
 Jim Shank
 Elkview, WV
 [EMAIL PROTECTED]




__ 
Do you Yahoo!? 
Make Yahoo! your home page 
http://www.yahoo.com/r/hs

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



[users] Icons Disappear from Toolbars

2005-03-12 Thread Michael Reich
Recently, I tried to modify icons on the OOo function bar and managed to 
lose several.  I opened the dialogue to add buttons to the tool bar and 
went to the icon menu.  When I selected an icon, the existing icon 
disappeared but was not replaced by the new selection.  What I have on the 
tool bar is a blank button: I can point at it and get the pop-up explaining 
the function of that button, and the button will function correctly if I 
click on it, but no icon is visible.

Where does OOo store the toolbar information?  M$ Word places this kind of 
info in the normal.dot file.

I'm running OOo 1.1.4 on Windows XP (SP1).  Any help in restoring my icons 
will be appreciated.  I previously posted this inquiry but haven't received 
any solution to the problem.  I tried to post this follow-up directly 
on  'gmane.comp.openoffice.questions' newsgroup, but my message isn't 
posting for some reason.

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


[users] Icons Disappear from Toolbars

2005-03-07 Thread Michael Reich
Today I tried to modify icons on the OOo function bar and managed to lose 
several.  I opened the dialogue to add buttons to the tool bar and went to

the icon menu.  When I selected an icon, the existing icon disappeared but

was not replaced by the new selection.  What I have on the tool bar is a 
blank button: I can point at it and get the pop-up explaining the function

of that button, and the button will function correctly if I click on it, 
but no icon is visible.

I'm running OOo 1.1.4 on Windows XP.  Any help in restoring my icons will 
be appreciated.





__ 
Celebrate Yahoo!'s 10th Birthday! 
Yahoo! Netrospective: 100 Moments of the Web 
http://birthday.yahoo.com/netrospective/

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