[Libreoffice-bugs] [Bug 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

Eike Rathke  changed:

   What|Removed |Added

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

--- Comment #12 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 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

--- Comment #11 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 with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

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) from
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:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

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

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
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 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

--- Comment #10 from Wolfgang Jäger  ---
FORMULA is returning the correct array in my tests under array evaluation since
V5.1.1.3 (latest). Insofar: fixed - worksforme.

ISFORMULA is showing the bug as demonstrated earlier still in V5.3.0.0 beta1.

-- 
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 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

--- Comment #9 from Wolfgang Jäger  ---
Created attachment 126957
  --> https://bugs.documentfoundation.org/attachment.cgi?id=126957=edit
Reworked demo containing additional proof for a claim.

The demo was rework adding columns K through N to the otherwise unchanged
sheet. 

This is done to prove the claim that also the FORMULA function is not correctly
working in array-context under specific conditions despite the fact that
FORMULA is returning the correct array if directly entered for array evaluation
using (Ctrl+Shift+Enter).

The one "specific condition" demonstrated is the occurrence of FORMULA(A2:A5)
as a subformula on the ForceArray parameter position of SUMPRODUCT in cell M1
of the reworked sheet.

Cases where FORMULA and ISFORMULA are used for array evaluation may not be very
frequent. However, if used without success, the exploration of the cause of the
error may be difficult.

-- 
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 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

Christian Koppen  changed:

   What|Removed |Added

 Attachment #122817|Demo by user|Demo by user Christian
description|"s...@koppen.org" reworked  |reworked as descibed in
   |as descibed in comment #6   |comment #7

-- 
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 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

--- Comment #8 from Christian Koppen  ---
Wolfgang, I tried your new testcase with LibreOffice 5.0 (don't know the exact
version), but unfortunately it didn't work. Then I updated to LibreOffice
5.1.0.3 and now I can confirm your workaround. This will probably help me,
thanks a lot.

-- 
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 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

--- Comment #7 from Wolfgang Jäger  ---
Just tested with LibO V5.1.0.3 first using the original attachment to comment
#1.
The behaviour of FORMULA changed. It now retiurns the expected array of
formulas applied under array evaluation. 
The behaviour of ISFORMULA is unchanged. 
(Cf comments #4,#5 by user "s...@koppen.org".

I also reworked his example and added a (temporary) workaround concerning his
request based on the new behaviour of the FORMULA function.

As I still not am fully familiar with this bugzilla software I quoted a wrong
number of comment for it.

-- 
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 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

--- Comment #6 from Wolfgang Jäger  ---
Created attachment 122817
  --> https://bugs.documentfoundation.org/attachment.cgi?id=122817=edit
Demo by user "s...@koppen.org" reworked as descibed in comment #6

-- 
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 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

--- Comment #5 from s...@koppen.org ---
Created attachment 122814
  --> https://bugs.documentfoundation.org/attachment.cgi?id=122814=edit
Comparison of matrix evaluation of ISEVEN and ISFORMULA

-- 
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 91502] The functions FORMULA and ISFORMULA do not return the correct array under "iterative evaluation" condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

--- Comment #4 from s...@koppen.org ---
Please consider allowing ISFORMULA within Matrix evaluations.

-- 
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 91502] The functions FORMULA and ISFORMULA do not return the correct array under iterative evaluation condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

raal r...@post.cz changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||r...@post.cz,
   ||winfrieddonkers@libreoffice
   ||.org
 Ever confirmed|0   |1

--- Comment #3 from raal r...@post.cz ---
Reproducible with Version: 5.1.0.0.alpha1+
Build ID: e929194317a7debb1c5467282230cbbabe61a710
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time:
2015-05-22_06:33:18

Setting to NEW and adding Winfried to CC.

http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#ISFORMULA
Passing a non-reference, or a reference to more than one cell, is
implementation-defined.

-- 
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 91502] The functions FORMULA and ISFORMULA do not return the correct array under iterative evaluation condition (array-evaluation)

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=91502

Wolfgang Jäger j...@psilosoph.de changed:

   What|Removed |Added

Summary|The functions FORMULA and   |The functions FORMULA and
   |ISFORMULA do not return the |ISFORMULA do not return the
   |correctan array under   |correct array under
   |iterative evaluation  |iterative evaluation
   |condition   |condition
   |(array-evaluation)  |(array-evaluation)

-- 
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