Page 1 of 1
Excel xlsx files not compaing
Posted: Wed May 24, 2017 8:30 am
by rossburnett
Just recently with ED 8.0, and now with 9.0, I get an error message saying that these are different binary files when comparing spreadsheets (see attachment). This started happening this month after having no problems before. There's no problem if I manually save each to a csv version, but the plugin was able to do that until recently.
Re: Excel xlsx files not compaing
Posted: Wed May 24, 2017 8:35 am
by psguru
Please make sure that your XLSX plug-in (OOXML to Text) is enabled under Options | Plugins.
Re: Excel xlsx files not compaing
Posted: Wed May 24, 2017 9:22 am
by rossburnett
Thanks for the quick reply.
The OOXML option was checked.
I just found out that this behavior also results from .docx-docx and .doc-doc file comparisons.
This makes no sense as it was working fine with 8.0 until recently. I can't think of any changes I would have made to the Options other than the text compare panel to mask columns or similar changes.
Re: Excel xlsx files not compaing
Posted: Wed May 24, 2017 9:23 am
by psguru
Could you attach a screenshot of your plugin options?
Re: Excel xlsx files not compaing
Posted: Wed May 24, 2017 10:18 am
by rossburnett
I was about to send you a screenshot when I noticed that the "Use plugins..." was unchecked.
No idea how that happened. Sorry for the confusion and thanks for the help.
Re: Excel xlsx files not compaing
Posted: Wed May 24, 2017 10:23 am
by psguru
This is what I was hoping for
