Bug Hunting Session
Bug 113800 - EDITING: Formula Bar Is Not Getting Focus When Column/Row Freeze Enabled
Summary: EDITING: Formula Bar Is Not Getting Focus When Column/Row Freeze Enabled
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.3.2 release
Hardware: All Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Freeze
  Show dependency treegraph
 
Reported: 2017-11-13 09:55 UTC by Kevin Suo
Modified: 2019-02-02 21:58 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
test ods file (13.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-11-14 01:28 UTC, Kevin Suo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2017-11-13 09:55:24 UTC
Steps to Reproduce:

1. Open the attached test ods document;

2. Click in cell Sheet1.D2, hit CTRL+C to copy the chars into your clipboard;

3. In cell Sheet2.F7, type in "=", then try to click cell Sheet1.F1 to set the formula.

Current behaviour:
the formula bar is not getting focus in step3, formula is not set.

Expected:
Formula bar should display "=Sheet1.F1".

Version: 5.3.7.2. Also reproducible in version 5.4.3.2.
Reproduced in both Fedora 26 and Ubuntu 17.10 x64.
Comment 1 Kevin Suo 2017-11-13 09:57:27 UTC
Note that we have column/row freeze enabled in Sheet2.
Bug is not reproducible if we remove the column/row freeze state.
Comment 2 Xisco Faulí 2017-11-13 15:11:23 UTC
Hi Kevin,
Please attached the document...
Comment 3 Kevin Suo 2017-11-14 01:28:24 UTC
Created attachment 137731 [details]
test ods file
Comment 4 Xavier Van Wijmeersch 2017-11-14 07:21:22 UTC
Kevin i can not produce the behavior with

Version: 6.0.0.0.alpha1+
Build ID: 0b4d0c87fe201b7cc7f49b2dc14c134c95558a30
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-11-11_02:45:18
Locale: nl-BE (en_US.UTF-8); Calc: group

home build

Version: 6.0.0.0.alpha1+
Build ID: 53e13b256fa5082eb29ea2addd1bfa184827e53b
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 5.4.4.0.0+
Build ID: 0958cd79545a21a37642f812937d57164117bffe
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 5.3.1.2
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 5 Aschalew 2017-11-14 08:32:59 UTC
can't reproduce if freeze cells enabled
on Calc:
view=>Freeze cells=> Freeze Rows and Columns

Version: 5.4.3.2 (x64)
Build ID: 92a7159f7e4af62137622921e809f8546db437e5
CPU threads: 8; OS: Windows 6.19; UI render: default; 
Locale: en-US (en_US); Calc: group
Comment 6 Aschalew 2017-11-14 08:33:55 UTC
(In reply to Aschalew from comment #5)
According Comment#1
> can't reproduce if freeze cells enabled
> on Calc:
> view=>Freeze cells=> Freeze Rows and Columns
> 
> Version: 5.4.3.2 (x64)
> Build ID: 92a7159f7e4af62137622921e809f8546db437e5
> CPU threads: 8; OS: Windows 6.19; UI render: default; 
> Locale: en-US (en_US); Calc: group
Comment 7 Kevin Suo 2017-11-14 08:47:13 UTC
I am in Simplified Chinese locale with ibus-pinyin input method.
Comment 8 Buovjaga 2017-11-16 10:07:59 UTC
(In reply to Kevin Suo from comment #3)
> Created attachment 137731 [details]
> test ods file

I reproduce.

Arch Linux 64-bit
Version: 6.0.0.0.alpha1+
Build ID: 121303615054568c204def97872343d2014af4a0
CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on November 16th 2017
Comment 9 QA Administrators 2018-11-17 03:46:43 UTC Comment hidden (obsolete)
Comment 10 mattia.b89 2019-02-02 21:58:47 UTC
Reproducible in

Version: 6.1.4.2
Build ID: 6.1.4-4
CPU threads: 4; OS: Linux 4.20; UI render: default; VCL: gtk3; 
Locale: it-IT (en_GB.UTF-8); Calc: group threaded