PulseAugur
EN
LIVE 15:46:53

Claude Opus 5.5 and Gemini 3.7 Flash excel at updating spreadsheet formulas

By PulseAugur Editorial · [1 sources] ·

A benchmark test evaluated three AI models—Claude Sonnet 5.5, Claude Opus 5.5, and Gemini 3.7 Flash—on their ability to correctly update spreadsheet formulas when copied to new cells. Claude Opus 5.5 and Gemini 3.7 Flash achieved perfect scores, accurately returning the updated formulas in all tested cases. Claude Sonnet 5.5 performed poorly, scoring only 0.25, often failing to provide a usable formula even when demonstrating partial understanding of reference movement. AI

IMPACT Highlights differences in LLM capabilities for practical spreadsheet assistance, indicating that model choice significantly impacts usability for formula manipulation.

RANK_REASON Benchmark of AI model performance on a specific task. [lever_c_demoted from research: ic=1 ai=0.7]

Read on dev.to — LLM tag →

AI-generated summary · Google Gemini · from 1 sources. How we write summaries →

Claude Opus 5.5 and Gemini 3.7 Flash excel at updating spreadsheet formulas

How we ranked this

Signal score
0 / 100
Composite score across the factors below. Higher = stronger signal that this story matters right now.
Newsworthiness bucket
Tool
Benchmark of AI model performance on a specific task. [lever_c_demoted from research: ic=1 ai=0.7]
Source corroboration
Single-source cluster
Only one publisher covered this so far. Single-source stories can still rank when the publisher is high-authority, but they lack cross-source corroboration.
Topics
product, other
Editorial topic classification. Feeds into how the story surfaces on /topic/<slug> hub pages and into the per-entity coverage mix.
AI-industry relevance
High
Clearly on-topic for AI-industry coverage.
Story freshness
30 days old
Aged out of breaking-news scoring windows; ranking reflects the durable signal from the full source set.

Full methodology in our editorial standards.

COVERAGE [1]

  1. dev.to — LLM tag TIER_1 English(EN) · Anvi Pardhi ·

    Can AI Return a Copy-Ready Spreadsheet Formula? I Tested 3 Models

    <p><em>This is a submission for the <a href="https://dev.to/challenges/kaggle-2026-09-23">Kaggle Benchmarking Challenge</a></em></p> <h2> What I Benchmarked </h2> <p>I tested whether language models can update Excel-style cell references when a formula is copied to a new cell.</p…

RELATED ENTITIES

RELATED TOPICS