https://bz.apache.org/bugzilla/show_bug.cgi?id=64505
Bug ID: 64505
Summary: TRANSPOSE does not handle string cells
Product: POI
Version: 4.1.2-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 37296
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37296&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
