menu
Daily Bits Email

The email you entered is already receiving Daily Bits Emails!

PC
Today's DealsMost PopularFuture DealsExclusives
AudioBusiness & FinanceDesign, Photo & GraphicsDesktop Customization
DevelopmentHobby, Educational & FunInternetProductivity
SecurityUtilitiesVideo
Mac
Today's DealsMost PopularFuture DealsExclusives
AudioBusiness & FinanceDesign, Photo & GraphicsDesktop Customization
DevelopmentHobby, Educational & FunInternetProductivity
SecurityUtilitiesVideo

Virus Scan for GS-Calc

A Super Spreadsheet for All of Your Needs

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.

Our virus scan reports this website is 100% Clean View Deal

Website Malware/Phishing Scan - Citadel5

We've scanned citadel5.com using a variety of antivirus software and can bring you the following results.

Website 100% Clean Badges

Let your website visitors know that they can trust your download is 100% safe by using the following badges on your website.

GS-Calc Virus Scan Report
GS-Calc Virus Scan Report
GS-Calc Virus Scan Report
GS-Calc Virus Scan Report
GS-Calc Virus Scan Report
GS-Calc Virus Scan Report

What are people saying about GS-Calc
Dave Venus Will there be a combo deal to get both gs-calc and gs-base? Thanks!
Nov 1 2015 at 4:47pm Copy Link
0
Citadel5 @DaveVenus There are no such plans at the moment.
Citadel5 - Nov 2 2015 at 2:01am Copy Link
0
Ela S. Besides the wonderful small menu ribbon, what are the advantages using GS-Calc in comparison to MS Excel?
Nov 2 2015 at 4:49am Copy Link
0
Citadel5 @ElaS
Most of the "key" features are listed on citadel5, some in the review above, some are also shown on the screens on the left.
To name just a few: easily and quickly opening/processing files (workbooks, text files, dBase files etc.) containing more than 1 mln rows; lower memory usage for such large files; worksheets in (nested) folders; any number of worksheets in one workbook; no (formula type) limitations re: multi-core updating; up to 16 x- and y- axes on one chart (vs. 2); being fully portable.
May I ask what features would be helpful for you? All suggestions are always appreciated (and often implemented quite quickly).
Citadel5 - Nov 2 2015 at 6:39am Copy Link
1
Mariusz Lewandowski Thank you again for a great piece of software. But I have some installation problems here. I logged to your page, downloaded the purchased version, unfortunately, the wizard did not ask for validation code and my copy runs as 30-day demo. What went wrong?
And one more issue: menu Settings > Uninstall GSCalc ends with dialog message that my acct does not have permission to update the registry. Q(1) - why it plays with registry in portable mode? Q(2) - I'm logged as admin (Win7 64 Pro) so what kind of permission do I need?
TIA
Nov 4 2015 at 1:47am Copy Link
0
Citadel5 @Mariusz Lewandowski Thanks for your comment. Please note that you have to log via the form placed at the top of the page (which gives you access to full versions files).
Save the system uninstall string/entry in the default (non-portable) mode nothing is written to the registry but perhaps you later chose to register and use the scripting interfaces? If so, both registering and unregistering those interfaces (using the "Settings" commands) requires the "Run as administrator" Windows command.
Citadel5 - Nov 4 2015 at 3:23am Copy Link
1
Greg Are there any tutorial videos or other material that you have to help us come up to speed on doing statistical analysis with GS-Calc? Or do you have input on best resources to get some help on that from other places? Thanks in advance.
Nov 4 2015 at 7:19am Copy Link
2
Citadel5 @Greg Istered At the moment there are only descriptions/specifications of those functions (along with usage examples). In general, they should be expanded into separate help sections in (one of) the next release(s). Compiling some list of resources is also a thing to consider.
Citadel5 - Nov 4 2015 at 9:16am Copy Link
0
Kelly Hamblin Is there a Help file included, not online?
Nov 4 2015 at 11:48am Copy Link
0
Citadel5 @Kelly Hamblin Yes, the full help file is included.
Citadel5 - Nov 4 2015 at 12:16pm Copy Link
0
Kelly Hamblin Yes, thanks, found it. I downloaded the app and fooled around with it for a while. Had some troubles getting formatting to stick to a whole file, even setting it up, and I was unsuccessful getting it to calculate days between dates. App is nice though and maybe useful for others. When I have time, I will give gs-base a tryout. Thanks for letting me try gs-calcs.
Nov 4 2015 at 1:25pm Copy Link
0
Samir Desai Don't buy. I paid $9.98, and downloaded the software from the link I received in the email from BitsDuJour. However, that link was ONLY for 30-day trial software, not for the full version. On Citadel5 website, there is absolutely no way to download full version without paying. I installed the software, and tried to register it. There is no way to register the software because it is a 30-day trial software. The registration dialog tells me to pay *again* full price. This is crazy. Please, fix it. Thanks. Don't buy this software until Citadel5 makes it easy to register for BitsDuJour customers.
Nov 4 2015 at 1:49pm Copy Link
1
Constantin Florea @Samir Desai, I have just forwarded your comment to the vendor as he will be able to better help with the issue you mention.
BitsDuJour Admin - Nov 4 2015 at 1:51pm Copy Link
0
Citadel5 @Kelly Hamblin If you can't find something in the help, please feel free to post your questions on the support forum. Both formatting and date calculations are pretty easy and you can work with both serial date numbers and standard (iso 8601) date-time and period strings.
Citadel5 - Nov 4 2015 at 1:54pm Copy Link
0
Citadel5 @Samir Desai Before running this promo @Constantin Florea and I double- checked that the download instructions in the receipt are correct. And I think they are:

> To start downloading the full version, please browse
> here: http://www.citadel5.com and enter your e-mail
> address and the password from the receipt email
> into the top part of the page.

The login form for registered users is located on every page. After you log onto that page for registered users, you can download this full version and all future full versions for 12 months.
Citadel5 - Nov 4 2015 at 2:05pm Copy Link
0
J Hi Citadel5,

Your instructions are very clear, but within the BDJ Software Receipt email, there are two download buttons for the 32-bit and 64-bit 'Trial' versions.

That's what both Samir and I (and maybe others) found confusing.

The two download buttons should be removed from the BDJ email receipt. That would force the customer into following your instructions.

Thank you.
Nov 4 2015 at 2:48pm Copy Link
1
Glen Hilton Recommended to all. Regular improvements are made to this program and notifications are sent to registered users with the latest updates. The vendor is open to suggestions so all users can benefit. The standard cost and optional yearly update option is fair. Only wish there was a lifetime upgrade option.
Nov 4 2015 at 5:51pm Copy Link
1
Pavi Johnson @J, I got their other program (GS-Base). The full versions must be downloaded via a link which is sent after you purchase. The downloads from the Bitsdujour mail is a 30-day demo you should de-install first.

It's a bit annoying, but this is a quality vendor and makes very good programs!

Best, /Pavi
Nov 5 2015 at 12:06am Copy Link
0
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Nov 5 2015 at 12:11am Copy Link
0
Mariusz Lewandowski I have their GSBase, too. These both are phenomenal apps, fast and not so heavy as well known alternatives. I use them in portable installation -- highly recommended.
Nov 5 2015 at 12:41am Copy Link
0
Citadel5 @J Thanks for your suggestion. I was told that the trial version links have already been removed from the BDJ receipt.
Citadel5 - Nov 5 2015 at 2:32am Copy Link
0
Ela S. @Citadel5: Thanks for your early reply.

I would need the prog esp for easy data visualization (which in Excel 2013 has a high learning curve). Following a m comments, I feel that this could be more easily handled in GS-Cal, and than exported as XLS to Excel?

Your other product GS-Base looks great as well, so the BDJ page indicates "Deal Coming Soon!". Which date will this be?

http://www.bitsdujour.com...re/gs-base
Nov 5 2015 at 4:10am Copy Link
0
Constantin Florea @Ela S., I am sorry about the confusion. At the moment we do not have GS-Base scheduled to run. There seems to be an issue with the Deal Coming Soon! label since it appears for a promotion which is not yet scheduled. I just added this in our Issue Tracker.
BitsDuJour Admin - Nov 5 2015 at 4:28am Copy Link
0
J Hi Pavi. Thank you for your information and recommendation!

You are welcome, Citadel5.
Nov 5 2015 at 5:22am Copy Link
0
VLM Just a few points of clarification, please:

1. Can GS-Calc open Excel files directly? In other words, if a users makes GS-Calc the default application for the Excel file extensions, will that work?

2. Can GS-Calc save back to (any of) the Excel formats? The program may be wonderful to work in, but when working within a project team environment, many users might need to get their work back into Excel.

3. I'm away from my office logging in from someone else's computer, so I cannot download and test the program myself today. So I must ask ... does GS-Calc use classic menus, or does it only use one of those ribbon things?

4. Can a user define and/or redefine shortcuts pretty much without limitation? (For those who are wrist-impaired :)

Thank you!
Nov 5 2015 at 6:51am Copy Link
0
Citadel5 @ Ela S. Could you please e-mail me (via citadel5.com) some more detailed information concerning how you process the data and how you would like to improve this?
The term "data visualization" can be quite broad and - of course - GS-Calc can not compete directly that easily with a +500MB package on a feature-by-feature basis, so I would just need more information.
Regarding saving Excel files, please see my next post in a few minutes.
Citadel5 - Nov 5 2015 at 8:46am Copy Link
0
Citadel5 @ VLM

Ad. 1., 2.
As stated in the in the description, the data is saved to/load from Excel using the (supported natively) Open Document *.ods file format, not the *.xlsx format.
It makes no difference at the current level of the supported functionality and because both the Office Open and ODF formats have similar limitations re: - for example - the things mentioned above.

GS-Calc supports (a sort of legacy support) Excel XML which is an early release/version of the files included in the current *.xlsx zip's.
If there are no more important/interesting features to implement, I think it (that Excel XML support) should be upgraded in the upcoming weeks/months.

Ad. 3.
The enclosed screens show the current version - no ribbons. That is, a short survey among the users elicited that (at least several months ago) virtually no one voted for (adding) ribbons.

Ad. 4.
No. (Perhaps to some extent: shortcuts can be assigned to scripts, which can execute the commands.)
Citadel5 - Nov 5 2015 at 9:07am Copy Link
1
Per User Hi
I purchased two licenses and registered one instance of the software with success on a laptop.The bits-du-jour reciept state quantity 2 but only one login passwd., and when loggin in to Citadel5.com only one activation code is available.
Shall I use the same activation code on both computers? Thank you.
Nov 5 2015 at 1:16pm Copy Link
0
Citadel5 @Per User Yes. By default one e-mail address used for a given order is linked to one login password and one validation code.
If you would like to "split" your order and create a 2nd account on citadel5.com either with the same e-mail (and a different login password) or with a different e-mail and password, please e-mail the details to Citadel5.
Citadel5 - Nov 5 2015 at 1:58pm Copy Link
0
VLM Thank you! I guess I'm just unfamiliar with the open document formats. Does this mean that I have to make a special export from Excel to get a file into this program? This is important, because I work with MANY Excel files, some quite old but still in use.

Glad to hear no ribbons. I haven't met many people who like them.

Shortcut customization --- something to consider.
Nov 5 2015 at 2:07pm Copy Link
0
Citadel5 @ VLM If having very old Excel files implies that they have been used with some very old Excel versions, I would recommend evaluating GS-Calc and evaluating switching to GS-Calc fully or "nearly fully" for the time being (and perhaps using the 2nd native GS-Calc file format *.gsc - a really very fast and compact one).
In Excel you just need to choose the Open Document Format file type when saving.
Also, I'm not sure at the moment, but it seems the conversion (that is, saving in Excel) should be doable en masse with some scripting.
Citadel5 - Nov 5 2015 at 3:04pm Copy Link
0
J Hi Citadel5,

Feature Request:

Please make the 'Open File' and 'Save As' dialog boxes resizable.

They are too small to efficiently scroll through and locate files.

Thank you.
Nov 5 2015 at 7:59pm Copy Link
0
Citadel5 @J It'll be done in the next update. (Thanks.)
Citadel5 - Nov 5 2015 at 11:37pm Copy Link
1
VLM That's right, Excel CAN save to ODF, I forgot about that. Thanks for reminding me. Scripting ... do you mean using your scripting capability?
Nov 6 2015 at 1:18am Copy Link
0
Citadel5 @VLM No no, I meant scripting Excel (to save all those old (*.xls?) files to *.ods files at once).
Citadel5 - Nov 6 2015 at 1:44am Copy Link
0
J Wow! That's Service!

Thanks Citadel5!
Nov 6 2015 at 7:33am Copy Link
0
Bruno User Hello, I am very pleased already but I miss better search/replace (i.e. in ranges of columns or rows) and multiple selections of non-adjacent columns/rows.

First of all, GS-Calc is lightweight, and the worksheets tree is so much better than the usual tabs, in other software, are. I own both MS Excel and MS Works, and for many tasks, I use MS Works instead of bloated MS Excel, but MS Works is not lightweight, it is primitive, which GS-Calc is not, far from that, so at both 10 and 20 bucks, GS-Calc is a real treat, and I'll buy, to replace MS Works in my workflow.

Btw, GS-Calc lets you sort by 10 columns, MS Works by only 3, and that alone is worth the replacement, and csv import into GS-Calc worths smoothly. Also, search ("find") and "find-and-replace" in GS-Calc both work with regex (as well as the "regular" way of course), and its Pivot table functionality also should be mentioned here.

So there's lots of kudos to be addressed to GS-Calc and its developer, but then, I am very astonished that it does not seem to be possible yet to limit search / search-and-replace to a given range.

I tried with selecting a column, then did a search, and GS-Calc promptly found unwanted hits in non-selected columns, and it's evident this is lack of important functionality; I then tried with a selection of rows: the same unwanted (but now expected) result.

I (as said, unsuccessfully) tried with selecting columns/rows, but it's obvious I would much prefer to have it both ways, i.e. with (a) good search / search-and-replace dialogue(s), too, in which I could indicate the range(s) in a field, in the form of
R23-48
or
C1;C4-6;C8

It's evident that TWO fields instead, in order to combine the above indications, would be "ideal", but it also seems sensible to just implement one field, allowing for entering ranges of rows OR columns, since that's the functionality most people will really miss here.

Also, by my trying to select columns (then verified by selecting rows), I became aware that GS-Calc currently does not permit selecting non-neighbouring columns or rows, so the semicola in my second example would not work anyway, at current state of affairs.

Thus, at this time and for my specific workflow, GS-Calc has not yet enough functionality, and possibly the same applies to some other users, so I kindly ask you to consider filling the gaps described above.

Thank you very much!
Jul 17 2016 at 6:00am Copy Link
1
Citadel5 @Bruno
Thank you for your comments. There will be several significant updates within the upcoming months and these missing options (searching limited to the specified ranges and multiple selections) should be included as well.
Citadel5 - Jul 17 2016 at 4:15pm Copy Link
1
Bruno User Brilliant! Thank you so much!
Jul 17 2016 at 5:06pm Copy Link
0
Merle One Hi
Just purchased a license but I have not received it yet...
Jul 20 2016 at 6:36am Copy Link
0
Bruno User Would like to add that there currently is no filtering of rows, i.e. no functionality "display only those rows which meet current search". Hopefully, all this inter-related visual-data-analysis-with-no-or-few-formula functionality will come in one package.
Jul 20 2016 at 12:41pm Copy Link
0
Citadel5 @Bruno
Yes, as you can see on the support forum, this is what was originally planned to be available in June, however the updates were eventually rescheduled as I outlined above.
(Btw, filtering and processing of tabular data is one of the main features in GS-Base.)
Citadel5 - Jul 20 2016 at 2:47pm Copy Link
0
geo User @ Citadel5
I would like to ask what are the differences between GS-Calc and GS-Base.
I do have GS-Base and must comment you on a really good product and excellent support.
Thanks for your reply,
Jul 21 2016 at 1:33pm Copy Link
0
Citadel5 @geo User
GS-Base is a database. It does have a similar set of built-in (calculation) functions that can be used in calculated fields thus the GS-Base table view (one of the three view types in GS-Base) may act and look like a worksheet with tabular data and with ("lookup") links between tables.
Otherwise (aside from some similar interface elements) both programs have different major features.
Citadel5 - Jul 21 2016 at 3:27pm Copy Link
0
Bruno User There has been a spin-off of this GS-Calc discussion some days later over at the GS-Base sale in which parties interested in GS-Calc might be interested in. But they should also read the "closing comment" to that discussion 3 weeks later: A spreadsheet (and this includes the "powerhouse" MS Excel, too!) is not a csv editor and should not be mistreated as one, so any possible limitations in "text crunching" respects of any spreadsheet should not be imputed to the spreadsheet, but only to your choice of the "bad", i.e. not optimized for the task, software category:

http://www.bitsdujour.com...ents123522 (and previous there, on July 28, 2016)
Aug 19 2016 at 3:52am Copy Link
0
Gunderic Hagen I was about to buy this app. until I read the FINE PRINT which says it is sold per computer. That means, I can only download it either to my PC or laptop, but NOT both. Sorry, I don't buy any app. with this limitation.
Jun 22 2017 at 1:11am Copy Link
0
Citadel5 @Gunderic Hagen
Actually, it's the opposite - you can use/install it on both your pc and laptop at the same time. (Installing it on an USB pen drive is another option.)
Citadel5 - Jun 22 2017 at 3:28am Copy Link
0
Gunderic Hagen What about the Fine print?

- GS-Calc is licensed per computer, and not per user.

Why do you still have this condition if you are not enforcing it???
Jun 22 2017 at 3:43am Copy Link
0
Citadel5 @Gunderic Hagen
There is also:
"Each license allows installation on a single computer and a laptop."

The "Fine Print" section here is a set of predefined options to choose from. It's the closest to "per user's pc-laptop two computer set".
Citadel5 - Jun 22 2017 at 4:07am Copy Link
0
Gunderic Hagen OK. What you are saying is that I will be able to use the same licence to download the app. on my PC AND laptop?

What is the deal with downloading it to a USB? I can also use this option, PLUS download it to may PC and my laptop?
Jun 22 2017 at 5:12am Copy Link
0
Citadel5 @Gunderic Hagen
Yes, that's correct. "And".

Not "downloading it to a USB" but "installing it on an USB pen drive", so plugging it to your current computer (and unplugging) will allow you to use it without another installation.

(Though, of course, making a backup copy of the setup exe on a pen drive is also a good idea itself.)
Citadel5 - Jun 22 2017 at 7:21am Copy Link
0
Gunderic Hagen Very well. I will buy then the app. BTW, GH is only my nome the plume...

I strongly urge you to review your Fine Print, as you have there conflicting statements....Bad for business.
Jun 22 2017 at 7:41am Copy Link
0
Citadel5 @Gunderic Hagen

To download the full version, you need to log onto the download page using the form at top of citadel5.com. Your C******** login password is included in your order confirmation e-mail.

The recommended setup folder is in the "User/your_name" folder for all programs installed locally in your Windows account. You should not change it to any other system folder (especially if the Windows account you're using doesn't have the write permission for it and the setup can't be completed).
Citadel5 - Jun 22 2017 at 8:43am Copy Link
0
Gunderic Hagen I do not find any form; I continue getting the same screen with the trial versions.... Which other download page you refer to???

Why is this process so complicated? I see also I am not the only one bumping into similar problems. If this is so complicated, I will be forced to request a refund.
Jun 22 2017 at 8:58am Copy Link
0
Citadel5 @Gunderic Hagen
As you noted, it's fully explained in one of the older comments (and in the order confirmation message, for that matter). The form consisting of two fields "e-mail" and "password" and the "Login" button is located at the top of each page on citadel5.com.

After you save the full version setup exe and your unique setup code you won't
need to log/re-download it again to install or to reinstall it till there is some new version available.
Citadel5 - Jun 22 2017 at 9:16am Copy Link
0
Roberto Excellent software.
Jun 22 2017 at 3:12pm Copy Link
0
Robert User CAUTION Potential Purchasers.

There are two options for this purchase. One is at $9.98 (50% off), with 1 year of upgrades. The other is $18, with lifetime of upgrades. After purchasing the Lifetime Upgrades edition, the e-mail sent with the license code states something entirely different. It states:
"You can install/register the software at any time. Upgrades to future versions of the software will be free for 12 months. For versions after that, upgrades will require additional payment, which will be discounted by 50%."

That doesn't seem fair to do a bait-and-switch. The e-mail received is very important, and is the proof of a particular purchase at agreed on terms. I would like to see this e-mail re-sent with correct wording, and corrected for future purchasers.
Jun 22 2017 at 6:16pm Copy Link
1
Gunderic Hagen I should have asked this before purchasing, but anyway, here it is:

Can you kindly tell me, how is this app better than Excel? Why should I use your app instead of Excel?
Jun 22 2017 at 10:02pm Copy Link
0
Constantin Florea @Robert User, I am sorry about the confusion. The lifetime upgrades version does have lifetime upgrades. It is true that the license policy from the promotion page is sent for all purchased products in that promotion (and that can be considered a bug) but the license policy in the promotion page is only meant to be valid for the first item in the promotion.
BitsDuJour Admin - Jun 22 2017 at 10:36pm Copy Link
0
Gunderic Hagen Can I expect Citadel5 to address my previous question?
Jun 22 2017 at 11:40pm Copy Link
0
Citadel5 @Gunderic Hagen
Please see a similar question and the answer posted here:
http://www.bitsdujour.com...tId=108410

You may also take a look at the latest updates:
http://forum-eng.citadel5...?f=7&t=554
http://forum-eng.citadel5...?f=7&t=557

Also, some user's post concerning using large text files in GS-Base, but this aspect (loading times) also applies to GS-Calc:
http://forum-eng.citadel5...f=13&t=556
Citadel5 - Jun 23 2017 at 1:48am Copy Link
0
Gunderic Hagen The first link you post does not bring up the info I'm looking. You can read: "We did not find anything that matched your search for "gs galc 2", but check out these new deals!" (are you aware of this?).

Would you kindly cut and paste brief information about the differences between Excel and your app.? I assume you have some bullet points depicting the benefits...

I risk saying that pointing out why is your app better/more convenient to use than Excel would be of great interest to any potential buyer and will surely help your sales efforts.
Jun 23 2017 at 2:11am Copy Link
0
Citadel5 @ Gunderic Hagen
Sorry, there was a typo in the link. (gs-galc -> gs-calc)

http://www.bitsdujour.com...tId=108410

Or simply please click "Load older comments" at the top of the this section.
Citadel5 - Jun 23 2017 at 4:47am Copy Link
0
Daniel User Hi, I just bought and installed GS-Calc because it addresses a need that just came up yesterday.

I needed an app that can display a CSV file that has 900 columns of data. I currently only have a very old copy of Excel that only supports 256 columns.

I got the data in the spreadsheet, but I want to resize each column so all the data is visible. In Excel, I can click on a range of columns and double-click on the divider between two columns and they all resize.

GS-Calc seems to only resize one column at a time. I don't want to repeat this 900 times. Is there anyway to resize all the columns in one action?
Jun 23 2017 at 10:43am Copy Link
0
Citadel5 @Daniel
You can either (1) click some row heading (to select the whole column range) and use the "Format > Auto Column Width" command or (2) check the "Settings > Options > General > Auto-fit column widths in imported files" option (which applies to text and xBase files).
Citadel5 - Jun 23 2017 at 11:06am Copy Link
0
Mappi75 Any new deals planned ?
Oct 6 2017 at 7:28am Copy Link
0
Citadel5 @Mappi75
The license version with free upgrades for 12 months costs $19.95.
The license version with life-time free upgrades costs $36.00.

This $9.95 50%-off promotion here concerns of course the first variant.

At any point in the future (and there are no plans to give up life-time upgrades within the next year), if you think it's worth it, you can upgrade to the life-time-free-upgrades license @50% off.

I'm not sure about the confusion you mentioned, but there have never been "not real" free life-time upgrades.
Citadel5 - Dec 3 2017 at 9:47am Copy Link
1
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Dec 7 2017 at 12:11am Copy Link
0
PortablesFan I've bought both of your programs here at BdJ before--can I do a 50%-off lifetime license for the "pack" of both of them?
If so, how? Am I supposed to have a link or a coupon code somewhere?
Thanks!
Dec 7 2017 at 2:37pm Copy Link
0
Citadel5 @PortablesFan
Sure, please e-mail Citadel5 for your 50%-off rebate code.
Citadel5 - Dec 7 2017 at 3:10pm Copy Link
0
John H Will this work On Linux under WINE?
Jul 14 2018 at 12:59pm Copy Link
0
Citadel5 @John H
Yes, GS-Calc works with Wine.
Citadel5 - Jul 16 2018 at 4:34am Copy Link
0
ciprian Hi, will a lifetime license be available as it was the case with GS database?
Nov 12 2018 at 3:01pm Copy Link
1
Praveen "v16.8.4 Mac & PC"

I was only able to find a link to the PC version on your website.

Is there a Mac version, or is that a typo?
Nov 13 2018 at 4:03pm Copy Link
0
Citadel5 Citadel5 @ciprian
Hi, yes, that option has just been added.
Citadel5 - Nov 13 2018 at 5:07pm Copy Link
1
Citadel5 Citadel5 @Praveen User
The above is a typo on this page. Should be corrected soon.
Citadel5 - Nov 13 2018 at 5:13pm Copy Link
0
CL I had a 1 year license to GS-Calc - Is there a discount to upgrade to Lifetime License or do I pay for the Full Lifetime Upgrade price ($27).
Nov 15 2018 at 6:30am Copy Link
0
wts Shouldn't Lifetime Upgrade be $18, which is 50% of the price on the Citadel5 site? I bought the GS-Base Lifetime Upgrade on the recent BDJ offer for $18 which was 50% of the price on Citadel5, same lifetime price as GS-Calc. Thanks.
Nov 15 2018 at 9:07am Copy Link
0
Citadel5 @ CL
All licenses are lifetime. Yes, if you purchased the one with free upgrades for one year, you can upgrade to the license with free lifetime upgrades at any moment (e.g. when you think the added features already justify this) @50% off ($US18.00).
Citadel5 - Nov 15 2018 at 10:04am Copy Link
0
Citadel5 @wt
As opposed to GS-Base, GS-Calc has always been available @BDJ without the free-lifetime-upgrades option. This time it was added, though it's 25% off. It's approx. equal to the total amount a user would pay purchasing a license with free one year upgrades ($9.98) and then upgrading in the future ($18.00).
Citadel5 - Nov 15 2018 at 10:07am Copy Link
0
CL How do I go about upgrading my GS-Calc (yearly) to Lifetime Upgrade for $18.00?
I would like to upgrade to Lifetime.
Nov 15 2018 at 12:21pm Copy Link
0
Citadel5 @ CL
When the program is updated, you receive an email notification with details re: changes/new features/fixes. If your free-upgrade period ended, you also receive a rebate code.
Otherwise you can contact Citadel5 to receive that rebate code at any time.
Citadel5 - Nov 15 2018 at 12:55pm Copy Link
0
CL Thanks You. I have submitted a request for the rebate code.
Nov 15 2018 at 1:06pm Copy Link
0
wts I requested an $18 lifetime upgrade rebate code via info@citadel5, received it within 15 minutes, and applied it successfully. Excellent response. Thank you.
Nov 15 2018 at 3:01pm Copy Link
0
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Nov 16 2018 at 12:11am Copy Link
0
K Anderson Bruno User had asked about an issue he had:
multiple selections of non-adjacent columns/rows

For example: select columns A, D, H
or select rows 1, 5, 23

Has this been implemented?

If it has, could you explain how to do it.
Thanks
May 21 2019 at 1:17pm Copy Link
0
Citadel5 Hi,
Multiple selection is not yet available.
Citadel5 - May 21 2019 at 2:27pm Copy Link
0
Citadel5 Hi,

Thanks for viewing this promotion. I thought that outlining some of the
GS-Calc distinctive features might be helpful as there were recurring
questions about this in the past:

* 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 in 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.

* 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
https://citadel5.com/images/bin_rows.png
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.

If you have any questions/suggestions, please feel free to ask here, via e-mail
or on the support forum.
Citadel5 - Apr 2 2020 at 2:14am Copy Link
0
David User Incredible software, at such a low price...personally its a bit more than what I need, but all of citadel5's work is legendary.
I have a license for their other big title, GS-Base, and I just can't stress enough what an incredible VALUE each of them are.

Thanks guys!
Apr 2 2020 at 9:02pm Copy Link
1
Citadel5 @David User Thank you for your kind comments.
Citadel5 - Apr 3 2020 at 4:46am Copy Link
0
Keith User The BitsDuJour receipt e-mail mentions "enter your e-mail address and the password from the receipt email" in order to download a registered version. Should I be expecting a separate e-mail message, one from Citadel? If so, I ordered early yesterday and still have not received that message.
Apr 3 2020 at 5:09am Copy Link
1
Citadel5 @ Keith User
BDJ informed me that there was some unexpected issue with (most likely) their server sending the e-mail addresses for automatic registration to Citadel5. It never happened before and I can't tell when they'll identify the issue (and re-send their receipts). At the moment Citadel5 is gradually performing "manual" registrations and sending registration e-mails to users after receiving the order data (e-mail addresses) by plain e-mails from BDJ. Sorry about the issue and thank you for your patience.
Citadel5 - Apr 3 2020 at 6:05am Copy Link
1
Steven Aves Very good software and quick tech support response.
Sep 23 2020 at 5:54am Copy Link
0
Mustang Is there a way to change the default workbook format like in Excel?
Sep 23 2020 at 9:33am Copy Link
0
Citadel5 @Mustang
If you mean the file format, you can define it during the setup or later in the "Options" menu.
As far as the default workbook cell format/style is concerned, you can change any element of it in the "Format > Style Palette" (for both new and existing workbooks).
Citadel5 - Sep 23 2020 at 10:59am Copy Link
0
Mustang "As far as the default workbook cell format/style is concerned, you can change any element of it in the "Format > Style Palette" (for both new and existing workbooks)."
In the Excel options menu, you can set the default font type and size for a new workbook. I found no similar such option in GS-Calc other than to reformat individual or blocks of cells. Not ideal to have to perform this operation every time I create a new workbook.
Sep 23 2020 at 11:13am Copy Link
0
Citadel5 @Mustang
Like I wrote, you can change any element of the default style for a new or existing workbook in the "Format > Style Palette" dialog box.
Similarly, you can also redefine any style on the list of styles/formats used in a workbook.
Citadel5 - Sep 23 2020 at 11:24am Copy Link
1
naveed How does this differ from excel and Google sheets?
Feb 17 2021 at 8:33am Copy Link
0
Citadel5 @naveed Some list of such features was posted here during the previous promotion, in April, over a year ago. I refreshed the list and included it below.

* 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 in 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. Functions can process graphics in cells.

* 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
Aside from the OpenDocument file format GS-Calc also offers a native binary format. Thanks to 2d data compression and then zipping it can generate very small files for very large workbooks. 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
https://citadel5.com/images/bin_rows.png
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 billions.

* Pivot tables can be used both as formulas and in separates view panes (with the same max. number of rows and columns as worksheets). Pivot data snapshots.

* Easy to use, built-in Monte Carlo simulations.

Perhaps there is also a number of other things that should/could be distinctive features, though I'm not sure how much has changed in the latest versions of the software you mentioned. E.g. displaying automatic chart error bars for the log scales or showing data picks in very large chart data series.
Citadel5 - Feb 17 2021 at 9:56am Copy Link
1
Steven Aves I can share my experience. GS-Calc is faster than Google sheets and not bloated like Excel, unless you need lots of what Excel offers.

I've found it easy to work with plus it is on my computer - My data.

It plays nice with GS-Base too.
Feb 18 2021 at 7:16am Copy Link
0
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Feb 19 2021 at 12:11am Copy Link
0
John Bartow Can it open or import excel spreadsheets(xlsx)?
Oct 20 2021 at 11:51am Copy Link
0
Citadel5 You can import/export to/from Excel using the *.ods format. It'll transfer all the functionality that can be exchanged as 1:1. There is also the older Excel *.xml format which is sort of pre-xlsx format but it's less convenient.
The *.xlsx format is not yet supported.
Citadel5 - Oct 20 2021 at 3:37pm Copy Link
0
Pete User If I have the latest version of Excel, what capabilities am I missing that GS-Calc has?
Apr 14 2022 at 10:56am Copy Link
0
Citadel5 Hi, Some list of such features was posted here on the
[Citadel5] - Feb 17 2021 at 9:56am
https://www.bitsdujour.co...tId=154903

Also, please see the recent forum announcements - those options work out of the box. Perhaps some advantage might be that (some) users' suggestions can be implemented rather quickly, e.g. in terms of weeks.

Of course, some functions will be "simplified" or absent in GS-Calc.
The setup file size proportion is like 4MB vs GB(s).
Citadel5 - Apr 14 2022 at 12:25pm Copy Link
0
Pete User What file formats is GS-Calc compatible with: (a) XLS, (b) XLSX
Can it import and export in those formats?
(I do like the small file size of the program)
Apr 14 2022 at 12:58pm Copy Link
0
Citadel5 At the moment the data can be exchanged in the Open Document *.ods format though using it as the default format in GS-Calc means some native features (if used) won't be saved (a detailed report/info is displayed prior to saving in such cases).
The upcoming GS-Base (https://www.bitsdujour.co.../gs-base-2) update
will be also using *.xls and I believe *.xlsx should appear in GS-Calc in the near
future.
Citadel5 - Apr 14 2022 at 2:16pm Copy Link
0
Pete User If I purchase today, will the *.xls and *.xlsx be part of my "free" upgrades?
Apr 14 2022 at 3:08pm Copy Link
0
Citadel5 I hope it's going to be much faster than 12 months, if this is what you mean.
Aside from that, upgrades are free for one year or lifetime free no matter what changes are implemented.
Citadel5 - Apr 14 2022 at 5:15pm Copy Link
0
Pete User Thanks. I will come back when the *.xls and *.xlsx import/export have been implemented.
Apr 14 2022 at 10:30pm Copy Link
0
Roberto Grab the lifetime Pete. It's worth it.
Apr 15 2022 at 12:54am Copy Link
1
Steven Aves Pete, I concur with Roberto.
Apr 15 2022 at 6:09am Copy Link
0
naveed Is there a way to filter the rows like in Excel?
Sep 8 2022 at 12:34pm Copy Link
0
Citadel5 Hi,
The objective was to make it way more versatile than "like in Excel", though it's an option added several days ago so still waiting for some broader feedback. You can take a look at the specification included above:
https://citadel5.com/gs-calc-18.1.htm
Citadel5 - Sep 8 2022 at 1:02pm Copy Link
0
naveed What I'm looking for is the ability to filter rows by certain values. In your example screenshot, say two job titles. I'd like to be able to check/uncheck the job titles I want to see. Regex has it's place but it takes time to write.
Sep 8 2022 at 3:04pm Copy Link
0
Citadel5 Two job titles or one address :-) from a few millions, it's equally fast and easy. For example:
enter, ac|ag, enter
Two or three seconds to find account managers and sales agents, I guess.
And if you want to find all jobs re: sales, you don't have to drill down through a list of various check boxes. Not to mention any longer lists.

Also, the FILTER() array filtered results can be used in any further processing in any function without any tricks (which take time to apply).
Citadel5 - Sep 8 2022 at 3:51pm Copy Link
1
fpi fpi The current 64 bits version is 18.3.1 (January 15, 2023), not 18.2.3
Jan 17 2023 at 3:35am Copy Link
0
Raymond User How strong is the query ability to parse a CSV cell value? This database is NOT the most well designed and some values have MANY pieces of information. For example, the address is all together - Number street city state zip and I need to pull out just certain Zip code values...... Can this be done with this software?

Thanks!!!
Jan 17 2023 at 12:44pm Copy Link
0
Citadel5 If you mean extracting and converting the data, there are several methods to do this:

1. The most versatile are ("industry standard") regular expressions. They can be used directly with the "Find and Replace" toolbar.
In both GS-Base and GS-Calc you can also create named series of such "Find and Replace" actions in the "Find and Replace Scripts" dialog box to do predefined transformations in one pass and with a one click.

Sample (F&R) "Scripts" window:
https://citadel5.com/help...cripts.png

The online "Find and Replace" help page:
https://citadel5.com/help...eplace.htm

You can find about every pattern you might need using Google searches. Using your zip example:
extracting+zip+from+strings+using+regular+expressions

2. Formulas. For example, the Find() formula in GS-Calc that will enable you to use regular expressions and returns matching patterns or their positions.

3. The "Copy with Options" and "Paste with Options" commands which let you switch between cell separators and split the data.

4. The "Edit > Split / Merge Cells" commands which will do the above in-place ad let you use strings of any lengths as separators.


If you mean filtering only, again regular expressions can be used and the above information apply as well both to various F&R methods and to the FILTER() functions:

https://citadel5.com/help...tering.htm

Filtering is quite fast. A few millions of rows should be filtered almost instantly.
Citadel5 - Jan 17 2023 at 3:07pm Copy Link
0
Raymond User Thank you!!! Great support and spot on!!! :)
Jan 17 2023 at 4:26pm Copy Link
0
bai bai I tried v18.3, there are two things I want to know.

1. input method support.
If I use english input, there is no problem. But when I use other input method such as Chinese input method, gs-calc will receive the first character only unless I use "Enter" key to input text in edit mode.

2. filter
I read all the documents about filter feature. But I can't use it correctly, my filter fomula always give me a "#value" error output.

The dataset is {1,2,3,4,5,6,7,8}, the filter rule is "greater than 5", the output will {6,7,8}. I don't use hyperlink feature, Could you show me a correct filter fomula?
Jan 17 2023 at 5:06pm Copy Link
0
Citadel5 @bai bai
1. Completing editing with the Enter key is the default method. Do you mean clicking the check icon near the edited cell?

2. It looks that for a single column the composer incorrectly created a cell reference instead of a (even 1x1) range reference and it had to be corrected manually. It's been corrected in the build 18.3.1.3. You can already download it. (Thanks for reporting this.)
Citadel5 - Jan 17 2023 at 6:34pm Copy Link
0
Nico Westerdale Great News! Citadel5 has agreed to extend this deal for another day - Enjoy!
BitsDuJour Admin - Jan 18 2023 at 12:11am Copy Link
0
bai bai @Citadel5

Thank you for the reply. I mean inputing characters directly when I didn't enter the editing mode. In english input method, I can input characters correctly. But when I use Chinese input method or other input method, it will popup a inputbox and gs-calc only accept the first charater.

You can try to use Chinese input method to confirm.
Jan 18 2023 at 6:07am Copy Link
0
Citadel5 Please see the online Help page re: the Unicode characters:
https://citadel5.com/help...nicode.htm
All three methods seem to work correctly with Chinese characters. The 3rd one also initiates the edit mode without pressing Enter/F2.
Citadel5 - Jan 18 2023 at 7:00am Copy Link
0
Alexandre Emeriau Hi, We can create DLL libraries with GS-Calc.
Can we then call functions in the dll from C# for example ?
Jan 18 2023 at 8:45am Copy Link
0
Citadel5 @Alexandre Emeriau
This description is already available via the support forum, but I'll add it here as well just in case:

Sure, you can write in DLL's not only any number of new functions (without any performance issues) but also you can replace existing built-in functions simply using the same names.
They are written in C++/C. They accept the same parameter types as the built-in functions, and they participate in the multi-core calculation chains same as the built-in functions so all in all it's exactly the same best performance as for the built-in functions.

They can return the same data types as the standard functions, including arrays (which has been available in GS-Calc for years and which MS introduced in their latest Excel 365, calling it "spilling").

Additionally, your functions can return:
* Images (either as handles to the bitmap data or file paths to display) that
are aligned to the upper-left corner of a given formula cell and can be shrunk to
fit the cell dimensions or expanded within the rest of the worksheet;
* Messages (for example, a conditional If.MessageBox()) which are - of course - all displayed after completing the recalculation/update.

Sample code is available on the forum. For example, the custom Image(...) function is only several lines long.
https://forum-eng.citadel...m.php?f=17
Citadel5 - Jan 18 2023 at 11:31am Copy Link
0
Steven Aves Excellent spreadsheet. Very responsive support.
You can't go wrong at just $10.
Sep 27 2023 at 5:36am Copy Link
1
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


Our virus scan reports this website is 100% Clean View Deal



BitsDuJour is for People who Love Software
Every day we review great Mac & PC apps, and get you discounts up to 100%
Deals
Software Download Deals Free Software Download Popular Deals Past Deals About our Giveaways
Communication
Daily Bits Suggestions Blog Recent Activity
Company
Contact About Link to Us Affiliate Program Promote Your Software
Follow Us
BitsDuJour on Facebook BitsDuJour on Twitter BitsDuJour on Google + BitsDuJour RSS Feed
© Copyright 2024 BitsDuJour LLC. Code & Design. All Rights Reserved. Privacy Policy