[users] Re: Where Do Base Reports Store The Desired Query?
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?
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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)
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
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
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
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
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
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
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
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
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
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
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...
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
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
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
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
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
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?
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
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
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
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
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
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
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
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
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
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
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]