Re: openoffice programming

2016-10-15 Thread Andrew Douglas Pitonyak
On 10/15/2016 10:17 AM, Alex Suk wrote: Damjan Jovanovic wrote But even at a rate of rewriting 1000 lines per day in Java, it would take 1 days, which is about 28 man years, to rewrite OpenOffice's 10 million lines of code... Do 10M lines in C++ convert to 10M lines in Java? Is it a 1:1 con

Re: [API] Priority Problem with AND and OR

2015-10-13 Thread Andrew Douglas Pitonyak
On 10/13/2015 06:25 AM, Regina Henschel wrote: Other example: Basic has no shortcut evaluation of boolean expressions. A major annoyance to me. It causes a bunch or nested if statements. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pito

Re: [API] Priority Problem with AND and OR

2015-10-12 Thread Andrew Douglas Pitonyak
Guenter, although you are correct with respect to Basic as implemented in AOO (and you stated it very well... I enjoyed your post), I am not aware of any other computer language where this is true. For example: C and C++ http://en.cppreference.com/w/c/language/operator_precedence Java is the s

Re: [DISCUSS] Qt as a replacement for VCL

2015-01-18 Thread Andrew Douglas Pitonyak
On 01/18/2015 01:46 PM, Fernando Cassia wrote: On Sun, Jan 18, 2015 at 12:43 PM, Yuri Dario wrote: This will have the positive side effect of removing all platform code from VCL since OS/2, Windows, *unix have QT ports. This will add one more layer inside operations, since QT will map to und

Re: [VOTE] New Apache OpenOffice PMC Chair

2015-01-16 Thread Andrew Douglas Pitonyak
+1 On 01/16/2015 07:47 AM, Rob Weir wrote: On Wed, Jan 14, 2015 at 7:00 PM, Andrea Pescetti wrote: On 31 December 2014 I wrote to this list that I would be available to resign from the Apache OpenOffice PMC Chair position as soon as a successor could be elected. We had nominations and long dis

Re: oooforum

2014-12-06 Thread Andrew Douglas Pitonyak
Side note: it seems that there is actually not much discussion. Ed, it seems, is over-committed for his time, which is what caused the problem with the forum in the first place. For now, I think most of the time is spent waiting on Ed to consider his options and make a decision about what he w

Re: oooforum

2014-12-06 Thread Andrew Douglas Pitonyak
On 12/05/2014 08:34 PM, Louis Suárez-Potts wrote: On 05 Dec2014, at 19:41, Andreas Säger wrote: Am 05.12.2014 um 01:15 schrieb Andrew Douglas Pitonyak: I did a scrape of the pages, and it is about 8GB last time I did it. Off hand, I expect that a huge chunk of that is SPAM, especially since

Re: oooforum

2014-12-04 Thread Andrew Douglas Pitonyak
On 12/04/2014 12:36 PM, Alexandro Colorado wrote: On Thu, Dec 4, 2014 at 11:11 AM, Andrea Pescetti wrote: Alexandro Colorado wrote: Unfortunately seems these matters went into private lists. I would suggest a public IRC meetup This is not an official resource of the project, so the projec

Re: oooforum status?

2014-10-28 Thread Andrew Douglas Pitonyak
to get the database from the server? On Mon, Oct 27, 2014 at 10:19 PM, Andrew Douglas Pitonyak mailto:and...@pitonyak.org>> wrote: In its current state it is mostly useless. I took an 8 GB dump by crawling the site in September. I think that it has as much spam as content i

Re: oooforum status?

2014-10-27 Thread Andrew Douglas Pitonyak
Colorado wrote: I see, I would hate to see this site die. Lots of information there, even if the site is held as a static site. On 10/27/14, Andrew Douglas Pitonyak wrote: On 10/27/2014 07:16 PM, Alexandro Colorado wrote: The conversation kinda went away and wonder what was the resolution about the

Re: oooforum status?

2014-10-27 Thread Andrew Douglas Pitonyak
On 10/27/2014 07:16 PM, Alexandro Colorado wrote: The conversation kinda went away and wonder what was the resolution about the oooforum and if there is any hope to recover the database at least to get some kind of plain browsable dump of the content. Regards. There was some discussion on the A

Re: OpenOffice lost again 6000 users (was: Improved OOXML support?)

2014-10-24 Thread Andrew Douglas Pitonyak
Do you know off hand if this is through OLE or some other mechanism? I have been handed a docx files with something embedded inside that prevents viewing because I do not happen to have that particular application installed on my computer. On 10/25/2014 12:50 AM, Dennis E. Hamilton wrote: To

Re: OpenOffice lost again 6000 users (was: Improved OOXML support?)

2014-10-24 Thread Andrew Douglas Pitonyak
On 10/24/2014 08:50 PM, Dennis E. Hamilton wrote: below. -Original Message- From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] Sent: Friday, October 24, 2014 17:27 To: dev@openoffice.apache.org Subject: Spam (9.566):Re: OpenOffice lost again 6000 users (was: Improved OOXML

Re: Access to the list of Autofilter

2014-10-24 Thread Andrew Douglas Pitonyak
On 10/24/2014 07:06 PM, Vladislav Stevanovic wrote: Hello, Is it possible with code in Basic to access to the list of Autofilter data in Calc? Reason: filtering with basic is limited maximum with 3 criteria... Because I need more then 3 criteria I want with basic code to use filtering capabilit

Re: OpenOffice lost again 6000 users (was: Improved OOXML support?)

2014-10-24 Thread Andrew Douglas Pitonyak
On 10/24/2014 11:42 AM, Dennis E. Hamilton wrote: below. -Original Message- From: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] Sent: Friday, October 24, 2014 06:18 To: dev@openoffice.apache.org Subject: Re: OpenOffice lost again 6000 users (was: Improved OOXML support?) On

Re: OpenOffice lost again 6000 users (was: Improved OOXML support?)

2014-10-24 Thread Andrew Douglas Pitonyak
On 10/24/2014 01:54 AM, Jörg Schmidt wrote: But where is the problem? Either OOXML *is* ISO standard or is not ISO-standard. If the problem is however that MS is 'meddling' in the standard, then it is a political issue that requires policy responses - not a question of software development.

Re: Some nice things

2014-09-15 Thread Andrew Douglas Pitonyak
I don't see any documentation. It looks like the project data was uploaded or created in 2011 and I don't see that it has been changed since then. I looked into the source code and I saw no javadoc either. Does not mean that it is useless, just that I don't think that it is documented in any w

Re: Link to oooforum

2014-09-04 Thread Andrew Douglas Pitonyak
Wooohooo, we received a positive response from Ed! On 09/03/2014 05:56 PM, Andrew Douglas Pitonyak wrote: Oh, yes, sorry, I could test on the official forum, but, the forum itself is laid out very differently so I don't think that it would work very well. The big issue that I see a

Re: Link to oooforum

2014-09-03 Thread Andrew Douglas Pitonyak
ote: Sorry the way I understood you couldnt work confortable at oooforum because of its unresponsiveness. So I suggest using the official forums to test the iMacros until they are up there to perform all the tasks. But I most have missed something. Regards. On 9/3/14, Andrew Douglas Pitonyak w

Re: Link to oooforum

2014-09-03 Thread Andrew Douglas Pitonyak
/14, Alexandro Colorado wrote: I agree, sorry to see the sad state of the forum. Maybe all this should be let known to the owner so he can take measurses. I dont think anyone want to see oooforum go. On 9/3/14, Andrew Douglas Pitonyak wrote: Yeah, even when I build an iMacro to remove a single

Re: Link to oooforum

2014-09-03 Thread Andrew Douglas Pitonyak
sufficient. That said, when the forum is so slow, hardly seems worth the effort. On 09/03/2014 08:41 AM, Andrew Douglas Pitonyak wrote: Side note: It occurred to me that some of my "failures" may be attributed to the site simply not responding since it stopped responding last night.

Re: Link to oooforum

2014-09-03 Thread Andrew Douglas Pitonyak
Side note: It occurred to me that some of my "failures" may be attributed to the site simply not responding since it stopped responding last night. On 09/03/2014 01:17 AM, Andrew Douglas Pitonyak wrote: Well, I find the entire thing rather confusing. For example, I can extract

Re: Link to oooforum

2014-09-02 Thread Andrew Douglas Pitonyak
PE=EXTRACT FOLDER=* FILE=mytable_{{!NOW:yymmdd_hhnnss}}.csv If I loop 50 times, it exports everything from that one page into three files. It seems that it does not easily support doing the entire thing in one shot; at least while using a loop! At least by listing the extract command 50 times

Re: Link to oooforum

2014-09-02 Thread Andrew Douglas Pitonyak
ooforum.org/forum/templates/subSilver/images/icon_latest_reply.gif>"alt="View latest post"title="View latest post"border="0"/> ​I also looked at iMacros, and found a couple of tutorials about Data extraction for URLs: http://wiki.imacros.net/Data_Extract

Re: Link to oooforum

2014-09-01 Thread Andrew Douglas Pitonyak
On 09/01/2014 03:15 PM, Alexandro Colorado wrote: Yup my idea is that you have an array with the spam users, perform a search on them, and then fill out the page with the posts related to the spam users, and just have the macros select all checkboxes and press the delete, and go to the next page.

Re: Link to oooforum

2014-09-01 Thread Andrew Douglas Pitonyak
ed to the handful of nicks. That way it could automated and ran all night. Another extension is iMacros https://addons.mozilla.org/en-US/firefox/addon/imacros-for-firefox/ Which I guess is near your field Mr Macros guy ;) On Sun, Aug 31, 2014 at 10:58 PM, Andrew Douglas Pitonyak < and...@pitonyak.o

Re: Link to oooforum

2014-08-31 Thread Andrew Douglas Pitonyak
Although I am able to remove the account, all that does is convert the posts to have a "guest" user. I wish it did remove the posts as well. On 08/31/2014 09:41 PM, Alexandro Colorado wrote: Can't you just remove the spamer account with all his posts? On 8/31/14, Andrew D

Re: Link to oooforum

2014-08-31 Thread Andrew Douglas Pitonyak
More accurately, the owner is generally non-responsive (he is really busy and does not have much time for a hobby forum). The forum is currently hosted on machines that prevent him from granting admin rights to the forum proper and I assume that he does not have things properly virtualized to

Re: Link to oooforum

2014-08-23 Thread Andrew Douglas Pitonyak
On 08/23/2014 10:16 AM, Andrea Pescetti wrote: On 20/08/2014 Mathias Röllig wrote: https://www.openoffice.org/support/ links to www.oooforum.org (The (Unofficial) OpenOffice Forum) but it seems down. If so (permanent down) the link should be deleted. It is not permanently down, but indeed I e

Re: OOXML

2014-08-03 Thread Andrew Douglas Pitonyak
On 08/03/2014 12:50 PM, Peter Kelly wrote: On 3 Aug 2014, at 6:52 pm, Regina Henschel > wrote: The second option has the advantage that it would be easier to cater for features that are supported in OOXML but not ODF, e.g. table styles. However the first option

Re: OOXML

2014-08-02 Thread Andrew Douglas Pitonyak
I am often required to read and write DOCX files and I know others for which this is a need. If I cannot accurately read / write DOCX files (or if I suspect that it may not work correctly) then I use Word; I don't like it when I have to use Word. On 08/02/2014 10:24 AM, Alexandro Colorado wr

Re: Tutorial Book on Open Office

2014-07-25 Thread Andrew Douglas Pitonyak
On 07/23/2014 04:49 PM, Rory O'Farrell wrote: On Wed, 23 Jul 2014 15:59:34 -0400 (EDT) Joan Lacombe wrote: Gentlemen: Can you recommend a good tutorial book that I can use to learn how to easily operate Open Office. I looked up the books listed on your website at Amazon and the reviews i

Re: Code snippets from oooforum in AOO website?

2014-07-14 Thread Andrew Douglas Pitonyak
On 07/14/2014 01:52 PM, Marcus (OOo) wrote: Am 07/14/2014 02:07 AM, schrieb Andrew Douglas Pitonyak: On 07/13/2014 07:02 PM, Marcus (OOo) wrote: I'm sure that someone will react. That's the goal. ;-) OK Marcus, I dropped an email to that list. If you have any pull over there, plea

Re: Code snippets from oooforum in AOO website?

2014-07-13 Thread Andrew Douglas Pitonyak
On 07/13/2014 07:02 PM, Marcus (OOo) wrote: I'm sure that someone will react. That's the goal. ;-) OK Marcus, I dropped an email to that list. If you have any pull over there, please do what you can to move this along. I really want this data to be made available again. -- Andrew Pitonyak

Re: Code snippets from oooforum in AOO website?

2014-07-13 Thread Andrew Douglas Pitonyak
On 07/13/2014 04:58 AM, Marcus (OOo) wrote: Am 07/13/2014 03:04 AM, schrieb Andrew Douglas Pitonyak: OK, I finally got off my backside and called The OOoForum owner. Seems that he is alive, well, and very busy and was not even aware that the site was down. He said that he obviously has not

Re: Code snippets from oooforum in AOO website?

2014-07-12 Thread Andrew Douglas Pitonyak
OK, I finally got off my backside and called The OOoForum owner. Seems that he is alive, well, and very busy and was not even aware that the site was down. He said that he obviously has not been doing a good job and is willing to discuss with the AOO team moving content and/or site. Let me kn

Re: Code snippets from oooforum in AOO website?

2014-06-28 Thread Andrew Douglas Pitonyak
On 06/28/2014 10:21 AM, jan i wrote: On 28 June 2014 14:58, Andrea Pescetti wrote: On 15/06/2014 Andrew Douglas Pitonyak wrote: On 06/14/2014 05:39 PM, Andrea Pescetti wrote: It seems http://oooforum.org/ is still unresponsive. ... Why do you need to hear from Ed before you mirror the

Re: Code snippets from oooforum in AOO website?

2014-06-15 Thread Andrew Douglas Pitonyak
I was one of the original administrators, and, I was an administrator until the forum simply disappeared. On 06/14/2014 05:44 PM, Alexandro Colorado wrote: I think Drew was an initial admin of the oooforum and also there are other co-admins like imacat. Any efforts trying to reach them? I am C

Re: Code snippets from oooforum in AOO website?

2014-06-15 Thread Andrew Douglas Pitonyak
On 06/14/2014 05:39 PM, Andrea Pescetti wrote: On 06/06/2014 Hagar Delest wrote: Le 06/06/2014 09:27, jan i a écrit : If we end up getting a full dump, I can arrange space on a vm, so we can temporary load it to extract what we need. No idea but floris v is clearing the code linked to the php

Re: Code snippets from oooforum in AOO website?

2014-06-06 Thread Andrew Douglas Pitonyak
On 06/06/2014 04:04 PM, Hagar Delest wrote: Le 06/06/2014 09:27, jan i a écrit : On 6 June 2014 09:01, Andrea Pescetti wrote: Not sure about this. Hagar wrote he has some stuff, but I don't know if that is a full dump (PHP code, database, attached files) which would allow us to restore the fo

Re: Code snippets from oooforum in AOO website?

2014-06-06 Thread Andrew Douglas Pitonyak
On 06/06/2014 03:01 AM, Andrea Pescetti wrote: Andrew Douglas Pitonyak wrote: I just dropped Ed another email, this time I copied the four known email addresses that I have for him. I made an attempt at contacting him too, to confirm that the project would like to save the forum, or at

Re: Code snippets from oooforum in AOO website?

2014-06-05 Thread Andrew Douglas Pitonyak
I just dropped Ed another email, this time I copied the four known email addresses that I have for him. My note reads as follows: Ed, Sorry for blasting this email to so many email addresses, but, I was hoping to get an update on the OOoForum site. Also, depending on your plans, do you have

Re: Code snippets from oooforum in AOO website?

2014-06-05 Thread Andrew Douglas Pitonyak
On 06/01/2014 05:51 PM, Regina Henschel wrote: Hi Hagar, Hagar Delest schrieb: Le 01/06/2014 16:51, Rob Weir a écrit : Is it possible to approach the operator of oooforum.org and discuss this? If he is no longer interested in maintaining that website, maybe he would agree to working with us t

Re: Code snippets from oooforum in AOO website?

2014-06-02 Thread Andrew Douglas Pitonyak
On 06/01/2014 06:19 AM, Hagar Delest wrote: The spammers were so successful at www.oooforum.org that it is not responsive for several days now (much more than little outages we have been used to in the past). So it seems that the forum is dead. It seems so. It has been the case for a very long

Re: Code snippets from oooforum in AOO website?

2014-06-02 Thread Andrew Douglas Pitonyak
On 06/01/2014 07:12 AM, jan i wrote: On 1 June 2014 12:19, Hagar Delest wrote: The spammers were so successful at www.oooforum.org that it is not responsive for several days now (much more than little outages we have been used to in the past). So it seems that the forum is dead. I have notic

Re: "is comprised of"

2014-02-04 Thread Andrew Douglas Pitonyak
This should probably be directed to the documentation project. Off hand, I would say that we could benefit from your knowledge. d...@openoffice.apache.org Although I agree that we should not purposely incorporate incorrect word use in our documents, my primary concern is that it is understood.

Re: Are there any legal repercussions for banning users from mailing lists?

2014-01-21 Thread Andrew Douglas Pitonyak
Items to ponder: 1. Anyone can sue anyone any time they desire for anything, but, a judge can throw it out and a lawyer will likely not take the case unless they believe that they will win money or the person must be willing to pay for the service. 2. Filing nuisance law suites is usually do

Re: Malware/ Adware masquerading as an Open Office extension

2014-01-20 Thread Andrew Douglas Pitonyak
On 01/19/2014 01:52 PM, Will Nettles wrote: The top website on Google for this seemed legit, but I wound up installing Genieo a mean little malware/adware bug. Do you remember what your Google search terms were? -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Inf

Re: OpenOffice development with Eclipse

2013-12-18 Thread Andrew Douglas Pitonyak
On 12/18/2013 09:40 AM, Andrew Douglas Pitonyak wrote: And I still think it is a good thing that LO builds under eclipse :-) Did i really write LO? Smack head! -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php

Re: OpenOffice development with Eclipse

2013-12-18 Thread Andrew Douglas Pitonyak
Great news Andre! On 12/17/2013 04:34 AM, Jürgen Schmidt wrote: And to underline what Andre has described above, this is really cool and we are sure it will help us a lot. Agreed I am more a NetBeans guy I too have a strong preference for NetBeans, (based on many negative experiences with E

Re: Improvements of OUString

2013-12-03 Thread Andrew Douglas Pitonyak
On 12/03/2013 11:27 AM, Herbert Duerr wrote: We should drop our support for ASCII? UTF-8 contains ASCII. This was one of its most important design goals and IMHO is a key factor that made this encoding such a big success. [...] Hm, UTF-8 is not identical to ASCII. What if I want to write

Re: Improvements of OUString

2013-12-03 Thread Andrew Douglas Pitonyak
On 12/03/2013 08:32 AM, Herbert Duerr wrote: On 03.12.2013 13:02, Andre Fischer wrote: Additionally to this almost correct statement one could mention that isEmpty() is preferred over getLength()>0 and why. Yes, it is preferred for checking the emptiness because it directly expresses what it

Re: Openoffice is being sold on ebay

2013-11-27 Thread Andrew Douglas Pitonyak
I thought it was fine for someone to sell a disc with OO installed. I think that the seller is overstating the compatibility, however. On 11/27/2013 07:34 PM, luis e wrote: To whom it may concern: I found out that there are sellers in ebay selling CDs with Openoffice. You can see some exampl

Re: Hello

2013-11-21 Thread Andrew Douglas Pitonyak
In case no one else responds to you have you checked out the DOC mailing list? d...@openoffice.apache.org On 11/20/2013 05:03 PM, David Virden wrote: My name is David and I'm interested in assisting with technical documentation. I have an English degree from the University of North Texas a

Re: BASIC and UTF-8

2013-10-14 Thread Andrew Douglas Pitonyak
On 10/14/2013 08:09 PM, Vladislav Stevanovic wrote: Hello, As I can see, there is a lot of people who are using BASIC for macros. And I too. Problem is next: does anybody developing Basic? Problem 1: for all who want to deal with characters outside of English language we have big problem, for exa

Re: A question about StarBasic

2013-09-03 Thread Andrew Douglas Pitonyak
Clarence, I assume that Jürgen was referring to objects that are part of AOO. In the example provided by Peter, creating an Excel.Sheet references an object that is not part of AOO, but it is known to Windows (if it works) and so AOO is able to find it. While you are running AOO, the objec

Re: OpenOffice not opening

2013-08-28 Thread Andrew Douglas Pitonyak
Kathleen, it looks like you emailed the developers list rather than the users list; oops. http://openoffice.apache.org/mailing-lists.html If you cannot find the correct list, let us know. That said. I have seen this before, and the solution is probably operating system dependent. I use Linu

Re: open office book writing in native language

2013-08-28 Thread Andrew Douglas Pitonyak
Please do write it.. No restrictions! :-) Native languages materials are an excellent thing to have. On 08/27/2013 11:25 AM, pot...@cs.teicrete.gr wrote: Hello, I would like to ask if i am allowed to write an open office tutorial (commercial book) in Greek language. Am i,as a writer, unde

Re: BasicAddonBuilder - problem (addon.xcu?) in AOO 4.0

2013-08-09 Thread Andrew Douglas Pitonyak
On 08/09/2013 07:56 AM, Oliver Brinzing wrote: Hi Jörg, What is the problem with the following addon.xcu? This functions in AOO 3.4.1 (for example) but not in AOO 4.0. aoo 4 requires a new element "ToolBarItems", see below. Regards Oliver I am guessing, then, that an add-on with toolbars wi

Re: autocorrect macro?

2013-07-15 Thread Andrew Douglas Pitonyak
I trust you tested the latest copy available here: http://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=7368 On 07/15/2013 12:08 PM, The weird writer wrote: when I try i get a weird error. extract faied 42 - To unsubscrib

Re: Open Office Tutorials

2013-06-27 Thread Andrew Douglas Pitonyak
I am copying your message to the doc list (d...@openoffice.apache.org) and hopefully Alexandro or Ricardo will provide a bit more guidance on this. In the meantime, consider subscribing to the doc mailing and creating an account here: http://wiki.openoffice.org/wiki/Documentation/How_Tos On

Re: dificulty in OO base

2013-06-17 Thread Andrew Douglas Pitonyak
Edson, There is some documentation that may be of help to you: https://wiki.documentfoundation.org/Documentation/Publications https://wiki.documentfoundation.org/images/f/fc/BH35-BaseHandbook.odt https://wiki.documentfoundation.org/images/7/76/BH35-BaseHandbook.pdf http://www.pitonyak.org/datab

Re: MSWord documents

2013-05-30 Thread Andrew Douglas Pitonyak
On 05/27/2013 11:13 PM, Bill Irving wrote: If I save the files as the word 97/2000/xp doc format will I lose anything?? The DOC format, although not perfectly supported, is supported pretty well in AOO. When given the choice, I usually choose DOC over DOCX because of this. LibreOffice suppor

Re: Load document from memory

2013-05-10 Thread Andrew Douglas Pitonyak
On 05/10/2013 05:51 AM, José Expósito wrote: Hi list! I want to write a OpenOffice extension, preferably in Java, to read an encrypted document from disk (docx, pptx and xlsx), decrypt them in memory and load them from a byte array, and of course disable the required menu actions to avoid ex

Re: Exit moderation mailing

2013-03-31 Thread Andrew Douglas Pitonyak
On 03/31/2013 06:16 PM, Andrea Pescetti wrote: Albino Biasutti Neto wrote: I am moderator of mailing doc,api @ o.a.o. Today I am out of time to moderate, I ask to remove moderation. Thanks. Do we have someone willing to replace Albino, preferably (but not necessarily) in the American time zo

Re: questions about Base---do we need an embedded DB?

2013-03-27 Thread Andrew Douglas Pitonyak
On 03/27/2013 04:57 PM, Kay Schenk wrote: Well Derby does seem to be "embed-able ". See: http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html This has been suggested before, as early as 2006. See: http://markmail.org/message/kp5n2d5yzhprgpjm Still, is any embedded DB a good thing?

Re: How to get mimetype at first position in the zip-container?

2013-03-27 Thread Andrew Douglas Pitonyak
thanks for the update on this On 03/27/2013 06:35 PM, Regina Henschel wrote: Hi all, OK, I found a solution: I first generate a zip-container with the command line version of 7z, which contains only the file mimetype. The command line version of 7z can do this without compressing the fi

Re: questions about Base---do we need an embedded DB?

2013-03-26 Thread Andrew Douglas Pitonyak
I like an embedded DB for those times that I desire a small DB for small data that is relational. For larger data sets, the embedded DB is insufficient. I see that you specifically ask about an embedded DB, yet some of the answers are related to Base in general. -- Andrew Pitonyak My Macr

Re: [CODE][PROPOSAL]: AOO 4.0 getting rid of the 3 layer office, part 1

2013-03-22 Thread Andrew Douglas Pitonyak
Great work Jürgen, I am impressed. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additio

Re: Implementing an Excel compatibility function (such as 0^0 = ERROR)

2013-02-21 Thread Andrew Douglas Pitonyak
On 02/21/2013 09:20 PM, Rob Weir wrote: On Thu, Feb 21, 2013 at 9:12 PM, Andrew Douglas Pitonyak wrote: During the long painful discussion of 0^0, there was mention of creating a compatibility function for POWER(x,y) to match the behavior in Excel. My understanding of how this would work is

Implementing an Excel compatibility function (such as 0^0 = ERROR)

2013-02-21 Thread Andrew Douglas Pitonyak
During the long painful discussion of 0^0, there was mention of creating a compatibility function for POWER(x,y) to match the behavior in Excel. My understanding of how this would work is as follows. 1. Create another function such as POWER.OTHER(x,y) that behaves as desired. 2. When an Exce

Re: Binary Reading Capabilities

2013-02-21 Thread Andrew Douglas Pitonyak
On 02/21/2013 07:37 PM, Rob Weir wrote: On Thu, Feb 21, 2013 at 2:10 PM, Nathan Pimental wrote: I'm not sure if help for reading direct binary or hex is being looked for, or even wanted, but I would be glad to develop a dll that reads and writes pure 1s and 0s for oo. What would be an example

Re: Binary Reading Capabilities

2013-02-21 Thread Andrew Douglas Pitonyak
You could write an extension :-) On 02/21/2013 02:10 PM, Nathan Pimental wrote: I'm not sure if help for reading direct binary or hex is being looked for, or even wanted, but I would be glad to develop a dll that reads and writes pure 1s and 0s for oo. -- Andrew Pitonyak My Macro Document: ht

Re: Calc behavior: result of 0 ^ 0

2013-02-14 Thread Andrew Douglas Pitonyak
On 02/14/2013 09:29 AM, Jürgen Schmidt wrote: On 2/14/13 2:49 PM, Andrea Pescetti wrote: Rob Weir wrote: On Thu, Feb 14, 2013 at 7:34 AM, Andrea Pescetti wrote: Fine. I would have started the vote earlier, but it's your code so I'll respect your choice. And it's good to give people more time t

Re: Calc behavior: result of 0 ^ 0

2013-02-14 Thread Andrew Douglas Pitonyak
On 02/14/2013 07:52 AM, Rob Weir wrote: We had a committer veto. Why are having a vote? A -1 from a commmitter is not something we vote on. The patch needs to be reverted, now. I thought he said he vetoed it and it would be voted on later. I was not aware that any committer could veto any

Re: Calc behavior: result of 0 ^ 0

2013-02-13 Thread Andrew Douglas Pitonyak
On 02/13/2013 02:46 PM, Pedro Giffuni wrote: Independently of the vote result I will be effectively stopping the development work I intended to do on Calc as I have lost all interest on improving it given the current situation. I totally understand. -- Andrew Pitonyak My Macro Document: http:/

Re: Performance test comparisons

2013-02-13 Thread Andrew Douglas Pitonyak
On 02/13/2013 09:34 AM, Rob Weir wrote: On Tue, Feb 12, 2013 at 6:47 PM, Andrew Douglas Pitonyak wrote: If you have a good setup for testing such things, try loading, saving, and closing AndrewMacro.odt That's a big one: Release the Kraken! The time to close the document (not s

Re: Implementation-defined behaviors in ODF spreadsheets

2013-02-13 Thread Andrew Douglas Pitonyak
Awesome! On 02/13/2013 12:43 PM, Rob Weir wrote: This topic seems to be of more general interest, given the discussions we've been having regarding the evaluation of 0^0. When we were writing up the specification of ODF 1.2's OpenFormula we had the goal to describe how real-world spreadsheet ap

Re: Starting Introduction to Contributing to Apache OpenOffice Module

2013-02-13 Thread Andrew Douglas Pitonyak
On 02/13/2013 08:15 AM, tony fre wrote: hi all, I love computers and since the first personal one came to brazil I've been dealing with them. I played with BASIC on the old times . . . saw some assembly but I'm not a programmer - I don't like it. on the other hand I love to break the computer

Re: Interval arithmetic [was Re: Calc behavior: result of 0 ^ 0]

2013-02-13 Thread Andrew Douglas Pitonyak
On 02/13/2013 11:14 AM, Rob Weir wrote: On Wed, Feb 13, 2013 at 10:43 AM, Pedro Giffuni wrote: FWIW; - Messaggio originale - Da: Andrew Douglas Pitonyak Of course, had I implemented quaternion math using Boost, no one would be complaining. :-P Pedro. [1] http

Re: R: Re: Calc behavior: result of 0 ^ 0

2013-02-12 Thread Andrew Douglas Pitonyak
On 02/12/2013 11:21 PM, Pedro Giffuni wrote: No, I cant, and I wont start scartching my head over it. The issue is minuscule enough that I have been aware from the start that it wasnt worth this bikeshed thread [1]. Of course, had I implemented quaternion math using Boost, no one would be com

Re: Calc behavior: result of 0 ^ 0

2013-02-12 Thread Andrew Douglas Pitonyak
On 02/12/2013 05:45 PM, Rob Weir wrote: On Tue, Feb 12, 2013 at 5:35 PM, Hagar Delest wrote: Le 12/02/2013 23:22, Rob Weir a écrit : But again, if you think that situation never comes up in real use, then let's not make the change, since it would have no benefit. You don't seem to see the

Re: Calc behavior: result of 0 ^ 0

2013-02-12 Thread Andrew Douglas Pitonyak
On 02/12/2013 05:07 PM, Marcus (OOo) wrote: Am 02/12/2013 10:39 PM, schrieb Rob Weir: Sorry, if it wasn't clear. I have a spreadsheet on my hard-drive right now that would be break if we changed the behavior of 0^0. And what is your *serious* use case for this spreadsheet? Beside to use it

Re: Calc behavior: result of 0 ^ 0

2013-02-12 Thread Andrew Douglas Pitonyak
My preference is to leave the patch and return #Value On 02/12/2013 01:11 PM, Dennis E. Hamilton wrote: RESOLUTION OF THE PROPOSAL The proposed change was made under CTR (Commit then Review). There has been a subsequent review and, as Don points out, the discussion has been lengthy and vocal.

Re: Select column in Calc

2013-02-12 Thread Andrew Douglas Pitonyak
OK, then you want the information as provided by Ariel. Just wanted to be sure. On 02/12/2013 08:50 PM, Galileo Teco Juárez wrote: obtain the value in a cell specific 2013/2/12 Andrew Douglas Pitonyak Do you want to "get", "take", or "obtain" the val

Re: Select column in Calc

2013-02-12 Thread Andrew Douglas Pitonyak
Do you want to "get", "take", or "obtain" the value that is in the cell, or, do you want to "select" the cell so that it is the current cell? On 02/12/2013 03:18 PM, Galileo Teco Juárez wrote: sorry mistake of translations this is the real question *how can i select the value of a colum in a

Re: Completed Introduction to Contributing to Apache OpenOffice Module

2013-02-12 Thread Andrew Douglas Pitonyak
Welcome. have you tried to build the source code yet? This may be a good starting place http://wiki.openoffice.org/wiki/Documentation/Building_Guide_AOO On 02/12/2013 04:13 PM, Maarten Kesselaers wrote: Hello, My name is Maarten Kesselaers. I'm from Belgium and work as a project manager a

Re: Performance test comparisons

2013-02-12 Thread Andrew Douglas Pitonyak
If you have a good setup for testing such things, try loading, saving, and closing AndrewMacro.odt LO claims that much of their improvements are related to large Calc documents. Might be nice to find and test their large test Calc document... Not sure what they used, however. On 02/12/2013

Re: Calc behavior: result of 0 ^ 0

2013-02-11 Thread Andrew Douglas Pitonyak
Oh no, please no popup when I paste that formula into 1000 cells, I don't want 1000 popups. Sadly, I sometimes do stupid things like that when I have a warning in functions that I write myself and a debug message pops up during testing. Yeah, scary! Now, a single warning that is only ever

Re: Calc behavior: result of 0 ^ 0

2013-02-10 Thread Andrew Douglas Pitonyak
Sadly, ODF allows any of three values to be returned, any user assuming any specific behavior is foolish. Load the document in any product or version, and it may change. If I order my preference, it is error, 1, and then 0. On 02/10/2013 04:18 PM, Hagar Delest wrote: The problem is to give t

Re: Calc behavior: result of 0 ^ 0

2013-02-10 Thread Andrew Douglas Pitonyak
On 02/10/2013 10:04 AM, Rory O'Farrell wrote: My thinking is the Calc should return the mathematically correct answer. ODF standard defines what can be returned. If there is a single mathematically correct answer, I would expect the standard to define it. If the standard is wrong (like definin

Re: Problem with the API forum

2013-02-08 Thread Andrew Douglas Pitonyak
On 02/08/2013 05:08 PM, Hagar Delest wrote: Could you make clear about what forum you're talking about? I checked the EN forum and there is no user with your mail address (I checked with the address used for the dev list but also your first name and last name alone). Hagar EN forum admin tea

Re: Problem with the API forum

2013-02-07 Thread Andrew Douglas Pitonyak
On 02/07/2013 04:57 PM, Yessica Brinkmann wrote: I understand, thank you very much. I really do not like the idea that my posts are "modified" by others, and that could mean, for example, something A message that is "moderated" means that a person with the "moderator" role looked at the messa

Re: Problems with Events

2013-02-05 Thread Andrew Douglas Pitonyak
On 02/05/2013 04:06 PM, Yessica Brinkmann wrote: Hello, As you remember I had many problems to run a macro. Now I have a question about the event to which I attach my macro. If I assign the macro to the event button mouse released I usually associate to initiating, or executing, (or what ever

Re: Reverting commits [was: Re: svn commit: r1441659 - /openoffice/site/trunk/templates/sidenav.mdtext

2013-02-02 Thread Andrew Douglas Pitonyak
If content is noticed and there is concern that there may be legal ramifications, it seems reasonable that the content would be immediately modified before review, which is what was done. So if I seem something that is wrong, should I fix it, or should I ask the person that made the initial er

Re: Volunteer Support Engineer/Tester reporting for duty :)

2013-02-01 Thread Andrew Douglas Pitonyak
Excellent, you probably want to look here: http://wiki.openoffice.org/wiki/Quality_Assurance and here http://openoffice.apache.org/qa.html On 02/01/2013 04:32 PM, Rob Conn wrote: Hi i'm Rob Conn, I am offering my skills and experience to help make open office better and resolve any issues yo

Re: Information on joining your team

2013-01-31 Thread Andrew Douglas Pitonyak
On 01/31/2013 03:46 PM, Angela Reilly wrote: I would like to join in on making Open Office better. Please contact me and let me know what I can do. My name is Angela and have been working with computers for a while now. I have used open Office on more than one of my computers and like it. What a

Re: still unable to create accounts on mwiki

2013-01-31 Thread Andrew Douglas Pitonyak
captcha (and so do I) as a security risc so I need to change that. Let me sum these events with a glimt in the eye: - 3 weeks waiting until I (by accident) saw it - 1 hour fixing. Have a nice day. Jan On 29 January 2013 23:40, Andrew Douglas Pitonyak wrote: Rakesh, I am sending this to the dev

Re: wiki still broken

2013-01-30 Thread Andrew Douglas Pitonyak
andro Colorado wrote: this has been going on for 3 weeks. On 1/31/13, Andrew Douglas Pitonyak wrote: Anyone able to create accounts? On 01/29/2013 05:40 PM, Andrew Douglas Pitonyak wrote: Rakesh, I am sending this to the dev mailing list, perhaps they can fix what ails the wiki. It is not possib

wiki still broken

2013-01-30 Thread Andrew Douglas Pitonyak
Anyone able to create accounts? On 01/29/2013 05:40 PM, Andrew Douglas Pitonyak wrote: Rakesh, I am sending this to the dev mailing list, perhaps they can fix what ails the wiki. It is not possible to create new accounts on mwiki. Is this a known problem, and will it be fixed soon? This

  1   2   >