Comment by chakintosh
16 days ago
I opened Excel today to view a spreadsheet and just out of curiosity, I decided to use the Copilot integration for the first time to ask it about a column's content. Copilot was clueless. The spreadsheet was open, the Copilot button is right there in the UI, as a user, the affordance of that button for me is that Copilot should already have the context (which is the spreadsheet content). But it didn't, and it kept asking me for the spreadsheet like it's open in a browser window.
I wanted to do something complex in google sheets. We had just gotten Gemini in gsheet. I assumed they'd have used some fancy mcp and enabled us to do a lot of things but all gemini in gsheet could do was summarize
It sounds like that's still a step up from Copilot.
I know Gemini has more advanced features in Docs and they rolled something out for Sheets. I would bet GWorkspace keeps gaining ground on the functionality battle.
Well, copilot is less than useless
But the thing is, for gemini to be magic, they need api for each operation, they don't have it! So that's why it can only do sum.
I got bitten by this confusing UX. The spreadsheet must be in OneDrive for copilot to use it as context. It’s actually quite useful.
I always find myself recalibrating if copilot understands what I am doing. I get mixed results. cannot seem to come up with a consistent rule of thumb.