Playmaker action: Spreadsheet Get Cell?

Discussion and help for Easy Save 3
Post Reply
doppelmonster
Posts: 13
Joined: Thu Jan 08, 2015 2:34 pm

Playmaker action: Spreadsheet Get Cell?

Post 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?

doppelmonster
Posts: 13
Joined: Thu Jan 08, 2015 2:34 pm

Re: Playmaker action: Spreadsheet Get Cell?

Post 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'.

User avatar
Joel
Moodkie Staff
Posts: 2800
Joined: Wed Nov 07, 2012 10:32 pm

Re: Playmaker action: Spreadsheet Get Cell?

Post 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
Joel @ Moodkie Interactive
Twitter - Unity

doppelmonster
Posts: 13
Joined: Thu Jan 08, 2015 2:34 pm

Re: Playmaker action: Spreadsheet Get Cell?

Post 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
Attachments
Schnappschuss_021520_103245_AM.jpg
Schnappschuss_021520_103245_AM.jpg (114.08 KiB) Viewed 326 times

User avatar
Joel
Moodkie Staff
Posts: 2800
Joined: Wed Nov 07, 2012 10:32 pm

Re: Playmaker action: Spreadsheet Get Cell?

Post 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
Joel @ Moodkie Interactive
Twitter - Unity

Post Reply