Comment on Very normal and safe
vrek@programming.dev 1 week agoI’m betting the one is formatted as text and the other rows are formatted as a numbers. Can’t confirm as I don’t use excel but that seems to be the issue.
Comment on Very normal and safe
vrek@programming.dev 1 week agoI’m betting the one is formatted as text and the other rows are formatted as a numbers. Can’t confirm as I don’t use excel but that seems to be the issue.
bus_factor@lemmy.world 1 week ago
No, it’s a lot more basic than that. You provide
=COPILOT()the cells to operate on in the second parameter, and the user didn’t provide it. Copilot cannot see any of the spreadsheet and just reported what a typical answer for a request like that is.vrek@programming.dev 1 week ago
Wait… Is that really true? The integrated copilot in excel can’t see the data in excel? That’s insane. Copilot in vscode or visual studio can see all the code your working on so I don’t see why excel wouldn’t be able to…
bus_factor@lemmy.world 1 week ago
Excel sees the cells you tell it to operate on. When you’re working with code, all the code is relevant. Usually in Excel, you have specific cells you want to do an operation on, and those are provided to the function, just like any other thing you do in Excel. If you want to operate on the entire spreadsheet, just provide a range including the entire spreadsheet, but this is not done unless you ask for it.
vrek@programming.dev 1 week ago
Wow, yeah most people who want to use a function like this will mess that up…