Spreadsheet Behavior

ricardorauber

With this suggestion, all developers (begginer or not) can use simple spreadsheets as tables of data or even arrays.

It can be called "Spreadsheet" and will always work with text values. The behavior will have these parameters:

- Name: The name of the spreadsheet (something like the key on load/save attribute that must be unique)
- Line: Line number of the cell
- Column: Column number of the cell
- Value: Value of the cell

Is that simple!

Behind the UI, it can be an array[][] of string.

Everyone knows how to use Apple Numbers or MS Excel and with this behavior will be easy to understand.

I think it's a great idea!

--- EXAMPLE ---

The "items" spreadsheet will have information about my weapons:

- Name: "items"
- Line: 1
- Column: 1
- Value: "knife"

- Name: "items"
- Line: 2
- Column: 1
- Value: "handgun"

- Name: "items"
- Line: 3
- Column: 1
- Value: "shotgun"

- Name: "items"
- Line: 1
- Column: 2
- Value: "0"

- Name: "items"
- Line: 2
- Column: 2
- Value: "14"

- Name: "items"
- Line: 3
- Column: 2
- Value: "5"

We can imagine a table like this:

knife - 0
handgun - 14
shotgun - 5

ricardorauber

Also, spreadsheets could be saved in the sql lite database! It would be awsome!

So many things to do with it!

ricardorauber

One more thing...

Line, Column and Value parameters could use expression editor, so it can be very dynamic!