Re: warning - Editor Wars!!!--how about some heresy on behalf of the Joe 6-Pack word processor user
On 06/27/2015 05:29 AM, toki wrote: On 06/27/2015 05:48 AM, Andrew Douglas Pitonyak wrote: Two versions were created, and off hand I don't remember the difference between the versions. There were versions for: * Writer; * Calc; * Impress; I don't remember if the one for Impress made it out of alpha testing. The one for Calc got as far as limited beta testing. I have only run these against a Write document, I have not tried with anything else. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Inserting 100 small text files into doc
Are these straight up text documents? If so, I think that a method has already been shown for how to copy all the files to one and then you can insert a single file. On Linux, this is even easier... Of course, since I like to write macros, I would write a macro that looked something like this: sFulPath = path to a document oDoc = ThisComponent oText = oDoc.Text oCurs = oText.createTextCursor() oCurs.gotoEnd(False) oSFA = CreateUnoService(com.sun.star.ucb.SimpleFileAccess) If NOT oSFA.exists(sFullPath) Then MsgBox (Unable to open sFullPath . Please check folder settings.) Exit Sub Else oTextStream = CreateUnoService(com.sun.star.io.TextInputStream) oTextStream.setEncoding(UTF-8) 'oTextStream.setEncoding(LATIN-1) iStream = oSFA.openFileRead(sFullPath) oTextStream.setInputStream(iStream) Do While NOT oTextStream.isEOF() s = oTextStream.readLine() oText.InsertString(oText.End, s, False) oText.InsertControlCharacter(oText.getEnd(),com.sun.star.text.ControlCharacter.APPEND_PARAGRAPH, False) Loop oTextStream.closeInput() End If Then you would just need to write a macro to loop through each file of interest. On 05/03/2015 05:25 PM, Dale Erwin wrote: On 5/3/2015 3:24 AM, Rory O'Farrell wrote: Another way to do this might be to make a Master Document, and enter therein the names of all the text files in sequence (perhaps from a captured directory listing?). The output document resulting from the expanded Master Document might then be edited in the usual way. There are problems: the individual documents might lose their formatting, and one would need to get one's head around the complexities of Master Documents and their structure. For a one-off task the hundred documents could have been inserted by hand using /File /Insert and an hour's work. My experience with master documents has been that the expanded master document cannot be edited directly, only the individual component files may be edited. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Help with deleted content
I usually see this when I open a text file using the wrong character set... Please also include the file type when saved... What was the file name with extension. If the file extension is wrong, most programs open it incorrectly. On 04/30/2015 07:29 PM, kayla samuel wrote: OpenOfffice has now deleted the content of 2 very long documents that I saved multiple times and created backups for. Each time I opened the document, all of the content was replaced with page after page of pound keys. I haven't found any useful information through forums or on your website on retrieving these documents, and I would like to know if there's anyway to save my work instead of having to start over again. Please get back to me soon. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: odt-file, ascii filter, series of pounds
How does a file disappear? That is an easy one. If you always save the file to the same file name, and something then happens to that one file, then there are no other copies. I have seen this as follows: Click on Save, and something goes wrong while saving, which corrupts the file (say it crashing mid-write). -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Way of reporting nastiness in your forum?
On 01/23/2015 01:07 PM, Maurice Howe wrote: Never, ever, include religious stuff in forum remarks. Surely you are referring to top versus bottom posting! - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Way of reporting nastiness in your forum?
On 01/22/2015 10:04 PM, Julian Thomas wrote: On Jan 22, 2015, at 00:18, Andrew Douglas Pitonyak and...@pitonyak.org wrote: Oh, and I have also heard some very strong opinions that PDF export support should be pulled; another minority opinion. PLEASE - do not pull that! It is a very minority opinion, I would not stress it. I would be a bit distressed if they did pull it. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Way of reporting nastiness in your forum?
On 01/21/2015 06:56 PM, jonathon wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 21/01/15 05:50, Andrew Douglas Pitonyak wrote: People who want to write the XLSX format are likely to not understand why he might feel so strongly about it. This is one of those complex issues, that usually has people talking past one another, totally ignoring what the other is saying, constructing straw-men to further mis-communicate their ideas, as part of their process of maximizing non-communication. Hagar indicated that it will never be able to cope with OOXML. Not sure if that is true, Compatibility depends upon how much loss one is willing to undergo, with respect to: * Content; * Presentation Markup; * Semantic Markup; * Other types of Markup; Rephrased: a) Willing to lose everything but content; b) Willing to lose everything but content and presentation markup; c) Unwilling to lose content, presentation markup, semantic markup, or other types of markup; A not so minor issue is that the MSO *x file formats, and OOXML file formats are two dissimilar file formats, that, at first glance, appear to be identical. IOW, even if AOO has perfect OOXML file format compatibility, it means squat, in terms of MSO *x file format compatibility. Well, the reasons for adding it are obvious... so that you can read / write the format. Reasons for not supporting it: 1. Uses resources that could be used for other things. 2. ideology: Force people to ODF formats 3. The format is poorly defined and contains all sorts of garbage in it You know, those sorts of things. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Way of reporting nastiness in your forum?
On 01/21/2015 08:08 PM, Urmas wrote: Andrew Douglas Pitonyak: ...it will never be able to cope with OOXML. So, now you're trying to lock-in LO users in ODF format? Priceless. First, note that the quoted text is a partial snipped pulled from the forum post that was not written by me. That said Every now and then, the topic will come up as to whether or not writing of OOXML should be supported; and there are always people who are not just against it, but really against it. I think that it is a minority opinion. I think that someone stated somewhere in this thread that support is in the works for AOO. Also, I would be very annoyed if the LO folks pulled their existing support. Oh, and I have also heard some very strong opinions that PDF export support should be pulled; another minority opinion. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Way of reporting nastiness in your forum?
On 01/20/2015 04:42 PM, Mat Walker wrote: Hi Guys, I have used OO stuff for a while and hope I have put enough back to payback the use. Today, I have the unfortunate task of having to create xslx files for an application that only reads those. So i did a search to see if there was any way to get Calc to write out that format (or a plugin to enable that). However, all I came across was a vile tirade of abuse from the user 'villeroy' on your (usually great) Forum. This abuse was aimed at a user, who also was asking about xlsx.. It is people like 'villeroy' who make 'normal' folk like me go elsewhere. I realise this individual is an independent person and not 'controlled' by the OO team; but there really should be a way of being able to report this sort of nastiness as it reflects badly on the folk who really do put a lot of their own time into these things and tars them with the same brush. Probably needs to be a way of getting rid of the bad apples in the basket... See - https://forum.openoffice.org/en/forum/viewtopic.php?f=45t=56953start=30 Mat Villeroy seems to be responding to nobody I assume that there was a post to which he was responding. I see that the thread is marked as solved. If AOO is not able to save as XLSX, try LO. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Way of reporting nastiness in your forum?
On 01/20/2015 08:07 PM, Rory O'Farrell wrote: On Wed, 21 Jan 2015 11:44:12 +1100 Martin Groenescheij mar...@groenescheij.com wrote: On 21/01/2015 8:42 AM, Mat Walker wrote: Hi Guys, I have used OO stuff for a while and hope I have put enough back to payback the use. Today, I have the unfortunate task of having to create xslx files for an application that only reads those. So i did a search to see if there was any way to get Calc to write out that format (or a plugin to enable that). However, all I came across was a vile tirade of abuse from the user 'villeroy' on your (usually great) Forum. This abuse was aimed at a user, who also was asking about xlsx.. It is people like 'villeroy' who make 'normal' folk like me go elsewhere. We know that communication is not Villeroy's best quality, but he only get abusive after posters keep coming back with the BUT I WANTattitude. Villeroy is highly appreciated for his contribution and has proven that he knows what he is talking about. It is worth examining the full thread (#31 postings), only one entry (#30) of which is quoted by the OP in this list-topic https://forum.openoffice.org/en/forum/viewtopic.php?f=45t=56953 See - https://forum.openoffice.org/en/forum/viewtopic.php?f=45t=56953start=30 Mat Ahhh, I had missed that it was page 2 of 2 and that there was stuff before it... There is a group of people who believe that AOO should not support writing other document types. I see that the primary issue is probably related to Villeroy's strongly held belief in this area. In other words, it seems that his hot buttons were pushed on that account. People who want to write the XLSX format are likely to not understand why he might feel so strongly about it. I am a bit surprised that it was not mentioned that LO is able to write this format. Hagar indicated that it will never be able to cope with OOXML. Not sure if that is true, but, it is not likely to deal with it well since it is so convoluted. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Need documentation on using OpenOffice as an OLE Object with PowerBuilder
I have some documents on my web site that show examples using Basic, which might help understanding the API. I have no particular comment on the use of OLE. https://www.openoffice.org/udk/common/man/tutorial/office_automation.html https://wiki.openoffice.org/wiki/Documentation/DevGuide/ProUNO/Bridge/Automation_Bridge On 12/04/2014 06:10 AM, Pierre POUPET wrote: Hello, We are a french company (ATILOG) making a software (GeFA) for enterprises to help them to handle their vehicules. You can find more explanations on our website: www.gefa-gestionflotteauto.com http://www.gefa-gestionflotteauto.com/ In our software, we would like to use OpenOffice (as an OLE Object) to export and Import files in an Excel format. We need all commands to open file, select columns, format columns, saveas, … Our software is written with Powerbuilder (the editor is SYBASE). Do you have some documentation or samples which could help us ? Thank you in advance. Best regards *Pierre POUPET* Gérant Associé Directeur Technique LD : +33(0) 427 021 360 Mob : +33(0) 675 775 956 _www.gefa-gestionflotteauto.com http://www.gefa-gestionflotteauto.com_ Atilog_Brignais -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php
Re: Office Writer forum page
On 10/28/2014 07:21 PM, conc...@localnet.com wrote: Dear Open Office, I've been using computers since the 1990's and the internet since 1998. I can find my way around on a website. However, I want to post to your forum on Office Writer but I do not see, any where on that page, the word 'Post' or anything that indicates in some way that I can post a message to the forum. Why is there not a large word - POST - on that page? So the question is, how does one actually POST a question? Thank You, Christine It probably says something like new thread... Nope, it is newtopic. https://forum.openoffice.org/en/forum/viewforum.php?f=7 I assume that you already have an account. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Sytem not working
On 09/21/2014 07:20 PM, Kim wrote: Dear: I have been using Open Office downloaded from your office since 2004 and I have encountered now Help icon and spell checks are not working I am using latest 4.1.1 Do I need to reload open office or can you send me an email link Kim Still no answer Hmmm... 1. Did they used work and then stop working after something memorable happened (like installing a new version of AOO)? 2. Have you tried resetting your user profile? Read this: http://comments.gmane.org/gmane.comp.apache.openoffice.user/4873 See if that helps. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Question for you.....
No concrete answers, but, off hand, it sounds like AOO thinks that every word is spelled incorrectly. Make certain that you have the proper dictionaries installed and that the language is set correctly on text. Sorry, no time to explain that, I am late for something else. On 09/03/2014 03:46 PM, Manuela Werthwein wrote: Hello, I have been using Apache OpenOffice for quite some time and just loveso thank you for this. Now I seem to have a problem with it this time.I downloaded the new version of Apache OpenOffice 4.1.1. yesterday and I never had this problem before. So the issue is that when I open up documents new or old, all of the words are underlined in red which shouldn't be. Can you please give me some guidance on how to rectify this situation. Many thanks, Manuela Werthwein 613-231-4575 manu...@visionofspirit.com manu...@windowtothesoul.com -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: loading openoffice 4.1.1 release
I believe that the sourceforge servers just came back online. On 08/23/2014 04:26 AM, Michel Oczkowski wrote: can not find http://downloads.sourceforge.net/project/openofficeorg.mirror/4.1.1/binaries/fr/Apache_OpenOffice_4.1.1_Win_x86_install_fr.exe?r=http%3A%2F%2Fwww.openoffice.org%2Ffr%2FTelecharger%2F%3Futm_source%3DAOO4_1_0_fr%26utm_medium%3DClient%26utm_campaign%3DUpgradets=1408782322use_mirror=optimate; - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: SV: loading openoffice 4.1.1 release
I suppose that you are subscribed to the user's list, so you receive the email :-) On 08/23/2014 05:43 AM, vitio55 wrote: I am not open Office suport Mvh Familjen Nilsson Originalmeddelande Från: Michel Oczkowski michel.oczkow...@orange.fr Datum: 23-08-2014 11:38 (GMT+01:00) Till: users@openoffice.apache.org Rubrik: loading openoffice 4.1.1 release can not find http://downloads.sourceforge.net/project/openofficeorg.mirror/4.1.1/binaries/fr/Apache_OpenOffice_4.1.1_Win_x86_install_fr.exe?r=http%3A%2F%2Fwww.openoffice.org%2Ffr%2FTelecharger%2F%3Futm_source%3DAOO4_1_0_fr%26utm_medium%3DClient%26utm_campaign%3DUpgradets=1408782322use_mirror=optimate; - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Macro Problems
On 08/19/2014 04:19 PM, Don Daugherty wrote: For several years I have been using OOo Macros, running under Basic. Then a few months ago they stopped working, and I am unable to track-down the source of the difficulty. When I startup a particular Financial spreadsheet, which should trigger a Startup macro, OpenOffice Basic starts and balks at the first command, which is GlobalScope.BasicLibraries.LoadLibrary(Calc), with Basic runtime error, An exception occurred, type com.sun.star.container.NoSuchElementException, Message:. I don't know where it's looking. What shows up in the file structure is under C:\Users\His\AppData\Roaming\OpenOffice.org\3\user\basic\Calc, which contains a group of .xba basic files. Ideas, anyone? That message seems to be saying that a Basic library loaded at the directory you list does not exist. Which version of OpenOffice are you running? Did you, perhaps, install a new version of OpenOffice? Do you have the directory as listed above? If yes, what files are in that directory? I do not have a Windows instance to check against; sorry. I will do some guessing. How did you find this path? Do you find this path somewhere in options, or, did you look on your hard drive? This may be only marginally useful to you, but, I am currently on a Linux computer and I have LibreOffice installed, but, I think that the information will still be useful to you. I have a file located here: /home/andy/.config/libreoffice/4/user/basic/script.xlc I expect that from what you stated, you should have a file here: C:\Users\His\AppData\Roaming\OpenOffice.org\3\user\basic\script.xlc If you look at script.xlc, I expect that you will find an entry that looks something like this: library:library library:name=DBUtil xlink:href=$(USER)/basic/Calc/script.xlb/ xlink:type=simple library:link=false/ This is saying that you have a library named Calc and that it is described in the file script.xlb. (remember that I asked about the files in that directory above). Just trying to get a feel for what you have on your machine. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: copy/paste goes to TABLES?????
On 07/27/2014 09:37 PM, Dee Drill wrote: I tried to copy a very short sentence from an Arabic Bible to OO so that I could enlarge it for use on a t-shirt. It copies and pastes just fine but automatically goes into Tables and won't get out of that format! It won't let me enlarge the text. I tried clearing it and starting over several times. I have had this problem before using english text as well. Dee Drill formerly Dee Schauer In a time of universal deceit, telling the truth will become a revolutionary act. Am I therefore become your enemy, because I tell you the truth? Gal. 4:16 __i__ *-O--O--(o)--O--O-* If you are unsure what to do with this, can you shoot me a copy of the document off list. Understand that I do not read Arabic, so do not expect me to read it, but, I can inspect the document if you like. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: New Member
On 07/28/2014 08:23 PM, CMLDMB wrote: Dear OpenOffice list members, I just wanted to introduce myself to you before I start asking questions. I'm a mom, grandmother, wife, retired teacher, OpenOffice enthusiast, and that's about it. I look forward to getting to know you guys. Cindy Welcome to the list Cindy Ask away... -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: New Member
Thank you for your kind words, but, I think that you are now publicly admitting to being a Geek! :-) On 07/28/2014 08:41 PM, CMLDMB wrote: Hi Andrew!! I've been enjoying your books about macros!! Cindy On 7/28/2014 7:39 PM, Andrew Douglas Pitonyak wrote: On 07/28/2014 08:23 PM, CMLDMB wrote: Dear OpenOffice list members, I just wanted to introduce myself to you before I start asking questions. I'm a mom, grandmother, wife, retired teacher, OpenOffice enthusiast, and that's about it. I look forward to getting to know you guys. Cindy Welcome to the list Cindy Ask away... - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: review, comments, conflicts with Oo 4.0 and higher
On 07/28/2014 08:43 PM, CMLDMB wrote: Hi For weeks I have been looking for an answer this problem. I have tried the documentation and the forums. I have searched the internet. The problems started when I upgraded from 3.x to 4.0 and beyond. I have always been able to go from Word 2010 to Oo and back again. My friend did her work on Word, emailed it to me, I made comments in Oo, saved it in Word format, then sent it back to her in Word format. It was fine. It worked great. However, after updating to 4.0 that all went away. So, I thought something must be a bit buggy and updated to the latest version last week. Still the same bad results. I was made aware of this when an eight hour editing job had to be completely redone on another computer that had Word 2010 on it. The client called and said the comment boxes were not usable. Sure enough, I opened the file in Word 2010 and it was a horrible mess. The trouble is that comments made in OpenOffice get trashed when the document is opened by Word 2010. They show a space between each letter. There is a blank line between each line of text that can not be deleted. And, the words that were once in one comment box are now spread through multiple boxes, pushing the text from box to box until at the last box all over spill text is deleted. Maybe I am not saving it in the right file type? Any help would be greatly appreciated. Thank you so much. Cindy You bring up the file type, and then you fail to mention what file type you use. Are you writing DOC files or DOCX files? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: New Member
I surely hope so! My wife said to me I never dated a geek until I met you! I told her that she should tell her friends to date geeks, they are generally grateful (a woman spoke to me)... On 07/28/2014 08:57 PM, CMLDMB wrote: Umm... Yeah, I guess so!! That's a good thing. Right? On 7/28/2014 7:56 PM, Andrew Douglas Pitonyak wrote: Thank you for your kind words, but, I think that you are now publicly admitting to being a Geek! :-) On 07/28/2014 08:41 PM, CMLDMB wrote: Hi Andrew!! I've been enjoying your books about macros!! Cindy On 7/28/2014 7:39 PM, Andrew Douglas Pitonyak wrote: On 07/28/2014 08:23 PM, CMLDMB wrote: Dear OpenOffice list members, I just wanted to introduce myself to you before I start asking questions. I'm a mom, grandmother, wife, retired teacher, OpenOffice enthusiast, and that's about it. I look forward to getting to know you guys. Cindy Welcome to the list Cindy Ask away... - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: help please
On 07/26/2014 08:58 AM, Chris Landrum wrote: Hello OO Users, I need help. Yesterday, since my Open Office was apparently a victim of computer gremlins, I uninstalled, rebooted, installed latest version, rebooted and solved that problem. NOW I’m getting an error message when trying to open all previous OO documents which says: “The requested operation requires elevation”. I would not worry about it except every business related document I have is in OO. I can’t process orders until this is resolved. Any help would be greatly appreciated. Thank you, Chris How are you opening the documents? Double click on a document from say Windows Explorer, or, are you using File | Open from inside of AOO? Finally, I assume that you installed the version from the AOO web site... -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Rif: best macros and macro resources for OpenOffice?
On 07/16/2014 08:50 AM, francesco.zivi...@surftech.it wrote: One thing I think will be useful is to explain for a beginner how to test and run MS Office Macros in OpenOffice. I know it shoud be possible but I could never understand exactly how and whitch limitations I can expect. Thank you. The base language is very similar, but the MSO version is riddled with annoying behaviors (I will call them bugs) such as the fact that things such as LBOUND will fail on an uninitialized array. This has been fixed in OO. So, if you have a macro that uses the language features and does not modify a document, it will probably work. Side note: If you are writing macros for MSO to run in MSO, use .NET; it is not portable, but it sure beats working around the poor language implementation. OK, back again If you are manipulating a document, just assume it will not work with exceptions for very common operations in Calc documents after you set compatibility mode. They may have support for other document types, but I am not aware of it - and I have very little experience trying to open MSO macros in OO. So, consider it a mostly uninformed opinion in that regard. Ing. Francesco Ziviani Sales Manager Tel. +39 348 4109172 Fax. +39 045 21090140 E-mail francesco.zivi...@surftech.it Surftech S.r.l. Via dei Montecchi 8 - 37031 Illasi (VR) www.surftech.it -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How to prevent very long text in a cell overlap the footer in Calc?
Jesse, Instructions to unsubscribe are included in the bottom of the email to which you replied I will repeat them here Send an email to users-unsubscr...@openoffice.apache.org That should do it. If not, then send an email to the list with text in the subject line that reads something like failed to unsubscribe. Then again, a moderator may have already handled it for you. On 06/13/2014 07:45 PM, Jesse Lafian wrote: yo. unsubscribe me please. this shit is super annoying. On Fri, Jun 13, 2014 at 3:19 AM, Andrea Pescetti pesce...@apache.org wrote: Brian Barker wrote: Mr Groenescheij can speak for himself - indeed, he already has - but are you right to castigate him for writing either You can't fill a 10 liter bucket with 11 liter water or what you try to do is driving a screw in the wall with a hammer? These expression are surely perfectly sensible metaphors Sure, I see nothing wrong either. Metaphors can be easily misunderstood. But the reply was surely not meant to be offensive. Regards, Andrea. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Wiedereinführung von Staroffice
I will concede that my German is not that good, but, did you ask a question, or simply make some comments? Also, was StarOffice professional reintroduced? Mein Deutsch ist nicht so gut, aber, hast du eine Frage zu stellen, oder einfach nur einige Bemerkungen? Auch wurde Staroffice Professionell wieder eingeführt? On 06/13/2014 11:19 AM, patrick.dre...@gmx.net wrote: Hallo! Die Wiedereinführung von Staroffice Professionell. Openoffice bleibt für User die kein Emailprogramm wollen. Die Programme von Staroffice 5.2 ohne den lästigen StarDesktop ausstatten und die Programme einzeln starten. Mit freundlichen Grüssen! -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: My problems with OpenOffice
On 05/25/2014 07:07 AM, António wrote: Hello My name is António and I've some questions for you to resolve my problems. So my biggest problem with OpenOffice is working on my laptop and doing work from school In my school all computers use Microsoft Office. When I do works there in PowerPoint, Word... When I get back home to open the works in OpenOffice the works are all disconfigured. Like the pictures are on top of the texts and the texts are spread all over the places... Why I can not return home with all my work in the same place and continue to do it? There is any options in OpenOffice to resolve that or it's the problem of the compatibility ? I think that you said: 1. You edit files in MSO 2. You open the files in AOO and the formatting is not correct. What file format are you using? Sometimes you can fix the problem by using a different file format. For example, write a .doc file rather than a .docx file. I have more experience in the word processing area than in presentations, but, at least with word processing, the choice of how an image is anchored can make all the difference. For example, I like to anchor my images as a character and they seem to export just fine between Word and Write. Just wanted to mention it. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Simple advice on how to get Reveal Codes inplemented please
On 05/24/2014 07:02 AM, DaveMainwaring wrote: Some of the threads are so long I don't have the energy to follow all the stuff :_) How do I vote, and support this initiative (or any other) ? This is where you vote for that particular issue https://issues.apache.org/ooo/show_bug.cgi?id=3395 You must have an account to vote, but it is easy to create one. If you have trouble creating the account, be sure to post back and say so. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Reveal Codes Query - or Re: Suggestion.
yes, voting is how you officially indicate your interest On 05/23/2014 03:39 AM, Helen wrote: I'd love the reveal codes feature -- didn't know there was a vote until I ran across this. On Mon, May 19, 2014 at 8:17 AM, Andrew Douglas Pitonyak and...@pitonyak.org wrote: On 05/19/2014 06:11 AM, japples wrote: So far, this conversation boils down to: use only styles which requires casual users to travel the steep learning curve to enable their use and possibility of creating conflicts with other style rules or show consideration to the casual user and provide a reveal code feature which is cleaner / more direct and does not have potential of creating conflicts. That is the preferred way of using the product, but it does not negate the need for the feature. It does, however, possibly make it more difficult to implement. I think that the real problem is that it requires a knowledgeable person (as in someone who would be able to code the solution) to care enough to choose to do it. This is, after all, community developed software. So, the trick is to convince a particular person to spend time / energy on that particular feature. In this case, it means that the feature must be first designed, since a design does not exist, and, the general usage pattern is sufficiently different, that it is not obvious to me that saying copy from WP is sufficient. Finding someone that cares enough to actually implement really is the hardest part. The product has many users, but, I only see 25 people on the CC list for the enhancement request and only 201 votes for implementation. https://issues.apache.org/ooo/show_bug.cgi?id=3395 So, if one talented person cares enough to do it, it will happen. Otherwise, I suppose that sufficient people need to vote for the feature. WIth as many users as exist, only finding 201 people who want it enough to put one of their votes towards it in over 10 years feels a little spartan. Perhaps the problem is that the people that want it do not know that they can vote for it. I will admit, however, that I don't have a handle on how many votes it would require to push it up the list, and I lack the time right now to check to see where it stands relative to other requests. I do see that most people that voted put two of their votes towards it. https://issues.apache.org/ooo/page.cgi?id=voting/bug.htmlbug_id=3395 Compared to using wysiwyg web page creator without ability to view code. Styles does nothing to correct skewed page; however, viewing the codes is a very helpful tool. Jack -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Reveal Codes Query - or Re: Suggestion.
On 05/19/2014 06:11 AM, japples wrote: So far, this conversation boils down to: use only styles which requires casual users to travel the steep learning curve to enable their use and possibility of creating conflicts with other style rules or show consideration to the casual user and provide a reveal code feature which is cleaner / more direct and does not have potential of creating conflicts. That is the preferred way of using the product, but it does not negate the need for the feature. It does, however, possibly make it more difficult to implement. I think that the real problem is that it requires a knowledgeable person (as in someone who would be able to code the solution) to care enough to choose to do it. This is, after all, community developed software. So, the trick is to convince a particular person to spend time / energy on that particular feature. In this case, it means that the feature must be first designed, since a design does not exist, and, the general usage pattern is sufficiently different, that it is not obvious to me that saying copy from WP is sufficient. Finding someone that cares enough to actually implement really is the hardest part. The product has many users, but, I only see 25 people on the CC list for the enhancement request and only 201 votes for implementation. https://issues.apache.org/ooo/show_bug.cgi?id=3395 So, if one talented person cares enough to do it, it will happen. Otherwise, I suppose that sufficient people need to vote for the feature. WIth as many users as exist, only finding 201 people who want it enough to put one of their votes towards it in over 10 years feels a little spartan. Perhaps the problem is that the people that want it do not know that they can vote for it. I will admit, however, that I don't have a handle on how many votes it would require to push it up the list, and I lack the time right now to check to see where it stands relative to other requests. I do see that most people that voted put two of their votes towards it. https://issues.apache.org/ooo/page.cgi?id=voting/bug.htmlbug_id=3395 Compared to using wysiwyg web page creator without ability to view code. Styles does nothing to correct skewed page; however, viewing the codes is a very helpful tool. Jack -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Reveal Codes Query - or Re: Suggestion.
On 05/19/2014 09:38 AM, 許哲崇 wrote: If we use OpenOffice to edit the file and use WordPerfect to reveal code, what is the problem? No problem at all... :-) The potential issue is that loading in a different editor will cause slightly different things to be displayed (at least that is my experience based on different formats, especially if there is something tricky or complicated about the text). -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Reveal Codes Query
On 05/17/2014 04:35 PM, Johnny Rosenberg wrote: 2014-05-16 20:38 GMT+02:00 japples japp...@europa.com: Does a list exist for OO users to vote for proposed future functionalities? I would like to vote for Reveal Codes. Reveal Codes is a very useful tool. It works independently of the Style rules and does not require the user to take time to search style rules then create or edit (causes changes in other documents?) Logically, it seems the more style rules the less efficient OO Writer. Guess you could say, reveal codes is like lifting the hood of a vehicle to change spark plugs. While style rules feature is similar to re-configuring the vehicle to operate bypassing spark plugs (takes more time and effort by the user). Thanks for your patience - Jack I think I remember some very intense discussions about this a couple of years ago, it was almost like some kind of war or something… Some people said it will never happen since there is nothing to reveal (Apache OpenOffice just doesn't work like that). Still someone managed to write an extension that does this, I think. I guess it fakes it somehow. Some people also think that it's not a good habit using them, and that styles is the way to go and so on. Some people also says that it's a bad habit to use a lot of character styles in text. So it seems like a lot of people are against the idea of reveal codes while others want them. I don't know. I have no use for them personally, so I don't care, but… well… Johnny Rosenberg It has been a long time since I tested the macro, so I don't remember what it showed and what it did not. If you really want to design this, then, it should likely not just be a duplicate of Word Perfect functionality. For example, what if My paragraph style sets character weight (that means how BOLD is it). Then, I manually set a bold amount, and, finally, I apply a character style that sets the character weight differently. Now, understand that if I do this in a macro, it is not as simple as bold is on or off, I can set a numeric value for it for all three of these things. This level of subtlety does not exist in the WP reveal codes stuff, it is merely on / off. This could be very confusing if I have the three bold settings so that they are all marginally bold (like say 90% bold, 100% bold, and 110% bold). My head hurts now! I assume that this feature (which would be cool to have) has likely not been seriously attempted for integration since a real implementation would require you to deal with these issues. Also, the macro version of the implementation is far from a working implementation. Think of it as a way to troll the code and then show an XML like version of the text in a dialog with certain change types shown; if my memory is correct. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Suggestion.
Some of what you want is easily available as follows: Use Tools | Options to open the options dialog. On the left, expend the section for Writer | Formatting Aids (you may need to have a writer document open at the time) You can then tell it to display things such as Paragraph end, spaces, non-breaking spaces, tabs, breaks, and similar. There is a macro that does something similar here: http://homepages.paradise.net.nz/hillview/OOo/ These were written 10 years back. I vaguely remember running RevealCodes2 or RevealCodes3, and, I think that I needed to fix something so that it would work... I don't really remember. One problem with a reveal codes macro in OOo is that formatting is often not changed based on directly applied formatting, but by styles. This may be a paragraph style, a character style, or, as directly applied formatting. On 05/12/2014 09:06 PM, Sarala Lee wrote: Sir / Madam, For many years I used WordPerfect as my Word Processor and Desktop Publisher to produce a 12 page newsletter. I have never found a better program. As I now have iMac I use Openoffice and have found that satisfies most of my requirements. However there is one very important property (if that's the right word) that WP had that is missing from all the Word Processors that I have used. That is what WP called Reveal Codes, where every change that was made in the document was shown by a particular code. e.g.: Hard return was HRT. If this was not what was wanted then you could make the change you required. Or as sometimes happens in OpenOffice, something happens which I don't understand, I have no way of finding out why. Would it be possible to incorporate this feature in OpenOffice? It would enhance this program's appeal to me and, I'm sure to many others who still hanker for the user friendliness of WP. Gordon Lee. --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: AMAZING -- Case of Subscription via a Remailer Address [was: Re: Removing yourself from the list :)]
On 03/11/2014 12:54 AM, Tubular wrote: Back to OO - your explanation made sense until I saw the inability to send from the remailer subscribed email address. When I subscribed to the list, I didn't have options . . . clicked the link and I was added. I have had it happen, but it is an unusual case not likely seen by a normal user. It had to do with a custom server being improperly configured and then later the incorrect user names being fixed. Based on who owned the email domain, emails subscribed with a specific email address (different name) continued to be received properly, but it was no longer possible to use that name for outgoing email. Odd case. What does v/r mean? Very Respectfully What does IMHO mean? In My Humble Opinion Just saw someone is requesting a change of email address - doesn't that require unsubscribing from the original email address then re-subscribing with the new one? Darn, I just opened another can of worms. I believe you to be correct. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Total Noobie Question--Text Docs (Letters)
Couple of comments: 1. If you are not able to solve your problem based on the provided feedback, respond and say so; for example, I tried your advice, and I had trouble with ... 2. I usually create a document that is configured the way that I want, and then I save that document as a template. https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Getting_Started/Creating_a_template Sounds like you need to modify a page style https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Working_with_page_styles although the advice provided by Chuck (email to the list) will probably do exactly what you want. On 03/04/2014 02:51 PM, MSAESQ wrote: Apologies if I’m in the wrong department. I have used MS Word for years but for many reasons I want to replace it with Open Office. I tried my first business letter today (without making a Template unless a Template will help me in the long run). If I can get ALL of my Open Office Letters set up as follows that would be great but I cannot seem to do it in proper sequence (or at all). Letter Size (8.5” X 11 “); Single Line Spacing; Full Justified Margins without hyphenizations (if the word cannot fit on a line continue full word on next line); Space to each side margins 0.8 “; Space from top: 1.4” Space from bottom : 1.2”; Space between paragraphs: 1 blank line. I’m not sure whether this question (asking for some type of sequencing/selection options/saving) is far too complex for a response or far too simple but I spent 1hour simply trying to setup a Doc/Letter page per the above and it seemed if I got part of it right, other aspects I had no clue. Any dumbed-down assistance appreciated (and will get me away from MS Word). If I’m in the wrong department a link to the correct area of Open Office would be helpful. Thanks, Michael tempr...@hotmail.com -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Document won't open
On 02/27/2014 11:08 PM, Nicholas Micalone wrote: Open Office documents do not open when clicking on a document in Documents. A document will open in Sandboxie, recover mode; however, in front of the title is a tilde and the word Lock. I have attached a screen shot. Please help. I have spent many hours trying to unlock via File Assassin and scanned three times each with Avast, Malwarebytes and Kasperski, all to no avail. No viruses found. My OS is Windows XP SP3, Duckduckgo as a search engine and Firefox as the browser. I am somewhat of a newbie (barely graduated Computer 101 after the third go-around). Thanx; Nick M. I do not know if you are subscribed, so I copied you directly Question 1: If you run AOO and use File Open, are you able to open the file? If yes, then your problem is that the file type is not associated to AOO. I know almost nothing about sandboxie, but, given the description, it is possible that may make it not possible to work. This may help http://support.microsoft.com/kb/307859 -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php
Re: Uninitiateds basic question
On 02/18/2014 09:39 AM, davidbath wrote: Dear Open Office Sorry to be contacting you on this, but I seem to be making little headway with what appears to be just what I need but is way above my head. Someone here will hopefully know the answers :-) I imported a .wdb file which was put into Calc in cell “A” on 92 rows. Did not know we could read wdb files... I needed to Edit 4 records which I discovered how to do but it left the boxes highlighted in red. I do not know what this means and have been unable to remove it. So the background of the cell is red, just the outline is red? I expect that change tracking is turned on, but I am only guessing: https://forum.openoffice.org/en/forum/viewtopic.php?f=9t=11351 I want to sort the complete file but found that the “Sort” selection was greyed out. To me this indicated that some thing else needed to be done first. I tried “Select All” and many other functions but have yet no luck. What if you select only the cells that you want to sort? Is the sort method still greyed out? I have consulted the “Tutorials” but there I cannot find any reference to my problems, in desperation I hope you could point me in right direction. If it is possible that you could assist I would be most grateful. Regards David Bath -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php --- List Conduct Guidelines: http://openoffice.apache.org/list-conduct.html To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: [openoffice] Flipping a table
Having a bit of trouble understanding the question I think that what you want to do is to reverse the order (based on rows), so that the first row becomes the last row and the last row becomes the first row. Although this can be done using a macro, I would probably do something like. 1. Find the last used column in your sheet. For now, lets pretend it is column K 2. In column K, enter the values 1, 2, 3, so K1 contains 1, K2 contains 2, etc. --- Enter 1 in K1, 2 in K2, 3 in K3. Starting in cell K1, drag to cell K3 to select cells K1 through K3. --- In the lower right corner of your selection, you will see a small black box, Hover your mouse cursor over that and it turns into large cross --- Click and drag the mouse down. If you pull it to the bottom, it will continue scrolling. --- Release your mouse and it will have entered the numbers in a continuous way. 3. Select from cell A1 to that last cell in column K 4. Sort your data descending based on column K On 01/15/2014 05:45 PM, Wade Smart wrote: In my calc sheet I have a need to flip the entire sheet. So Column 1A would be 450A? Ive found several macros but Ive not been able to get them to work. Does anyone know if this can be done? Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Help pls, my texts in OO don't wrap when I paste to email.
On 12/18/2013 12:04 AM, d b wrote: For the past week or so, texts that I write in Open Office don't wrap when I paste them into Hotmail or Yahoo to send as emails. This very email is an example. How can I fix this problm? Thanks! Can you clarify? if you enter something like this: paragraph 1 paragraph 2 Do you mean that paragraph 1 and 2 are on the same line, or, do you mean that if paragraph 1 has four lines in your text document and it is not pasted as four lines, but as one line that wraps only for display purposes? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Basic Macro – write a file
On 11/22/2013 06:41 PM, Johnny Rosenberg wrote: Dim iNumber As Integer iNumber = Freefile Open sFilePath For Output As #iNumber Print #iNumber, Line 1 Print #iNumber, Line 2 Close #iNumber The file now looks like this (in hex values): 4C 69 6E 65 20 31 0A 4C 69 6E 65 20 32 0A So every line ends with 0A (Chr(10)). The file is going to be in a special text file format suited for a specific app, so I need every line to end with 0D 0A (Chr(13) Chr(10)). Is that possible? How? Can I see a short example of that, that creates a text file that looks like the following? 4C 69 6E 65 20 31 0D 0A 4C 69 6E 65 20 32 0D 0A Regards Johnny Rosenberg Sadly, the obvious solution fails horribly by stripping the 0x0D Print #iNumber, Line 1 CHR$(13) This solution, however, works just fine! Dim sFilePath$ : sFilePath = /home/MrRosenberg/x.txt Dim oSFA' SimpleFileAccess service. Dim sFileName$ ' Name of file to open. Dim oStream ' Stream returned from SimpleFileAccess. Dim oTextStream ' TextStream service. Dim sStrings' Strings to test write / read. Dim sInput$ ' The string that is read. Dim s$ ' Accumulate result to print. Dim i% ' Index variable. sStrings = Array(One, UTF:Āā, 1@3) ' File to use. sFileName = sFilePath ' Create the SimpleFileAccess service. oSFA = CreateUnoService(com.sun.star.ucb.SimpleFileAccess) 'Create the Specialized stream. oTextStream = CreateUnoService(com.sun.star.io.TextOutputStream) 'If the file already exists, delete it. If oSFA.exists(sFileName) Then oSFA.kill(sFileName) End If ' Open the file for writing. oStream = oSFA.openFileWrite(sFileName) ' Attach the simple stream to the text stream. ' The text stream will use the simple stream. oTextStream.setOutputStream(oStream) ' Write the strings. oTextStream.writeString(Line 1 CHR$(13) CHR$(10)) oTextStream.writeString(Line 2 CHR$(13) CHR$(10)) ' Close the stream. oTextStream.closeOutput() -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office does not initialise
I am glad that things seem to be working fine now. In the future, if OO seems to hang, jump to the task manager and kill the soffice process and/or tasks. I have certainly seen it (on Windows and Linux) hang with nothing displayed. When that happens, a new instance will not properly start until the existing processes are killed. I don't see this often, and I don't even remember what I last saw it. On 11/18/2013 09:21 AM, Iain wrote: Yeah sorry to have not been more explicit. Double click on either Word or Excel type documents do not open (when the reported situation occurs) Trying to double click on the OO short-cut creates a think for half a minute then nothing. Version of OO is 4.0.0, under Window 8. Thank you for your advice. Cannot report as, naturally, OO is doing fine right now. Many thanks for the Task Manager approach suggestion. Iain -Original Message- From: Andrew Douglas Pitonyak Sent: Monday, November 18, 2013 2:02 PM To: users@openoffice.apache.org Subject: Re: Open Office does not initialise I assume you are using windows of some sort. Can you be more specific? I am uncertain exactly what you did and then what happened when you did it. (1) Do you mean that you use Windows Explorer to find a WORD document and then you double click on the WORD document and OO does not open? (2) Do you mean that you use File Open, select a Word document? (3) What if OO is already open and editing a document when you try (1) or (2) If OO has failed in some way, try this to start: Open the task manager (I think you use Control+Alt+Del and then select open the task manager). I think that from the process list (is that what it is called, I am not on a windows box), look for the process labeled soffice, and kill it. If OO is running, make sure that you have saved all documents first, because this should kill OO. On 11/18/2013 06:56 AM, Iain wrote: Hi, Just a small problem. At perceived random times, OO refuses to initialise, either when requested to read Word or Excel type documents. Whenever this occurs a reboot of the Windows machine is required to fix the problem. Are there more succinct ways around this situation? Many thanks, Iain Watson - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Open Office does not initialise
I assume you are using windows of some sort. Can you be more specific? I am uncertain exactly what you did and then what happened when you did it. (1) Do you mean that you use Windows Explorer to find a WORD document and then you double click on the WORD document and OO does not open? (2) Do you mean that you use File Open, select a Word document? (3) What if OO is already open and editing a document when you try (1) or (2) If OO has failed in some way, try this to start: Open the task manager (I think you use Control+Alt+Del and then select open the task manager). I think that from the process list (is that what it is called, I am not on a windows box), look for the process labeled soffice, and kill it. If OO is running, make sure that you have saved all documents first, because this should kill OO. On 11/18/2013 06:56 AM, Iain wrote: Hi, Just a small problem. At perceived random times, OO refuses to initialise, either when requested to read Word or Excel type documents. Whenever this occurs a reboot of the Windows machine is required to fix the problem. Are there more succinct ways around this situation? Many thanks, Iain Watson - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Java Troubles When Trying to Use Mail Merge
Despite Dr. Zarlenga's odd claims, I do believe that it is possible to run Java on Windows. I happen to use Linux, so anything that I say is of course suspect. A few questions for you. 1. What version of AOO are you using? 4.x? For version 3.x, you need Java 6, for AOO 4, you can use 7. 2. What vesrion of Java. Note that I believe that AOO can only use a 32-bit version of Java, not a 64-bit version. 3. Somewhere under Tools Options you can tell AOO where your Java is installed. This must be set I believe. I cannot check the actual path at the moment (since I don't have AOO installed on the machine I am using now). There are some comments here: http://www.openoffice.org/development/releases/4.0.0.html On 11/13/2013 07:35 PM, jjb i.e. Just Jeff Butler wrote: Hello! I've used Open Office for some time now and LOVE IT! I haven't tried using the Mail Merge Wizard feature until today and it kept telling me that I needed Java to run it. I had previously removed Java from my computer because of the problems with it. Anyway, I reinstalled it to try and get Mail Merge to work. Unfortunately, I still can't complete the merge. It can't seem to find Java. I am using Windows 7, 64-bit. Thank you in advance for anything you can do for me. Jeff B. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: File won't open
On 10/01/2013 07:16 PM, Doug wrote: I've just received an attachment consisting of an important legal document as a .docx file. I downloaded Apache 4.0.1 and it won't open the file. (Neither will Textmaker 2012 or WordPerfect 6.) Since this is a personal file, I can't send it to you, but do you have any comment? (It comes from a law office, and they are NOT going to switch to OpenOffice!) --doug So you cannot share the file with some member, that limits things a bit... but it turns out that Microsoft is very good at copying what others have done and they use the same container as an ODF file; a zip container. Save your fail as say x.zip and then see if you can look at x.zip using your favorite zip viewer. If you cannot, then it is not a DOCX file (or it is damaged). -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: VLOOKUP vs Macros
=ADDRESS(1, 3, 1,, sheet1) returns SHEET1.$C$1 =INDIRECT(ADDRESS(1, 3, 1,, sheet1)) returns whatever is stored in the cell referenced by SHEET1.$C$1 On 09/28/2013 11:30 AM, John Meyer wrote: I have a spreadsheet with a number of worksheets. The first worksheet has the bonuses for employees in this format ID, Sales Agent, Sales For Date, Bonus for Date, Sales for Date(N), Bonus For Date (N). . . The rest of the spreadsheets are each named for the date of sales that they contain. They are in the same format as the column header for Sales For Date. I set up each row like this ID static, Agent name static, =COUNTIF(*staticdateworksheet*!ColumnWithIDFirstRow:ColumnWithIDNthRow,Firstcolumnrowiamin),BonusCalculation What I'd like to do is change that formula around to resolve the sheet name by the first row of the salescount ID (i.e. if It's 9-27-2013 it would pull up 9-27-2013, 9-28-2013, etc.). Is this possible? It's not a pressing issue, I'd just like to see if it could be done. Thanks. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Leslie Liddel, how to unsubscribe
Leslie, if you send an email to users-unsubscr...@openoffice.apache.org with no message, does it remove you from the list? On 09/26/2013 06:56 AM, Leslie Liddell wrote: I'm getting these e-mails also. I am a relatively new subscriber. Can you get me off the list? Leslie Liddell Vocatus atque non vocatus, Deus aderit Bidden or not bidden, God is present leslielidd...@gvtc.com On Sep 25, 2013, at 11:53 PM, Peter Junge wrote: John, I'm one of the moderators of this list and I have been unsubscribing a couple of subscribers like Lynn in recent months. I don't share your POV regarding the size of the issue, it just happened twice this week but it doesn't happen every week. Anyway, one theory that we have already been discussing many years ago within the old OOo community is that these kinds of users enter a subscription with a fraudulent provider of OpenOffice that offer them 'support' and managing somehow to get these users subscribed to our mailing list. I have been trying to confirm this theory with some persons I had unsubscribed in the past but they were never willing to discuss so far. So, what should I do? One thing seems clear, this is certainly no technical issue that can be easilty investigated in. Best regards, Peter On 9/26/2013 7:03 AM, John Hart wrote: There are only four messages from Lynn. None asking for help with AOO and It's obvious she didn't request to be on the list, nor anyone else using her email address. How did she get subscribed to the list This has happened quite a few times and it's supposed to be that In order to be subscribe one must reply to an email from the list. That doesn't appear to true in this case or others I've looked in to. Someone should find out how this happened and make sure it doesn't happen again. jrh 4 conversations LYNN BRUBAKER Today Converting sdw files help. I don't know how I got on this email list but can someone get me off. LYNN BRUBAKER Today Backwards compatibility help. I don't know how I got on this email list but can someone get me off. LYNN BRUBAKER Today AOO can't open .xlsx spreadsheet at Cornell site help. I don't know how I got on this email list but can someone get me off. LYNN BRUBAKER 8/24/2013 5:36 AM Help I'm being invaded Every day I get about 10 emails concerning how to work Open Office. Every day I get rid of them by putting them in junk, but the next day I'll get about ten more. I don't think they are people trying to contact Apache Open Office, but the old Open Office - now defunct. Is there any way you can t… These messages take up: 13.9 KB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Lynn Brubaker, how to unsubscribe
Lynn, Did you send an email to users-unsubscr...@openoffice.apache.org On 09/25/2013 07:01 AM, LYNN BRUBAKER wrote: help. I don't know how I got on this email list but can someone get me off. From: tomgol...@yahoo.com To: users@openoffice.apache.org Subject: Backwards compatibility Date: Wed, 25 Sep 2013 02:44:24 + Should text files created with OOo (.odt) containing simple recorded macros (to apply certain formats with a keystroke combination) be able to be read by OpenOffice 3.1? I sent some files out, and it was reported that they were corrupted. It’s an IT guy who said it, so I don’t ASSUME he didn't know to open them with OpenOffice; but I can’t be sure. Anyone tried this feat with success? Sent from Windows Mail -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Backwards compatibility
I have no experience with this, but, try the following: 1. Load the document in question 2. Using Tools | Options to open the Options dialog. 3. Under Load / Save, is there a General section that allows you to set the ODF format version? I can't check on AOO at the moment, but with LO I am set for 1.2 Extended, which I do not know if it is supported by OOo 3.1. On 09/24/2013 10:44 PM, tomgol...@yahoo.com wrote: Should text files created with OOo (.odt) containing simple recorded macros (to apply certain formats with a keystroke combination) be able to be read by OpenOffice 3.1? I sent some files out, and it was reported that they were corrupted. It’s an IT guy who said it, so I don’t ASSUME he didn't know to open them with OpenOffice; but I can’t be sure. Anyone tried this feat with success? Sent from Windows Mail -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: scripts in AOO spreadsheets interpreted by MS excel?
On 09/01/2013 11:23 AM, Gary Aitken wrote: Is this also the case for the spreadsheet (calc) documents? Are they readable by MS excel? If so, are scripts (Java) also generally properly interpreted by MS excel? I was not aware that you could script Excel in Java. Do you mean control Excel in Java, or literally embed a Java Script that is runnable in Excel? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Data Analysis in OpenOffice Calc - Fast Fourier Transform analysis
Sadly, I am not aware of FFT functionality for AOO. On 08/01/2013 10:13 AM, wils_m...@compuserve.com wrote: Hi AOO Users, Does anybody know whether there are any data analysis add-ons for AOO Calac V4.0.0? I am particularly interested in a Fast Fourier Transform routine similar to the one available in the DA extension for MS Excel. Has anyone written an FFT add-on function for AOO Calc? I have a package written for MS Excel which simulates the mixing of two sinusoidal waves and displays both the input and output waveforms on a virtual oscilloscope that uses the graphing feature. The package also has a virtual spectrum analyser that will show the harmonic content of the product waveform but this needs to use the FFT function which is available in MS Excel. I don’t currently use MS Office and would like to run the package in AOO but without an FFT function, I cant use the spectrum analyser to show the harmonic content of the combined waveforms. There are many applications for this type of simulation package and It would be good to be able to use AOO Calc instead of having to rely on MS Excel! Advice on how to go about creating a suitable function would be most appreciated if there are no functions currently available. Regards Geoff Williams -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Codes
On 06/24/2013 10:32 AM, Brian Barker wrote: You'll have noticed, I hope, that I've anyway been corrected: you *can* do this easily in Writer, using Format | AutoCorrect | Apply. Ummm, I had no idea you could do that, but I see that it works That would have saved me at least one macro -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Codes
On 06/23/2013 12:08 AM, Brian Barker wrote: At 22:20 22/06/2013 -0400, Andrew Douglas Pitonyak wrote: At 14:44 22/06/2013 -0400, Doug McGarrett wrote: Now if OO and LO are so great, why can't they deal with curly quotes and apostrophes in imported text? I have to go thru and fix all the damned inch marks one by one by hand. WordPerfect can do that automatically. Not only that, it can differentiate between quote marks and real inch and foot designators. Let's see your OO/LO do that! I am not sure what this is since I have never had any particular difficulty dealing with these things though I am not sure how one can understand that a particular single quote is an inch mark as opposed to a non-curly double quote. I think the reference to an inch mark is simply a way of identifying your (typewriter-style) non-curly double quote. But Mr McGarrett does have a point, I think. OpenOffice Writer will replace typed single and double quotes with what it calls custom quotes quite efficiently as you type. But if you have existing straight quotes in a document (perhaps in an inherited document or in text pasted in from elsewhere), there appears to be no easy way to apply that intelligence after the event. You could replace a straight quote with a curly one, but you'd have to select manually the individual cases where you needed open and close quotes: you cannot at this stage invoke Writer's ability to use its intelligence about this. In some other word processors (dare I mention Microsoft Word if I promise to wash my mouth out?), you can merely replace straight quotes with straight quotes: replacement is treated the same way as typing, the same intelligence is invoked, and curly quotes of the appropriate handedness are substituted en masse. Brian Barker Oh, now I get it WP will auto-magically replace straight quotes with curly quotes when you import a document. For most of what I do, that would really mess things up for me. I did have one document, however, where I desired that beahvior, so I wrote a macro to do it if I remember correctly; would have been nice to have had a built-in command to do it for me already. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: [libreoffice-users] ”Artifacts” in OpenOffice and LibreOffice
On 05/11/2013 12:05 PM, Rory O'Farrell wrote: A fix frequently advised for video oddities in OpenOffice is to disable (turn off) one or both of Video Acceleration and anti-Aliasing in /Tools /Options /OpenOffice.org : View, under Graphics output. Interesting, that had not occurred to me, primarily because I was not aware of them. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: [libreoffice-users] ”Artifacts” in OpenOffice and LibreOffice
I have had subtle redraw issues with OO off and on, and I always blamed it on an interaction between applications and the video drivers. Realize that I use nVidia video cards on 64-bit Fedora using the proprietary video drivers. What I saw was not remotely as bad. Admittedly, when I tried out the latest dev build, it was totally unusable (of course, the single tester was unable to reproduce on Windows 7). see https://issues.apache.org/ooo/show_bug.cgi?id=122214 Are you able to do a test and change your video driver say between the free and not free driver to see if there is a change (I do not use Ubuntu so I don't have a good handle on what drivers are available or how). I used to have exactly the same problem in QT, and it was very bad. I was able to avoid the problem with QT Creator by starting it using -graphicssystem raster Not that I expect this to help you. I did notice that it still has some rendering issues that appeared in the latest versions (I believe it is related to an over-lay issue when you edit a field that assumption allowed me to fix it in the software that I write, but I did not jump into the QT code base). I have seen strange redraw issues so long in OO that correcting for it is almost automatic in my brain (scroll screen up then down to clear) so I cannot even say if I still see the problem. I think I do, but it is for sure not as bad is it used to be for me. I know, that I have rambled on and on I will summarize in saying 1. I have never seen it so bad 2. I have seen screen corruption 3. You may avoid some of it based on the video driver If I had it that bad on my Fedora system, I would likely change my desktop on login to see if it helped. With Fedora, I can easily jump between Gnome and KDE (as one example). I would also try jumping between the two different drivers available to see how that helped as well. Sadly, the free driver is poor with respect to 3D stuff. On 05/11/2013 08:52 AM, Johnny Rosenberg wrote: I have had this problem for quite some time now (months if not years) in LibreOffice and OpenOffice. The problems are maybe a little bit worse in LibreOffice, but I didn't exactly measure it… It looks like a graphics card problem, but why are nothing else affected? It only happens to OpenOffice and LibreOffice. I tested a few versions and it seems to not matter. The screenshots are taken with Apache OpenOffice 3.4.1 and I saw the same thing in LibreOffice 3.5, 3.6 and 4.0. I think this also happened with earlier LibreOffice versions, like 3.4 and 3.3. I didn't use OpenOffice since 3.2 (except 3.4.1, which I use these days), and I don't even remember what it looked like. Here's a screenshot with Apache OpenOffice Calc 3.4.1. I added some arrows pointing at the problem areas: http://ubuntuone.com/0wvqcaN38PC5835t4uJVPv The worst thing is when I try to use the Basic IDE, take a look at this. Very hard to write and edit code when it looks like this: http://ubuntuone.com/4HRPQMpblZT97UxHq5ggzO My operating system is Ubuntu 12.04 and the more stuff I run at the same time, the worse will it look. My graphics card is the nVidia GeForce Go 7300, which is blacklisted for use with the Unity 3D desktop, so that may be what's causing this problem, but still it ONLY happens to LibreOffice and OpenOffice. One thought that I have is that LibreOffice and OpenOffice are not GTK applications (I think – are they?), but on the other hand, neither is my web browser (Opera), and I don't have these problems with it. Both LibreOffice and OpenOffice.org were installed with the official deb files. The LibreOffice version that came with Ubuntu 12.04 was carefully removed before installing what I have now. Thoughts? Anyone else saw this? Packard Bell Easy Note MX66 laptop, made in November 2006. 2.0 GiB RAM, Genuine Intel® CPU T2050 @ 1.60GHz × 2. Ubuntu 12.04 LTS (32 bits) Kernel: Linux 3.2.0-41-generic-pae nVIDIA Driver Version: 304.88 -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: lost password to acct
On 03/02/2013 12:51 PM, marcia...@comcast.net wrote: Had all info on spreadsheets for 3 years in open office computer crashed and hard disk gone had passwords on computer please help reinstate my acct marcia hill marcia...@comcast.net Marcia, can you clarify what you need to reinstate? Are you asking relevant to this mailing list, or are you asking how to get your file back on the bad drive? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Having issues installing in windows
On 02/19/2013 09:23 PM, Support Team wrote: Hi, Just updated to windows 8 used your sortware years not had one issues with your sortware come today had issues installing it on windows 8 will not work could please help me with this one Danny, Can you be more specific? For example, was this a fresh install, did you download directly and then try to install, what happened when you tried to install? http://forum.openoffice.org/en/forum/viewtopic.php?f=5t=57772 -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: user name
Where, exactly, did you register? A forum, wiki, etc... On 02/14/2013 03:30 PM, 514thom wrote: I registered as a user yesterday, but forgot my user name. I have the password, but didn't take note of the user name. Please advise as I've been trying to get through on other links and cannot do anything without the user name. email: *514t...@gmail.com* *Thanks* -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: user name
Copying back to the list so that an appropriate person can see the response. user claims to have created an account on Apache. Unsure where that is. 514thom, can you be more specific? Was there a specific web site? Please respond to the user's list. On 02/14/2013 04:51 PM, 514thom wrote: On Apache to resolve an issue with Open Office. On Thu, Feb 14, 2013 at 4:45 PM, Andrew Douglas Pitonyak and...@pitonyak.org mailto:and...@pitonyak.org wrote: Where, exactly, did you register? A forum, wiki, etc... On 02/14/2013 03:30 PM, 514thom wrote: I registered as a user yesterday, but forgot my user name. I have the password, but didn't take note of the user name. Please advise as I've been trying to get through on other links and cannot do anything without the user name. email: *514t...@gmail.com mailto:514t...@gmail.com* *Thanks*
Re: Microsoft Office issues
I assume that he should have said something like: I am running windows, and when I double click on a DOC file, it opens in AOO rather than MS Word. Is this correct? (just trying to figure out what you mean, as is Regina). On 02/12/2013 02:02 PM, Regina Henschel wrote: Hi, to help you, we need some further informations: (1) Which is your operating system? (2) Which version of Apache OpenOffice or OpenOffice.org do you use? (3) Which kind of Microsoft Office documents do you try to open, for exmaple .doc or .docx or .docx(strict) or .xml or ...? (4) How do you try to open them? For example double click the document icon in the file manager? Or start Apache OpenOffice and use Open from the start window? Or drag the document icon on an application icon? Or...? (5) What is not perform the task exactly? For example nothing happens, or opens in false application or shows text import filter settings or ask for an application to open with or ...? Kind regards Regina martyhundley schrieb: We have Open Office installed on our office computer, but, anytime I try and open a Microsoft Office document (excel, word, etc.), it will not perform the task. We need help in this matter, because I am sure you are aware, although your product serves our purpose, many other clients use Microsoft Office, and we need this issue resolved to help provide them with proper service. Thank you for your help. Marty Hundley Sent from my U.S. Cellular® Smartphone - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Updates
On 02/08/2013 02:18 PM, Dave Raby wrote: Is there a new update address? Regards Dave Raby This feels like a simple question, but I don't understand it. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How? copy a graph exactly (no data table) to another file
On 02/01/2013 02:23 PM, David L Babcock wrote: I have a file for collecting a year's data which I want to duplicate for the next year (2013). Since I am annoyed by a bunch of structural/embedded things that are copied along from year to year when I do a simple rename, I am building a new file, sheet by sheet, by copying each sheet over to it. (This scrambles many of the links between sheets, but I can fix these.) However the graphs so transferred appear in the new file with a data table instead of actual cell ranges, which kills them dead so far as showing changing data. They show a snapshot of last year's last data. I do not want to build anew these graphs, they are complex, with many attribute tweaks. Any ideas? XP, OO 3.4 I have no particular comment on your current process, but is it possible for you to create a template from this (even if you only save a mostly empty copy for next year) so that you can start from the mostly empty stage easily next year. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: I have changed my email address
On 01/26/2013 10:29 AM, George Anstey Webb wrote: Dear Sirs, I already have a password and user name for OpenOffice.org but cannot find where to log in on the website so as to change my email address. I am changing my ISP from Orange to Plusnet. This means changing my email address to geo...@ansteyword.plus.com Are you able to login to any of these three sites? http://wiki.openoffice.org/wiki/Main_Page https://issues.apache.org/ooo/ https://cwiki.apache.org/confluence/display/OOOUSERS/Wiki+Home Does this help? For now, my outgoing emails will still be from my original email address of geo...@ansteyword.fsnet.co.uk until the changeover is complete. Please ensure my address details are changed to ensure your future emails are sent to me from now on at my new email address geo...@ansteyword.plus.com Thanking you for your attention, Kind Regards, George Anstey Webb 14 Kelston Road, Newbridge Hill, Bath, BA1 3QN. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: open-office 3.4
This sounds confusing / unexpected. I am adding some comments inline. I will repeat some items for clarification. You mention exe files, so I assume that you are using Windows. Hopefully someone more well versed in Windows idiosyncrasies will respond as well. On 01/11/2013 04:45 AM, Gabriel Loy wrote: I have been using Apache open office for some time now, You installed Apache OpenOffice (AOO) and have been using it. (I infer that it was installed and working) and have had occaxxional glitches with exe files. What do you mean by glitch? Do you mean that you try to run it and an error occurs, then you run it and it works? If there is an error, be as specific as possible. After downloading the latest update i am now in a virtual lock out situation. When i try to run the software a dialog box tells me there is a problem with soffice and a search initiates whixh end in the same position, ie cannot access the file. I have no means of accesing the files in order to find where or what the problems are. It seems to me that the file is missing or corrupted. Can you help? please Gabriel Loy My recommendation is that you Remove AOO from your computer. Do you know how to uninstall a program? I don't have a windows machine near by, but what you need to do will vary depending on your version of windows. YOu need to do something like Start Control Panel Uninstall Programs That Uninstall part may be called add / remove, or something like that. Find OpenOffice, and remove it. After you uninstall AOO, then, try a full install. This should not take more than 10 minutes to try assuming you already have a copy of the latest AOO to install. Another thought. The install process leaves a directory on your desktop (I believe) that contains a copy of the install files. I assume that you are running AOO by using Start All Programs select AOO rather than from a potentially older short-cut on your desktop. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: User Registration
On 01/09/2013 06:35 PM, Thomas Ferraro wrote: Please register me so that I can help QA Apache Open Office Go here: http://www.openoffice.org/qa/ooQAReloaded/ooQA-ReportBugs.html After skimming the page, you can click on the first link that takes you here to be added: https://issues.apache.org/ooo/createaccount.cgi Welcome to the community -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Unscribe
On 12/15/2012 03:44 PM, Hagar Delest wrote: But many users don't bother trying the hints we give. come now Hagar, it is because you did not do what they really wanted.. 1. Figure out their IP address 2. Break into their computer 3. Fireup their email package 4. Send an email message to users-unsubscr...@openoffice.apache.org You can smack me at any time now :-) It is very easy to miss the unsubscribe line at the bottom. I also suspect that some users do not subscribe to the list. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Listening Mode - Single instance
On 11/29/2012 10:18 AM, Steele, Raymond wrote: Is it possible to open a single instance of calc via loadComponentFromURL() in listening mode. The instructions here, http://wiki.openoffice.org/wiki/Documentation/DevGuide/ProUNO/Starting_OpenOffice.org_in_Listening_Mode, define editing a Setup.xcu file, but the information here, https://issues.apache.org/ooo/show_bug.cgi?id=117803, says that Setup.xcu no longer exist in version 3.3. Apparently, I could update the main.xcd file, but I only want listening mode when a specific application opens calc because another application will need to close that instance. I'd prefer not use a script to launch soffice -accept=socket,host=0,port=2002;urp;. Raymond My initial reaction is that Calc does not listen, OpenOffice listens. So are you saying that as soon as a Calc document is opened, you want OOo to start listening? Off hand, I don't think that you can do that. I believe that the choice must be made when OOo begins (not sure how that plays into the whole quick-starter stuff). You do not mention your operating system, but, you might be able to configure another copy of OOo for a different user or location that is configured to use it. I have seen comments on this in the past, I don't remember the details. I ran a quick google query using running two instances of OOo at the same time and it returned links into oooforum.org, which has been highly unreliable lately, and I could not connect. Give it a try and maybe it will work for you. The idea is to use two different OOo profiles so that you can have two different instances. Then, you can choose which instance you want to run. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org