Ask Lemmy
A Fediverse community for open-ended, thought provoking questions
Rules: (interactive)
1) Be nice and; have fun
Doxxing, trolling, sealioning, racism, and toxicity are not welcomed in AskLemmy. Remember what your mother said: if you can't say something nice, don't say anything at all. In addition, the site-wide Lemmy.world terms of service also apply here. Please familiarize yourself with them
2) All posts must end with a '?'
This is sort of like Jeopardy. Please phrase all post titles in the form of a proper question ending with ?
3) No spam
Please do not flood the community with nonsense. Actual suspected spammers will be banned on site. No astroturfing.
4) NSFW is okay, within reason
Just remember to tag posts with either a content warning or a [NSFW] tag. Overtly sexual posts are not allowed, please direct them to either [email protected] or [email protected].
NSFW comments should be restricted to posts tagged [NSFW].
5) This is not a support community.
It is not a place for 'how do I?', type questions.
If you have any questions regarding the site itself or would like to report a community, please direct them to Lemmy.world Support or email [email protected]. For other questions check our partnered communities list, or use the search function.
6) No US Politics.
Please don't post about current US Politics. If you need to do this, try [email protected] or [email protected]
Reminder: The terms of service apply here too.
Partnered Communities:
Logo design credit goes to: tubbadu
view the rest of the comments
This is probably a dumb question, and there's likely a very good reason why this can't be done, but can you not generate an Excel file from one of the other formats yourself? E.g. have the program output a CSV and write a python script that parses it into an excel file. That way you might have more control over the generated Excel and maybe be able to do it automatically.
Yep, export to CSV, format as desired, save in Excel format?
Might be annoying to format it but I would guess it is easier than having to change data?
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.
Maybe the output to managers needs to be Excel for some reason, e.g. there's some processing afterwards with another closed tool.
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.
Must be the export into an Excel file that breaks it. By that point, an alternative reader won't help.
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.