There would be no way to do that reliably. There's too much weird stuff people might say to reference things, and the LLM would definitely act on the wrong cells more often than not.
Excel already has a perfectly unambiguous way to provide a specific range of cells, Which is why the =COPILOT() function lets you supply those in the second parameter. I'm assuming they get passed to the LLM as context, likely encoded as a markdown table. LLMs love parsing markdown, apparently.
The user provided no such range of cells, though, so the LLM is most likely seeing none of those other cells, and is just working based on random values from the Internet.
Yes, but "above" just goes into the LLM, which does who-knows-what with it, and certainly isn't designed to address cells that way. So to the LLM that's just like any other arbitrary text.
The text field says =COPILOT("sum the numbers above"). It doesn't work that way. Excel does not have any concept of what "above" means here. Those numbers are not used in the calculation whatsoever. To reference those numbers, the field should say =COPILOT("sum the numbers in", A1:A3).
What the user did here was ask the LLM to generate some text based on a text prompt and no other data, and the LLM decided to answer with a string containing only digits.
There are no values from the spreadsheet in this case. "The numbers above" are just text to the LLM.
They could of course require that optional cell or cell range parameter after the prompt, but that would eliminate some use cases. "Generate some text", one of the stated use cases in the help text, doesn't reference any cells.
Also, numbers in Excel aren't necessarily as clear cut as you make it seem. Excel famously thinks everything is a date, and how number-y must a number be before it isn't okay?
Not to mention there are other things to do with numbers which don't require arithmetic. What if someone wants to have Excel translate 34 to "thirty-four"? Or have Excel generate a poem 34 words long? Or whatever else nonsense people might try.
The C-section for the third kid was scheduled, right? I could see how a doctor would be less inclined to have a nervous husband watching during an emergency as opposed to a scheduled procedure.
A friend of mine does that for group lunches. If everyone is humming and hawing about where to go, he'll suggest McDonald's. This reduces the threshold of making suggestions significantly for the others, because they no longer need to find a great place. They only need to come up with somewhere better than McDonald's.
How is looking at ascii values supposed to help when someone prompts it with "calculate the sum of the numbers above"? The whole point is that no matter what kind of prescreening you add to an LLM, people will write prompts which are missed by the screening.
No AI truly knows what it's doing. You can give it things to call out to, but you can't know for sure if it will use them, and definitely can't know it will pass it the right parameters.
People use Excel for everything. Soo many spreadsheets out there should really have been databases, but the suits have one hammer they know how to use and they're determined to use it.
TL;DR: Sounds like something someone who knows how to use other tools would say
They straight up tell you to not use it for math. It's for analyzing a bunch of text you shoved into a spreadsheet, say for example customer testimonials or something. Making it work most of the time would actually be worse, because then people would be more inclined to use it instead of writing the formulas to do it right.
It's not meant for calculations. People do all sorts of calculations in Excel. This is for when you have a bunch of rows with text in them, say for example customer testimonials, and you want to summarize and/or determine sentiment for each one so you can analyze it without reading it all.
I saw a demo of it, and if it works as advertised it could be cool. You can use the results from other queries in other cells, so it feels like using Excel, just with text instead of numbers.
I personally don't have any use for it, but it has a lot more potential to be useful than most of the AI garbage I see.
You should be able to set up letterboxing using either xrandr or your window manager, although I got pretty unsatisfactory results when I searched for "xrandr letterboxing".
What are you using to draw on the screen? That would determine how best to achieve this. I'd expect it to be doable regardless, but the path there would be different.
That cat looks like it's seen some shit.