Just a few quick spreadsheet tips.
Right-to-Left Orientation
I just noticed this. If you like your spreadsheet weighted on the right, you can make it that way.
Right-click on a tab and choose Sheet Right to Left.
The sheet will flop and the number headings of the rows, etc. will be on the right.
Moving or Copying Sheet Content Easily Between Spreadsheets
I also want to encourage everyone to consider using the Move/Copy feature to get content of one sheet to another document. It's quicker than copying and pasting, and preserves the formatting.
Right-click on the sheet you want to move or copy and choose Move/Copy Sheet.
In the window that appears, select an open spreadsheet (it needs to be open already) to add the sheet to, and specify where. Also, SELECT COPY IF YOU DON'T WANT TO MOVE IT. IF YOU DON'T WANT IT TO DISAPPEAR FROM WHERE IT CURRENTLY IS, SELECT COPY.
Click OK. In the spreadsheet that you moved or copied the sheet to, you'll see the sheet where you specified it should appear.
I don't have the right-to-left option. Is there any extension required?
Posted by: KJ | August 07, 2009 at 02:24 AM
I don't have the sheet right or left when clicking on the tab.
But
Posted by: johnH | August 10, 2009 at 03:04 PM
Only enable Complex Text Layout (CTL) in Tools - Settings - Language
Posted by: KAMI | August 18, 2009 at 12:16 AM
My version of OO.0 (3.1.0) does not have that path to CTL
My path is "Tools" > "Options" > "Language Settings" > "Languages" > "Complex Text Layout"
Posted by: johnH | August 22, 2009 at 07:45 AM