Issue 77955

Summary: "Insert->Sheet From File...": Default name should be based on file name.
Product: Calc Reporter: oreg <gero>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 2.2   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Description oreg 2007-05-30 16:18:43 UTC
The process for "Insert->Sheet From File..." could be improved:

The default name of the new sheet should be based on the file name instead of
"Sheet1".

(Moved here from Issue 77760.)
Comment 1 oc 2008-07-15 10:42:59 UTC
reassigning features and enhancements to user requirements@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)
Comment 2 eric.savary 2010-05-23 08:02:22 UTC
The use of the inserted file name as sheet name could be optional as the mockups
of issue 92520 show.

http://www.openoffice.org/nonav/issues/showattachment.cgi/55601/92520_before_insert.jpg

http://www.openoffice.org/nonav/issues/showattachment.cgi/55602/92520_after_insert.jpg
Comment 3 eric.savary 2010-05-23 08:03:05 UTC
*** Issue 92520 has been marked as a duplicate of this issue. ***
Comment 4 oreg 2010-05-24 16:40:38 UTC
es, I would prefer that Issue 77953 be fixed (along with this one) and the sheet
name were editable in the import dialog. Then there would be no reason to have
an additional option--the name would be set to the file name by default, which
in any case makes more sense than the arbitrary "Sheet 1", and the user could
edit it to whatever she prefers--even "Sheet 1" if she is so inclined...

Could someone promote this issue to "CONFIRMED"?
Comment 5 Edwin Sharp 2014-01-02 19:28:16 UTC
If the existing sheets are not based on file name, why a new sheet should?
Comment 6 oreg 2014-01-02 20:39:01 UTC
Edwin, imported sheets can only have a name if the imported format is a spreadsheet. I should have mentioned this in my orginial post: This bug is mostly about importing non-spreadsheet formats, in particular CSVs. They cannot have a sheet name in the imported file and OOo currently assigns them the meaningless name "Sheet1" (or presumably some other number if 1 already exists). The file name (w/o the suffix) would be a much better choice.
Comment 7 Edwin Sharp 2014-01-05 15:22:54 UTC
Thanks for clarifying.
Good suggestion.