On Thu, Jul 29, 2010 at 14:28, Bob Archer <Bob.Archer_at_amsi.com> wrote:
>> On Thu, Jul 29, 2010 at 13:05, Allen <oldracingcars_at_gmail.com>
>> wrote:
>> > I've recently updated from a Windows XP PC to a Windows 7 machine
>> and
>> > moved across several repos.
>> >
>> > When I do a commit, all (or the vast majority anyway) of the
>> Excel
>> > (.xls XLS) spreadsheets are listed as having changed. And a few
>> PDFs
>> > too. I have checked the last updated dates on the files and some
>> > haven't changed for years but for some reason SVN is seeing a
>> > difference.
>> >
>> > Does anyone know what might be causing this?
>>
>> It's Excel. Open any Excel file, then close it. Don't change
>> anything,
>> don't click Save, just open it and close it. Excel changes
>> something
>> in the file & doesn't tell you about it. You can't always trust a
>> Last
>> Modified date - they're easily manipulated.
>>
>> I just opened Excel & created a spreadsheet with a value in cell
>> A1.
>> Then I quit Excel, opened the file, then quit Excel. MD5 checksum
>> confirms - Excel changed the file and I didn't do a thing.
>>
>> C:\>c:\_apps\tools\unxutil\md5sum Book1.xls
>> 5b2fa69b9322179bdeae0f2e1525b846 *Book1.xls
>>
>> C:\>c:\_apps\tools\unxutil\md5sum Book1.xls
>> 482db9d75a2a384ef248fc69b3072755 *Book1.xls
>>
>
> I wonder if turning of AutoCalculation would stop this from happening. I know in word there is also a setting where it saves your last printed date to the file so everytime you print a doc the file is updated. I usually turn this off too.
No such luck, Bob. I just set the Excel file I created for my test to
Manual, and unchecked "Recalculate before save", and the MD5sum still
changes on a simple open/close.
I assume you're talking about Tools -> Options -> Calculation in Excel
2003 here. Interestingly, despite this appearing to be a program
option (due to where the setting is located), this seems to be stored
in the file itself. But I may be testing poorly there.
------------------------------------------------------
http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=4061&dsMessageId=2640384
To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_tortoisesvn.tigris.org].
Received on 2010-07-29 20:47:42 CEST