themachinestops @ themachinestops @lemmy.dbzer0.com Posts 0Comments 7Joined 2 mo. ago
The problem is that politicians don't understand cyber security, whta their asking is basically the equivalent of closing the front door of a house and leaving the backdoor open. It was already proven to be a bad idea, eternalblue is a good example.
But you use the same column correct? and the data that is messed up is the same type? Unless the data that is messed up is very hard to detect using a script, it should be possible.
I suggest making a script to fix it, rather than fix it manually. It is very easy to use, so basically program then export to excel then run officescript. Also don't tell anyone you made a script, tell them you are doing it manually.
https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel
There is many formats that excel uses, the issue is probably with XLSX format, my guess the problem will be solved by either using a different software or changing the format to csv. If Microsoft doesn't want to bother solving the problem. It is very hard to pinpoint the exact problem without seeing the program, but I will never do something like this manually, I will probably make a script to fix it.
I think you mean export to xls, also each program will have a different way for exporting. It might be that the way excel does it breaks it.
He can also use an alternative to excel like OpenOffice or libreoffice, I don't know why would they would use excel when it causes issues.
Paywalls can go to hell: https://archive.ph/EubRs