Difference between revisions of "Documentation/FAQ/Calc/Formatting"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc
Line 14: | Line 14: | ||
</DPL> | </DPL> | ||
− | <table border= | + | |
+ | |||
+ | |||
+ | <table border=1 cellpadding=5 style="width:100%; border-collapse: collapse; border-color:#AAA; background-color:#EEE;"><tr> | ||
+ | <td> | ||
+ | ===Add a new FAQ entry=== | ||
<inputbox> | <inputbox> | ||
+ | bgcolor=#EEE | ||
type=create | type=create | ||
− | default=Documentation/FAQ/Calc/Formatting/< | + | default=Documentation/FAQ/Calc/Formatting/<FAQ_TITLE> |
preload=Documentation/FAQ_Template | preload=Documentation/FAQ_Template | ||
buttonlabel=Add new FAQ | buttonlabel=Add new FAQ | ||
− | |||
break=no | break=no | ||
</inputbox> | </inputbox> | ||
+ | '''Instructions''' | ||
+ | * Do '''not ask questions''' here, but '''give answers'''. | ||
+ | * If you have a '''question to ask''', go to the [http://user.services.openoffice.org User Forum]. | ||
+ | * Replace ''<FAQ_TITLE>'' part in the input box above by the title you would like to give the FAQ item and click '''Add New FAQ''' | ||
</td></tr></table> | </td></tr></table> |
Revision as of 09:21, 7 April 2009
This page has FAQs about formatting spreadsheets in OpenOffice.org Calc.
This list is ordered by popularity. The most popular FAQs are at the top. But also have a look at the bottom to find any new entries.
- How can I create a drop-down list that references a list of values to select from?
- How do I insert superscript or subscript text in my spreadsheet?
- How do I wrap text within a cell in my spreadsheet?
- How can I use a dot (.) as decimal sign instead of a comma?
- How can I use conditional formatting?
- How can links to other workbooks, including vlookups, update dynamically?
- How do I add additional strings or characters to cell contents?
- How do I insert a page number in the form of 'Page 1 of N' on each page of a spreadsheet?
- How are thick lines or borders created around my cells?
- How do I format cells in Calc so that the rows number automatically?
- Is there a way to add times that total greater than 24 hrs?
- How can I create my own sort lists?
- How do I use styles and formatting?
- How do I make a wide title cell extend across several columns in my spreadsheet?
- I have a custom number format that I use, but Calc forgets it.
- Some of the rows or columns in my spreadsheet are hidden. How do I see all rows or columns?
- How do I disable the capitalized letter at the beginning of cells in Calc?
- Can I center my text so that the text will flow both to the left and right if the cells are empty?
- How do I rotate a column title so that it fits above my very narrow column?
- How are notes within cells displayed?
- Why are my notes not showing for cells?
Add a new FAQ entryInstructions
|