Re: Importing fonts to OpenOffice
On Sat, 28 Dec 2019 20:25:31 -0800 Michael Anderson wrote: > How can I import new fonts into OpenOffice? Am trying to get some from > Fee Fonts, but I can't get them into the program from a zip file. > > Thanks, > Michael Anderson > As your email indicates you are using Windows, you need to install the fonts to Windows, using Control Panel /Fonts. -- Rory O'Farrell - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Importing fonts to OpenOffice
Import those fonts into your operating system. Then they will be available to OpenOffice. Sent from my iPhone > On Dec 29, 2019, at 3:58 AM, Michael Anderson wrote: > > How can I import new fonts into OpenOffice? Am trying to get some from Fee > Fonts, but I can't get them into the program from a zip file. > > Thanks, > Michael Anderson > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Importing fonts to OpenOffice
How can I import new fonts into OpenOffice? Am trying to get some from Fee Fonts, but I can't get them into the program from a zip file. Thanks, Michael Anderson - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: importing
The only way that I know of is to open the Access Query for editing and switch to the SQL view. Then copy the text of the SQL statement and paste into a new Query created in Base also open in SQL view mode. Rinse and repeat for each of the queries in the Access file. The help system in Access covers how to switch into SQL view there. Same holds for the Base application, the help shows you how to switch the Query designer into SQL view. The actual select statement may need some translation from the dialect used in Access and the dialect used by whichever of the database engines Base is working with at the moment. Best wishes, On Sat, Dec 8, 2018 at 11:28 AM wrote: > To whom it may concern; > > > > Presently, I am using Microsoft Access as my database for my men's club > roster. I have approximately 300 records. I would like to use Apple Open > Office Base in lieu of Access. I have two tables (one for active members > and one for dropped members). I have several (at least twenty-five) > queries > in that Access database. > > > > I tried the online suggestion to bring over to Open Office all my tables > and > queries. However, every one of the queries came over as a table. Not one > query. All tables. > > > > My basic question is: Is there a way to import an Access query into Apple > Open Office? > > > > C L Rockwell > > clrockwel...@gmail.com > >
Re: importing
> On 9 Dec 2018, at 3:16 am, > wrote: > > To whom it may concern; > > > > Presently, I am using Microsoft Access as my database for my men's club > roster. I have approximately 300 records. I would like to use Apple Open > Office Base in lieu of Access. First of all, you should be aware that the build in database is good for test purpose only. If forever your system crash it is not always easy to recovery the file. > I have two tables (one for active members > and one for dropped members). I have several (at least twenty-five) queries > in that Access database. > > > > I tried the online suggestion to bring over to Open Office all my tables and > queries. Could you tell us which online suggestion, there are many suggestions but not all of them are good. > However, every one of the queries came over as a table. Not one > query. All tables. > > > > My basic question is: Is there a way to import an Access query into Apple > Open Office? > > > > C L Rockwell > > clrockwel...@gmail.com > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
importing
To whom it may concern; Presently, I am using Microsoft Access as my database for my men's club roster. I have approximately 300 records. I would like to use Apple Open Office Base in lieu of Access. I have two tables (one for active members and one for dropped members). I have several (at least twenty-five) queries in that Access database. I tried the online suggestion to bring over to Open Office all my tables and queries. However, every one of the queries came over as a table. Not one query. All tables. My basic question is: Is there a way to import an Access query into Apple Open Office? C L Rockwell clrockwel...@gmail.com
importing addresses from Appleworks
Will openoffice import a database with street addresses from an old Appleworks program? And how? Also, I have been able to print addresses directly onto postcards in Appleworks. Can I do this with openoffice? Lisa and Cecil McKenzie McKenzie Glass 958 Road 215 Emporia, KS 66801 Lisa620-481-6868 www.mckenzieglass.com www.facebook.com/McKenzie.Glass
Re: Importing CSV [...]
At 11:44 20/02/2018 +1100, Ivo van Emmerik wrote: Importing CSV All the information is in the two documents It's particularly unhelpful that you provide only pictures of the CSV files, which makes experimentation and confirmation tedious for anyone helping you. I want to import this CSV file. And when I import it using those settings. I tried to change the import columns to Number but I could not. You shouldn't need to: Standard should do all you need. Than every number has that single mark there with three spaces and the only way to get rid of it is manually delete it! It's best not to imagine that the leading apostrophe is actually in the cell but rather that it is just a marker. If you declare Comma as your separator, your columns of numbers are not just numbers but are preceded by a number of explicit spaces. These strings are imported as text, and the apostrophe is an indicator that what is there is text, not the number which it looks like and that you presumably want. You can sort the problem after you have imported the text. Here's what to do: o Select all the data cells - in other words. rows 4 onwards. o Go to Edit | Find & Replace... (or Ctrl+F). o For "Search for", enter " +" (that's space-plus, no quotes). That regular expression matches any number of consecutive spaces. o Leave "Replace with" empty. o Click More Options and tick "Current selection only" and "Regular expressions". o Click Replace All. The trick here is that after you have removed the spaces, Calc reinterprets the values as it would do if you typed them initially. It recognises the text without its leading spaces as numbers and converts them and stores them as numbers. The apostrophes have disappeared! But there is an easier way: o In the Text Import dialogue, at "Separated by", tick Comma, Space, and "Merge delimiters". Now you just have a little tidying up to do. o Select A4 to G4 - all the parts of your now disconnected first line. o Go to Format | Merge Cells (or click the Merge Cells button in the Formatting toolbar). o Reply Yes to moving the contents of the cells. o Now use Merge Cells again to separate the merged cells. Your text in now in A1. o Repeat with A2 to B2. o Repeat with C3 to D3 to reassemble "Dsn Height" o Select A1 to C3. o Cut and paste into B1. o Delete column A. Here's probably an even easier way: o In the Text Import dialogue, at "Separated by", tick Comma, Space, and "Merge delimiters", but also change "From row" to 4. o Delete column A. o If required, insert three new rows at the top and paste in or retype the first three lines manually. Another idea is to create a new spreadsheet and to use Insert | Sheet From File... and to open the CSV file that way. Then you can import the data twice with different Text Import settings and reassemble different parts together on your real sheet. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Importing CSV and Posting questions on forum
On 02/20/2018 11:14 AM, Ivo van Emmerik wrote: 1. Importing CSV All the information is in the two documents On the Text Import dialogue box, make sure Detect special numbers is checked. Cheers -- David Robley To err is human. To really screw up it takes a computer!
Re: Importing CSV and Posting questions on forum
On 20/02/18 11:44 AM, Ivo van Emmerik wrote: 1. Importing CSV All the information is in the two documents Delete the first two lines from the CSV file to get the columns correct remember that each spreadsheet looks at the first line to find what columns to use, then open it in Calc. Because there are a lot of spaces in front of the values it is interpret as text not as numbers, the way OpenOffice handles text it puts the ` in front of the number. If you remove all the spaces it will load correctly as numbers. To save you a lot of time there is an option with importing CSV files tick the Detect special numbers and it will handle the values as numbers instead of text. 2) Posting questions on forum Sorry I want to ask the forum a question! But I can not see a button to start a new message, I logged in there is no clear indication where to press, if I am blocked because I am new than tell me, this is very frustrating! Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Importing CSV and Posting questions on forum
On 02/20/2018 11:14 AM, Ivo van Emmerik wrote: 2) Posting questions on forum Sorry I want to ask the forum a question! But I can not see a button to start a new message, I logged in there is no clear indication where to press, if I am blocked because I am new than tell me, this is very frustrating! Go to the forum and log in. Click on the section of the forum in which you want to post a question, e.g. Calc. Once in the selected section, look for an icon New Topic in the upper left hand side of the page. Cheers -- David Robley There's no life after death. Just Los Angeles.
Importing CSV and Posting questions on forum
1) Importing CSV All the information is in the two documents 2) Posting questions on forum Sorry I want to ask the forum a question! But I can not see a button to start a new message, I logged in there is no clear indication where to press, if I am blocked because I am new than tell me, this is very frustrating! Sent from Mail for Windows 10 JOB NAME: E:\Users\Ivo\Documents\Constructa\2017\Cameron Park\MGA harris st 4 Date: 20/02/2018 Point,Layer,Dsn Height, 111, LIP, 14.668, 112, LIP, 14.623, 113, LIP, 14.433, 114, LIP, 14.263, 115, LIP, 14.243, 116, LIP, 14.112, 117, LIP, 14.093, 118, LIP, 13.981, 119, LIP, 13.853, 120, LIP, 13.725, 121, LIP, 13.597, 122, LIP, 13.483, 123, LIP, 13.363, 124, LIP, 13.243, 125, LIP, 13.123, 126, LIP, 13.103, 127, LIP, 12.980, 128, LIP, 12.856, 129, LIP, 12.733, 130, LIP, 12.633, 131, LIP, 12.623, 132, LIP, 12.523, 133, LIP, 12.423, 134, LIP, 12.323, 135, LIP, 12.283, 136, LIP, 12.183, 137, LIP, 12.083, 138, LIP, 12.083, 163, LIP, 14.608, 164, LIP, 14.563, 165, LIP, 14.373, 166, LIP, 14.203, 167, LIP, 14.183, 168, LIP, 14.052, 169, LIP, 14.033, 170, LIP, 13.921, 171, LIP, 13.793, 172, LIP, 13.665, 173, LIP, 13.537, 174, LIP, 13.423, 175, LIP, 13.303, 176, LIP, 13.183, 177, LIP, 13.063, 178, LIP, 13.043, 179, LIP, 12.920, 180, LIP, 12.796, 181, LIP, 12.673, 182, LIP, 12.573, 183, LIP, 12.563, 184, LIP, 12.463, 185, LIP, 12.363, 186, LIP, 12.263, 187, LIP, 12.223, 188, LIP, 12.123, 189, LIP, 12.023, 190, LIP, 12.023, 217,FACE, 14.743, 218,FACE, 14.698, 219,FACE, 14.508, 220,FACE, 14.338, 221,FACE, 14.318, 222,FACE, 14.187, 223,FACE, 14.168, 224,FACE, 14.056, 225, STORM, 13.928, 226,FACE, 13.800, 227,FACE, 13.672, 228,FACE, 13.558, 229,FACE, 13.438, 230,FACE, 13.318, 231,FACE, 13.198, 232,FACE, 13.178, 233,FACE, 13.055, 234,FACE, 12.931, 235,FACE, 12.808, 236, STORM, 12.708, 237,FACE, 12.698, 238,FACE, 12.598, 239,FACE, 12.498, 240,FACE, 12.398, 241,FACE, 12.358, 242,FACE, 12.258, 243, STORM, 12.158, 244,FACE, 12.158, 270,FACE, 14.683, 271,FACE, 14.638, 272,FACE, 14.448, 273,FACE, 14.278, 274,FACE, 14.258, 275,FACE, 14.127, 276,FACE, 14.108, 277,FACE, 13.996, 278,FACE, 13.868, 279,FACE, 13.740, 280,FACE, 13.612, 281,FACE, 13.498, 282,FACE, 13.378, 283,FACE, 13.258, 284,FACE, 13.138, 285,FACE, 13.118, 286,FACE, 12.995, 287,FACE, 12.871, 288,FACE, 12.748, 289, STORM, 12.648, 290,FACE, 12.638, 291,FACE, 12.538, 292,FACE, 12.438, 293, STORM, 12.338, 294,FACE, 12.298, 295,FACE, 12.198, 296, STORM, 12.098, 297,FACE, 12.098, 499, CL, 14.638, 500, CL, 14.593, 501, CL, 14.403, 502, CL, 14.233, 503, CL, 14.213, 504, CL, 14.082, 505, CL, 14.063, 506, CL, 13.951, 507, CL, 13.823, 508, CL, 13.695, 509, CL, 13.567, 510, CL, 13.453, 511, CL, 13.333, 512, CL, 13.213, 513, CL, 13.093, 515, CL, 13.073, 517, CL, 13.032, 519, CL, 12.991, 521, CL, 12.950, 523, CL, 12.909, 525, CL, 12.867, 527, CL, 12.826, 529, CL, 12.785, 531, CL, 12.744, 533, CL, 12.703, 535, CL, 12.670, 537, CL, 12.636, 539, CL, 12.603, 540, CL, 12.593, 542, CL, 12.560, 544, CL, 12.526, 546, CL, 12.493, 548, CL, 12.460, 550, CL, 12.426, 552, CL, 12.393, 553, CL, 12.360, 555, CL, 12.326, 557, CL, 12.293, 558, CL, 12.253, 559, CL, 12.153, 560, CL, 12.053, 561, CL, 12.053, 642,1 M OFSET, 14.743, 643,1 M OFSET
Re: Importing into a database
At 08:48 04/12/2017 -0700, John Buono wrote: I am trying to import a CSV file into a database. I have followed help page but it does not work. No-one can be sure exactly what help instructions you have followed unless you identify them, of course. I open the CSV file and it opens correctly in a spreadsheet. But then when I copy and paste the rows and columns into the database table, all I get is the last value of the CSV file in the first cell of the database. I'm not sure exactly what you mean by pasting into the database table. I see nothing in the help text about pasting *into a table*. What am I doing incorrectly? You may be making this too complicated. o Create that database. You've done this. o Open the CSV file in OpenOffice as a spreadsheet. You've done this. o Either: + Copy the material from the spreadsheet. + In the database, click Tables in the Database column on the left. + Paste not into an existing table, but into the Tables panel now visible in the database. + Follow the instructions from the wizard. o Or: + In the database, click Tables in the Database column on the left. + Select the material in the spreadsheet. + Drag the selection into the database and drop it in the Tables panel now visible in the database. + Follow the instructions from the wizard. Once you have done this, you can move any material around in database tables if necessary, of course. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Importing into a database
On 05/12/17 2:48 AM, John Buono wrote: Hi, I have a problem. I am trying to import a CSV file into a database. I have followed help page but it does not work. I open the CSV file and it opens correctly in a spreadsheet. But then when I copy and paste the rows and columns into the database table, all I get is the last value of the CSV file in the first cell of the database. What am I doing incorrectly? What you do incorrectly is hard to say, but you could start to copy the data into a new table and see if that works. From there you could check column names and attributes and check if there are any differences. Don't forget that spreadsheets are more forgiving on data inconsistencies than databases. Without more insight into the data structure there is not much more I can say. John - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Importing into a database
Hi, I have a problem. I am trying to import a CSV file into a database. I have followed help page but it does not work. I open the CSV file and it opens correctly in a spreadsheet. But then when I copy and paste the rows and columns into the database table, all I get is the last value of the CSV file in the first cell of the database. What am I doing incorrectly? John
Re: importing a download
On 03/29/2016 02:21 PM, Peter wrote: > Unable to import a down load. Example we downloaded our tax > data from turbo tax and when it asks to save file we do. > > Then when we want to run it, it asks us to install open > office 4.0.0. > > It doesn't recognize 4.2 and it continues to ask the same deal. > > we have removed 4.2 and installed 4.0.0 and it just keeps > asking for us to install 4.0.0. help > This sounds like a setup problem with TurboTax and/or your system default applications. I don't use TurboTax but I'm guessing you can probably open your tax data with 4.1.2. Can you check your import settings for TurboTax and see if maybe OpenOffice 4.0.0 is hardcoded there or something of that nature. Or, you could have OpenOffice 4.0.0 specified as your default spreadsheet program and that's the problem. Please see our Installation Instructions for some guidance on assigning default applications in Windows. http://www.openoffice.org/download/common/instructions.html -- MzK "Time spent with cats is never wasted." -- Sigmund Freud - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
importing a download
Unable to import a down load. Example we downloaded our tax data from turbo tax and when it asks to save file we do. Then when we want to run it, it asks us to install open office 4.0.0. It doesn't recognize 4.2 and it continues to ask the same deal. we have removed 4.2 and installed 4.0.0 and it just keeps asking for us to install 4.0.0. help -- "The will of God, will never take you where the Grace of God, will not protect you." --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
importing xml file into calc
Hello, last seven days I've been trying to import my xml file into the open office calc programme. It's my first experience with open office products and I don't have any programming skills. I know I have to write a XSLT filter to import the xml file as noticed in the following link http://www.oooforum.org/forum/viewtopic.phtml?t=51387highlight=xml But the thing is I cannot find a good step-by-step-documentation which would help to write create the filter and embed it into the calc file and then to open my xml document in calc. The particular questions are: -what do I have to do to begin with -what editor I have to use to write my filter -how can I test it -could you provide some examples of filters and so on. Could you please provide me a precise documentation for open office 4.1.1. calc or assist me on this issue? Thank you in advance. Cheers Mariya
Re: importing xml file into calc
Hi Mariya, what kind of xml is it? There exists already some filters and perhaps one of them will open your file. Or you will find an existing filter in an extension. Are you forced to use xml or do you can get another format, e.g. csv, as well? Mariya Belyaeva schrieb: Hello, last seven days I've been trying to import my xml file into the open office calc programme. It's my first experience with open office products and I don't have any programming skills. I know I have to write a XSLT filter to import the xml file as noticed in the following link http://www.oooforum.org/forum/viewtopic.phtml?t=51387highlight=xml But the thing is I cannot find a good step-by-step-documentation which would help to write create the filter and embed it into the calc file and then to open my xml document in calc. The particular questions are: If you really need an own filter, then you would not embed it into the Calc file, but add it to your OpenOffice via Tools XML Filter Settings New -what do I have to do to begin with You would need to learn writing XSLT. That is independent of OpenOffice. -what editor I have to use to write my filter You can use every editor, which can write in encoding utf-8. But of cause you will looking for a editor which give you some comfort. Which one is suitable, depends on your operating system. -how can I test it Tools XML Filter Settings has a Test button, but I have never used it, because I do not write my own filters. -could you provide some examples of filters and so on. You can look into existing filters, for example the Ms Excel 2003 XML filter in path to OpenOffice\share\xslt\import\spreadsheetml\spreadsheetml2ooo.xsl Could you please provide me a precise documentation for open office 4.1.1. calc or assist me on this issue? OpenOffice 4.1.1 Calc implements the standard ODF 1.2. You find the documentation in https://www.oasis-open.org/standards#opendocumentv1.2 and especially, for the grammar, the schema http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-schema.rng There exist some small additions, but you can handle them later. Kind regards Regina - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Importing PDF form into OO 4.0.1
Jim McLaughlin jjim.mclaugh...@gmail.com: I am looking for a way to import into OO a form created by a third party with Adobe in PDF format. I want to be able to fill out the form with my computer, rather than print a blank form and fill in by hand. For reasons not known to me, the third party did not create a fillable PDF form, which I can fill out with the 'puter, either within OO or with Adobe reader. so, the form is just a compilation of field labels and series of underscores or drawn lines or rectangles instead of meaningful input boxes. in such a case, i think, the easiest way is to take snapshots in good resolution, insert them into a writer document in background and place frames on top of those lines or rectangles. i used to do so. another way is to insert typewriter comments over the input lines in a pdf reader. adobe's latest reader allows typewriting. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Importing PDF form into OO 4.0.1
At 17:10 04/02/2015 -0800, Jim McLaughlin wrote: I am running OO 4.0.1 on a PC clone under Windows 7 Home Premium edition. I am looking for a way to import into OO a form created by a third party with Adobe in PDF format. I want to be able to fill out the form with my computer, rather than print a blank form and fill in by hand. For reasons not known to me, the third party did not create a fillable PDF form, which I can fill out with the 'puter, either within OO or with Adobe reader. Other third parties do provide other kinds of fillable forms so I know it can be done. I just don't know how. I am looking for a way to fill out the form with OO and save it in the .PDF format. I don't think the fact that some forms can be filled means that forms not designed to be filled must somehow be able to be filled. o In Adobe Reader, use Edit | Copy File to Clipboard. o Paste into a new Draw document. o Resize the image to its original dimensions. (Hold down the Shift key to preserve the aspect ratio.) o Insert text boxes as necessary over the image of your form. Use the Text button in the Drawing toolbar and drag to produce each text box. o Use File | Export as PDF... to create your final PDF file. It's fiddly and messy, but it works. I've used it. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Importing PDF form into OO 4.0.1
I am running OO 4.0.1 on a PC clone under Windows 7 Home Premium edition. I am looking for a way to import into OO a form created by a third party with Adobe in PDF format. I want to be able to fill out the form with my computer, rather than print a blank form and fill in by hand. For reasons not known to me, the third party did not create a fillable PDF form, which I can fill out with the 'puter, either within OO or with Adobe reader. Other third parties do provide other kinds of fillible forms so I know it can be done. I just don't know how. I am looking for a way to fill out the form with OO and save it in the .PDF format. Any ideas? Thank you each and all in advance.