[Libreoffice-bugs] [Bug 107369] Enhancement to Calc function SUBSTITUTE

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=107369

--- Comment #3 from Joel Madero <jmadero.dev at gmail.com> ---
(In reply to David Lynch from comment #2)
> My spreadsheets have frequent instances of code like:
> 
> =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE
> (SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE
> (SUBSTITUTE(E2,MID(G2,1,1),"",1),MID(G2,2,1),"",1),MID(G2,3,1),"",1),MID(G2,
> 4,1),"",1),MID(G2,5,1),"",1),MID(G2,6,1),"",1),MID(G2,7,1),"",1),MID(G2,8,1),
> "",1),MID(G2,9,1),"",1),MID(G2,10,1),"",1),MID(G2,11,1),"",1),MID(G2,12,1),
> "",1),MID(G2,13,1),"",1),MID(G2,14,1),"",1),MID(G2,15,1),"",1)
> 
> ... and the formula would be longer if it were legal to make it so.
> 
> My suggestion for enhancement would reduce this to a single call to
> substitute.
> 
> This code is calculating {E2}-{G2}, where {X} is the contents of cell X
> regarded aa a set.

This is obviously an extreme cornercase and probably not a good use of a
spreadsheet application to begin with. Not only would would this be a
significant hack of the code requiring someone with a high level of skills, it
would also cause potential nightmares for interop. Finally, I suspect this
would help all of 1 person ever.

We could mark it as NEW and leave it there indefinitely which used to be the
protocol for these kinds of requests. 

My instinct is to mark this as WONTFIX but I'll leave someone else to do that.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170423/733f0134/attachment.html>