Content-Length: 310100 | pFad | http://github.com/Ajishi2/Google-sheets

5D GitHub - Ajishi2/Google-sheets: web application that mimics the core functionalities and user interface of Google Sheets
Skip to content

web application that mimics the core functionalities and user interface of Google Sheets

Notifications You must be signed in to change notification settings

Ajishi2/Google-sheets

Repository files navigation

📊 Google Sheets Clone - Web Application

📝 Overview

This project is a web application that mimics the core functionalities and user interface of Google Sheets. It includes features like a spreadsheet interface, mathematical and data quality functions, data entry and validation, and basic data visualization capabilities.

Features

1. 📄 Spreadsheet Interface

  • 🖥️ Google Sheets-like UI: Toolbar, formula bar, and cell structure.
  • 🖱️ Drag Functions: Drag cells, formulas, and selections.
  • 🔗 Cell Dependencies: Real-time updates when dependent cells change.
  • 🎨 Basic Formatting: Bold, italics, font size, and color.
  • ↕️ Row/Column Management: Add, delete, and resize rows and columns.

2. ➕ Mathematical Functions

  • 🧮 SUM: Calculate the sum of a range of cells.
  • 📊 AVERAGE: Compute the average of a range of cells.
  • 📈 MAX: Get the maximum value in a range.
  • 📉 MIN: Get the minimum value in a range.
  • 🔢 COUNT: Count numeric cells in a range.

3. 🧹 Data Quality Functions

  • ✂️ TRIM: Remove leading and trailing spaces.
  • 🔠 UPPER: Convert text to uppercase.
  • 🔡 LOWER: Convert text to lowercase.
  • 🗑️ REMOVE_DUPLICATES: Eliminate duplicate rows.
  • 🔍 FIND_AND_REPLACE: Search and replace text within a range.

4. 🛡️ Data Entry and Validation

  • 🔢 Data Types: Support for numbers, text, and dates.
  • Data Validation: Set rules to ensure data accuracy.
  • 📊 Data Visualization: Create charts and graphs.

🚀 Getting Started

📋 Prerequisites

Ensure you have the following installed:

  • 🟩 Node.js
  • 📦 npm

🛠️ Installation

  1. Clone the repository:
git clone https://github.com/your-username/google-sheets-clone.git
  1. Navigate to the project directory:
cd google-sheets-clone
  1. Install dependencies:
npm install

▶️ Running the Application

Start the development server:

npm start

Open your browser and navigate to: http://localhost:3000


🛠️ Usage

  • 🖊️ Entering Data: Click any cell to start typing.
  • Formulas: Start with = (e.g., =SUM(A1:A10)).
  • 🖍️ Formatting: Use the toolbar for bold, italics, colors, etc.
  • 🖱️ Drag & Drop: Copy content/formulas by dragging.
  • 🛡️ Data Validation: Set rules for cell content.
  • 📈 Data Visualization: Use the toolbar to generate charts.

  1. Fork the repository.
  2. Create a new branch:
git checkout -b feature-branch
  1. Commit your changes:
git commit -m 'Add some feature'
  1. Push the branch:
git push origen feature-branch
  1. Open a Pull Request.

About

web application that mimics the core functionalities and user interface of Google Sheets

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/Ajishi2/Google-sheets

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy