Page 1 of 1

Yellow Format for Columns/Row ... In SQUADS.XLS ?

Posted: Sun Sep 12, 2010 8:12 pm
by Merr
Pip,

I don't want to post this in tech support since it "may" be a 3rd party problem, but ever since v1.3.8 or 1.3.9 you're killing me when adding new units to the squads file :evil:

I'll explain ....

I've been using Microsft Works Spreadsheet since BA's release with no problem ... until v1.3.8 or 1.3.9 was released.
In one of those updates you added yellow formats (in the XLS) to some columns and rows, the main problem being the CY column (Elite_Sniper column).

If I "add" a new unit it removes that yellow format from the column ... no problem when saving to CSV.
But, if I later remove that unit it deletes that yellow format in the CY column (in the old units row) leaving a blank spot between the last unit and where the yellow format begins again ... When saving to CSV it crashes the game.
My solution was to simply add the yellow format back into that blank spot :D .

I can duplicate the problem over and over if you need a sample CSV to try out ... plus an error log.

Anyway, I figured it out but I thought I'd let you know. Again, it might just be MWS being the problem.

Rob


EDIT : .......... Perhaps it wasn't the 1.3.8 or 9 update ...but it was the last change to the SQUADS.XLS you did.

Posted: Mon Sep 13, 2010 10:03 am
by IainMcNeil
It seems like an issue with your editor. I'm not sure what we can do about it but you don;t need the yellow colouring. Work from the csv file rather than the xls if it helps. The xls just has extra data in it for us to help remind about various things.