Re: [Libreoffice-qa] Compatibility, Open Source, Microsoft
On 02/02/2015 05:03 PM, Julio Cesar Campos wrote: Hello, There is an excellent work and progress in Libreoffice, congratulations. I use LibreOffice as the only program for all activities, and certainly I am very grateful and pleased with their performance, and the work of so many people behind this. Each time it is launched a new version of LibreOffice, I use the attachment to test compatibility and always see great progress, I'm sure you do the same every time, but I would like to hear your comments about the difference when you open the attachment with Microsoft office and Libreoffice, I do it with a spirit of curiosity and support. Thanks for your kind attention and response. Julio Cesar My experience is generally with very simple MSO documents (no macros or complex formating). I have not seen any compatibility issues. Also, I have not heard any complain about LO produced MSO format documents I have sent to them, again simple formats. I use Linux so MSO is not available except by web subscription which I refuse to buy. Jay ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/ -- Jay Lozier jsloz...@gmail.com ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
Re: [Libreoffice-qa] fdo#80638 Incorrect SUM with decimal numbers
On 06/29/2014 12:53 PM, Terrence Enger wrote: Hi, all. I have just, for the first time that I remember, changed a confirmed bug report to a request for enhancement. I would like confirmation or correction of my judgement. The report is fdo#80638 Incorrect SUM with decimal numbers https://bugs.freedesktop.org/show_bug.cgi?id=80638. My thought is that Calc simply does not do decimal numbers. Thanks for your attention, Terry. Hi, This is not an LO bug. I get the exact same result with a Python script, a Ruby script, and Calligra Sheets. It is a problem with internal representation of decimal numbers in any computer system. This is a well known problem in scientific computing/numerical analysis. Also, reordering the addition produced different precisions. I think the correct numerical analysis term for this is precision referring to how closely the actual value is to the true value. I would close this report with the note this is not a problem specific to LO or any other spreadsheet. All spreadsheets will produce similar results depending on the specifics of how real numbers are handled by the underlying OS/CPU. Jay -- Jay Lozier jsloz...@gmail.com ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
Re: [Libreoffice-qa] fdo#80638 Incorrect SUM with decimal numbers
On 06/29/2014 04:16 PM, Terrence Enger wrote: On Sun, 2014-06-29 at 14:11 -0400, Jay Lozier wrote: On 06/29/2014 12:53 PM, Terrence Enger wrote: Hi, all. I have just, for the first time that I remember, changed a confirmed bug report to a request for enhancement. I would like confirmation or correction of my judgement. The report is fdo#80638 Incorrect SUM with decimal numbers https://bugs.freedesktop.org/show_bug.cgi?id=80638. My thought is that Calc simply does not do decimal numbers. Thanks for your attention, Terry. Hi, This is not an LO bug. I get the exact same result with a Python script, a Ruby script, and Calligra Sheets. It is a problem with internal representation of decimal numbers in any computer system. This is a well known problem in scientific computing/numerical analysis. I think I hear a distant voice, echoing down the decades, sayting truncation error. rant The PC world tends to accept this problem as inevitable. However, the larger IBM systems going back to System/360 and other systems inspired by it have offered decimal arithmetic. This, too, has its funnies, but the problems tend to manifest themselves in high-order digits, and so are often less subtle. /rant Also, reordering the addition produced different precisions. I think the correct numerical analysis term for this is precision referring to how closely the actual value is to the true value. I would close this report with the note this is not a problem specific to LO or any other spreadsheet. All spreadsheets will produce similar results depending on the specifics of how real numbers are handled by the underlying OS/CPU. The computers handle real numbers well enough they can fool the unwary into thinking that the computers' real numbers are like a mathematician's real numbers. It just ain't so, of course: the computer's real numbers are a finite subset of the mathematician's rational numbers. I cannot imagine what a good fix for the problem would be. And to change the result of a calculation, even a wrong result, is likely to break somebody's workflow. One possibility is to introduce a new function, call it betterSum perhaps, which accumulates the addends in order of increasing absolute value. This would not change the behaviour of existing spreadsheets. I do not expect that this would be worth the effort. So, yes, I think I shall close the report NOTABUG. (But you can tell that I am greatly tempted by NOTOURBUG, can't you?) Jay Thank you, Jay, for helping me to this decision. Terry, Hi, NOTOURBUG LOL! I read a couple of books on numerical methods in the mid 80's and they both discussed this problem as adding to the natural measurement errors in one's data. The point both made was it could be minimized but never eliminated. Because it could not be eliminated there could be a situation where this error blew up and caused bogus results to be generated. What I remember of the potential fixes is they are not something that a spreadsheet user would typically do. One is to encode the data as text, then programmatically convert it into integers which works fairly well with currency. The spreadsheet equivalent is to enter all the data as integers. Division and possibly multiplication will sometimes create real numbers but the precision problem is typically small enough that it should not cause problems. Another was to move the decimal point to eliminate leading zeros. The idea is if some of the data is 0.00xy meters and some is a.bd0 meters it should enter as millimeters x.y mm and abd0 mm instead. This would work on a spreadsheet. -- Jay Lozier jsloz...@gmail.com ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
Re: [Libreoffice-qa] fdo#77409 needs a bit more specifics
Kohei, I can not confirm the bug on 4.2.3.3/Manjaro Linux. Arrow key movement is working correctly on my box. Left, right, up, and down arrows move the active cell in proper directions; one cell per key stroke. I would re-rate this as needs more info. I have added my comments to the report. Jay On 04/25/2014 12:19 PM, Kohei Yoshida wrote: Hi there, With regard to this bug report https://bugs.freedesktop.org/show_bug.cgi?id=77409 could someone please verify this, or set the STATUS to UNCONFIRMED? It appears that this bug has not been properly triaged and the reporter set the status to NEW directly. And either I cannot reproduce this or I don't understand the description of the problem. Thanks for your help. Kohei ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/ -- Jay Lozier jsloz...@gmail.com ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
[Libreoffice-qa] Python vs Java, Was Bisect GUI for Windows
How much of the code requires Java? Also, with Python, the interpreter is likely not installed on Windows and possibly a Mac. With Linux one would need to verify the correct Python version is installed. I think the same problems are true with Ruby and Perl. However, JVMs are more likely to be installed. If the issue to avoid using Java itself, then Scala and Groovy(?) may be better alternatives to Python or Ruby. I do not know enough about either to make a choice. If the issue is the remove Java entirely then I think the choice is basically Python, Perl, or Ruby. From what I have seen Python is probably the better choice in my somewhat biased opinion (I write mostly in Python). Python modules exist for PyQT/Pyside (QT) and wxWidget and tkinter is built-in, which I believe are all cross platform. Jay On 04/20/2014 02:35 PM, Bjoern Michaelsen wrote: Hi, On Sun, Apr 20, 2014 at 09:43:45AM -0700, Robinson Tryon wrote: Bjoern -- Thoughts on using Glade for this purpose? I figure it might be good to use the same stuff we're using elsewhere in the LO project... I dont think Glade is a good idea. If the bibisect UI is sufficiently simple (and it should be), Tkinter would be the most simple crossplatform toolkit that is available everywhere -- even if it is somewhat ugly on some platforms. As for using Python instead of Java: I based that on the assumption that (at least in the LibreOffice community) there are more people willing to work on the first than on the second. I might be wrong. @Florian: So if there are not a few people showing up saying I would help out with Python, but unlikely with Java (which did not happen yet), just go ahead with Java, if you prefer that. It was based on my gut feeling, and gut feelings might be wrong. Best, Bjoern ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/ -- Jay Lozier jsloz...@gmail.com ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
Re: [Libreoffice-qa] Python vs Java, Was Bisect GUI for Windows
Joel, I do not know how much help I can give. Florian, Please contact me with more details about the GUI. Jay On 04/20/2014 03:01 PM, Joel Madero wrote: Hi Jay, Any way that you could collaborate with Florian to try to get the Bibisect GUI up and running? It's one of our long running projects in QA and currently it's just Florian working on it. It would be an incredible addition to ensuring high quality releases as it would open the door for new users to easily help identify regressions and help developers identify where the regression was introduced. Best, Joel On 04/20/2014 11:57 AM, Jay Lozier wrote: How much of the code requires Java? Also, with Python, the interpreter is likely not installed on Windows and possibly a Mac. With Linux one would need to verify the correct Python version is installed. I think the same problems are true with Ruby and Perl. However, JVMs are more likely to be installed. If the issue to avoid using Java itself, then Scala and Groovy(?) may be better alternatives to Python or Ruby. I do not know enough about either to make a choice. If the issue is the remove Java entirely then I think the choice is basically Python, Perl, or Ruby. From what I have seen Python is probably the better choice in my somewhat biased opinion (I write mostly in Python). Python modules exist for PyQT/Pyside (QT) and wxWidget and tkinter is built-in, which I believe are all cross platform. Jay On 04/20/2014 02:35 PM, Bjoern Michaelsen wrote: Hi, On Sun, Apr 20, 2014 at 09:43:45AM -0700, Robinson Tryon wrote: Bjoern -- Thoughts on using Glade for this purpose? I figure it might be good to use the same stuff we're using elsewhere in the LO project... I dont think Glade is a good idea. If the bibisect UI is sufficiently simple (and it should be), Tkinter would be the most simple crossplatform toolkit that is available everywhere -- even if it is somewhat ugly on some platforms. As for using Python instead of Java: I based that on the assumption that (at least in the LibreOffice community) there are more people willing to work on the first than on the second. I might be wrong. @Florian: So if there are not a few people showing up saying I would help out with Python, but unlikely with Java (which did not happen yet), just go ahead with Java, if you prefer that. It was based on my gut feeling, and gut feelings might be wrong. Best, Bjoern ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/ -- Jay Lozier jsloz...@gmail.com ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
Re: [Libreoffice-qa] Python vs Java, Was Bisect GUI for Windows
I can help with Python Jay On 04/20/2014 05:39 PM, Bjoern Michaelsen wrote: On Sun, Apr 20, 2014 at 02:57:36PM -0400, Jay Lozier wrote: Also, with Python, the interpreter is likely not installed on Windows and possibly a Mac. Python ships with LibreOffice on Windows and Mac (and can be assumed to be there on ~all Linux installs). But anyway, the only thing that would be relevant is someone stepping up and saying I would help out if its in Python (or I would help out if its in Java FWIW). Anyone? ;) Best, Bjoern -- Jay Lozier jsloz...@gmail.com ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
Re: [Libreoffice-qa] Windows 8 Tester for FDO#63215 (crasher)
On 04/07/2013 07:03 AM, Pedro wrote: Answered on the Bugzilla report -- View this message in context: http://nabble.documentfoundation.org/Libreoffice-qa-Windows-8-Tester-for-FDO-63215-crasher-tp4048318p4048344.html Sent from the QA mailing list archive at Nabble.com. ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/ Answered on Bugzilla report - using Linux Mint and 4.0.2.1 and unable to replicate reported problems. -- Jay Lozier jsloz...@gmail.com ___ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/