Issue 97019

Summary:	Select Special (empty cells, formulae, values etc)
Product:	Calc	Reporter:	vince <openoffice>
Component:	editing	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues, weigel
Version:	OOo 3.0
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	FEATURE	Latest Confirmation in:	---
Developer Difficulty:	---
Issue Depends on:
Issue Blocks:	15522

Description vince 2008-12-08 13:32:56 UTC

A "select special" option should be implemented in order to select special cells 
from a marked region. This comes in very handy, if you want to fill empty cells in 
a range with a default value, for example (see also issue #97018 "Entering 
multiple values").

Comment 1 Stefan Weigel 2008-12-12 19:36:26 UTC

Important feature, I think.

Meanwhile you may help yourself with a little macro. For example this code will
select empty cells within your selection:

Sub SelectEmptyCells()
    dim oController as object
    oController = StarDesktop.CurrentComponent.currentController
    oController.select(oController.Selection.queryEmptyCells)
end Sub

Comment 2 villeroy 2009-01-03 22:04:10 UTC

http://ooomacros.org/user.php#221020
Download, extract oxt, Tools>Packages... Add oxt