Created attachment 109360 [details] screenshot with bug [Version 4.3.3.2; Windows 7] When trying to add a name to a worksheet, i see the text 'Invalid name, only use letters, numbers and underscore' I've use 'B2' which is a letter and a number, LO thing this is not correct, but this is not clear from the given error message. Other thing like 'BB', 'B_', '_2', 'B2_', 'B_2' are accepted
confirmed thanks Luuk :) I bet this is he case already for a long time...
** 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.0.4 or later) 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 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 your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20
same on 5.2 master
In version 5.1.0.3 the 'wrong' message is still shown. It would be more clear to a user if this message was change to: "You cannot enter a reference to a cell, or a range of cells"
@jani, Looks as a reasonable candidate for an easy hack to me. With one check a choice for string A or B is made.
I totally and with a code pointer it will be.
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INVALID due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team This INVALID Message was generated on: 2016-05-09
a valid issue, all info here. Was NeedInfo erroneously I think
.
(In reply to Cor Nouws from comment #9) > . NEEDINFO was there, because there are no code pointer, which is mandatory for a easyHack. Of course we can remove Easyhack, then NEEDINFO is not needed.
Remark, easyHacks are normally controlled by an experienced developer, so adding a code pointer should not be a problem.
(In reply to jan iversen from comment #11) > Remark, easyHacks are normally controlled by an experienced developer, so > adding a code pointer should not be a problem. If that is not a problem, than it should happen within 3 month, otherwise 'QA Administrators' are closing this automatically.... ;) @Cor, thanks for re-opening this, it's very hard to keep actual track of bugs I created or just following out of curious interest...
I follow easyhacks every morning, and update status and other things. I do not close bugs, that is for the QA team to do, but I make sure development easyhack follow the guidelines we have. If NEEDINFO is disturbing, then simple put it on NEW, and remove easyhack.
Changing status: NEEDINFO -> NEW Adding keyword 'needsDevEval' [ninjaedit]
Abhilash Singh committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=413232229cbfd9d49ce9d1cdbb6b6e2dbe83af38 tdf#86214 User isn't warned entering a cell address not allowed It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Seems solved
Indeed seems to be solved B1048577 is OK B1048599 is NOT OK now we will only hope the number of lines in Calc won't increase soon ;)
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=224a8b3856ec3cbe6d9f864789184d49ecb8c8d8 add test for tdf#86214 It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a070d0d34763c83b4e957a7aee8b7f255a1d5519 extend the test for invalid names, related tdf#86214 It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 106610 has been marked as a duplicate of this bug. ***
*** Bug 106608 has been marked as a duplicate of this bug. ***