Ask Slashdot: Spreadsheet With Decent Programming Language?

First time accepted submitter slartibartfastatp writes "Spreadsheets are very flexible tools for data analysis and transformations, the obvious options being MS Excel and LibreOffice. However, I found increasingly infuriating to deal with the VBA--dialect functions or (even worse) its translated versions. Is there any spreadsheet that allows usage of a decent programming language in its formulae? I found PySpread intriguing, but still very beta (judging from its latest release version 0.2.3). Perl or even javascript would be better options than =AVERAGE(). Do you know any viable alternatives?"

Comments

Just do it the other way around

[h4rr4r]

Instead of a spreadsheet with good programming just program and output a spreadsheet. CPAN has plenty of packages for this.

Re:Just do it the other way around

[hazem]

At the very least get them using a real DB and not VBA. Trust me you will be far better served in the long run.

The problem is in most organizations, IT is not responsive to requests to set up these kinds of databases. They especially don't deal with requests that are not precise and require a fast turn-around. Thus you end up with analysts and accountants using Excel and sometimes VBA because they can get the job done quickly and effectively.

And frankly, I don't want my accountants and analysts wasting their time creating databases and learning to write database applications. Their job is to be very good at accounting and analysis, not administering databases.

Definition

[wideBlueSkies]

What is the definition of a decent programming language?

It's a pretty ambiguous requirement.

C? Java? Python? Perl? Javascript?

Each is 'decent' in it's own way.

Another way to ask is this: What do you feel the shortcomings of the Excel VB language variant are?

Re:MS Offfice 2013 - Javascript apps

[Motard]

What, exactly is wrong with =AVERAGE()?

Re:Stop. Stop right now.

[MouseR]

Turning a spreadsheet into an application is not programming. It's being an accountant.

Re:Version numbers...

[Myopic]

Yes. I am advocating that version numbers should carry broadly-recognizable meaning. I accept your different opinion but I disagree with it.

In fact I think it would be silly for you to try to defend the suggestion that "version numbers should have no inherent meaning". None? Would you advocate that version numbers be non-sequential? After all, Mac OS 10.6 came after Mac OS 10.5, but maybe next they could release Mac OS 3.6, and then Mac OS 31.5, and then Mac OS -2, and then Mac OS Pi.

Of course version numbers carry meaning. They can't carry lots and lots of meaning, but they can carry a little bit. Why even bother with dotted-decimal version numbers if the dots and decimals mean nothing? Just use integers, but even monotonically increasing integers have "meaning" in that they convey directional advancement of the software. Likewise, if you use dates, dates carry meaning. Other than random numbers, it's difficult to imagine a version numbering scheme that has "no inherent meaning".

Re:My problem is quite the opposite.

[lgw]

No, Excel won because it was very much better .. at what the majority of users use spreadsheets for: keeping simple lists. Microsoft realized that early on and optimized for it. Excel is also terriffic these days as a simple graph-paper-oriented drawing program: make the cells square and you can outline and color quite easily. It also does a respectable job at turning a imple set of data into a pretty infographic-style graph.

Excels behavior as a tool for complex financial calculations is simple irrelevent for 99% of its users. It won because it was optimized for doing simple, visual stuff.