I posted this on the hunter boards, but I'm sure it will get eaten, so I thought I'd post it here too. This is the band-aid that I use to get the spreadsheet to work in open office. I still can't get the sorting macros to work properly, but what I do is take the stat weights and plug them into
Loot Rank for WotLK to compile a BIS list. Here's what you need to do to make that work.
DISCLAIMER: This has only been tested with version 38d of the spreadsheet and OO 3.0
1) First, make sure that your OO is set to allow macros. Go to Tools > Options > Security > Macro Security. Set this to low or medium.
2) Now you need to monkey with the macros to get them to support OO basic. Go to Tools > Macros > Organize Macros > Openoffice.org basic. In this window select Hunter_DPS > Standard > Module1, then hit "Edit".
3) In the code window that should be up now, first go to Edit > Find/Replace, and enter "Rem" in the find field, nothing in the "replace with" field, and hit "replace all". This makes all the macro code active.
Now go to sheet 36 and put the "rem" back in the method name that now reads "Private Sub IncentTest_Click". It should be "Private Sub IncrementTest_Click".
4) Now you need to go through every module (the tabs at the bottom) and delete the top two lines as well as the bottom line. The top two should be "Attributes VBA...." and "Sub..." the bottom line should be "End Sub". Then, at the top of each tab, add the line
Option VBASupport 1
5) Go the the "Overview" sheet and unprotect it (Tools > Protect Document > Sheet)
6) Pull up the form controls toolbar (View > Toolbars > Form Controls)
7) Turn on design mode by clicking the button in the upper right-hand corner (a pencil and a ruler)
8) Click on the "CalcAttributes" button in the spreadsheet to select it
9) Right click the button and select "Control" from the dropdown menu
10) In this window, in the "Events" tab, click the ellipsis button next to the field that reads "Mouse Button Pressed"
11) Click "Macro" in the next window
12) The macro you want is under "Hunter_DPS > Standard > Sheet36 > Increment_Test_Click. Select this and click "OK". You can now close the other windows you opened
13) Click the pencil/ruler button in the upper right-hand corner of the Form Controls toolbar to turn design mode off. You may also close the toolbar.
14) Click the button, watch the spreadsheet do its magic, and take the stat weights to lootrank.com!
You can also get most of the other macros to work now that you've fixed the formatting on them, the names are pretty straightforward and it's easy to guess which ones go with which buttons, just use the same procedure outlined in steps 6-13. As I mentioned before, the sorting macros don't sort properly, and the import-export functions cause errors. If you're getting errors in the import-export functions, just comment out (a single apostrophe before the line) or delete the entire function so that the other macros in that module will run. If anyone knows of a simpler way to do steps 3 and 4 or if you think you can get the other functions working, I'd love to hear it.