On Fri, Jul 30, 2010 at 10:45, Allen <oldracingcars_at_gmail.com> wrote:
> But the curious thing here is that I haven't opened any of these
> files, I have merely zipped the folder, copied it to a new PC and
> unzipped. (OK, it wasn't ZIP, it was right-click and 'Send to
> Compressed folder' but that's just Microsoft-speak for ZIP isn't it?).
>
> Of five Excel files in one folder, four are fine and only one is
> 'dirty' (is that Tortoise-speak for having a red pling next to it?).
> The ok files are dated 2005, 2008, 2009, 2010 and 2010; the dirty file
> is dated 2007. I am completely sure I haven't opened that files since
> 2007 as it's something completely uninteresting to do with that year's
> tax return,
>
> In another folder which contains old invoices, about 75% are dirty and
> the rest are fine but there seems no rhyme or reason to it. No
> correlation by date and as all those invoices have the same format, it
> can't be down to the spreadsheet layout. Even more curiously, I
> spotted a handful of PDFs with the same problem.
>
> If I copy the file away somewhere and do a SVN update, I get a clean
> file but now with today's date which is less than ideal. If I copy
> the file back, it's dirty again so you would think that the zip/move/
> unzip process must have done something to that file. BUT, if I take
> the file directly from my old PC and drag it to the folder on the new
> PC, it's dirty again. So it can't be the file - unless Windows 7
> modifies the file as I drag and drop it - so it must be what it's
> comparing the file against. But wouldn't the update have reset that?
> I am out of my depth here!
>
Please don't top-post - it makes it harder to follow the conversation.
At this point, I would recommend that you do what I did below -
perform the tests you did above, and at each stage perform an md5sum
(or any other checksum algorithm) against the files. This will tell
you for certain if the files are getting modified by those actions. Do
it outside of a working copy to totally remove Tortoise from the
equation.
MD5 utilities for Windows: http://www.google.com/search?q=md5sum+windows
>
> On Jul 29, 7:56 pm, Bob Archer <Bob.Arc..._at_amsi.com> wrote:
>> > On Thu, Jul 29, 2010 at 14:28, Bob Archer <Bob.Arc..._at_amsi.com>
>> > wrote:
>> > >> On Thu, Jul 29, 2010 at 13:05, Allen <oldracingc..._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.
>>
>> Yes, it is saved in the file. I did the following test...
>>
>> 1. Create a new spreadsheet.
>> 2. Turn of AutoCalculate
>> 3. Save it
>> 4. Add to svn
>> 5. Commit
>>
>> 6. Reopen spread sheet.
>> 7. Close Excel
>>
>> After step 7 tsvn did not show a dirty icon. I also did a Check for modifications (svn st) and it showed no modified files.
>>
>> Of course, to chagne this setting in everyspread sheet would be a bit of a pain. Also, most people are used to autocacluate being on.
>>
>> I just did another test...
>>
>> 8. Open spread sheet
>> 9. Turn autocalculation on
>> 10. Save
>> 11. Close excel
>> 12. Commit change
>> 13. Open in Excel
>> 14. Close excel
>>
>> Still showing no change to the file. I am using Excel 2007 so it may be different than 2003.
>>
>> BOb
>>
>> ------------------------------------------------------http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=4061&dsMess...
>>
>> To unsubscribe from this discussion, e-mail: [users-unsubscr..._at_tortoisesvn.tigris.org].
>
> ------------------------------------------------------
> http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=4061&dsMessageId=2640712
>
> To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_tortoisesvn.tigris.org].
>
------------------------------------------------------
http://tortoisesvn.tigris.org/ds/viewMessage.do?dsForumId=4061&dsMessageId=2640717
To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_tortoisesvn.tigris.org].
Received on 2010-07-30 17:17:34 CEST