The GS-Calc application was developed to be a small, fast and portable all-purpose spreadsheet that will help you to better organize your data. Track your expenses and incomes, create reports, search and edit databases, perform statistical calculations.
GS-Calc does the job quickly, easily and efficiently. GS-Calc supports ODF natively.
Here are some key features of "GS-Calc":
· 12 mln rows x 4,096 columns.
· ODF spreadsheet format as the default file format.
· Around 300 built-in formulas including specialized numerical functions: matrix operations and decompositions (LU, Cholesky, SVD);
· linear equation sets;
· with Gauss and Cholesky methods and improving iterations;
· least squares (weighted, constrained), regression with orthogonal polynomials;
· time series analysis;
· minimization;
· linear, integer and quadratic programming.
· Array formulas and 3D-formulas;
· UDF functions accepting and returning arrays.
· Workbooks containing any number of hierarchically organized worksheets.
· Multi-pane worksheet windows with up to 100 freely sync views;
· advanced sync options.
· 2D/XY and 3D charts capable of handling very large amount of data.
· Hidden formulas and cells excluded from printing. Printing watermarks.
· Strong password protection and encryption; password-protecting workbook structures and individual cells.
· Dual COM interfaces enabling you to use GS-Calc functionality in your own applications.
· Standard editing and formatting tools and options; optional Excel-, OpenFormula- and GoogleDocs-compatible formula syntax, predefined numeric styles and user-defined styles.
· Clean installation (no registry entries are required); optional fully portable setup.
· Saving workbooks to PDF: saving entire workbooks (with the worksheet tree structure preserved), single worksheets, pages, ranges and single charts; very small output files.
· Importing, exporting and editing text, dBase III-IV, Clipper, FoxPro 2.x and Excel 2003 XML files
Limitations:
· Printing the first page only and up to 15 worksheets in one workbook
· 30 days evaluation period
What's New in This Release: [ read full changelog ]
New features and changes:
· The match(), vlookup() and hlookup() functions now accept negative values of the "startFrom" and "occurrence" parameters. The positive "startFrom" parameter denotes the start search cell and the negative value denotes the end/stop cell. The negative "occurrence" parameter triggers bottom-up searches.
· Examples of the match(), vlookup() and hlookup() functions using the SEARCH::AutoSort (used to perform fast searches for unsorted data) flag are now included in the sample.ods file.
Bug fixes:
· Crashing when pasting after copying data with the "Edit > Advanced Copy Options > Copy & Transpose / Reverse" commands.
· A bug concerning exporting files in the Excel XML format (preventing some Excel versions from opening them).
· [The optional "extended-parameter" syntax was not available for the hLookUp() function.
· The SEARCH::AutoSort flag was not available for the vLookUp() function despite the help file stating otherwise.
· The "percentage" style behavior was in...
Find us on Google+
