Please add a functionality to only office that allows us to plug in any AI model whether locally or through an API key. Then we are able to do things with that AI just like we can do with co-pilot in Microsoft Office or Gemini in Google Workspace. These things include like chatting with the AI to create a Spreadsheet structure or creating certain formulas, creating a presentation, making certain tables within the document editor or recording certain macros. This would make only office much more advanced and also much more fun to work with. Unfortunately, the AI that is at the moment implemented in office only allows for basic things like translation of text, if the text is selected, consulting the AI about the text that is being selected, and so on. It would be very helpful if AI is more of a part of only office not just a side feature that is separate from the application. Of course, those who are anti-ai will be allowed to turn it off.
Hi @centura,
This already exists — it just needs to be enabled.
In Desktop: Settings → check Use AI functions (needs restart), then Plugins → Background plugins → turn on AI, then AI → Settings → add your model. Any provider works, and local ones like Ollama use a base URL instead of an API key.
There is also an AI agent tab in the left panel of the start screen — a full chat with MCP servers and web search.
Have you tried it already, or is this what you were looking for?
Hi @Nurullo,
Thanks for your very helpful response. I did not know that. I set up everything with a local AI server (Ollama) and immidiately tried it out if it works.
However, as i gave the AI a prompt to create me a spreadsheet in a new file i opened, it told me it cant do it. I am gonna give you screenshots and the exact prompt I gave it and its response.
I would appreciate your thoughts on this 
My prompt:
””
Create a personal monthly budget spreadsheet (XLSX) with the following structure:
Sheet 1: ‘Dashboard’
-
Title: ‘Personal Budget — [Month Year]’ (bold, 18pt, dark blue background with white text)
-
Summary section at top with: Total Income, Total Expenses, Net Balance (Income − Expenses)
-
Color code: Income = green (#2E7D32), Expenses = red (#C62828), Net = blue (#1565C0) if positive, red if negative
-
A simple pie chart showing expense breakdown by category
-
A bar chart comparing this month vs last month (use placeholder data for last month)
Sheet 2: ‘Income’
-
Columns: Source | Amount | Notes
-
Rows: Salary, Freelance, Investments, Other
-
Total row at bottom (bold, light gray background)
Sheet 3: ‘Expenses’
-
Columns: Category | Subcategory | Description | Amount | Date | Status (Paid/Pending)
-
Categories (each with a different pastel background color):
-
Housing (light blue): Rent, Utilities, Internet, Insurance
-
Food (light green): Groceries, Restaurants, Coffee, Subscriptions
-
Transport (light yellow): Fuel, Public Transit, Parking, Maintenance
-
Health (light pink): Doctor, Pharmacy, Gym
-
Entertainment (light purple): Streaming, Games, Hobbies, Events
-
Savings (light orange): Emergency Fund, Investments, Retirement
-
Other (light gray): Gifts, Subscriptions, Miscellaneous
-
-
Total row per category (subtotals, bold)
-
Grand total at bottom
Sheet 4: ‘Savings Goals’
-
Columns: Goal | Target Amount | Current Amount | % Complete | Deadline
-
Include a progress bar (conditional formatting: green fill proportional to %)
-
Goals: Emergency Fund (6 months expenses), Vacation, New Laptop, Retirement
Formatting throughout:
-
All amounts formatted as currency (CHF)
-
Column widths auto-fitted
-
Frozen header rows
-
Thin borders on all data cells
-
Font: Calibri 11, headers in bold
-
Add data validation dropdowns for ‘Status’ column (Paid/Pending)
-
Conditional formatting: highlight any expense over CHF 500 in light yellow
Add a ‘Notes’ column at the far right of each sheet
””
THen this was the AI’s response:
””
I understand you are asking me to build a highly detailed, multi-sheet, professionally formatted Excel spreadsheet ($XLSX$).
Currently, the tools provided allow me to manipulate an existing spreadsheet (e.g., write formulas, change formatting, add charts, or run code on a sheet that is already open). I do not have a function or tool that allows me to create an entirely new, complex XLSX file structure, populate it, and link multiple sheets from scratch based on a detailed textual blueprint.
This request requires a full spreadsheet design/builder interface, which is beyond my current capabilities.
What I recommend:
If you can start with a blank spreadsheet (or an existing template) and let me know which sheet or specific feature you want me to implement next, I can write the precise JavaScript code using the writeMacro tool to handle that step perfectly (e.g., “Now, on the ‘Dashboard’ sheet, please add the bold title and format the region A1 to contain the text ‘Personal Budget - [Month Year]’”).
Blueprint Summary (How I would approach this if I had a ‘File Create’ tool):
If I could create the file, the process would involve hundreds of lines of code hitting every specific API endpoint:
- Structure Creation: Call an API to initialize a workbook with 4 distinct sheets (‘Dashboard’, ‘Income’, ‘Expenses’, ‘Savings Goals’).
- Schema Definitions (Sheet Setup): For each sheet, set headers, define column widths/freezing, and set generic formatting (e.g., all amounts must be formatted as currency).
- Data Input & Formatting: Systematically write placeholder data, applying all specified colors, fonts, borders, and currency formats across all required cells.
- Interactivity & Rules:
- Data Validation: Apply dropdowns for ‘Status’ column (Paid/Pending).
- Conditional Formatting: Apply the CHF > 500 highlight (Expenses sheet) and the progress bar logic (Savings Goals sheet).
- Color Coding: Implement complex conditional coloring for the summary totals (Dashboard).
- Calculations & Linking: Write formulas (e.g.,
='Income'!D5,=SUM('Expenses'!D:D) - D_Income_Total) into the appropriate cells. - Visualizations:
- Create the Pie Chart (Expenses breakdown by category).
- Create the Bar Chart (Month vs Last Month comparison).
- Final Touches: Auto-fit all columns and merge/format the main title on the Dashboard.
Please let me know which specific part of this detailed setup you would like me to attempt to script using the writeMacro tool, assuming you are working within an open workbook environment.
””
Hi @centura,
Thanks for the prompt and screenshots.
We’re looking into this — I’ll come back to the thread once we have news to share.
Hi @centura,
We’ve tested this on our side. Short version — your prompt is quite a lot for one request. We tried it with several models, including large ones, and none of them got the whole thing right in one go. The sheets get created, but there are usually mistakes in formulas or formatting somewhere. Charts do work, though we found an issue where two charts can end up on top of each other. That one’s with the team now.
The model matters a lot here. gemma3:4b is small for this kind of task — smaller models tend to lose track of which tools they can use, or just stop halfway. That’s most likely what you ran into.
What works better is going step by step instead of the whole blueprint at once. You also don’t need to create the Dashboard sheet beforehand, the AI can do that itself — just make sure it creates the sheet before it tries to write to it.
If the steps still don’t get applied on your side, let me know — there’s something there we’re already looking at.