Drawing borders efficiently

Kazuo Iwama, Eiji Miyano, Hirotaka Ono

研究成果: ジャーナルへの寄稿学術誌査読

2 被引用数 (Scopus)


A spreadsheet, especially MS Excel, is probably one of the most popular software applications for personal-computer users and gives us convenient and user-friendly tools for drawing tables. Using spreadsheets, we often wish to draw several vertical and horizontal black lines on selective gridlines to enhance the readability of our spreadsheet. Such situations we frequently encounter are formulated as the Border Drawing Problem (BDP). Given a layout of black line segments, we study how to draw it efficiently from an algorithmic view point, by using a set of border styles and investigate its complexity. (i) We first define a formal model based on MS Excel, under which the drawability and the efficiency of border styles are discussed, and then (ii) show that unfortunately the problem is \mathcal{NP} -hard for the set of the Excel border styles and for any reasonable subset of the styles. Moreover, in order to provide potentially more efficient drawing, (iii) we propose a new compact set of border styles and show a necessary and sufficient condition of its drawability.

ジャーナルTheory of Computing Systems
出版ステータス出版済み - 2月 2009

!!!All Science Journal Classification (ASJC) codes

  • 理論的コンピュータサイエンス
  • 計算理論と計算数学


「Drawing borders efficiently」の研究トピックを掘り下げます。これらがまとまってユニークなフィンガープリントを構成します。