[users] Re: Reg: Help

2012-03-05 Thread Dennis E. Hamilton
If you have Excel files that are encrypted with a password, those files cannot be opened by current OpenOffice.org releases under any conditions. If you have Excel files with protected fields or have a fully-protected (read-only) document, it is true that those Excel files are no longer protecte

[users] Re: Online updates

2012-01-23 Thread Dennis E. Hamilton
What link do you mean? ooo-users-subscr...@incubator.apache.org is an e-mail address and I just tested it by successfully subscribing under one of my own addresses. - Dennis -Original Message- From: Robert Holtzman [mailto:hol...@cox.net] Sent: Monday, January 23, 2012 13:33 To: user

[users] Re: Spreadsheet just continues to open columns

2012-01-22 Thread Dennis E. Hamilton
Take a look at the forums and these pages: Sometimes this problem may be related to automatic updating of cells on load of the document. There is some a

[users] Re: spam via kenai server

2012-01-13 Thread Dennis E. Hamilton
Please forward a plaintext copy of the complete spam message with its headers to me, if you don't mind. Also, which OOo forum are you talking about? This: < http://user.services.openoffice.org/en/forum/>? - Dennis E. Hamilton tools for document interoperability, <http:

[users] Re: deleting

2011-12-27 Thread Dennis E. Hamilton
Hi Margaret, 1. If you would rather not receive mail except for topics that you have requested help for, you might find the OpenOffice Community Forums more to your liking: . 2. About deleting files. a. There is no direct way to delete already-

[users] Re: Is this list now death?

2011-12-17 Thread Dennis E. Hamilton
Yesterday, 2011-12-16 (UTC-0800), there were ten messages on ooo-users@ incubator.apache.org. Coincidentally, there were about the same number on this list, users@ openoffice.org. I don't keep track for [libreoffice-users] but I see that there is double that traffic already today, Saturday (UT

[users] Re: List Migration Prospects (was RE: Re: Hi)

2011-12-15 Thread Dennis E. Hamilton
(was RE: Re: Hi) On Thu, Dec 15, 2011 11:04:55 AM -0800, Dennis E. Hamilton wrote: > The one problem that I am aware of is the inability for folks to > know whether a post is from a non-subscriber or not. (this is the 4th or 5th time since 2002 I explain the same thing on this list, so I&#

[users] Re: List Migration Prospects (was RE: Re: Hi)

2011-12-15 Thread Dennis E. Hamilton
. That is something moderators can modify. This discussion might be better on ooo-users@ incubator.apache.org, of course. - Dennis -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Thursday, December 15, 2011 11:05 To: 'M. Fioretti'; users@open

[users] Re: List Migration Prospects (was RE: Re: Hi)

2011-12-15 Thread Dennis E. Hamilton
@openoffice.org Subject: [users] Re: List Migration Prospects (was RE: Re: Hi) On Wed, Dec 14, 2011 13:20:50 PM -0800, Dennis E. Hamilton wrote: > The lists are not being transferred (the lists and their current > archives will completely disappear except where 3rd parties have > established

[users] Re: List Migration Prospects (was RE: Re: Hi)

2011-12-15 Thread Dennis E. Hamilton
Well, as you can tell, Apache OpenOffice folk are subscribed to some of these lists. It is helpful to make the suggestions about ooo-users on ooo-users of course. And I must remember to collect the actions I have given myself somewhere that won't be overlooked and forgotten. With regard to po

[users] Re: Will OOo be killed?

2011-12-14 Thread Dennis E. Hamilton
"I wonder if they will need to migrate that one after it moves out of incubator stage..." No. That transfer can and will be done automatically. - Dennis -Original Message- From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] Sent: Wednesday, December 14, 2011 13:44 To: users@ope

[users] List Migration Prospects (was RE: Re: Hi)

2011-12-14 Thread Dennis E. Hamilton
rivate responses. - Dennis -Original Message- From: Mike Scott [mailto:m...@scottsonline.org.uk] Sent: Wednesday, December 14, 2011 09:04 To: users@openoffice.org Subject: [users] Re: Hi On 14/12/11 16:49, Dennis E. Hamilton wrote: > The subscription address for the Apache OpenO

[users] Re: Is this list now death?

2011-12-14 Thread Dennis E. Hamilton
For the record, it is not known how the lists became constipated. It seems to have happened with all of them. They are now all working, according to the list moderators who have reported. It is true that the @openoffice.org lists will be retired. There will be more notification when that is

[users] Re: Will OOo be killed?

2011-12-14 Thread Dennis E. Hamilton
Earlier in 2011, Oracle announced the intention to transfer OpenOffice.org to a community-based development project. On the first of June, 2011, Oracle licensed the code base to the Apache Software Foundation (ASF), for development under the Apache License. The trademarks and logos are also tr

[users] Re: Hi

2011-12-14 Thread Dennis E. Hamilton
The subscription address for the Apache OpenOffice users list is . Send a message from the e-mail address you want to be subscribed. Respond to the confirmation that is returned by the list robot. If for some reason your request bounces (it happens), report that and your request to . Also, as

[users] Re: Support Required

2011-11-22 Thread Dennis E. Hamilton
I don't know whether you will attract an answer here. Other places you can try include 1. The LibreOffice users list, us...@global.libreoffice.org, with subscription by sending an empty message to users+subscr...@global.libreoffice.org 2. The OpenOffice.org Community Forums at

[users] Re: using functions inside functions

2011-11-22 Thread Dennis E. Hamilton
nding cases, =VALUE(LEFT(TRIM(QUOTIENT(SUM(C35:C40),10)),1))+MOD(SUM(C35:C40),10) -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Tuesday, November 22, 2011 18:37 To: 'Anthony Chilco'; users@openoffice.org Subject: [users] Re: using functions i

[users] Re: using functions inside functions

2011-11-22 Thread Dennis E. Hamilton
This only works for numbers greater than 9 (assured in the problem statement) less than 100. Try this puppy: =VALUE(LEFT(TRIM(SUM(C35:C40)),1)+MOD(SUM(C35:C40),10) TRIM has the nice property of forcing text from a scalar and delivering text as the result. Shh, pass it on. - Dennis -Or

[users] Re: what happened to the extensions?

2011-11-20 Thread Dennis E. Hamilton
unday, November 20, 2011 18:51 To: users@openoffice.org Subject: [users] Re: what happened to the extensions? On Sun, 2011-11-20 at 18:38 -0800, Dennis E. Hamilton wrote: > Do not use ooo-site.apache.org. That is not the live site. That is a > staging site for conversion of the m

[users] Re: what happened to the extensions?

2011-11-20 Thread Dennis E. Hamilton
Do not use ooo-site.apache.org. That is not the live site. That is a staging site for conversion of the material and verification of the Apache project authoring and content-maintenance process in anticipation of a cut-over. The live site will continue to be whatever is at http://openoffice.o

[users] Re: Locale Setting suggestion

2011-11-10 Thread Dennis E. Hamilton
fy the locale repertoire. -Original Message- From: Eustace [mailto:emf...@gmail.com] Sent: Thursday, November 10, 2011 00:04 To: users@openoffice.org Subject: [users] Re: Locale Setting suggestion On 2011-11-09 15:29 Dennis E. Hamilton wrote: > It's not so much US Army (especi

[users] Re: Locale Setting suggestion

2011-11-09 Thread Dennis E. Hamilton
It's not so much US Army (especially historically) as ISO and the international standard for recording dates. My computer allows me to do that no matter what my Locale is, although not all of my applications pay attention. It is easier to set in some applications, not in others. Perhaps ano

[users] FW: [libreoffice-users] MS font exploit

2011-11-05 Thread Dennis E. Hamilton
xploit was already being discussed. (I had not dug into EOT at the time that I wrote the following.) -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Saturday, November 05, 2011 11:19 To: 'us...@global.libreoffice.org' Subject: RE: [libreoffic

[users] Re: Apache SPF bounces

2011-10-07 Thread Dennis E. Hamilton
nt: Friday, October 07, 2011 12:05 To: users@openoffice.org Subject: [users] Re: Re: Mark Bourne wrote: > Dennis E. Hamilton wrote: >> [BCC: to ooo-dev @i.a.o] >> >> Mark, >> >> It could be a configuration problem with AOOo Bugzilla, or a >> disconnect in reco

[users] Re: Bounced ooo-dev mail

2011-10-07 Thread Dennis E. Hamilton
e.mbou...@spamgourmet.com [mailto:openoffice.mbou...@spamgourmet.com] Sent: Friday, October 07, 2011 11:56 To: users@openoffice.org Subject: [users] Re: Re: Dennis E. Hamilton wrote: > 2. Was the bounce from ooo-dev itself or from someone on the list whose > e-mail system bounced your post? (I&#x

[users] Re: (unable to make Additional Comments on AOOo bugzilla)

2011-10-07 Thread Dennis E. Hamilton
ent fails. I tried emailing the ooo-dev list on incubator.apache.org, but that list bounced my emails due to SPF records not matching. Someone else forwarded my original message, and I've been watching the archives of that list in case any responses turn up there. Mark. Dennis E. Hamilt

[users] Re: Please comment on a bug to have mail sent to OP.

2011-10-07 Thread Dennis E. Hamilton
Dotan, I checked the bugzilla and the email that it has for you as the submitter of that bug. It is your @OO.o email address. If you changed the forwarding of that at OO.o, it should work. I sent you an e-mail so that you can verify that. Also, for others who have bugs in the OO.o bugzilla t

[users] Re: Calc: Sort double columns

2011-10-03 Thread Dennis E. Hamilton
at 20:08, Dennis E. Hamilton wrote: > I think it can all be handled. First, eliminate the merged cell > that has the number in it. Just have the top of the two have the > number and make the border between the empty cell underneath invisible. > > Secondly, make a column that

[users] Re: (Calc Linking and IPAD support)

2011-10-03 Thread Dennis E. Hamilton
Xavier, This is an English list. Esta es una lista Inglés. Por favor, visite Please visit <http://es.openoffice.org/> <http://user.services.openoffice.org/es/forum/> <http://openoffice.org/projects/es/lists> - Dennis E. Hamilton tools for document interoperability, &l

[users] Re: Calc: Sort double columns

2011-10-03 Thread Dennis E. Hamilton
response following Mark's -Original Message- From: openoffice.mbou...@spamgourmet.com [mailto:openoffice.mbou...@spamgourmet.com] Sent: Monday, October 03, 2011 10:44 To: users@openoffice.org Subject: [users] Re: Calc: Sort double columns Dotan Cohen wrote: > I am reviewing the records

[users] Re: Problems with opening

2011-10-02 Thread Dennis E. Hamilton
Rick Hayden says: > ... I keep getting "Fatal > Error" message that states that the application cannot be started > due to my access rights missing. I have to uninstall Open Office , > then reinstall, but the problem still exists. I have folders that > have very important information and it's ver

[users] [ANNOUNCE] OASIS Standard ODF 1.2 Approved

2011-09-30 Thread Dennis E. Hamilton
The OASIS ODF 1.2 Committee Specification 01 has been successfully advanced to an OASIS Standard, . The final ballot results for approval of OASIS Standard ODF 1.2 is at

[users] Re: Newsletter/single day of communication

2011-09-29 Thread Dennis E. Hamilton
Go to this page: . Make sure you are logged in via your OpenOffice.org ID. All will be revealed to you. - Dennis -Original Message- From: Juanita Jaime-McGrew [mailto:movebeyondyourlim...@gmail.com] Sent: Thursday, September 29, 2011 12:27 To:

[users] Re: Can't download your program for Windows

2011-09-26 Thread Dennis E. Hamilton
I think you're better off using the official openoffice.org site for the download, . Use the "I want to download OpenOffice.org". All Windows versions of OpenOffice.org are 32-bit (x86), but they install and run on 64-bit Windows just fine. - Dennis -Origina

[users] Re: Help with writing macro

2011-09-21 Thread Dennis E. Hamilton
>From your example, there is potentially another way to solve this in Calc >formulas. You can specify a list of references that would then be a single parameter: =MACRO(A13~D15~C1) For example, =SUM(A13~D15~C1) works. The question is, how does the definition of the macro specify that it a

[users] Re: ooo-users on Gmane

2011-09-19 Thread Dennis E. Hamilton
bcock [mailto:ol...@rochester.rr.com] Sent: Monday, September 19, 2011 06:45 To: users@openoffice.org Subject: [users] Re: ooo-users on Gmane On 9/16/2011 12:51 PM, Dennis E. Hamilton wrote: > The Apache list is a new list, not a migration of any existing list. > > How it works with GMANE is

[users] Re: ooo-users on Gmane

2011-09-16 Thread Dennis E. Hamilton
The Apache list is a new list, not a migration of any existing list. How it works with GMANE is however adding any lists that you read under GMANE works (i.e., subscribing via NNTP). If you subscribe to ooo-users@ incubator.apache.org directly, you will need to go through an e-mail verificati

[users] Re: Cannot down Extensions Templates

2011-09-11 Thread Dennis E. Hamilton
As far as I know there has been no movement to Apache servers and the domain has not been directed to anywhere else than it has been all along. Furthermore, the OSUOSL laboratory location is not under control of Oracle or Apache. It just happens to be reachable via a subdomain of the openoffi

[users] Re: Cannot down Extensions Templates

2011-09-11 Thread Dennis E. Hamilton
Yes, there seems to be some problem with either the OSUOSL site or with the resolution of the URL. There was a problem like this in July and the issue was with services running at OSUOSL, the Open Source Laboratory at Oregon State University, where e

[users] Re: [ANN] This list is migrating to ooo-us...@incubator.apache.org

2011-09-04 Thread Dennis E. Hamilton
22:36 To: users@openoffice.org Subject: [users] Re: [ANN] This list is migrating to ooo-us...@incubator.apache.org On 2011-09-04 11:04 PM Dennis E. Hamilton wrote: > For reasons that I cannot explain, some messages were delayed in going to the > e-mail. I received this one and a couple of

[users] Re: [ANN] This list is migrating to ooo-us...@incubator.apache.org

2011-09-04 Thread Dennis E. Hamilton
For reasons that I cannot explain, some messages were delayed in going to the e-mail. I received this one and a couple of others two days later than I saw them on the archive of the list. This happens. It was apparently a routing or email-queue kick-off quirk where these messages arrive so mu

[users] Re: Status of OpenOffice.org Preservation/Migration with Apache

2011-09-04 Thread Dennis E. Hamilton
able list of related pages as well. - Dennis -Original Message- From: Dennis E. Hamilton [mailto:dennis.hamil...@acm.org] Sent: Saturday, September 03, 2011 09:14 To: users@openoffice.org Subject: [users] Status of OpenOffice.org Preservation/Migration with Apache [ ... ] GENERAL

[users] Re: Status of OpenOffice.org Preservation/Migration with Apache

2011-09-03 Thread Dennis E. Hamilton
nux_m...@clear.net.nz] Sent: Saturday, September 03, 2011 18:53 To: users@openoffice.org; dennis.hamil...@acm.org Subject: Re: [users] Status of OpenOffice.org Preservation/Migration with Apache On Sunday 04 September 2011 04:14, Dennis E. Hamilton wrote: > > MIGRATION OF LISTS > I recommend the Ta

[users] [ANNOUNCEMENT] OO.o Bugzilla Now Supported at Apache

2011-09-03 Thread Dennis E. Hamilton
SUMMARY 1. The OpenOffice.org Bugzilla Issue Tracker at is now Read-Only. New bugs cannot be entered. Existing issues can be reviewed. Existing issues cannot be modified or updated. 2. The complete Buzilla Issue Tracker is now move to the Apache OOo Bugzill

[users] Re: [ANN] This list is migrating to ooo-us...@incubator.apache.org

2011-09-03 Thread Dennis E. Hamilton
[ANN] is an abbreviation of ANNouncement and has been used on newsgroups and mailing lists for many years. (It is not specific to OOo in any way.) Evidently, the convention is not so widely known as the poster thought. - Dennis -Original Message- From: Richard Detwiler [mailto:rldet

[users] Status of OpenOffice.org Preservation/Migration with Apache

2011-09-03 Thread Dennis E. Hamilton
[I am starting a new thread, although this is in response to threads by Mike Scott and David B. Teague] Over time, there will be more information on the project site, and the Apache ooo project Community Wiki at

[users] Re: [ANN] This list is migrating to ooo-us...@incubator.apache.org

2011-09-02 Thread Dennis E. Hamilton
Noop, Sorry, the reply form on the archive does not setup a quotation that can be used, or else I missed it. I don't even think I can see the message being replied to once I am using the form. Of course, the archive shows indented threading, except where the message you questioned went astray

[users] Re: [ANN] This list is migrating to ooo-us...@incubator.apache.org

2011-09-02 Thread Dennis E. Hamilton
Sorry about the confusion. It was just advice. No need to change what you are doing. When the time is up and you do it yourself, please report to ooo-dev that you have done so along with any additional information you think we might need about it. - Dennis -Original Message- From:

[users] Re: [ANN] This list is migrating to ooo-us...@incubator.apache.org

2011-09-02 Thread Dennis E. Hamilton
A post by Larry Gusaas. He has already replied to one or another of the posts that had this text. I was using the archive browser form and must have screwed up the reply somehow. (I also posted the same message essentially twice because I didn't think I'd sent the first to the list. Sorry, f