Feature proposal: new program operations

[Andrés C. González]

Hi,

I finally could build TreeSheets on my platform (and I realize that my last message probably didn't make much sense, sorry about that).

I am interested in the "program" functionality, and in extending the available operations.

For example, I am thinking of a submatrix operation (please, see attached image).

Is that interesting for the project? Do you have any suggestions for other possible operations?

Thank you,

--

Andrés González, SJ

LinkedIn | GitHub | Blog

[Wouter van Oortmerssen]

I am interested in the "program" functionality, and in extending the available operations.

That be cool!

 

For example, I am thinking of a submatrix operation (please, see attached image).

Is that interesting for the project? Do you have any suggestions for other possible operations?

Hmm.. your suggested interface seems a bit too.. technical, in that it it is not very intuitive to read.

I wonder if it can be made simpler by instead having operations drop a row or column?

I am not sure what should all be added, likely it would be good to look at what are the most frequent operations people do in Excel.

I already added "sum", we could probably use "average" an others.

Rather than making this a full programming language where it takes many operations to do something, I'd be in favor of a design where few powerful operations do common things you want in a spreadsheet. Hence, "average", which can also be done by a combination of "sum", "count" and "/", but that is much clumsier.

[Andrés C. González]

Hmm.. your suggested interface seems a bit too.. technical, in that it it is not very intuitive to read.

I wonder if it can be made simpler by instead having operations drop a row or column?

Yes, a simpler interface sounds good. I am thinking about the following operations: top, bottom, right, and left. Each one extracts a given number of rows or columns (see image example).

Would a pull request with those operations be acceptable, as a first step?