|
|
The documentation project has this excellent document explaining how to do simple calculations and formatting. You have 2 options : rename the file to have the extension .csv ; and “File” => “Open” dialog, you can also set the 'Files of type' field to 'Text CSV'. This is quite a way down in the list so it is easy to miss. This is a design limit in OpenOffice, but there are proposals to remove it. However it is unlikely that this will happen before OpenOffice 2.0. But if you want to help, this problem has been broken into several steps to be completed and many programmers could easily do it. If the 32000 limit is a real problem for you, there are a few options. Frequently when you are hitting the row limit it is a symptom of a spreadsheet design which could be improved: Restructure the rows - split the data into several spreadsheets ( or several sheets within one spreadsheet file ); and Use a real database – this is the most frequent thing people are trying to accomplish by having such a large number of rows in a sheet. To quote from Calc “Help” => “Shortcut Keys for Spreadsheet” : To fill a selected cell range with the formula that you entered on the Input line, press Alt+Enter. Hold down Alt+Enter+Shift to apply the cell format of the input cell to the entire cell range. Go to “Tools” => “Options” and then “Spreadsheet” => “Print” to make sure the "Print only selected sheet" is checked. You can select the cell(s) you want to print then you go to “Format” => “Print Range” => “Define”. When the content of a cell is too long to be displayed in a single cell, it will be clipped at the standard width and height of the cell itself. The rest of the content is simply hidden. You can: Go to the heading row and drag one of the column edges until it is wide enough to display your data properly if the cell content is a number; or Double click on the cell if the cell content is text and a little red triangle appears on the right side of the cell to signal that this is an overflowing one. It is not possible to do this directly. Such a file can be opened from Calc only if you remove the password using the original application. "Goal Seek" in OpenOffice is the equivalent of Solver in Excel. “Tools” => “Goal Seek” To learn more about it: “Help” => “Contents” => “Spreadsheets” => “Miscellaneous” => “Applying Goal Seek”. “Tools” => “Options” => “Spreadsheet” => “View” (From Tamblyne:) Disable AutoInput : “Tools” => “Cell Contents” => uncheck “AutoInput” Disable capitalization of first letters in sentences “Tools” => “Autocorrect” => “Options” tab and uncheck "Capitalize first letter of every sentence" Position the cursor to the right of the last column that you want to stay visible (you can have more than one) and choose “Window” => “Freeze”. To remove it “Window” => “Freeze”. The same is possible with rows. There are a list of documents on the documentation project which explain how to do various useful things with Calc. And another very good list of FAQs here . There are also sites outside of OpenOffice : www.oodocs.org and ooextras.sourceforge.net . It is possible in Calc for the text to flow to the empty cells on the right hand side. However flowing to the left is not yet supported in Calc. Formats in each cell can be based upon defined conditions. This function can be accessed through the drop-down menus: Go to Format > Conditional Formatting... In the dialog box that appears, enter the conditions that determine the formats and the desired formats for each condition. If more help is needed to understand the settings, click the Help button in the dialog box, and a new help window opens with a description of all the fields shown in the dialog box. The help file also shows the path to a sample file that uses conditional formatting for reference. Again the documentation project has provided a document : “How to Format a Spreadsheet” . The documentation project has an excellent document here . Again the documentation project has provided a document : “How to set the Printing Settings” . Left-click on chart once to select chart Right-click for dropdown menu Select "Modify Data Range" Check "First column as label" Then either: fill in the $ column range for column A ( Make sure a ; seperates the two sets of ranges for A and B ) or Select the by marking column A with the mouse on the sheet. The A range now apprears in the X-axis scale. (From a Calc developer:) The chart currently cannot handle multiple X series, but there is a workaround. Place all X values in one column, and put the different Y series in the columns to the right, i.e.: 1 2 2 3 3 4 4 5 5 6 6 7 7 8 gives you a XY chart with 2 data series (first column used for X values). A new chart module is currently implemented. It will support independent X and Y values for each series. http://graphics.openoffice.org/chart/featurewishes.html
|
||||||||||||
The free and open productivity suite
- Search
-
Change Language
OpenOffice.org is available in many different languages. You might want to visit the webpages created by one of our many native language communities.
-
Log In
