Fun with xml extraction

Rwn said:
Does anything happen when you change the animal in the drop-down list? (cell with UNIT_EMU in my screenshot)
Click to expand...

I get a spread sheed. The drop down box does not do anything. BtW I have never used macros or anything beyond the simplest bits of spread sheets.
 
Dancing Hoskuld said:
I get a spread sheed. The drop down box does not do anything. BtW I have never used macros or anything beyond the simplest bits of spread sheets.
Click to expand...

There's no macro, just formulas, conditional formatting to color some cells and a picture pasted over some cells. I've tried saving it in a earlier format of Excel (attached) in case it could help.

I'm not at all familiar with LibreOffice, but do you at least have a screen similar to the one in the screenshot, with the latitude/longitude, the world map and a blue area? What happens if you manually change the name of the unit or the MinLatitude/etc. just below?
 

Attachments

  • Rwn's Spawn Map old.rar
    38.6 KB · Views: 30
Dancing Hoskuld said:
The old works a bit better in that it changes the info but nothing is displayed on the map.
Click to expand...

The map is a picture pasted over the cells, try to either delete the picture (you'll lose the precise coastline, but you'll still get the general location) or set "white" in the picture to "transparent" (there's an excel function to do that, no idea in LibreOffice). Tell me if the cells aren't colored even without the map.
 
Dancing Hoskuld said:
The first one works now. It required me to turn on Java which I did but it did not tell me I had to exit and start again:crazyeye:
Click to expand...

That's a bit odd, I did not use Java... I guess LibreOffice uses it to make things like drop-down menus or conditional formatting work, then. Well, glad it works now.
 
Very interesting thread, I have Excel 2013 and going to be analyzing some of this data
 
You must log in or register to reply here.

Similar threads

A
  • Sticky
Modding Guide for VP 4.0+ (COMPLETE, v1.0)
Replies
5
Views
3K
mofab16084
M
D
Civ2 MGE several fixes and additions with support for music tracks
2
Replies
31
Views
1K
duplj
D
Recursive
New Version - 4.6.1 (April 14, 2024)
3 4 5
Replies
86
Views
9K
Better Buff Turtle ship
Better Buff Turtle ship
Meteor Man
Using chatGPT to mod Civ3
2 3
Replies
44
Views
5K
Ozymandias
Ozymandias
W
[Civ2] Help with Civ 2 finances
Replies
4
Views
1K
kdsteff
K
Top Bottom