iPart gets modified when requesting its worksheet by Inventor API

[Anonymous]

Hello Community,

Recently I found some curious behavior while using Inventor API which, from my PoV, is a bug. For some actions I programmatically open iPart spreadsheet using iPartFactory.ExcelWorkSheet(), extract required data and close it without any modification. And despite there are no changes applied to a table, a part factory becomes dirty and its instances get “requires update” state in Inventor.

The issue appears only once per Inventor session: subsequent request-close operations from work fine. Also corresponding actions executed from user interface (open internal spreadsheet in Excel and close it) do not modify an iPart.

To reproduce the issue, open any iPart in new Inventor session and execute simple VBA code:
Set partDoc = ThisApplication.ActiveDocument
Set factory = partDoc.ComponentDefinition.iPartFactory
Set WB = factory.ExcelWorkSheet.Parent
Call WB.Close
After it, source part becomes dirty.

The issue is observed on Inventor 2016 to 2019 with Excel 2016.

Did anyone faced such a behavior? Is there any resolution for a problem?

Thanks in advance,
Paul

[bradeneuropeArthur]

use this instead:

Call wb.Close(False)

[Anonymous]

Arthur,

Unfortunately, your suggestion doesn't work. Even if we pass SaveChanges = False to Workbook.Close(), iPart still becomes Dirty.

Thanks,

Paul

[Anonymous]

Hello Community,

It's been a while since the last response which, unfortunately, is not helpful. Does anyone know how to report an issue to Autodesk related to API? Regular support accepts only issues with CAD application, but not with its Automation.

Thanks,

Paul