Lattice Angular

Spreadsheet built using Angular 9. Can handle expressions (= 2 * 3 * 4) or references to other cells (= C5) and basic functions (= LEN(A2) and = JOIN(B3, B4)).

Uses:

• ngFor, ngIf directives
• Template reference variables
• Event handlers: (click), (focus), (keyup.enter)
• FormControl
• FormGroup subclass
• Services: EvaluatorService, SheetService
• Components: LatticeSheetComponent, LatticeTableComponent, App

TODO:

• Tests! Using https://github.com/testing-library/angular-testing-library
• Fix white overlap on cells
• Add cell ranges
• Add SUM()
• Add AVERAGE()

---

This project was generated with Angular CLI version 9.1.9.

Development server

Run ng serve for a dev server. Navigate to http://localhost:4200/. The app will automatically reload if you change any of the source files.

Code scaffolding

Run ng generate component component-name to generate a new component. You can also use ng generate directive|pipe|service|class|guard|interface|enum|module.

Build

Run ng build to build the project. The build artifacts will be stored in the dist/ directory. Use the --prod flag for a production build.

Running unit tests

Run ng test to execute the unit tests via Karma.

Running end-to-end tests

Run ng e2e to execute the end-to-end tests via Protractor.

Further help

To get more help on the Angular CLI use ng help or go check out the Angular CLI README.