Excel display value of set is #N/A

microsoft / python-in-excel

Python in Microsoft Excel

MIT License

517 stars 34 forks source link

Closed ncalm closed 9 months ago

ncalm commented 1 year ago

These return a set object which can be printed and is intact, but the object can't be displayed in a cell:

set(pd.Series([1,2,3,4,5]))
set([1,2,3,4,5])

When trying to display in a cell, it shows #N/A.

I would expect it to just display the set as a spilled array, similar to ndarray or series.

keyur32 commented 1 year ago

Thank you for the report. Marking this as an enhancement so we can follow up on.

keyur32 commented 1 year ago

Internal bug id: 8409804

keyur32 commented 9 months ago

This is now fixed. Please reply back if you have any comments.