Skarn wrote:I have a question in a similar vein; apologies for the hijack.![]()
I'm using an older version of Excel that can't handle the depth of function calls in the SSF spreadsheet.
I do, however, also have OpenOffice which can open the spreadsheet (it takes about 10 minutes to convert), so I was wondering if anybody has had success with using it that way? I'm a bit hesitant to go in blind, since my old 2E universe generator (Excel v4 vintage) did NOT work well when I tried to let OpenOffice convert it several years ago.
Hijack reply!
There are generally two issues (in my experience) with porting it over to OO or Libre or the like:
1) There is (or at least there was) a formatting issue with the Vlookup statements. Excel is a bit more forgiving, allowing spaces/not allowing spaces (one or the other) whereas OO/Libre requires them. This causes some of the Vlookups to break, but it's strictly a formatting issue. Once that's fixed it's OO happy.
2) The "custom macros" with the exception of the New Turn button, are all really just replacements for older excel code that was a pain to write and maintain, but were otherwise all doable in the formula bar. I can't remember where these all were located, but at the least there's one in the planetary GPV calculator and one for research. These would need to get rewritten to not be excel macros, but it IS doable.