Matrix Games Forums

Here's a link to the latest version of my Pacwar editor (version 23).

https://www.dropbox.com/s/gszmua0wj8g50 ... 3.xls?dl=0

Regards,

Rich

Many thanks for this version.

A minor issue:
Pressing F9 doesn't display the statistics for a/c in slot 99 (Ki-46-II, the one that you have added) in the top line.
Statistics for a/c in slot 98 (Ki-51) are displayed instead.

Thanks, Rich. It's neat having access to all of that information.

For those of us without Excel, I spent a few hours tweaking the macros so that they work with LibreOffice, and put it up here: http://many-words.com/pacific-war/pacwared23.ods

Note that the editing functionality is not likely to work, and will almost certainly corrupt saved games. There are issues with the way text is displayed, but it's sufficient for my purposes—that is, solely for inspecting the current state of the game.

Good catch Istfemer!

I've corrected the error and uploaded the new version. Here it is:

https://www.dropbox.com/s/e4mz9p0p39kqw ... 4.xls?dl=0

Regards,

Rich

Fishbreath,

Interesting... You've inspired me to download LibreOffice and take a look at your file. Maybe we can get a fully operational version of the editor for our brethren without Excel.

Regards,

Rich

It doesn't look like too much of a struggle. There are three major things I had to change:

- LibreOffice's Byte type is signed, so assigning a Byte value > 127 to a cell in a sheet fails with an error. There are a bunch of places where I do VarDataLong = CLng(VarData), then assign VarDataLong to the cell.
- LibreOffice calls subroutines differently (see File for examples).
- LibreOffice has no good way to read strings from binary files (it doesn't respect the length of the string, it just reads forever), so I added a function for that. It needs to ignore everything after null-terminators, but doesn't at the moment.

Here's a fully functional version of PacwarEd24 using LibreOffice Calc (open source). Enjoy!

https://www.dropbox.com/s/r5ep6510k9te7 ... 4.ods?dl=0

Data input for this version is a quite a bit slower than Excel (it takes my computer about 45 seconds to input), but output is fast.

Rich