|
Matthew Simmons
|
October 15, 2014 at 11:59 am
So I saw the other post about using Open Office on the Mac to save the seating chart as a csv file and followed the instructions. When imported though, the row order gets messed up. It shows row 1, then row 10-19, then row 2, then row 20, then row 3,4,5,6,7,8 and 9. I tried adding leading zeroes to the row number, but it didn’t seem to work. Is there a bug or something that I’m missing. I’m happy to send you the csv file to take a look.
|
|
Josh
|
October 15, 2014 at 12:50 pm
Hi Matthew,
The rows are ordered alphanumerically, but adding a leading zero should work. Did you add more than one leading zero?
|
|
Matthew Simmons
|
October 15, 2014 at 2:10 pm
I only added one zero. Should I have added two?
|
|
Josh
|
October 15, 2014 at 2:13 pm
One should work. Can you post the contents of the CSV file onto a pastebin or a github gist and give us a link to it so we can take a look?
|
|
Matthew Simmons
|
October 15, 2014 at 2:20 pm
It’s working now. it looks like open office was dropping the leading zero when it saved the document as a csv. Thanks for your help.
|
|
Josh
|
October 15, 2014 at 7:52 pm
Hi Matthew,
I’ve seen the same thing happen with Numbers on the Mac, but changing the data format for the Row cells made it happen.
|
