Description: 1. more file can't use vlookup function; 2. one file ,more sheet is ok; 3. use lib 6.0,6.1,6.2,6.2.3 ; 4. on one is ok 5. I report this bug on bbs on last month , but no one response this question; 1. pls use two excel file,include(xls,ods,xlsx); 2. winodows system(windows 7 64bit, professional os); 3. CPU:I5,memory: 8G, hardisk:500 GB; Steps to Reproduce: 1. use two excel; 2. use vlookup function ; 3 can't use mouse draw ; Actual Results: can't use Expected Results: ms office Reproducible: Always User Profile Reset: Yes Additional Info:
please add more clear steps for repro
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Thank you for reporting the bug. Unfortunately without clear steps to reproduce it, we cannot track down the origin of the problem. Please provide a clearer set of step-by-step instructions on how to reproduce the problem. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested information is provided.
I think I have a similar problem with the function wizard Description: 1. Selecting the vlookup function from the wizard. 2. Indicating the matrix field to the sheet in another opened file. 3. The function wizard does not transfer a range of cells from a sheet from another file (no reference or link to another file).
Confirm with 6.3, Linux, regression
This seems to have begun at the below commit. Adding Cc: to Henry Castro ; Could you possibly take a look at this one? Thanks d69919320545a15351976d49883332bee16dc37d is the first bad commit commit d69919320545a15351976d49883332bee16dc37d Author: Jenkins Build User <tdf@pollux.tdf> Date: Fri Mar 16 21:26:29 2018 +0100 source 009d2756b1678477ec23d5647bd5004c4bff3a62 author Henry Castro <hcastro@collabora.com> 2018-03-15 14:23:48 -0400 committer Henry Castro <hcastro@collabora.com> 2018-03-16 20:58:50 +0100 commit 009d2756b1678477ec23d5647bd5004c4bff3a62 (patch) tree c1ad3f7de8bb95085b38ceff13a8064fa19f2089 parent 8a8663a49b6d2ba297587c730860cc8ca9d139da (diff) lokdialog: do not lock events when opened ScFilter Dialog
Created attachment 151165 [details] printscreen
*** Bug 126651 has been marked as a duplicate of this bug. ***
I have a same problem with the function wizard Description: 1. Selecting the vlookup function from the wizard. 2. Indicating the matrix field to the sheet in another opened file. 3. The function wizard does not transfer a range of cells from a sheet from another file.Сhecked in lib 6.2.x-6.3.0.4
Dear Henry Castro, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assign it back to yourself if you're still working on this.
@Caolán, I thought you might be interested in this issue...
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f31d36966bceb90e261cbecd42634bde4448d527 tdf#124513 let wizard reappear on tabbing back to document It will be available in 6.5.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.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-6-4": https://git.libreoffice.org/core/commit/ebba06b785c87e6a310a523fa9570449d3986cd7 tdf#124513 let wizard reappear on tabbing back to document It will be available in 6.4.0.1. 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.
I think https://cgit.freedesktop.org/libreoffice/core/commit/?id=b3a9fd1c51b4d0c2a8146c250e5571cc38eae9e6 from Szymon fixed 98% of this and https://git.libreoffice.org/core/commit/f31d36966bceb90e261cbecd42634bde4448d527 gets it over the line
Szymon Kłos committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/commit/e5f74d20c2b72b107fe719cc888d779f17e5d57c tdf#124513 Allow to use multiple Formula dialog instances It will be available in 6.3.5. 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.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/commit/95846782231096345e9a09b3fa35355316ef50fe tdf#124513 let wizard reappear on tabbing back to document It will be available in 6.3.5. 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.
this should work now
I confirm in new version the problem is solved. Version: 6.4.0.0.beta1+ Build ID: 3bd1b85cdc00456e35d286d3d76ffd7b36c5e03e CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3; TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:libreoffice-6-4, Time: 2019-11-26_02:21:24
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-6-3-4": https://git.libreoffice.org/core/commit/1b4c9908887b5260033b431d6c5e4a9c10b9ee53 tdf#124513 let wizard reappear on tabbing back to document It will be available in 6.3.4. 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.
The problem is not solved Версия: 6.3.4.2 (x86) ID сборки: 60da17e045e08f1793c57c00ba83cdfce946d0aa Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: по умолчанию; VCL: win; Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU Calc: threaded
The Version 6.4 beta1 is not solved! This bug report submit over half years! please as soon as possile , thank you very much!
@astrel, @peter, could you please explain the steps to reproduce it ?
Dear : step 1 : please create 2 excel files ; step 2: use the function: vlooup ; pls try it , the test is very easy , u can found the error ; thank you very much!
To play, be sure to use the function wizard and mouse !!!!
Created attachment 156501 [details] Screencast of using wizard with VLOOKUP Confirming that the original problem (however poor the original "description" were) is still not fixed.
And just to be clear: this has never worked, including LO 3.3, and AOO. It's an inherited limitation (inability to select a range from another document using the wizard and mouse), and the regression that was tracked here starting from comment 5 is a different problem (thanks for fixing that), but it does *not* address the original request for enhancement. Since the confusion happened here, it might be a good idea to close this one (as tracking the regression part), and file a new one for the original problem.
Created attachment 156502 [details] Screen cast on 5.4 Oh excuse me for the statement that this has never worked. It did, when the files are saved; please see how this worked in 5.4.
Mike Kaganski,thank you so much for your help! This problem started with L.O. 6.1.x.x.
Whatever the decision is wrt keeping the bug here, or moving into a new issue: the original problem is a regression after https://gerrit.libreoffice.org/plugins/gitiles/core/+/009d2756b1678477ec23d5647bd5004c4bff3a62
*** Bug 126988 has been marked as a duplicate of this bug. ***
Dear Xisco Faul： The next version 6.4! can we solved this error? Thank you very much!!
The problem is solved! Версия: 6.4.0.1 (x86) ID сборки: 1b6477b31f0334bd8620a96f0aeeb449b587be9f Потоков ЦП: 4; ОС: Windows 10.0 Build 18362; Отрисовка ИП: по умолчанию; VCL: win; Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU Calc: threaded and 6.4.0.1 (x64)
Dear : I used the new version 6.4.0.1 test this bug; but sorry , The bug is not solved ! pls try again , tks! My computer: 1. OS: windows 7; 2. language: chinese; 3. liberorffice version:6.4.0.1(X64）
Based on my attempt to follow the reproduction steps, this is working. (Ubuntu 20.04, LO 7.2.) Although there is one claim that it still is not working (in 2019), others who are invested in this bug report say that it is working since 6.4. Since this bug has been silent for over two years, I'll mark it as worksforme. Because this bug is so messy, anyone who disagrees should open a new bug report and clearly explain how to still reproduce.
Comment on attachment 156501 [details] Screencast of using wizard with VLOOKUP Indeed, attachment 156501 [details] shows two unsaved documents. Referencing an external document without a storage is not possible.