Apache OpenOffice (AOO) Bugzilla – Issue 76934
Selection trigger when the cursor is in the middle of a token that can not be followed by a range
Last modified: 2013-08-07 15:12:27 UTC
NOTE: This bug was originally reported here - https://bugzilla.novell.com/show_bug.cgi?id=238739 Tested Build: Downloaded OOo_2.2.0_LinuxIntel_install_wJRE_en-US.tar.gz package from: http://openoffice.bouncer.osuosl.org/?product=OpenOffice.org&os=linuxintelwjre&lang=en-US&version=2.2.0 Problem - In a spreadsheet field, defined as numbers, a value of eg (-0.3,+0.3,=0.3) and use one of the arrow keys (up, down, left, right) to accept the value, the accepted value is displayed as eg -0.3F1616 (where the F1616 is the field number of the field just below/above/to the right or left of the entry field, depending on which arrow key was pressed). If I press the enter key instead of one of the arrow keys the result is ok.
Hi, this is not a bug. It's just the way Spreadsheets work in edit mode of cells. Vursor moves adds a reference to the cell the cell cursor was moved too. This is especially usefull if you have e.g. =SIN( in a cell. Frank
closed invalid
It's a bit more subtle than that. We can be smarter about when to initiate a range selection. =2+<Ok> =sin(<Ok> =3<NOTOK> It's actually somewhat trickier than that. We need to look at what is on both sides of the cursor position =sin(<cursor>3 : not ok If we want to really have a decent finger feel we need to start considering the start and end of the _selection_ rather than jut the edit position =<startsel>3<endsel><cursor> : is ok, if we replace the 3 with a range.
So it's not a defect but an enhancement. Jody do you want to do it by yourself ? Re_assigned to requirements. Frank
fst : it depends on how you define 'defect' :-) I'll likely have a look at this as part of our XL compat display work.