menu
Daily Bits Email

The email you entered is already receiving Daily Bits Emails!

GS-CalcDiscount

GS-Calc

A Super Spreadsheet for All of Your Needs

$39
v20.3 for PC 
Platforms: Windows 7/8.x/10/11 64-bit
GS-Calc ScreenshotSpreadsheet Editors Software ScreenshotGS-Calc, Spreadsheet Editors Software ScreenshotGS-Calc, Business & Finance Software ScreenshotSpreadsheet Editors Software, GS-Calc ScreenshotBusiness & Finance Software, GS-Calc ScreenshotBusiness & Finance Software, Spreadsheet Editors Software ScreenshotGS-Calc, Business & Finance Software, Spreadsheet Editors Software ScreenshotGS-Calc Screenshot 8

Remember that huge calculator you used to have in school, the one that was so massive that it needed its own case? Everything you ever wanted to do was mapped to a button on that calculator…but today’s discount software promotion condenses that functionality into a spreadsheet called GS-Calc!

GS-Calc is a spreadsheet that lets you track expenses, income, and sales while performing statistical calculations and data analysis with over 390 included formulas plus any number of formulas you can define yourself in DLL libraries. With GS-Calc, you’ll be able to edit huge text files and databases without even leaving the application, thanks to support for 12 million rows and nearly 16,384 columns. That is a lot of data!

Beyond the sheer magnitude of the GS-Calc spreadsheet is the impressive processing power of the program, combined with its agility and flexibility. Even the largest files load and save quickly. But use the program for pivot tables and advanced statistical functions, and GS-Calc uses up to 64 processor cores to boost calculations. You can even use up to 100 synchronized panes to multi-task like never before! And with support for export to PDF and import/export from TXT, dBase, Clipper, Fox Pro, and Excel XML formats, GS-Calc is the only spreadsheet you’ll ever need.

Please note folks: GS-Calc can use natively either the standard ODF *.ods spreadsheet format or it's native fast and compact binary format (for example: a spreadsheet with 20 million random numbers will be saved and loaded more or less instantly as a 150MB file).
Also, GS-Calc can be installed on any portable storage device. The installation requires about 7MB. No other libraries or run-times are required.

See what's new in the latest version 19:
https://forum-eng.citadel5.com/viewtopic.php?f=7&t=637

Loading, saving and filtering performance examples:
https://citadel5.com/help/gscalc/large_files.htm

Also, please notice the movies below detailing a few of the product's features:
https://www.youtube.com/watch?v=-_pn8rbfrNg
https://www.youtube.com/watch?v=kmE1-IMInbY
https://www.youtube.com/watch?v=QNkBcj0yvtw

The Conversation
Features
The Fine Print
Expand All Email Updates Load 135 Older Comments
Citadel5 New features in GS-Calc 20.4:

The maximum amount of data in one worksheet has been increased from about 32GB to about 500GB. The number of formulas in one worksheet is unlimited
(previously around 4 billions).
The performance has been improved by several percent.


Several missing help topics have been added to the Help file.
They can be also view online (https://citadel5.com/help/gscalc )

Copying cells vs duplicating copied cells
https://citadel5.com/help...licate.htm

Using AutoScroll Range to automatically move between cells
https://citadel5.com/help...ranges.htm

Selecting functions to display within the table toolbar and related options
https://citadel5.com/help...ctions.htm

Hiding view elements / maximizing the table view display areas
https://citadel5.com/help...-views.htm

Cross-highlighting columns/rows for better readability
https://citadel5.com/help...oss-hi.htm

Using the Dark Mode
https://citadel5.com/help...k-mode.htm

Creating mini-charts in cells
https://citadel5.com/help...charts.htm

Inserting images, files in worksheets
https://citadel5.com/help...t-file.htm

Images and lists of images in cells
https://citadel5.com/help...images.htm
Citadel5 - Jan 16 at 4:12pm Copy Link
0
Citadel5 New features in GS-Calc 20.3:

Conditional cell formatting - the setFormatIf(reference, action, if_condition, format_true, format_false) formula.

Formats a given cell or a range of cells. The numeric action parameter specifies which formatting attributes to set or clear (restore defaults).
Usually, it's convenient to keep all the formatting functions in a separate worksheet. A single cell selection/value can control the appearances of other worksheets.
The function can be applied both to existing cells and empty regions without any previous formatting (and in this scenario the 1st update can be slightly slower).

There are no limitations for the number or complexity concerning this function.You can use millions of conditionally formatted cells or regions same as anyother formulas and nested IFs.

If the reference argument specifies entire columns or rows, the formatting action will be applied respectively to column and row styles. The formatting layers are as follows: a table style Custom Cell Styles" dialog box.

The 32nd action type sets all possible cell formatting/style attributes at once. Custom cell styles are added to a workbook with the Format > Custom Cell Styles dialog box and are saved in a workbook. Custom cell styles in a workbook can be saved to or loaded from a global GS-Calc cache using the Save As Default App Styles and Load Default App Styles commands in the Custom Cell Styles dialog box.

Examples:

setFormatIf(c120, 11, c120 > 0, "green", "red")
setFormatIf(c:e, 11, c120 > 0, "green", "red")
setFormatIf(10:20, 11, c120 > 0, "green", "red")
setFormatIf(c120, 20, c120 > 0, "all 2px solid green", "diag-left diag-right red")
setFormatIf(d100:d999, 1, c1="use format", "currency", 0)
setFormatIf(d99, 20, a1, "bottom 2px dotted green", -1)
setFormatIf(d99, 32, a10 > 10, "my-style-1", "my-style-2")
Citadel5 - Jan 16 at 4:16pm Copy Link
0
Citadel5 New features in GS-Calc 20.2: Replacing formulas automatically in worksheets. GS-Calc enables you to ("mass-") replace formulas automatically in worksheets. You can use this for example, to: instantly mass-modify/add/remove functions in formulas or some parameters/arguments used by functions in large workbooks without the risk of making mistakes in long formulas, replace existing functions with your own ones, replace in xlsx files some recently added functions, in general: converting formulas from any spreadsheet software using its own extensions. You can easily replace a given function by any other functions or expressions that uses some or all of the original parameters in any order, embed them in any other functions or expressions, mix this with cell references or constant values etc. In the first edit field you need to specify how the function look like in formulas. Replace actual parameters with subsequent letters a...z. In real formulas in your worksheet these parameters can be any expressions and nested functions, for example: VLOOKUP(a, b, c, d, e, f) TRIM(a)IF(a, b, c) IF(a, b, c) MATCH(a, b, c) In the second edit field you must specify the expression that will replace that function, for example: MY_VLOOKUP(abs(a) + 1, b, b100:b1000, e, d, 2) + 1 TRIM(a & " of" & d10) IF(a, b, IF(c < b, b, c)) * 2 MATCH(a, b, 0, 1, 1)
Citadel5 - Jan 16 at 4:23pm Copy Link
0
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Jan 18 at 12:11am Copy Link
0

On BitsDuJour Today

Sticky Password Premium (Mac & PC) Discount
Mac & PC
Sticky Password Premium
Never forget a password again.
100

Spreadsheet Editors Deals

Excel Merger PRO (PC) Discount
for PC
Excel Merger PRO
Easily Merge Spreadsheets and Workbooks Into One File
10
Advanced CSV Converter (PC) Discount
for PC
Advanced CSV Converter
A Hassle-Free Way to Convert Your CSV Files
25
DiffEngineX (PC) Discount
for PC
DiffEngineX
Compare and Contrast Excel Spreadsheets!
StatPlus (Mac & PC) Discount
Mac & PC
StatPlus
A Superior Statistical Analysis Suite
Like BitsDuJour on Facebook
BitsDuJour is for People who Love Software
Every day we review great Mac & PC apps, and get you discounts up to 100%
Follow Us
© Copyright 2024 BitsDuJour LLC. Code & Design. All Rights Reserved. Privacy Policy