Bug 64505

Summary: TRANSPOSE does not handle string cells
Product: POI Reporter: d.parlapiano
Component: SS CommonAssignee: POI Developers List <dev>
Status: NEEDINFO ---    
Severity: normal    
Priority: P2    
Version: 4.1.2-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: Attached are the file called "template" to be used for testing and the file called "evaluate" which shows what the POI functions return.
test case poi

Description d.parlapiano 2020-06-08 10:58:10 UTC
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.
Comment 1 chenlin 2020-07-14 06:21:58 UTC
(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.
Comment 2 d.parlapiano 2020-07-14 08:37:35 UTC
If you try to evaluate the attached test case (test-case-poi.zip) with the POI, you will see that the POI return errors and not the transposed line
Comment 3 d.parlapiano 2020-07-14 08:38:41 UTC
Created attachment 37362 [details]
test case poi

test case poi