I have 1 cell sheet saved in 2 different file types; excel and ods file types. If I edit one can I have those edits apply to the other also?
I don’t know of a way to do that.
Usually you would keep a single document format and modify that one and then export it to another format when you need it in that format.
Is there a reason you need to maintain both formats? I don’t use LibreOffice anymore but when I did I kept all the documents in .xlsx format only.
After thinking about it I think it s sort of a dumb question. My work needs windows format cause they run windows, so the cell sheet I have needs to be in excell format. I also had already saved in ods format. I know “save as” is right there, and it s just a matter of doing it twice. I was just wondering if something like saving both formats at the same time was possible. Say I edit one, and the other format is automagically updated, and saved when I save the edited one…My guess is it would be a lot more trouble than it s worth.
I would just keep it in .xlsx. You don’t have to use ods unless you prefer it.
libreoffice on the command line has conversion tools in it, but I’m having some trouble getting that to work at the moment, which is why I hadn’t shared that earlier. Theoretically, you could use inotifywait to watch the file, and run a conversion command when it changes.
But, if this file you’re working on is to be readily available to Microsoft Office users, perhaps just stick to the format they’re familiar with.
Microsoft Office can open .ods files, but whether or not the folk you’re working with will be comfortable with that is 
When in Rome… etc
@sempterobit ,
If you want to convert all xlsx files modified in the last 24 hours to ods and the script is in that
directory:
find . -type f -newermt "-24 hours" -name "*.xlsx" -exec soffice --convert-to ods {} +