https://bugs.documentfoundation.org/show_bug.cgi?id=158620
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Summary|Add #SPILL! error |TRANSPOSE() should generate | |an error if cells available | |are not sufficient to write | |the result. CC| |[email protected] Ever confirmed|0 |1 --- Comment #4 from Eike Rathke <[email protected]> --- However, TRANSPOSE() silently omitting values if the transposed matrix does not have sufficient cells dimension to be held should generate _some_ error, IMHO.. probably #REF! but if Excel uses #SPILL! (does it?) for this very situation then we could introduce that as well. So maybe we should change this request from anything #SPILL! error related to the actual use case described. Doing so. -- You are receiving this mail because: You are the assignee for the bug.
