Description: Calc allowed "live" editing a formula with content from tabs other than the edited cell's tab by navigating to them and selecting cells. Versions 6.1.5.2 and 6.2.2 appear to stop the cell edit as soon as another tab is selected. True with in-cell editing and without, with slight difference. Steps to Reproduce: In-Cell Edit 1. select an empty cell 2. type "=" 3. select another tab 4. select a non-blank cell 5. hit "Enter" 6. go to original tab and cell 7. see nothing but an "=" Edit in Formula Bar 1. select an empty cell 2. type "=" in formula bar 3. select another tab 4. select a non-blank cell 4x. see step 4's cell ID added to formula bar 5. hit "Enter" 6. go to original tab and cell 7. see nothing in it Actual Results: Ended with invalid or empty formula iin version 6.1.5.2 and 6.2.2.2 Expected Results: Previous versions would allow completion of a formula with selections from other tabs Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 6.2.2.2 (x64) Build ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d CPU threads: 12; OS: Windows 10.0; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: threaded
I can not confirm with Version: 6.3.0.0.alpha0+ Build ID: c8c0292c2152df8c353aeff32896f0cfa8a53a64 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; and Verze: 6.2.2.2 (x64) ID sestavení: 2b840030fec2aae0fd2658d8d4f9548af4e3518d Vlákna CPU: 1; OS: Windows 10.0; Vykreslování UI: výchozí; VCL: win
not repro with Version: 6.3.0.0.alpha0+ (x64) Build ID: 35d9a2618dc0116378ab795a7b9277d248c5afd4 CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-04-05_04:55:04 Locale: de-DE (de_DE); UI-Language: en-US Calc: threaded some random tries, all worked ok, resolved: worksforme? or wait till 6.3 is released?
Thank you for reporting the bug. I can not reproduce the bug in Version: 6.2.1.2 (x64) Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71 CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: CL Version: 6.3.0.0.alpha0+ (x64) Build ID: 91cdf22b88a4f7bec243c8fb187627e766d3294c CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-08_00:38:10 Locale: en-US (en_US); UI-Language: en-US Calc: CL
@Bruce: Seems to be fixed with dev version. Please could you test it with dev version? You can download it here: http://dev-builds.libreoffice.org/daily/master/ Thank you
I concur that described misbehavior does not appear in 6.3.0.0.alpha0+ (x64). Thank you.
(In reply to bruce from comment #5) > I concur that described misbehavior does not appear in 6.3.0.0.alpha0+ > (x64). Thank you. Thanks for retesting with the latest version. Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.