Tulisan ini adalah hasil copas dari menu help open office v3.2
Tujuan nya adalah sebagai arsip, bahan belajar untuk keperluan sendiri.
======================
Karena di kantor sudah mulai menggunakan open office, dan karena masih terbiasa dengan microsoft Excel, maka ketika ingin me-warp tulisan di cell masih kesulitan.
Biasa nya di MSExcel menggunakan ALT+Enter, tetapi di OO32 ternyata tidak berlaku.
setelah buka help nya, ketahuan dech, ternyata OO32 memakai Ctrl+Enter. *) tetapi dengan syarat tertentu...,
Inserting Line Breaks in Cells
Inserting line breaks in OpenOffice.org Calc spreadsheet cells
1.To insert a line break in a spreadsheet cell, press the Ctrl+Enter keys.
This will work only with the text edit cursor inside the cell, not at the input line. So first double-click the cell, then single-click at the text position where you want the line break.
You can search for a newline character in the Find & Replace dialog by searching for \n as a regular expression. You can use the text function CHAR(10) to insert a newline character into a text formula.
Formatting OpenOffice.org Calc cells for automatic line wrapping
1.Select the cells for which you want an automatic line break.
2.Choose Format - Cells - Alignment.
3.Select Wrap text automatically.
Inserting line breaks in OpenOffice.org Writer text document tables
1.To insert a line break in a text document table cell, press the Enter key.
An automatic line break will be performed while you type across the end of each cell.
Tujuan nya adalah sebagai arsip, bahan belajar untuk keperluan sendiri.
======================
Karena di kantor sudah mulai menggunakan open office, dan karena masih terbiasa dengan microsoft Excel, maka ketika ingin me-warp tulisan di cell masih kesulitan.
Biasa nya di MSExcel menggunakan ALT+Enter, tetapi di OO32 ternyata tidak berlaku.
setelah buka help nya, ketahuan dech, ternyata OO32 memakai Ctrl+Enter. *) tetapi dengan syarat tertentu...,
Inserting Line Breaks in Cells
Inserting line breaks in OpenOffice.org Calc spreadsheet cells
1.To insert a line break in a spreadsheet cell, press the Ctrl+Enter keys.
This will work only with the text edit cursor inside the cell, not at the input line. So first double-click the cell, then single-click at the text position where you want the line break.
You can search for a newline character in the Find & Replace dialog by searching for \n as a regular expression. You can use the text function CHAR(10) to insert a newline character into a text formula.
Formatting OpenOffice.org Calc cells for automatic line wrapping
1.Select the cells for which you want an automatic line break.
2.Choose Format - Cells - Alignment.
3.Select Wrap text automatically.
Inserting line breaks in OpenOffice.org Writer text document tables
1.To insert a line break in a text document table cell, press the Enter key.
An automatic line break will be performed while you type across the end of each cell.
Comments
Post a Comment