Date: prev next · Thread: first prev next last
2022 Archives by date, by thread · List index


I wonder if the capability in the new ScriptForge libraries could be exploited. Several routines in there look useful, such as:
ReplaceChar  Replaces all occurrences of the characters specified in the 
Before parameter by the corresponding characters specified in After.
ReplaceStr   Replaces in a string some or all occurrences of an array of 
strings by an array of new strings.
Reverse Returns the input string in reversed order.

Sort Sort a one dimension array in ascending or descending order. Text comparisons can be case-sensitive or not.
All of the above I do currently using existing Calc capability (without 
use of macros). However, if the ScriptForge functions above were Calc 
functions, the result would be easier to develop and less error prone. 
(This is what happened when new functions such as REGEX and CONCAT were 
introduced.)
I probably have enough coding skills to embed these ScriptForge routines 
into User-Defined Calc functions. However, I am wary of doing this, 
because some such code I have previously developed did what I wanted but 
was too slow to be usable. And my spreadsheets already are sluggish, see 
<https://bugs.documentfoundation.org/show_bug.cgi?id=144205> or 
<https://bugs.documentfoundation.org/show_bug.cgi?id=144257>
Can I have  feedback please on whether requests for new Calc functions 
such as those above are likely to be feasible and implemented?
Please, any tips on how I should write code to exploit these ScriptForge 
routines in a manner that makes them speedy?
David Lynch


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.