Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||"Insert->Sheet From File...": Default name should be based on file name.|
|Component:||ui||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||4.1.0-dev|
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 email@example.com 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.