Bug 116595

Summary: Can't rename view
Product: LibreOffice Reporter: Ted Lee <tmplee>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement    
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: macOS (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: database editing window

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.