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

[bugzilla-daemon at bugs.documentfoundation.org]

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

David Lynch <david_lynch at blueyonder.co.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |UNCONFIRMED
                 CC|                            |david_lynch at blueyonder.co.u
                   |                            |k
     Ever confirmed|1                           |0

--- Comment #2 from David Lynch <david_lynch at blueyonder.co.uk> ---
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.

-- 
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/3277cbc2/attachment.html>