diff options
-rw-r--r-- | source/text/scalc/01/04060107.xhp | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/source/text/scalc/01/04060107.xhp b/source/text/scalc/01/04060107.xhp index 842121ad92..46203e7496 100644 --- a/source/text/scalc/01/04060107.xhp +++ b/source/text/scalc/01/04060107.xhp @@ -683,7 +683,7 @@ <paragraph id="par_idN11B75" role="tablecontent" localize="false" xml-lang="en-US"><item type="input">7</item></paragraph> </tablecell> <tablecell> - <paragraph id="par_idN11B81" role="tablecontent" xlocalize="false" ml-lang="en-US"><item type="input">8</item></paragraph> + <paragraph id="par_idN11B81" role="tablecontent" localize="false" xml-lang="en-US"><item type="input">8</item></paragraph> </tablecell> <tablecell> <paragraph id="par_idN11B7H" role="tablecontent" localize="false" xml-lang="en-US"><item type="input">9</item></paragraph> @@ -691,12 +691,11 @@ </tablerow> </table> -The above table is 2 rows, 4 columns. In order to transpose it, you must select 4 rows, 2 columns. Assuming you want to transpose the above table to the range A7:B10 (4 rows, 2 columns) you must select the entire range and then enter the following: +<paragraph id="par_id3168518" role="paragraph" xml-lang="en-US">The above table is 2 rows, 4 columns. In order to transpose it, you must select 4 rows, 2 columns. Assuming you want to transpose the above table to the range A7:B10 (4 rows, 2 columns) you must select the entire range and then enter the following:</paragraph> <paragraph id="par_id3166145" role="code" xml-lang="en-US">TRANSPOSE(A1:D2)</paragraph> -Then <emph>make sure to enter it as matrix formula with <switchinline select="sys"><caseinline select="MAC">Shift+Command+Enter -</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline></emph>. The result will be as follows: +<paragraph id="par_id3178518" role="paragraph" xml-lang="en-US">Then <emph>make sure to enter it as matrix formula with <switchinline select="sys"><caseinline select="MAC">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline></emph>. The result will be as follows:</paragraph> <table id="tbl_id6215816"> <tablerow> |