https://bz.apache.org/bugzilla/show_bug.cgi?id=64505
chenlin <740475...@qq.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
OS| |All
--- Comment #1 from chenlin <740475...@qq.com> ---
(In reply to d.parlapiano from comment #0)
> Created attachment 37296 [details]
> Attached are the file called "template" to be used for testing and the file
> called "evaluate" which shows what the POI functions return.
>
> The array formula with the TRANSPOSE function doesn't handle string values
> and returns #VALUE.
>
> If I use the TRANSPOSE function on cells of type string, it only returns
> #value.
>
> If I use the TRANSPOSE function on cells containing both types of data
> (strings and numbers), only cells containing numbers will evaluate correctly.
>
> If I use the TRANSPOSE function on cells of type number, it correctly
> returns the values.
>
> Attached are the file called "template" to be used for testing and the file
> called "evaluate" which shows what the POI functions return.
Upload test cases if possible. It's easy for us to understand your intentions.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
