https://bugs.documentfoundation.org/show_bug.cgi?id=92628
Bug ID: 92628
Summary: EDITING: Double click in formula sometimes gets wrong
word boundaries
Product: LibreOffice
Version: 4.4.4.3 release
Hardware: x86-64 (AMD64)
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 117132
--> https://bugs.documentfoundation.org/attachment.cgi?id=117132&action=edit
Speadsheet with example formula for testing double click word boundaries
When double clicking a cell reference inside a formula, sometimes the wrong
word boundaries are used resulting in more being selected than expected.
Specifically, if the cell reference is followed by numbers, the cell reference
and the numbers end up being selected, instead of just the cell reference.
In the spreadsheet attached, the formula
=IF(A3="","",IF(LEN(A3)<=135,A3,IF(LEN(A3)<=260,LEFT(A3,SEARCH("
",A3,125)),LEFT(A3,SEARCH(" ",A3,130)))))
is used as an example. Double clicking the cell reference A3 works as expected
in most cases.
Double clicking the A3 cell reference in the SEARCH() functions results in
"A3,125" or "A3,130" being selected instead of just A3 being selected as would
be expected.
As a work around, adding a space after the comma (i.e. SEARCH(" ",A3, 130))
makes double clicking work as expected.
Tested using LibreOffice Calc 4.4.3 (Windows) and 4.3.7.2 (Fedora 21)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
