Ask Your Question

Why can't I save file with multiple sheets instead of only the last active sheet I was in? [closed]

asked 2014-01-12 23:23:35 +0200

jspreadsheet gravatar image

I opened csv file as spreadsheet. Sheet1 is listed. Copied a few lines from sheet1 to sheet2. Copied a few lines from sheet1 to sheet3. Saved file while in sheet3. Closed file while in sheet3. Re-opened file . ---Only Sheet1 now but it's the data from sheet3 the last one I was active in. The original sheet1 and sheet2 are gone!!!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 14:22:54.739299

1 Answer

Sort by » oldest newest most voted

answered 2014-01-13 00:10:57 +0200

m.a.riosv gravatar image

Because you can't save more than one sheet in a CSV file. Take in account that CSV files are plain text files not spreadsheet files.

If you want save all sheets use Menu/File Save as / and select as File type ODF Spreadsheet (.ods *.ods).

You can import a CSV file in a spreadsheet with Menu/Insert/Sheet and if you like retaining it linked, checking the option.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-01-12 23:23:35 +0200

Seen: 33,732 times

Last updated: Jan 13 '14