[users] Re: ! ESSEEPOHJAA KAIVATAAN !
2011/10/15 anne risku risku.a...@gmail.com: Hei! Asikirjamalleissa ei ole esseepohjaa, siis pohjaa, missä on kansisivu, sisällysluettelo, seuraavat sivut sivunumerollisia leipätekstisivuja (alaken 1, 2, 3, jne.). Yritin itse tehdä seuraavan tyylisen esseepohjan, mutta siistä EI TULE MITÄÄN!! Olen tuhrannut openoffice esseepohjan tekemiseen viisituntia!! Voisitteko lähettä minulle esseepohjan, johon saisinliitettyä tekstini, niin saisin palautettua esseen opettajalle ajallaan. Olisi todella hienoa, jos saisin pohjan jo maanantaina 17.10.2011, kiitos! This mailing list is in English only. I tried to translate your text to Swedish with Google translate, but unfortunately too many words remained untranslated, so I didn't understand much of it. I don't know if you are one of those people in Finland (6%?) who speaks Swedish, but if you are, and if English is a problem for you, then you could try to write to the Swedish OpenOffice.org mailing list (if there is no Finnish list, that is). Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: file excel con macro
2011/10/10 rmamm...@alice.it: Non riesco a far funzionare correttamente file di excel con macro. Il fine si apre ma non funziona correttamente Vad snackar du om? Du vet väl att det är engelska som gäller här? -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Help with writing macro
2011/9/20 Grzesiek Sójka p...@sojka.co: Hi there. I need to write a macro accepting variable length parameter list. I was tryint to googl but no luck. So the question is how to write (preferably in OpenOffice Basic) macro accepting variable length parameter list. Thanks in advance for any help Can you give an example? I'm not sure what you mean by ”accepting variable length parameter list”. What is the user supposed to do and what is the macro supposed to do with it? Is the macro supposed to run in Calc, Writer or what? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Help with writing macro
2011/9/21 Grzesiek Sójka p...@sojka.co: On 09/21/11 17:08, Johnny Rosenberg wrote: Can you give an example? I'm not sure what you mean by ”accepting variable length parameter list”. I do need to get some kind of statistic-like data. So I can not make any assumptions on the number of the results specified. Lets say that my macro is called MACRO. It should be possible to put in the spreadsheet cell something like: =MACRO(A13;D15;C1) and also: =MACRO(A2;D1) Then our MACRO should return some kind of numerical data calculated using all the values from all the cells specified. For the star it may be for example the sum of all values. What is the user supposed to do and what is the macro supposed to do with it? Is the macro supposed to run in Calc, Writer or what? It should be used in Calc. I haven't done this myself, but I would try to use ”Optional” and ”IsMissing”, something like this: Function MyFunction(A As Double, Optional B As Double, Optional C As Double) As Double ' Some code If IsMissing(B) Then ' Do something EndIf More code End Function Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: vlookup question
2011/9/10 Wade Smart wadesm...@gmail.com: On Sat, Sep 10, 2011 at 14:15, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/9/10 Wade Smart wadesm...@gmail.com: Im trying to figure out how to make that work. on Tab 2 = teams. ColumnA Row 12 - 14 = number of players ColumnB Row 12 - 14 = Player Jersey Number Player name ColumnC I put a 1 next to the captain Comumn D - the next team Ok. On Tab 1 = Game form. H10 = I type in the Home team (ex: 1) K10 = I type in the Away team (ex: 4) K18 is my vlookup. =VLOOKUP($E18,$Teams.$A$12:$N$26,($H$10+1),0) So it looks at which team Ive put down and then gets that roster of players. So, from ColumnC above - if I insert that column, when I type in say 2 on my game form, its only going to pull a 1 because that is the captain column. Im not sure how to get around that yet. And where is your conditional formatting? You did explore [Format → Conditional formatting], didn't you? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help Well, I didnt get to the conditional formatting because of the vlookup layout problem that I posted above. Okay, then I guess I don't understand your question. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: vlookup question
2011/9/10 Wade Smart wadesm...@gmail.com: Im trying to figure out how to make that work. on Tab 2 = teams. ColumnA Row 12 - 14 = number of players ColumnB Row 12 - 14 = Player Jersey Number Player name ColumnC I put a 1 next to the captain Comumn D - the next team Ok. On Tab 1 = Game form. H10 = I type in the Home team (ex: 1) K10 = I type in the Away team (ex: 4) K18 is my vlookup. =VLOOKUP($E18,$Teams.$A$12:$N$26,($H$10+1),0) So it looks at which team Ive put down and then gets that roster of players. So, from ColumnC above - if I insert that column, when I type in say 2 on my game form, its only going to pull a 1 because that is the captain column. Im not sure how to get around that yet. And where is your conditional formatting? You did explore [Format → Conditional formatting], didn't you? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Libreofice better than OpenOffice
2011/9/5 Debdipta Ghosh debdipta1...@gmail.com: Hi, I am a Linux user and a great believer of open source software and its development. I have been using Openoffice since 2006. But currently I found a new OSS LibreOffice which is much more better than open office. Such as Open office takes more time to open than Libreoffice When I first tried LibreOffice I timed that, and on my computer OpenOffice.org was quicker. I haven't done that recently though, so maybe things changed since. OpenOffice hangs more than Libreoffice Neither of them hang on my system, but LibreOffice crash sometimes. Fronts are better in LibreOffice Both use the system fonts on my machine. LibreOffice is more user friendly. None of them are user friendly if you ask me. But none of them are terrible either. Thanking you, Debdipta Shouldn't this have been posted to the LibreOffice user's list, rather than here? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Date ??
2011/9/4 Irv [K3IRV] McWherter irv4...@gmail.com: Hi All: I have a date problem. The OO ensemble does not seem to allow a date choice of DD/MM/YY. I have some documents that I must submit in this format, but I cannot find it in the cell format selection, nor can I figure out how to do it otherwise. Can anyone out there help me before you leave? What are your language settings? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Many thanks, Irv. -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: I'm having trouble creating a formula, can anyone help?
2011/8/29 Randy Barrett iatepaintch...@comcast.net: I'm trying to make a formula where lets say cell A1 has a number without a formula. In cell H1 I want to make a formula that follows these guidlines. A1 H1 0-99 0 100-199 1 200-299 2 300-399 3 400-499 4 500-599 5 600-699 6 700-799 7 800-899 8 900-999 9 1000+ Platinum is it possible and how do i do it? If the number to be evaluated is in A1 and the result is in H1, then type the following in H1: =IF(A1=1000;Platinum;INT(A1/100)) Example: A1=563 ⇨ H1=5 A1=1328 ⇨ H1=Platinum Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: HELP - Keyboard Shortcuts
2011/8/18 Dustin Beckham dustinrbeck...@gmail.com: To Whom It May Concern: I need to assign some keyboard shortcuts that are not listed with the available keyboard shortcuts. I wish to assign Ctrl+. (period) and Ctrl+, (comma) to navigate between worksheets in Calc. I do not wish to use the predefined Ctrl+PgUp and Ctrl+PgDn because those buttons do not work on my laptop (old). Nor do I wish to use any other available preset available shortcuts. Please help. Thank you for your time and assistance. Dustin Beckham Open Office User That's probably impossible, but let's wait and see if someone has a suggestion that actually works. Good luck. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: RegEx to Add HTML Codes to CSV
2011/8/18 Mike Scott m...@scottsonline.org.uk: On 18/08/2011 04:44, tambl...@gmail.com wrote: On Tue, 16 Aug 2011 22:30:38 -0500, tambl...@gmail.com wrote: Can someone help me figure out the find and replace for this? I've imported a CSV into a spreadsheet (migrating a site from Wordpress to Joomla). The field for the posts has newline characters, which won't be automatically converted to paragraph HTML tags by Joomla as they were in Wordpress. So, basically, I need to put ap tag at the beginning of each paragraph, and a/p tag at the end of each paragraph. I thought this would be easy, and found the regex info in the help file, but every time I try to run it, I'm told that the beginning or end of the paragraph isn't found. It's not finding \n, either. I do have the Regular Expressions and Current Selection Only boxes checked. Is it looking for Writer paragraphs? Is there something else I should be searching for in Calc? I can always edit each post to add these tags if I have to. There are only 500 or so of them, but I'd really like to avoid that. :-) I've since found out that the problems with this are due to the limitations of find/replace in Calc. Does anyone know how to work around it? Thanks! Not an OOo solution, but I find perl is good for this sort of thing. You could preprocess your csv before importing into Calc. Or you could simply use sed in a terminal. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: RegEx to Add HTML Codes to CSV
2011/8/18 Mike Scott m...@scottsonline.org.uk: On 18/08/11 09:48, Johnny Rosenberg wrote: So, basically, I need to put ap tag at the beginning of each paragraph, and a/p tag at the end of each paragraph. I thought this would be easy, and found the regex info in the help file, but every time I try to run it, I'm told that the beginning or end of the paragraph isn't found. It's not finding \n, either. I do have the Regular Expressions and Current Selection Only boxes checked. Is it looking for Writer paragraphs? Is there something else I should be searching for in Calc? ... Not an OOo solution, but I find perl is good for this sort of thing. You could preprocess your csv before importing into Calc. Or you could simply use sed in a terminal. True, not that that comes as standard with windows. He doesn't say what OS he's using. (Besides, I've never really got my head round sed :-) Given perl's portability and its flexibility in pattern matching, it's my own tool of choice for anything from one-off one-liners to OS maintenance scripts to well, whatever.) Well, I'm so tired of asking people what operating system they are running, so I just give the answers that I would like myself if I asked the same question. If the operating system is not mentioned I assume that he or she has the same operating system as me. So why I suggested sed is that it's pre-installed if your operating system is the same as what I've got, and he didn't say otherwise in his original post. Even if he runs Windows, maybe someone else having the same problem can find the solution in sed, who knows? By the way, sed can be installed in windows, at least 32-bit: http://gnuwin32.sourceforge.net/packages/sed.htm But I haven't tried it myself since I don't have Windows. On the other hand, if you are going to install sed, you could rather install Perl instead… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] OpenOffice.org Basic – Arrays as parameters in functions
Let's say I have this array: Type MyType A As String B As Long End Type Sub Main Dim MyArray(0) As MyType, i As Long ' A lot of stuff going on For i=1 To Something ReDim Preserve MyArray(i).A=getStuffFromSomewhere() MyArray(i).B=getStuffFromOuterSpace() Next i ' More stuff going on for quite a while End Sub So I have a big array of my own type. Now I want a function to do things based on the contents of MyArray. I know I can do this: Function MyFunction(AnArray As Variant) ' Do things End Function So my question is, if I don't want to use the parameter-as-variant method, is there another way? I guess I could do something like the following: Function MyFunction(AnArray(Something) As MyType) ' Do things End Function The problem is that ”Something” is just that, something, not a known value. Using the variant trick seems to be cheating to me… Is it the only way to go, really? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Basic – Feeling stupid…
For years I have emptied arrays by just setting each element to 0 with For loops. That's time consuming for big arrays and today when I was looking at some old code I wrote a couple of years ago I ran into those lines, and I thought that there must be a much better way to do this, so I started thinking… And yes, of course there is! How many times didn't I scratch my head when my array is suddenly empty when I forgot ”Preserve” in ReDim? So why not just forget it by purpose…? Here's my example code: REM * BASIC * Option Explicit Sub Main Const MaxElements=100 ' Create an array. Dim A(1 To MaxElements) As Integer Dim i As Long ' Fill the array with some data. Randomize For i=1 To MaxElements A(i)=Rnd*1000 Next i ' Empty the array. Dim Time As Long Time=GetSystemTicks() For i=1 To MaxElements A(i)=0 Next i Print GetSystemTicks()-Time ' Fill it again. For i=1 To MaxElements A(i)=Rnd*1000 Next i ' Empty it again. Time=GetSystemTicks() ReDim A(1 To MaxElements) As Integer Print GetSystemTicks()-Time End Sub Running this, two message boxes (from the Print command) pops upp. Typically the first one displays around 14000 (14213 when I tested a few seconds ago) and the second one around 600 – 800 (797 in this case, 638 is the lowest value so far). After trying a couple of times it seems like the ReDim statement is about 20 times faster than the For loop. It doesn't really matter for small arrays, but the ReDim is a one-liner, For requires three lines. So now I feel really stupid that I didn't think of this before… By the way, the getSystemTicks() function seems to return the time in ms, at least on my system (did some experiments with it a while ago). Try this one, for example: REM * BASIC * Sub Main Dim A As Long, B As Long, C As Long A=getSystemTicks() Wait 100 B=getSystemTicks() Wait 100 C=getSystemTicks() Print A, B, C End Sub Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: MS Word Alternative
2011/7/30 paul whitehill whitehill_p...@yahoo.com: Hi i wonder if you can help me. I wonder that too… the alternative seems to have a charge £1.59 but it says it is free. What alternative and to what? OpenOffice.org is free if you download it at http://www.openoffice.org/. No charge what so ever, as long as you download it yourself. Is the open office Writer the same as MS Word ? No. If it was, it wouldn't be free. This is the software I want to type up a document, can you help me ? Well… download it from http://www.openoffice.org/, install it, run it and start typing… Don't forget to use Styles from the beginning. It will save you a lot of time later. There is built in help which is sometimes helpful. If not, ask specific questions here. Are there any software clashes, Say i want to send a document attached to my e.mail, will it Open in all systems? Yes, as long as support for ODF is installed (like OpenOffice.org, LibreOffice, AbiWord, ODF-plugins for MS Office and so on). If the receiver doesn't have to edit your document, you can always send it as a PDF. Thanks, please answer my questions Regards, Paul Whitehill. -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: operating problem
2011/8/4 Roy Commander r...@talktalk.net: Hi I have been using Open Office for a number of years as a private individual. Suddenly it fails to work,I cannot access my files or open Open Office files without being asked to register which I have done on a number of occasions only to be back to no access, I have also tried uninstalling and reinstalling all to no avail. Can you help please I am a retired pensioner. Thanks Roy Commander UK Maybe if we know what you've got. What version of OpenOffice.org? What operating system (and version)? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: to Open Office or Libre Office from a google doc
2011/8/1 Helen etter...@gmail.com: I use google documents to make spreadsheets that I need to share. When it's time to print, I copy the contents of the spreadsheet, open a new blank document in LibreOffice calc, and paste. It makes a mess. Is there any way to keep the info in the correct cells? I could print from google, but google docs have limited formatting options, and I'd like to use the more versatile formatting options of OO/LO. Using Linux, suse 11.4, LibreOffice 3.3.1 Thanks much, -- Helen Etters using Linux, suse11.4 Did you try to download the document and then open it with OpenOffice.org/LibreOffice? Does it look better? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: auto correct
2011/6/27 Robert Kingett kingettb...@gmail.com: Does anyone have anyway to import my Microsoft word autocorrects with my open office? Depends on how Microsoft Word save them. OpenOffice.org saves them at ~/.openoffice.org/3/user/autocorr/acor_xx-XX.dat, where xx-XX is you language and country, for example acor_sv-SE.dat in my case (Swedish-Sweden) or acor_en-GB.dat for British English. This is a zip file which contains a few xml files among other things. One of them is called DocumentList.xml and it looks like this (I omitted all posts except one of them): ?xml version=1.0 encoding=UTF-8? block-list:block-list xmlns:block-list=http://openoffice.org/2001/block-list; block-list:block block-list:abbreviated-name=M2 block-list:name=m²/ /block-list:block-list If the Word autocorrection list is available in some kind of text format it's probably possible to convert it with an OpenOffice.org macro or with a Bash script or with almost any kind of script. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Fwd: Re: Binary Math Functions Question
2011/6/10 JOE Conner joeconner2...@gmail.com: On 6/10/2011 1:55 PM, JOE Conner wrote: You're welcome. By the way, did it work…? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email tousers-unsubscr...@openoffice.org For additional commands send email tosy...@openoffice.org with Subject: help SNIP Thanks again Johnny, your equasion =OR(AND(NOT(A1);B1);AND(A1;NOT(B1))) worked a treat, I am still mulling over the rest where you lead step by step through macro creation. I downloaded a copy of the Star Basic tutorial from http://api.openoffice.org/basic/man/tutorial/tutorial.pdf to study. A quick search of it did not show XOR as a key word, but perhaps I did not search it correctly. Well, as I showed you, XOR is already a function in OpenOffice.org BASIC, so it can not be used as a variable name. Or what would you say about an expression like ”XOR=XOR XOR XOR” (except that it is meaningless…)? What I want ultimately, is to be able to type something like ABCDE in cell A1 and type FGHIJ in cell B2 and in cell A3 type =XOR(A1;A2) and have a valid string on XOR'ed characters, A with F, B with G, C with H, D with I, and E with J. Thanks again. Joe You mean bitwise XOR of the character's codes (such as UTF-8, ISO 8859-1 or even ASCII)? Well, that would be a somewhat more complicated macro. What would you expect the result to be in that example of yours (ABCDE XOR FGHIJ)? Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Binary Math Functions Question
2011/6/8 JOE Conner joeconner2...@gmail.com: On 6/6/2011 2:14 PM, Johnny Rosenberg wrote: 2011/6/6 JOE Connerjoeconner2...@gmail.com: Is there any function for calc such that XOR can be used in the form such as =XOR(A1;B1) and put the result in the cell? No, but it can be added manually by writing it in OpenOffice.org Basic. Kind regards Johnny Rosenberg SNIP Thanks Johnny for that, but you give me far too much programming skill. For all, is not boolean arithmetic/algebra a part of the ODF specifications? Joe Conner, Poulsbo, WA USA -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help I am not an ODF- or OpenOffice.org/LibreOffice expert, but I guess you're right. Do you think the following is too complicated? =OR(AND(NOT(A1);B1);AND(A1;NOT(B1))) If there is no typo, it's equivalent with =XOR(A1;B1) (if XOR existed…), but I guess you already know that. Anyway, it's easy to make a function like this with OpenOffice.org BASIC, but you need to accept that the new function's name can not be XOR, because XOR is a keyword in OpenOffice.org BASIC, and can therefore not be the name of a function or a variable. So let's accept the name XR instead, or you can choose whatever you want as long as it's not a keyword. Now click Tools → Macros → Organize Macros → OpenOffice.org Basic… This brings up a dialogue box with three fields. One of them is ”Macro from”. Under ”My Macros” you'll find ”Standard”. Highlight it and click ”New”. Another dialogue pops up and you are expected to enter a name of a new module. Default name is ”Module1 which is not too exciting… I typed ”CellFunctions”. Hit OK and off you go…! The OpenOffice.org BASIC IDE thing opened and you can enter your Basic code, which will work in any spreadsheet from now on! Here's what I typed, you can copy it from here and just paste it in, if you like: REM * BASIC * Option Explicit Function XR(x As Boolean, y As Boolean) As Boolean XR=x XOR y End Function I don't know how much programming skill you have, but in case of zero I will explain every row now: REM * BASIC * This is just a comment and does nothing more than tell people that this is a BASIC macro. This is there by default so I didn't write it. You can delete it if you like. Option Explicit Means that you need to declare every variable you use, otherwise you will get nothing but error messages. This helps you to spell your variable names the same every time. Misspelled names of variables are often very hard to find, at least if your code is somewhat more complicated than this. Function XR(x As Boolean, y As Boolean) As Boolean This tells us that XR is a function which return value is Boolean. XR takes two parameters, x and y, and both of them are booleans. XR=x XOR y Returning a value in a BASIC function is done by assigning a value to the function's name. In this case, XR returns x XOR y. End Function This is, surprisingly enough, where this function ends… Okay, we wrote our own cell function, let's try to use it! Go back to the spreadsheet, enter FALSE in A1 and TRUE in B1. In C1, enter: =XR(A1;B1) Hit Enter. C1 should now display TRUE! So there you go! So now it's up to you to create your own XNOR, NAND and NOR functions! Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Binary Math Functions Question
2011/6/9 JOE Conner joeconner2...@gmail.com: On 6/9/2011 9:17 AM, Johnny Rosenberg wrote: 2011/6/8 JOE Connerjoeconner2...@gmail.com: On 6/6/2011 2:14 PM, Johnny Rosenberg wrote: 2011/6/6 JOE Connerjoeconner2...@gmail.com: SNIP Thanks Johnny for that, but you give me far too much programming skill. For all, is not boolean arithmetic/algebra a part of the ODF specifications? Joe Conner, Poulsbo, WA USA -- I am not an ODF- or OpenOffice.org/LibreOffice expert, but I guess you're right. Do you think the following is too complicated? =OR(AND(NOT(A1);B1);AND(A1;NOT(B1))) If there is no typo, it's equivalent with =XOR(A1;B1) (if XOR existed…), but I guess you already know that. Anyway, it's easy to make a function like this with OpenOffice.org BASIC, but you need to accept that the new function's name can not be XOR, because XOR is a keyword in OpenOffice.org BASIC, and can therefore not be the name of a function or a variable. So let's accept the name XR instead, or you can choose whatever you want as long as it's not a keyword. Now click Tools → Macros → Organize Macros → OpenOffice.org Basic… This brings up a dialogue box with three fields. One of them is ”Macro from”. Under ”My Macros” you'll find ”Standard”. Highlight it and click ”New”. Another dialogue pops up and you are expected to enter a name of a new module. Default name is ”Module1 which is not too exciting… I typed ”CellFunctions”. Hit OK and off you go…! The OpenOffice.org BASIC IDE thing opened and you can enter your Basic code, which will work in any spreadsheet from now on! Here's what I typed, you can copy it from here and just paste it in, if you like: REM * BASIC * Option Explicit Function XR(x As Boolean, y As Boolean) As Boolean XR=x XOR y End Function I don't know how much programming skill you have, but in case of zero I will explain every row now: REM * BASIC * This is just a comment and does nothing more than tell people that this is a BASIC macro. This is there by default so I didn't write it. You can delete it if you like. Option Explicit Means that you need to declare every variable you use, otherwise you will get nothing but error messages. This helps you to spell your variable names the same every time. Misspelled names of variables are often very hard to find, at least if your code is somewhat more complicated than this. Function XR(x As Boolean, y As Boolean) As Boolean This tells us that XR is a function which return value is Boolean. XR takes two parameters, x and y, and both of them are booleans. XR=x XOR y Returning a value in a BASIC function is done by assigning a value to the function's name. In this case, XR returns x XOR y. End Function This is, surprisingly enough, where this function ends… Okay, we wrote our own cell function, let's try to use it! Go back to the spreadsheet, enter FALSE in A1 and TRUE in B1. In C1, enter: =XR(A1;B1) Hit Enter. C1 should now display TRUE! So there you go! So now it's up to you to create your own XNOR, NAND and NOR functions! Regards Johnny Rosenberg ジョニー・ローゼンバーグ Thank you Johnny - both for your time and for your willingness to work up a detailed example and explanation. I do appreciate it Blessings, Joe Conner, Poulsbo, WA USA You're welcome. By the way, did it work…? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Binary Math Functions Question
2011/6/6 JOE Conner joeconner2...@gmail.com: Is there any function for calc such that XOR can be used in the form such as =XOR(A1;B1) and put the result in the cell? No, but it can be added manually by writing it in OpenOffice.org Basic. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ If there is not, is it projected to be added? If not, why not? If yes, then when? Thanks. Joe Conner, Poulsbo, WA USA -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: SUMPRODUCT() (just some thoughts, no question)
2011/6/2 Michael Adams linux_m...@clear.net.nz: On Friday 03 June 2011 00:56, Johnny Rosenberg wrote: Maybe this would rather be sent to the Discuss list, but I thought that this could be a hint for other people who didn't know about the SUMPRODUCT() function for some strange reason… Go on Johnny, it's not a tutorial without an example. Else it's just a trumpet blow. -- Michael Well, I can give an example similar to the one that I solved with SUMPRODUCT(). Let's say that every time we bought something we enter all the details about it in a spreadsheet. The fields could be: Date Name of the thing we bought (like Milk, Toaster or whatever) Some kind of amount, like weight, volume or something What we paid Some kind of category of the product, like food, clothes and office More things, could be almost anything… On another spreadsheet we want to keep track of how much money we spend on food the last month, so I set up a table with 28-31 rows depending on which month we are studying. If it is 2011-06-03 today, the table would start at 2011-05-04 and end at 2011-06-03. To calculate how much money we spent on food we now need two conditions to be fulfilled for every row: Date and Category. Let's say that we use the A column for date and the sheet were we have our data is called ”Data”, then B8 could look something like this: =SUMPRODUCT(Data.A2:A10=A8;Data.D2:D10=Food;Data.F2:F10) In this made-up example (which I did not test, so I hope there are no typos in it…), the Data sheet has date in column A, Categories in column D and Cost in column F. So what it does, is simply to add every thing in column F (well, at least row 2 until row 10) for all the rows where column Data.A match A8 (which is a date) and where column Data.D match the word ”Food”. One thing I miss though, is something that I could do in Excel. In Excel ”A:A” means ”the whole A column”. I haven't found an easy way to do that in LibreOffice (or OpenOffice.org). Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: This is a confirmation email that you have subscribed to the
2011/6/2 H.-Dieter Viel h.-dieter.vi...@freenet.de: What giantly elephant shit is Open Office?? I wanted to know why it´s impossible to register with my email address because always I get the message Invalid signature, valid examples include: OpenOffice 3.1 on Windows Vista / NeoOffice 2.2.3 with MacOS 10.4 / OpenOffice 2.4 on Ubuntu 9.04 Please note that you will need to enter a valid e-mail address before your account is activated. You will receive an e-mail at the address you provide that contains an account activation link. I want to ask a question in the forum and this is impossible because of s. a. Now I get all messages by all users. That's the point of all mailing lists. What can I do with this? Nothing! With that attitude you can't. Otherwise you could unsubscribe. Kill my submit!!! Hammurabi -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] SUMPRODUCT() (just some thoughts, no question)
It's unbelievable. Since 1999 I have used Excel/OpenOffice.org/LibreOffice quite a lot, almost daily. I consider some of my spreadsheets somewhat advanced with macros and long formulas doing some fancy stuff… Today I accidently ran into the SUMPRODUCT() function and found that it's exactly what I really needed for all those years! How could I manage without it? Until today I could, but now I reached the limits of the combination My brain + No SUMPRODUCT() function… So I started to search the Internet for how to solve a problem that I had, which I couldn't solve with SUMIF or other functions and I found some SUMIF examples. The last example of one web page was however a SUMPRODUCT() example which solved my problem very easily. I could even remove three entire columns in my spreadsheet, every one of which included some complex formulas… I guess the lack of knowledge of the SUMPRODUCT() function forced me to learn quite a few other functions, workarounds and tricks… Maybe this would rather be sent to the Discuss list, but I thought that this could be a hint for other people who didn't know about the SUMPRODUCT() function for some strange reason… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Hot question, need advice (Linux2MacOSX)
ons 2011-03-23 klockan 22:09 +0600 skrev Павел Субач: I live in Russia, and set Russian preferences, but i try switch comma in configuration, can't do this (switch ok, but not effect). Ok, i will save as non CSV format, but how i can remove E and show full 19 symbols decimal ? (0,001). Need for work, show traffic and analyzing it... -- All the best. From Pavel V Subach Tell me EXACTLY what you are doing when you try to import that CSV file. Are your operativsystem set to Russian in every aspect? Do you use comma for decimal separator in Russia? Exactly what does those scientific numbers look like? Is it like ”1E-19” or ”1e-19” or is there a space somewhere, like ”1 e-19” or similar? -- Best regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Hot question, need advice (Linux2MacOSX)
mån 2011-03-21 klockan 21:46 +0600 skrev Павел Субач: Hot question: - How to remove E and show full length decimal number ?? - How to convert .009 - 0,009 when import in calc from CSV format ??? In previous version, but for Linux (OpenOffice 3.1), it was perfect show my decimal with 19-20 zero after zero, without E (decimal has anything size) And convert .009-0,009 use English(USA), when import document But all is it won't work in LibreOffice 3.3 and OpenOffice 3.3 for MacOSX I have Ubuntu 10.10 (Linux), OpenOffice.org 3.3.0 and LibreOffice 3.3.1. I created a simple CSV using my text editor, Gedit and I opened it in OpenOffice.org and LibreOffice. I selected English (USA) and I also tried English (GBR) and it worked properly in both cases: The decimal points were converted to decimal commas, which is correct in my case, since my system is set to Swedish, and we use decimal commas here. So I don't know what you are doing wrong, but it works as expected for me. -- Best regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: How to make AutoFilter act more like Excel's Autofilter
Den 2011-03-09 19:29:38 skrev Andy Graybeal andy.grayb...@casanueva.com: Hello, My organization is trying to move from MS Office to OpenOffice (or it might be read, I'm trying to convince everyone to move from MS Office to OpenOffice in an effort to move our business to use only open source software). We're using OpenOffice 3.2.0 on Ubuntu 10.04. One of my co-workers regularly uses Excel's (2003, if I remember correctly) Autofilter feature, and she has a different experience with OpenOffice's Autofilter. Here are the steps taken in Excel: * Select a row * We go to: Data - Filter - Auto Filter * Dropdown boxes appear for every column * We select an item from the dropdown box; this lists only the items that have been filtered, and it gives her the chance to make a subtotal in one of the empty row below the filter results. Here are the steps taken in OpenOffice: * Select a row * We go to: Data - Filter - Auto Filter, it informs and asks us that The range does not contain column headers. Do you want the first line to be a column header? We select Yes from the dialog box. * Dropdown boxes appear for every column * We make a selection from a dropdown box; this lists the filtered items and other information. She doesn't get the chance to make a subtotal in an empty row below the filter results. Can you help us approach the situation? Should we be doing things differently? What is a column header and would assigning this help us? Thanks, Andy ”…it gives her the chance to make a subtotal…” Since I don't have Excel I would probably need to know exactly HOW this happens, to be able to answer the question. Is she asked in a dialogue box or what? Anyway, subtotals are usually calculated with the SUBTOTAL() function, so she can always put it in a cell manually. -- Kind regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Multiplication
Den 2011-03-09 13:51:19 skrev Dan Lewis elderdanle...@gmail.com: Comment inline. On Wed, 2011-03-09 at 13:38 +0100, Sigrid Carrera wrote: Hello, On Sun, 6 Mar 2011 15:20:26 -0600 Dick Smith rpsmith...@neb.rr.com wrote: Can you give me a simple example of multiplying one Column (B), all lines on worksheet times 80% for all lines Column (C) amounts? Let me try what you want to do. You might have work hours in column B, hourly pay in column C and the company you're billing to has an agreement, that you only charge for 80% of the total cost? Is this idea correct? If so, what you would want to enter in either A1 or D1 is: =B1 * C1 * 0,8 In the United States this equation is = B1 * C1 * 0.8 (Sigrid lives in a part of the world where the use of commas and periods is the opposite of how the US does it. We write 1,003.25. and Others write 1.003,25. These numbers are the same. Hope this helps too.) Dan There are more variants as well, like the one I prefer: 1 003,25. If you want to be able to change the percentage quickly you should enter it in a separate cell before your actual data. Say your percentage entry is in cell A1, then the formula changes as follows: =B1 * C1 * $A$1 The $ signs fix the entry for the cell, so if you copy the formula to other cells, the reference for A1 stays the same, while B1 and C1 change. Hope this helps. Sigrid -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help -- Kind regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: How do I count the ways....
Den 2011-03-06 06:35:32 skrev Allen netsecur...@sound-by-design.com: I feel sure that I've done this but don't recall how as it has been a while. I have a column of text entries, how do I count the number of cells that are blank and how many have entries? In one column, all the text entries are the same but in other columns there are a wide variety of different texts. All I need is that there are, for example, 27 blank and 126 that have text in them. I don't need the contents, just the number that have contents. OO 3.1 LibreOffice 3.3.1/XP SP3 thanks, Allen This one counts cells that are not empty: =COUNTA(CellRange) I can't find the English name for the one that counts empty cells, but it is ANTAL.TOMMA() in Swedish… could be something like ”COUNTEMPTY()” or ”COUNT.EMPTY()”. You can look for it by selecting a cell and then hit Ctrl+F2. -- Kind regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: How do I count the ways....
Den 2011-03-06 09:50:08 skrev Johnny Rosenberg gurus.knu...@gmail.com: Den 2011-03-06 06:35:32 skrev Allen netsecur...@sound-by-design.com: I feel sure that I've done this but don't recall how as it has been a while. I have a column of text entries, how do I count the number of cells that are blank and how many have entries? In one column, all the text entries are the same but in other columns there are a wide variety of different texts. All I need is that there are, for example, 27 blank and 126 that have text in them. I don't need the contents, just the number that have contents. OO 3.1 LibreOffice 3.3.1/XP SP3 thanks, Allen This one counts cells that are not empty: =COUNTA(CellRange) I can't find the English name for the one that counts empty cells, but it is ANTAL.TOMMA() in Swedish… could be something like ”COUNTEMPTY()” or ”COUNT.EMPTY()”. You can look for it by selecting a cell and then hit Ctrl+F2. Found it! =COUNTBLANK(CellRange) -- Kind regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Calc: Calculating Time Totals for a Time Card
Den 2011-02-28 10:00:54 skrev Amichai Rotman amic...@iglu.org.il: Hello, I have a Calc spreadsheet I use to keep track of time, kind of a time card. I use the 24 Hrs. format. I have a Sheet for each client for the current month (so it would include 31 rows maximum, not including the first one used for the headers): Column A has the Start Time (i.e.: 09:15) Column B has the End Time (i.e.: 13:25) Now, I want Column C to have the total time for each row, and another cell to have the total time spent for this client that month (say, H3) I guess I'd have to sum the total for C2:C32, but I can't figure out how to calculate it as time and what to put as a formula in H3. Thanks! Amichai. You just sum as usual. Format the result as time, for example HH:MM or [HH]:MM. One hour is defined as 1/24 of a 24 hour period (”dygn” in Swedish… does other languages also have a word for this? English seems to lack one…), so 8 hours=1/3≈0.… If you enter 12:00 into a cell, it will probably display like that, but if you then format it as 0.000 it will display as 0.5. I just mentioned this so that you will easily realise that you can just sum and subtract times like all other kinds of numbers. Things like =B3+B4-B5 will give an expected result if B3:B5 contains time data, for example. -- Kind regards Johnny Rosenberg -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
Re: [users] Re: Calc- reference a bunch cells into 1 cell?
Den 2011-02-19 02:35:20 skrev Harold Fuchs hwfa.gmanen...@gmail.com: Johnny Rosenberg gurus.knu...@gmail.com wrote in message news:op.vq397ls0xqd8ry@pb-laptop... Den 2011-02-18 21:56:45 skrev . pe...@aleksandrsolzhenitsyn.net: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My spreadsheet has a tiny monthly calendar on it that has 1 cell for each day. So, it has 7 columns across and 8 rows down. When you select the cells it has a range like this- A1:G8 Erm. Sorry, but where you live do months have 56 days? I think you should have removed my name above, since you removed everything I wrote. Someone would maybe think that I wrote the text above, otherwise. Not a big deal, I just wanted to point out that I didn't write anything of the above, as far as I can see. Thanks. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Printing large Calc sheet on 1 page?
Den 2011-02-19 13:20:01 skrev . pe...@aleksandrsolzhenitsyn.net: Is there an easy and simple way to print a large Calc sheet, that normally prints on 3 letter sized pages, on one page? Format → Page… → Sheet (or whatever it says, ”Tabell” in Swedish anyway – the last tab) or Preview → Page format → Sheet Only reply if you know how to do it. Ok, do you mind if I use this thread to tell a funny story…? Ok, I get it, I won't… -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc- reference a bunch cells into 1 cell?
Den 2011-02-18 21:56:45 skrev . pe...@aleksandrsolzhenitsyn.net: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My spreadsheet has a tiny monthly calendar on it that has 1 cell for each day. So, it has 7 columns across and 8 rows down. When you select the cells it has a range like this- A1:G8 I want to put the contents of cells A1 to G8 into 1 cell on different sheet in the same file. It can be done by; - - Selecting and Copying A1:G8 - - Pasting it into Writer (at this point it appears like a graphic that you can rescale) - - Copying it from Writer and pasting it into the single cell using Paste Special- GDI metafile That works well but there's got to be an easier way. Any ideas? I am just curios; why would you want to do something like that? I would guess (and yes, it's only a guess, nothing more) that nobody ever wanted to do that before, so there is no special feature for it. Again, only a guess… One possible solution would be to write a macro for it. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] like a nested IF
Den 2011-02-17 14:35:47 skrev Wade Smart wadesm...@gmail.com: I have a column that will have 10 possible words in it. Each word is assigned a number. I have another column which calculate those words based on the numbers. So, A1 is (Beginner, Recreational, Highschool, College, Experienced, etc). Beginner = 1, Rec = 2 etc. So in say B1 I want it to say 2 if I write Rec. I was trying nested IFs but thats very complex. Any ideas? Wade I would have made a list on a new sheet with two columns, like this: Beginner 1 Recreational 2 and so on. Then, on the first sheet, I would have used VLOOKUP() in column B. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] like a nested IF
Den 2011-02-17 20:15:00 skrev Wade Smart wadesm...@gmail.com: On 02/17/2011 12:47 PM, Wade Smart wrote: On 02/17/2011 09:43 AM, Johnny Rosenberg wrote: Den 2011-02-17 14:35:47 skrev Wade Smart wadesm...@gmail.com: I have a column that will have 10 possible words in it. Each word is assigned a number. I have another column which calculate those words based on the numbers. So, A1 is (Beginner, Recreational, Highschool, College, Experienced, etc). Beginner = 1, Rec = 2 etc. So in say B1 I want it to say 2 if I write Rec. I was trying nested IFs but thats very complex. Any ideas? Wade I would have made a list on a new sheet with two columns, like this: Beginner 1 Recreational 2 and so on. Then, on the first sheet, I would have used VLOOKUP() in column B. Ok so in F2 I have Rec, or will have as each cell is filled in, and in G2 it needs to red 2. L2 = Beginner M2 = 1 L3 = Rec M3 = 2 So if I want G to have a number in it from what I write in F, I put the lookup in G2. Wade Ok. Got that working :D Now, I have about 500 of these rows to do. How do I get the lookup column to increase to each cell without it offseting where its getting its data from? If you hold the bottom right corner and drag, it will increase all the cells by one in the function. I just wrote about that a monite ago, hopefully you received it. Good luck! -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] like a nested IF
Den 2011-02-17 19:47:10 skrev Wade Smart wadesm...@gmail.com: On 02/17/2011 09:43 AM, Johnny Rosenberg wrote: Den 2011-02-17 14:35:47 skrev Wade Smart wadesm...@gmail.com: I have a column that will have 10 possible words in it. Each word is assigned a number. I have another column which calculate those words based on the numbers. So, A1 is (Beginner, Recreational, Highschool, College, Experienced, etc). Beginner = 1, Rec = 2 etc. So in say B1 I want it to say 2 if I write Rec. I was trying nested IFs but thats very complex. Any ideas? Wade I would have made a list on a new sheet with two columns, like this: Beginner 1 Recreational 2 and so on. Then, on the first sheet, I would have used VLOOKUP() in column B. Ok so in F2 I have Rec, or will have as each cell is filled in, and in G2 it needs to red 2. L2 = Beginner M2 = 1 L3 = Rec M3 = 2 So this is your list with words and numbers right? I would suggest you to sort them so the L column is in alphabetic order first. So let's assume that you have your list, it is ten words and numbers and it is located at L2:M11. So if I want G to have a number in it from what I write in F, I put the lookup in G2. You need it in every row in the G column, starting from G2 (I assume, I guess you use row 1 for headings or something like that, right?), going as far down as you wish. Now, place your cursor in G2 and press Ctrl+F2. This brings up the formula guide. You can now, in an easy way, create your formulas. So find VLOOKUP in the field to the left and double click it. Now you can fill in some fields that represents the parameters of the VLOOKUP() function. The first field is what we want to search for, in this case whatever is in cell F2, so click on the cell F2. If it is hidden under the dialogue, then click the button to the right of the field to make the dialogue hide a bit. Now click the F2 cell if you diodn't before, and then click that button again, to the right of the input field. The second parameter determines where we will search, which is our L2:M11 range, so place the cursor in that field and then select that range with the mouse. Next parameter is called Index, and it determines in which column of our cell range we will find our number, in this case 2. 1 means the the first column in the selected range, in this case L, but we want our result from the M column, so that's why 2 is the proper value here. All fields which names are bold are required. The next one, ”Sorted”, is not bold, so we only need it in some cases. Place the cursor there and you will see a short description about what it does and how to use it. As you can see, we don't need it since our cell range is sorted. Place your cursor in one of the other fields and you should now see the result in that dialogue. Click OK. So now we have a working formula in G2, but there will be some problems when we copy our formula to other cells. One of the more serious problems is that if we copy to G3, L2:M11 will now be ”converted” to L3:M12. So we need to go back to G2, press F2 and select (highlight) L2:M11 with the mouse. Now press Shift+F4 and the range address will be ”converted” to $L$2:$M$11, which means that the address won't changed when formula is copied to other cells. Don't do this with the first parameter though, since we want it to adapt when copying it. Now copy the cell downwards. You will now notice that if nothing is entered in one or mote of the rows in the F column, the corresponding row in the G column will display en error message. We don't want that, so edit the G2 formula again to this: =IF(F2=;;VLOOKUP(F2;$L$2:$M$11;2)) This makes sure that if F2 is empty, G2 will remain empty. Now copy the formula downwards again, and it should work as expected, hopefully. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: OpenOffice.org Calc: Can't find a cell function that returns a cell range.
Den 2011-02-08 23:30:16 skrev Andreas Säger ville...@t-online.de: Am 08.02.2011 19:35, Johnny Rosenberg wrote: Doesn't seem that any of these does what they are supposed to do. Could anyone else test this? Why does virtually nobody ever post any formula? Yes, the formuals I posted do work for me in any spreadsheet program Calc, Excel and Gnumeric likewise. OFFSET(C4:D5 ; -1 ; -2 ; 3 ; 4) returns A3:D5 This one returns A3:D5 which is 12 cells. Returning 12 values by a single formula requires an array formula. Otherwise you get #VALUE. But you wanted to get a SUM from a calculated range: SUM(OFFSET(C4:D5 ; -1 ; -2 ; 3 ; 4)) returns a single value, the sum of A3:D5 Aaah, yes, of course. I just misunderstood the whole concept. I thought that the OFFSET() formula would display the address in the cell, which does not make much sense now, when I think about it… Thanks! The other examples return a single cell reference should work as is. You are probably right. :) -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OpenOffice.org Calc: Can't find a cell function that returns a cell range.
Den 2011-02-09 10:32:02 skrev yahoo-pier_andreit pier_andr...@yahoo.it: Il 08/02/2011 22:54, Johnny Rosenberg ha scritto: Den 2011-02-08 20:58:16 skrev yahoo-pier_andreit pier_andr...@yahoo.it: Il 08/02/2011 18:02, Johnny Rosenberg ha scritto: What I want is a cell function like ADDRESS(), but instead of a reference to a single cell, I want a reference to a cell range. ADDRESS(1;1;1) ⇨ $A$1 ADDRESS(2;2;4) ⇨ B2 I would like something like this: RANGEADDRESS(1;1;1;2;2;4) ⇨ $A$1:B2 Can't find such a function, though. What do I miss? Can I use ADDRESS() in some combination to obtain this anyway? Here is a quick example of what I'd like to do: =SUM(RANGEADDRESS(A1;B1;C1;D1;E1;F1)) try this: ADDRESS(1;1;1):ADDRESS(2;1;1) $A$1:$A$2 Well, I'm not looking for only displaying an address, I want to use it for something, for example =SUM(ADDRESS(1;1;1):ADDRESS(2;1;1)) doesn't work. try this: =SUM(indirect(ADDRESS(1;1;1):ADDRESS(2;1;1))) That works, but I found a way that I think is even easier: =SUM(INDIRECT(AD1+1:$A$29)) In this case I want to use different start cells depending on values in cells in column D. Thanks all, for all suggestions! -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] OpenOffice.org Calc: Can't find a cell function that returns a cell range.
What I want is a cell function like ADDRESS(), but instead of a reference to a single cell, I want a reference to a cell range. ADDRESS(1;1;1) ⇨ $A$1 ADDRESS(2;2;4) ⇨ B2 I would like something like this: RANGEADDRESS(1;1;1;2;2;4) ⇨ $A$1:B2 Can't find such a function, though. What do I miss? Can I use ADDRESS() in some combination to obtain this anyway? Here is a quick example of what I'd like to do: =SUM(RANGEADDRESS(A1;B1;C1;D1;E1;F1)) -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: OpenOffice.org Calc: Can't find a cell function that returns a cell range.
Den 2011-02-08 18:30:54 skrev Andreas Säger ville...@t-online.de: Am 08.02.2011 18:02, Johnny Rosenberg wrote: What I want is a cell function like ADDRESS(), but instead of a reference to a single cell, I want a reference to a cell range. ADDRESS(1;1;1) ⇨ $A$1 ADDRESS(2;2;4) ⇨ B2 I would like something like this: RANGEADDRESS(1;1;1;2;2;4) ⇨ $A$1:B2 Can't find such a function, though. What do I miss? Can I use ADDRESS() in some combination to obtain this anyway? Here is a quick example of what I'd like to do: =SUM(RANGEADDRESS(A1;B1;C1;D1;E1;F1)) OFFSET and INDEX return cell ranges from a start range and positional numbers. You calculate a text from positional numbers. That text is the same as quoted =$A$1 in a formula. It is just a sequence of letters, digits and dollars. The reference is only in your head. INDIRECT tries to convert such strings into references. The following expressions return a reference to A1: OFFSET(A1;0;0;1;1) INDEX(A1:X999;1;1) INDIRECT(ADDRESS(1;1)) OFFSET is the most versatile and easy to use (0 rows off, 0 columns off, resized to 1 row and 1 column). OFFSET(C4:D5 ; -1 ; -2 ; 3 ; 4) returns A3:D5 (1 up, 2 to the left, 3 rows, 4 columns) I just read the help about this and it seems to be what I’m looking for. Now there's only one minor problem: It doesn't work… #VALUE! I have OpenOffice.org 3.2.0 Swedish (the OFFSET function is called FÖRSKJUTA in Swedish). It works with addresses like ”A1”, that is single cells, then it returns the value of the target cell. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: OpenOffice.org Calc: Can't find a cell function that returns a cell range.
Den 2011-02-08 18:30:54 skrev Andreas Säger ville...@t-online.de: Am 08.02.2011 18:02, Johnny Rosenberg wrote: What I want is a cell function like ADDRESS(), but instead of a reference to a single cell, I want a reference to a cell range. ADDRESS(1;1;1) ⇨ $A$1 ADDRESS(2;2;4) ⇨ B2 I would like something like this: RANGEADDRESS(1;1;1;2;2;4) ⇨ $A$1:B2 Can't find such a function, though. What do I miss? Can I use ADDRESS() in some combination to obtain this anyway? Here is a quick example of what I'd like to do: =SUM(RANGEADDRESS(A1;B1;C1;D1;E1;F1)) OFFSET and INDEX return cell ranges from a start range and positional numbers. You calculate a text from positional numbers. That text is the same as quoted =$A$1 in a formula. It is just a sequence of letters, digits and dollars. The reference is only in your head. INDIRECT tries to convert such strings into references. The following expressions return a reference to A1: OFFSET(A1;0;0;1;1) Output: 0 INDEX(A1:X999;1;1) Output: 0 INDIRECT(ADDRESS(1;1)) Output: 0 OFFSET is the most versatile and easy to use (0 rows off, 0 columns off, resized to 1 row and 1 column). OFFSET(C4:D5 ; -1 ; -2 ; 3 ; 4) returns A3:D5 (1 up, 2 to the left, 3 rows, 4 columns) Doesn't seem that any of these does what they are supposed to do. Could anyone else test this? -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OpenOffice.org Calc: Can't find a cell function that returns a cell range.
Den 2011-02-08 20:58:16 skrev yahoo-pier_andreit pier_andr...@yahoo.it: Il 08/02/2011 18:02, Johnny Rosenberg ha scritto: What I want is a cell function like ADDRESS(), but instead of a reference to a single cell, I want a reference to a cell range. ADDRESS(1;1;1) ⇨ $A$1 ADDRESS(2;2;4) ⇨ B2 I would like something like this: RANGEADDRESS(1;1;1;2;2;4) ⇨ $A$1:B2 Can't find such a function, though. What do I miss? Can I use ADDRESS() in some combination to obtain this anyway? Here is a quick example of what I'd like to do: =SUM(RANGEADDRESS(A1;B1;C1;D1;E1;F1)) try this: ADDRESS(1;1;1):ADDRESS(2;1;1) $A$1:$A$2 Well, I'm not looking for only displaying an address, I want to use it for something, for example =SUM(ADDRESS(1;1;1):ADDRESS(2;1;1)) doesn't work. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc month and year together?
Den 2011-02-02 03:33:47 skrev . pe...@aleksandrsolzhenitsyn.net: On 02/01/2011 11:26 AM, Michael D. Roush wrote: On 2/1/11 11:13 AM, . wrote: How do I get Calc to put any year (listed in cell A1) and the month (listed in B1) into C1 so that it would look like this; January 2011 Given that you have 2011 in cell A1, and January in cell B1, the correct formula for cell C1 would be: =CONCATENATE(B1; ;A1) This will take the text from B1, put a space after it, and then the text from A1. Result... January 2011. Michael Perfect! Thank you so much. Which is the same thing as: =B1 A1 The character offers a way to ”concatenate” things without using the CONCATENATE function syntax. A matter of taste, I suppose. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Open Office.Org- 2 programs
Den 2011-02-01 23:26:11 skrev Hanna170 theresad...@yahoo.com: I noticed that when I am in a spreadsheet and I want to create a word doc I have to close the spreadsheet. I cant work in 2 separate programs at one time or am I just trying to open the second program incorrectly ?? Please respond asap. Thank you so much, Theresa Nelson I am not sure what you are doing, but I just tested this myself with OpenOffice.org 3.2.0 (for Linux) and there was no problem to open an odt, one odg and two ods at the same time, and I don't think there is an obvious limit involved. Exactly how do you try to create a new document? Please explain in as much detalils as possible. What do you do and exactly what happens? Error messages? Exactly what do they say? What operating system do you use and what version? What version of OpenOffice.org? -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc month and year together?
Den 2011-02-01 17:13:10 skrev . pe...@aleksandrsolzhenitsyn.net: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 How do I get Calc to put any year (listed in cell A1) and the month (listed in B1) into C1 so that it would look like this; January 2011 Please don't reply unless you know exactly how to do it. In A1, you have, for example, 2011 and in B1 the text ”January”, is that the starting point of this problem? If so, type this into C1: =B1 A1 Is B1 rather a number, like 1 for January or 9 for September? Then do the following: In C1, enter the following: =DATE(A1,B1,1) Right click C1 → Format cells… → Numbers → Enter the following into the Format description field: Click OK. I have Swedish OpenOffice.org, so things might be named differently than the above description, so you probably need to use your imagination a bit, perhaps… -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] openoffice ?
Den 2011-01-31 15:59:08 skrev Robert Allen robertallen...@yahoo.com: i simply wanted to see an example of a document - ANY DOCUMENT - in your program and after spending approximately 20 minutes of searching and finding nothing but explanations of how things work and how great things are could still NOT find a single example - is it necessary to have to go through the entire download installation simply to see an example of a document in this not really that open of an open office doc? Maybe because there's nothing to show? It can look just like anything, it depends on so many other things than OpenOffice.org itself, like which fonts you use and so on. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Shortcuts for special characters
Den 2011-01-24 07:09:10 skrev John Jason Jordan johnjas...@gmail.com: On Sun, 23 Jan 2011 09:42:55 +0100 Johnny Rosenberg gurus.knu...@gmail.com dijo: It has been a long time since I used Word, but I recall all you did was type Alt, then the letter combination (e.g., a:), and it automatically converted the letter combination. If the Alt was not followed by one of the built in letter combinations, then the Alt was ignored. I've looked everywhere, but I can't find such a feature in Writer. I find this surprising. In Unix-like operating systems you have the Compose key (at least if your desktop environment is Gnome), which is useful for things like this. What you do is that you define a Compose key (I use the otherwise useless Caps Lock for that, but other options are available). It works like this: Press your Compose key → release it → press → release → press O → release → the result is Ö. Looks complicated, but just try it. You need to press three keys to create an Ö or any of the other characters, like á, ë, œ, Ø, ø and so on. This is what I was looking for. I assumed it would be in OOo, but this is even better because it is system-wide. I use Gnome on Fedora 14, but I have never looked at the keyboard settings. Using your suggestion I changed the useless Windows key to a compose key and now I can get the diacritics I need. The only things I am lacking are ¿, and ¡. I can't figure out what the secret key is to get those. ¿ = Compose ? ? ¡ = Compose ! ! E.g., for á I type press the Windows key, type an apostrophe and then the a. The Windows compose key turns the apostophe into a dead key for the acute accent, so the secret key is the apostrophe. But I can't figure out what the secret keys for ¿ and ¡ are. There must be a table somewhere in the Gnome documentation, but I can't find it. http://www.hermit.org/Linux/ComposeKeys.html Thanks for the information! ¡You're welcome! -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Shortcuts for special characters
Den 2011-01-24 17:19:01 skrev M Henri Day mhenri...@gmail.com:
2011/1/24 John Jason Jordan johnjas...@gmail.com
On Mon, 24 Jan 2011 15:12:37 +0100
M Henri Day mhenri...@gmail.com dijo:
2011/1/24 John Jason Jordan johnjas...@gmail.com
On Sun, 23 Jan 2011 09:42:55 +0100
Johnny Rosenberg gurus.knu...@gmail.com dijo:
It has been a long time since I used Word, but I recall all you
did was type Alt, then the letter combination (e.g., a:), and it
automatically converted the letter combination. If the Alt was not
followed by one of the built in letter combinations, then the Alt
was ignored.
I've looked everywhere, but I can't find such a feature in
Writer. I find this surprising.
In Unix-like operating systems you have the Compose key (at least if
your desktop environment is Gnome), which is useful for things like
this. What you do is that you define a Compose key (I use the
otherwise useless Caps Lock for that, but other options are
available). It works like this: Press your Compose key → release it
→ press → release → press O → release → the result is Ö.
Looks complicated, but just try it. You need to press three keys to
create an Ö or any of the other characters, like á, ë, œ, Ø, ø and
so on.
This is what I was looking for. I assumed it would be in OOo, but
this is even better because it is system-wide.
I use Gnome on Fedora 14, but I have never looked at the keyboard
settings. Using your suggestion I changed the useless Windows key to
a compose key and now I can get the diacritics I need.
The only things I am lacking are ¿, and ¡. I can't figure out what
the secret key is to get those. E.g., for á I type press the Windows
key, type an apostrophe and then the a. The Windows compose key
turns the apostophe into a dead key for the acute accent, so the
secret key is the apostrophe. But I can't figure out what the
secret keys for ¿ and ¡ are. There must be a table somewhere in the
Gnome documentation, but I can't find it.
John Jason, on my 105-key standard Scandinavian keyboard with Ubuntu
10.10 installed, «¡» is obtained by holding the «Alt-Gr» key down and
pressing «1» (on my keyboard, «Shift + 1» gives «!») and «¿» by doing
«Alt Gr + Shift + +» (on my keyboard, «Shift + +» gives «?»). Hope
this helps !...
Apparently the Alt-Gr key is enabled when you select the Scandinavian
keyboard. With the US keyboard it is not, but as I discovered you can
set it to any key in System Preferences Keyboard Layouts
Options. I could have set it to the right Alt key, but I decided to use
the otherwise useless Windows key instead.
As it turns out I finally found the solution. I type the Windows key
*plus the shift key*, then the ? key (which requires shift again).
Ditto for the ¡.
I finally found the table I was looking for. I don't know why the Gnome
people didn't include it in the Help, but here it is:
http://hermit.org/Linux/ComposeKeys.html
There are lots of other things you can do with the Compose key.
As a matter of fact, I generally use the right-hand MS key as the compose
key on my 105-key keyboard, for example if I want to type «š» or «č», but
for the two glyphs you mentioned, «Alt Gr» works by default. In any
event,
good you resolved the problem !...
Henri
There are many possible solutions for this problem. Another one is to
create your own keyboard layout, which I did. It is available as ”Sweden –
Johnny Rosenberg” when I select Swedish for language or Sweden for
country. Here's my layout, just in case anyone's interested:
Row 1: §!#@%/()=+´
Shift+Row 1: ☠☺”♯¤‰|₍₎≈?`
AltGr+Row 1: ☏¡@£$¥{[]}\´
Shift+AltGr+Row 1: ℡☹“♮턌∵∴/⁽⁾≠¿`
Row 2: qwertyuiopå¨
Shift+Row 2: QWERTYUIOPÅ^
AltGr+Row 2: 턋ω€√τ♣♠ⁱ°π⌀~
Shift+AltGr+Row 2: 턉Ω¢®™♢♡ℹ∞℗⊕ˇ
Row 3: asdfghjklöä'
Shift+Row 3: ASDFGHJKLÖÄ’
AltGr+Row 3: ασðφγþ턆턇λøæ×
Shift+AltGr+Row 3: αΣÐ℉턞Þ턎턁턂ØƯ
Row 4: zxcvbnm,.-
Shift+Row 4: ZXCVBNM;:_
AltGr+Row 4: ≤ß☐℃♩βⁿµ¸…–
Shift+AltGr+Row 4: ≥턊☒©♩♭ⁿµ˛…—
AltGr+Tab: ⇥
Shift+AltGr+Tab: ⇤
AltGr+Enter: ↵
Shift+AltGr+Enter: ¶
AltGr+Backspace: ⌫
Shift+AltGr+Backspace: ⌫
AltGr+Arrow keys: ←↑↓→
Shift+AltGr+Arrow keys: ⬄↹↔⇨
AltGr+(Home End Delete Insert PgUp PgDn): ◂▸⌦✓▴▾
Shift+AltGr+(Home End Delete Insert PgUp PgDn): ◂‣⏏✔▴▾
Numpad: 0123456789,/*-+
Shift+Numpad: ±⅛¼⅜½⅝¾⅞⅓⅔.÷·⅚⅙
AltGr+Numpad: ₀₁₂₃₄₅₆₇₈₉⩽⅕⅗₋₊
Shift+AltGr+Numpad: ⁰¹²³⁴⁵⁶⁷⁸⁹⩾⅖⅘⁻⁺
That's it, I guess…
--
Kind regards
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Shortcuts for special characters
Den 2011-01-23 03:36:36 skrev John Jason Jordan johnjas...@gmail.com: On Sat, 22 Jan 2011 19:52:57 -0600 Barbara Duprey b...@onr.com dijo: On 1/22/2011 6:25 PM, John Jason Jordan wrote: OOo 3.2.1 (from OOo, no the repositories) on Fedora 14 x86_64. I've searched and I can't find how to set the shortcut keys for entering characters with accents, or what shortcut keys exist by default. E.g., I wish to type á, é, ü, etc. in an English document. I do not wish to change to a different keyboard. I can enter the characters by Unicode code point, but that is a pain if you have a lot of them to do. The default shortcuts would probably suffice if I could just figure out what they are. I cannot search the Help because any searches in Help crash OOo. (Crash report already sent.) I haven't had to deal with this, but how about an AutoCorrect that substitutes the special character given a character pair (or triplet) that would not ordinarily occur? I can remember long ago something where if you typed u: (for example), it would create the umlauted u. I thought of that, but I don't want AutoCorrrect to change the combination all the time. What if I want to type: 1. The correct item for the task would be a: (a) frying pan, (b) stew pot, etc. In the above the a: would get converted to ä. I found an extension called Compose Special Character, but it takes almost as many keystrokes as just typing the Unicode value. It has been a long time since I used Word, but I recall all you did was type Alt, then the letter combination (e.g., a:), and it automatically converted the letter combination. If the Alt was not followed by one of the built in letter combinations, then the Alt was ignored. I've looked everywhere, but I can't find such a feature in Writer. I find this surprising. This seems to be a common problem for Windows users. I left Windows behind in summer 2007, which solved most of the problems I had, but there is no reason to do that only for a minor problem like this one… In Unix-like operating systems you have the Compose key (at least if your desktop environment is Gnome), which is useful for things like this. What you do is that you define a Compose key (I use the otherwise useless Caps Lock for that, but other options are available). It works like this: Press your Compose key → release it → press → release → press O → release → the result is Ö. Looks complicated, but just try it. You need to press three keys to create an Ö or any of the other characters, like á, ë, œ, Ø, ø and so on. But you have Windows, right? Then I can inform you that there someone wrote something called ”AllChars”, which ”emulate” the Unix-like Compose key. It also adds a feature similar to Autocorrect, but since it works on your whole system, it works everywhere: In OpenOffice.org, your text editor, your email program, web browser, you name it. Since a couple of years ago it's Open Source too. Unfortunately it looks like AllChars are no longer developed, so maybe it won't work in Windows 7, I don't know, but I am sure there are other projects out there that does approximately the same thing. There is something called ”AutoHotKey”, but I am not sure whether it does the Compose key thing or not. I did some searching and also found Accent Composer: http://www.accentcomposer.com/ Maybe worth a try. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - printing rows on every page
Den 2011-01-09 02:11:52 skrev Brewster Gillett b...@fdi.us: On Sun, 2011-01-09 at 01:45 +0100, Johnny Rosenberg wrote: I ran into a few other bad bugs with the Ubuntu-version of OpenOffice.org and finally I just couldn't stand it any more, so I kicked it out and installed the ”real” OpenOffice.org. Worked like a charm since then. I don't know if that would help in this very case, but I would certainly try. brewster: I guess that is a distinction of which I was not aware. Are you saying that Ubuntu is shipping a slightly different version from that which is available directly from OOo? That I should download the latest version directly from OOo and install it over the Ubuntu version? I am definitely not inclined to use RCs or betas. Just out of curiosity, is there a detectable rationale for Ubuntu's provision of a buggier version of OOo than Open Office itself ships? Brewster Well, the Ubuntu version is actually Go-oo (as far as I know) rather than OpenOffice.org. So is the case with other well known GNU/Linux-distributions as well, for example OpenSUSE and more. Go-oo has some advantages over OpenOffice.org, so maybe it's better for some users in some cases. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc - printing rows on every page
Den 2011-01-09 01:11:42 skrev Brewster Gillett b...@fdi.us: At 13:12 08/01/2011 -0800, Brewster Gillett wrote: I have explicitly followed the OOHelp instructions - FORMAT-PRINT RANGES-EDIT, done the instructed highlighting for the top two rows that I seek to have printed on every page, and have gotten the echo that is displayed on the help screen - $1:$2. But when I go to exit, I get a tiny popup that informs me: invalid sheet reference In searching the list of error messages for Calc, I find no specific mention of invalid sheet reference. I went back and attempted various combinations of A1 and A2, and kept getting the same message. What am I missing, here? Brian Barker wrote: Are you using OpenOffice version 3.1 as provided by/with Ubuntu? This appears to have been a bug in that version. See https://bugs.launchpad.net/openoffice-pkgs/+bug/374708 . brewster: My apologies for not including version and platform information - I should know better. Using Open Office 3.2 (build:9483) running under Ubuntu 10.04. I guess that I must assume that 3.1 bug was not fixed since it is still reproducing under my later lashup. barker: I trust this helps. Brian Barker brewster: Actually it helped on a couple of counts; I'd always rather find out that it's a bug instead of my lack of competence :-)... ... and your bug-blog link had a workaround that someone had discovered, that appears to do the trick. The lesson for me is that when a problem seems intractable or has no plausible explanation, check the bug reports first. Thanks, Brewster I ran into a few other bad bugs with the Ubuntu-version of OpenOffice.org and finally I just couldn't stand it any more, so I kicked it out and installed the ”real” OpenOffice.org. Worked like a charm since then. I don't know if that would help in this very case, but I would certainly try. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How do I open Microsoft WORKS 9 files in Open Office 3.2?
Den 2011-01-05 11:37:12 skrev Sigrid Carrera sigrid.carr...@googlemail.com: Hi, 2011/1/1 j art jart7d...@gmail.com: ? Please write next time your question in the body of your mail. And some sort of greeting would be nice too. :) To answer your question: As far as I know, OpenOffice.org cannot read MS Works files. If you have a Works installation somewhere, you can open your files there and safe in in .doc format. After doing this, you can read/edit the files with OpenOffice.org. Another possibility is, that you try the go-oo-version of OpenOffice.org or LibreOffice. I think I saw somewhere, that those two versions can read Works files - but I'm not 100 % sure about this. Sigrid Yes, this is correct. I have never tried it myself, but at least the Works files are in the list of file formats in Go-oo. If your operating system is some of the well known GNU/Linux distributions, like Ubuntu, OpenSUSE, Fedora and more, Go-oo is already installed (but it appears as ”OpenOffice.org”). -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Can OOo be used on a Mac?
2010/12/29 Earl Melton earlemel...@yahoo.com: I know absolutely squat about mac computers, but have a friend who wants to use OOo on one. When I searched for 'openoffice on mac' on the openoffice.org/ site, I found several inquiries similar to mine, but no answers. Has anyone been successful at this? And, if the answer is Yes, could you please share a link or specific 1-2-3-type instructions on how to go about it? It is a laptop with Mac OS X v10.5.8 -- Earl Yes. Just click the link that corresponds to your language and operating system here: http://download.openoffice.org/other.html#tested-full Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Can OOo be used on a Mac?
Den 2010-12-29 15:57:13 skrev Earl Melton earlemel...@yahoo.com: 2010/12/29 Earl Melton earlemel...@yahoo.com: I know absolutely squat about mac computers, but have a friend who wants to use OOo on one. When I searched for 'openoffice on mac' on the openoffice.org/ site, I found several inquiries similar to mine, but no answers. Has anyone been successful at this? And, if the answer is Yes, could you please share a link or specific 1-2-3-type instructions on how to go about it? It is a laptop with Mac OS X v10.5.8 -- Earl Yes. Just click the link that corresponds to your language and operating system here: http://download.openoffice.org/other.html#tested-full Johnny Rosenberg Thanks Johnny, I hadn't seen that exact page. The only two Mac options I saw listed were OS Intel and PowerPC. Would either of those likely work on his OS X? If he has an Intel processor he should download the Intel version, otherwise the PowerPC version is the right one. -- Earl -- -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] PDF
Den 2010-12-25 15:05:33 skrev David B Teague davidbtea...@comporium.net: On 12/24/2010 7:27 AM, Brad Rogers wrote: On Fri, 24 Dec 2010 17:16:08 +0530 Sam Swaminathsamitpfin...@gmail.com wrote: Hello Sam, I am not able open up Adobe PDF Files, as Adobe pop-up says 'that my trial run is over, now buy'. This pop-up is from Adobe Acrobat version 7. Is there any free version wherein I can open Adobe PDF Files sent by Mutual funds Credit Card Statememnts? If all you wish to do is _read_ the PDFs, you only need a reader, not the full Acrobat (which allows editing/creating PDFs). The reader is a free download from the Adobe site, and is not time limited in any way. I find that Foxit Reader is smaller, loads quicker, and is reputed to be safer than the Adobe product. I find that it has useful features that the Adobe reader does not. Try it, it is free, and I believe you will like it. I have no connection to the company or people who produce Foxit products. I'm just a satisfied user. --David Can Foxit open a PDF form and save it again when you filled it in? Adobe Reader can not do that, however I found recently that Evince can! :) -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Disappeared document
Den 2010-12-18 12:08:44 skrev cmsuijkerbu...@gmail.com: Dear sir/madam, I am an user of Open Office and with great pleasure, but now I have a problem: This morning I wanted to open a document in Recently opened documents, and to my surprise, the box was empty, while yesterday-evening, when closing down my computer, it was full. So far, that is inconveniant, but no harm done, you just start te document by selecting Opening Document. However the most important document I use, however still in the Document box on my computer, I cannot open the document any longer. All other documents can be openend, but that one. Can you please help? With kind regards, Kees Suijkerbuijk, Hoogerheide, The Netherlands Maybe you moved the file to another folder? -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] PDF Conversion
Den 2010-12-15 07:40:17 skrev Jean-Baptiste Faure jbf.fa...@laposte.net: Le 10/12/2010 19:39, Douglas Hinds a écrit : OO's ability to create pdf files is a valuable asset. However, the need frequently arises to convert pdf files to a editable format. Hi, PDF is not a document format intended to editing. If you need to modify such kind of document why not ask the author a copy of the original in editable format (.odt, .doc, etc.) ? So why does Adobe make their Acrobat program? A cassette tape was originally intended for speech only, not music, but a few decades later some manufacturers actually made some quite capable cassettes and decks, like TDK, Nakamichi and many others, and people used them for music as well, in fact I think the most common use was music. Things doesn't necessarily need to be what they were originally intended to be. And good luck to ask the authorities to send you editable copies of their stuff. I tried that a few years ago. They said that they have been thinking about uploading their documents in DOC (Microsoft) format. Well, that's better than nothing, but still today, a few years later, there is still only the PDF on their site. However, that was a PDF form thing (FDF?) and a few days ago I discovered that I can fill in those and save them with Evince, which was impossible a few months ago, I think. But that doesn't solve the OP's issue. Seems like he is looking for some kind of Linux equivalent of Adobe Acrobat, so the question is probably: Is there such a thing out there somewhere? Unfortunately the answer seems to be no. And yes, I know PDFimport extension, but it is useful only for very light modifications like to complete a form. Best regards JBF -- Best regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Issues
Den 2010-12-13 17:54:52 skrev Karla Kallenberg karla_kallenb...@hotmail.com: Hello, I have some major problem with my docs that i write in the Oppen Office prog. As u can see in the attatched file it allways appears ? % in the text when it is saved and opens upp again. How come, and how can as change it?? Best regardsKarla Kallenberg, if u may u can also reply in swedish. There is no attached file to your message. Attached files are often stripped off messages on this list. It's better to upload your file somewhere and then include a link to it in your message. Din bilaga kom aldrig fram. På e-postlistor som denna är det ganska vanligt att bilagor inte hänger med hela vägen. Det är bättre att ladda upp sin fil någonstans istället och sedan bifoga en länk till den i själva meddelandet. Du vet väl att det finns en e-postlista på svenska också? us...@sv.openoffice.org Vill man få svar på sina frågor måste man också registrera sig där först genom att skicka ett tomt meddelande till: users-subscr...@sv.openoffice.org -- Kind regards/Vänliga hälsningar Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: PDF Conversion
Den 2010-12-12 01:33:24 skrev RA Brown rabr...@the-martin-byrd.net: On Sat Dec 11 2010 14:45:54 GMT-0800 (PST) Douglas Hinds wrote: One more thing: My own posts are not returning (so I'm bbc-ing myself) and I'm wondering if this can be changed via my account's configuration. That is a Gmail thing. For some reason they figure that if you send it you do not need a copy. Go figure. Well, the Gmail idea is, as far as I know, that you are not supposed to delete anything, so everything you ever wrote or received is still searchable in Gmail and you can also find your written messages by clicking ”Sent messages”. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: Re[2]: [users] PDF Conversion
Den 2010-12-12 12:18:58 skrev Harold Fuchs hwfa.openoff...@googlemail.com: On 10 December 2010 20:43, Johnny Rosenberg gurus.knu...@gmail.com wrote: Den 2010-12-10 21:13:38 skrev Douglas Hinds douglas.hi...@gmail.com: Todd Goatley suggested: Try Adobe Reader. You can save the doc in text, then open it in OO. Thank you for your response, but: Adobe Acrobat Reader is a Windows Program There is a Linux version of Adobe Reader, I've used it for years. For Adobe Acrobat however, there is no Linux version as far as I know, but that was not what was suggested. snip Will Acrobat run under WINE? http://appdb.winehq.org/appview.php?appId=847 -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] PDF Conversion
Den 2010-12-10 19:39:44 skrev Douglas Hinds douglas.hi...@gmail.com: OO's ability to create pdf files is a valuable asset. However, the need frequently arises to convert pdf files to a editable format. I installed the extension OO offers for doing that but the results were not adequate. I no longer use Windows. Can anyone suggest a Linux Application (I'm running Mint - a version of Ubuntu) that would allow me to convert PDF files to a format editable in OO? Thanks in advance for your suggestions. What kind of ”editing” do you frequently want to do? If it is simple things like filling in a PDF form (FDF), you can use Evince. I discovered that the other day by accident… I know that it didn't work in earlier versions, but now it does (I use Evince 2.32.0). You can fill in some fields, save the document, open it again and continue editing the fields. You still can not do that in Adobe Reader though. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: Re[2]: [users] PDF Conversion
Den 2010-12-10 21:13:38 skrev Douglas Hinds douglas.hi...@gmail.com: Todd Goatley suggested: Try Adobe Reader. You can save the doc in text, then open it in OO. Thank you for your response, but: Adobe Acrobat Reader is a Windows Program There is a Linux version of Adobe Reader, I've used it for years. For Adobe Acrobat however, there is no Linux version as far as I know, but that was not what was suggested. Best regards Johnny Rosenberg , and Saving to a text file (equivalent to extracting the text) means that I lose both the graphics and the rest of the page formatting, which Is not really what I was hoping for. I was hoping for a faithful reproduction of the pdf file in an editable format. In Windows (a now obsolete OS) Solid Converter PDF does a good job of doing that, but I have not been able to run under Wine (I'm using TheBat! version 3.99 - an email client for win - to write this with - WineHQ informer me that version 4 won't run, but v. 3.x will). Other commercial pdf editors/creators include Foxit but I was hoping an opensource app was available (Ghostscript will extract to text but as I mentioned, that's not what I have in mind). In any case, than you for your response. Douglas Hinds Email: tgoat...@gmail.com Mobile mail: 7752230...@tmomail.com C: 775-223-0839 Sent from myTouch 4G - Reply message - From: Daniel Lewis elderdanle...@gmail.com To: users@openoffice.org Subject: [users] PDF Conversion Date: Fri, Dec 10, 2010 10:51 Douglas Hinds wrote: OO's ability to create pdf files is a valuable asset. However, the need frequently arises to convert pdf files to a editable format. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: Re[2]: [users] PDF Conversion
Den 2010-12-10 21:47:08 skrev Douglas Hinds douglas.hi...@gmail.com: It might help if you had stated what you meant by the results were not adequate. OO writer can now open pdf files, but it opens them in OO Draw and each and every line is included in it's own text box so the documents flow is totally lost for the purpose of editing. The letterhead didn't appear, either. And we are describing a pdf document created in writer and exported to pdf from there. What type of editing do you want to do? I want a faithful reproduction of the pdf file in a totally editable form. Where does OOo fail to do what you want? It doesn't do the above. OO opens pdf files in Draw - that means it's a graphics rather than a document file. Perhaps there's a configuration that can change this - which is the reason for my post today to users at oo.org. Any ideas? Douglas Hinds Well, there are a few PDF editors out there, most of them are crap, but you have to find out for yourself what suits your need best. Someone has already mentioned PDF Editor. You can also edit PDF files in Scribus I think, and maybe even Incscape. There are also commercial software, one of them is PDF Studio, which I installed on my system. You can use it without paying anything for a short period of time and after that you need to purchase or use a somewhat crippled version… But not everything is free in life, not even for Linux users some times… -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
Den 2010-12-04 12:26:43 skrev Andreas Säger ville...@t-online.de: Am 02.12.2010 17:07, Johnny Rosenberg wrote: Den 2010-12-01 19:51:00 skrev Andreas Säger ville...@t-online.de: Spreadsheets are not intended to do such things (hey, they name it Calc). Sorry, didn't think about that. So the next time I want to watch a movie with my COMPUTER, I'd better forget about it and buy a DVD instead, watching it with my DVD player connected to my TV. Or maybe I should go to the cinema instead. A computer should only be used for computing, right? Don't be foolish, please. Without DVD-capable player software and a set of adequate video codecs your computer can not play DVDs, let alone movie editing. There is external equipment for that too. Or was a couple of decades ago. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
Den 2010-12-03 09:13:46 skrev Mike Scott m...@scottsonline.org.uk: On 02/12/2010 16:07, Johnny Rosenberg wrote: Den 2010-12-01 19:51:00 skrev Andreas Säger ville...@t-online.de: Spreadsheets are not intended to do such things (hey, they name it Calc). Sorry, didn't think about that. So the next time I want to watch a movie with my COMPUTER, I'd better forget about it and buy a DVD instead, watching it with my DVD player connected to my TV. Or maybe I should go to the cinema instead. A computer should only be used for computing, right? Or we could think that development is actually a good thing, in some aspects. Within limits. Unfortunately people always compare with Excel, and if OpenOffice.org Calc can't do something that Excel can, they are often unlikely to switch to OpenOffice.org. I am not sure if the focus should be on satisfying earlier Excel users or trying to develop unique (and good) stuff for OpenOffice.org, that Excel lacks, but what can be added that isn't there in OpenOffice.org Calc or MS Excel already? In this case, as someone High Up has decided that pictures are a good idea, IMO the facility should behave rationally and predictably. It doesn't, which is fair ground for complaint. And since I did (when writing a bug report), those who agree with me could vote for it and hopefully something nice could happen… :) -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
Den 2010-12-01 19:51:00 skrev Andreas Säger ville...@t-online.de: Spreadsheets are not intended to do such things (hey, they name it Calc). Sorry, didn't think about that. So the next time I want to watch a movie with my COMPUTER, I'd better forget about it and buy a DVD instead, watching it with my DVD player connected to my TV. Or maybe I should go to the cinema instead. A computer should only be used for computing, right? Or we could think that development is actually a good thing, in some aspects. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Images in OpenOffice.org Calc
I am trying to make some kind of catalogue with item number and a short description for each item. I also want to include an image of each item, scaled down to a height of 4 cm. The row height is also 4 cm, so each image fits perfectly on each row. The problem is that when I sort the list, images are not sorted. How can this be solved? Regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Images in OpenOffice.org Calc
Den 2010-12-01 16:12:29 skrev Gene Young n2...@cfl.rr.com: On 12/1/2010 9:51 AM, Mike Scott wrote: On 01/12/10 14:42, Mike Scott wrote: On 01/12/10 13:45, Johnny Rosenberg wrote: I am trying to make some kind of catalogue with item number and a short description for each item. I also want to include an image of each item, scaled down to a height of 4 cm. The row height is also 4 cm, so each image fits perfectly on each row. The problem is that when I sort the list, images are not sorted. How can this be solved? Can the images be anchored to a paragraph? No, only to a cell or a page. Remember this is OpenOffice.org Calc, not OpenOffice.org Writer. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Images in OpenOffice.org Calc
Den 2010-12-01 15:51:09 skrev Mike Scott m...@scottsonline.org.uk:
On 01/12/10 14:42, Mike Scott wrote:
On 01/12/10 13:45, Johnny Rosenberg wrote:
I am trying to make some kind of catalogue with item number and a
short description for each item. I also want to include an image of
each item, scaled down to a height of 4 cm. The row height is also 4
cm, so each image fits perfectly on each row.
The problem is that when I sort the list, images are not sorted. How
can this be solved?
I see the same. Curiously, with text in the cells as well as pictures
supposedly anchored to the cells, the text will move and the pictures
not. Weird.
Same behaviour whether anchored to cell or page.
But someone has been here before:
http://www.oooforum.org/forum/viewtopic.phtml?t=82549
Seems like a no-no :-{
Even wierder though, if the images are cell-anchored, they /do/ move
around when rows or columns are inserted. So I can't see any
justification for the observed behaviour when sorting.
The Calc guide is unhelpful as to sorting; the implication IMO is the
actual behaviour is a bug.
(http://wiki.services.openoffice.org/w/images/b/b3/0300CS3-CalcGuide.pdf)
I didn't find any bug reports about this, so I filed one myself:
http://www.openoffice.org/issues/show_bug.cgi?id=115870
Feel free to vote for it.
--
Kind regards
Johnny Rosenberg
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Images in OpenOffice.org Calc
Den 2010-12-01 17:46:04 skrev Mike Scott m...@scottsonline.org.uk: On 01/12/10 16:06, Johnny Rosenberg wrote: Den 2010-12-01 16:12:29 skrev Gene Young n2...@cfl.rr.com: On 12/1/2010 9:51 AM, Mike Scott wrote: On 01/12/10 14:42, Mike Scott wrote: On 01/12/10 13:45, Johnny Rosenberg wrote: I am trying to make some kind of catalogue with item number and a short description for each item. I also want to include an image of each item, scaled down to a height of 4 cm. The row height is also 4 cm, so each image fits perfectly on each row. The problem is that when I sort the list, images are not sorted. How can this be solved? Can the images be anchored to a paragraph? No, only to a cell or a page. Remember this is OpenOffice.org Calc, not OpenOffice.org Writer. Now there's a point. I've just tried using Writer for the same job, using a table. That works just fine. Might be a workaround perhaps, depending on whether you need the full Calc facilities or not. Might be, I'm not sure yet. I'll try it if I can't find a better way. I filed a bug report anyway, so in a few years something might happen… or not… ;D http://www.openoffice.org/issues/show_bug.cgi?id=115870 -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Images in OpenOffice.org Calc
Den 2010-12-01 18:04:35 skrev John Brooks jb4...@swbell.net: How can I get my name off the mailing list? No one seems to know. Well, most people here know that. Just send an empty message to: users-unsubscr...@openoffice.org -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] want off list (was Re: [users] Images in OpenOffice.org Calc)
Den 2010-12-01 18:22:42 skrev Mike Scott m...@scottsonline.org.uk: On 01/12/10 17:05, John Brooks wrote: How do I get my name off the mailing list? No one seems to know. Possibly not by burying a request in another thread and not even changing the subject. And we're all just users too. But have you tried following the instructions sent when you subscribed originally? Which are usually repeated at the foot of each list email? For which you need to email from the subscription address and no other. For some strange reason that text are not always there, I think. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
Den 2010-12-01 18:45:14 skrev Andreas Säger ville...@t-online.de: Am 01.12.2010 17:06, Johnny Rosenberg wrote: No, only to a cell or a page. Remember this is OpenOffice.org Calc, not OpenOffice.org Writer. And by far more important: it is not OpenOffice.org Base where you can store things like catalog data (including pictures as cell values) and create catalogues by means of the Oracle Report Builder AddOn. Yes, but I am not used to OpenOffice.org Base. Still, no matter if there are better ways or not, I think this is a bug. Why anchor to a cell if the image won't follow sort? And, as far as I heard, Excel can do this… (but I can't use Excel since Excel lacks the most important feature: Multi operating system support). -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Images in OpenOffice.org Calc
Den 2010-12-01 20:50:20 skrev Rob Clement r...@robbev.com: On 01/12/2010 18:51, Andreas Säger wrote: Am 01.12.2010 19:11, Johnny Rosenberg wrote: Den 2010-12-01 18:45:14 skrev Andreas Säger ville...@t-online.de: Am 01.12.2010 17:06, Johnny Rosenberg wrote: No, only to a cell or a page. Remember this is OpenOffice.org Calc, not OpenOffice.org Writer. And by far more important: it is not OpenOffice.org Base where you can store things like catalog data (including pictures as cell values) and create catalogues by means of the Oracle Report Builder AddOn. Yes, but I am not used to OpenOffice.org Base. Still, no matter if there are better ways or not, I think this is a bug. Why anchor to a cell if the image won't follow sort? And, as far as I heard, Excel can do this… (but I can't use Excel since Excel lacks the most important feature: Multi operating system support). Well, that was a problem even with cell annotations until 2.3(?) where it has been fixed. This kind of problem seems to be very hard to fix for other shapes. Spreadsheets are not intended to do such things (hey, they name it Calc). Pictures are meant to be decorative or explanatory in respect to the sheet, not in respect to contained database data. Excel is the one and only spreadsheet program which encourages its users to misuse it as a database. Millions of users did even learn VBA to make this dream come true with devastating consequences for the overall busines IT. In the forum topic you linked in the issue report, there is another hyperlink to a hyperlink solution. Simply store a file name together with some descriptive name and compose a hyperlink by means of a formula. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Johnny I assume from what you are saying that the text and the picture are in the same cell. Am I correct? what happens if you put the text in one cell and the picture in the next cell in the same row and then sort on both columns? Does it move then? That was what I did. There is no text in the cell where I put the Image. Sorry if this is a dumb question Not at all. Rob - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How does OOo store Writer images?
Den 2010-11-29 16:19:13 skrev James Greenidge ji...@mac.com: On 11/28/10 4:37 PM, RA Brown wrote: That is strange as here it does. I opened a jpg in gimp, cut and pasted it into a new Writer document. Saved the doc then closed Writer open the ODT with Archive Manager and the directory is there with the picture, in PNG format. This all done under Ubuntu and Go-oo v 3.2 will test with OOo 3.3RC6. Andy Is what I get from this that OOo indeed converts JPGs (and GIFs and PICTs?) into PNG as its native image state? That I should rename these mystery Picture folder image files with long number filenames with PNG extensions to render them right in viewers or re-pasting? On Sun Nov 28 2010 13:28:16 GMT-0800 (PST) Guy Voets wrote: Hello, Did a quick test: - a cut and pasted picture doesn't seem to trigger a folder 'Pictures' in the odt folder - an inserted picture (Insert Picture From File) appears in the 'Pictures' folder in the odt zip This would explain a lot with one of my frustrating hangups, like maybe why I can't get imbedded MOVs to cut their links and be standalone image files, no matter whether I use the insert menu or direct cut-paste. Might this be related to why images in RTF documents created in other WPs won't be rendered in OOo a'la No QT decompressor available? A image/mov insertion bug perhaps? I personally don't trust Go-oo or the Ubuntu OpenOffice.org. It seems to be made of bugs; I found quite a few before I switched to the ”vanilla OpenOffice.org” on my Ubuntu machine. My impression of Ubuntu OpenOffice.org was that very much simply doesn't work (and we have four Ubuntu machines altogether, me and my wife, and we had the same problems will all of them). However, if this is relevant in this particular case, I don't know. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How does OOo store Writer images?
Den 2010-11-28 15:03:15 skrev James Greenidge ji...@mac.com: A Write document is corrupt but I can use Stuffit to open it and get at the files but I can't find the very important images. Does OOo store then as PNG or PICT or JPG? Also, does OOo convert image files pasted into a Write doc? Thanks! Are your images in your writer document or are they linked to from writer? If the latter, there are no images in the ODF. Otherwise I guess OpenOffice.org Writer stores them in their original format in a separate folder (”Images”?), but I'm not 100 % sure about that. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] how to set x character and lines per page ?
Den 2010-11-26 22:38:54 skrev Victor Stapelberg vstapel...@gmail.com: Hello I am writing a book and I need to format it in a way as to know how man pages of text I have reached. I need 55 character/spaces x 30 lines per page Thank you Victor What do you mean by ”55 characters/spaces”? Depending on your font, ”M” might take the same space as ”iii”, so is it 55 ”M” or 55 ”i” or do you intend to use a fixed font, like FreeMono, Courier or similar? -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Calc: How to see list of sheets
Den 2010-11-18 14:22:19 skrev L Duperval lduper...@yahoo.com: Hi, In Excel 2K3 Very OT: 2K3? In my world that means 2300 (except that the ”k” shouldn't be capitalised…), like 2k3 Ω means 2,3 kΩ and so on. Well, have a nice day. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Removing line breaks in Open Office writer, etc.
Den 2010-11-14 18:21:43 skrev Twayne twa...@twaynesdomain.com: In news:1289695759.2200.11.ca...@jeff-desktop, Jeffrey Needle jeff.nee...@gmail.com typed: I've found a marvelous answer to the problem of removing line breaks in Open Office text, etc. ... I hope this is of some help to you. No help to me: I use OOo's native Replace command for that. See Tabs, newlines, paragraphs \t \n $ and the following lines for how to. Yes, but I think there was some serious problem with that, if I recall correctly. The problem was that \n in the search field is Shift+↵ and in the replace field it is ↵, but there is no way to replace the other way around, at least not easily. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open office 2009
Den 2010-11-09 00:45:54 skrev Barbara Duprey b...@onr.com: On 11/8/2010 6:25 AM, Bill McCarthy wrote: HelloI installed the program as instructed on CD, but I have never found a way to actually RUN the program since there was NO operational icon created and all that comes up is the original install panel. Bill McCarthy Pittsburgh, PA [Bill (wbm5...@comcast.net) is not subscribed and probably will not see any responses unless directly copied.] Yes he can, here: http://www.openoffice.org/servlets/ReadMsg?list=usersmsgNo=208667 A quick Google search took me there, anyone can do it. Best regards Johnny Rosenberg OpenOffice.org is normally installed from a file that is downloaded from www.openoffice.org, not from a CD, and it has release level numbers (like OpenOffice.org 3.2.1) rather than a name like this, so I don't know where you are getting it -- but there have definitely been releases this year. You may want to go to the site, if you can, and download the most recent stable version. You say you saw an install dialog, which is also what you would see by double-clicking the file downloaded from the site. Did you not have directions to follow from there? On a Windows system, you should end up with a submenu for OOo in your Start menu, and probably also with a desktop icon and maybe an icon in your system tray. If you let us know more about your operating system, where you are getting the file or CD, and exactly what actions you took and their results, we may be able to help more specifically. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: open office 2009
Den 2010-11-09 10:48:43 skrev Harold Fuchs hwfa.gmanen...@gmail.com: Johnny Rosenberg gurus.knu...@gmail.com wrote in message news:op.vlwddfxjxqd...@pb-laptop... Den 2010-11-09 00:45:54 skrev Barbara Duprey b...@onr.com: On 11/8/2010 6:25 AM, Bill McCarthy wrote: HelloI installed the program as instructed on CD, but I have never found a way to actually RUN the program since there was NO operational icon created and all that comes up is the original install panel. Bill McCarthy Pittsburgh, PA [Bill (wbm5...@comcast.net) is not subscribed and probably will not see any responses unless directly copied.] Yes he can, here: http://www.openoffice.org/servlets/ReadMsg?list=usersmsgNo=208667 A quick Google search took me there, anyone can do it. But he doesn't know to do that. As far as he's concerned he asked a question and didn't get an answer. Did he say that? I didn't see that, sorry. My mistake. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OUTLOOK
Den 2010-11-09 08:37:19 skrev Stuart McFadden mcfadde...@hotmail.co.uk: good morning do you have a download that equates with (or is near to) Outlook? many thanks a VERY satisfied user stuart mcfadden Evolution. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open office 2009
Den 2010-11-09 18:09:13 skrev Barbara Duprey b...@onr.com: On 11/9/2010 3:45 AM, Johnny Rosenberg wrote: Den 2010-11-09 00:45:54 skrev Barbara Duprey b...@onr.com: On 11/8/2010 6:25 AM, Bill McCarthy wrote: HelloI installed the program as instructed on CD, but I have never found a way to actually RUN the program since there was NO operational icon created and all that comes up is the original install panel. Bill McCarthy Pittsburgh, PA [Bill (wbm5...@comcast.net) is not subscribed and probably will not see any responses unless directly copied.] Yes he can, here: http://www.openoffice.org/servlets/ReadMsg?list=usersmsgNo=208667 A quick Google search took me there, anyone can do it. It would be interesting to know your search term, but the main problem I have with the OOo archives is that there is no good way to reply there to requests for further information or clarification. The Nabble interface is better, but the typical user is not going to get there without help. I don't remember exactly so I searched again, this time for: open office 2009 McCarthy First hit takes you to one of the responses and from there you can read the original message and all the responses. If that doesn't work, you can always search for a whole sentence in the message, I think. That would be useful if you still have your own message available. Best regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open office 2009
Den 2010-11-08 13:25:43 skrev Bill McCarthy wbm5...@comcast.net: HelloI installed the program as instructed on CD, but I have never found a way to actually RUN the program since there was NO operational icon created and all that comes up is the original install panel. Bill McCarthy Pittsburgh, PA What is ”open office 2009”? Never heard of it. If you are talking about OpenOffice.org, then the version number is probably 3.1.something or 3.2.something. Exactly how do did you install it? I always install the debs from http://www.openoffice.org/ and when I done that I can always find OpenOffice.org at the upper Gnome panel → Applications → Office. But you never mentioned your operating system, so I don't really have a clue what might have happened in your case. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Help! Export to PDF not embedding fonts
Den 2010-10-31 21:38:52 skrev Daniel Lewis elderdanle...@gmail.com: John Jason Jordan wrote: On Sun, 31 Oct 2010 12:07:28 -0700 John Jason Jordanjohnjas...@gmail.com dijo: I created a presentation in Impress (3.1.1 from OOo, not from the repositories, on Fedora 11, x86_64) in which I used the fonts Bitstream Vera Sans Regular and Bold. When I export to PDF all text appears as just blank boxes for the letters. I get the same view of the PDF with Adobe Reader, Okular, Evince, and a couple other PDF viewers that I have installed. I have discovered that the problem is apparently in OOo. Scribus, for example, is happy to embed the fonts in a PDF. The Bitstream Vera family apparently came with the Gnome desktop, at least reading the license leads to this conclusion. There is no prohibition on embedding, or just about anything else for that matter. It is a very open license. As a workaround I changed the entire document to DejaVu. It took an hour because you can't change a font globally. And I have a couple of tables of five columns and 15 rows. You can't even change a font for an entire table - you have to select the text in each cell individually and apply the new font. And exactly why don't you use styles? It could be that the problem with OOo 3.1.1 is due to a setting somewhere in OOo. However, I couldn't find any place in Preferences or Options to change font behavior. If there is a place to change the embedding of a font, someone please tell me where it is. You did not mention what you did in Impress to create the PDF document. Did you use the PDF icon? Or, did you use the File Export as PDF? The easiest way to change font families (Bitstream Vera Sans Regular and Bold to DejaVu) is to change the font in the Styles and Formatting dialog (F11 key). With your presentation opened in Impress, type the F11 key to open this dialog. At the top of this dialog are two icons on the left side: Graphics Styles and Presentations Styles. Make sure the Presentation Styles is selected. The styles you must concern yourself are the ones you used (perhaps without knowing it) among these: Notes, Outline 1, , Outline 9, Subtitle, and Title. Right click the style whose font you want to change and click Modify. Select the font you want from the list. Click OK. I'm fairly certain that directions as to how to modify any of these styles are found in the Impress Guide. (The latest version should be available through the OOo website (Wiki section) in the next week or so.) This guide contains quite a bit of information about how to use Impress if you want much more information. The chapter Getting Started with Impress from the Getting Started Guide will likely give you all the information you need about modifying a Presentation Style in Impress. It may be all you need. Dan - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] openoffice
Den 2010-10-26 16:24:43 skrev Heikki Jussila
heikkitapio.juss...@gmail.com:
On Tue, Oct 26, 2010 at 00:53, Barbara Duprey b...@onr.com wrote:
On 10/21/2010 4:33 PM, saskia shoshana cohen wrote:
Shalom
When I receive documents PdF or MHTLM doc
It is impossible to open them to download them
Thank you to help me quickly to resolve this problem
{Saskia (saskiacohentan...@gmail.com) is not subscribed and probably
will
not see messages unless directly copied.]
Saskia, OpenOffice.org is not really designed to open either of those
formats. PDF files can be opened in the Draw application, I think, but
basically as drawings; you need a reader (there are several free ones,
including one from Adobe), or you can try one of the utilities that
attempts
to make them editable. Sorry, I can't recommend any as particularly
good,
though maybe somebody else here can help.
For editing PDF files I use Foxit PDF Editor (version 2.0 build 111). It
can
open any PDF file and you can edit its content, even add graphics etc.
You
can get it from Foxit Software (it is for Windows so if you are using
MAC or
Linux then you need to find something else for PDF management.
There is one called ”PDF Studio” which unfortunately is not free, but it's
available for Linux, Windows and Mac.
Regards
Johnny Rosenberg
MHTLM appears to be some sort of message attachment format that is not
generally supported. Your best bet is probably to have whoever is
sending
you these attachments use a different format instead. If you meant
MHTML, a
web page browser format that collects various external components
together,
again this is not a supported format for OOo: Internet Explorer should
probably be able to handle it, though.
MHTLM is a Microsoft special format of HTML when saved form IE (it
contains
all the information you see from a web-page in a single file, but you
need
IE to get it functioning properly, you may be able to see the text in
other
browsers too, but that is not always the case.
What OOo primarily deals with is text documents, spreadsheets,
presentations, and drawings, all in a large number of formats.
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Re: [users] openoffice
Den 2010-10-21 23:33:34 skrev saskia shoshana cohen saskiacohentan...@gmail.com: Shalom When I receive documents PdF or MHTLM doc It is impossible to open them to download them Thank you to help me quickly to resolve this problem PDF's are better opened with Document Viewer or Adobe Reader or similar. You don't need OpenOffice.org for that. What is MHTML? Never heard of, sorry. I don't think I have seen one in my whole life, so I guess I should be embarrassed now… -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Open Offfice as replacement for Microsoft Office
Den 2010-10-25 02:55:11 skrev VITO MINNI vmi...@yahoo.com: Gentlemen I am looking to use open office as a replacement for microsoft office is this possible Regards, Vito Minni It depends on what you want to do. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] convertion to AVI or MP4
Den 2010-10-18 22:27:33 skrev Adam Tauno Williams awill...@whitemice.org: On Mon, 2010-10-18 at 18:24 -0300, Ricardo Sequeira Bechelli wrote: Hello people, Somebody knows if is possible to convert files from *.odp direct to AVI, WMV or MP4? No, I don't believe it is possible. Or if exists a free software to do this? I don't think so either. A workaround would maybe be to use something like GTK-RecordMyDesktop or somethning like that. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OOo-Calc Error when moving tab?
Den 2010-10-16 16:47:56 skrev Hylton Conacher (ZR1HPC) hyl...@conacher.co.za: Hi, I have a fresh install of openSuSe 11.2 and it comes bundled with OOo 3.1.1 build 3.1.1..4, which has been installed to facilitate continued use of OpenOffice. I had created a 17 sheet spreadsheet on the older version launched with openSuSe 11.0 and successfully opened the spreadsheet in the new version. The spreadsheet contains 2 tabs of text with the balance being graphs of the text data i.e. one of the text sheets is called data and contains readings, which are then graphed on the remaining sheets. The problem on the newer version of OOo is that when I want to move one the monthly tabs that contains a graph, or even the data tab that only contains numbers, when I click on it and move it OOo shuts down completely and needs to be restarted and the recovery of the open document needs to take place. To try and fix this eror I have checked for updates using Yast, and whilst newer versions are available they do not seem to be openSuSe 'supported'. Is there a fix for this, should I raise a bug report as it may be happening in the newset version too? Anyone point me in the right direction to get this resolved? Regards Hylton I had a problem like that (not exactly the same problem though) with the Ubuntu version of OpenOffice.org, which I believe is Go-oo rather than OpenOffice.org but I think also the OpenSUSE version is built with Go-oo. I removed the crap and installed the official OpenOffice.org version (the one to be found at http://www.openoffice.org/) instead and had no problems since. It's not ”supported” by Ubuntu, but I don't care; it works. For me, that is… If I had OpenSUSE 11.2 (which I indeed do, on one partition, but I rarely use it) and had that problem in OpenOffice.org, I would uninstall it and try the official OpenOffice.org version instead, which by the way is much more recent anyway. If that works I probably should report the problem to the OpenSUSE team. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] opening .doc files
Den 2010-10-14 20:23:20 skrev John Kennedy skeb...@gmail.com: On Thu, Oct 14, 2010 at 12:07, fuad abboud abbo...@shaw.ca wrote: I have the following question: How do you change settings in OpenOffice so that OpenOffice is not the default application used to open .doc files? thanks. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Those settings are changed in Windows, NOT OpenOffice.org. How you do it depends on the version of Windows you are using. John That is if Windows is his operating system. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Change background image in OpenOffice.org Calc
I had a spreadsheet open and I dragged an image to it from my desktop, and I right clicked it → Arrange… → To Background. Now I can't figure out how to remove it. Have tried everything I can think of… I can't use Undo since that would undo things that I want to keep. Anyone? OpenOffice.org 3.2.0 Ubuntu 10.04 -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Change background image in OpenOffice.org Calc
Den 2010-10-13 17:31:32 skrev Michele Zarri m.za...@gmail.com: On 13/10/10 16:15, Johnny Rosenberg wrote: I had a spreadsheet open and I dragged an image to it from my desktop, and I right clicked it → Arrange… → To Background. Now I can't figure out how to remove it. Have tried everything I can think of… I can't use Undo since that would undo things that I want to keep. Anyone? OpenOffice.org 3.2.0 Ubuntu 10.04 One possible way: - open the navigator (F5) - select the category Graphics and expand it - double click on the offending image (probably called Graphic 1 unless you have more images in the spreadsheet) This should bring up the image and allow you to delete it or to re-arrange it. Cheers, Michele Ah… thanks! Forgot about the navigator since I never use it. Maybe I should start to use it from now on… :) And it was Graphic 2 in this case, just in case someone wants to know… -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Please help with a problem on OppenOffice.org 2.0
Den 2010-10-12 12:04:10 skrev Earl Melton earlemel...@yahoo.com: On 10/11/2010 01:55 PM, Johnny Rosenberg wrote: Den 2010-10-11 14:08:12 skrev Kosie Olivier koos.olivi...@gmail.com: I have a problem on OpenOffice - my arrow keys do not move cells on a spreadsheet anymore like it did before. What can I do? Hope you can help me! JPH Olivier koos.olivi...@gmail.com Why do you still use the very old OpenOffice.org 2.0? And what do you mean when you say ”move cells”? I have never been able to do that with the arrow keys alone. I ws pretty sure I had done it before, but just now confirmed it on my Ubu 3.2.0 and it worked fine. I selected three contiguous cells, then placed the mouse pointer on the very edge of the selection and moved it down to the next row, then back where they belong. Duck soup! Yes, the mouse, but you was asking about the arrow keys? And placing the mouse pointer at the edge is an Excel thing, you don't need to do that in OpenOffice.org. Just place it anywhere in the cell range and move it. If you want to move a single cell, you need to make sure it is highlighted, for example by selecting two cells and then move the mouse pointer back to the first cell again without releasing the mouse button, or by Shift+Click on the cell you want to highlight and then move it. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Please help with a problem on OppenOffice.org 2.0
Den 2010-10-11 14:08:12 skrev Kosie Olivier koos.olivi...@gmail.com: I have a problem on OpenOffice - my arrow keys do not move cells on a spreadsheet anymore like it did before. What can I do? Hope you can help me! JPH Olivier koos.olivi...@gmail.com Why do you still use the very old OpenOffice.org 2.0? And what do you mean when you say ”move cells”? I have never been able to do that with the arrow keys alone. -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] (Calc) Text output for cell based on other cell values
Den 2010-10-08 20:44:00 skrev Brad Rogers b...@fineby.me.uk: On Fri, 08 Oct 2010 10:50:09 -0700 JOE Conner joeconner2...@gmail.com wrote: Hello JOE, You could have just hidden the column. FORMAT = COLUMN = HIDE. You're right, but as the column was being used as a spacer anyway, I opted for white on white. Well, you could insert a new column and then hide it… -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] coding documents in Open Office
Den 2010-09-30 21:16:39 skrev Ľubomír Cerina lubomir.cer...@gmail.com: hi, is any way to change coding of documents in HTML ? Im suffering with different codes when using Open Office it uses Win-1252, while when editing in Note pad i have options (ansi, win-1250, unicode, utf-8) please help me synchronize coding of all my pages, win-1250 would be ideal for me. thanks much Don't you think it's time to leave Win-1250, ISO-8859-1 and those kinds of encodings behind? It's 2010 now and shouldn't we all just use UTF-8? And I wouldn't create HTML documents in OpenOffice.org. Couldn't you just do a search-and-replace in an text editor, by the way? -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Need support -
Den 2010-09-28 15:08:45 skrev ri...@compuserve.com ri...@compuserve.com: Sir; In the past I have sent an annual donation to keep open office alive. However there is a conspicuous lack of product support. Until I am able to receive an intelligent answer to the question Please can someone tell me why the open office spell checker works intermittently? I am no longer sending money to open office. Just curious, but why do you send money to OpenOffice.org? OpenOffice.org is free and gratis, but of course anyone are welcome with donations, I guess. I have attempted several avenues of support all met with frustration as I was totally ignored or received well meaning but feckless support from amateurs. I am not sure, but if you want professional support I think you can buy it somehow, but it seems like you already pay for it for some reason. And most of the people on this list are amateurs, of course, that's kind of the point. We are all users who tries to help each other out the best we can. I like your product and agree with most of the 'open source' ideals but am frustrated and disenchanted with the absence of any formal support. Open office is forcing me to fall back in using overpriced Microsoft products. Please advise. Hank Jones mailto:ri...@compuserve.comri...@compuserve.com - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
