Issue 97019 - Select Special (empty cells, formulae, values etc)
Summary: Select Special (empty cells, formulae, values etc)
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks: 15522
  Show dependency tree
 
Reported: 2008-12-08 13:32 UTC by vince
Modified: 2013-01-29 21:39 UTC (History)
2 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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