some expressions involving arrays in {curly braces} give wrong answers, or complain #VALUE

Submitted by John Denker

Description

Created attachment 222481 spreadsheet exhibiting bug: some expressions involving arrays in {curly braces} give wrong answers, or complain #VALUE

Gnumeric version '1.10.13' The following appear to be 100% reproducible:

Symptom #1: =sumproduct({1,2,3},sin({1,3,5})) ... complains #VALUE

Symptom #2: =max(sin({1,3,5})) ... gives wrong numerical result

==========

By way of contrast, seemingly-similar expressions such as the following appear to give correct results:

=sumproduct({1,2,3},10^({1,3,5}))  ... (OK)

=linest(A15:A18,sin(2*{1,3,5}*A15:A18),FALSE)   ...  (OK)

~~Attachment 222481~~, "spreadsheet exhibiting bug: some expressions involving arrays in {curly braces} give wrong answers, or complain #VALUE":
function-of-array-bug.gnumeric

Version: 1.10.x