https://bugs.documentfoundation.org/show_bug.cgi?id=107369
David Lynch <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
CC| |[email protected]
| |k
Ever confirmed|1 |0
--- Comment #2 from David Lynch <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
