Description: In the 5.4.2 release, Calc no longer highlights referenced cells or cell ranges with different colors while editing a formula. (The option "Tools\Options...\LibreOffice Calc\View\Display\[x] Show references in color" is still checked.) Steps to Reproduce: 1. Enter the formula "= B2" into cell A1. 2. Edit the formula. Actual Results: Cell B2 is no longer shown with a colored frame. Expected Results: Cell B2 should be highlighted with a colored frame. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64; rv:56.0) Gecko/20100101 Firefox/56.0
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (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.)
Created attachment 137044 [details] Simple test document Ok, I have attached a simple test document (Test.ods).
if I double click on cell A1 the blue border around B2 is displayed. 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 steps are provided
Created attachment 137047 [details] Screenshots taken with LO 5.3.6 and 5.4.2 Here are more detailed instructions. The screenshots taken with LibreOffice 5.3.6 show what *should* happen (but no longer does in 5.4.2). 1. Open LibreOffice Calc 2. Open "Test.ods" 3. Click cell A1 (=> The formula "= B2" appears in the "Input line" edit field at the top) 4. Click anywhere in the "Input line" (=> Cell B2 should be highligthed with a blue box, see "Example1.jpg") 5. Exit the "Input line" and click cell B15 (=> The formula "= SUM(B4:B8)" appears in the "Input line") 6. Click anywhere in the "Input line" (=> The range B4:B8 should be highligthed with a blue box, see "Example2.jpg")
(In reply to Xisco Faulí from comment #3) > if I double click on cell A1 the blue border around B2 is displayed. Sorry, I didn't notice that before. I can confirm that the bug does not happen when editing is done by double-clicking a cell, but only when the "Input line" is used. (In this case, also the formula shown in the edited cell isn't colored.)
confirm LO 6, linux
This seems to have begun at the below commit. Adding Cc: to Eike Rathke ; Could you possibly take a look at this one? Thanks f308cf47b5557e9890026ed0939bdf9caa31d174 is the first bad commit commit f308cf47b5557e9890026ed0939bdf9caa31d174 Author: Jenkins Build User <tdf@pollux.tdf> Date: Thu Aug 24 19:34:46 2017 +0200 source d31a8263d564ebd7886f6debdf36cedd031915ea author Eike Rathke <erack@redhat.com> 2017-08-24 14:34:55 (GMT) committer Eike Rathke <erack@redhat.com> 2017-08-24 14:37:15 (GMT) commit d31a8263d564ebd7886f6debdf36cedd031915ea (patch) tree 494dbabd49cdd5d9a5cbb44ce28fa35894e58707 parent 73ee631e58f392415f23e98460ff4b2f3a763d37 (diff) Resolves: tdf#108795 merge table EditEngine language attributes to input line
Investigating.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8112af3361fdf15fcf5d3177cd967e1d8d97d5f3 Resolves: tdf#113179 merge language attributes early, tdf#108795 follow-up It will be available in 6.0.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.
Pending review https://gerrit.libreoffice.org/43572 for 5-4
Still exists on this version Version: 5.4.3.1 (x64) Build ID: 32c8895c6cae21571f364dbb059f419a743ee44d Threads CPU : 4; OS : Windows 6.29; UI Render : par défaut; Locale : fr-FR (fr_FR); Calc: group
(In reply to ThierryT from comment #11) > Still exists on this version > > Version: 5.4.3.1 (x64) > Build ID: 32c8895c6cae21571f364dbb059f419a743ee44d > Threads CPU : 4; OS : Windows 6.29; UI Render : par défaut; > Locale : fr-FR (fr_FR); Calc: group please try with a master build from http://dev-builds.libreoffice.org/daily/master/ You can install it alongside the standard version.
I tested the master version : Version: 6.0.0.0.alpha1+ (x64) Build ID: b19e1a145bcdaab7ccd4c4c84dd3bd9795403cd5 CPU threads: 4; OS: Windows 6.3; UI render: default; TinderBox: Win-x86_64@42, Branch:master, Time: 2017-10-21_23:57:09 Locale: fr-FR (fr_FR); Calc: CL Bug is fixed on this version. Do you apply the correction on the next version 5.4.3.2 ?
(In reply to ThierryT from comment #13) > > Bug is fixed on this version. > Do you apply the correction on the next version 5.4.3.2 ? Yes, see comment 10
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=99fdaf683e6403b1d8a70d48ebe0e20194017624&h=libreoffice-5-4 Resolves: tdf#113179 merge language attributes early, tdf#108795 follow-up It will be available in 5.4.4. 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.
(In reply to raal from comment #14) > (In reply to ThierryT from comment #13) > > > > Bug is fixed on this version. > > Do you apply the correction on the next version 5.4.3.2 ? > > Yes, see comment 10 Actually no, see comment 15 ;-)
*** Bug 113401 has been marked as a duplicate of this bug. ***
*** Bug 113456 has been marked as a duplicate of this bug. ***
*** Bug 113466 has been marked as a duplicate of this bug. ***
*** Bug 113497 has been marked as a duplicate of this bug. ***
*** Bug 113518 has been marked as a duplicate of this bug. ***
*** Bug 113636 has been marked as a duplicate of this bug. ***
*** Bug 113691 has been marked as a duplicate of this bug. ***
*** Bug 113801 has been marked as a duplicate of this bug. ***
*** Bug 113902 has been marked as a duplicate of this bug. ***
*** Bug 114065 has been marked as a duplicate of this bug. ***
*** Bug 114576 has been marked as a duplicate of this bug. ***