Storytime. I tried to use copilot to get some rather convoluted dataset analyzed in Excel. Not a huge task, but basically I wanted it to count me the occurrences of certain values, grouped by that value. Of course that’s easy with Pivot, and there’s probably also some formula for that, but it wasn’t very urgent, so I figured I’d see what Copilot could do. Now of course I didn’t want to use that =COPILOT() formula, but instead asked Copilot to create me a formula to correctly count how often each value occurs. So it created this multiple lines long formula, which from first glance seemed plausible (though way overcomplicated). I asked it to insert this into cell F13. „Of course“, it said — and then proceeded to do nothing. Confronted with this, it tried again, and failed. After some asking why it didn’t just go that, it told me that this is not possible in Excel in Mac. I’d have to use the web version of Excel. WTF? Why doesn’t the fully featured version do this? Well, of course: Microsoft doesn’t like Apple too much. So I tried copy pasting the formula and failed. Some syntax error cropped up. I asked Copilot about this, and it came back with a typical „oh sorry, my bad, here is the correct formula“ and the same formula again. Of course this failed. And since I didn’t want to debug this stupid thing (the error message of course also didn’t give any indication what exactly could be wrong), I just created a Pivot and got my result in seconds.
Now this is only one of many experiences I had when trying to really use that 365 Copilot for anything useful. Maybe I should write a book about it. And then ask Copilot to write a book about it and put this into the epilogue.
Bubs12@lemmy.cafe 1 week ago
Top comment from the last time this was posted pointed out how the image is cropped on the left. We are most definitely looking at rows 11-14 and there are numbers above that are not being shown.
I just want them to remove the god awful copilot button that showed up in the corner on top of cells in my spreadsheet with no way to move or hide it. It’s not even on the ribbon anymore where I can ignore it. Fuckin’ pricks.
bus_factor@lemmy.world 1 week ago
It’s a lot simpler than that.
=COPILOT()can only see cells provided in the second parameter, and the user didn’t provide one. It’s just giving you what a typical answer to “compute the sum of the numbers above” is.smeenz@lemmy.nz 1 week ago
In other words, they may as well have given it “make up a number”
… though with all the hallucinations, it would probably return elephant intermittently