for, let’s say ten years, my entire powershelling career, i have used |OGV to lazily and quickly and dirtily spit out a grid of results that i can sort if i need to and copy and paste into excel if i need to do more than sort.
suddenly today, that pasting results in just junk pasted into excel. cells that don’t contain columns are are merged with columns next to them, and cells containing commas are split into multiple columns. (i’m exporting active directory stuff like samaccountname and distinguishedname).
my work PC was ‘upgraded’ to windows 11 about a week ago. is this a gift from that? is anybody else seeing this?
gotcha. I don’t have access to a Windows 11 box with an AD environment for me to test. I never use Out-GridView, but I just tried it on my current machine and got the results that you described used to work for you.
Is this still Powershell v5.1 for you?
yes. version 5.1 in the ISE.
and. actually if i RDP into a windows 2019 server and run the same out-gridview code, pasting those results into excel on my workstation are the same gibberish as runing the powershell locally on my workstation. . this is the kind of thing i’ve done hundreds of times, so this smells like an excel setting/windows 11 thing more than a powershell thing. now i’m just curious if anybody else has seen/fixed this.