Skip to content
robertleeplummerjr edited this page Sep 5, 2014 · 5 revisions

Since jQuery.sheet is the main UI for the time being, there is no need to focus on UI components in the C#Sheet, it will be a set of classes that can essentially assemble spreadsheets, calculate spreadsheets, and supply json or ajax to the jQuery.sheet counterpart.

Syntax parser needs to ensure it can parse at least all markups in jQuery.sheet (40 hours)

  • Combine a a repository of all existing unit test formulas and ensure each can be parsed using the C# implementation
  • Any failing syntax must be fixed so that C#Sheet acts the same as jQuery.sheet

Extend the calculations engine so that cell lookups can be achieved to get there value (20-40 hours)

Mimic jQuery.sheet's cell dependency management in C#Sheet (20-40 hours)

Improve jQuery.sheet's formula functions to better match that of Excel/Libre Office (?)

Port jQuery.sheet's formula functions to C# (?)

Performance increases (?)

Implement revision system so that spreadsheets inherently ARE already calculated any time they are needed. (?)

  • This will take advantage of when a cell is edited, performing the calculation and caching it at that time.