Comment on Very normal and safe

• vrek@programming.dev ⁨1⁩ ⁨week⁩ ago

  I’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.

  source

  • 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.

    source

    • 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…

      source

      • 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.

        source

        • -> View More Comments