[libreoffice-users] Flat XML ODF Spreadsheet (fods) and human-readable diff of content changes

Hi!

I was hoping that LibreOffice is able to maintain a spreadsheet
document in uncompressed XML which I can check-in to a version
control system. With this, I'd like to get a nice visualization of
*content changes*, e.g., by using the version control system
features. This is what I want to achieve.


Storing in uncompressed XML was easy via Flat XML ODF Spreadsheet
(fods). I converted a xlsx file to fods and committed it to a git
repository.

Then I changed once single cell in the fods and committed the
modified file as well.

Unfortunately, I got *many* changes:

    1 file changed, 297 insertions(+), 297 deletions(-)

«git show» shows typical lines like:

,----
| [...]
| -  <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">
| +  <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default">
| [...]
| -    <table:table-column table:style-name="co21" table:default-cell-style-name="ce11"/>
| +    <table:table-column table:style-name="co21" table:default-cell-style-name="ce18"/>
| [...]
`----

Therefore, the user-made changes are drowned within an ocean of
style-name changes whose purpose is not obvious to me as someone who
is not an expert in ODF format.

With ...

  git show HEAD|grep "^[\+-].*office:value="|grep -v "table:style-name="
    
... I was able to reduce the output lines to the content changes only.

1) How stable is this solution? I.e., is it possible that I exclude
content changes with this expression as well?

2) This git/grep method is not feasible for normal end-customers. Is
there a way to reduce or omit the style-name changes?

Thanks!

-- 
All in all, one of the most disturbing things today is the definitive
fact that the NSA, GCHQ, and many more government organizations are
massively terrorizing the freedom of us and the next generations.
                                                  http://Karl-Voit.at


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted