paperbot · PL 论文追踪

全部论文 待读 收藏

P2 SGUARD: A Feature-Based Clustering Tool for Effective Spreadsheet Defect Detection

SGUARD:一种基于特征聚类的有效电子表格缺陷检测工具
ASE 2019 34th IEEE/ACM International Conference on Automated Software Engineering (ASE)2019匹配度 2/10 · 该论文属于程序分析与缺陷检测方向,但研究对象是电子表格,未涉及用户核心关注的 LLM/Agent、ML 系统静态分析、浮点程序分析或贝叶斯程序分析。因此与研究方向仅有较弱的领域相关性。引用 4 inbox
Da Li, Huiyan Wang, Chang Xu, Ruiqing Zhang, Shing-Chi Cheung, Xiaoxing Ma
crossref: 2026-09-12

AI 速览

一句话:提出基于特征聚类与簇细化的电子表格缺陷检测工具 SGuard,在精度与召回间取得平衡并超越现有技术。

电子表格被广泛使用,但容易包含各类缺陷。本文提出缺陷检测工具 SGuard,通过学习电子表格特征,将具有相似计算语义的单元格聚类,再对聚类进行细化,从而把异常单元格识别为缺陷。该方法在缺陷检测中达到87.8%的精度和71.9%的召回率,F-measure为0.79,优于现有电子表格缺陷检测技术。作者还介绍了 SGuard 的实现与使用方式,并提供视频演示和公开下载仓库。

问题
电子表格广泛使用但易含缺陷,如何自动检测其中的异常单元格/缺陷是本文关注的问题。
方法
SGuard 学习电子表格特征,对计算语义相似的单元格聚类,并细化聚类以识别异常单元格为缺陷。
评估
在缺陷检测任务上报告87.8%精度、71.9%召回率和0.79 F-measure,并与现有技术比较表明更优。
原文摘要(Abstract)

Spreadsheets are widely used but subject to various defects. In this paper, we present SGuard to effectively detect spreadsheet defects. SGuard learns spreadsheet features to cluster cells with similar computational semantics, and then refines these clusters to recognize anomalous cells as defects. SGuard well balances the trade-off between the precision (87.8%) and recall rate (71.9%) in the defect detection, and achieves an F-measure of 0.79, exceeding existing spreadsheet defect detection techniques. We introduce the SGuard implementation and its usage by a video presentation (https://youtu.be/gNPmMvQVf5Q), and provide its public download repository (https://github.com/sheetguard/sguard).

链接与引用

DOI 原文 ·

BibTeX
@inproceedings{paperbot5339,
  title = {SGUARD: A Feature-Based Clustering Tool for Effective Spreadsheet Defect Detection},
  author = {Da Li and Huiyan Wang and Chang Xu and Ruiqing Zhang and Shing-Chi Cheung and Xiaoxing Ma},
  booktitle = {ASE},
  year = {2019},
  doi = {10.1109/ase.2019.00122}
}