GS-Calc
| A simple pivot table created in GS-Calc A simple pivot table created in GS-Calc | |
| Developer(s) | citadel5 |
|---|---|
| Stable release | 17.2
/ 23 October 2019 |
| Written in | C++ |
| Engine | |
| Operating system | Microsoft Windows |
| Platform | WTL |
| Type | Spreadsheet |
| License | Trialware |
| Website | citadel5 |
Search GS-Calc on Amazon.
GS-Calc is a spreadsheet developed by Citadel5.
GS-Calc distinctive features
Organizing worksheets in tree structures
References to cells in nested folders are similar to plain file paths, e.g.
=\folder1\folder2\wsheet1!A10
and can be relative to the current folder as well. Additionally, 3D references can be created with constructions like
=\folder1\folder2!A10
where an array of the A10 cell values from all worksheets in "folder2" is returned. The number of worksheets is unlimited.
Overwriting the built-in functions
All functions can be redefined without any multi-threaded performance degradation or any limitations of the multi-threaded calculation options. The support forum includes sample source code showing e.g. how to create imaging functions or call R Project functions.
Multi-threaded calculation
Multi-threaded calculations can include any formulas, including formulas with dynamic references. The (definable) number of used processor cores is 1 to 64.
Optional binary file format
Although zipped xml file formats are the common standard now, aside from the OpenDocument file format GS-Calc also offers a native binary format. It can be used if saving/loading times and the size of the output files are more important and the interoperability with other programs is not needed. For example, in the binary file format, rows containing series such as
| A | B | |
|---|---|---|
| 1 | =sum(e1:f1) | 10000000 |
| 2 | =sum(e2:f2) | 9999999 |
•
•
•
| 10000000 | =sum(e10000000:f10000000) | 1 |
can be automatically saved as a single row.
Synchronized nested viewing panes
Worksheets can be displayed in up to 100 split panes where various groups of them can optionally use synchronized vertical and/or horizontal scrolling to browse multiple worksheet(s) regions at the same time.
Worksheet dimensions
The number of rows is 12 million and the number of columns is 4096. The maximum number of cells with formulas is 4 billion.
GS-Calc users
GS-Calc has been used in scientific applications mainly due to its number of columns and rows.[1][2][3]
References
- ↑ American Society for Horticultural Science, "Genetic Diversity of Seven Deciduous Azalea Species"
- ↑ FEBS Letters 580 (2006) 6413–6422, "A simple model to explain three-base periodicity in coding DNA"
- ↑ Case Western Reserve University, "Relative Efficiency of the Internal Capital Market In a Multi-division Firm"
External links
 |
Wikimedia Commons has media related to [[commons:Lua error in Module:WikidataIB at line 466: attempt to index field 'wikibase' (a nil value).|Lua error in Module:WikidataIB at line 466: attempt to index field 'wikibase' (a nil value).]]. |
- Official website
- GS-Calc 14 review, Softpedia
- GS-Calc 10 review, PC World
- GS-Calc 6.0 review, Tucows
- robry825.com Robry-Calc is a distribution based on GS-Calc and has been used approx. since 2010 for complex data models for natural gas market by analysts providing data among others for Investorvillage.com, First Enercast Financial.
This article "GS-Calc" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:GS-Calc. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.
