https://bugs.documentfoundation.org/show_bug.cgi?id=145603
Bug ID: 145603
Summary: Drag-n-drop in formula bar creates mismatch between
cell and formula bar
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When using mouse to highlight part of the string in formula bar, then
drag-n-drop'ing it to a different place, the string in the formula bar changes
as expected, but the string in the cell doesn't change. This mismatch persists
in future editing attempts made in the formula bar, creating all sorts of
problems.
Steps to Reproduce:
1. Create a new empty spreadsheet;
2. Enter a relatively long formula in cell A1, for example
"=SUM(B1:B3)+SUM(C1:C3)";
3. Click in the formula bar to enter editing mode in formula bar. In the
default configuration now the B1:B3 and C1:C3 cells should be highlighted with
different color borders (not sure if this part is relevant);
4. Highlight part of the formula, for example the latter half "+SUM(C1:C3)";
5. Use mouse to drag-n-drop it to the front of the formula, after the "="
character;
6. Observe that in the formula bar, the string is "=+SUM(C1:C3)SUM(B1:B3)" as
expected, but in cell A1 the string is unchanged, still
"=SUM(B1:B3)+SUM(C1:C3)";
7. (Optional) Further editing attempts in formula bar with keyboard will
operate at the same position of two strings, but of course operate on different
characters, and are all messed up. For example, use arrow key or Home/End key
to put cursor between "=" and "+" (mouse clicking seems to work as well), then
Delete key, will delete "+" in the formula bar, but will delete "S" (leaving
"=UM(B1:B3)+SUM(C1:C3)") in A1 cell. The final Enter key which exits editing
mode and commits the formula, will synchronize both places with the string in
cell A1. So for users accustomed of focusing on the formula bar during
editing, this unfortunately gives wrong and unexpected result.
Version Information:
I've heard similar symptoms among the chatters in the Chinese user community
for a while, but only recently be able to experience it myself and investigate.
I can reproduce with both 7.2.3 RC1 and 7.3/master on Windows 10:
Version: 7.2.3.1 (x64) / LibreOffice Community
Build ID: 1d5dee817bde88d78dbcc0d00f88492568e131d5
CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: threaded
and
Version: 7.3.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: c7500945fc5d5bd2130a2d38be0bd4b15445cd90
CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: threaded
The other occurrences I've heard about seem to be on Windows as well, so
tentatively setting the OS field.
In 7.1.7 I can not test because drag-n-drop is not possible in formula bar
(mouse cursor becomes "forbidden"):
Version: 7.1.7.2 (x64) / LibreOffice Community
Build ID: c6a4e3954236145e2acb0b65f68614365aeee33f
CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: zh-CN (zh_CN); UI: zh-CN
Calc: threaded
In 7.0.6 I can not reproduce, the formula bar and cell A1 keep synced after
drag-n-drop:
Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 2; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: zh-CN (zh_CN); UI: en-US
Calc: threaded
Therefore this is also some sort of regression/ImplementationError.
--
You are receiving this mail because:
You are the assignee for the bug.
