Re: Openoffice is terrible
On Sat, 18 Oct 2014 16:42:52 -0500 Alexandro Colorado j...@oooes.org wrote: lots of replies for someone that never came back to clarify its point. Is clearly a spam email. snip [RoryOF] There have been other emails in this thread towards the same point, which I won't quote. The INVALID marker in the yahoo.com address seems to be added by the Apache listkeeper and must be removed manually before replying to the OP. I have received a personal reply from him which elaborates on the points he makes. Below I echo this to the list. I am not a Calc user in other than the most trivial sense (one A4 page of simple calculation); I have also not used a Mac in 35+ years, so am beyond my knowledge in this. [/RoryOF] Detailed email received: - Thanks Rory. The file I downloaded was the full installation for Mac OSX 64-bit DMG at http://www.openoffice.org/download/index.html I mainly use it for the spreadsheets. I'm somewhat reticent to try it again but at this point I have a bunch of spreadsheets in the .ods format now and the idea of converting them to use in Excel (which, if it weren't for the bugs in Openoffice, would actually be an inferior program in some respects). I'm willing to accept the issue with my middle mouse button may be something more complicated. I remember uninstalilng an earlier version of Openoffice and the problem went away. I don't honestly have many times when I wish to use it, so it's one of the lesser issues. However now having uninstalled version 4.1 the issue still persists, so for all I know, it is something else, despite the fact that I thought i had pinned it down to Openoffice. The other weird thing is that I was using 4.0 but now when I go to that same link and try to download a full installation for 4.0, it says that there is none available for my system. I don't know how I installed it before if there is no installer for it. By far the most annoying bug from 4.0 was the scrollbar issue. As mentioned, with large spreadsheets, scrolling down very far caused it to be very difficult to return up. You could do it, but it would go very slowly. It would not let you drag the bar up as quickly as you wanted. You could scroll up with the middle mouse wheel but that would take forever with the size of documents I'm talking about (I'm not sure what the cut-off was, but imagine several hundreds to thousands of rows of spreadsheet). Usually I would just have to return to the top by searching for known contents of an earlier cell or using the go to cell feature, which is obnoxious. And I know I'm not the only one who has this problem because I've read about it as a known issue. Whether or not it persists in 4.1 I have no idea because the program wouldn't even launch completely. Overall, I wish that Openoffice would work better because there are advantages to it. An .ods spreadsheet is much smaller than an .xls file of the exact same spreadsheet, for one. I believe the find function is also better in Openoffice than Excel (at least the version I have). I admit that not being able to even sign up for the support forum was the thing that broke my patience entirely, plus the inability to now even revert to using the version of the program I had been using for lack of installer. By the way, if you're curious, I'm using a Mac Pro 2.1, 2 x 3ghz Quad core Intel Xeon with 16 gb of RAM (most support people inevitably want to know what your system is). On Saturday, October 18, 2014 4:27 AM, Rory O'Farrell ofarr...@iol.ie wrote: On Fri, 17 Oct 2014 23:08:50 -0700 michael sintros mbsint...@yahoo.com.INVALID wrote: Your software is so terrible that I lack the appropriate words to describe it. I have used version 4.0 for a long time now. It functions... barely. Using the side scroll bar in large documents, once you scroll to the bottom, it will not let you scroll back up. This is incredibly mindbogglingly annoying. The software also hijacks my middle mouse button and regardless of the application, will not function at all if the software is installed at all. This is not only annoying but creepy. Why if Openoffice is installed but not even open does it affect the behavior of other programs. Ridiculous. Now I see that 4.1 has been released. With hope that some of these issues would be fixed I installed it on my computer. It took several minutes for the program to not even open at all, giving me not responding messages, hijacking my computer so that I couldn't even do things in other applications and finally I had to force quit it. If all of that weren't bad enough, I went on your support forum to talk about this but I can't even register. Why? Who the fuck knows. It keeps telling me that I need a valid email address even though I've entered my email address about 800 times. Not only are you people incapable of writing a fully functional program,
Re : Re: Openoffice is terrible
Indeed, OP has subscribed on Fri May 10, 2013. Username: goldenhelix You can request a new password, with the standard form (forgot password) you access from the login page. Note that you can give the username OR the mail address, you don't need to fill-in both fields. Hagar - Mail d'origine -De: Andrea Pescetti pesce...@apache.orgAgrave;: users@openoffice.apache.orgCc: michael sintros mbsint...@yahoo.comEnvoyeacute;: Sat, 18 Oct 2014 11:18:37 +0200 (CEST)Objet: Re: Openoffice is terrible Rory O'Farrell wrote: On Fri, 17 Oct 2014 23:08:50 -0700 michael sintros wrote: If all of that weren't bad enough, I went on your support forum to talk about this but I can't even register. Why? Who the fuck knows. It keeps telling me that I need a valid email address even though I've entered my email address about 800 times. ... With regard to your experience logging on to the User support forum, I am sure that when a Forum Administrator comes online he will look into this. Apparently one of the 800 times you succeeded. The e-mail address mbsintrosATyahoo.com is in use on https://forum.openoffice.org/en , meaning that there is an account associated with that e-mail address. When you registered, you also chose a username and a password. Use those two to login. You can (but you must remember at least the username you chose) have a new password e-mailed to you (or have the activation e-mail resent to you) from https://forum.openoffice.org/en/forum/ucp.php?mode=login If you don't even remember the username you chose, we can investigate it for you. Regards, Andrea. -To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional commands, e-mail: users-h...@openoffice.apache.org
Fatal error when exporting a dialogue.
I tried this with the same file in both Apache OpenOffice Calc and LibreOffice Calc, the same result. Error message: Apache OpenOffice Calc: ”StringResourceImpl: No entry for resourceID:” If I click OK, Apache OpenOffice Calc crash. The file is saved but loading it doesn't work. Nothing happens. LibreOffice Calc: ”StringResourceImpl: No entry for resourceID: !!br0ken!!” LibreOffice Calc crash when clicking OK. The file is saved but loading it makes LibreOffice Calc crash. The file is quite big. It takes about 23 seconds to open it with LibreOffice Calc and 51 seconds with Apache OpenOffice. Apache OpenOffice 4.1 LibreOffice 4.2 Ubuntu 14.04 My question is: What does this error message mean? Can I do anything about it? Like editing my dialogue somehow before trying to export it? Seems like some parameter somewhere is missing for some reason. An earlier version of the dialogue can be exported and imported without any problems. The difference between the new and the old dialogue is that I added a label and a number field to the new one. I did that by copying and editing existing ones. Maybe something was lost during that process. Any hints will be appreciated. I guess I could just start all over again and create a new one, but I want to know (if possible) what's wrong with the one I already have. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ
Re: Openoffice is terrible
Could I add my two bob's worth, as a long-time Mac Calc user. I am assuming the following was written by Michael (who is receiving this in copy), even though I found it in Rory's message: On 19/10/14 at 5:59 PM, ofarr...@iol.ie (Rory O'Farrell) wrote: By far the most annoying bug from 4.0 was the scrollbar issue. As mentioned, with large spreadsheets, scrolling down very far caused it to be very difficult to return up. You could do it, but it would go very slowly. It would not let you drag the bar up as quickly as you wanted. You could scroll up with the middle mouse wheel but that would take forever with the size of documents I'm talking about Are you familiar with the Cmd+arrow (up or down) key combination? I've found this to be by far the fastest way to scroll up and down long spreadsheets, as it brings up (or down) the last empty or filled cell. Alternatively, if you want to scroll to a certain point, you can simply click once to select any cell, and then keep the required arrow pressed until you reach the desired cell. Or you can use the Find command to locate any cell with given data. In fact, your point made me realise I never use the scrollbar! :-) Hope this helps a bit, marina - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Openoffice is terrible
Martin Groenescheij wrote: the OP email address is quite strange: mbsint...@yahoo.com.INVALID The .INVALID is added by the Apache mailing list management software, and it is a workaround to circumvent a new policy in use at Yahoo. See the archives of this list or the Apache Infra blog for more information. So if one wants to CC the original poster it is enough to remove .INVALID and only keep yahoo.com, which is what most of us did. Regards, Andrea. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
OS X Yosemite Compatibility
Good morning. I have been using OpenOffice for many years getting away from Microsoft’s Works. Converted all my word excel files into OpenOffice. In January I switched to a Apple iMac desktop computer and quickly downloaded OpenOffice. Question: I have the opportunity to upgrade for free to the new OS X Yosemite from Maverick and would like to know if Openoffice 4.1.1 will work on Yosemite. I use it daily and need to access the spreadsheet I made for my checking, savings and credit card entries. Thank you for your great product and your help. Dan Ranich
RE: OS X Yosemite Compatibility
Well, I haven't switched to 4.1.1 yet - I am extraordinarily lazy. But I did migrate to Yosemite this past Friday and 4.1.0 seems to be fine. I may be mistaken but I don't think that x.1 and x.0 are all that different except for a nice magic mouse fix. I have been working around that problem so I haven't upgraded to x.1. From: daniel.ranich8...@yahoo.com.INVALID Subject: OS X Yosemite Compatibility Date: Sun, 19 Oct 2014 08:42:31 -0400 To: users@openoffice.apache.org Good morning. I have been using OpenOffice for many years getting away from Microsoft’s Works. Converted all my word excel files into OpenOffice. In January I switched to a Apple iMac desktop computer and quickly downloaded OpenOffice. Question: I have the opportunity to upgrade for free to the new OS X Yosemite from Maverick and would like to know if Openoffice 4.1.1 will work on Yosemite. I use it daily and need to access the spreadsheet I made for my checking, savings and credit card entries. Thank you for your great product and your help. Dan Ranich
comparing content of cells
Hello, I have a question; -I have a column with names A , and then several columns (B-F) with formula's that result in an empty cell but sometimes in a name or a symbol. (each name has it's own row, and a name cannot pop up in another row) -On another page a want columns (H-L) that give only those situations when a name in A is also found in B-F but only the names, without the empty cells inbetween. So a long list with only a few names and many blancs is reduced to a short list of lets say 3 or 4 names Any way how this can be done? thnks, Bryan Sent from my mobile device. On 19 Oct 2014, at 9:01 am, Dan Lewis elderdanle...@gmail.com wrote: On 10/18/2014 05:42 PM, Alexandro Colorado wrote: lots of replies for someone that never came back to clarify its point. Is clearly a spam email. huge snip Or is it likely that the OP did not subscribe to this mailing list and has missed all if not many of the comments made? If so, not having received them, the OP might be even more angry. He is not subscribed and my reply to him bounced. Most of these email problems are wit yahoo the OP email address is quite strange: mbsint...@yahoo.com.INVALID Or, there is also the possibility that the person is a troll. Dan - 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
Is there a way for a Basic macro to detect what application is running it?
Here's my problem: I have both Apache OpenOffice and LibreOffice installed and I use them both. I have quite a few Calc files with Basic macros. Today I found my first difference between the Basic API in LibreOffice vs. Apache OpenOffice: Dim Dlg As Object, Ctl As Object DialogLibraries.LoadLibrary(Standard) Dlg=CreateUnoDialog(DialogLibraries.Standard.ElDialog) Ctl=Dlg.getControl(DateField) Now, I want to use Ctl.setDate(myDate) and myDate=Ctl.getDate(), and here's the difference: In Apache OpenOffice, myDate is a Long. Today's date, 2014-10-19, is represented as 20141019. I made two functions to convert to and from the format I needed. When running my macro in LibreOffice, the macro was interrupted by an error message, of course. After some debugging I found that the LibreOffice version of Ctl.setDate/Ctl.getDate works with a struct: Type DateType Year As Long Month As Long Day As Long End Type This is of course not a big deal, I can make the macro accept both formats, but the macro need to know if LibreOffice or Apache OpenOffice is running it. How can I do that? I have tried to find the answer myself, both using xray and searching the web, but so far nothing. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ
Cannot Install OpenOffice v 4.1.1 on Linux
Cannot Install OpenOffice v4.1.1 Used your extensive (but not detailed enough for 80 year old enthusiasts!!) help pages. Am using Linux Am using kubuntu 14.04 (now LTS version) - Desktop version Terminal: bumpy@bumpyputer:~$ whereis soffice soffice: /usr/bin/soffice /usr/bin/X11/soffice -remove the symlink. How?? Do not have another older version of Open Office – NO -using Libre Office Java – The current version is installed * Linux Kernel version 2.6.18 or higher YES – latest 64-bit * glibc2 version 2.5 or higher -NO won't install * gtk version 2.10.4 or higher -NO won't install * Pentium III or later processor-AMD ATHLON X4 645 Processor * 256 MB RAM (512 MB RAM recommended) - 8 Gig * Up to 1.55 GB available hard disk space -100 G * X Server with 1024x768 resolution (higher resolution recommended), with at least 256 colors - 1920x1080 * Window Manager- Linux version * Gnome 2.16 or higher, with the gail 1.8.6 and the at-spi 1.7 packages, required for support of assistive technology tools (AT tools). - Using kubuntu (desktop) - at-spi 1.7 packages - NO - selected libatk (2.10.2-2ubuntu1) … instead -My adaptor:amd64 Graphics: Nvidia GeForce GTX 550 4.4.0 NVIDIA 331.38 So far am not impressed with OpenOffice. Where could I get DETAILED instructions for an 80 year old guy? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Cannot Install OpenOffice v 4.1.1 on Linux
Make sure soffice exist and is not a broken link in /usr/bin/soffice If you install OpenOffice from our website, it will reside on /opt/OpenOffice/program/soffice Otherwise, please check the pacakge information, googling here is the openoffice package for Kubuntu: https://launchpad.net/~apacheopenoffice However is terribly outdate (3.4) currently we are on 4.1.1 My best recomendation is to download from our website. On 10/19/14, Peter bumpy...@gmail.com wrote: Cannot Install OpenOffice v4.1.1 Used your extensive (but not detailed enough for 80 year old enthusiasts!!) help pages. Am using Linux Am using kubuntu 14.04 (now LTS version) - Desktop version Terminal: bumpy@bumpyputer:~$ whereis soffice soffice: /usr/bin/soffice /usr/bin/X11/soffice -remove the symlink. How?? Do not have another older version of Open Office – NO -using Libre Office Java– The current version is installed * Linux Kernel version 2.6.18 or higher YES – latest 64-bit * glibc2 version 2.5 or higher-NO won't install * gtk version 2.10.4 or higher-NO won't install * Pentium III or later processor -AMD ATHLON X4 645 Processor * 256 MB RAM (512 MB RAM recommended) - 8 Gig * Up to 1.55 GB available hard disk space -100 G * X Server with 1024x768 resolution (higher resolution recommended), with at least 256 colors - 1920x1080 * Window Manager - Linux version * Gnome 2.16 or higher, with the gail 1.8.6 and the at-spi 1.7 packages, required for support of assistive technology tools (AT tools). - Using kubuntu (desktop) - at-spi 1.7 packages - NO - selected libatk (2.10.2-2ubuntu1) … instead -My adaptor:amd64 Graphics: Nvidia GeForce GTX 550 4.4.0 NVIDIA 331.38 So far am not impressed with OpenOffice. Where could I get DETAILED instructions for an 80 year old guy? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Is there a way for a Basic macro to detect what application is running it?
There sure be an environmental variable somewhere related with the application build version that will have the libreoffice / openoffice delimiter. One way is to consult the Setup.xcu of the product. Here is a forum post with a python script that looks there, however this is for PyUNO des. a Basic should in theory be simpler. https://forum.openoffice.org/en/forum/viewtopic.php?f=44t=19202 On Sun, Oct 19, 2014 at 2:06 PM, Johnny Rosenberg gurus.knu...@gmail.com wrote: Here's my problem: I have both Apache OpenOffice and LibreOffice installed and I use them both. I have quite a few Calc files with Basic macros. Today I found my first difference between the Basic API in LibreOffice vs. Apache OpenOffice: Dim Dlg As Object, Ctl As Object DialogLibraries.LoadLibrary(Standard) Dlg=CreateUnoDialog(DialogLibraries.Standard.ElDialog) Ctl=Dlg.getControl(DateField) Now, I want to use Ctl.setDate(myDate) and myDate=Ctl.getDate(), and here's the difference: In Apache OpenOffice, myDate is a Long. Today's date, 2014-10-19, is represented as 20141019. I made two functions to convert to and from the format I needed. When running my macro in LibreOffice, the macro was interrupted by an error message, of course. After some debugging I found that the LibreOffice version of Ctl.setDate/Ctl.getDate works with a struct: Type DateType Year As Long Month As Long Day As Long End Type This is of course not a big deal, I can make the macro accept both formats, but the macro need to know if LibreOffice or Apache OpenOffice is running it. How can I do that? I have tried to find the answer myself, both using xray and searching the web, but so far nothing. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Alexandro Colorado Apache OpenOffice Contributor 882C 4389 3C27 E8DF 41B9 5C4C 1DB7 9D1C 7F4C 2614