git diff fatal exception

[vk3il]

git-xl has been working well for some time, but I've recently had it failing on my main excel project file. The error is as follows:

$ git diff
[21228] Failed to execute script diff
Traceback (most recent call last):
  File "diff.py", line 47, in <module>
  File "diff.py", line 12, in get_vba
  File "site-packages\oletools\olevba3.py", line 2793, in extract_all_macros
  File "site-packages\oletools\olevba3.py", line 2738, in extract_macros
  File "site-packages\oletools\olevba3.py", line 2749, in extract_macros
  File "site-packages\oletools\olevba3.py", line 1324, in _extract_vba
  File "site-packages\oletools\olevba3.py", line 1301, in check_value
oletools.olevba3.UnexpectedDataError: Unexpected value in VBA/dir for variable PROJECTLCID_Id: expected 0002 but found 004A!
fatal: external diff died, stopping at CDR compliance tool.xlsb

I tried creating a new excel workbook with a simple VBA macro and it too throws the same error. The environment is Microsoft® Excel® for Microsoft 365 MSO (16.0.14131.20278) 64-bit

Seems that the PROJECTLCID_Id value is wrong in the file, but Excel doesn't seem to mind and running a repair doesn't fix the problem. Has MS changed this value perhaps?

[fzumstein]

Hi @vk3il, thanks for reporting! this looks like an issue with https://github.com/decalage2/oletools. I'll try to find the time to upgrade to the latest version to see if that solves the issue.

[vk3il]

Thanks @fzumstein . Looking at that repository, it may in fact be a newly opened bug - see: decalage2/oletools#701
Maybe let them know of the downstream impact of it?

[alzec]

Hello,

Does anyone know if there is a temporary solution for this problem?

[caiocesart]

Hello,

Does anyone know if there is a temporary solution for this problem?

Hi, have you found any solution?

[dnsnx]

Same here. Would be interested in a solution to this issue.

[allezzy]

This could be related to an update in the VBA file format for version 11.0 where CompatVersionRecord was added:
https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-ovba/5abef063-3661-46dd-ba80-8cb507afdb1d

004A is the identifier for this new record.

[junxu94]

Hi, I am seeing the exact same issue, but not to see solution in this thread. Can someone provide the solution? Thanks so much!

[jspraul]

Update to newest version of oletools, update for python 3.10.4 #70

I think you have to clone and build the latest from this repository, as nothing has been released yet.

[fzumstein]

Yeah, to make a new release, I'd need to port the pipeline over to GitHub actions, and that takes a lot of time a nerves (that I currently a bit short of).

[winnieXY]

Any news on that? I'm hitting the same issue

[fzumstein]

this is now released with 0.5.1