📊 SPREADSHEET_APP

Interactive terminal-style spreadsheet application with advanced formula evaluation and range selection capabilities.

---

🎓 Certification

Course: JavaScript Algorithms and Data Structures

Complete Your Certificate:

• ✅ This project (Spreadsheet App) fulfills one requirement

Full Project Suite: 25+ hands-on projects from Pyramid Generator to Final Certification Projects

• 🎓 Complete all projects to earn your certification

This repository contains the complete portfolio of projects needed to demonstrate JavaScript proficiency and earn the freeCodeCamp certificate.

---

📸 Application Preview

Live Demo: https://acheronx0577.github.io/JavaScript-Building-a-Spreadsheet

---

🎮 How to Use

🔢 Basic Navigation

• Arrow Keys: Move between cells
• Shift + Arrow Keys: Select cell ranges
• Ctrl + Arrow Keys: Jump to edges
• Tab/Shift+Tab: Horizontal navigation
• Enter/Shift+Enter: Vertical navigation
• Escape: Cancel operations

📝 Formula System

• Basic Math: =A1+B2, =C3*D4, =E5/F6
• Functions: =SUM(A1:A10), =AVERAGE(B1:B5)
• Range References: =MEDIAN(A1:J99)
• Direct Input: Enter values without =

🎯 Selection Features

• Click: Select single cell
• Drag: Select multiple cells
• Range Formulas: Apply formulas to selected ranges
• View Mode: Inspect cell contents without editing

---

🧮 Available Functions

Function	Description	Example
SUM	Sum of values	=SUM(A1:A10)
AVERAGE	Mean average	=AVERAGE(B1:B5)
MEDIAN	Middle value	=MEDIAN(C1:C10)
EVEN	Filter even numbers	=EVEN(D1:D10)
RANGE	Create number sequence	=RANGE(1,10)
NODUPES	Remove duplicates	=NODUPES(E1:E10)
INCREMENT	Add 1 to values	=INCREMENT(F1:F5)
FIRSTTWO	First two values	=FIRSTTWO(G1:G10)
LASTTWO	Last two values	=LASTTWO(H1:H10)
RANDOM	Generate random number	=RANDOM(1,100)

---

🎨 TUI Style Features

• Terminal Interface: Window controls, blinking cursor, status bars
• Teal & Purple Theme: Custom CSS variables with gradient accents
• Real-time Statistics: Live cell count and mode indicators
• Range Highlighting: Visual feedback for selected cell ranges
• Formula Bar: Dedicated formula input with status indicators

---

🧰 Installation & Usage

1️⃣ Clone this repo

git clone git@github.com:acheronx0577/JavaScript-Building-a-Spreadsheet.git

2️⃣ Run the file

Just open index.html in your favorite browser 🌐 and start playing!

---

No dependencies required - pure HTML, CSS, and JavaScript.

---

🤝 Contributing

Fork the repo and submit PRs for:

• New spreadsheet functions
• UI/UX enhancements
• Performance optimizations
• Additional keyboard shortcuts
• Export/import functionality

---

Built with ❤️ through freeCodeCamp | Making data analysis accessible and interactive!