search

microsoft / python-in-excel

Python in Microsoft Excel
MIT License
490 stars 31 forks source link

Potential infinite loop bug with lists #17

Open b-gonzalez opened 10 months ago

b-gonzalez commented 10 months ago

Please see the screenshots below:

image

image

Description:

Cell A1 contains code that references an instance of a list that's assigned to the variable l

Cells C1:C3 contain the values 1 through 3.

Cells D1:D3 reference l and append the values in cells C1:C3 to it

Cells F1:F3 reference the l variable and use the Excel Value option as the python object.

Cell F1 outputs the first value in variable l which is 1

Cell F2 outputs the first two values in variable l and spills. So the values it outputs are 1 and 2

If I keep F2 spilled but fill down to output F3, it looks like I get stuck in an infinite loop with the calculation engine constantly recalculating. Please see the screenshot below:

image

image

Let me know if you have additional questions.

Thanks!

-Brian

keyur32 commented 10 months ago

Thank you! We're taking a look.