Problem description: Steps to reproduce: 1. Create a new spreadsheet document with at least one sheet. 2. Open the "Manage Names" dialog 3. Assign a name to a range (or a single cell, which does not matter) and set the scope of the name to any sheet (but not to "Document (Global)") 4. Select the above assigned range in the corresponding sheet Current behavior: The name box displays the selected range (e. g. "A1" or "A1:C6") Expected behavior: The name box should display the assigned name (e. g. "myField" or "myMatrix") This currently only works for names in the global scope. MS Excel 2007 shows the name in the local scope. Operating System: Linux (Other) Version: 3.6.6.2 release
Thank you for reporting this issue! I have been able to confirm the issue on: Version 4.1.1.2 Platform: Ubuntu 13.04 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + As I've been able to confirm this problem on an earlier release I am changing the version number as version is the earliest version that we can confirm the bug, we use comments to say that the bug exists in newer versions as well. Marking as: New (confirmed) Trivial - no impact at all but should probably say name not range Lowest Keywords - Whiteboard Status - proposedeasyhack + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org/get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
Removing comma from whiteboard (please use a space to delimit values in this field) https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Whiteboard#Getting_Started
In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval. Thank you and apologies for the noise
Migrating Whiteboard tags to Keywords: (needsDevEval) [NinjaEdit]
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170103
Still occurs in 5.3beta2 / Ubuntu 16.04. Since local names were not available in OOo (step 3 in description), this is an implementation error. Adding easyHack keyword, since this was proposed as an easy hack, but the proposal still has to be evaluated. Currently the Manage Names dialog is available in Sheet -> Named Ranges and Expressions -> Manage...
One additional bit of information, the range can be assigned via the Add button in Manage Names dialog.
(In reply to marius.spix from comment #0) > 4. Select the above assigned range in the corresponding sheet ..and this means you just select the range with your mouse or keyboard.
Created attachment 140898 [details] Scope Local do not appear Active Cell Reference (Name Box)
Created attachment 140899 [details] Named cells with Scope Local do not appear Active Cell Reference (Name Box)
Created attachment 140900 [details] Names with Local Scope do not appear Active Cell Reference (Name Box) PS: Had a slight problem attaching the image. Hope it works. Sorry for any redundancy.
I don't see any code points => remove EasyHack keyword and it's steill repro in Версия: 6.3.0.1 (x64) ID сборки: 41ac97386aba908b6db860cfb4cfe2da871886ae Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: GL; VCL: win; Локаль: ru-RU (ru_RU); UI-Language: ru-RU Calc: threaded
Eike Rathke committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/d3a8fdf3cad0e71ff5e13bb229fed6e52206c6b9 Resolves: tdf#67007 display sheet-local range name in Name Box for selection It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/c/core/+/103430 for 7-0
Verified in Version: 7.1.0.0.alpha0+ Build ID: 050e95e50d44a5cbb74bb5de481cb30551f83136 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded @Eike, thanks for fixing this issue!!
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/6d9652e2864a020b61f26a7b51ca908f1d9790a8 Resolves: tdf#67007 display sheet-local range name in Name Box for selection It will be available in 7.0.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Created attachment 166067 [details] testsheet_with_two_named_ranges_test hello @erAck, don't know for sure, but may be there's room for improvement, see attached sheet, two ranges named 'test', one scope 'global', one scope 'sheet1', if you select from the 'name box' you get offered both, but regardless which you click the selection changes to the local range, would it be better to make the global range 'adressable' - reachable? if you select the ranges manually 'test' appears in the name box, but without a hint about the scope, thus some simple minded users might check the magenta range as 'test', and be astonished why values keyed in there aren't evaluated by formuas referencing 'test', ... this may look silly, but will happen once you think of handing sheets to other users ... once there are multiple ranges with identical names in a project they should always show their 'full name', with the scope, and should all be selectively adressable - by including the scope reference into the name or by clicking on the appr. entry ... or not? reg. b.
If you want anything changed regarding the handling when clicking a name entry of the Name Box then please open a new RFE.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/dda3592f6a1028bd9d433eb2f88e561959212cf6 tdf#67007: sc: Add UItest It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.