Urgent.News

What's breaking now, across thousands of outlets.

Tech

Introducing BermudoGreen.js: A Free, Zero-Dependency Excel Spreadsheet & Formula Engine for Vanilla JS

Hey everyone! ๐Ÿ‘‹ I'm excited to introduce BermudoGreen.js , a lightweight, completely free, and open-source Excel spreadsheet and formula calculation engine built for Vanilla JavaScript. Many modern spreadsheet solutions for the web come with expensive licensing fees that can cost developers thousands of dollars. I wanted to create a simple, reliable, zero-dependency alternative that anyone canโ€ฆ

Introducing BermudoGreen.js, a completely free and open-source Excel spreadsheet and formula calculation engine built for Vanilla JavaScript. Many modern web spreadsheet solutions come with expensive licensing fees, which can cost developers thousands of dollars. The goal of BermudoGreen.js is to provide a simple, reliable, and zero-dependency alternative that can be easily integrated into web applications without worrying about enterprise-level pricing or restrictive licensing.

Key features include a built-in formula engine with support for common functions like SUM, AVERAGE, COUNT, IF, VLOOKUP, and more. An interactive formula bar with dynamic multi-color range highlighting and IntelliSense auto-complete tooltips is also available. The engine supports Excel layout conventions such as column letters (A, B, C, etc.), row numbers (1, 2, 3, etc.), auto-fit columns, and drag-to-resize functionality.

Number formatting options include Currency, Percentage, Integers, Decimals, and Dates. Seamless copy/paste (Ctrl+C / Ctrl+V) functionality is supported for direct transfer to and from Microsoft Excel or Google Sheets. Global undo/redo support via Ctrl+Z and Ctrl+Y is also included.

With zero dependencies, BermudoGreen.js is built using pure Vanilla JavaScript, HTML5, and CSS, making it lightweight and easy to integrate into any web application. To get started, visit the live demo or clone the repository from the GitHub link provided. Simply add the necessary links and script tags to your HTML, and drop the spreadsheet into your page.

Written by urgent.news from Dev.to's reporting โ€” not their text. Machine-written โ€” may contain errors; check the original before relying on it.

Read the original at dev.to โ†’

More in Tech

Bitwise and Otherwise: Understanding XOR Distance

Hello, I'm Maneshwar. I'm building git-lrc, a Micro AI code reviewer that runs on every commit. It is free and source-available on Github. Star git-lrc to help devs discover the project.

  • XOR distance calculated by bitwise XOR of binary IDs
  • Larger XOR numbers indicate greater distance between nodes
  • XOR distance satisfies metric properties: identity, symmetry, and triangle inequality

More from Tuesday 25 August โ†’