Problem with SPREADSHEETCOMPARE

Hello,

I have added following file to the system PATH:

C:\Program Files (x86)\Microsoft Office\Office15\DCF\SPREADSHEETCOMPARE.EXE 

When I attempt to run the tool from command line:

SPREADSHEETCOMPARE book1.xls book2.xls

or

SPREADSHEETCOMPARE book1.xlsx book2.xlsx

The tool crashes with following information (in Polish:

Podpis problemu:
  Nazwa zdarzenia problemu: CLR20r3
  Podpis problemu: 01: spreadsheetcompare.exe
  Podpis problemu: 02: 5.5.0.5
  Podpis problemu: 03: 531f7e59
  Podpis problemu: 04: mscorlib
  Podpis problemu: 05: 4.0.30319.18408
  Podpis problemu: 06: 52310b91
  Podpis problemu: 07: 46b9
  Podpis problemu: 08: 26
  Podpis problemu: 09: System.ArgumentException
  Wersja systemu operacyjnego: 6.1.7601.2.1.0.256.48
  Identyfikator ustawie regionalnych: 1045
  Dodatkowe informacje 1: 0a9e
  Dodatkowe informacje 2: 0a9e372d3b4ad19135b953a78882e789
  Dodatkowe informacje 3: 0a9e
  Dodatkowe informacje 4: 0a9e372d3b4ad19135b953a78882e789

Have anybody managed to execute the tool from the command line with two files as parameters?

**IMPORTANT NOTICE**

If the tool is executed from the command line, it **permanently removes** the first file that is subject for the comparison! 

Use dummy files if you want to reproduce the problem.


Thanks,

Kamil


  • Edited by Kamil Niklasiski Thursday, May 22, 2014 8:38 AM Added important notice.
May 22nd, 2014 8:30am

Hi,

You can try disabling the antivirus program temporarily to check if it's related.

In addition, what is your OS? You may not have installed the Microsoft .NET Framework, install Microsoft .NET Framework or update it to the latest to check the result.

Regards,

Melon Chen
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2014 8:02am

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Thanks,

Melon Chen

Forum Support

May 26th, 2014 2:48am

Hi,

I'm marking the reply as answer as there has been no update for a couple of days.

If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks,

Melon Chen

Forum Support

Free Windows Admin Tool Kit Click here and download it now
May 29th, 2014 2:56am

Hello,

thank you for your response!

I have installed .net 4.5.1.

I cannot disable anti-virus software (MS Endpoint Protect) as I'm not allowed (I do not have enough privileges). I would assume the tool should work with MS product (Endpoint). 

Is it possible to submit this problem to Microsoft for further investigation?

Best regards,

Kamil

June 2nd, 2014 12:50pm

Hi,

Before we take further actions, we can try to perform a clean boot to determine whether background programs are interfering with this:

http://support.microsoft.com/kb/929135

Test if this can be reproduced in clean boot, which is always an efficient way in this kind of issue.

Thanks,

Melon Chen

Forum Support

Free Windows Admin Tool Kit Click here and download it now
June 5th, 2014 1:25am

Thank you for your answer.

Unfortunately clean boot does not help.

If you have any other hints, there are welcomed. Have you tried to reproduce this on your machine? Do you have same problem?

Thanks,
Kamil

June 5th, 2014 10:52am

Hi,

I tried on my machine but didn't reproduce this issue.

This tool seems to come along with Office suite, please try repairing Office from Control Panel -> Programs and Features, test if this fixes the problem.

Thanks,

Melon Chen

Forum Support

Free Windows Admin Tool Kit Click here and download it now
June 6th, 2014 2:52am

Hi,

I understand that you have managed to run spreadsheetcompare.exe with two parameters? E.g.

spreadsheetcompare Book1.xlsx Book2.xlsx ?

I  have repaired Office 2013, but this have not helped.

Do you have any other ideas? I'll see if my colleagues are running with same problem, to verify if this is isolated problem to my machine or not.

Regards,
Kamil

June 6th, 2014 12:43pm

Hi,

When I ran it with two parameters, I did reproduce this problem. This is a quick note to let you know that we are performing research on this issue.

Thanks,

Melon Chen

Forum Support

Free Windows Admin Tool Kit Click here and download it now
June 9th, 2014 2:12am

Thank you for the note.

Hopefully this issue can be easily resolved - we plan to use this feature in our version control system.

Regards,
Kamil

June 9th, 2014 6:51am

Hi Kamil,

Please update Office and Windows to the latest update.

Is any Excel file opened when you are trying to compare through the command? What is the OS on the machine?
What is the event describing in the Application event logs with event 1000 for the crash as the faulting module.

Try uninstalling the Add In completely and reinstall it again. Test if that helps

Regards,
Rohit.

Free Windows Admin Tool Kit Click here and download it now
June 9th, 2014 3:41pm

Also please let me know the Office and Windows version installed.
June 9th, 2014 3:46pm

Hi Kamil,

Please update Office and Windows to the latest update.

KN> I always install the newest Windows and Office updates

Is any Excel file opened when you are trying to compare through the command?

KN> I have tested this with opened and not opened other excel files.

What is the OS on the machine?

KN> Windows 7 Professional (PL). SP1.

What is the event describing in the Application event logs with event 1000 for the crash as the faulting module.

KN> Below you can find text copy of all error events I found. I can provide you one additional error file [C:\Users\kniklasinski\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppCrash_spreadsheetcompa_d0b0ddbc4c5757187c39015404434d9e8cbaa91_226ce7c3\Report.wer], but it is binary file and I'm not sure how I can attach it to this post. 

Nazwa dziennika:Application
rdo:        .NET Runtime
Data:          2014-06-10 12:51:25
Identyfikator zdarzenia:1026
Kategoria zadania:Brak
Poziom:        Bdy
Sowa kluczowe:Klasyczny
Uytkownik:    Nie dotyczy
Komputer:      LTPL003734.bravurasolutions.local
Opis:
Application: SPREADSHEETCOMPARE.EXE
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.ArgumentException
Stack:
   at System.IO.Path.CheckInvalidPathChars(System.String, Boolean)
   at System.IO.Path.GetFileName(System.String)
   at ProdianceExcelCompare.Form1.StatusReady()
   at ProdianceExcelCompare.Form1.Init()
   at ProdianceExcelCompare.Form1..ctor(System.String)
   at ProdianceExcelCompare.Program.Main(System.String[])

Kod XML zdarzenia:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name=".NET Runtime" />
    <EventID Qualifiers="0">1026</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-06-10T10:51:25.000000000Z" />
    <EventRecordID>97856</EventRecordID>
    <Channel>Application</Channel>
    <Computer>LTPL003734.bravurasolutions.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Application: SPREADSHEETCOMPARE.EXE
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.ArgumentException
Stack:
   at System.IO.Path.CheckInvalidPathChars(System.String, Boolean)
   at System.IO.Path.GetFileName(System.String)
   at ProdianceExcelCompare.Form1.StatusReady()
   at ProdianceExcelCompare.Form1.Init()
   at ProdianceExcelCompare.Form1..ctor(System.String)
   at ProdianceExcelCompare.Program.Main(System.String[])
</Data>
  </EventData>
</Event>

Nazwa dziennika:Application
rdo:        Application Error
Data:          2014-06-10 12:51:27
Identyfikator zdarzenia:1000
Kategoria zadania:(100)
Poziom:        Bdy
Sowa kluczowe:Klasyczny
Uytkownik:    Nie dotyczy
Komputer:      LTPL003734.bravurasolutions.local
Opis:
Nazwa aplikacji powodujcej bd: SPREADSHEETCOMPARE.EXE, wersja: 5.5.0.5, sygnatura czasowa: 0x531f7e59
Nazwa moduu powodujcego bd: KERNELBASE.dll, wersja: 6.1.7601.18409, sygnatura czasowa: 0x53159a86
Kod wyjtku: 0xe0434352
Przesunicie bdu: 0x0000c42d
Identyfikator procesu powodujcego bd: 0x1b50
Godzina uruchomienia aplikacji powodujcej bd: 0x01cf8499ec30214b
cieka aplikacji powodujcej bd: C:\Program Files (x86)\Microsoft Office\Office15\DCF\SPREADSHEETCOMPARE.EXE
cieka moduu powodujcego bd: C:\Windows\syswow64\KERNELBASE.dll
Identyfikator raportu: 2b9ede2b-f08d-11e3-a75a-005056c00008
Kod XML zdarzenia:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Application Error" />
    <EventID Qualifiers="0">1000</EventID>
    <Level>2</Level>
    <Task>100</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-06-10T10:51:27.000000000Z" />
    <EventRecordID>97857</EventRecordID>
    <Channel>Application</Channel>
    <Computer>LTPL003734.bravurasolutions.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>SPREADSHEETCOMPARE.EXE</Data>
    <Data>5.5.0.5</Data>
    <Data>531f7e59</Data>
    <Data>KERNELBASE.dll</Data>
    <Data>6.1.7601.18409</Data>
    <Data>53159a86</Data>
    <Data>e0434352</Data>
    <Data>0000c42d</Data>
    <Data>1b50</Data>
    <Data>01cf8499ec30214b</Data>
    <Data>C:\Program Files (x86)\Microsoft Office\Office15\DCF\SPREADSHEETCOMPARE.EXE</Data>
    <Data>C:\Windows\syswow64\KERNELBASE.dll</Data>
    <Data>2b9ede2b-f08d-11e3-a75a-005056c00008</Data>
  </EventData>
</Event>

Nazwa dziennika:Application
rdo:        Windows Error Reporting
Data:          2014-06-10 12:51:30
Identyfikator zdarzenia:1001
Kategoria zadania:Brak
Poziom:        Informacje
Sowa kluczowe:Klasyczny
Uytkownik:    Nie dotyczy
Komputer:      LTPL003734.bravurasolutions.local
Opis:
Pakiet bdw 35762240, typ 22
Nazwa zdarzenia: CLR20r3
Odpowied: Niedostpny
Identyfikator pliku Cab: 0

Sygnatura problemu:
P1: spreadsheetcompare.exe
P2: 5.5.0.5
P3: 531f7e59
P4: mscorlib
P5: 4.0.30319.18444
P6: 52717edc
P7: 46b9
P8: 26
P9: System.ArgumentException
P10:

Doczone pliki:
C:\Users\kniklasinski\AppData\Local\Temp\WERE3AE.tmp.WERInternalMetadata.xml

Te pliki mog by dostpne tutaj:
C:\Users\kniklasinski\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppCrash_spreadsheetcompa_d0b0ddbc4c5757187c39015404434d9e8cbaa91_226ce7c3

Symbol analizy:
Ponowne sprawdzanie rozwizania: 0
Identyfikator raportu: 2b9ede2b-f08d-11e3-a75a-005056c00008
Stan raportu: 0
Kod XML zdarzenia:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Windows Error Reporting" />
    <EventID Qualifiers="0">1001</EventID>
    <Level>4</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-06-10T10:51:30.000000000Z" />
    <EventRecordID>97858</EventRecordID>
    <Channel>Application</Channel>
    <Computer>LTPL003734.bravurasolutions.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>35762240</Data>
    <Data>22</Data>
    <Data>CLR20r3</Data>
    <Data>Niedostpny</Data>
    <Data>0</Data>
    <Data>spreadsheetcompare.exe</Data>
    <Data>5.5.0.5</Data>
    <Data>531f7e59</Data>
    <Data>mscorlib</Data>
    <Data>4.0.30319.18444</Data>
    <Data>52717edc</Data>
    <Data>46b9</Data>
    <Data>26</Data>
    <Data>System.ArgumentException</Data>
    <Data>
    </Data>
    <Data>
C:\Users\kniklasinski\AppData\Local\Temp\WERE3AE.tmp.WERInternalMetadata.xml</Data>
    <Data>C:\Users\kniklasinski\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppCrash_spreadsheetcompa_d0b0ddbc4c5757187c39015404434d9e8cbaa91_226ce7c3</Data>
    <Data>
    </Data>
    <Data>0</Data>
    <Data>2b9ede2b-f08d-11e3-a75a-005056c00008</Data>
    <Data>0</Data>
  </EventData>
</Event>

Try uninstalling the Add In completely and reinstall it again. Test if that helps

KN> Can you please advise how to uninstall the add-in and install it again? I have not found such functionality.

Free Windows Admin Tool Kit Click here and download it now
June 10th, 2014 10:56am

I have provided Windows version in previous post.

Excel version is provided in the screenshot (I hope this is sufficient)

June 10th, 2014 11:02am

Hi Kamil,

Thanks for the detailed post!

As the logs suggest it is not Excel that is crashing but SPREADSHEETCOMPARE.EXE and the module that has caused it to crash was KERNELBASE.dll.
The exception code
0xe0434352 is a general one and points to issue with CLR.

Try adding an exception to this utility in DEP. For this -
Click Start -> Right click Computer -> Properties -> Advanced System setting on the left pane -> On Advanced tab -> click Settings under Performance -> Data Execution Prevention tab -> select 'Turn On DEP for all programs and services except those I select -> click Add -> browse for SPREADSHEETCOMPARE.EXE -> OK.
This will require you to restart the computer.

Also check if you and other components have got rights on SPREADSHEETCOMPARE.EXE. add yourself to full control as well other system components.

If this does not help I will advise you to open a ticket with Microsoft so that a dedicated technician can help you with this issue.

Regards,
Rohit.


Free Windows Admin Tool Kit Click here and download it now
June 10th, 2014 1:26pm

Rohit,

sorry for late response.

Have you managed to add SPREADSHEETCOMPARE.EXE to DEP exclusions?

In my case, I have received a warning: 'This program must work with enabled DEP function. It is not possible to disable DEP for this type of program.'

I tried to run the tool from local admin account that has all necessary privileges and same problem appears.

Cheers,
Kamil

June 12th, 2014 12:46pm

Hi,

we have the same problem.

I tested it on Windows8 x64 client with Office 2013 installed as local admin and without local admin.

If you have a solution this would be fine ...

Is it possible if this works to stdout the results in a file like result.log or something else ?

Regards,

Christian


Free Windows Admin Tool Kit Click here and download it now
June 12th, 2014 2:20pm

Christian,

it seems there is workaround that solves partly the issue. Please check related StackOverflow post.

Many thanks to Julien who pointed this out!

I'm not sure if stdout / result.log is supported by this tool (I guess probably not).

Best regards,
Kamil

June 24th, 2014 9:17am

I wrote simple batch script under GNU licence here: https://github.com/kniklas/excomp

It allows to execute comparison of two files from a command line.


Free Windows Admin Tool Kit Click here and download it now
June 24th, 2014 10:22am

I wrote simple batch script under GNU licence here: https://github.com/kniklas/excomp

It allows to execute comparison of two files from a command line.


June 24th, 2014 10:22am

Using the batch script as you propose is the only way I could configure Spreasdsheetcompare as a compare tool in TFS.
Free Windows Admin Tool Kit Click here and download it now
April 2nd, 2015 12:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics