Assumptions!A1 100 -> 105
and Projections!A1 1500 -> 1575
.git diff
or query the Git log to answer many of your questions. Git also encourages a much more expressive account of how and why things have changed through commit messages. This ensures that your work is reproducible and auditable. Future you will be grateful. Plus, Git is fun. It saves you time (in the long run) and helps you manage risk, so you can relax a bit while you work with Microsoft Office files that change in unexpected ways.git diff
on binaries because, they are right, you should probably avoid including binaries in your repos if you can.diff
tool, Git will crack open the binary with ExcelCompare. This is much better than the default message:git diff
. Git looks in .gitattributes for rules to apply its configuration, and you need to tell it to use the “excel” method on files with xls, xlsx and xlsm file extensions. Then in .git/config, tell Git what the “excel” method is.config
with your text editor and add the following command to execute ExcelCompare as the “excel” method for git diff
.git diff
after saving it. This is incredibly useful when you have lots of tabs and you are not sure how they all relate, and many other excel comparison tools force you to manually save different versions of the same file which increases the risk that the wrong version gets used or changes get lost in the mix. Now, you can work on the same file and commit your changes. Fun, right? Wrong. ExcelCompare slows down your git diff
calls, so I am not completely sold. If someone knows of a faster tool, please comment!git diff
on docx will tell you that an entire line has changed but leave it to you to figure out which words differ. When tracking your writing/edits, it would be nice to track changes at a more granular level. The markdown versions of docx will help you zero in on specific words and highlight them with a custom diff.git wdiff mydoc.docx
, and you will see additions in green and deletions in red on a word-by-word basis. You can also look at the full history of a file with git log -p --word-diff=color mydoc.docx
.pip install python-pptx
.wdiff
you created earlier. Try out git wdiff MyPres.pptx
to see what has been added or deleted from a presentation.