Originally Posted by bellator
But these are still all in the works, so don't pester :p If anyone can tell me how i make the spreadsheet open office friendly, will do so
|
It seems to be a two-fold problem. Firstly, OOo is not compatible with Excel's macro language at all, so things like the buttons and drop-downs don't function at all. Also, any fields that seem to reference hidden fields don't function. Things such as the totals for stats, the row with values for Blessing of Kings, etc, all give 502 errors (Invalid argument; Function argument is not valid, for example, a negative number for the root function.)
I'd help decipher the issues, but I have never actually worked with macros, and can't figure out what's going on in the hidden cells. Perhaps this will help anyone who's working on this.
--edit--
There are actually a few fields that do function in the top section for "Information". "Base Information" is static, so that obviously works, but strangely things like "Hit", "Crit", "Dam (S)", work.
Going through the steps on how things are totaled out, it seems to be that the calculations for trinkets is where the problem lies. IE: if I completely remove the "Strength" column for trinkets and the libram, the stat totals from gear comes out to an actual value with no error, and then the overall total works fine... until you factor in Divine Strength, which breaks it again. D: