https://bugs.documentfoundation.org/show_bug.cgi?id=107099

            Bug ID: 107099
           Summary: Filesave of csv allows saving separate worksheets. But
                    closing document saves only one worksheet
           Product: LibreOffice
           Version: 4.2.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
I just learned the hard way that one cannot save multiple worksheets inside a
.csv file (unlike a spreadsheet). I lost several hours of work. I will never
make this mistake again, but others might. 

What fooled me was that I was able to save versions of the .csv file in
different worksheets, so I thought I was backing up along the way. LibreOffice
pleasantly allowed me to save the different worksheets, and displayed the
worksheet tabs and names at the bottom the same as if it were a spreadsheet
file. But when I closed and reopened the .csv file, all the worksheet tabs were
gone, along with hours of work and my sanity.

So this is a feature request. To prevent others from repeating my mistake,
perhaps have LO fail faster and more gracefully, such as refusing to save a
separate worksheet and offering a warning. Thank you for your consideration. 

Steps to Reproduce:
1. Open a csv file
2. Create a new worksheet at the bottom, with a different name. Save. LO will
display multiple worksheets at the bottom.  Save.
3. Close the file.

Actual Results:  
Upon reopening, only one worksheet is visible (probably the most recent one). 

Expected Results:
IMPOSSIBLE: Multiple worksheets would still be visible. I understand this is
impossible. 

ALTERNATIVE SUGGESTION: Prompt, firm and efficient failure: Have LO refuse to
allow creating/saving more than one worksheet, and offer a notice that csv
files cannot have multiple worksheets. 


Reproducible: Always

User Profile Reset: No

Additional Info:
Perhaps some might call this a feature request rather than a bug. However, I
just lost half a day of paintaking work (and some faith in LO), so the
consequences are not trivial. Also, I was directed to submit feature requests
here also. 


User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:30.0) Gecko/20100101
Firefox/30.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to