[users] Re: limit # of columns in a spreadsheet
On Thu, Jun 30, 2011 at 4:46 PM, Helen etter...@gmail.com wrote: How do you prevent the new spreadsheet from creating infinite columns? Seems all my OO (and libre) spreadsheets take the default of infinite columns. You see infinite columns but the actual number of columns in the OOo sheet is determined by the last column that has data in it. You can determine the last cell by doing a ctrl (or cmd on Mac) - end. Since google seems to see more cells in the sheet, why don't you just open a new sheet in google docs, then select all active cells in your OOo sheet, copy them, then past them into the google docs sheet? -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Problem Open Office Writer
2011/6/8 Gary Bertolo gmbertol...@gmail.com Now You've got to be Kidding Oracle... What kind of service is this that I signed onto to get the answers to my software problems and questions. This unnecessary crud is B.S. I'm opting out of this... can't get help from support then what good is it. Signed Peeved' You're trying to get help on a FREE product, and you are beefing about not being hand-held by Oracle, and depending upon users for help? Good riddance! jomali -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Convert a row of table to text
On Tue, May 17, 2011 at 1:38 PM, Vladimir Ivanov vladi@abv.bg wrote: Hello Team, It's Vladimir.I want to use your OpenOffice product.I have OpenOffice 3.3.When I use Writer I want to convert a row of table to text.But Writer converts all the table.How to use that option as on Word ?Let me know if I make a mistake when I try to make convert.Of course it's very little problem for me and I'll use OpenOffice. Best regard, Vladimir Ivanov Vladimir, 1. Put cursor in row you want to convert 2. Select Table-Split Table 3. If the row was not the last row of the table, split the rows below the row you want to convert as in 1 and 2. 4. Put cursor in the row you want to convert. 5. Select Table-Convert-Table to text jomali -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: anchor to character ???
The command is anchor AS character and the help file says Anchors the selected item as a character in the current text. If the height of the selected item is greater than the current font size, the height of the line containing the item is increased. On Mon, May 16, 2011 at 9:11 AM, Mike Scott m...@scottsonline.org.ukwrote: I'm sure I've raised this before, but it's still an issue for me. What /exactly/ is anchor TO character supposed to do in Writer? The command is anchor AS character and the help file says Anchors the selected item as a character in the current text. If the height of the selected item is greater than the current font size, the height of the line containing the item is increased. snip -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Export Html Outline Numbering/Lettering Broken
I looked at your forum post as a courtesy to you. If you really want help, I'd suggest you post the problem itself here rather than asking us users to chase it down. I made an outline document and saved it to html. It worked just fine. What version of OOO are you using and what operating system? On Sun, Mar 27, 2011 at 6:44 PM, Joel Cambon joel2@gmail.com wrote: I already posted this on the forums here: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=39622p=182157#p182157 But I thought id repost it here and ask if this is a bug. I guess if you get this and you know the answer, answer on the forums unless you don't have a forum account, if you don't then answer here. Thanks. -Joel -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: OO default
Lisa, I just tried it on my Mac and it works as advertised. The only thing I can think of is that you are trying the Open with from a right click on the file name, rather than opening the Get Info window first. It is true that, when you click Open with and select an alternate application you can only select Always open with for that document. However, in Get Info, you will also see a button labeled Change All... which will change file associations for all files of that type. jomali On Wed, Mar 16, 2011 at 1:25 AM, Lisa Dee l1sa...@yahoo.com wrote: First - hardly a rant - merely expressing an opinion. I still contend that is presumptuous to set OO as default launcher. Second - I don't use Microsoft - only save my Pages (Mac) documents as Word .doc for those who do not have Mac OS. When I do the Open With, it only allows me to check a box that says Always open this document with - there is no box for Change All Like This Thanks anywayI'll have to figure out how to make OO not my default launch... btw - I don't mind working with OO, just prefer the option is all - no offense meant. -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
Re: [users] HELP...sending documents to people
Why would you do that? Simply export to PDF directly in OOo and send that file to the recipient. On Mon, Jan 17, 2011 at 4:58 PM, Vic Dura vpd...@hiwaay.net wrote: On Mon, 17 Jan 2011 10:55:45 -0800, JOE Conner joeconner2...@gmail.com wrote Re Re: [users] HELP...sending documents to people: On 1/17/2011 5:48 AM, Debi Banes wrote: Hello, What do I have to do when I email someone a document I created in OO and they can't open the document. I think it has something to do with the ext. I do not have Word or Excel although I have tried to change the extension to one of the other formats that OO offersWhat am I doing wrong...I'm not too switch in his computer stuff. Thanks! It sounds as if your email receivers do have OpenOffice. You can FILE - SAVE AS and choose M$oft Word (.doc). Then your email receivers will probably be able to open your document. Try it, and then get back to us with the results. Or, assuming you have Windows, get yourself a PDF converter such as the free doPDF at http://www.dopdf.com/ doPDF installs itself as a virtual PDF printer driver so after a successful installation will appear in your Printers and Faxes list and also in the list of All Programs. Using doPDF you can convert to PDF in two ways: 1. Print to PDF via the virtual printer driver doPDF. You would do this exactly as you print to a regular printer, just the result will be a PDF file, not a printed piece of paper. 2. Using the doPDF Startup window. doPDF has an executable file (accessible from the start program group) that you can run in order to start a conversion wizard. Then send them the .pdf as an email attachment. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] HELP...sending documents to people
Simply do a File-Send-E-mail as PDF to send the file as a PDF document. If you want it to be editable, do a File-Send-E-mail as Microsoft Word... On Mon, Jan 17, 2011 at 8:48 AM, Debi Banes dlba...@yahoo.com wrote: Hello, What do I have to do when I email someone a document I created in OO and they can't open the document. I think it has something to do with the ext. I do not have Word or Excel although I have tried to change the extension to one of the other formats that OO offersWhat am I doing wrong...I'm not too switch in his computer stuff. Thanks!
Re: [users] Missing stuff on a Mac
Whitney, You'll have to be more specific about what you are seeing. As a Mac user, I have never had the Mac menubar (not toolbar) disappear. It has the application-specific items for the active window in all applications, including Ooo on my machines. Jomali On Fri, Dec 17, 2010 at 12:02 PM, Whitney Russell whitney.lr...@gmail.comwrote: I am having trouble using open office on a mac. I've looked through the help and FAQ but can't find an answer to my questions. I swear I'm missing buttons on the tool bar. I even went to customize it and options like format or tools for footnotes that are referred to in help answers just aren't there. When I'm in open office, my Mac toolbar (meaning not the one on the word document but the one that is always at the top of the screen on a mac) disappears. I'm guessing that's the problem and am wondering if anyone knows how to fix it. Thanks. Whitney P.S. Would appreciate having any answers explained very simply. I'm an anthropologist (recently studied OS software and think it's great) but not a computer expert. :)
Re: [users] Question
Why don't you ask the administrator rather than this list? This is not and OpenOffice question. On Wed, Dec 15, 2010 at 5:13 PM, m93s...@aol.com wrote: I am trying to uninstal OpenOffice but everytime I try it says: This administrator has put policies in place that prevent uninstillation Why is that? Sara
Re: [users] Re: What is the use case for multiple sheets in Calc?
snip If my memory serves me correctly, I first encountered multiple sheets in a spreadsheet many years ago in Lotus 1-2-3 when it was touted as a 3D modeling tool. Two-dimensional data with identical formats in each sheet could be aggregated in a top sheet. Of course, the same result could be achieved by defining various zones in a single sheet, but review of the data in each sheet is facilitated by being able to go from tab to tab. One could imagine a document model in which associated writer, spreadsheet, database and presentation documents would be held in a single file, with the ability to reference data between them. OOo already allows some such interaction, albeit with data in separate files. I wouldn't hold my breath waiting for such a redesign to happen. Of course, if someone provided the resources... Jomali
Re: [users] Why register Db?
On Fri, Jul 30, 2010 at 12:28 PM, webmas...@krackedpress.com webmas...@krackedpress.com wrote: On 07/30/2010 12:12 PM, Gordon Burgess-Parker wrote: On 30/07/10 16:56, Earl Melton wrote: Greetings All, I am new to Linux and this is my first post to the forum. Hope I do it right. While I have often used OOo Writer and Calc in Windows, I had never opened Base. The subject line was going to read, Did Base not come with Ubuntu? because there was no way to start it. I played with Synaptic, though, and now have access to Base. In starting my first file, it immediately asks me, Do you want the wizard to register the database in OpenOffice.org? My question is, Why would I want to do that? I answered No because I don't really see the need. Would one (or more) of you more experienced users please enlighten me? Many TIA! If it's an address database then Open Office can use that for mailing labels and such like... I do not see the database as an option in my Ubuntu version of OOo. It is grayed out of the menu screen. snip As I recall, Ubuntu ships a version of go-oo without the Base component. You have to install the full version to get Base. Jomali
Re: [users] Why register Db?
On Fri, Jul 30, 2010 at 12:36 PM, Earl Melton earlemel...@yahoo.com wrote: Thanks Gordon, On 07/30/2010 11:12 AM, Gordon Burgess-Parker wrote: If it's an address database then Open Office can use that for mailing labels and such like... So would you say there is really no reason -- privacy, security, or otherwise -- to [not] register it? IOW, nobody besides me is going to see it or have editing access to it? Sorry to be so paranoid, but 25+ years of working mostly with Uncle Bill's software can do that to a guy. :-) snip It might help you to read OOo help first. The help file says: Data from any database file can be registered to OpenOffice.org. To register means to tell OpenOffice.org where the data is located, how it is organized, how to get that data, and more. Once the database is registered, you can use the menu command *View - Data source* to access the data records from your text documents and spreadsheets. Thus, you should always register a database. In case you are wondering, registering does not mean sending data to any outside destination. It is a local registration like entering data in the registry in Windows. Jomali
Re: [users] Need help to Market OOo
@Paula, It's great that you have found using OOo so helpful. However, you could give back to the community by sharing the glitches you have found with Calc. Perhaps users could help you overcome those glitches, or perhaps your experience would help developers to improve the system. Jomali On Wed, Jul 21, 2010 at 10:40 AM, Paula Johnson lesbng...@gmail.com wrote: I don't know if this will be at all helpful, but I live in state funded public housing and I do volunteer work for the director. State funded housing is suffering badly. While funding has not increased, expenses continue to rise. I am assisting the part-time director because she is unable to keep up with day to day tasks and there is no mioney in the budget for an assistant. In fact, the board has voted for her increase in salary every year, but she has refused to accept a raise for several years now, due to budget shortfalls. The director has never heard of Open Office. I offered to put all application information onto an Open Office spreadsheet, thereby streamlining her work. She accepted my offer and I began the data entry process this morning. Our housing authority is small and cannot afford to purchase up-to-date software. Sure, I've run in to some glitches in the spreadsheet. If we paid big money for it I would give it a bad review; however, with some patience and no money, it is doing what it needs to do and is a big help here. I hope this is helpful to you, Paula Johnson West Boylston, MA On Tue, Jul 20, 2010 at 5:05 PM, Gregory Forster gforst.1...@sbcglobal.netwrote: OOo's web site has been changed, so I can't find the information I need. I need help! This Saturday, a computerized system will be voted on. On the table is a very expensive, overly elaborate database that does much more than required, akin to a little old lady putting a Ferrari drive train into a Geo Metro to go to the grocery store. I have a few sold on the Open Office alternative. However, I need more. I need examples of government entities, corporations, educational entities that have actually switched to Open Office. I want to be loaded with uncompromising ammunition of facts to promote Open Office. HELP!! Greg -- Peace, Paula
Re: [users] NIGHTMARE!!!
It works fine here (OOo 3.2 on Mac OS X 10.6). What is the specific problem you are having with the document? jomalie On Tue, Jun 15, 2010 at 5:30 PM, Claus Fuetterer c.fuette...@physik.uni-leipzig.de wrote: Fill out windows forms with openoffice writer IS A SHEER NIGHTMARE!!! I risk to fail a project submission with deadline midnight (in one hour!!!) because of this trash software full of errors and inconsistencies. I swear you that tomorrow I will install windows and MS-Word. Sorry but I liked reliability and reproducibility of linux software but openoffice writer is everything but that. Its the worst software I ever used. Let me know once it is really working at at least 99%... Best, Dr. Claus Fütterer, Leipzig, Germany PS: I attached you the form, try it!!! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] What is the use of the envelope style?
On Wed, Jun 9, 2010 at 11:22 AM, John Kaufmann kaufm...@nb.net wrote: [This is a third attempt in two weeks at a question that has so far had no responses - I don't know whether because I ask questions poorly or because others are as clueless as I am on such questions. If the former: my questions may seem long, because I do a lot of homework before asking a question, and try to lay out the background in a systematic way. However, I'm open to suggestion on how to ask questions more efficiently; meanwhile, I try again, from yet another angle.] snip Greetings, John, When read your first message, I noted the admirable amount of research you did before asking your question. However, I found myself confused about exactly what you were looking for, so I did not reply. In your exchange with NoOp, I think I understand better what your root question is. I think you are asking, There are two envelope-related features in Writer. One is the envelope page style. The other is the Insert - Envelope command. How are they related? I don't believe they are related. It seems to me they are provided for different purposes. I would use the Envelope page style as the basis for creating my own custom envelope template containing material I wish to include. The Insert-Envelope command is a feature that allows me to easily create envelopes pre-formatted with my own return address and fields I can populate from a database (or, alternatively, overwrite those fields with the addressee information). The inserted envelope does not use the Envelope page style, but rather its own User format. But you know all that already, so perhaps I'm missing something. If you are asking the logic behind the design choices made, this user mailing list is probably the wrong place to ask. We are not (usually) developers. You might get better answers on a development list. I hope this helps. Jomali
Re: [users] What is the use of the envelope style?
Sorry to reply to my own post, but I have an erroneous statement I correct below. On Thu, Jun 10, 2010 at 9:25 AM, jomali jomali3...@gmail.com wrote: On Wed, Jun 9, 2010 at 11:22 AM, John Kaufmann kaufm...@nb.net wrote: [This is a third attempt in two weeks at a question that has so far had no responses - I don't know whether because I ask questions poorly or because others are as clueless as I am on such questions. If the former: my questions may seem long, because I do a lot of homework before asking a question, and try to lay out the background in a systematic way. However, I'm open to suggestion on how to ask questions more efficiently; meanwhile, I try again, from yet another angle.] snip Greetings, John, When read your first message, I noted the admirable amount of research you did before asking your question. However, I found myself confused about exactly what you were looking for, so I did not reply. In your exchange with NoOp, I think I understand better what your root question is. I think you are asking, There are two envelope-related features in Writer. One is the envelope page style. The other is the Insert - Envelope command. How are they related? I don't believe they are related. It seems to me they are provided for different purposes. I would use the Envelope page style as the basis for creating my own custom envelope template containing material I wish to include. The Insert-Envelope command is a feature that allows me to easily create envelopes pre-formatted with my own return address and fields I can populate from a database (or, alternatively, overwrite those fields with the addressee information). The inserted envelope does not use the Envelope page style, but rather its own User format. Wrong - it uses the customized Envelope page format. The Paper format is user. But you know all that already, so perhaps I'm missing something. If you are asking the logic behind the design choices made, this user mailing list is probably the wrong place to ask. We are not (usually) developers. You might get better answers on a development list. I hope this helps. Jomali
Re: [users] Macs
Ask him to install Openoffice on his Mac. Jomali On Sun, Jun 6, 2010 at 12:02 PM, Abdul Hai ahai11lon...@yahoo.co.uk wrote: Hi can I share open office documents with my friend who uses a Mac? Support solar power in the developing world. http://www.everyclick.com/solaraid http://www.solar-aid.org/
Re: [users] Re: Force MS Office file type to be associated to OpenOffice
snip Bah... I made a proper request for a proper File Association Manager long before that post: http://www.openoffice.org/issues/show_bug.cgi?id=77257 This is a ridiculous situation, but apparently there is not much hope for a proper solution due to the arrogance of a few developers who happen to be the only ones in the position to do anything about it. Let me understand your point of view. You think that developers, most of whom probably work in a *nix environment, to spend precious resources to develop functionality that only affects the windows environment and is already provided by the Windows OS are arrogant? Take off your blinders. Jomali
Re: [users] Re: Force MS Office file type to be associated to OpenOffice
Since I worked in Windows for many years before moving to a sane OS, and managed file associations regularly, I know that Windows does provide resources for associating file extensions with the programs to open them. What functionality does Windows lack that you want OOo to provide? Jomali On Wed, May 26, 2010 at 12:24 PM, Tanstaafl tansta...@libertytrek.orgwrote: On 2010-05-26 11:37 AM, jomali wrote: snip Let me understand your point of view. You think that developers, most of whom probably work in a *nix environment, to spend precious resources to develop functionality that only affects the windows environment and is already provided by the Windows OS are arrogant? No. 1. The functionality is *not* provided by the Windows OS - such a statement is demonstrably false, and 2. I think that developers who provide a product where the vast majority of users are in a Windows environment, should absolutely try to make things better for such users, not worse. Take off your blinders. My blinders fell off many years ago. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Force MS Office file type to be associated to OpenOffice
You are an arrogant person, aren't you? I actually did read your request for update. However, I hoped you had better information than what you provided in that request. You claim that, when you lose template file association and restore it, the templates open as templates and not as new writer files. That is true, if you re-associate them with Writer. However, if you re-associate them with Openoffice 3.2, they open correctly. Granted, this is non-intuitive, but I discovered this with five minutes of experimentation. I agree with the commentators who did not see this as a desirable added feature in Ooo, since it's so easy to do in Windows and since not even Microsoft Office has such a feature. Jomali On Wed, May 26, 2010 at 3:58 PM, Tanstaafl tansta...@libertytrek.orgwrote: On 2010-05-26 3:06 PM, jomali wrote: Since I worked in Windows for many years before moving to a sane OS, and managed file associations regularly, I know that Windows does provide resources for associating file extensions with the programs to open them. What functionality does Windows lack that you want OOo to provide? A GUI interface directly in OOo that can manage the file associations for all of the files it is capable of opening - everything from repairing broken file associations (including associating template file types so that they work as templates are supposed to work), to restoring the file associations of non ODF file types that it took over at installation time to their previous state before it took them over. You know - something the average USER can use and understand, and that makes adminstering OOo a whole lot less painful. You didn't read my bug/feature request did you (don't answer, rhetorical question)... - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Water Marks
Well, I, for one don't understand why one would find another's personal expression of religious belief offensive as long as that person does not disparage yours. On the other hand, you, James chose to express your atheistic religious beliefs in a way to disparage theistic religious beliefs. Neither theism nor atheism is provable using mathematical or scientific criteria, so we (I think) should accept others where they are without disparagement while acknowledging disagreement. Jomali On Tue, Apr 6, 2010 at 8:23 AM, James Knott james.kn...@rogers.com wrote: Programmer In Training wrote: If you want an answer, email me off list as that's way off topic and also I have no desire to give trolls and flamers any fuel for their angst-ridden rants. Well, I for one, find your sig offensive. Please keep religious nonsense off the list. All religion, be it Christianity, Islam, Judaism etc. is delusion. All too often those delusions are used to harm others. So, please keep it to yourself. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Very strange sorting error/brian
On Mon, Mar 1, 2010 at 11:08 AM, Brewster Gillett b...@fdi.us wrote: snip bg: That's an intriguing notion. Since ZIPs only ever consist of numbers, why would it be preferable to store them as text? So as to avoid confusion with real numbers? jomali: That's not entirely true. Extended zip codes are usually (often?) supplied as Zip-Extension. Also, zip codes with leading zeroes have to be converted on output, while no conversion would be necessary if they were preserved in a text representation. I've also seen the equivalent to zip codes in foreign countries including non-numeric digits. Granted, you may not have a present need for foreign zip-type codes, but they do exist. snip
Re: [users] Writer; Decimal Tab Stops?
On Sun, Feb 28, 2010 at 7:28 PM, Twayne twa...@twaynesdomain.com wrote: Hi, I'm in the process of changing some Word templates to Writer templates and I've hit a snag. How do you set a decimal tab stop? That's one where, when digits are entered, they align to the left or right of the decimal point. A decimal tab stop is one where in a column of numbers, the decimal points will all align one under the other. e.g. digits after the fixed position (column wise) decimal point fill in to the right, and digits to the right of the decimal point fill in toward the left. Output would look like (with a mono-space font): $ 0.254 $300.79 $5.5657 $15.969 and so on, all the decimals and cents aligned so they start in the same character column, one over the other. The 3 and 4 digits resolution after the decimal is used in the fine-detail descriptions of very large numbers of objects and is not a typo. I found a decimal tab stops entry in OO.o's Help, but the information seems to have nothing whatever to do with a decimal tab stop. In fact, it's apparently the General Settings information and only briefly mentions tab stops. I feel like I've done it before in OO.o, but darned if I can figure out how now! Thanks much in advance for any relevant information/comments you may have, If you look at the ruler at the top of the document, there is a small icon on the left showing the current tab stop type. If you click on it, you will see cycle it through left, right, decimal and center tabs. If you stop at the decimal tab, then when you insert a tab on the ruler, it will be a decimal tab. You can also call up the paragraph formatting dialog and set your tabs and their types there. Twayne -- Life is the only real counselor; wisdom unfiltered through personal experience does not become a part of the moral tissue. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] discontinue
Christine, a) I'm sorry that OpenOffice.org did not suit your needs. It would be interesting to know what feature you would have liked. Perhaps it could be of use to others and might be included in a future upgrade. b) You are not writing to a company, but a group of users of OpenOffice.org who are more than happy to help other users when possible. c) You are the only one who can unsubscribe yourself. Just follow the directions that are included in each message you receive. d) Shouting will get you nowhere. Jomali On Sun, Feb 21, 2010 at 9:51 AM, Christine Hanley snuggles...@verizon.netwrote: TO WHOM IT MAY CONCERN PLEASE REMOVE ME FROM YOUR MAILING LISTS AS YOUR PROGRAM WAS AND IS OF NO USE TO ME. iT DID NOT CONTAIN THE FEATURE i REQUIRED AND i WAS COMPLETELY UNABLE TO GET A STRAIGHT ANSWER FROM YOUR COMPANY. i NEVER HAD THIS PROBLEM WITH ANY OTHER COMPANY BUT YOURS AND i WILL NO LONGER TRY TO USE YOUR PROGRAM. i HAVE FOUND SOMETHING BETTER THAT DOES HAVE THE FEATURE i REQUIRE AND THEY RESPONDED TO MY QUESTION THE FIRST TIME i ASKED IT AND WERE ABLE TO HELP. THANKS FOR NOTHING!
Re: [users] discontinue
Terry, Are you one of those people who habitually takes your frustration out on co-workers? If so, I would not want to work with you. I fully understand frustration. I feel it often. However, I also am mature enough to behave considerately to other people and avoid shouting. Perhaps she did not realize that all caps is shouting, but it is, and if she has consideration for others, she will avoid continuing the practice when she is apprised of it. If you want paid support, I suggest you buy StarOffice from Sun. OpenOffice.org, as a free, open source program, does not have a revenue stream to support a customer support system. Instead, users support one another. Developers sometimes chime in to help as well. I, for one, appreciate the efforts of so many experienced users who volunteer their time and expertise to help us out. Jomali On Sun, Feb 21, 2010 at 5:26 PM, Terry Plowman tmplow...@bellsouth.netwrote: Maybe if the producers would have a real customer support system, people would not get so frustrated and shout. Incidentally, she may not be shouting. She may be working and habitually use all caps when typing information into the computer. I used to have a job where I never used lower case text, so my system was always set on all caps, and when I would send an email, I often forgot to take the caps off. Treating someone like they are wrong or unnecessarily offensive because they are frustrated with a product or procedure that doesn't appear to be working is rather asinine. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Fault in spelling check
Significant fault - I don't think so. Perhaps nice to have, but the lack of the ability to specify a non-standard word separator does not affect functionality at all. The only thing that happens is an annoying notification of a spelling error, which you can ignore completely. Why don't you just enter a feature request so the developers can consider a change in the future? Jomali On Mon, Feb 15, 2010 at 9:02 AM, Séamas Ó Brógáin s...@iol.ie wrote: I’ve just noticed what seems to be a fault in Openoffice 3.2. Two words separated by a dash, thus: then—after are underlined in red and are picked up as a fault in the spelling check. In some applications there is (or was) a feature whereby the user chose what would be the characters regarded as word separators. I don’t think there is such an option in Openoffice, in which case this is a significant fault. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Using OOo to count words in documents
On Sat, Feb 13, 2010 at 4:36 AM, Johnny Rosenberg gurus.knu...@gmail.comwrote: snip Isn't word count already implemented in OpenOffice.org Writer? Regards Johnny Rosenberg Yes. Select File-Properties to get word count and other properties of the document. John
Re: [users] msword docs dont display properly
This subject has come up many, many times. The OOo developers have done an outstanding job in trying to maintain compatibility between OOo and MS Office. However, it is inevitable that there will be some incompatibilities between the tools. Might I suggest a workflow solution to the problem, using a separation of concerns approach borrowed from object oriented programming and modern web page development? When developing a document that has to be shared, use minimal (preferably no) formatting of the document during the development and initial review process. For example, simply insert graphics after the paragraph that will eventually contain them. Make tables simple unformatted tables of data. When everyone in the workgroup is satisfied with the content, use either OOo or MS Office to format the document. For final comments, circulate a PDF file which the reviewers can mark up and return to the person formatting the document. That person, using the tool of his or her choice will then incorporate comments as necessary. Such a process will avoid the contention over which tool is better and allow each person in the group to use the tool they prefer. John On Thu, Feb 11, 2010 at 9:20 AM, McLauchlan, Kevin kevin.mclauch...@safenet-inc.com wrote: Aryeh Weiss [mailto:ar...@cc.huji.ac.il] inquired: I find that MSWord docs which contains tables or figures usually do not display properly. Location of the images is wrong, and often text positioning is not correct. I do not know if list rules allow posting of attachments, but if anyone it interested, I can email offlist the MSWord file and two PDFs that show which show the MSWord display and the OO display. Thia issue is the major limiting factor in my needing to keeping using MSWord (in virtual box under OSX). Are there particular options which solve this problem? I would be interested in this, too. I'm trying to use OOo inside a Microsoft-centric company. If anything is going to screw up my attempts to turn around documents that other people edit in MS Word, it's usually tables and graphics. Is there guidance, somewhere, on best practices for creation of documents in Word, such that they'll stand the best chance of round-tripping between Word and OpenOffice? Or a cheat-sheet on things to look for in Word documents - and correct - before bringing them into OOo? I've found the odd old discussion via Google, but nothing definitive or comprehensive. Most people with whom I deal are using MS Office 2003 or 2007. Similarly, it might be interesting to know some things-to-do and things-to-avoid when creating documents in OOo that you know are going to be edited by people using Word. Usually, nobody ADDS tables or graphics to my docs, but they might edit the contents of tables, or do things that would push a graphic around. Or, they might copy a table in my document (the Word version that they're editing) and paste it as the basis of a new table, or perhaps add a column or rows to an existing table. - Kevin The information contained in this electronic mail transmission may be privileged and confidential, and therefore, protected from disclosure. If you have received this communication in error, please notify us immediately by replying to this message and deleting it from your computer without copying or disclosing it. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OOo on 21 % of German Internet users' computers
James, Please don't retail misinformation. I run the Mac version (2.6.7). I have it open right now. When I click on the Menu item (or use Shift-F1), a question mark appears. When I click on a UI element, the help window for that element opens in my browser, at url file://localhost/tmp/skl/Gimp.app/Contents/Resources/share/gimp/2.0/help/en/index.html. If you open the Gimp.app package and navigate to Contents/Resources/share/gimp/2.0/help/en/, you will find the help files. This, by the way, is precisely the way Photoshop Elements help works (I just tried it on my laptop). John On Sun, Feb 7, 2010 at 5:53 AM, James Wilde james.wi...@sunde-wilde.comwrote: On Feb 6, 2010, at 05:09 , jomali wrote: What do you mean There is no context sensitive help? On the help menu, the second item down is Context Sensitive Help. When you click it, a question mark is displayed that brings up the relevant help page for the clicked-on UI item. John John, there is actually no context-sensitive help in the Mac version, and, as I understand it, the help files must be specially installed on at least one of the other platforms. //J - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OOo on 21 % of German Internet users' computers
What do you mean There is no context sensitive help? On the help menu, the second item down is Context Sensitive Help. When you click it, a question mark is displayed that brings up the relevant help page for the clicked-on UI item. John On Fri, Feb 5, 2010 at 10:36 PM, Pierre openoff...@finalfiler.com wrote: Michael Adams wrote: Despite the fact that poor documentation and help files do frequently exist on FOSS software. This is not an issue that The GIMP suffers from. The GIMP's help files are larger than the program file: http://gimp-win.sourceforge.net/stable.html They may be large, but they are difficult to navigate, There is no search function as far as I can see and certainly there is no context sensitive help. One has to trawl through the pages in the hope of finding the relevant topic. -- Pierre Worrigee, NSW, ,-._|\ / Oz \ \_,--._/ v The boys dressed themselves, hid their accoutrements, and went off grieving that there were no outlaws any more, and wondering what modern civilization could claim to have done to compensate for their loss. They said they would rather be outlaws a year in Sherwood Forest than President of the United States forever. Mark Twain's Adventures of Tom Sawyer - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Mail Merge won't create multiple letters
On Sun, Jan 24, 2010 at 4:35 PM, D p-collec...@gmx.com wrote: Sorry if this is a FAQ. I did look but didn't see any resolution to this. I'm trying to create a simple mail merge setup. I created my form document easy enough as well as the Base database of recipients, but when I go through the mail merge process, it always creates a single letter and quits. I can select which one by using the wizard and selecting the edit document button on the wizard after the merge is done, but no matter what I get one page (the form is one page), not as many as in the database records. What I'd expect is if there are two records in the database, then make a two page document with each page being one letter, or something like that. Am I doing it wrong somehow? Any help is appreciated! I suspect that you expect to see all of the letters to be sent on your screen. However, have you tried printing your mail merge document? The merge, AFAIK, only happens upon printing. John
Re: [users] Re: Re: Writer: adding newline before table
When this thread began, I thought How else would one add a line before a table? This is exactly the way Microsoft Word works (I just tried it to refresh my memory). Since, when a table begins a document, there is no space before the table to put the cursor in, the current operation is about all you could do. Since, based on past threads, Dotan prefers OOo to work as Word does, I would think this is very desirable (though counterintuitive) behavior ;-). John On Thu, Jan 21, 2010 at 4:03 PM, Dotan Cohen dotanco...@gmail.com wrote: On OpenOffice.org 3.3.0 DEV300m69 (on Fedora 12 Linux), when I put the cursor at the very beginning of the first cell and press Enter, the result is a newline BEFORE the table. Also, the cursor moves from it's original position, to the one that I THINK I would expect it to be in: in the newline that was created before the table. Yes, but before you press Enter, where is the cursor? Do you see that the newline is not placed in the place where the cursor was (the cursor was in the cell, the newline is outside)? I think that you are looking at the cursor's position _after_ you press enter. The issue is the cursor's position _before_ you press enter. -- 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] [moderated]
What photo handling program does Microsoft Office have? What do you want to do with such a program? John On Sat, Jan 2, 2010 at 8:05 AM, John Neale stony.ne...@googlemail.comwrote: Does open office have a photo handling program like Microsoft office has.
Re: [users] my problem
On Wed, Dec 16, 2009 at 9:39 PM, Programmer In Training p...@joseph-a-nagy-jr.us wrote: On 12/16/2009 3:59 PM, Programmer In Training wrote: On 12/16/2009 3:11 PM, James Knott wrote: Is it not possible to check the md5sum on a Mac? It's always a good idea to verify download integrity. snip Are there any native[1] utilities on a Mac to do that? I know there aren't any on Windows (and I don't even know of any third-party utilities, but that's just because I've never bothered to check). PIT [1]: By native I mean comes with the OS by default. Like 'cd' or 'mkdir' is native to *Nix's. I'm responding to myself because everyone is assuming I'm on *Nix. I asked about a Mac for the edification of the OP and mentioned Windows because that's what I'm using. If I were to type md5sum in a console window in Windows, I'd get an error message about the command not being found. I also know where to find the md5sums for OOo, thank you for the link though. So, my question was partly answered when someone said many *Nix util's will work on a modern Mac. I never really asked a second question. If you are on Mac OSX, you *are* on *nix, a variant of BSD, actually, and all of the common *nix utilities are already present. Just open a terminal window as I suggested previously and try it! John
Re: [users] my problem
On Tue, Dec 15, 2009 at 8:06 PM, Penny Larish penn...@mts.net wrote: Hi, I am completely lost. I downloaded openoffice last night but my computer battery went dead just after the download. Since recharging my Macbook I attempted to open my download. I received a warning that I need to close openoffice.org on host, but I have no clue what they are talking about, let alone how to achieve. I haven't been able to do any tutorials as I am on dial-up, so as you can see I am in rough shape. Any assistance anyone could provide would be so gratefully appreciated !!! I am trying to do a presentation on my mac and someone said openoffice would be a good choice for doing that. Penny Penny, I suggest that you restart your computer. Restarting will shut down any open applications. After the restart, delete the downloaded Openoffice dmg file and re-download it. Keep your laptop plugged in during the download to avoid your battery going dead, because the download will take a long time on dialup. When you open the downloaded dmg, you will have to install it. I assume you know how to install applications from a disk image. Once it is installed, you should be on your way. John
Re: [users] my problem
On Wed, Dec 16, 2009 at 4:59 PM, Programmer In Training p...@joseph-a-nagy-jr.us wrote: On 12/16/2009 3:11 PM, James Knott wrote: Is it not possible to check the md5sum on a Mac? It's always a good idea to verify download integrity. snip Are there any native[1] utilities on a Mac to do that? I know there aren't any on Windows (and I don't even know of any third-party utilities, but that's just because I've never bothered to check). PIT [1]: By native I mean comes with the OS by default. Like 'cd' or 'mkdir' is native to *Nix's. Open a terminal window. Type md5sum and the file name you want to get the md5sum to Compare the result to the published md5sum of the file to verity that it downloaded correctly. John
Re: [users] Re: To use Alt-* or Ctrl-* for keyboard shortcuts?
On Sun, Dec 13, 2009 at 7:26 PM, Larry Gusaas larry.gus...@gmail.comwrote: On 2009/12/13 3:18 PM Johnny Rosenberg wrote: 2009/12/13 Harold Fuchshwfa.openoff...@googlemail.com: Dotan Cohen wrote: Many of OOo's menus have keyboard shortcuts underlined. How is the user supposed to know if the modifier key for the shortcut is Ctrl-* or Alt-*? As far as I know, in *Windows* an underlined letter in a menu item *always* means Alt and the letter. If OOo does not follow this convention then I think its authors are in breach of covenant. Can't comment on Linux or Mac though. Seems to be Alt on Linux too. Macs do not have underlined letters in menu. Correct - on our versions of OOo the shortcut keys are shown adjacent to the menu item. John -
Re: [users] Re: calculating fields with a macro in a database
Your answer leads me to believe that you haven't really investigated the possibilities of using the database facilities for solving your problem, since you aren't even aware that OOo provides HSQLDB as its default, not MySQL. If you really need to use a database to manage your data, you might investigate more thoroughly how you might solve your problem using SQL. John On Fri, Dec 11, 2009 at 8:00 AM, Jonathan Kaye jdkay...@gmail.com wrote: jomali wrote: On Wed, Dec 9, 2009 at 4:49 AM, Jonathan Kaye jdkay...@gmail.com wrote: This is a simple question but hours of searching various documents hasn't turned up an answer yet. In a spreadsheet I can assign a function whose argument is a cell to perform an operation that is displayed in the cell containing the function call. Thus, if cell B1 has the formula =upper(A1) and A1 has a string Hello world, then B1 will display HELLO WORLD. I can also use a macro in a similar fashion to map one string of characters onto another. My question is: how do I do this in a database? I would like to define a field in a query whose value is calculated by applying my macro to the value of another field. I have a field called ENTRY in my database and I would like to create another field whose value is FIXSORT(ENTRY) where FIXSORT is a macro that I've written which maps one string onto another one. I assume this is done using a query but I've been unable to figure out how to create the calculated field. Thanks for any help. Jonathan -- Registerd Linux user #445917 at http://counter.li.org/ Please do not send me copies of list mail. I read the lists. Thanks! I doubt that you can do it with an OOo macro (others may know more). However, you can probably do what you want with SQL, depending on the DBMS you are using and the actual substitution you would like to make. In your example, you can formulate an SQL query using the UPPER function to display Hello World as HELLO WORLD. For a more complex query, you might want to consider using the stored procedure or function capabilities of you DBMS. John Thanks John. My macros are extremely specific to a given task and could only be created via a macro programming language (such a the variety of basic used in openoffice). I use the dbms supplied by openoffice (mysql?). I have not been able to find any mention of how to use macros created in openoffice for calculated fields. I guess it can't be done. Thanks again. Jonathan -- Registerd Linux user #445917 at http://counter.li.org/ Please do not send me copies of list mail. I read the lists. Thanks! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] CR/LF (carriage return/line feed) in OO Calc
On Wed, Dec 9, 2009 at 5:03 AM, Peter Hillier-Brook p...@hbsys.plus.comwrote: Ian L. Target wrote: In Office 97 Excel, I could hit SHIFT RETURN to get a CR/LF in a cell. How is this done in OO Calc? It's tedious, but it can be done by: 1 Select the cell in which you wish to introduce new lines within text. 2 Click in the text in the input line to select it. (The formula bar will change to show the Accept/Cancel green tick and red cross) 3 Now go back to the selected cell where the content is now editable and use CTRL+Enter to insert your newlines. Peter HB Not tedious at all: 1. If you are entering data, simply use CTRL-Enter (CMD-Enter on Mac) when you want a new line 2. If you want to edit a cell you've left, double-click the cell, put your cursor where you want the newline to appear, and use CTRL- or CMD-Enter. Do this as many times as you want, then hit TAB or select another cell with the mouse. It's not necessary to go to the input line at all. John
Re: [users] calculating fields with a macro in a database
On Wed, Dec 9, 2009 at 4:49 AM, Jonathan Kaye jdkay...@gmail.com wrote: This is a simple question but hours of searching various documents hasn't turned up an answer yet. In a spreadsheet I can assign a function whose argument is a cell to perform an operation that is displayed in the cell containing the function call. Thus, if cell B1 has the formula =upper(A1) and A1 has a string Hello world, then B1 will display HELLO WORLD. I can also use a macro in a similar fashion to map one string of characters onto another. My question is: how do I do this in a database? I would like to define a field in a query whose value is calculated by applying my macro to the value of another field. I have a field called ENTRY in my database and I would like to create another field whose value is FIXSORT(ENTRY) where FIXSORT is a macro that I've written which maps one string onto another one. I assume this is done using a query but I've been unable to figure out how to create the calculated field. Thanks for any help. Jonathan -- Registerd Linux user #445917 at http://counter.li.org/ Please do not send me copies of list mail. I read the lists. Thanks! I doubt that you can do it with an OOo macro (others may know more). However, you can probably do what you want with SQL, depending on the DBMS you are using and the actual substitution you would like to make. In your example, you can formulate an SQL query using the UPPER function to display Hello World as HELLO WORLD. For a more complex query, you might want to consider using the stored procedure or function capabilities of you DBMS. John
Re: [users] Styles Question
On Wed, Dec 9, 2009 at 5:05 PM, Mark C. Miller mr.mcmil...@gmail.comwrote: Let me preface this by saying that when I hit F11, and saw list styles I thought it was a 'list of styles'; (like a list of files) , not styles applied to lists. That's just to give you a frame of reference of my knowledge level. After asking a question about tabs earlier this year, I hit Amazon for some reference books that had been recommended. It was cheaper than printing them myself, and I just have to have a hard copy to highlight, etc. I've been reading Getting Started with OpenOffice.org 3 (Published by Friends of OpenDocument, Inc) and Writer Guide (Published by SoHo Books) both of which appear to be hard copy versions of the docs at the OOo Author's Site). I've checked out the on-line references a good old google search got me. I can not tell you how confused I am. Here's what I want to do: Create a list of test questions numbered 1 through 10. Each number will be flush left just like the first letter of a paragraph would be. My out- of-the-box set-up of 3.1 on Ubuntu 9.10 keeps wanting to assign a number style and indent the number. I get the first question written and the form is correct. When I hit return to begin a new paragraph, the previous number is indented. Do I need to set up a list style? A page style? Why, if I don't want any style, do I get one by default? Shouldn't it be the other way around? If you could point me towards which specific style I need to work with, that will be a big help. It may be just me, but this isn't very intuitive. mcm -- Mark C. Miller, Indianapolis IN, USA users-h...@openoffice.org Just as a matter of curiosity, without knowing the answer to your question, I decided to experiment. That's the way I learn a new application, by the way. I created a list of ten questions. They had the default list style, of course, which indents each number. I then opened the list styles toolbar and applied each numbered list style in turn. When I got to Numbering 3, I had what I wanted - a numbered list that had the numbers aligned with the left margin. I then adjusted the tab (since the default tab was too far to the right for my taste and made a new style from the selection named questions. My experiment took all of five minutes. John
Re: [users] Request for assistance
Hi, June, Did you ever hear of Google? I just put openoffice watermark into Google and got a plethora of hits, including one that gave three alternative ways of doing what you want. We are glad to help other users with their problems, but I find it very annoying when the user doesn't do at least a little homework first. I, personally, find it mystifying that users expect OOo to work exactly the way Microsoft Office works for every feature. John On Tue, Nov 24, 2009 at 2:54 AM, juju2422...@yahoo.com juju2422...@yahoo.com wrote: Hi, my name is Junebug, I can't get anyone to help me, I lost all my files and my Microsoft office, and your comment about them making all the money is probably true, but with open office I can't put a watermark into my mail, not email, correspondences, and on envelopes that I did with ease when I had Microsoft Office, no one answers this question and just taking a chance and contacting people who may be able to tell me what the problem is. I can make any watermark, but then when you insert on to the page where you will compose your letter, it won't let you enter any text, it just brings up handles on the page. Can you check it out and maybe find a solution for me. Please, I need this for my work and personal use. Regards June Muraco From: Mark Traceur marktrac...@gmail.com To: users@openoffice.org Sent: Tue, November 24, 2009 2:13:10 AM Subject: Re: [users] Request for assistance Watch out, sounds like a scam. Gee, you think? I figure we can trust him with a few hundred dollars, at least... -- Microsoft does half the work that Open Source developers do, and they get all the money. Where's the justice there? JIG (wajig + gjig): unified frontend to many APT and DPKG executables (apt-get, apt-cache, dp... - http://www.reddit.com/r/Ubuntu/comments/a71cf/jig_wajig_gjig_unified_frontend_to_many_apt_and/ - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Request for assistance
Oops - I forgot to reply-all. Hi, June, Did you ever hear of Google? I just put openoffice watermark into Google and got a plethora of hits, including one that gave three alternative ways of doing what you want. We are glad to help other users with their problems, but I find it very annoying when the user doesn't do at least a little homework first. I, personally, find it mystifying that users expect OOo to work exactly the way Microsoft Office works for every feature. John On Tue, Nov 24, 2009 at 2:54 AM, juju2422...@yahoo.com juju2422...@yahoo.com wrote: Hi, my name is Junebug, I can't get anyone to help me, I lost all my files and my Microsoft office, and your comment about them making all the money is probably true, but with open office I can't put a watermark into my mail, not email, correspondences, and on envelopes that I did with ease when I had Microsoft Office, no one answers this question and just taking a chance and contacting people who may be able to tell me what the problem is. I can make any watermark, but then when you insert on to the page where you will compose your letter, it won't let you enter any text, it just brings up handles on the page. Can you check it out and maybe find a solution for me. Please, I need this for my work and personal use. Regards June Muraco From: Mark Traceur marktrac...@gmail.com To: users@openoffice.org Sent: Tue, November 24, 2009 2:13:10 AM Subject: Re: [users] Request for assistance Watch out, sounds like a scam. Gee, you think? I figure we can trust him with a few hundred dollars, at least... -- Microsoft does half the work that Open Source developers do, and they get all the money. Where's the justice there? JIG (wajig + gjig): unified frontend to many APT and DPKG executables (apt-get, apt-cache, dp... - http://www.reddit.com/r/Ubuntu/comments/a71cf/jig_wajig_gjig_unified_frontend_to_many_apt_and/ - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Does OO Help's Find support an exact string search?
The entity you are looking for is, in fact, called a hyperlink. Among its parameters is the URL it points to and its representation in a document. Unfortunately, the designers of OOo decided to refer to its style when it has not been visited as an Internet Link and the style when it has been visited at a Visited Link. It is also true that entering either Internet Link or Visited Internet Link in the help find dialog does not find either entry. However, finding hyperlink leads to Editing Hyperlinks which contains the information you are looking for. (a different) John On Thu, Nov 19, 2009 at 11:00 PM, John Kaufmann kaufm...@nb.net wrote: In a message dated 2009.11.19 22:00 -0500, Charles T. Bell wrote: Seeking info on the automatic use of Writer's character style Internet Link, I went to OO's Help and did a Find on Internet Link - without the quotation marks, it should be noted, because Help's Find does not support the convention of quotation marks to indicate an exact string search - and that is the problem: Is there a way to Find an exact string like Internet Link? No. You can't find what isn't there. ? Nothing about: - Automatic adoption of certain character styles? - Internet Link [yes, I know elsewhere OO uses URL; naming consistency is not OO's strength]? Sorry, I don't understand: What is it that isn't there? - and if something is not there, how would one know before searching for it? You might try hyperlink which is the correct term for what you want ... Is it? (I don't think so.) You can look at adjacent thread [Character styles Internet Link and Visited Internet Link] for some idea of the questions I was searching for help on. Unless I'm missing something, what I was looking for is what I wanted. Thanks, John - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to insert cut cells in Cacl
I don't know that this is unique to OOo, since that's the way Excel (2000) works as well. I just tried it to refresh my memory, since I rarely use Excel anymore. However, in Excel, if you try to drag drop a column, you get a warning about replacing the data in the target column. In Calc, there is no warning. The moved column's data silently replaces the old column's data, leaving a blank column behind. John On Mon, Oct 19, 2009 at 10:27 AM, Steven Kopischke steven.kopisc...@sbcglobal.net wrote: Andreas Saeger wrote: Tony Li wrote: Dears, could somebody give the tips on how to insert cut cells in cacl, My requirement is: 1) Select on row / column in cacl, and click cut 2) Insert the cut row / column to another place like between column A and column B without overwriting the content in column B. One of the weaknesses of OOo is that you have to insert the rows/columns before cutting and pasting. SK - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Special formats in Base
You're doing nothing wrong, Arnold. The display format of the data is one thing and the data in the database is another. Why would you want to waste space in the database to store the parentheses, spaces and dash in the phone number when you can interpret it as you wish on output? John On Fri, Oct 16, 2009 at 7:47 PM, Arnold Roth aro...@socal.rr.com wrote: I have created a form to enter data where one of the fields is a telephone number. In setting up the table, I entered a custom format as (xxx)xxx-. This shows as I expected (area code in parentheses followed by the digits) in the format box. When I enter phone numbers in the form, they simply appear in the table as a string of numbers without the formatting. Can anyone tell me what I'm doing wrong? Thanks Arnold Roth - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Special formats in Base
Understandable. If you want to store the extra characters, as far as I know, you will have to make the fields in the database char or varchar fields and type the data in as you want to store it. I seem to recall that Access allowed one to specify storage of telephone numbers as formatted data, but I'm sure MySQL doesn't. I haven't worked with dBase or FoxPro in so many years that I don't know if either of them allow storage of formatted data. Perhaps someone else knows a way, but I rather think you'll have to type the entire text you want to save. Otherwise, you'll have to change your workflow to minimize editing raw data. John On Sat, Oct 17, 2009 at 3:35 PM, 71234.3...@compuserve.com wrote: Hi jomali, Why would you want to waste space in the database to store the parentheses, spaces and dash At least in my case, because I often modify data in the raw stored database format, and it is easier if the format is easy to read, and storage space and computer speed to scan it are now _very_ cheap. I'm mostly speaking of use in dBase and FoxPro as I am just slowly learning / converting to OO Base. Bob
Re: [users] Inserting check boxes in Writer
What's wrong with inserting a frame, anchoring it as a character, aligning it to the middle, giving it a border as you desire and a size as you desire? John On Fri, Oct 16, 2009 at 4:26 PM, AG computing.acco...@googlemail.comwrote: I am designing a check-list that I will be using as hard-copies. I would like to have tick boxes next to text, as a means of recording different aspects or parameters (e.g. check all that apply, out of a range of options). Thus far I have attempted this through experimentation with different paragraph and character formatting options, but nothing has worked. In MS Word, it was possible to insert a tab space, highlight that space and then frame it using some formatting option (I can't remember which) and an empty box or oblong would result. I am looking for something similar. Any ideas? TIA AG - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: [openoffice] [users] Photos in DataBase
On Fri, Sep 25, 2009 at 11:28 PM, John Kaufmann kaufm...@nb.net wrote: In a message dated 2009.09.06 19:54 -0500, Keith Bates wrote: On Sat, 2009-09-05 at 13:47 -0700, Susan Wallace-Masse wrote: ... I am transcribing a cemetery and I need to be able to attach one or more photos to each entry I make. How do I do this? There is a tutorial on this at: http://sheepdogguides.com/fdb/fdb1imag.htm Keith, I'm not the OP, but I took a look at this, and am immediately lost: After a bit of preliminary pleasantries discussing the bird photos, the author launches right into And now for the data entry for... - which presumes an pre-existing database and tables. I feel like I walked into the middle of a discussion. Did I miss something? John - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org I don't understand your comment. I visited the link and found that the author gives detailed instructions for setting up the database before the sentence you cite. I don't see how you missed that material, or how you dismiss it as preliminary pleasantries. He gives enough information for even the least instructed on using Base to follow his tutorial. John
Re: [users] Possible to put Writer document in body of email?
On Tue, Sep 22, 2009 at 5:27 AM, Dotan Cohen dotanco...@gmail.com wrote: 2009/9/18 Barbara Tobias barbtobia...@gmail.com: I'm using Ubuntu Linux, OOo 3.1.1, and Evolution for email. When I click on the email option from writer, it does bring up an email compose window, but the Writer document is an attachment. Is there a way to specify that the Writer text should be in the body of the email? Thanks. Barbara As other posters mentioned, you can copy and paste the text from Writer to Evolution. However, you will loose all formating. If you need the formatting, you could export the document to HTML, check that it still contains the critical formatting, and then use the HTML as an HTML mail. It would be nice if there were a way to automate this. -- Dotan Cohen That's odd. I copy and paste from Writer to gmail frequently and the formatting comes along with the text. I just tried it in Apple's Mail and formatting also accompanied the pasted text. Since OSX is Unix based, it must be an Evolution problem. Maybe another mail client would work differently. John
Re: [users] Possible to put Writer document in body of email?
On Tue, Sep 22, 2009 at 4:24 PM, James Knott james.kn...@rogers.com wrote: jomali wrote: That's odd. I copy and paste from Writer to gmail frequently and the formatting comes along with the text. I just tried it in Apple's Mail and formatting also accompanied the pasted text. Since OSX is Unix based, it must be an Evolution problem. Maybe another mail client would work differently. John It might also depend on whether you're sending HTML or plain text. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Well, yes. Dotan's original message spoke of losing formatting, which would only be relevant if you were sending HTML. Plain text, by definition, has no formatting. John
Re: [users] openoffice send mail
On Sun, Sep 20, 2009 at 9:34 PM, M Henri Day mhenri...@gmail.com wrote: snip Lars, given that I have a so-called «broadband» connexion, rather than a dial-up, I can't see any advantages for me in using an email client rather than directly loading my webmail provider. If you know any way of configuring OOo to directly send a document as an attachment in (in my case) Gmail, rather than taking a detour via Swiftdove/Thunderbird, I'd be most grateful to hear it !... Henri Henri, What you're asking for is an e-mail client to be incorporated into OOo. As I recall, this has been asked for many times before, but the developers don't seem to want to use their time developing something that is already available in already mature open source applications like Thunderbird and Seamonkey. Thus, whether you like it or not, to send an e-mail message from OOo, you will have to use one of the open source e-mail clients, configured to use Gmail as its default account. It's very easy to do, and has no downside except having to download and install the desired client. John
Re: [users] search for numbered item by number
On Mon, Sep 21, 2009 at 8:20 AM, David B Teague davidbtea...@verizon.netwrote: TomW wrote: David B Teague wrote: TomW wrote: David B Teague wrote: SNIP SNIP. These numbers for which I am searching are generated by OpenOffice.org, and you cannot highlight them, nor copy them to the clip board. And in my experience regular expressions don't find them. BTW I never did find how to do this in MS Word either. I was hoping it might be possible here in some simple way. David - My apologies to all. I do not know what I was thinking when I came up with that response. Too many projects! Too little time! And DSL connection from hell!!! TomW Tom: Thanks for the apology. I assume that I didn't make myself clear when there is confusion, so I was not put out in any way. And I understand the troublesome DSL connection. I spent my first year of DSL with a connection that went up and down like a yo-yo. I still would like to be able to do search for OO.o numbered list items by list number. This comes up frequently in making a local copy of Wikipedia articles by copy and paste to OO.o. There the reference numbers are in the text but the reference numbers are generated by OO.o. While the links work on the web pate, they don't refer to the copied list in the OO.o copy. Any help from anyone? Even an answer that This isn't possible. would almost be welcome. Then I might make a request for feature. Warmest Regards David - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org David, I think what you are asking for is similar to the many requests for a reveal codes feature and for the ability to search for hard paragraph breaks. All such requests assume that there are characters in the document that contain the numbers or represent the hard break or that there are embedded codes that control the structure of the document. However, if I understand the document structure correctly, it is really an XML document represented in a complex data structure in memory. If you were to try to search an HTML file for the numbers in the line items in an ordered list element, you would have a similar problem because the numbers are not generated until the document is displayed. I imagine one could design a search engine that was aware of the document structure, but I'm not aware of any projects that attempt to do so. Perhaps if you tried on the developers list to ask about such an ability you would get a better answer than from us mere users. John
Re: [users] Database indexes
Hi, Bob, Generally, you can have as many as you need. No, you don't have to delete your ID index. In fact, you have to have a primary index in order to enter any data at all. All additional indexes (indices?) do is to make ordering faster when you order on the index parameters. For a name and address database, with only a few records (less than thousands) you are unlikely to experience any performance improvements by creating additional indexes. Unless you are processing many records at a time many times a day, don't bother making additional indexes. Just use ORDER BY clauses in your sql statements and be done with it. John On Fri, Sep 18, 2009 at 1:59 PM, Bob Williams li...@barrowhillfarm.org.ukwrote: Hi, How many indexes can a database have? I have created a simple, flatfile, name and address type database. Each entry has an auto-incremented ID number, which was set as the primary index in the design stage. Now that I've got some records in there, I'd like to index it on Lastname then Firstname in A-Z ascending order. Do I have to delete the ID index, which is called SYS_IDX_46, first? Will this activate my new 'Names' index automagically? Thanks, Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.1, Kernel 2.6.27.25-0.1-default, KDE 4.3 Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Database indexes
Precisely. If you aren't familiar with sql, just use the wizard. It will prompt you for sort order. If you edit your form to use the query rather than the basic table, it will be sorted as specified in the query. John 2009/9/18 Bob Williams li...@barrowhillfarm.org.uk Hi John, Many thanks for speedy response. At the moment, my data entry form is based on the (single) table. To get it to automatically display records in sorted order, I should create a query and base the form on that? Bob On Friday 18 September 2009 19:14:00 jomali wrote: Hi, Bob, Generally, you can have as many as you need. No, you don't have to delete your ID index. In fact, you have to have a primary index in order to enter any data at all. All additional indexes (indices?) do is to make ordering faster when you order on the index parameters. For a name and address database, with only a few records (less than thousands) you are unlikely to experience any performance improvements by creating additional indexes. Unless you are processing many records at a time many times a day, don't bother making additional indexes. Just use ORDER BY clauses in your sql statements and be done with it. John On Fri, Sep 18, 2009 at 1:59 PM, Bob Williams li...@barrowhillfarm.org.ukwrote: Hi, How many indexes can a database have? I have created a simple, flatfile, name and address type database. Each entry has an auto-incremented ID number, which was set as the primary index in the design stage. Now that I've got some records in there, I'd like to index it on Lastname then Firstname in A-Z ascending order. Do I have to delete the ID index, which is called SYS_IDX_46, first? Will this activate my new 'Names' index automagically? Thanks, Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.1, Kernel 2.6.27.25-0.1-default, KDE 4.3 Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.1, Kernel 2.6.27.25-0.1-default, KDE 4.3 Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to sort mixed alpha numbers?
Sure, go ahead. I'd be glad to look at it. John On Wed, Sep 16, 2009 at 8:10 PM, NoOp gl...@sbcglobal.net wrote: On 09/15/2009 07:34 PM, jomali wrote: Put the formula =MID(A1;FIND( ;A1);LEN(A1))+0 in Cell B1. Extend down as far as your data in Column A goes. Sort on column B Voila! John I'm having trouble figuring that out... wouldn't be the first time :-) Would it be OK if I emailed you the spreadsheet so that you can try with the original? Gary - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to sort mixed alpha numbers?
Put the formula =MID(A1;FIND( ;A1);LEN(A1))+0 in Cell B1. Extend down as far as your data in Column A goes. Sort on column B Voila! John On Tue, Sep 15, 2009 at 6:30 PM, NoOp gl...@sbcglobal.net wrote: On 09/12/2009 01:51 AM, Bob Estes wrote: NoOp wrote: On 09/09/2009 08:35 PM, NoOp wrote: I've tried every combination that I can think of (even formating cells to text) and still cannot figure out how to sort via a column with data like this: Sail Number USA 84 USA 604 USA 275 USA 35024 USA 103 USA 116 USA 38747 USA 72 USA 40 USA 87549 USA 41001 USA 52 USA 28719 Any suggestions? Thanks to all that offered suggestions... I'll have to give them a try when I'm back from sailing on Monday. Gary (NoOp) I found a way that works reasonably well. First, I copied the list into column B of a Calc spreadsheet with each entry on its own line. I then deleted the USA from each row and reinserted it in column A. As part of the test, I added a couple of entries each for UK and AUS numbers. I then selected the data to be sorted. I then selected DATA/SORT, Sort by column A then by column B. On the options tab, I then selected Enable natural sort. Clicking on OK sorted the data first by country and then by number. This was an alphabetical sort instead of an ASCII sort which is what I think you wanted. This sounds like a long procedure, but it took me longer to write up the explanation than it did to do the sort. I hope this helps. Bob Thanks all. The regatta is over so now I'll have time to experiment. What I did (the night before the regatta) was copy the data from a web page (http://www.big-boat-series.com/Event/CurrentEntries.aspx) and pasted into Calc. I had hoped to sort by sail numbers so that I'd have an easy reference list as the boats come around my marks (I work on-water Race Committee). Turns out I survived without it, but I still want to figure out the sort puzzle for future situations. A 96 boat list isn't that hard to manipulate, but anything larger might require a macro if I can't figure out a simple way to do it with the sort feature. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Export to PDF: not all pages same size / dimensions
I don't know what computer or OS you are using, but on my Mac OS 10.5, the document has consistent page sizes in Preview and in Adobe Reader. Thus, I have to conclude the document is OK, but the application reading the document is not. John On Tue, Aug 11, 2009 at 4:37 AM, Dotan Cohen dotanco...@gmail.com wrote: Often I find that PDF files created in Writer do not have consistent page sizes or dimensions. See in particular this file: http://www.lsemuse.co.uk/sites/default/files/the-muse-2009.pdf Is there a way to force consistent page sizes? Thanks. -- 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] Writer: Highlight row
Shift + End Triple click on the line. John On Fri, Apr 3, 2009 at 7:50 AM, Dotan Cohen dotanco...@gmail.com wrote: In OOo 3.0 Writer, how can a user highlight the current row of text with a keyboard shortcut? Specifically, I intend to use this with lists, for highlighting a list item. Thanks. -- 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] Writer: Highlight row
You're quite right about the shift+end combination. I didn't know of your need to be anywhere in the line. How about using Home to go to the beginning of the line, followed by Shift+end to select the whole line. I'm on a Mac, and I'm sure I have also used the same triple-click on a PC. What system are you using that prevents you from multiple clicking? In every system I've used, single click selects an insertion point, double click selects a word, and triple click selects the line. I hope this helps. John On Fri, Apr 3, 2009 at 10:38 AM, Dotan Cohen dotanco...@gmail.com wrote: Shift + End That's what I've been doing, but it only highlights the entire line if the cursor is at the beginning of the line. Triple click on the line. I can't even double click! -- 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] Writer: Highlight row
On Fri, Apr 3, 2009 at 10:51 AM, Dotan Cohen dotanco...@gmail.com wrote: You're quite right about the shift+end combination. I didn't know of your need to be anywhere in the line. How about using Home to go to the beginning of the line, followed by Shift+end to select the whole line. Naturally, I make sure that I am at the beginning of the line. But I ask to know if there is a way to highlight the current line directly. I'm on a Mac, and I'm sure I have also used the same triple-click on a PC. What system are you using that prevents you from multiple clicking? In every system I've used, single click selects an insertion point, double click selects a word, and triple click selects the line. I'm using Kubuntu, but it is not my computer that is preventing me from multiple clicking. It is manual disability. I'm sorry, Dotan, I was unaware of your disability. I am also unaware of any other direct way to select the current line using the keyboard. Of course, clicking on the beginning of the line and dragging downward will select that line would work, but I'm sure you were aware of that alternative already. Is that method incompatible with your disability? -- 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] Re: Bug?
On Tue, Mar 10, 2009 at 12:40 AM, JOE Conner joeconner2...@gmail.comwrote: Joe Smith wrote: snip I must admit, it took me a looong time to get used to typing semicolons instead of commas, like every other function syntax I've ever used. I still find myself tripping over it. I would be very happy to see OOo accept commas in the user interface when the effective locale would allow it, but it strikes me as opening a Pandora's box of complexity and bugs. Joe Partly my grief with commas in OxygenOffice is that the accompanying help files for formulas do not show commas but rather have semicolons. That is why =IF( ISNUMBER(A1) , IF(A1=0 , , A1), ) works, where =IF( ISNUMBER(A1) ; IF(A1=0 ; ; A1); ) fails and is in compliance with IF function help files and ISNUMBER help files. Joe Conner, Poulsbo WA USA To Joe and Joe: Just my two cents: 1) If you've used languages like C, C++, Perl, Java, Javascript, etc., you should have no problem with using semicolons as statement separators. Excel uses its own convention, which OOo does not follow. 2) If you choose to use a non-standard port like OxygenOffice, why are you complaining to the OpenOffice user list? If OxygenOffice wants to change the OpenOffice convention, it is free to do so, but it should provide its own help files to document the changes. John