https://bugs.documentfoundation.org/show_bug.cgi?id=158620
--- Comment #5 from ady <[email protected]> --- (In reply to Eike Rathke from comment #4) > 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. Now we are back to the original Summary field. FWIW, TRANSPOSE() is not a new function (as Eike knows), whereas the #SPILL! error is directly related to the post-array-formulas era (i.e. dynamic arrays), not supported by Calc ATM. While I see the potential need to receive some kind of warning regarding the procedure described in comment 0, I am not sure that getting an error on the cell result (e.g. #REF!) is adequate; the result within the cell is correct. There are similar operations that will get a warning, not an error in valid cells. For instance, copy an entire column with content on row 17000 and then "paste special > transpose" to some row will trigger the warning: "There is not enough space on the sheet to insert here." The negative consequence is that _no_ cell gets a result, but the user is warned. I'm not sure the balance between the pros and cons is positive, in any of these cases. -- You are receiving this mail because: You are the assignee for the bug.
