Bug 122395 - Irrecoverable loss of focus editing formula across worksheets with frozen rows/columns
Summary: Irrecoverable loss of focus editing formula across worksheets with frozen row...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.2.1 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-12-31 17:14 UTC by temple48
Modified: 2019-01-12 19:10 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample doc for bug #122395 (7.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-07 15:39 UTC, temple48
Details

Note You need to log in before you can comment on or make changes to this bug.
Description temple48 2018-12-31 17:14:55 UTC
When editing a formula in the formula bar, LibreOffice Calc 6.1.2.1 release (Fedora 29, GNOME 3) irrecoverably loses focus if another worksheet is accessed for addition to the formula, if that worksheet has freeze rows/columns enabled.

The only way to escape appears to be to force quit the application.

Upon re-launching the application, if the freeze rows/columns is removed from the worksheet, the formula can be written without any loss of focus or problem otherwise.

This has been encountered on multiple unique documents, saved in both .ods and .xlsx formats.
Comment 1 raal 2019-01-05 17:32:11 UTC
Hello,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you

I can not reproduce with Version: 6.3.0.0.alpha0+
Build ID: ef58bf56ad292656ad2de0a417eda72cc170f782
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Comment 2 temple48 2019-01-07 15:39:30 UTC
Created attachment 148098 [details]
Sample doc for bug #122395

Sample doc for bug #122395 attached here. Generated with LibreOffice Calc 6.1.2.1-4.fc29.
Comment 3 temple48 2019-01-12 18:53:18 UTC
This appears to be fixed in:

Version: 6.1.4.2
Build ID: 6.1.4.2-1.fc29
Comment 4 raal 2019-01-12 19:10:21 UTC
(In reply to temple48 from comment #3)
> This appears to be fixed in:
> 
> Version: 6.1.4.2
> Build ID: 6.1.4.2-1.fc29

Thanks for info. Closing.