Description: The menu tree in Calc of LO 5.3.0 is not correct resp. not complete: In the submenu of main menu item "Insert" doesn't exist an item "Named areas" (in german "Namen") as in LO 5.2 - with submenu items "Set" ("Festlegen"), "Manage" ("Verwalten"), "Insert" ("Einfügen") etc. Instead of the menu item "Named areas" there is the one item "Insert", that belongs in LO 5.2 to the submenu of "Named areas". Clicking on this item in LO 5.3 the same form is opened as in LO 5.2 by clicking on the menu item of Insert - Named areas - Insert. Appended screenshots are created with LO 5.3.0 build from 2016-11-02_23.27.06, but the build from 2016-11-05_23.04.01 shows the same behavior. Steps to Reproduce: 1. create an empty spreadsheet document 2. (select any cell and enter something) - not needed, the beavior is the same 3. click on Main menu "Insert" Actual Results: submenu as described appears - with menu item "Insert" without a submenu arrow Expected Results: submenu with menu item "Named areas" and an arrow indicating that a sub menu exists Reproducible: Always User Profile Reset: No Additional Info: I think that it is not a big thing and that all needed code exists (if it was not deleted by transition from LO 5.2 to LO 5.3), but the composition of the main menu item "Insert" is in error. Hints: - I have reproduced the error on 2 computers (x86 und x64) - both with Windows10 1607. - Severity: Maybe other users mean "Normal" were better, but I have selected because I use named areas in my most important spreadsheet documents to create links (e.g. for jumps within the documents). Without this feature I can't uses this version. User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:49.0) Gecko/20100101 Firefox/49.0
Created attachment 128531 [details] zip-file with screenshots of calc menu "Insert" etc. Screenshots showing - LO 5.2.3: Menu tree Insert - Named areas - LO 5.2.3: Form shown after click on menu item Insert - Named areas - Insert - LO 5.3.0: Menu item Insert - LO 5.3.0: Form shown after click on menu item Insert - Insert
Reproducible. Version: 5.3.0.0.alpha1+ Build ID: 32bdc5097013e7efd9c85e1b8df697880e66e925 CPU Threads: 4; OS Version: Windows 6.2; UI Render: default; Layout Engine: new; TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2016-11-04_23:30:30 Locale: es-ES (es_ES); Calc: single
This submenu was moved to Sheet > Named Ranges and Expressions.
Interesting we have the same entry on two places with different behavior, well my mistake, not exactly the same: Menu/Insert/Named Range or Expression... Menu/Sheet/Named Ranges and Expressions With minimal difference on their name. Doesn't look as a good improvement of the UI. Menu/Sheet/Named Ranges and Expressions/Define Menu/Sheet/Named Ranges and Expressions/Create Menu/Sheet/Named Ranges and Expressions/Label IMHO should be at least also on Insert, the three entries allow to create items, 'Named Range or Expression...' only paste the list of NRE on the sheet. Why not simplify, having only the entry on Sheet. But with a different name for the main and secondary entries. BTW I can't see this change on released notes.
Oops! I hadn't expect and therefore I hadn't found that the menu for named areas completely with all 5 submenu items is moved from the menu "Insert" (in german "Enfügen") to the menu "Sheet" ("Tabelle") in LO 5.3 - especially because in (German) LibreOfficeDev help still only the "old" method via the Insert menu is described. I have tested: With the Named cells submenu in the Sheet menu I can handle the names (set, manaage, insert) in the same manner as with the named areas submenu of Insert menu in LO 5.2. For me this is OK - my prolem is solved! I don't know if it is good or necessary that there are two ways to reach the same result.