Bug 107370 - Enhancement to Calc function REPLACE
Summary: Enhancement to Calc function REPLACE
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.3.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2017-04-23 14:04 UTC by David Lynch
Modified: 2019-01-14 17:55 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Lynch 2017-04-23 14:04:57 UTC
REPLACE("Text"; Position; Length; "NewText")
	Text refers to text of which a part will be replaced.
	Position refers to the position within the text where the replacement will begin.
	Length is the number of characters in Text to be replaced.
	NewText refers to the text which replaces Text.

Enhancement requested:

*** Text and NewText can be regular expressions. ***

This enhancement is compatible with existing REPLACE.
Comment 1 Joel Madero 2017-04-23 15:02:28 UTC
From what I can tell Microsoft does not do this with Excel. This could potentially cause some serious interoperability issues.

That being said, I'll mark as NEW because it's a valid request with caveat on the below.

Enhancement requests are handled entirely by volunteers. The volunteer needs to find the enhancement both interesting and within their skillset. Furthermore, they'd have to weigh the benefit (which seems quite small, likely of our millions of users only a handful would ever use this) against the cost (interoperability and time). This particular enhancement seems to be quite difficult which means only a few developers would have the potential skills. Furthermore, the cost could be quite high. To be realistic, I don't think this will ever be implemented but it'll be in the database just in case someone wants to try to tackle it.
Comment 2 David Lynch 2017-04-23 16:24:10 UTC
I am asking only for what is available already in the Find and Replace dialog. I had hoped that code reuse would be possible in enabling this in a Calc function.
Comment 3 Joel Madero 2017-04-23 19:07:07 UTC
(In reply to David Lynch from comment #2)
> I am asking only for what is available already in the Find and Replace
> dialog. I had hoped that code reuse would be possible in enabling this in a
> Calc function.

Unlikely. The code is very different.