So after adjusting the min and max orbits only in those files the game CTD with a Json error. Nother other changes were made but it loads up fine with the orginal file put back in place or the original values. Any idea why this would be the case? Are you doing this with only the base game and no other mods like Nex? Apologies for the chain of questions, I'm loving the added difficulty of Nex plus lots of other factions over vanilla but I would love to increase the number of planets and colonization options for the factions significantly for even more challenge.
Hey sorry about missing the update to the thread.
I am doing this with a bunch of mods loaded in. Almost all of them. Too many to count.
Off the top of my head, one thing that could be happening is that the UTF settings are changed. Or in simpler terms, the format has changed. When openoffice opens an csv file, it will ask in what encoding it should open it up with. And it will do so with the selection box highlighted. A slight mouse wheel roll will change it, and while it shows everything in place, the application cannot read it, probably due to some header information it is expecting but not seeing.
Some things to clarify the situation: Have you tried just changing on value and seeing if it crashes? Or are you using the crashing file and swapping it with the original only?
Some other things that might be happening: Because it is a CSV file (comma-separated-file) the spreadsheet program you are using might be asking you (or not asking you) whether you want to save it as an excel file. This is obviously a big no-no. Changing file formats that applications read rarely ends well.
Another thing you can try is to open it up in a plain text file (like notepad) and compare your modified csv file to the original one to see if there are any notable changes.
Hope this helps. If all else fails, I could send you the csv file with the changes you need and see if that works.