Bug 64505 - TRANSPOSE does not handle string cells
Summary: TRANSPOSE does not handle string cells
Status: NEEDINFO
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 4.1.2-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-08 10:58 UTC by d.parlapiano
Modified: 2020-07-14 08:38 UTC (History)
0 users



Attachments
Attached are the file called "template" to be used for testing and the file called "evaluate" which shows what the POI functions return. (12.33 KB, application/x-zip-compressed)
2020-06-08 10:58 UTC, d.parlapiano
Details
test case poi (6.12 KB, application/x-zip-compressed)
2020-07-14 08:38 UTC, d.parlapiano
Details

Note You need to log in before you can comment on or make changes to this bug.
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