Apache OpenOffice (AOO) Bugzilla – Issue 40174
XRangeSelection should support a "single cell" selection mode
Last modified: 2013-02-24 21:08:55 UTC
XRangeSelection interface should support a "single cell" selection mode, i.e. a selection mode that only lets you select one single cell. Currently, this interface only supports a "simple area select" - a mode where you can select multiple adjoining cells. The "single cell" select mode should also provide the following two sub-modes: mode 1) you can only select a cell on the current sheet, and the resulting formula will NOT include a sheet reference e.g. "$B$23" mode 2) you are permitted to select a cell on a sheet that is not current, and the resulting formula will include a sheet reference e.g. "$Sheet2.$B$23". Such mode switch can be accomplished by introducing an additional property (or two) in the RangeSelectionArguments service.
One minor change. There will NOT be the two sub-modes specified in my original comment. This single cell mode will follow the way a similar mode is implemented natively in Calc (for example, selecting a target cell in the Goal Seek dialog). I've started working on this, so changing the status to STARTED...
Assigning this issue to myself
STARTED again
Created attachment 21559 [details] A patch
The new property is a boolean and is named "SingleCellMode". An evaluation of this patch is much appreciated. :-) Kohei
In this implementation, the cell reference always stays 3D (i.e. a reference that includes the sheet address), because switching to a 2D reference when the selected cell is on the current sheet did not work well with ScSimpleRefDlg.
Retarget to OOo Later & set the priority to P5
Hi Kohei and Niklas, I would like to avoid that issues of type PATCH linger in Issuezilla for ages. Kohei, I changed the target milestone to "not determined". I think after the review of the patch we'll find the appropriate target. But let's see whether it's ready for integration first. Thanks, Stefan
Hi Stephan, That's fine by me. I appreciate your attention to this issue. -Kohei
The patch is good. I only changed the formatting of the idl description, and committed it to child workspace "calc36". Thanks, Kohei!
reassigning to QA for verification re-open issue and reassign to oc@openoffice.org
reassign to oc@openoffice.org
reset resolution to FIXED
Created attachment 36265 [details] Document to verify the new behaviour
looks good in cws calc36 => verified
closed because fix available in OpenOffice.org Developer Snapshot Build src680_m167