Another LO anti-feature

users
#1

How can I disable the silly dialog that pops up after every search&replace on
a Calc sheet? After correcting a column of 250,000 numbers it tries to write
250,000 cell addresses into a list box which takes by a magnitude more time
than the replacement process.
If such feature is really, really desired by the Excel fans, then it should
be possible to disable it. Furthermore, such feature should be supervised by
an experienced Calc developer who knows that a search run returns a
collection com.sun.star.sheet.SheetCellRanges with interface
XSheetCellRanges having method getRangeAddressesAsString. In my case, this
method would return one string "Sheet1.A1:A250000"
http://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/XSheetCellRanges.html#getRangeAddressesAsString

#2

Hi Andreas,

How can I disable the silly dialog that pops up after every search&replace on
a Calc sheet?....

You're not the first one with this idea. See:
https://bugs.documentfoundation.org/show_bug.cgi?id=83614

I've marked this to be evaluated, possibly not too hard, so there may be
many people that are able to help with making the option.

Ciao - Cor

#3

For 5.2.4 search/replace will not show more that 1000 results to resolve
tdf#92160

=-ref-=

https://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-5-2&id=1a093a2c06c30c17e483614e36a75907e7d0991f

https://cgit.freedesktop.org/libreoffice/core/commit/?id=ba68e6dd7ad99ef2a2720f327813d13550b98966

#4

There is a bug report tdf#92160 - sc: limit search results to 1000 entries.

I think it should be on the last 5.2.4.2 released version.

Miguel Ángel.