Issue 77955 - "Insert->Sheet From File...": Default name should be based on file name.
Summary: "Insert->Sheet From File...": Default name should be based on file name.
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 92520 (view as issue list)
Depends on:
Blocks:
 
Reported: 2007-05-30 16:18 UTC by oreg
Modified: 2014-01-05 15:22 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.