Base question
I have a database consisting of two tables related by a common field. I'm able to do all sorts of queries to it and extract various reports, as well. I would like to extract some of the data from the main table and include the common field from the related table in the form of a CSV file to act as a sort of backup for the database and to facilitate sending the data to another person. I can write a macro to accomplish this, I think, but is there perhaps an easier way to do it? Dick Hoffman - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Adding data to Base tables
Some time ago I built a Base database that uses two tables. It has worked very well all these years. Now I want to build another database in an entirely different project using three spreadsheets that I want to incorporate in the db. I can't figure out how to transfer data from the spreadsheets to the tables. Copy and paste doesn't work. I'm sure I somehow was able to move data from a spreadsheet to a table in the old db but have forgotten how I did it. I really don't want to have to retype all the data if possible. Any help will be appreciated. Dick Hoffman - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Can't edit Base macro
Running OO 4.1.15 on a Windows 11 system. When trying to edit a macro in Base, OO terminates and goes through a recovery process for the opened dbase. The dbase and macro remain functional after recovery but I cannot make the changes I want to make. Dick Hoffman - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
AOO can't open .xlsx spreadsheet at Cornell site
I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/clementschecklist/download/ but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AOO can't open .xlsx spreadsheet at Cornell site
On 9/25/2013 7:54 PM, Kay Schenk wrote: On Tue, Sep 24, 2013 at 2:58 PM, Dick Hoffman wrote: I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/**clementschecklist/download/<http://www.birds.cornell.edu/clementschecklist/download/> but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman --**--**- To unsubscribe, e-mail: users-unsubscribe@openoffice.**apache.org For additional commands, e-mail: users-help@openoffice.apache.**org No suggestions and yes AOO 4.0.x has a problem with it. I downloaded it as well. I hope it doesn't contain personal data. If it does, I will delete it. On the other hand, if it doesn't, can we use it as an attachment to an issue? This would be helpful to troubleshoot this problem. Thanks. The spreadsheet at the Cornell site doesn't contain any personal data; it can be used for troubleshooting purposes, or any other. I've had various suggestions and received several remedies. To summarize: the .xlsx file can apparently be read in OO 3.1.1 (someone who was able to do so saved it as a .ods and sent it on to me); the .xlsx file apparently can be read in AOO 4.0.1 (someone who was able to do so offered to save it as a .ods and send it on to me); yes, the .csv file can be taken into AOO or Excel to create an equivalent spreadsheet but you lose the color coding that is in the .xlsx which helps when scrolling through the data and the references from the second sheet of the .xlsx file don't seem to be present in the .csv file. I now have a version of the Cornell file in .ods format that serves my purposes. Thanks to all of you for your comments and suggestions. What a great group of people you are! Dick Hoffman Cleveland Heights, OH - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AOO can't open .xlsx spreadsheet at Cornell site
On 9/26/2013 4:53 PM, Dick Hoffman wrote: On 9/25/2013 7:54 PM, Kay Schenk wrote: On Tue, Sep 24, 2013 at 2:58 PM, Dick Hoffman wrote: I downloaded a fairly large spreadsheet from this location http://www.birds.cornell.edu/**clementschecklist/download/<http://www.birds.cornell.edu/clementschecklist/download/> but when I try to open it with AOO the progress line shows about a quarter of it being loaded and then AOO stalls and I have to use the Task Manager to cancel soffice. This is using AOO 4.0 on a Windows XP Pro/SP3 system. Any suggestions as to what might be wrong will be appreciated. Dick Hoffman --**--**- To unsubscribe, e-mail: users-unsubscribe@openoffice.**apache.org For additional commands, e-mail: users-help@openoffice.apache.**org No suggestions and yes AOO 4.0.x has a problem with it. I downloaded it as well. I hope it doesn't contain personal data. If it does, I will delete it. On the other hand, if it doesn't, can we use it as an attachment to an issue? This would be helpful to troubleshoot this problem. Thanks. The spreadsheet at the Cornell site doesn't contain any personal data; it can be used for troubleshooting purposes, or any other. I've had various suggestions and received several remedies. To summarize: the .xlsx file can apparently be read in OO 3.1.1 (someone who was able to do so saved it as a .ods and sent it on to me); the .xlsx file apparently can be read in AOO 4.0.1 (someone who was able to do so offered to save it as a .ods and send it on to me); yes, the .csv file can be taken into AOO or Excel to create an equivalent spreadsheet but you lose the color coding that is in the .xlsx which helps when scrolling through the data and the references from the second sheet of the .xlsx file don't seem to be present in the .csv file. I now have a version of the Cornell file in .ods format that serves my purposes. Thanks to all of you for your comments and suggestions. What a great group of people you are! Dick Hoffman Cleveland Heights, OH I upgraded to AOO 4.0.1, so out of curiosity I tried to access the .xlsx file at the Cornell site. Results were the same; after about 20 minutes the progress bar showed about 25% of the file loaded and I had to use the Windows Task Manager to terminate soffice.bin to stop it. Dick - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AOO can't open .xlsx spreadsheet at Cornell site
On 10/5/2013 5:03 PM, Andrea Pescetti wrote: Dick Hoffman wrote: I upgraded to AOO 4.0.1, so out of curiosity I tried to access the .xlsx file at the Cornell site. Results were the same; after about 20 minutes the progress bar showed about 25% of the file loaded and I had to use the Windows Task Manager to terminate soffice.bin to stop it. It opens normally for me with 4.0.1; however, it takes unacceptably long (13 minutes in my case). I opened https://issues.apache.org/ooo/show_bug.cgi?id=123429 since this is definitely a performance bug. Regards, Andrea. Thanks for opening a bug on this. I don't understand the comment from Andreas Säger; does that mean no action will be taken on the bug? Dick - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Problem with a docx file
When I try to open the attached file using AOO 4.0.1 on my Windows XP-SP3 system I get the following from AOO: Open Office Document Recovery Due to an unexpected error, OpenOffice crashed. All the files you were working on will now be saved. The next time OpenOffice is launched, your files will be recovered automatically. The following files will be recovered: (blank - no files are listed) When I click on "OK" AOO opens again but takes no action regarding the file in question. A ".~lock" file is left in my Temp directory. When I upload the .docx file to the free file conversion site, http://www.zamzar.com/, and have it convert the file to .doc, AOO has no problem opening the resulting doc file. The original file may have been created on a Mac system, for what that is worth. Dick Hoffman HOLIDAY SONGS 2012.docx Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
