Skip to content

FUTURE.md

Latest commit

 

History

History
59 lines (42 loc) · 2.34 KB

FUTURE.md

File metadata and controls

59 lines (42 loc) · 2.34 KB
Raw

Future Enhancements

Univer Integration (Spreadsheet UI)

Overview

Univer is a full-stack spreadsheet framework (Google Sheets-like) that could enhance the app with in-browser spreadsheet editing.

Key Features

  • Full spreadsheet UI with Excel-like editing
  • Real-time collaboration (OT-based conflict resolution)
  • Node.js support for server-side rendering/processing
  • Plugin architecture with 100+ plugins available
  • Apache-2.0 license (free for core features)

Assessment for This App

Consideration Analysis
Overkill? Likely yes for current use case. We import files, not edit spreadsheets live. Adds ~500KB+ bundle size.
Where it fits If users need to edit data inside the app (fix typos, add rows, manipulate before comparing).
Complexity Significant learning curve. Current ExcelJS import is ~100 lines. Univer would be 500+ lines with state management.
Alternatives Handsontable ($899/yr) or FortuneSheet (MIT, lighter) for basic editing.

When Univer Makes Sense

  1. In-app spreadsheet editing before comparison
  2. Collaborative features - multiple users editing same list
  3. Building toward a BI/reporting tool
  4. Formula support needed for calculated columns

When to Skip It

  1. Current import-only workflow is sufficient
  2. Bundle size matters (PWA or mobile-first)
  3. No need for real-time collaboration

Recommended Phased Approach

Phase 1 (Current): Keep ExcelJS for import/export - it works
Phase 2 (If needed): Add FortuneSheet for light inline editing
Phase 3 (If scaling): Migrate to Univer for full collaboration

Potential Integration Points

  • Replace file import modal with embedded spreadsheet
  • Allow paste/edit data directly in spreadsheet UI
  • Feed edited data into existing comparison logic
  • Export comparison results back to editable spreadsheet

Resources