To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80599
------- Additional comments from [EMAIL PROTECTED] Sat Aug 11 11:47:35 +0000 2007 ------- This functionality already exists, although it is slightly hidden: i.) you can *copy* the cell-range and *paste-special* it while checking the *Transpose* checkbox (see on the lower right corner of the 'Paste special' dialog). Beware however of a potential error with this method (see issue 74625, http://www.openoffice.org/issues/show_bug.cgi?id=74625). ii.) there are various array() functions, look in the help for the documentation on *array formulas* (at least in OOo 2.3 development version m222) write in one cell the following array formula: 1.) =transpose(_your_array_) 2.) DO NOT PRESS ENTER !!! 3.) press CTRL+SHIFT+ENTER !!! 4.) the formula changes to {=transpose(_your_array_)} the {}-braces cannot be entered manually! 5.) the formula and array will span all cells necessary to fill in the array Hope this helps. Should be closed as WORKSFORME. A better documentation is also warranted. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]