Defaults in Find dialogue and toolbar for Calc

users
#1

The defaults in the Find toolbar and the Find dialog are:

Direction: Rows Search in: Formulae

I normally want the opposite: Search in columns (because columns usually consist of more homogeneous data than columns) and search in Data (because usually I'm usually looking at the finished spreadsheet rather than constructing it, and even when constructing a spreadsheet, search for a formula is infrequent).

You cannot change the default from the toolbar and, if you change the default from the dialog then move to another sheet, it changes back to the unwelcome default.

Is there a way to change the default permanently?

Is there a reason for the current behaviour? If not, I propose to ask for a change.

David Lynch

#2

Not that I've been able to find. I also prefer to search columns
before rows and wish there were a way to make that the default.

#3

>
> The defaults in the Find toolbar and the Find dialog are:
>
> Direction: Rows Search in: Formulae
>
> I normally want the opposite: Search in columns (because columns usually
> consist of more homogeneous data than columns) and search in Data
> (because usually I'm usually looking at the finished spreadsheet rather
> than constructing it, and even when constructing a spreadsheet, search
> for a formula is infrequent).
>
> You cannot change the default from the toolbar and, if you change the
> default from the dialog then move to another sheet, it changes back to
> the unwelcome default.
>
> Is there a way to change the default permanently?

Not that I've been able to find. I also prefer to search columns
before rows and wish there were a way to make that the default.

I think it would be even nicer if it remembered the settings from last time.

Kind regards

Johnny Rosenberg

#4

The defaults in the Find toolbar and the Find dialog are:

Direction: Rows Search in: Formulae

I normally want the opposite: Search in columns (because columns usually
consist of more homogeneous data than columns) and search in Data
(because usually I'm usually looking at the finished spreadsheet rather
than constructing it, and even when constructing a spreadsheet, search
for a formula is infrequent).

You cannot change the default from the toolbar and, if you change the
default from the dialog then move to another sheet, it changes back to
the unwelcome default.

Is there a way to change the default permanently?

Not that I've been able to find. I also prefer to search columns
before rows and wish there were a way to make that the default.

+1

I think it would be even nicer if it remembered the settings from last time.

+2

#5

Enhancement request submitted:

<https://bugs.documentfoundation.org/show_bug.cgi?id=145292>

David Lynch