Re: [Libreoffice-qa] Compatibility, Open Source, Microsoft

2015-02-04 Thread Jay Lozier


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

2014-06-29 Thread Jay Lozier


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

2014-06-29 Thread Jay Lozier


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

2014-04-25 Thread Jay Lozier

  
  
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

2014-04-20 Thread Jay Lozier

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

2014-04-20 Thread Jay Lozier

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

2014-04-20 Thread Jay Lozier

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)

2013-04-07 Thread Jay Lozier

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/