<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Enhancement to Calc function SUBSTITUTE" href="https://bugs.documentfoundation.org/show_bug.cgi?id=107369#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Enhancement to Calc function SUBSTITUTE" href="https://bugs.documentfoundation.org/show_bug.cgi?id=107369">bug 107369</a> from <a class="email" href="mailto:jmadero.dev@gmail.com" title="Joel Madero <jmadero.dev@gmail.com>"> Joel Madero</a> <pre>(In reply to David Lynch from <a href="show_bug.cgi?id=107369#c2">comment #2</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>