https://bugs.documentfoundation.org/show_bug.cgi?id=97095
Bug ID: 97095 Summary: FEATUNE REQUEST : NEW OPTHIMIZ‑ED VUNG‑TI‑ÔNS PRO SUB‑STITUTE Product: LibreOffice Version: 5.0.4.2 rc Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: nem...@hotmail.com Hi have some trouble with the func‑ti‑ôn sub‑stitute I get error... Buth still I have to ask you some‑thing : Can you please in‑stead than vrit‑ing all of this (con‑vert Latin character in others scripts (Greek, Cyrillic) : A = ܐ, B = ܒ, etc...) =(MAJUSCULE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE(SUBSTITUE($G3495;A.$B$2;A.$B$3);A.$D$2;A.$D$3);A.$E$2;A.$E$3);A.$G$2;A.$G$3);A.$H$2;A.$H$3);A.$I$2;A.$I$3);A.$J$2;A.$J$3);A.$K$2;A.$K$3);A.$L$2;A.$L$3);A.$M$2;A.$M$3);A.$N$2;A.$N$3);A.$O$2;A.$O$3);A.$P$2;A.$P$3);A.$Q$2;A.$Q$3);A.$R$2;A.$R$3);A.$S$2;A.$S$3);A.$T$2;A.$T$3);A.$U$2;A.$U$3);A.$V$2;A.$V$3);A.$W$2;A.$W$3);A.$X$2;A.$X$3);A.$Y$2;A.$Y$3);A.$Z$2;A.$Z$3);A.$AA$2;A.$AA$3);A.$AB$2;A.$AB$3);A.$AC$2;A.$AC$3);A.$AD$2;A.$AD$3);A.$AE$2;A.$AE$3);A.$AF$2;A.$AF$3);A.$AG$2;A.$AG$3);A.$AH$2;A.$AH$3);A.$AI$2;A.$AI$3);A.$AJ$2;A.$AJ$3);A.$AK$2;A.$AK$3);A.$AL$2;A.$AL$3);A.$AM$2;A.$AM$3);A.$AN$2;A.$AN$3);A.$AO$2;A.$AO$3))) To use this one : =(MAJUSCULE(SUBSTITUE($G3495;A.$B$2:A.AO$2;A.$B$3:A.$AO$3))) =(MAJUSCULE(SUBSTITUE($G3495;A.$(B:AO)$2;A.$(B:AO)$3))) or =(MAJUSCULE(SUBSTITUE($G3495;A.$*$2;A.$*$3))) {* = ALL} And in others case of superposed table : =(MAJUSCULE(SUBSTITUE($G3495;A.$B$2:A.B$40;A.$C$3:A.$C$40))) or =(MAJUSCULE(SUBSTITUE($G3495;A.$B$(2:40);A.$C$(3:40)))) or =(MAJUSCULE(SUBSTITUE($G3495;A.$B$*;A.$C$*))) {* = ALL} IT WOULD BE LOT BEDDËR !!! AND WITH‑OUT LIMITA‑TI‑ÔN OF SUB‑STITUTE (POLY TʰAN 200) BE‑CAUSE NOW I GET ERR:514 !!! KANTH YOU, ƷOOD DAY. ASK.LIBREOFFICE.ORG FORUM POST : - https://ask.libreoffice.org/en/question/61889/new-functions-for-substitute/ - https://ask.libreoffice.org/en/question/62973/function-substitute-err514/ -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs