This page is outdated. You will be redirected to http://wiki.services.openoffice.org /wiki/Documentation/FAQ shortly.
Spreadsheet FAQ Index Page
- 001 - How do I open a tab-delimited file in OpenOffice.org Spreadsheet? What if I have a different type of delimiter?
- 002 - I see '###' in a cell that formerly held data. How can I see my data again?
- 003 - How do I wrap text within a cell in my spreadsheet?
- 004 - How I do select a row (or rows) in my spreadsheet to repeat on every page when printed?
- 005 - I don't want a capitalized letter at the beginning of a phrase in Calc. What should I do?
- 006 - How do I freeze/split the first rows and the first columns so that they remain visible when I scroll through my spreadsheet?
- 007 - How do I print my spreadsheet correctly?
- 008 - How do I make a wide title cell extend across several columns in my spreadsheet?
- 009 - How do I rotate a column title so that it fits above my very narrow column?
- 010 - How do I create a chart in a spreadsheet that is automatically updated when the data is changed?
- 011 - How do I protect cells in my spreadsheet?
- 012 - How do I output my spreadsheet data as an ASCII, delimited text file?
- 013 - Some of the rows in my spreadsheet are hidden. How do I see all the rows?
- 014 - How do I format cells in OpenOffice.org Spreadsheet so that the rows number automatically?
- 015 - What do each of the error codes (Err:NNN) in OpenOffice.org spreadsheets mean?
- 016 - How can I use cells from different Calc files?
- 017 - How I change the order of sheets in my spreadsheet?
- 018 - How can I rename a sheet?
- 019 - How is a variable date inserted into a spreadsheet cell?
- 020 - How are thick lines or borders created around my cells?
- 021 - How do I insert a page number in the form of 'Page 1 of N' on each page of a spreadsheet?
- 022 - A large OpenOffice.org spreadsheet was converted from another application. Some of my rows are missing! What happened?
- 023 - What is the maximum number of cells in an OpenOffice.org spreadsheet?
- 024 - How do I insert superscript or subscript text in my spreadsheet?
- 025 - Is it possible to open an Excel file that is protected by a password in Calc?
- 026 - How can I use decimal signs (dots) instead of commas to display rational figures?
- 027 - I want to select two cells that are not adjacent, but holding down the CTRL key does not seem to work. How can I perform this action?
- 028 - How can I create my own sort lists?
- 029 - Is there any way to merge a text file with separated fields (*.txt, *.csv) into a Calc file?
- 030 - How can I wrap text within a cell?
- 031 - If a cell is centre-justified, and the text is wider than the cell, it automatically left-justifies. Can I fix this?
- 032 - In MS Excel I can center my text so that the text will flow both to the left and right if the cells are empty; how can I do this in Calc?
- 033 - How do I use styles and formatting?
- 034 - Can I use a spreadsheet file with more than 32,000 rows?
- 035 - My formula from an Excel worksheet doesn't work!
- 036 - Why does Calc refuse to open my text file?
- 037 - How do I add trailing characters to a cell?
- 038 - How are notes within cells displayed?
- 039 - Why does deleting filtered rows remove other rows too?
- 040 - How can I start Calc instead of Writer?
- 041 - Why does Calc print out all the sheets in the file?
- 042 - How can I print some, but not all, of the cells on a sheet?
- 043 - How do I get Sheet1 to print as portrait and Sheet2 to print as landscape?
- 044 - I have a custom number format that I use, but Calc forgets it.
- 045 - How can I use conditional formatting?
- 046 - What is the fastest way to copy a calculation to all rows?
- 047 - Where can I find definitions for the error codes?
- 048 - Why do I see the formula text and not the result of the formula?
- 049 - Is there a way to add times that total greater than 24hrs?
- 050 - Where can I find more documentation for Calc?
- 051 - These automatisms suck!!
- 052 - How to get proper Calc Help files for OpenOffic.org 2.0.1 for Windows?
- 053 - How do I extend the range of data shown in my chart after I add new data to my spreadsheet?
