[Libreoffice-bugs] [Bug 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

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

Holger Klene  changed:

   What|Removed |Added

 CC||h.kl...@gmx.de

--- Comment #13 from Holger Klene  ---
Created attachment 140986
  --> https://bugs.documentfoundation.org/attachment.cgi?id=140986=edit
strange index value error

I'm having trouble to make the returned arrays intersect with the current row.
It works for non-empty cells, but fails on empty cells (red in the given
document).

I thought it is due to the strange behavior of the function wizard sometimes
giving the result as a preview or failing with a value error. So clicking
different locations inside the function wizard it will suck up parameters or
add spaces.

But trying to replicate this manually, I could not make it work. Only
explicitly giving row and column solved it.

Could you please have a look at my instructions in the given document, if you
can reproduce the strange screenshots also embedded in the document?

Thanx

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |NOTABUG

--- Comment #12 from Eike Rathke  ---
It's neither nor, you also don't need to enter it as array formula, but then it
depends on the position context. If not an array formula, whether the result is
#VALUE! depends on where (which cell) the formula is entered. What
=INDEX(A1:C3,1) does is it returns the cell range A1:C1, if not in array
context the implicit intersection of the formula position with the range is
taken as usual, this is the same as in =A1:C1, so if the formula is anywhere in
columns A:C then the value of row 1 in that column is the result, in any other
column the  result is #VALUE! because there is no intersection with A1:C1.

Entered as array formula the result is an array with values of A1:C1, which can
be entered on any cell position, e.g. the same as {=A1:C1}

All this is normal cell range evaluation behaviour regarding scalar/array
context and not specific to the INDEX() function.

In the attached screenshot examples only results BLUE and RED work because only
for those the formula expression can determine exactly one cell.

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

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

--- 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 on a currently supported version of
LibreOffice 
(5.1.6 or 5.2.3  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-20170103

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

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

--- Comment #10 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.0.4 or later)
   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

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 your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71325

Robinson Tryon (qubit) qu...@runcibility.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||qu...@runcibility.com
 Ever confirmed|0   |1

--- Comment #9 from Robinson Tryon (qubit) qu...@runcibility.com ---
So to sum-up...

(In reply to John Smith from comment #6)
   Perhaps this can be put forward as a bug to
   have the Array check-box automatically selected as it is for functions 
   such
   as MMULT, GROWTH and TREND
  ...
  I have to disagree. INDEX is not always an array formula.
  ...

So who decides?

  IMHO, this is a documentation problem only, thus the doc's team should be
  cc'd and the description of the bug should be changed accordingly.

 I am still of the opinion this should be passed to the devs as a bug to
 allow them to determine just what the function should do.

(In reply to Ady from comment #7)
 Perhaps the Status of this bug report should be changed and some QA group
 should be cc'd.

I can't speak ex cathedra for the QA Team, but I'm pretty sure we're okay
letting others make the call here. I'll bring this up to the Devs *and* to the
Design Team, and let them both weigh-in.

Regardless of how we decide to resolve the issue, it's valid, so Status - NEW.

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71325

--- Comment #8 from raal r...@post.cz ---
According to comment 7 should be Component = Documentation?

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71325

Ady ady...@hotmail.com changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71325

--- Comment #6 from John Smith clicks...@yahoo.co.uk ---
(In reply to comment #5)
 (In reply to comment #3)
  Perhaps this can be put forward as a bug to
  have the Array check-box automatically selected as it is for functions such
  as MMULT, GROWTH and TREND
 
 I have to disagree. INDEX is not always an array formula.
 
 When INDEX is used as an array function, the first argument is required and
 the rest are optional.
 
 When INDEX is used as simple function, both row and column arguments are
 required, and there are no default values for these 2 arguments (not
 zero nor one).
 
 IMHO, this is a documentation problem only, thus the doc's team should be
 cc'd and the description of the bug should be changed accordingly.

I believe this should be an array formula.
The first argument, 'reference' is always required.
Only as 'array' is a result returned when this parameter is used on its own.
When 'row' is then added both 'simple' and 'array' return results.
Same when 'column' is added with 'row' so that both are present.
Only as 'array' is a result returned with 'row' 0 or omitted and 'column'
present.

If you read the ODF spec. for this function here;
http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#INDEX
I think you will appreciate why it ought to be an 'array'.

I am still of the opinion this should be passed to the devs as a bug to allow
them to determine just what the function should do.

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71325

--- Comment #7 from Ady ady...@hotmail.com ---
(In reply to comment #6)
 I believe this should be an array formula.
 The first argument, 'reference' is always required.
 Only as 'array' is a result returned when this parameter is used on its own.
 When 'row' is then added both 'simple' and 'array' return results.
 Same when 'column' is added with 'row' so that both are present.
 Only as 'array' is a result returned with 'row' 0 or omitted and 'column'
 present.
 

 Your own comments are reinforcing the need to improve the current help
documents for the INDEX function in Calc.

 If you read the ODF spec. for this function here;
 http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.
 html#INDEX
 I think you will appreciate why it ought to be an 'array'.

Well, I still read the same as before. It says ReferenceList|Array
DataSource, meaning that the *DataSource* can be either a *reference* (simple
formula) or an *array* (array formula).

So, again, INDEX can be used in a simple formula or in an array formula.

 
 I am still of the opinion this should be passed to the devs as a bug to
 allow them to determine just what the function should do.

IMHO, the function itself is already defined and it seems to be working as
defined, so I see this as a documentation problem in Calc.

Perhaps the Status of this bug report should be changed and some QA group
should be cc'd.

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71325

--- Comment #3 from John Smith clicks...@yahoo.co.uk ---
(In reply to comment #2)
 I think the issue is the help may need a better explanation.
 
 When the range has more than one row or column, respective default options
 or zero value need to enter the formula as array Ctrl+Shift+Enter instead of
 Enter, because it is working with a matrix in this cases.

Yeah that seems to be the case. Perhaps this can be put forward as a bug to
have the Array check-box automatically selected as it is for functions such as
MMULT, GROWTH and TREND

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71325

--- Comment #4 from mariosv mari...@miguelangel.mobi ---
If you are agree, please adapt the title and change the importance from normal
to enhancement.

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71325

--- Comment #5 from Ady ady...@hotmail.com ---
(In reply to comment #3)
 Perhaps this can be put forward as a bug to
 have the Array check-box automatically selected as it is for functions such
 as MMULT, GROWTH and TREND

I have to disagree. INDEX is not always an array formula.

When INDEX is used as an array function, the first argument is required and the
rest are optional.

When INDEX is used as simple function, both row and column arguments are
required, and there are no default values for these 2 arguments (not zero
nor one).

IMHO, this is a documentation problem only, thus the doc's team should be cc'd
and the description of the bug should be changed accordingly.

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71325

--- Comment #1 from Ady ady...@hotmail.com ---
I confirm inadequate behavior, in LO 4.1.3.2 on Windows.

Additionally, explicitly using zero values for row and/or column (instead of
leaving them empty, which should be equivalent to zero according to official
help), are also resulting in a #value error.

The only argument that is being accepted as optional is the last one (range),
instead of accepting row and column as optional (or zero) too.

-- 
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 71325] UI: INDEX function returns #VALUE error when optional arguments are omitted.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=71325

mariosv mari...@miguelangel.mobi changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||mari...@miguelangel.mobi
 Ever confirmed|0   |1

--- Comment #2 from mariosv mari...@miguelangel.mobi ---
I think the issue is the help may need a better explanation.

When the range has more than one row or column, respective default options or
zero value need to enter the formula as array Ctrl+Shift+Enter instead of
Enter, because it is working with a matrix in this cases.

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