- Why does the formatting change when I file share between Open Office and Microsoft Office?
- How to create different headers within the same document in OO
- What are the shortcut key for OpenOffice and Word?
- Opening a CSV/TXT (Vision) file in Calc
- How do I create superscript/subscript text?
- How to get gridlines to print in Openoffice Calc?
Open Office
For the most part, transitioning between OO and Office is pretty straight forward. The most important part of sharing files is communication. If you know what you are trying to achieve and how each person is formatting their documents, you can avoid stress down the road. Some issues are unavoidable because once you get into the more complex formatting is when you will find more issues but with a little preparation on both the OO and Office end before sharing can alleviate headaches.
Knowing the outcome is half the battle:
Summary: Create a unique page style for each header and add them by adding page breaks.
| Short Cut Keys | Effect | |
| OO | MS | |
| Ctrl+A | Ctrl+A |
Select All |
- Open Calc file
- Choose File>Open
- In the "Files of Type" drop down menu, chhose TextCSV(*.csv;*.txt)
- Choose the coorect file and press "Open"
- You'll get a window that will have you specify the delimiters (which is usually commas). There are also options to format the data as you want it to show up.
- When you are done press "Ok" and the data will be present as a spreadsheet and can now be saved as such.
Select the text that you want to change:
For Superscript: CTRL+SHIFT+P
For SubscriptL CTRL+SHIFT+B
With the document open, go to Format>Page...>"Sheet" tab> and choose the printing options that you want to appear under the Printing heading. Be sure to click "Ok" once you have made your selection.