Open Office : Some tricks

• Convert text to columns in Open Office:
• http://www.oooninja.com/2008/01/text-columns-calc-convert-openoffice.htm.
• lf you are inserting more than one row and the row has tab seperated columns , than Open office opens the "text import" window by default. You can select the seperator option to be "Fixed Width" and click on the scale at the top to determine the column length.

• How to copy formula result from cell:
• http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=5855&start=0

•  How to add a non-changing column to a formula
• http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=26752&start=0
• Add $ to a cell reference to make it absolute. ie Column D27 can be made absolute by =(D$27
• To insert spreadsheet or chart into presentation (Open Office Impress)
• Insert->Object ->OLE Objects -> Spreadsheet

• If slide panel is not docking back to its original position
• Click View, check Slide Panel so that you can view Slide Panel
• Hold down CTRL then double click on the gray area near the word "Slides" on the Slide Panel and it will dock itself in the right place

• Create graph from existing values

• Say you want Column A as X axis and Column B as y axis.
• Select the two columns and select "insert graph" option from the menu.
•  The  DATA RANGE will show:
• $Sheet1.$A$1:$B$101  replace that with
• $B1:$B$101   (the  start and end row number of Column B)
• Click next: On data series , insert the following in categories:
  $A$1:$A$101 (The start and end row number of Column A )