A  few  months  ago  I  suggested  to  some  people  who  were  planning
on  collaborating  on a  document  to  use Fossil  as  a  VCS for  their
document which they were planning  on writing in LibreOffice. After some
investigation I discovered  that LibreOffice has a  "flat" format called
FODT which  looked promising so  I thought  that it might  actually work
well.

After a  few commits, however, it  became apparent that there  were some
things  about LibreOffice  that made  managing  the file  with Fossil  a
nightmare, despite the fact that the  FODT format seemed to be ideal for
this.

The biggest challenges we discovered were:

1)  LibreOffice has  a  counter of  sorts called  Rsid  that is  updated
everytime the document is saved.

2) LibreOffice generates automatic styles for just about every paragraph
and sometimes  even every word  and character within the  paragraph that
change with  almost every paragraph  when you  alter text. This  is done
even if you think you have applied a specific style to something because
the automatic style  is actually linked to the original  style through a
parent-child relationship.

3) The rsid  is part of the automatic styles,  so everytime the document
is  changed dozens  of new  styles get  inserted automatically  into the
document. As a result, a one character change to a paragraph (e.g. for a
spelling correction) could actually end  up being committed to Fossil as
a 500 line change. Completely useless and unmanageable.

These  things,  among  others,  result  in  automatic  styles  that  are
identical in "function" but have  entirely different names and different
rsids. After  just a few commits  there were over 300  of such automatic
styles  that  were  in  the   document  making  comparing  revisions  an
impossible task because even though two paragraphs visually had the same
style, in  the actual source of  the document they had  a different name
and rsid.

What we  found, however, is  that it is possible  to avoid all  of these
behaviors by very careful and deliberate use of user-defined styles. For
example, rather than highlighting a word  in a paragraph and changing it
to an italic font, one should instead apply a predefined character style
to the word.

Similarly, instead  of highlighting  a paragraph  and changing  the font
size or font name to something, one should simply click on the paragraph
and change the style using user-defined styles.

In other words, one should have explicit styles and always be deliberate
in  assigning styles  to words,  paragraphs and  characters. If  a style
doesn't exist for some text effect  that is desired, create it first and
then assign it to the text in question.

Finally,  it is  possible  to  disable the  Rsid  which also  eliminates
another source  of noise  in the  diff between  commits. The  setting is
called  "Store it  when changing  the  document" and  disabling it  will
prevent LibreOffice from saving this with the document.

It even works  with images because images are placed  in the document as
base64 encoded  blobs. This is  not really ideal because  compression is
likely not going to be as good  as it could be, but some sacrifices have
to  be made  to have  a  useful history  that management  in Fossil  can
provide.

Before every commit, it is necessary to run "fossil diff" or use the new
"fossil ui" to look at the diff  and verify that no new automatic styles
have been  introduced. If any  are found, then  it's easy to  track them
down in  the document and highlight  the text and use  the "Clear direct
formatting" option to reset it to  the user-defined style and then apply
a proper style if necessary. Continue doing this until the diff shows no
new automatic styles and then commit.

After all of this, I'm going to  consider this a success because as long
as one is careful about not  letting LibreOffice run away with automatic
styles, Fossil can actually be quite  useful to compare revisions of the
document.

I'm  sure I've  left something  out, but  I thought  I would  share this
experience  just  in  case  someone  else gets  the  notion  to  combine
LibreOffice FODT documents with Fossil revision management.

Andy