Problem to edit Efx

[lennis29]

Hi PzKrps Community

For some time now there has been a problem with the [ Efx.pzdat ] files, I always edit it with Microsoft Excel, but it does it with versions 2007, 2010, 2016, I don't understand what is happening.
- Has anyone been through this?
- How can I solve it?

-

[eskuche]

Do you have conditional formatting randomly toggled on
?

[eskuche]

Do you have conditional formatting randomly toggled on
?

[lennis29]

Do you have conditional formatting randomly toggled on
?

Check that option and I see everything normal, you can send me a spintscreen to better locate me on the options you mention.
thank you

[cw58]

I don't use Excel but this is what the parameters look like in OpenOffice; maybe the 2 programs have similar settings.

efx.jpg (103.34 KiB) Viewed 635 times

[Locarnus]

I don't use Excel but this is what the parameters look like in OpenOffice; maybe the 2 programs have similar settings.

I'm not sure anymore, but I think it was the other text delimiter (the singlequote instead of the doublequote). Otherwise the values were offset in the unit details window (Alt + LeftClick on unit).

Using Libre Office (probably same for OpenOffice), you have to go "File/Save As" and then make a checkmark for "Edit filter settings" when saving the .csv. In the small window that opens up, select
Character set: Unicode UTF-16
Field delimiter: {Tab}
String delimiter: '
And checkmark "Save cell content as shown"

After saving it as .csv, rename to .pzeqp or whatever Tab delimited file yor are editing.


If you are more familiar with the files, I suggest using Notepad++ with ElasticTabstops plugin instead.
No option to freeze rows and columns, but much faster saving and editing.
And with the right font settings, nearly the whole width of the equipment file fits onto a 1920 resolution. (Also might require renaming the columns, see the equipment file in my PzC addon: https://www.slitherine.com/forum/viewtopic.php?t=106547)

[lennis29]

Thanks for your input, I'll be testing.