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.
(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.
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
Created attachment 37362 [details] test case poi test case poi