need help with open office.

guillefaceguilleface Member Posts: 1,014
edited July 2012 in Miscellaneous
i saved my work to .csv but when i opened, all my questions moved, like for example, i had my question in row1 column A "Only 3% of the earth water is fresh., now when i opened, "only" is on column A, 3% is on columnB, "of" is on column C and so on. whats the best way to save?thanks

Answers

  • mithraweptmithrawept Member, PRO Posts: 167
    A csv file is essentially a text list, where the cells are delimited by commas, rather than put into cells on a spreadsheet. Essentially when you save the file and then open again, the file format has put the data back into a single string per row. Think of it as a spreadsheet with only one column.

    Try saving as Microsoft Excel compatible format, .xls or .xlsx or .sylk- I don't use Open Office, so I don't know what formats it supports but one of these should hopefully work.

    Probably a good idea to do some testing before committing your game data though.
Sign In or Register to comment.