https://bz.apache.org/bugzilla/show_bug.cgi?id=64505
chenlin <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO OS| |All --- Comment #1 from chenlin <[email protected]> --- (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: [email protected] For additional commands, e-mail: [email protected]
