Help with Spreadsheet String to Array

[MaxJoseph]

Hi all,

This is probably a simple fix, but I cannot for the life of me see where my error is! Please help!

I am using Array to Speadsheet String and Spreadsheet String to Array to get tables of values into and out of my code.

[kartiknattar · Accepted solution]

I guess you forgot to put comma while declaring array. something like this [0,0,0]

[MaxJoseph]

Bah! It appears taht I deleted most of the body of my text!

When I use randomly generated data, convert it to a spreadsheet string with Array to Spreadsheet String I get an output which I can then convert back to an array using Spreadsheet String to Array. Perfect!

I can examine the output of Array to Spreadsheet String with '\' codes on to see the true format. I then make a similar sting, formatted in the say way (as far as I can see!), and it fails to import the last row of each page of the 3D array.

Why only the last row? How does my format differ from the output of Array to Spreadsheet String? What am I missing? Please help!

Thanks,

Max

[MaxJoseph]

Perfect! Thanks!

I just couldnt see it on my own!