Tabularis Formatus: Predictive Formatting for Tables

2025-08-14

AI Summary

Existing spreadsheet conditional formatting (CF) rule creation relies heavily on users’ platform expertise, posing high cognitive barriers, poor UI usability, and difficulties in rule construction. This paper proposes the first end-to-end neural-symbolic approach for automatic CF rule prediction. It introduces a novel numerically aware formatting learning paradigm that jointly integrates modular rule synthesis, large language model–driven semantic reasoning, and diversity-aware ranking—requiring neither user-provided examples nor natural language instructions. Evaluated on 1.8 million real-world formatted spreadsheets, our method achieves 15.6%–26.5% higher rule generation accuracy than state-of-the-art symbolic and neural baselines. It further significantly improves interpretability, output diversity, and practical applicability, establishing a new foundation for intelligent, user-centric spreadsheet automation.

Technology Category

• Machine Learning: Neuro-Symbolic Learning
• Cognitive Modeling & Cognitive Systems: Symbolic Representations
• Natural Language Processing: Generation

Application Category

• Search and Retrieval-Augmented AI: Web learning to rank, online learning, and counterfactual learning for ranking
• Semantics and Knowledge: Data modeling to support human-machine intelligence, including LLMs agents, intelligent system behavior, explanations, and user-friendly interactions
• User Modeling, Personalization and Recommendation: Fairness-aware retrieval and ranking

Abstract

Spreadsheet manipulation software are widely used for data management and analysis of tabular data, yet the creation of conditional formatting (CF) rules remains a complex task requiring technical knowledge and experience with specific platforms. In this paper we present TaFo, a neuro-symbolic approach to generating CF suggestions for tables, addressing common challenges such as user unawareness, difficulty in rule creation, and inadequate user interfaces. TaFo takes inspiration from component based synthesis systems and extends them with semantic knowledge of language models and a diversity preserving rule ranking.Unlike previous methods focused on structural formatting, TaFo uniquely incorporates value-based formatting, automatically learning both the rule trigger and the associated visual formatting properties for CF rules. By removing the dependency on user specification used by existing techniques in the form of formatted examples or natural language instruction, TaFo makes formatting completely predictive and automated for the user. To evaluate TaFo, we use a corpus of 1.8 Million public workbooks with CF and manual formatting. We compare TaFo against a diverse set of symbolic and neural systems designed for or adapted for the task of table formatting. Our results show that TaFo generates more accurate, diverse and complete formatting suggestions than current systems and outperforms these by 15.6%--26.5% on matching user added ground truth rules in tables.

Problem

• Simplifying conditional formatting rule creation for spreadsheets
• Automating rule trigger and visual formatting learning
• Improving accuracy and diversity in formatting suggestions

Innovation

• Neuro-symbolic approach for CF suggestions
• Automates rule trigger and visual formatting
• Diversity preserving rule ranking system