Bug 116595 - Can't rename view
Summary: Can't rename view
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All macOS (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-03-24 01:02 UTC by Ted Lee
Modified: 2018-03-28 13:39 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
database editing window (170.97 KB, image/png)
2018-03-24 01:02 UTC, Ted Lee
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ted Lee 2018-03-24 01:02:55 UTC
Created attachment 140841 [details]
database editing window

Open a database that has a view.  Select Table to show the name of the view in the lower part of the window, along with the table.  Select the view.  Pull down the Edit menu.  "Rename" is grayed out.  Or pull up a contextual (control-click) menu on the view -- no rename option is presented.  If you attempt to select the name of the view you do not get an editable field (like under similar circumstances on a Mac.) There is at least one relatively simple workaround: open the view for editing, save-as under the desired new name, and delete the view.  But one shouldn't have to do that!  Attached is a screen shot of a database window -- the view named XmasList is a view to be renamed, but can't be without using the workaround.  "Bug" present in all version of LO I've tested, up to and including both 6.0.4 and 6.1alpha builds from today.
Comment 1 Alex Thurgood 2018-03-28 07:18:34 UTC
@Ted : is this just for embedded hsqldb, or does it also apply to other database backends that support views ?
Comment 2 Alex Thurgood 2018-03-28 07:19:42 UTC
@Ted : does it depend on the contents of the View ?


Setting to NEEDINFO

It would be helpful if you could provide us with a test ODB file so that we can attempt to reproduce.
Comment 3 Alex Thurgood 2018-03-28 07:24:41 UTC
Reproduced with embedded hsqldb file and LO6021
Comment 4 Ted Lee 2018-03-28 13:39:22 UTC
I gather that means I don't need to respond to your earlier request for a sample database!  I don't have any databases other than those created by LO (or OO or NO) so I can't answer your question about whether the problem arises with an external database.