[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2018-12-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=80583

Eike Rathke  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |er...@redhat.com
   |desktop.org |
 Status|NEW |ASSIGNED

--- Comment #23 from Eike Rathke  ---
Taking.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2018-06-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=80583

--- Comment #22 from raal  ---
Created attachment 142635
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142635=edit
Calc 6.2master

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2018-06-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=80583

--- Comment #21 from raal  ---
LO 6.2master -  bug still happens in Total cell. It doesn't work in EN language
settings, but works in CZ language settings (comma as decimal separator, ; as
separator in functions)

Tomaz,if you find some time ... Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2018-02-22 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=80583

Andrew Ziem  changed:

   What|Removed |Added

 CC||ahz...@gmail.com

--- Comment #20 from Andrew Ziem  ---
This bug still happens. That is, when I create an ANOVA the Total SS has ERR
508 until I edit it.

LibreOffice version 6.0.0.3
Build ID 64a0f66915f38c6217de274f0aa8e15618924765
Ubuntu 16.04

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2017-09-01 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=80583

--- Comment #19 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice 
(5.4.1 or 5.3.6  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and 
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20170901

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2015-12-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=80583

--- Comment #17 from fs...@yahoo.com ---
in my trial(12/23/2015), a very similar problem on my 5.0.2 LibraOffice
download, about calc to using its (tools->solver) to solve a simple nonlinear
equation with one unknown; the correct answers have 2 roots(2 correct answers), 
if I enter init value close to one(answer of bigger value), calc's algorithm
can converge to it; if I enter init value close to another one(answer of
smaller value), calc's algorithm can converge to it too, however, at the end,
calc popup
a "conclusion"-window which claimed (No Solution), and everything locked there
unless I am be forced to click (OK), then that correct-smaller answer gone,
back to original init value.  I wish there is one post here when it be solved
at some newer version maybe.  Also, libreoffice 's calc algorithm spend a long
time ~20-30 sec compare to another free-open-source on mathmatical calculation
project, Octave, which can post out correct answers in 1 sec under my test.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2015-12-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=80583

--- Comment #18 from Tomaz Vajngerl  ---
(In reply to fsshl from comment #17)
> in my trial(12/23/2015), a very similar problem on my 5.0.2 LibraOffice
> download, about calc to using its (tools->solver) to solve a simple
> nonlinear equation with one unknown; the correct answers have 2 roots(2
> correct answers), 
> if I enter init value close to one(answer of bigger value), calc's algorithm
> can converge to it; if I enter init value close to another one(answer of
> smaller value), calc's algorithm can converge to it too, however, at the
> end, calc popup
> a "conclusion"-window which claimed (No Solution), and everything locked
> there unless I am be forced to click (OK), then that correct-smaller answer
> gone, back to original init value.  I wish there is one post here when it be
> solved at some newer version maybe.  Also, libreoffice 's calc algorithm
> spend a long time ~20-30 sec compare to another free-open-source on
> mathmatical calculation project, Octave, which can post out correct answers
> in 1 sec under my test.

This has nothing to do with this bug... except that both are in Calc. Create a
new bug and provide an example document.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2015-12-02 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=80583

--- Comment #16 from Kevin Suo  ---
Bug still exists in:
Version: 5.0.4.1 (x64)
Build ID: 2def61bcbb29a7a8611b833682fe1291910b11ad
Locale: zh-CN (zh_CN)

also exists in:
Version: 5.1.0.0.beta1-buildfix1 (x64)
Build ID: 13010a13177025f633c9b85adcb3edf6920e44e3
Threads 4; Ver: Windows 6.19; Render: GL; 
Locale: zh-CN (zh_CN)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2015-06-23 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=80583

--- Comment #15 from Kevin Suo suokunl...@126.com ---
This bug still exists with:

Version: 5.0.0.1
Build ID: 9a0b23dd0ab9652e0965484934309f2d49a7758e
Locale: zh-CN (zh_CN)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2014-11-16 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=80583

Mirosław Zalewski mini...@poczta.onet.pl changed:

   What|Removed |Added

 CC||mini...@poczta.onet.pl

--- Comment #12 from Mirosław Zalewski mini...@poczta.onet.pl ---
Few code pointers for those interested. Fixing this should be easy enough for
people with basic knowledge of C++ (not me, unfortunately).

sc/source/ui/StatisticsDialogs/AnalysisOfVarianceDialog.cxx :
Total Sum of Squares in one factor ANOVA is constructed by using applyRangeList
method (line 324). 
Withing groups sum of squares is constructed by using
lclCreateMultiParameterFormula() function (line 296), and between groups sum of
squares has semicolon hardcoded (line 251).

When output is written to spreadsheet, it's formula grammar is explicitly set
to English (line 549).

But applyRangeList method, defined in
sc/source/ui/StatisticsDialogs/TableFillingAndNavigationTools.cxx line 65, uses
mpDoc-GetAddressConvention() to format formula according to local grammar (I
assume).

This means that all formulas constructed using applyRangeList will return
syntax error when local grammar is not compatible with English grammar. This
affects only Total sum of squares of one factor ANOVA, but similar artifacts
may be present in other statistical functions.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2014-11-16 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=80583

Mirosław Zalewski mini...@poczta.onet.pl changed:

   What|Removed |Added

 CC||qui...@gmail.com

--- Comment #13 from Mirosław Zalewski mini...@poczta.onet.pl ---
Hi Tomaz

There is a problem while constructing formulas for one factor ANOVA. It affects
Chinese users (and probably others who use comma as formula argument
separators). Very similar to bug 76731. Could you take a look at this?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2014-11-16 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=80583

--- Comment #14 from Tomaz Vajngerl qui...@gmail.com ---
(In reply to Mirosław Zalewski from comment #13)
 Hi Tomaz
 
 There is a problem while constructing formulas for one factor ANOVA. It
 affects Chinese users (and probably others who use comma as formula argument
 separators). Very similar to bug 76731. Could you take a look at this?

Yes, sure I can. :)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2014-07-02 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=80583

--- Comment #8 from Jacques Guilleron guillero...@aol.com ---
Hello Kevin,

Installed in a new profile, I don't reproduce the issue with LO 4.2.5.2 and
Windows 7 Home Premium.
 When you were generating ANOVA in D1, are you sure you are using A1:B100 as   
   data source? (not only a single cell?)
Yes. Dialog window at the beginning was made for that.
 I can 100% reproduce even I copy A1:B100 anywhere.
OK.
 Those numbers in A1:A100 were generated by using the Edit - Fill - Random
   Numbers.
If I copied them, it's mainly to have the same results with ANOVA.
 In fact, even the following simple numbers in A1:B2 will get the same ERR 509:
 1,2
 3,4
OK.
 There is no problem with Number1 and Number2 separated by comma. In calc, 
 formula both accepts , and ;. For example, =SUM(1,2) and =SUM(1;2) 
 all  get the expected results.
I don't think so. SUM(1,2) give me 1,2, SUM(1, 2) give Err:509 and
delete the comma, and SUM(1;2) give 3.
Anyway, for ANNOVA, changing the comma by semicolon give the result into the
formula of Total.
 The formula in E11 was not input manually, it was generated by Data  
  Statistics - Analysis of Variance. So even there was input error, its 
 not  the user's fault.
Yes. You are right and that has to be fixed.
 However, the reality is that, there is no input error. (If you copy and paste 
  the exact same formula within E11 to another cell, it get the expected  
   result, rather than ERR 508.)
If I do that, I get Err:501

regards,

Jacques

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2014-07-02 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=80583

--- Comment #9 from Kevin Suo suokunl...@gmail.com ---
(In reply to comment #8)
Hi, Jacques. Thank you very much for your useful info. This bug is becoming
really interesting.

* By default, LibreOffice uses , as separator. (This can be verified when you
reset your profile and go to Tools - Options - LibreOffice Calc - Formula -
Separators: Function.
* When I set the separator for function to ; then follow the steps, I do not
get the Err:508. I think this may be why you do not reproduce this bug
behaviour.
* When I set the separator back to ,, I can reproduce this bug behaviour
again.

Also:
* When set separator to ,, =SUM(1,2) and =SUM(1;2) all get result 3.
(=SUM(1;2) will be atomically converted to =SUM(1,2) when you hit ENTER)
* When set separator to ;, =SUM(1,2) results #NAME?, and =SUM(1;2)
results 3. 

I hope these information will be helpful. Thanks!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2014-07-02 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=80583

--- Comment #10 from Kevin Suo suokunl...@gmail.com ---
(In reply to comment #9)

So I guess maybe libreoffice is using ; as separator when applying Data -
Statistics - Analysis of Variance, even if the separator for calc is
configured as ,, thus results error message.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2014-07-02 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=80583

--- Comment #11 from Jacques Guilleron guillero...@aol.com ---
Well done! Kevin, you got it !

That's the right explanation. I forgot to look at there.
Another difficulty: those parameters are locale dependent.
If I set Locale to English(USA), I find comma for separator in functions and
indeed this behaviour.
But I think this is also the case for some other functions.

It's already fine to have this.

Regards,

Jacques

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2014-07-01 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=80583

Jacques Guilleron guillero...@aol.com changed:

   What|Removed |Added

 CC||guillero...@aol.com

--- Comment #6 from Jacques Guilleron guillero...@aol.com ---
Hello Kevin,

If I copy A1:B100 in a new sheet and generate ANOVA in D1, I don't reproduce
the issue. 
If now I select E11 and function wizard fx, I see the issue: Number 1 and
Number 2 are together in the same input line, separated by a comma, wheras a
semicolon is expected.
Input error?

Jacques

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2014-07-01 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=80583

--- Comment #7 from Kevin Suo suokunl...@gmail.com ---
(In reply to comment #6)

 If I copy A1:B100 in a new sheet and generate ANOVA in D1, I don't reproduce
 the issue. 
When you were generating ANOVA in D1, are you sure you are using A1:B100 as
data source? (not only a single cell?)
I can 100% reproduce even I copy A1:B100 anywhere.

Those numbers in A1:A100 were generated by using the Edit - Fill - Random
Numbers.
In fact, even the following simple numbers in A1:B2 will get the same ERR 509:
1,2
3,4

 If now I select E11 and function wizard fx, I see the issue: Number 1 and
 Number 2 are together in the same input line, separated by a comma, wheras a
 semicolon is expected.

There is no problem with Number1 and Number2 separated by comma. In calc,
formula both accepts , and ;. For example, =SUM(1,2) and =SUM(1;2) all
get the expected results.

 Input error?
The formula in E11 was not input manually, it was generated by Data -
Statistics - Analysis of Variance. So even there was input error, its not
the user's fault.
However, the reality is that, there is no input error. (If you copy and paste
the exact same formula within E11 to another cell, it get the expected result,
rather than ERR 508.)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs


[Libreoffice-bugs] [Bug 80583] EDITING: Analysis of Variance (ANOVA): DEVSQ returns Err:508, while direct DEVSQ formula returns correct result

2014-06-27 Thread bugzilla-daemon
https://bugs.freedesktop.org/show_bug.cgi?id=80583

Jay Philips philip...@hotmail.com changed:

   What|Removed |Added

Summary|Data - Statistics - |EDITING: Analysis of
   |Analysis of Variance: DEVSQ |Variance (ANOVA): DEVSQ
   |returns Err:508, while  |returns Err:508, while
   |direct DEVSQ formula|direct DEVSQ formula
   |returns correct result  |returns correct result

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs