Another LO anti-feature

classic Classic list List threaded Threaded
5 messages Options
Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|

Another LO anti-feature

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
Cor Nouws Cor Nouws
Reply | Threaded
Open this post in threaded view
|

Re: Another LO anti-feature

Hi Andreas,

Andreas Säger wrote on 21-12-16 21:21:
> 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

--
Cor Nouws
GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28  A038 E49D 7365 B134 80A6
- vrijwilliger http://nl.libreoffice.org
- volunteer http://www.libreoffice.org
- The Document Foundation Membership Committee Member

--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
V Stuart Foote V Stuart Foote
Reply | Threaded
Open this post in threaded view
|

Re: Another LO anti-feature

m.a.riosv m.a.riosv
Reply | Threaded
Open this post in threaded view
|

Re: Another LO anti-feature

In reply to this post by Andreas Säger
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.
Luuk Luuk
Reply | Threaded
Open this post in threaded view
|

Re: Another LO anti-feature

In reply to this post by V Stuart Foote
why 1000 ?

an option to make it not show at all is very much a better option


On 22-12-16 00:13, V Stuart Foote wrote:

> 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
>
>
>
>
> --
> View this message in context: http://nabble.documentfoundation.org/Another-LO-anti-feature-tp4203317p4203336.html
> Sent from the Users mailing list archive at Nabble.com.
>


--
To unsubscribe e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Windows10 / LibreOffice  (latest?)