Technology1 min read

A Million Rows and Live Excel Formulas, Inside Your Own App

By · Published by Everything Blog

In short

The DataGrid component leverages self-painting cells, CSS styling, range-based selection, and lazy-loaded tree-table modes to manage up to one million rows without copying underlying data during sorts. Alongside it, the Workbook component reads and writes CSV, .ods, and .xlsx files, seamlessly supplying individual sheets as grid models. A live calculation engine with 402 Excel functions automatically recalculates dependent cells up to Excel's 64-level nesting limit. An interactive formula editor further supports users with syntax autocompletion, color-coded cell references, and visual grid outlines.

Key points

  • Dependent cells update automatically across sheets up to Excel's 64-level nesting thresho…: Dependent cells update automatically across sheets up to Excel's 64-level nesting threshold whenever values change.
  • The built-in formula editor features syntax autocompletion and highlights referenced cell…: The built-in formula editor features syntax autocompletion and highlights referenced cells directly on the grid.
  • Existing Swing compatibility components like JTable leverage the underlying row engine to…: Existing Swing compatibility components like JTable leverage the underlying row engine to accelerate mobile sorting.

Sources checked by our analysis pipeline: 1

My high school finishing exams included a test in Lotus 1-2-3. I’ve spent a good part of my career since then yelling at spreadsheets, and I still use them every day: the company P&L, grocery lists, student attendance. People love to hate them. The world runs on them anyway, because nothing else lets a person who isn’t a programmer build a working model of their business in an afternoon.

Lotus is worth remembering for another reason. It didn’t invent the spreadsheet. VisiCalc did. Lotus put charts next to the numbers, and mixing two good ideas made one of the first great software companies. Here are the components. Remix them.

This week Codename One gained two of them. DataGrid

is a grid for data at enterprise scale, and Workbook

turns it into a spreadsheet with real files and live formulas.

DataGrid is Table for a million rows

Table

stays. It lays out a real component in every cell, which is what you want for a form with twenty fields. DataGrid

is a different animal, closer to SwingX’s JXTable

and JXTreeTable

if…

Technology