Page 1 of 1

Playmaker action: Spreadsheet Get Cell?

Posted: Thu Feb 13, 2020 8:25 pm
by doppelmonster
Hello,
i am just diving into ES3 with Playmaker. I used ES2 with Playmaker some time ago extensively.

I am just trying out to create, save and load to Spreadsheet. But i am missing a "ES3 Spreadsheet Get Cell" action? How would I load a cell into a variable?

Re: Playmaker action: Spreadsheet Get Cell?

Posted: Thu Feb 13, 2020 9:16 pm
by doppelmonster
I tried to write the action on my own but i am missing something.

Code: Select all

 [ActionCategory("Easy Save 3")]
    [Tooltip("Gets a given cell of the ES3Spreadsheet.")]
    public class ES3SpreadsheetGetCell : ES3SpreadsheetAction
    {
        [Tooltip("The column of the cell we want to get the value of.")]
        public FsmInt col;
        [Tooltip("The row of the cell we want to get the value of.")]
        public FsmInt row;

        [Tooltip("The variable we want to use to store our loaded data.")]
        [UIHint(UIHint.Variable)]
        public FsmVar value;

        

        public override void OnReset()
        {
            value = null;
            row = null;
            col = null;
        }

        public override void Enter()
        {
        
                value.SetValue (es3Spreadsheet.GetCell<object>(col.Value, row.Value));
        }
    }
This is the error I get. the fun thing is that i expected the 1 :)
System.FormatException: Expected '{' or "null", found '1'.

Re: Playmaker action: Spreadsheet Get Cell?

Posted: Fri Feb 14, 2020 4:26 pm
by Joel
Hi there,

The ES3SpreadsheetGetCell action should be included in the latest update, so it sounds like you might not be on the latest version or the file is not updating from the Asset Store. If you PM me your invoice number I'll send over the correct version.

Regarding your error, you might want to try deleting your save data and see if this resolves the issue.

All the best,
Joel

Re: Playmaker action: Spreadsheet Get Cell?

Posted: Sat Feb 15, 2020 9:39 am
by doppelmonster
Hi i just reimported the package from the asset store (Version: 3.1.4f1 • Aug 12, 2019). But i was already up to date. and dont got a getcell action.
As a sidenote: i also dowloaded the actions from jean fabres ecosystem browser (mainly for arraymaker). But i dont think that this confused something, at least i dont have errors in the console. in the attachment you see my action library.

For now i switched to the file workflow instead of spreadsheet as this work for my current project as well but spreadsheets might come in handy for localisation in the future.

cheers,
Matthias

Re: Playmaker action: Spreadsheet Get Cell?

Posted: Sun Feb 16, 2020 10:02 am
by Joel
Hi there,

That's very strange, it looks like Asset Store importer is importing the wrong version, or is failing to overwrite an old version of the file. If you PM me your invoice number I'll be happy to send it over.

All the best,
Joel