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
