Skip to content

Address issue #1563#1762

Merged
sjanzou merged 4 commits into
patchfrom
SAM_1563
Apr 19, 2024
Merged

Address issue #1563#1762
sjanzou merged 4 commits into
patchfrom
SAM_1563

Conversation

@sjanzou

@sjanzou sjanzou commented Apr 17, 2024

Copy link
Copy Markdown
Collaborator

Improved error handling when setting named range values in Excel workbooks with equations
image

To test, run the test file
PV_Batt_Com.zip

in the current release and receive the OLE errors
image

Build SAMOS with the patch branches of lk, wex, and ssc and the SAM_1563 branch of SAM and open and run the the file and "Send to Excel with equations" and receive no OLE errors and metrics that match between the Excel workbook with equations and SAM
image

@sjanzou sjanzou self-assigned this Apr 17, 2024
@sjanzou sjanzou requested review from brtietz and cpaulgilman April 17, 2024 09:45
@sjanzou sjanzou linked an issue Apr 17, 2024 that may be closed by this pull request

@cpaulgilman cpaulgilman left a comment

Copy link
Copy Markdown
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Looks good -- I'm not seeing OLE Automation errors for the PV Battery / Commercial config.

@sjanzou sjanzou merged commit cddf732 into patch Apr 19, 2024
@sjanzou sjanzou deleted the SAM_1563 branch April 19, 2024 06:54
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

OLE Automation Error in Range

2 participants