Handsontable
 | |
 Currency exchange table built with Handsontable | |
| Developer(s) | Handsoncode |
|---|---|
| Stable release | 6.1.0
/ October 17, 2018 |
| Repository | github |
| Written in | JavaScript |
| Engine | |
| Platform | See Browser compatibility |
| Type | JavaScript library |
| License | Free/Commercial |
| Website | handsontable |
Search Handsontable on Amazon.
Handsontable is a JavaScript datagrid library with a spreadsheet user interface and features that is developed and supported by Handsoncode.[1][2] Since version 7.0.0, the library has been distributed as source-available software, with 6.2.2 being the final open source (MIT license) version.
Handsontable is not standalone software and therefore requires integration into a larger system, such as a CRM, ERP, or CMS, among others.[3][4]
History[edit]
The idea to create a JavaScript datagrid with the functionality of a spreadsheet was arrived at by one of the founders of Handsoncode, Marcin Warpechowski,[5] in 2010. It came out of frustration from a lack of then-stable solutions allowing for the ability to edit JSON files in a browser. The first commit for the software was pushed to the Github repository on May 24, 2011,[6] and the first milestone of the repository was completed in version 0.1.0, being closed on May 16, 2012.[7]
In 2016, Handsontable was extended by additional features. This proprietary extension became known as Handsontable Pro. The features mentioned included column filters, nested headers, and formula support.
On March 6th, 2019, Handsontable merged its Community Edition and Pro versions and changed the name of the software to Handsontable.
Technology used[edit]
Initially, Handsontable was written using jQuery, but that dependency was removed in 2014.[8] Currently, it follows the updates to the ECMA Script standard.
Features[edit]
Handsontable contains fewer features than consumer software such as Google Sheets or Microsoft Office. It's core functionality, however, can be extended through custom plugins due to its modular design.[9][2] Handsontable includes, among others, the following options:[10][11][1]
- Freezing rows and columns
- Moving rows and columns
- Resizing rows and columns
- Sort data in a column
- Context menu
- Merging cells
- Clipboard
- Filtering data in a column
- Column dropdown menu
- Nested headers
- Collapsing columns
- Export to file
- Formula support
Framework support[edit]
Handsontable uses wrappers to support JavaScript frameworks. It currently supports the following frameworks:
Browser compatibility[edit]
Handsontable is compatible with Google Chrome, Mozilla Firefox, Apple Safari, and Internet Explorer 9+, although there are some known issues with IE9.[10] It also supports Microsoft Edge and Opera 26+.[14]
References[edit]
- ↑ 1.0 1.1 Zhang, Shuo; Zada, Vugar Abdul; Balog, Krisztian (2018). "SmartTable". SmartTable: A Spreadsheet Program with Intelligent Assistance. pp. 1297–1300. arXiv:1805.06353. doi:10.1145/3209978.3210171. ISBN 9781450356572. Search this book on
- ↑ 2.0 2.1 Voss, Morgan (2017). "Practical Implementation of Triggered Expressions". Triggered expressions: event driven manipulation of cell states in spreadsheets (PDF) (PhD). Massachusetts Institute of Technology.
- ↑ Martini, Robin; Braeger, Matthias; Salmon, Justin; Suwalska, Anna (21 October 2015). Tools and Procedures for High Quality Technical Infrastructure Monitoring Reference Data at CERN (PDF). International Conference on Accelerator and Large Experimental Physics Control Systems. Melbourne. p. 4.
- ↑ Tran, Quoc Cuong (2014). "Development Environment". DEVELOPMENT AND ANALYSIS USABILITY VIDEO TOOL BY PRAILS WEB FRAMEWORK (PDF) (Thesis). Oulu University of Applied Sciences.
- ↑ Technologies, HONETi - Interactive Web. "Marcin Warpechowski (Starcounter) - Speaker - infoShare - the biggest tech conference in CEE". infoShare 2018. Retrieved 2018-06-15.
- ↑ "First commit · handsontable/handsontable@55ceda4". GitHub. Retrieved 2018-06-15.
- ↑ "First milestone". GitHub. Retrieved 2018-06-15.
- ↑ "Release 0.12.6". GitHub. Retrieved 2018-06-15.
- ↑ "How to Make Your Own Web Spreadsheet App: Tools Review". DZone. Retrieved 2018-07-02.
- ↑ 10.0 10.1 "Angular2 Grid Options". WanariLeaks. 2017-04-27. Retrieved 2018-07-31.
- ↑ MERTEL, Adam; TÖGEL, Marek (January 2015). GIS APLIKACE PRO EMISNÍ MODELOVÁNÍ (PDF). GIS Ostrava (in čeština). Ostrava. p. 2.
- ↑ 12.0 12.1 "Release radar". GitHub. 2018-05-09. Retrieved 2018-06-15.
- ↑ "Awesome Grid". GitHub. Retrieved 2018-06-15.
- ↑ "Browser compatibility". Handsontable. Retrieved 2018-06-15.
External links[edit]
This article "Handsontable" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:Handsontable. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.
