Page 1 of 1

SpreadSheet not loading types correctly

Posted: Wed Jun 02, 2021 5:49 am
by john
Hello,

Here is an example script where I'm not able to load the data back.
ES3Spreadsheet sheet;

private void Start()
{
sheet = new ES3Spreadsheet();
}
void Update()
{
if (Input.GetKeyDown(KeyCode.P))
{
sheet.SetCell(0,0,this.transform.position);
Debug.Log("position Value saved");
sheet.Save("Position.csv", false);
}

if (Input.GetKeyDown(KeyCode.L))
{
sheet.Load("Position.csv");
Debug.Log("Load position is " + sheet.GetCell<Vector3>(0, 0));
this.transform.position = sheet.GetCell<Vector3>(0, 0);
}
}


I keep getting the following error
FormatException: Expected ',' separating properties or '"' before property name, found '{'.
I've updated the ES3 asset but the issue persists. Any Info is appreciated thanks.

Re: SpreadSheet not loading types correctly

Posted: Wed Jun 02, 2021 7:36 am
by Joel
Hi there,

Thanks for the clear repro case, I've managed to replicate this at my end. If you private message me your invoice number I'll send over an update to resolve this.

All the best,
Joel