Worm Spreadsheet Test Page

This page demonstrates the spreadsheet functionality with local storage fallback

๐Ÿงช Test Instructions

Step 1: Open the Spreadsheet

Click the button below to open the spreadsheet in a new tab:

Step 2: Test Basic Functionality

  1. Enter a filename (e.g., "test.log") and click "Load"
  2. Click on any cell to edit it
  3. Type some text or numbers
  4. Press Enter or click elsewhere to save
  5. Check the browser console for save confirmations

Step 3: Test Calculations

  1. Enter numbers in cells A1, A2, A3
  2. Enter numbers in cells B1, B2, B3
  3. Observe the row sums in the rightmost column
  4. Observe the column sums in the bottom row
  5. Check the global sum in the bottom-right corner

Step 4: Test Titles

  1. In any cell, type: TITLE A Name (sets column A title)
  2. In any cell, type: TITLE 1 Employee (sets row 1 title)
  3. Notice how title cells are highlighted in green

๐Ÿ” Debug Information

Click "Check Local Storage" to see what data has been saved locally:

๐Ÿ“‹ Expected Behavior

โœ… What should work:
  • Cell editing and saving to local storage
  • Automatic sum calculations
  • Title highlighting
  • Sticky headers when scrolling
  • Status updates in the header
โŒ What won't work without server:
  • Real-time collaboration (no polling)
  • Saving to actual worm log files
  • Loading from existing log files

๐Ÿš€ Next Steps

To test the full functionality with the worm extension:

  1. Start the easyp server with the worm extension
  2. Place the spreadsheet.html file in the document root
  3. Access it via the server URL
  4. Test real-time collaboration between multiple browser tabs