iiiiiiitttttttttttt

1282 readers

47 users here now

you know the computer thing is it plugged in?

A community for memes and posts about tech and IT related rage.

founded 6 months ago

MODERATORS

irelephant@programming.dev

irelephant@lemmy.dbzer0.com

870

We put the Thing That Can't Do Numbers™ in your spreadsheets (programming.dev)

submitted 2 weeks ago by irelephant@programming.dev to c/iiiiiiitttttttttttt@programming.dev

100 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] DupaCycki@lemmy.world 2 points 1 week ago (1 children)

Passing the range is optional, as per the documentation. However, when used with a separate range parameter, it does return correct results. Note that specifying a range inside the text prompt will not work, even though it should be the exact same request sent to the model.

I'm not sure what the intended purpose for this is, but it can return crazy numbers when doing math. You can ask it to add some cells in a completely empty spreadsheet and it'll return some random numbers.

[–] Blackmist@feddit.uk 4 points 1 week ago

Yeah, plenty of warnings in there about not using it for numbers.

And also this:

The COPILOT function only has access to data provided through the context arguments. It does not have access to:

Other data from the workbook

So it's optional only in that it won't even look at the spreadsheet when returning the result. I suspect the next 20 years of AI research will be teaching it to say "I'm sorry, Dave. I'm afraid I can't do that" when appropriate.