Re: [API] Priority Problem with AND and OR
Hi, Andrew Douglas Pitonyak schrieb: [..] The real question becomes should it be changed to follow expected mathematical norms (breaking all existing correct code and fixing all broken code where people assumed it was done in the generally accepted way). I am glad I need not make that call. No, it should not be changed. You cannot break existing macros after so many years, and the behavior is not really "wrong", because it follows the mathematical definition. The problem is not, that Basic makes it different than some other languages. The problem is, that it is so badly documented. Other example: Basic has no shortcut evaluation of boolean expressions. Kind regards Regina On 10/12/2015 08:15 PM, Guenter Marxen wrote: Hi, Am 12.10.2015 um 21:40 schrieb Mathias Röllig: ... What do you expect? For logical operations AND is equivalent to * and OR is equivalent to +. no, that's not true. AND and OR have the same priority, just as * and / (division). (* and / have a higher priority than + and -.) AND should have a higher priority than OR, so I would expect in both Expressions have to be evaluated from left to right with respect to priority and parenthesis. Only for those specific operators. And the complaint was that your statement is unexpectedly true. "and" and "or" are binary operators. Therfore your examples can be written as "A or B" where "B = (C and D)". If you write your example as "A or (C and D)" then it is the same and everyone sees immediatly, how it is evaluated. I wrote an implementation for a proposed international standard in Fortran 90 many years back It was suggested that I assume that people would not know precedence rules so that I should use parenthesis for all statements and that I should avoid things like ternary operators since beginning programmers may not know what they were. In both cases, the result is TRUE, because "TRUE or anything" is TRUE, just as "TRUE or (anything)". "(A or B) and C" is totally different. On http://www.p-roocks.de/truthtable2.php you can create "tables of truth" (Wahrheitstabellen) for logical expressions like "A or B and C" and more complex ones. cases (because TRUE Or () = TRUE): bResult = TRUE But you will get TRUE Or FALSE And TRUE = (TRUE Or FALSE) And TRUE = TRUE TRUE Or TRUE And FALSE = (TRUE Or TRUE) And FALSE = FALSE Is there any explanation that AND and OR have (and should have) the same priority? It is as it is! You are correct in that! - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [API] Priority Problem with AND and OR
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.pitonyak.org/oo.php - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: Not Responding
The better way to do this is using your operating system. - Mail original - De: "Earl Meyer" À: dev@openoffice.apache.org Envoyé: Lundi 12 Octobre 2015 23:33:15 Objet: Not Responding Can't delete files get message not responding. Any way to fix?ThanksEarl Meyer - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [API] Priority Problem with AND and OR
Not true or misstated, see https://technet.microsoft.com/en-us/library/ms186992%28v=sql.105%29.aspx for correct priority of operators. Without parentheses AND is evaluated before OR Attached is a little browser program I use to test Boolean arithmetic. It is written in html && stands for AND, || stands for OR. Use == to test if two things are equal, like (3 == 2+1) Howard Hi, Am 12.10.2015 um 21:40 schrieb Mathias Röllig: > ... > What do you expect? > For logical operations AND is equivalent to * and OR is equivalent to +. no, that's not true. AND and OR have the same priority, just as * and / (division). (* and / have a higher priority than + and -.) > AND should have a higher priority than OR, so I would expect in both Expressions have to be evaluated from left to right with respect to priority and parenthesis. "and" and "or" are binary operators. Therfore your examples can be written as "A or B" where "B = (C and D)". If you write your example as "A or (C and D)" then it is the same and everyone sees immediatly, how it is evaluated. In both cases, the result is TRUE, because "TRUE or anything" is TRUE, just as "TRUE or (anything)". "(A or B) and C" is totally different. On http://www.p-roocks.de/truthtable2.php you can create "tables of truth" (Wahrheitstabellen) for logical expressions like "A or B and C" and more complex ones. > cases (because TRUE Or () = TRUE): > bResult = TRUE > But you will get > TRUE Or FALSE And TRUE = (TRUE Or FALSE) And TRUE = TRUE > TRUE Or TRUE And FALSE = (TRUE Or TRUE) And FALSE = FALSE > > Is there any explanation that AND and OR have (and should have) the same > priority? It is as it is! -- Grüße Günter Marxen --- Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft. https://www.avast.com/antivirus - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: SQLite ODBC driver for Libra and OpenOffice
>This is a commercial offer with a trial version (30 days). >The driver is costly 150 USD. This commercial driver has been published as an extension: http://extensions.openoffice.org/en/project/openoffice-sqlite-odbc-driver Is it normal? - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: SQLite ODBC driver for Libra and OpenOffice
Le 13/10/2015 15:37, FR web forum a écrit : > This commercial driver has been published as an extension: > http://extensions.openoffice.org/en/project/openoffice-sqlite-odbc-driver > Is it normal? > Seems it also comes with a proprietary, restrictive license : https://www.devart.com/odbc/sqlite/docs/index.html Alex - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: SQLite ODBC driver for Libra and OpenOffice
About commercial extensions ... It's fine. We want to encourage people to use OpenOffice, and even if they don't give anything back to us, building a sustainable business market around it will help us be a real alternative to the commercial options. If people can only make a business around MS Office, it is likely they will only develop there. Of course, anyone else is free to develop a cheaper or free version ;). Pedro. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
4.1.2_release_blocker requested: [Issue 126586] automation deadlock: osl_closeSocket() doesn't wake up thread stuck in accept()
dam...@apache.org has asked for 4.1.2_release_blocker: Issue 126586: automation deadlock: osl_closeSocket() doesn't wake up thread stuck in accept() https://bz.apache.org/ooo/show_bug.cgi?id=126586 --- Comment #1 from dam...@apache.org --- I've committed a patch that generalizes the #if defined(LINUX) to FreeBSD and (by extrapolation only) NetBSD, and not only gets AOO to exit when run with automation enabled as described, but also gets all tests to run, and even gets as many tests to pass on FreeBSD as pass on Linux (though different ones fail and for different reasons lol). I am thus proposing this fix as a 4.1.2 release blocker. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [API] Priority Problem with AND and OR
On 13/10/2015 Andrew Douglas Pitonyak wrote: The real question becomes should it be changed to follow expected mathematical norms (breaking all existing correct code and fixing all broken code where people assumed it was done in the generally accepted way). No, but we should advise people to use parentheses to ensure disambiguation when the operator precedence it is not totally obvious. Regards, Andrea. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: SQLite ODBC driver for Libra and OpenOffice
Alexander Thurgood wrote: Le 13/10/2015 15:37, FR web forum a écrit : This commercial driver has been published as an extension: http://extensions.openoffice.org/en/project/openoffice-sqlite-odbc-driver Is it normal? Seems it also comes with a proprietary, restrictive license : https://www.devart.com/odbc/sqlite/docs/index.html While the vast (95%+, I would say; maybe even 99%+) majority of extensions have a Free and Open Source license (and most of them, additionally, are available at no cost) I think that a few "proprietary and commercial" extensions do exist. A questionable behavior, though, is that they stated the license is "Creative Commons Attribution": http://extensions.openoffice.org/en/search?query=&sort_by=created&sort_order=DESC and it looks like they should be contacted and the wrong license indication rectified. Regards, Andrea. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
OpenOffice 4.1.2-RC2 available (and happy birthday!)
As a small gift for the 15 years of OpenOffice (OpenOffice was released as Open Source on 13 October 2000, as Louis reminded us during ApacheCon Budapest), we now have OpenOffice 4.1.2-RC2 available. OpenOffice 4.1.2-RC1 has been tested for more than a week without major bugs or regressions reported. Almost all relevant issues were tested and verified fixed, even though we still need help with some. Note that, since there is still some delay for building and uploading, RC2 is current as of revision 1707648 (last accepted commit, see https://svn.apache.org/viewvc/openoffice/tags/ for the SNAPSHOT change), so 4 days ago. A few reported bugs on RC1: - RC1 was missing Linux 64-bit DEB packages and had some incorrect scripts for source checksums; these are now fixed. - https://bz.apache.org/ooo/show_bug.cgi?id=126305 additional patches were needed, these are in RC2 - Windows installation: a user reported "Installation aborted with the message that I lack access to registry". See http://s.apache.org/Z6v and https://bz.apache.org/ooo/show_bug.cgi?id=126587 ; RC2 should not have any changes in this respect, but possibly Windows users can explain/check/guide. - https://bz.apache.org/ooo/show_bug.cgi?id=107619 is not completely solved, a fix came when RC2 was already being prepared and it is not included - Several release blockers were addressed (Bugzilla link below) RC2 can be downloaded from https://dist.apache.org/repos/dist/dev/openoffice/ open "binaries", then the language code, then you will find installers. If you can't download it now, it means it is still synchronizing, try again in a few hours. For QA, the link to use for verifying "release blocker" bugfixes is this one (you will need a Bugzilla account to see it and to verify bugfixes): https://bz.apache.org/ooo/buglist.cgi?cmdtype=dorem&list_id=170710&namedcmd=4.1.2_approved_and_fixed&remaction=run&sharer_id=7 Only the issues marked as RESOLVED FIXED are still to be checked. If you verify that everything works as expected, please mark the issue as VERIFIED FIXED (or post a comment, specifying your Operating System and language). It is fine and useful to have two independent verifications of a bug, especially on two different operating systems. Remember: testing is important since 4.1.2-RC2 can be a release we actually vote upon. We are seeing a few release blocker requests coming in but I'll wait that everything is properly tested before seeing whether this deserves a RC3. So if you didn't test RC1, please test RC2; you can actually use it for day-to-day tasks too for a few days, for more realistic testing. Replies to the QA list only, if possible, thanks. Regards, Andrea. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
