GS-Calc 21.4 has been released

GS-Calc GS-Calc Updates
1

GS-Calc 21.4 introduces initial Python integration in GS-Calc and fixes three problems listed below:

Using Python functions as UDF()

Using the built-in UDF() (user-defined-) function you can call any Python modules/functions in formulas in GS-Calc.
This can help you to significantly increase GS-Calc functionality thanks to the large number of various Python modules and libraries including, for example, science, finance, graphics.

(Note: The new Python UDF() functions replace the previous UDF() that was based on system automation servers registered in Windows and had very limited use.)

From GS-Calc you can pass to Python functions any type of parameters: (double precision) numbers, text strings, ranges as numeric arrays/matrices, automatically saved blocks of CSV data from ranges.

GS-Calc can accept from Python functions any type of data it supports in formulas: (double precision) numbers, text strings, numeric arrays/matrices, 2d arrays of any size and with any cell contents passed to GS-Calc as CSV data blocks to parse and finally images/graphics (that can overflow the formula cells).

The UDF() function:

UDF(module, function, type, parameter1, parameter2, …)

  • module - Python module name with full path, for example “c:\my_modules\some_functions”

  • function - function name as it appear in the above module, for example “my_function”

  • type - an index (0-5) specifying what type of data GS-Calc should expect from the Python procedure. Possible values are:

    • 0 - a number

    • 1 - a matrix/array of numbers

    • 2 - a text string (up to 1024 characters)

    • 3 - a string/block of CSV data (of any size) to be pasted without parsing numbers in cells

    • 4 - a string/block of CSV data (of any size) to be pasted with parsing numbers in cells

    • 5 - an image (binary data returned as standard Python “memoryview” binary data)

    Additionally, you can add to the “type” parameter the following flags:
    32 - all ranges/arrays passed from GS-Calc to Python will be saved and pass to Python as blocks/strings of CSV data
    64 - same as 32 except that CSV data is created and pass instead of an array only if there any non-numeric/text cells within that GS-Calc range/array.
    If neither 32 nor 64 is used, if you specify a range as a parameter in the UDF() function, GS-Calc will pass it as an array of numbers ignoring any text data. Rules used to save and parse such CSV data blocks are the same as for handling regular CSV files in GS-Calc.

Python modules are plain text files with the "*.py" extension. Below is an example of such a file containing seven simple functions.

e:\example.py :

def function1():
return 10

def function2(a, b):
return a + b

def function3(text):
return ‘A new text with ’ + text + ’ inserted in the middle’

def function4():
csvdata = ‘abc,def,ghi\n123,456,789’
return csvdata

def function5(csvdata):
return csvdata

def function6(csvFilePath):
f = open(csvFilePath, ‘rb’)
file_content = f.read()
f.close()
return file_content

def function7(imageFilePath):
f = open(imageFilePath, ‘rb’)
file_content = f.read()
f.close()
return bytearray(file_content)

In GS-Calc the above functions can be use as follows:

Installing Python and integrating it with GS-Calc

You can download the standard Python package, among others, from Microsoft Store or directly from the Python project home page.

You must specify which Python version you would like to use with GS-Calc, selecting a given version in GS-Calc in the "Settings > Options > General" dialog box.

Unless you already have Windows system variables pointed to the Python installation folder, in the "Settings > Options > General" dialog box you must also specify the folder where the Python core library DLL (for example python39.dll for the selected version 3.9) file is located.

Note: At the moment this initial version comes with the Python 3.9 support. Subsequent version should be added later as the bundled small gsc2pythonXX.dll proxy modules.

*
*507×574 12 KB


GS-Calc 21.5 21.5.1 - update - 2025-02-08

GS-Calc 21.5 adds newer Python version support in GS-Calc and fixes a
problem related to saving Excel xlsx files when sheets have cells with borders/frames defined.

GS-Calc 21.5.1 fixes a problem for large pivot tables: if they were saved in the bottom pane it could cause crashes. (Pivot tables used directly in sheets are not affected.)