Bug 97095 - FEATUNE REQUEST : NEW OPTHIMIZ‑ED VUNG‑TI‑ÔNS PRO SUB‑STITUTE
Summary: FEATUNE REQUEST : NEW OPTHIMIZ‑ED VUNG‑TI‑ÔNS PRO SUB‑STITUTE
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 97688 (view as bug list)
Depends on:
Blocks:
 
Reported: 2016-01-13 11:50 UTC by nemzag
Modified: 2016-02-14 15:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
SUBSTITUTION HOW TO (30.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-01-26 23:25 UTC, nemzag
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nemzag 2016-01-13 11:50:26 UTC
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/
Comment 1 nemzag 2016-01-26 23:25:36 UTC
Created attachment 122228 [details]
SUBSTITUTION HOW TO

Can someone, help ? 

How can I make poly than 40 substitute in function ? (ERR:514)
Can someone check the file ? Ħêlph حلف plêasë.
Comment 2 Luke 2016-02-11 20:48:25 UTC
*** Bug 97688 has been marked as a duplicate of this bug. ***
Comment 3 Joel Madero 2016-02-12 06:26:40 UTC
Seriously I've asked you before to go to the mailing list to get help writing in English - PLEASE stop reporting bugs that are impossible to understand. There are mailing lists available where users can help you. Don't reopen this bug without a much clearer description.

Also - you've been warned about the uselessness of pinging your own bugs with things like "can someone help" etc... etc....

In the future these will just be closed as INVALID and if you mess with the settings you'll be banned from bugzilla. I usually am not this harsh but you've been warned a variety of times about:

1) Bugs that are incomprehensible because they are virtually not in English ("vrit-ting" is not an English word);
2) Messing with settings (I understand you haven't done it this time but just a heads up, in the future these bugs will immediately go to INVALID).


Moving to NEEDINFO - do not just reopen it stating that the enhancement is obvious - join the mailing list for your locale, describe your problem clearly there, get feedback, and post a clear comprehensible English response then mark as UNCONFIRMED.

Thank you.
Comment 4 nemzag 2016-02-12 10:15:46 UTC
Hi, 

I ask if some‑ône ħêlph, it is be‑cause I real‑ly need to be able to do at least 100 modi‑ficati‑ôn, 
since nô ône give me an answer in ASK.LIBREOFFICE.ORG.

Sorry, buth I need that ħêlph.

About language,
I'm not obligated to write (war) / vrite (vero) in standard Engl‑is,
I have my own in‑vênt‑ed language with beddër com‑bina‑ti‑ôn, and I will use it, because I don't like Engl‑is (or, for / pro, work / varg, thank (die & kill) kanth (live & be),

I'm Albanian Maceduni‑an. Not British‑American.

I will not write at mailing‑list, 
I sub‑scribed and I re‑ceive a lot of use‑less email... 
So I un‑sub‑scrib‑ed

I don't in‑fra‑stand why you threat‑ing me about bann‑ing me, 
I don't plan to mess with sett‑ing.

Can you tell who you are, admin, chief ?

Thanq (ΘΑΝΕϘ‑ΤΕ) you very much.

Good day.
Comment 5 Joel Madero 2016-02-12 16:27:35 UTC
(In reply to nemzag from comment #4)
> Hi, 
> 
> I ask if some‑ône ħêlph, it is be‑cause I real‑ly need to be able to do at
> least 100 modi‑ficati‑ôn, 
> since nô ône give me an answer in ASK.LIBREOFFICE.ORG.

Completely irrelevant. This isn't the place for help and or support. It's a place to report bugs and then *leave them be* (not a place to poke asking for help, asking when it'll be fixed, etc... etc...)
> 
> Sorry, buth I need that ħêlph.

Again completely irrelevant, this isn't the place for *help*.
>
> About language,
> I'm not obligated to write (war) / vrite (vero) in standard Engl‑is,
> I have my own in‑vênt‑ed language with beddër com‑bina‑ti‑ôn, and I will use
> it, because I don't like Engl‑is (or, for / pro, work / varg, thank (die &
> kill) kanth (live & be),

This is a bit ridiculous - the point is to ensure OTHERS can understand you. If you're writing in some other English then that prevents that from happening and your bugs will keep going into NEEDINFO. And in fact you ARE obligated to write in standard English on our bugzilla:

see: https://wiki.documentfoundation.org/QA/Bugzilla/Policies_and_Procedures#Policies

And yes - failing to follow those procedures *is* a way to get banned.

> 
> Can you tell who you are, admin, chief ?

Yes I am one of the administrators.
Comment 6 Luke 2016-02-13 07:58:22 UTC
The Official language of the bugtracker is English. This includes titles. See Bug 97762.

Please follow the rules. This includes not spamming the bug tracker with the same question. Not using the bug tracker for support. And writing your reports in English.
Comment 7 nemzag 2016-02-14 13:25:58 UTC
I ASKED AT ASK.LIBREOFFICE WITH NO RE‑SPONSE, 
SO I ASK HERE PRO ĦÊLPHË / ΗΛΦƏ / حلف !
BE‑CAUSE, I NEED TO MADE POLY THAN 100 CHANGE !!!


I'M ALBANI‑AN NOT ENGL‑IS, 
I WILL VRITE IN GEG LATINE ENGL‑IS,
IF YON WANT TO USE TOSCAN LATIN (FROM WHO IS DERIVED ITALIAN, FRENCH, ENGLISH),
IT'S YOUR CHOICE, 
BUT I WILL NOT USE IT... 
EVEN IF YOU OB‑LIGATE ME OR RE‑PRESS ME.

IF I'M NOT FREE TO VRITE HOW I WANT,
THEN I WILL NOT MADE ANY RE‑PORT ANY‑POLY.


THE PURPOSE OF MY VRIT‑ANG IS TO RIGHT POSI‑TI‑VE‑LY AND ALSO RIGHT‑LY...
IF THEY COM‑PRE‑HEND OR NOT, IS IR‑RE‑LEV‑ANT PRO ME, 

IF YOU WANT TO USE ALL THE TIME :
THANK : DIE & KILL IN GREEK ORTHODOX,
MERCY MERCI (MARA, MORS, MORTS, SMRT ; DIE), 
OR FOR, DOOR, WORD, WORLD, WHORE, WORRY
LIKE THE OB‑SESS‑ED BEAST OF APO‑CAL‑YPSE, 
IT'S YOUR CHOICE, 

BUT IN ALBANIA, YUGO‑SLAVIA, BULGARIA, GREECE, MACEDONIA
WE WILL NOT SUP‑PORT YOU.

WE UN‑DER‑STAND THE ROOT, ETYMOLOGY & SEMANTIC OF THE UGLYSH,
SO WE WILL NOT USE IT...
AND THAT'S ALL.

YOU ARE A LIBREOFFICE ADMIN, GREAT,
I'M THE HAKAN IMPERATOR OSCAR CAESAR GAZDA QADI SUDDA BUDDHA MÊNDI RAJA.

I SPEAK AT IM‑PERA‑TI‑VE 
AND IN GEG SHQYPË ÔKYPTEROS (SONOUROUS, LOUD, ORIGINAL, ANTIQUE LANGUE),

I HATE THE TOSCANE SCIPIO AND DE‑VIA‑TI‑ÔN LIKE FRENCH OR ENGL‑IS...
I WILL USE & KEEP MY QRÊGU GEG DIA‑LECT EVEN IN ENGL‑IS.

IF I CAN'T HERE THEN I WILL NOT RE‑PORT AND SUG‑GEST NO‑THING.

GOOD DAY. KANTH YOU.
Comment 8 Joel Madero 2016-02-14 15:40:30 UTC
(In reply to nemzag from comment #7)
> I ASKED AT ASK.LIBREOFFICE WITH NO RE‑SPONSE, 
> SO I ASK HERE PRO ĦÊLPHË / ΗΛΦƏ / حلف !
> BE‑CAUSE, I NEED TO MADE POLY THAN 100 CHANGE !!!
> 
> 
> I'M ALBANI‑AN NOT ENGL‑IS, 
> I WILL VRITE IN GEG LATINE ENGL‑IS,
> IF YON WANT TO USE TOSCAN LATIN (FROM WHO IS DERIVED ITALIAN, FRENCH,
> ENGLISH),
> IT'S YOUR CHOICE, 
> BUT I WILL NOT USE IT... 
> EVEN IF YOU OB‑LIGATE ME OR RE‑PRESS ME.
> 
> IF I'M NOT FREE TO VRITE HOW I WANT,
> THEN I WILL NOT MADE ANY RE‑PORT ANY‑POLY.

Due to continued violation of policies (most notably refusal to use proper English and wasting everyone's time) - you are being permanently banned from the bug tracker.