> 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.
>
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&dsMessageId=2640388
To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_tortoisesvn.tigris.org].
Received on 2010-07-29 20:56:22 CEST