I am thinking about how to manage spreadsheets that contains formula in GitHub.
Then, I realized LibreOffice Flat XML ODT may be a good extension to save.
However, the creation date, mouse position, and other unnecessary metadata wastes my time in solving those conflicts.
Is there any setting to remove those metadata from files?
Thanks
Isn’t git there to handle the “diff”, or are you handling versions yourself.
.
The only setting I knew of, would be privacy settings, but I never checked, if that would also remove the date etc.
Calc can export values and formulas as csv.
Solving merge conflicts? That means several authors edit the same document at the same time? If you don’t need the settings you could pre-process the .fods file before commit to remove the <office:meta> element and <office:settings> element with all its children, like
xmlstarlet ed -L -d '/office:document/office:meta' -d '/office:document/office:settings' filename.fods
Where xmlstarlet is https://xmlstar.sourceforge.net/ and should be available in your Linux distribution.
1 Like