WikiDer > Yordam: Saralash - Vikipediya
![]() | Ushbu yordam sahifasi a qanday qilib ko'rsatma berish. Unda Vikipediya normalari va amaliyotlarining ba'zi jihatlari (lariga) oid jarayonlar yoki protseduralar batafsil bayon etilgan. Bu bittasi emas Vikipediya qoidalari yoki ko'rsatmalari, va o'zgaruvchan darajalarni aks ettirishi mumkin Kelishuv va tekshirish. |
Vikiteks |
---|
Saralash jadvallaridan foydalanish
Vikipediyani ko'rib chiqayotganda duch kelishingiz mumkin jadvallar qilingan tartiblangan. Saralanadigan jadval bir yoki bir nechta sarlavha kataklaridagi o'qlar bilan aniqlanadi. Ularni bosish jadval satrlarini tanlangan ustun asosida o'sish tartibida tartiblashiga olib keladi. Xuddi shu o'qni ikkinchi marta bosish kamayish tartibida tartiblanadi. Uchinchi marta bosish butun jadvalning asl tartibini tiklaydi. Masalan; uchinchi marta bosish sabab bo'ladi Qasddan odam o'ldirish darajasi bo'yicha mamlakatlar ro'yxati subregion tomonidan asl tartibiga qaytarish.
Haqiqiy saralash jarayoni kompyuteringizda amalga oshiriladi mijoz tomonidagi JavaScript. Shu sababli ushbu funksiyadan faqat sizning veb-brauzeringizda JavaScript yoqilgan bo'lsa foydalanish mumkin. Saralash jarayoni, shuningdek, kompyuteringizga va ma'lumotlar miqdoriga bog'liq. Sekin kompyuterda juda katta stolni saralash uzoq vaqt talab qilishi mumkin.
Misol
Bu kichkintoyning misoli tartiblangan stol.
ism | ma'lumotlar | ko'proq ma'lumotlar |
---|---|---|
mushuklar | 273 | 53 |
itlar | 65 | 8,492 |
sichqonlar | 1,649 | 548 |
Murakkab sarlavhali jadvallar
Hozirgiga qaraganda ancha murakkab sarlavhali jadvallarni to'g'ri saralash. Masalan:
ism | ma'lumotlar ustunlari | boshqa ustun | |
---|---|---|---|
ma'lumotlar | ko'proq ma'lumotlar | ||
mushuklar | 273 | 53 | 1 |
itlar | 65 | 8,492 | 2 |
sichqonlar | 1,649 | 548 | 3 |
Ikki yoki undan ortiq sarlavha satrlari yordamida saralash strelkalari sukut bo'yicha pastki sarlavha qatoriga joylashtiriladi. Sozlash orqali ularni maksimal bir qator yuqoriroq joylashtirish mumkin class = "sorttop"
pastki satr satrining yuqori qismida.
Odatiy
| {| class = "wikitable sortable" | -! 1-ustun! ustun 2 | -! style = "text-align: left;" | 3! style = "text-align: left;" | 7 | - | 1 | 3 | - | 2 | 4 |} | Foydalanish
| {| class = "wikitable sortable" | -! 1-ustun! ustun 2 | - class = "sorttop"! style = "text-align: left;" | 3! style = "text-align: left;" | 7 | - | 1 | 3 | - | 2 | 4 |} |
Murakkab datarovli jadvallar
Jadvallarda bir nechta qatorlarni o'z ichiga olgan kataklar bo'lishi mumkin | qatorlar =n
. (Qarang Yordam: rowspan).
Satrlar satrini har safar ishlatishda ko'rsatilishi kerak. Har qanday saralashni amalga oshirishdan oldin, qator oralig'ini sozlash to'g'ri bo'lishi kerak. Noto'g'ri rowspan tashkiloti noto'g'ri ma'lumotlarni qoldirib, saralash opsiyasini buzadi.
Quyidagi misollarga qarang.
Tartiblanganda barcha qatorlar to'ldiriladi. Ratsionsiz jadvallarni kamroq tajribali muharrirlar va jadvalni tahrirlash uchun bir martagina to'xtaydigan muharrirlar osonroq saqlab turishadi.
Ish tartibida tartiblash bilan qatorlarni to'g'ri qatorga qo'ying:
ism | mashhurlik | ma'lumotlar | ko'proq ma'lumotlar | yil |
---|---|---|---|---|
mushuklar | mashhur uy hayvonlari | 273 | 53 | 2013 |
itlar | 65 | 8,492 | 2014 | |
sichqonlar | 1,649 | 548 |
E'tibor bering, saralashdan so'ng, qatorlarni ajratish katakchalari qatorlarga bo'linadi va ularning tarkibi takrorlanadi (misolda "2014" yil). Agar jadvalning asl tartibi xuddi shu o'qga uchinchi marta bosish orqali tiklansa, u holda hujayralar takrorlanib qoladi va asl qatorga qaytarilmaydi.
Satrlarni buzish va qatorlar va ustunlardagi aralashmalarga olib keladigan noto'g'ri qatorlar:
ism | mashhurlik | ma'lumotlar | ko'proq ma'lumotlar | yil |
---|---|---|---|---|
mushuklar | mashhur uy hayvonlari | 273 | 53 | 2013 |
itlar | 65 | 8,492 | 2014 | |
sichqonlar | 1,649 | 548 |
Onlayn jadval muharrirlari va rowspan
Bu erda oson wiki jadvali muharriri mavjud:
Jadvalning alohida kataklaridagi matn va havolalarni tahrir qilishni osonlashtiradi. Ayniqsa, stol korpusida qatorlar bo'lmaganda juda oson. Oldingi bo'limga qarang. Qatorsizlar jadvalning pastki ramkasini o'zgartirish va narsalarni aylantirish osonroq. Vikitekst ramkasi soddalashtirilganidan so'ng, onlayn jadval muharriri ham sodda bo'ladi, chunki jadvalni tahrirlash uchun vikitekstni ko'p tahrirlash shart emas.
Tor ekranda ko'proq ustunlar uchun imkoniyatlar
Vertikal sarlavhalar
- Qarang: Andoza: Vert header
mushuklar | 273 | 53 | 1 |
itlar | 65 | 8,492 | 2 |
sichqonlar | 1,649 | 548 | 3 |
Ushbu shablon shuningdek satrlarni yoki ustunlarni qamrab oluvchi sarlavhalar bilan ishlaydi (yordamida) qatorli va kolspan). Eslatma vertikal chiziq yo'qligini |
o'rtasida qator oralig'i = 2
va {{vert header
| {| class = "wikitable sortable" | -! rowspan = 2 {{vert header | stp = 1 | name}}! colspan = 2 {{vert header | ma'lumotlar ustunlari}}! rowspan = 2 {{vert header | stp = 1 | boshqa ustun}} | -! {{vert header | stp = 1 | ma'lumotlar}}! {{vert header | stp = 1 | qo'shimcha ma'lumotlar}} | - | mushuklar | 273 | 53 | 1 | - | itlar | 65 | 8,492 | 2 | - | sichqonlar | 1,649 | 548 | 3 |} |
Tugmalarni alohida qatorda saralash
- Eslatma: Dan Aprel 2020 muhokamasi kimdir ekran o'quvchi yozgan: "Bo'sh / bosish mumkin bo'lgan qator bilan hali ham o'qish mumkin, bo'sh katakchalardan o'tib ketish juda zerikarli; Men ular boshqa holatlarda ham bo'lishi mumkinligini bilaman. Ehtimol, bu kichik kirish imkoniyatlarini yaxshilashni yo'qotadigan holatlardan biri ekranlarda yaxshiroq namoyish qilish uchun hozircha. " Bor Phabricator vazifasi T35249 saralash belgisining standart joylashuvi sarlavha matni ostida bo'lishini so'rab.
![]() | Ushbu bo'lim kirish imkoniyati savol ostida. Muayyan masala: bo'sh jadval sarlavhalari klaviatura navigatsiyasini murakkablashtiradi va ekranni o'quvchi uchun mazmunli chiqishni bermaydi. Tegishli munozarani munozara sahifasi. Maqolalarni yanada qulayroq qilish to'g'risida ma'lumotni bu erda topishingiz mumkin WikiProject kirish imkoniyatlari. |
Jadvalni tor ekranlarda ixchamroq qilish uchun saralash tugmachalari matn joylashgan sarlavha katakchalari ostiga qo'shimcha sarlavha qatoriga qo'yilishi mumkin. Saralash tugmasi har doim eng pastki sarlavha hujayrasida tugaydi.
Qator oralig'ini qo'shing <br>
yoki bo'sh joy & nbsp;
bo'sh sarlavha hujayralaridan birida. Aks holda saralash qatori juda tor bo'ladi. Agar siz foydalanayotgan bo'lsangiz data-sort-type = "..."
xususiyati, sarlavha katakchasiga saralash belgisi bilan qo'shilishi kerak.
Saralash tugmachalari markazlashtirilishi mumkin style = "background-position: center;" |
har bir hujayrada. Taqqoslash uchun, bu faqat quyida joylashgan oxirgi katak uchun amalga oshiriladi. Mana jadval, keyin sarlavha katakchalari uchun vikitekst.
| {| class = "wikitable sortable" | -! satr oralig'i = 2 | ism! colspan = 2 | ma'lumotlar ustunlari! satr uzunligi = 2 | yana bir ustun | -! ma'lumotlar! ko'proq ma'lumotlar | -! |
!! !! !! style = "background-position: center;" | | -
Ikkilamchi kalitAgar ustun qiymatni bir necha marta o'z ichiga oladigan bo'lsa, ustunni saralash har bir kichik to'plam ichidagi satrlarning tartibini shu ustunda bir xil qiymatga ega bo'lgan holda saqlaydi (barqaror saralash
). Shunday qilib, birlamchi, ikkilamchi, uchinchi va hokazo kalitlarga asoslanib saralash birinchi navbatda eng kam ahamiyatli tugmachani saralash orqali amalga oshirilishi mumkin va hokazo. Masalan, quyidagi jadvalni Matn ustunida, so'ngra Raqamlar ustunida saralash uchun avval tugmachani bosing. "Raqamlar" ustun sarlavhasi (ikkilamchi saralash klavishi), so'ngra "Matn" ustun sarlavhasi (asosiy saralash klavishi).
Bir nechta saralash tugmachalari yordamida jadvalni saralashning yana bir usuli bu keyingi tugmachalar uchun ustun sarlavhalarini bosish paytida shift tugmachasini bosib ushlab turishdir. Masalan, quyidagi jadvalni Matn ustunida, so'ngra Raqamlar ustunida saralash uchun avval "Matn" ustun sarlavhasini (asosiy saralash klavishi) bosing, so'ngra shift tugmachasini bosib ushlab turing va "Raqamlar" ustun sarlavhasini bosing ( ikkilamchi saralash kaliti). | Raqamlar | Matn | Sanalar | Valyuta |
---|---|---|---|---|
4 | Qo'shimcha matn | a | 4.20 | 01. Yanvar 2005 |
5 | qator 1 | 05/12/2006 | 7.15 | a |
1 | qator 2 | 02-03-2004 | 5.00 | b |
1 | qator 3 | 03-02-2004 | 5.00 | a |
2 | qator 4 | x | 13-aprel-2005 yil | |
2 | qator 5 | a | 13-aprel-2005 yil | |
3 | qator 6 | a | 6.50 | 17. 2006 yil |
3 | qator 7 | z | 2.30 | 25. 2006 yil |
3 | qator 8 | z | 5.50 | 28. 2006 yil |
3 | 9-qator | z | 3.77 | 31. 2006 yil |
3 | qator 10 | z | 1.50 | 01. 2006 yil |
25 | qator 11 | z | 1.50 | 01. 2006 yil |
qator 12 |
Pastki
VisualEditor-dagi jadvalning xususiyatlar paneli jadvalni saralash mumkin deb belgilashga imkon beradi.Jadvallar amalga oshirilishi mumkintartiblangan orqalimijoz tomonidagi JavaScript qo'shib
class = "wikitable sortable" ularning yuqori qatoriga. Ushbu jadvallar kerakli miqdorda katakchalar bilan to'g'ri formatlanishi kerak. Bundan tashqari, ustuningiz sarlavhalari to'g'ri ko'rsatilganligiga ishonch hosil qilishingiz kerakVikikod !
. Buning uchun
belgi jadval sintaksisida ishlatiladi. Agar siz foydalanayotgan bo'lsangizVizual muharrir
, jadvalning xususiyatlar dialogini ochishingiz va saralash imkoniyatini tanlashingiz mumkin.
Oddiy misol Bu jadvalning vikisursidirko'rsatilgan
birinchi bo'limda va jadvallarni saralashni yoqishning odatiy usuli ko'rsatilgan:
{| class = "wikitable sortable" | -! ism! ma'lumotlar! ko'proq ma'lumotlar | - | mushuklar | 273 | 53 | - | itlar | 65 | 8,492 | - | sichqonlar | 1,649 | 548 |} !
The sarlavha hujayralari bo'lgan hujayralarni bildiradi. Jadval saralanishi uchun jadvalning birinchi satrlari to'liq shu sarlavha kataklaridan tuzilishi kerak. Siz jadval jadvalining asosiy sintaksisini bilib olishingiz mumkin.
Jadvallarga kirish
Qatorlarning dastlabki tartib tartibi Dastlab foydalanuvchilarga jadval taqdim etilganda, satrlar har doim vikitekstdagi kabi tartibda ko'rinadi. Agar jadval ma'lum bir ustun bo'yicha tartiblangan ko'rinishini istasangiz, vikitekstning o'zini shu tartibda saralashingiz kerak. Bu odatda birinchi ustun uchun amalga oshiriladi. TheVisualEditor jadvalning alohida ustunlari va qatorlari bo'ylab harakatlanishni osonlashtiradi. Bu haqda, shuningdek jadvalni boshlang'ich alifbo tartibida qo'yish haqida ma'lumot olish uchun qarang.
§ Dastlabki alifbo tartibida
Cheklovlar va istisnolar
Jadvallar faqat vertikal ravishda pastga qarab saralash uchun tugmachani bosishi mumkin (eng ustun ustun nomini bosish jadval satrlarini yuqoriga va pastga qarab o'zlarini qayta tartiblashlariga olib keladi). Sichqoncha bo'ylab gorizontal ravishda saralash mumkin emas (jadvalning ustunlari o'zlarining chapdan o'ngga pozitsiyalarida o'zlarini qayta tartiblashlariga olib kelishi uchun eng chap satrdagi katakchani bosish imkoniyati yo'q).
Tanlangan ustunlarni yaroqsiz holga keltirish Agar ma'lum bir ustun tartiblanmasligini xohlasangiz, belgilang
class = nomaqbul
uning sarlavhasi xujayrasining atributlarida.
Wiki belgisi{| class = "wikitable sortable"! Raqamlar !! Alfavit !! Sanalar !! Valyuta !!class = sortortable |
Saralash mumkin bo'lmagan | - | 1 || Z || 02-02-2004 || 5.00 || Bu | - | 2 || y || 13-aprel-2005 |||| Ustun | - | 3 || X || 17 .aug.2006 || 6.50 || Is | - | 4 || w || 01.Jan.2005 || 4.20 || Tartibsiz | - | 5 || V || 05/12/2006 || 7.15 || Qarang ? | -! Jami: 15 !!!!!! Jami: 22.85 !! |}
Sizning brauzeringizda qanday ko'rinishga ega | Raqamlar | Alifbo | Sanalar | Valyuta |
---|---|---|---|---|
1 | Saralash mumkin emas | 02-02-2004 | 5.00 | Z |
2 | Bu | y | 13-aprel-2005 yil | |
3 | Ustun | X | 6.50 | 17. 2006 yil |
4 | Shunday | w | 4.20 | 01. Yanvar 2005 |
5 | Saralash mumkin emas | 05/12/2006 | 7.15 | V |
Qarang? | Jami: 15 |
Jami: 22.85
Yakuniy qatorlarni saralashdan tashqari
Altbilgi sifatida sarlavha
Siz pastki qismida sarlavhani takrorlashni xohlaysiz. Siz buni yordamida amalga oshirasiz! (Undov belgisi) jadvalning oxirgi qatoridagi barcha kataklar uchun sintaksis. Bu altbilgi sifatida tan olinadi va qator saralashning bir qismi bo'lmaydi. Wiki belgisi | {| class = "wikitable sortable"! Ism !! Familiya !! Balandlik | - | Jon || Smit || 1.85 | - | Ron || Rey || 1.89 | - | Mario || Byanki || 1.72 | -! Ism !! Familiya !! Balandlik |}
|
Balandligi
Oddiy altbilgi Bunga erishish orqali erishish mumkin
class = "sortbottom" |-
).
kerakli jadval qatorida (boshlanadigan satr Wiki belgisi | {| class = "wikitable sortable"! Ism !! Familiya !! Balandlik | - | Jon || Smit || 1.85 | - | Ron || Rey || 1.89 | - | Mario || Byanki || 1.72 | - sinf = "sortbottom" | colspan = "2" | O'rtacha: || 1.82 |}
|
O'rtacha: Agar chiziqlar ketma-ket bo'lsa, pastki qismida bir nechta chiziqlarni ushlab turish mumkin. Agar jadvalning asl tartibi bir xil o'qga uchinchi marta bosish bilan tiklansa, u holda qatorlar qatoriga o'ting
class = "sortbottom"
ular dastlab pastki qismida bo'lmagan taqdirda ham pastki qismida qoladi.
Saralashdan yuqori qatorlarni chiqarib tashlash Bu yuqoridagi tekis (sarlavhasiz) qatorlar uchun yuqoridagi kabi ishlaydi. Bunga erishish orqali erishish mumkin
class = "sorttop" |-
kerakli jadval qatorida (boshlanadigan satr
). Agar chiziqlar ketma-ket bo'lsa, yuqori qismida bir nechta chiziqlarni ushlab turish mumkin.
Saralashni sozlash
Odatiy bo'lib, tizim har bir ustundagi ma'lumotlar turini taxmin qilishga harakat qiladi. Buni dastlabki beshta qatorga qarab va ularning tarkibini baholash orqali amalga oshiradi. Ushbu jarayon ko'pincha ishlaydi, ammo agar siz mos kelmaydigan qiymatlar yoki tizim bilmagan qo'shimcha ko'rsatkichlar bo'lsa, ularni osonlikcha chalkashtirib yuborish mumkin. Ushbu noaniqlikni oldini olish uchun siz ma'lum bir ma'lumot turini majburlashingiz yoki katakning qiymatini bekor qilishingiz mumkin.
meta: Yordam: Saralash # Ustun uchun tartiblash tartibini majburlash The
data-sort-type = "..."
atributini ustun sarlavhasi ichiga qo'shib, ostidagi kataklarning hammasi ma'lum bir ma'lumot turi sifatida ko'rib chiqilishini ta'minlashi mumkin. Saralash katakchasi bilan sarlavha katakchasiga kirishi kerak. Saralash katakchasida saralash belgisiz ishlamaydi. Masalan; ikki qator sarlavha bo'lganda, pastki satrda har doim saralash piktogrammasi bo'ladi. Quyidagi (harfga sezgir bo'lmagan) qiymatlar uchun amal qiladi
:
ma'lumotlar saralash turi
matn
raqam
valyuta
urlveb-sayt manzillari uchun
IP-manzil raqamli uchunInternet protokoli manzillari
sanatilga xos standart sana formati uchun
isoDate sanalar uchunISO 8601format (masalan, YYYY-MM-DD)
usLongDateAQSh formatidagi sanalar uchun (bir oy oldin)
vaqt
Masalan: | Vikiteks Hechqisi yo'q | ma'lumotlar saralash turi Bilan | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
data-sort-type = matn |
|
|
Sevgi va urush Yo'q
data-sort-type = matn
sarlavhada, jadvalator butun ustunni raqamli deb hisoblash uchun birinchi qatorlardagi raqamlar bilan chalkashib ketadi. Natijada raqamli bo'lmagan sarlavhalar matnlarining alifbo tartibidan qat'iy nazar nolga teng ravishda noto'g'ri tartiblashtiriladi. E'tibor bering, agar e'lon qilingan sort turiga ega bo'lmagan ustun faqat sonli qiymatlarni o'z ichiga olsa, <ref>...</ref>
lekin ma'lumotnoma bilan 1 12 2 27 289 3[17] 4 5 ...
kamida bitta raqamning oxirgi raqamidan so'ng, bu ustun sukut bo'yicha matn (alfasayısal) sifatida tartiblanishiga olib kelishi mumkin, Saralash turini e'lon qilish orqali bunga yo'l qo'ymaslik mumkin:
! data-sort-type = "number" | Elev. (ft) o'rniga
.
! Elev. (ft)
Standart ma'lumot turi ustun Agar siz ko'rsatmasangiz a
ma'lumotlar saralash turi , tartiblash tartiblari (thema'lumotlar turlari
- , "ko'tarilish" yoki "tushish" tanlovidan tashqari, saralash tartibini belgilaydi) quyidagilar:
- sana (shuningdek quyida ko'ring)
- mezon: birinchi bo'sh bo'lmagan element "DD-MM-YYYY", "DD-MM-YY" yoki "DD mmm YYYY" ko'rinishida
- tartib: YYYYMMDD raqamli qiymati; 10-uzunlikdagi DDsMMsYYYY (agar s-da joylashgan belgilar bir-biriga teng bo'lsa va '/' yoki '-' ajratuvchi bo'lsa) YYYYMMDD, 8-uzunlikdagi DDsMMsYY (agar s-da joylashgan belgilar bir-biriga teng bo'lsa va '/' yoki '-' separator) 19YYMMDD bo'lsa YY> = 50 va aks holda 20YYMMDD, va "DD mmm YYYY" qatori mmm an (qisqartirilgan) oy nomi bilan.
- isoDate (ISO 8601)
- mezon: "± YYYY-MM-DD" formati, "YYYY" yili uchun 1-4 ta raqam bilan -9999 dan 9999 gacha, oy faqat "± YYYY-MM-DD" formati bilan, soat: mm: ss.sss ± TH: TM "soat soati" hh ", daqiqalar" mm ", soniyalar" ss.sss "va vaqt zonasi ofset" TH: TM bilan, to'g'ri qiymatlar ixtiyoriy.
- tartib: raqamli, vaqt UTC bilan 1970 yil 1 yanvardan keyin millisekundlarda.
- valyuta (ushbu rejim boshqa ma'lumotlar uchun ham foydali bo'lishi mumkin)
- mezon: birinchi bo'sh bo'lmagan element $, £, € yoki ¥ bilan boshlanadi
- tartib: raqamli, bu belgilarga va barcha oddiy harflar va vergullarga e'tibor bermaslik, lekin bo'shliqlarni hisobga olmaganda; ilmiy yozuvlardan foydalanish mumkin emasligiga e'tibor bering, chunki e va E o'chiriladi
- raqamli
- mezon: birinchi bo'sh bo'lmagan element shunchaki raqamlar, nuqtalar, vergullar, "+", "-" bo'shliqlardan iborat bo'lib, keyin "e" yoki "E" va "+", "-", raqamlartartib: vergul va bo'sh joylarni olib tashlaganingizdan so'ng, agar mavjud bo'lsa, agar qator raqam bilan boshlanadigan bo'lsa, tartib qatordagi birinchi raqamga ko'ra raqamli (parseFloat qo'llaniladi); agar u bo'sh bo'lsa, u nolga teng deb hisoblanadi; boshqa holatlarda (parseFloat qaytadiNaN
- ), element -∞ kabi joylashtirilgan.
- Taklif etilayotgan xalqarolashtirish: Nemis tilida va boshqalarda vergulni o'nli nuqta sifatida ko'rib chiqing.
- mag'lubiyat
- mezon: boshqa barcha holatlar; order: brauzeringiz qo'llab-quvvatlasa, mahalliy tilga (masalan, inglizcha) buyurtma ishlatadi. Shu bilan bir qatorda, katta harflar kichik harfga aylantirilgandan so'ng buyurtma bo'ladiASCII - buyurtmani ko'rsatadigan qisman ro'yxat:! "# $% & '() * +, -. / 09:; <=>? @ [] ^ _' Az {|} ~ é— (quyida ham qarang; bo'sh joy bo'shliq boshqa har qanday belgidan oldin keladi; abo'sh joy
kod
& nbsp;bo'sh joy deb hisoblanadi; ikkita qo'shni oddiy bo'sh joy bitta deb hisoblanadi; bir nechta bo'sh joylar uchun foydalanish mumkin
& nbsp;yoki muqobil
& nbsp;
va oddiy bo'sh joylar)
Agar bir nechta mumkin bo'lgan turlar mos keladigan bo'lsa, yuqoridagi tartibda birinchi tur tanlanadi. Masalan, "24-12-2007" sana sifatida mos keladi, shuning uchun raqam sifatida ko'rib chiqilmaydi. Moslashtirish turini aniqlashda formatlash va belgilash teglari e'tiborga olinmaydi. Saralash tartibi sahifani yuklagandan so'ng sarlavha ostidagi birinchi 5 bo'sh qator bilan belgilanadi. Bu qatorni o'chirgandan yoki ustun qo'shgandan keyin ham o'zgarishi mumkin. Shuning uchun har bir element kerakli ma'lumotlar turi mezoniga mos kelishiga ishonch hosil qilish maqsadga muvofiqdir. A dan foydalanishqator shablon
bu juda qulay tarzda amalga oshirilishi mumkin. Har bir ustunning saralash rejimi kerakli darajada ekanligiga ishonch hosil qilish usuli a ni belgilaydi
ma'lumotlar saralash turi , qarang.
yuqoriga
Hujayra uchun saralash tugmachasini ko'rsatish {{Ba'zan katakning qiymati to'g'ri tahlil qilinmaydi yoki qatorni maxsus usulda saralashni xohlaydi. (masalan, "Jon Dou" ni o'z ichiga olgan katak "Jon" deb emas, "Doe" deb saralanishi kerak). Bunga osongina foydalanish orqali erishish mumkin}}
tartib nomi {{, shunga o'xshash:tartib nomi
| birinchi | oxirgi | ixtiyoriy havola maqsadi | ixtiyoriy tartiblash kaliti}} . Shu bilan bir qatorda, siz o'rnatishingiz mumkin
ma'lumotlar saralash qiymati
xususiyat. Wiki belgisi{| class = "wikitable sortable"! Ism va familiya !! Balandlik | - |data-sort-value = "Smit, Jon"| Jon Smit || 1.85 | - |data-sort-value = "Rey, Ian"| Yan Ray || 1.89 | - |data-sort-value = "Byanki, Zaxari" | | Zakari Byanki || 1.72 | -! O'rtacha: || 1.82 |}
|
O'rtacha:
Harbiy unvonlarni martabali yoshi bo'yicha tartiblash juda qulaydir.
Wiki belgisi{| class = "wikitable sortable"! Ism va familiya !! Rank | - |data-sort-value = "Smit, Jon"| Jon Smit ||data-sort-value = "16"| [[Kapital | Cpl]] | - |data-sort-value = "Rey, Ian"| Yan Rey ||data-sort-value = "8"| [[Kapitan (OF-2) | Kapitan]] | - |data-sort-value = "Byanki, Zaxari"| Zakari Byanki ||data-sort-value = "10"
| [[2-leytenant | 2 Lt]] |}
Bu quyidagilarni beradi: | Ism va familiya |
---|---|
Rank | Jon Smit |
Cpl | Yan Rey |
Kapitan | Zakari Byanki |
2 Lt Shuningdek qarang.
mw: Yordam: Saralash # Saralash kalitini ko'rsatishAgar sizda barcha yozuvlar tirnoq (") bilan boshlanadigan ro'yxat bo'lsa, va yozuvlardan biri uchun saralash tugmachasini o'rnatmoqchisiz, keyin foydalanishingiz kerak bo'ladiHTML nomi yoki raqami saralash tugmachasi boshidagi tirnoq uchun. QarangBu yerga
ham. Masalan, ba'zida qo'shiq sarlavhalarining ro'yxatlari har bir qo'shiqning sarlavhasini tirnoqlarda keltiradi. Shunday qilib, qo'shiq sarlavhasidagi ma'lum bir so'zga ko'ra saralash uchun quyidagilardan birini foydalaning:
data-sort-value = "& quot; WORD"
data-sort-value = "& # 34; WORD"
Bir qator qatorlarni saqlash
ma'lumotlar saralash qiymati
ma'lum qatorlarni birgalikda saqlash uchun ishlatilishi mumkin. Ushbu qatorlarning belgilangan tartibi saqlanib qoladi. Masalan, "Niderlandiya" dan keyin "South Holland" ni qanday tartibda yoki ustunda bo'lishidan qat'iy nazar ushlab turish: |
|
London Agar sizda kolspanlar bo'lgan qatorlar bo'lsa, bu biroz qiyinlashishi mumkin. Siz ham foydalanishingiz mumkin
class = "kengaytirish-bola"
bir qatorda; u har doim jadval satrida saralanishi mumkin bo'lgan har doim jadval manbaidagi satrdan pastda bo'ladi. |
|
Germaniya sobiq DDRni o'z ichiga oladi.
Ma'lumot turini avtomatik aniqlashga misollar. Dastlab ustundagi 5 katak Ssenariyda ustunning dastlabki 5 katakchasi nimani o'z ichiga olganligi ko'rinadi. Saralash rejimi bo'ladiraqamli agar birinchi 5 katakka ega bo'lsafaqat raqam (raqamlarni formatlashda ishlatiladigan vergul va nuqta raqam sifatida qabul qilinadi). Raqamli tartiblash tartibi 5-katakchadan keyingi kataklarda matn topilgan taqdirda ham saqlanib qoladi. 123,564,589.7e12 ichidailmiy yozuv
va raqam sifatida ko'rib chiqiladi. Bo'sh katak raqamli tartiblashda raqamsiz sifatida ko'rib chiqiladi. Dastlab quyida joylashgan 2 ta jadvalning har birining pastki qismida dastlab bo'sh katak mavjud.Ma'lumotlar turini avtomatik aniqlash mos kelmaydi. Buhar doim qo'shish yaxshiroq a
ma'lumotlar saralash turi uchun
|
|
aaa Yagona valyuta belgisi yoki bitta alfavit belgisi hozirda ustunning dastlabki 5 katakchasi orqali skript belgilaydigan narsani o'zgartirmaydi:
|
|
|
|
|
|
e 600 Foiz belgisi belgilanishdan o'zgarmaydiraqamli tartib.
|
|
Raqamli birikmalar Aplyus belgisi ichidabo'sh hujayra dastlabki 5 katak orasida standart raqamlash tartibini buzadi. A kabiraqamdan keyin ortiqcha belgi
|
|
matn sifatida
- Raqamli tartiblash muammolariEslatma:
Ustundagi dastlabki 5 katak orqali ma'lumotlar turini avtomatik aniqlash haqida yuqoridagi bo'limga qarang. Ushbu muammolarning aksariyati endi qo'yish orqali ustun tartiblash rejimini qo'lda belgilash orqali hal qilinishi mumkin
data-sort-type = raqam ustun sarlavhasida. Yuqoridagi va quyida keltirilgan jadval jadvallariga qarang. Shuningdek qarangmeta: Yordam: Saralash # Saralash rejimlarini saralash
va ustunni tartiblash tartibini majburlash haqidagi bo'lim. Ishlamoq
data-sort-type = raqam ichida bo'lishi keraksarlavha katakchasi busaralash belgisini o'z ichiga oladi.
Ko'p qatorli sarlavhali jadvallarda saralash belgisi eng pastki sarlavha hujayralarida bo'ladi. <ref>...</ref>
Adabiyotlar
har qanday katakchadagi raqamdan keyin (birinchi beshta katakchani ham qo'shganda) endi raqamli tartiblash buzilmaydi.
Agar ustun ustidagi birinchi 5 katakchalardan biridagi raqamdan oldin yoki keyin bo'lsa, matn standart raqamlash tartibini buzadi. Hatto foydalanishda ham
data-sort-type = raqam ustun sarlavhasida, har qanday katakdagi raqam oldidagi matn, bu katakning raqamli tartibini buzadi. Agar ustun yordamida tartiblash tartibi ko'rsatilgan bo'lsa, raqamdan keyingi matn muammo bo'lmaydi
.
"data-sort-type = raqam" (v.taxminan , "taxminan" degan ma'noni anglatadi) ko'pincha raqamlar ustunlarida uchraydi. Raqamli tartiblash ishlashi uchun uni raqamdan keyin qo'yish kerak. Shu bilan bir qatorda, uni boshqa ustunga o'tkazish mumkin. Ning qo'shilishi
data-sort-type = raqam
ustun sarlavhasiga ruxsat bermaydi. raqamning oldiga qo'yish. Ustunni raqamli tartiblash uchun etakchi nollar shart emas. Agar shunday ko'rinadigan bo'lsa, demak, ustun alifbo tartibida tartiblangan. Dastlabki 5 katakchadan raqamlardan boshqa narsani qidirib toping va ushbu katakchalarga binoan tuzating. Yaxshisi, qo'shing
data-sort-type = raqam
ustun sarlavhasiga. Keyinchalik boshqa tahrirlovchilar tomonidan tahrir qilish raqamli tartiblashni buzmaydi.
Ustundagi dastlabki 5 katakchalardan biridagi bo'sh katakchadagi har qanday chiziqcha, ustunni sukut bo'yicha tartiblashni buzadi.
Raqam oldidagi chiziq sonli tartiblashni buzmaydi. Chiziqlarga katakchalarning istalgan joyida ruxsat beriladi
data-sort-type = raqam
ustun sarlavhasida ishlatiladi.{{Yo'q }} ustunning dastlabki beshta katakchasidagi shablon ma'lumotlar turini avtomatik aniqlashda ta'siriga mos kelmaydi. A ni har doim belgilash yaxshiroqdir
ma'lumotlar saralash turi
ustun sarlavhasida.
- Raqamli diapazonlarEslatma:
Ko'pgina muammolar qo'shilish yo'li bilan hal qilinadi
data-sort-type = raqam
ustun sarlavhasiga. Bundan tashqari, keyinchalik tahrirlash natijasida yuzaga keladigan muammolarning oldini oladi.
Raqamdan keyingi chiziq endi ustunning standart tartibini buzmaydi. Shuning uchun (30-40) diapazon endi ishlaydi.
Raqamdan keyin plyus belgisi ustundagi dastlabki 5 katakchalardan birida bo'lsa, sukut bo'yicha tartiblashni buzadi.
Aks holda bo'sh katakchadagi ortiqcha belgisi ustunni sukut bo'yicha tartiblashni buzadi. Agar hujayra ustundagi birinchi 5 katakdan biri bo'lsa.
Agar pastki yoki yuqori diapazon bo'yicha saralashni xohlasangiz, diapazon uchun 2 ta ustunni ishlatishingiz mumkin. Agar siz yuqori diapazonni eng yaxshi tartibda bo'lishini istasangiz, barcha katakchalar raqamlar bilan to'ldirilishi kerak. Masalan; pastki va yuqori diapazonda bir xil raqamdan foydalanishingiz mumkin. Bundan tashqari, yuqori diapazondagi raqamdan keyin ortiqcha belgisini qo'shishingiz mumkin.Quyidagi jadvallarning birinchi to'plami to'g'ri tartiblanmagan, "400+" murakkablashtiruvchi omillarga ega bo'lmagan pastki diapazondan tashqari. Yozib oling "400 +" va ularning ustunlarida to'g'ri tartiblashtirmang. Ushbu jadvallarda yo'q
data-sort-type = raqam
|
|
|
(yuqori)
data-sort-type = raqam borsaralashni quyidagi jadvallarda o'rnatdi. 400+ Ning saralashiga e'tibor bering 400 +.
|
|
|
(yuqori)
Sana tartibida muammolar
Oy nomlari "Ingliz tili" ning sukut bo'yicha sozlamalarini o'zgartirgan ro'yxatdan o'tgan foydalanuvchilar uchun oy nomlarini o'z ichiga olgan barcha tartiblash muvaffaqiyatsiz bo'lishi mumkinMaxsus: afzalliklar
. Bu inglizcha Vikipediyada nisbatan kam foydalanuvchilarga ta'sir qiladi va ularni e'tiborsiz qoldirish mumkin.
Faqat yil QarangDaromadlar tengligi bo'yicha mamlakatlar ro'yxati . Yilni saralash, agar hech qanday matn ustun ichidagi katakchada birinchi narsa bo'lmasa, ishlaydi. Yil birinchi bo'lishi kerak. Qo'shilmoqda
data-sort-type = sana
ustun sarlavhasiga buni o'zgartirmaydi. Matn yaxshikeyin kamerada bir yil. "FY" (moliyaviy yil
), masalan, yildan keyin ketishi kerak. Yildan keyingi ma'lumotnomalar yaxshi. "C" belgisini qo'ying. yildan keyin yoki "est" dan foydalaning. o'rniga yil keyin.
Bo'sh katakchadagi har qanday chiziqcha ustunni yil tartibini buzadi. Yildan keyingi chiziqlar yaxshi.Raqamli tartiblashdan farqli o'laroq {{Yo'q }} yil ustunidagi istalgan katakchadagi shablonemas
ushbu ustunning tanaffus yilini saralash.
Yilni saralash bilan bog'liq muammolar mavjud bo'lsa, katakchadagi birinchi narsa sifatida matn yoki chiziqcha (har qanday turdagi) bo'lgan ustundagi biron bir katakchani tekshiring. Ushbu matnni yoki chiziqchani olib tashlang va ustun to'g'ri saralanishi kerak.
Yil va oy Sana saralashishlamaydi faqat oydan bir yil oldin (kun yo'q) ustunlar uchun. Qo'shilmoqda
data-sort-type = sana yoki
data-sort-type = isoDate ustun sarlavhasigayordam bermaydi. Ko'rish uchun har bir ustun sarlavhasini quyidagi jadvallarda bir necha marta bosing. Belgilangan ustunga e'tibor bering
data-sort-type = isoDate
ba'zi brauzerlarda to'g'ri tartiblanishi mumkin, ammo bu ishonchli emas. Yil va oy raqamli shaklda (YYYY-MM) bilan ishlaydi
data-sort-type = isoDate
|
|
|
|
|
2004 yil avgust
Oy va yil Sana saralashishlamaydi ustunlar uchun faqat yil oldin oy (kun yo'q). Qo'shilmoqda
data-sort-type = sana ustun sarlavhasiga
|
|
|
|
2004 yil avgust
Oy, kun va yil
|
|
|
|
2004 yil 4-avgust
Kun, oy va yil
|
|
|
|
2004 yil 4-avgust
- 100 yildan oldin. Har qanday sana formatiEslatma:
Ushbu qismdan keyin tegishli bo'limga qarang. Saralash maxfiy orqali amalga oshirilishi mumkin
ma'lumotlar saralash qiymati yordamidaISO sanasi . Bilan birga
data-sort-type = isoDateEslatma: Saralash vikitekti quyidagi 2 jadval uchun bir xil.
| Miloddan avvalgi 207 yil dekabr |
{|| - style = vertical-align: top; | {| class = "wikitable sortable" | -! data-sort-type = isoDate | Sana | - | data-sort-value = "111-12-05" | 5 dekabr 111 | - | data-sort-value = "35-01-07" | 7 yanvar 35 | - | data-sort-value = "207-12-05" | 5 dekabr 207 | - | data-sort-value = "- 111" | Miloddan avvalgi 111 yil | - | data-sort-value = "- 35-01-07" | Miloddan avvalgi 7-yanvar, 35-yanvar | - | data-sort-value = "- 207-12" | Miloddan avvalgi 207 yil dekabr |} Quyidagi jadval uchun xuddi shu isoDate qiymatlari ishlatiladi
ma'lumotlar saralash qiymati
| Miloddan avvalgi 207 yil dekabr |
{| class = "wikitable sortable" | -! data-sort-type = isoDate | Sana | - | data-sort-value = "111-12-05" | 5 dekabr 111 | - | data-sort-value = "35-01-07" | 7 yanvar 35 | - | data-sort-value = "207-12-05" | 207 yil 5-dekabr | - | data-sort-value = "- 111" | taxminan miloddan avvalgi 111 yil | - | data-sort-value = "- 35-01-07" | Miloddan avvalgi 35-yil 7-yanvar | - | data-sort-value = "- 207-12" | Miloddan avvalgi 207 yil dekabr |}
- Yil, oy, kun. Raqamlardan foydalanish. ISO sanasi YYYY-MM-DD Misollar uchun; jadvallarni ko'ringAndroid One
. Kunduzi YYYY-MM dan foydalanadi. Qarang:.ISO sanasi "± YYYY-MM-DD", -9999 dan 9999 gacha "YYYY" yili uchun 1 dan 4 gacha raqam. Yilning o'zi yaxshi. Agar oy ishlatilsa, unda ikkita raqam ishlatilishi kerak. Agar oy oldingi nolsiz bitta raqamdan foydalansa, saralash buziladi. Bitta raqam kun uchun yaxshi. Sanadan oldin va keyin ba'zi narsalarga ruxsat beriladi. Kabi "v. " (uchuntaxminan |-
) sanadan oldin, va sanadan keyin ma'lumotnomalar. Yil oldin vikitekstda salbiy raqam bo'lgan bo'sh joy qoldirishni unutmang. Aks holda,
jadvalni formatlash sifatida ishlatiladi. Saralash eng yaxshi ishlaydi
data-sort-type = isoDate
|
|
|
|
v. 207-11
Sana jadvalini saralash shabloni: kun va oy, boshqa ko'plab sana formatlari {{Ushbu misol jadvallarida}}Sana jadvalini saralash
shablon. Ularning barchasi to'g'ri tartiblangan. Vikipediya matniga qarang ("manbani tahrirlash"). Har bir jadvalda birinchi kirish uchun vikitekst jadval sarlavhasida ko'rsatilgan.Eslatma: Jadval ustunlaridan hech biri
data-sort-type = modifikator. Foydalanish
data-sort-type =
ba'zida saralashni buzishi mumkin.{{Sana jadvalini saralash }} shablonidan ko'plab sana formatlari bilan foydalanish mumkin. QarangAndoza: Sana jadvalini saralash
|
|
|
2004 yil 11 yanvar
Saralangan sarlavhalardagi fon ranglari Umumiy bilan rang qo'shish
"fon: ...;" sarlavhadagi xususiyat ushbu ustunni saralash tugmachasini yo'qotishiga olib kelishi mumkin - qarangphab: T33755
. Misol: | Ism | Familiya |
---|---|---|
Balandligi | Jon | 1.85 |
Smit | Ron | 1.89 |
Rey | Mario | 1.72 |
Byanki | 1.82 |
O'rtacha: Keyinchalik aniqroq foydalaning
style = "background-color: ...;"
narsalarni to'g'ri ishlashi uchun. Misol:{| class = "wikitable sortable" | -! style = "background-color: navajowhite" | Ism! style = "background-color: navajowhite" | [[Familiya]]! style = "background-color: navajowhite" | [http://example.com Balandligi]
| - | Jon | Smit | 1.85 | - | Ron | Rey | 1.89 | - | Mario | Byanki | 1.72 | - class = "sortbottom" | colspan = "2" | O'rtacha: | 1.82 |}
Ushbu tartiblangan jadvalni ishlab chiqaradi: | Ism | Familiya |
---|---|---|
Balandligi | Jon | 1.85 |
Smit | Ron | 1.89 |
Rey | Mario | 1.72 |
Byanki | 1.82 |
O'rtacha:
Maslahatlar va fokuslar
To'ldirish
Ba'zan hizalamak uchun yozuvlar chap tomonga to'ldiriladi. Bu ularning tartiblanishiga salbiy ta'sir ko'rsatishi mumkin.
Bo'sh joylar Chap to'ldirishning ta'siribo'sh joy kodlar
& nbsp;
bo'sh bo'shliq sifatida ko'rsatiladigan brauzerga bog'liq: IE-da ular (bo'sh bo'shliqlardan farqli o'laroq) etakchi bo'sh joy sifatida saralash uchun hisoblanadi, shuning uchun matnli raqamlar ro'yxatida (alfavit tartiblash tartibi qo'llaniladi) ular ishlatilishi mumkin. aniq yoki yopiq o'nlik ajratuvchisidan oldin belgilar sonini tenglashtirish. Biroq, Firefox-da ularni saralash maqsadida e'tiborga olinmaydi. Saralash yordamida & nbsp; | IE-da ishlaydi, ammo Firefox-da ishlamaydi |
---|---|
Ism | 100.3 FM |
Uchinchidan | 89.5 FM |
Birinchidan | 107.3 FM |
To'rtinchi | 95.3 FM |
Ikkinchi Shuningdek qarang.
Muhokama: Aholisi bo'yicha AQSh shtatlari va hududlarining ro'yxati / Arxiv 1 # Saralash jadval
Nol bilan to'ldirish
- 000156
Misol:
Formatnum padleft bilan birlashtirilishi mumkin:
Butun son:
- 0,000,000,299,792,458
{{formatnum: {{padleft: 299792458 | 16 | 0}}}} beradi:
Haqiqiy:
- 0,000,000,299,792,458.056000
{{formatnum: {{padleft: {{# expr: ((299792458.056 - .5) 0-tur)}} | 16 | 0}}}}. {{padleft: {{# expr: (1000000 * (299792458.056 -) (299792458.056 - .5) 0-tur))) tur 0}} | 6 | 0}} beradi:
SanalarJadvalda tartiblanadigan sanalarni formatlashning eng oddiy usuli bu {{Sana jadvalini saralash }} shablon. Ga muvofiquslubiy qo'llanma
, shablon quyidagi format yordamida chaqiriladi:
{{Sana jadvalini saralash | 1776 yil 4-iyul}}Please see the documentation of the template {{Date table sorting
}} for full details on how to use this.
|
April 64 BC
Date sorting works by formatting dates so they can be sorted numerically. For example:
yyyy mm dd
2001 07 21
yoki...for 21 July 2001. The "display:none" style can be used to hide a sortable numeric date before the displayed date. {{Date table sorting
}} does this automatically, and is recommended in most cases. You can use 2012 yil 7-iyul
etc. to get sortable dates. Example, including one date with a different display format: |
---|
Sana |
2012 yil 7-yanvar |
2012 yil 7-may |
2012 yil 4-iyul |
2012 yil 7-iyul !9937-09-23
For years BC,
- can be used for -0062-09-23 (62 BC): Simply subtract the year BC from 10,000. Shuningdek qarang:
bugzilla:8226
Numeric sort for BC/AD years
In certain circumstances the following sort technique may be used to provide a simple intuitive numeric sort for BC/AD years which are often surrounded by qualifying text. The sort in the BC/AD column (the fourth column in the example) is forced to be numeric (just as the other columns are forced to be alphabetic) by the inclusion of the first two hidden rows. These rows contain extreme values which will mean that these rows will ALWAYS be sorted to the top and bottom of the table, regardless of which column is sorted. As the sort mechanism determines the sort type to be used by examining the first cell in the column to be sorted the hidden rows ensure that a purely numeric value is always found in the first or last cell. The mechanisms used here are explained in the current article at: #Forcing proper sort type and positioning rows with a hidden sort key va.
#ExamplesWith numeric sorting guaranteed all that is needed is to precede the BC/AD text with a positive or negative year number in a hidden sort key (
{{Hs|-9999 ! }} ) which suitably represents the cell text. As this number will be the first thing the sort code sees it will sort it as a number, in the order
large negatives -> zero -> large positives
, or the opposite. Once the sort type is fixed at the start of a sort the presence of alphabetic values in subsequent rows is ignored. The sort is done numerically on the first text in each row. The detail of the exclamation mark after the positive/negative year number in the hidden sort key is to clearly mark an end to the number which the sort mechanism must consider. In certain circumstance, if the exclamation mark is not present, and the hidden sort key is immediately followed by another number, that number may be treated as a continuation of the hidden sort key number, to produce an incorrect sort. The tables in the article: Doimiy yashash vaqti bo'yicha shaharlar ro'yxati
have been modified to used this sort. The following example is modified (maintaining some defects in the content which will need resolving in the original!) from one of those tables:
{| class = "wikitable sortable" | -! Name! Historical region! Location! Continuously inhabited since! class = "nomaqbul" | Notes|-style="display:none;"|!a||!a||!a||-9e99|-style="display:none;"|~z||~z||~z||9e99|-| [[Ife]] || || {{Hs|Nig}}[[Osun State]], [[Nigeria]] || {{Hs|-500 !}}c. 500 BC |||-| [[Axum]] || [[Kingdom of Axum]] || [[Ethiopia]] || {{Hs|-400 !}}c. 400 BC || Ancient capital of the Kingdom of Axum...|-| [[Mogadishu]] || || [[Somalia]] || {{Hs|900 !}}c. 900 || settled by Arab traders|-| [[Dar es Salaam]] || || [[Tanzania]] || {{Hs|1865 !}}1865 || Founded by the Sultan of [[Zanzibar]].|} | Ism | Tarixiy mintaqa | Manzil | Continuously inhabited since |
---|---|---|---|---|
9e99 | Agar, Osun shtati | Nigeriya | ||
v. Miloddan avvalgi 500 yil | Agar, Osun shtati | Nigeriya | v. 8-asr | |
earliest traces of habitation date to the 4th century BC. | Ha | Yo'q | Efiopiya | v. Miloddan avvalgi 700 yil Oldest site of continuous habitation in . |
Afrikaning Sahroi osti qismi | Axum | Axum qirolligi | Efiopiya | v. Miloddan avvalgi 400 yil |
Ancient capital of the Kingdom of Axum | Igodomigodo | Benin qirolligi | Nigeriya | v. Miloddan avvalgi 400 yil |
City of Benin, one of the oldest cities in Nigeria | Djenné-Jeno | Mali | v. Miloddan avvalgi 200 yil oldest known city in | |
Saxaradan Afrikaga | Mogadishu | Somali | v. 900 | |
settled by Arab traders | Keyptaun | Keyp koloniyasi | 1652 | Janubiy Afrika |
Founded by Jan van Riebeeck of the Dutch East India Company | Monroviya | 1822 | Liberiya Settled by freed American slaves through the | |
Amerika mustamlakachilik jamiyati | Dar es Salom | 1865 | Tanzaniya Founded by the Sultan of . |
Zanzibar
Controlling sorting and display
- Text undesired for sorting but needed for display: Yildaraqamli
- sorting mode, text breaks numerical sorting whether the text is before or after the number. Sorting then becomes alphanumeric. Empty cell is treated as "zero" when sorting numerically. Yildasana
- sorting mode, this text needs to be put in a separate column; in the case of a cell containing a range of dates or numbers (e.g. from .. to ..), text in surplus of what is required for sorting is put in the extra column. If the first part of the text is used for sorting, then the extra column needs to be the following one; conversely, if the last part of the text is used for sorting, then the extra column needs to be the previous one; depending on the table format, this dividing of an item over two cells may look ugly. Yildaalifbo
sorting, any footnotes etc. do not require a separate column; they can simply be put at the end of the element.
- Text undesired for display but needed for sorting:
can be put as hidden text in the column to be sorted
Combining the two, we can have displayed text independent of text used for sorting, by fully hiding the latter, and fully putting the former in a separate column (in date sorting mode and numeric sorting mode) or in the same column after the hidden text (in alphabetic sorting). Fully putting the displayed text in a separate column may look ugly if it is not done consistently for a whole column, but only for elements that require this (e.g. if most entries in a column are single numbers, but some are ranges).
Static column
|
|
Parij
The style can be adjusted to make it appear as a single table. If for some row the height of that row is too small for the text in a cell on one of the sides, the browser increases it, and there is no longer a match.A static column can also be created by enclosing the sortable table with the templates {{static column begin}} and {{oxiri}}. See the documentation of {{static column begin
}} tafsilotlar uchun.
Maintaining tables sorted by rank
Tables in rank order may become difficult to maintain as the list is updated. People keep adding more rows to the table, but fail to renumber all the ranks each time a new one is added. With Visual Editor it is much easier now. QarangYordam: Jadval
and the section at the end on the Visual Editor. It is easy to add or remove a column of rank numbers. See the section on copying a column from one table to another. Copy a rank column from another table, or an older version of the same table. Masalan; copy from.Bu yerga
It is a rank column from 1 to 250.
Click on the first cell (with number 1) of the rank column. Then shift-click on the highest number you need. Click "copy" from the edit menu of your browser. Then click on the first cell of the blank column that needs rank numbers. Click "paste" from the edit menu of your browser.
- Putting a table in initial alphabetical orderEslatma: For more info see the Visual Editor sections at the end of Yordam: Jadval . Shuningdek qarang::Phab:T240114
"Enhance the VisualEditor table editor to allow sorting and saving sorted content." There are fast and slow ways to do this. Scroll down for fast ways. AfsuskiVizual muharrir
does not have a fast way to quickly alphabetize a table. You can manually move rows around one at a time. Click on a cell in a row. Then click on the arrow that shows up at the left of the row. Then click on "move above" or "move below" as needed.
If this is buggy or is not working, the rows can be moved around in the wikitext by cutting and pasting rows in the wikitext. A fast way is to launch free ,LibreOffice Calc or another spreadsheet program. QarangElektron jadval dasturlari ro'yxati
. Go to the Wikipedia page or user sandbox with the table. Select and copy the table right off the page (do not go into the wikitext or the HTML). Paste it into a new Calc page. In Calc click on any cell in the column you want sorted, and then click on one of the sort options in the data menu at the top of the Calc window. Click on "ascending" or "descending" to sort alphabetically or numerically depending on the column contents. Click on "sort" for more options. Then convert the Calc table back to wikitext by pasting it into .
Commons:Convert tables and charts to wiki code or image files There is another way to alphabetize a table. Biri foydalanishi mumkinNoteTab Engil ||
.
(freeware version of NoteTab). It installs quickly and easily. But the wikitext must be in compressed table format. All the wikitext for a row must be on one line. That means the cells in that row are separated by double bars
To alphabetize the list by the first column paste the table wikitext into a new NoteTab Light page. Select the rows you want to alphabetize. Then click on the "modify" menu, then "lines", then "sort", and then "ascending". That will put "A" at the top and "Z" at the bottom. |-
Then put back (wikitext for row) between each line. Do that via find-and-replace by replacing
^ p bilan
^p|-^p
^ p|-
is the underlying text editor code for line breaks in NoteTab.
is the wikitext for a table row. If there are blank lines between the entries replace
^p^p bilan
^p|-^p
Copy the wikitext and paste it back into the article. Save the page.
[[Help:Sorting#Initial alphabetical sort versus initial sort by rank order]]
It is a good idea to keep lists and tables in some kind of initial non-random sort order. Numbered rank order can be difficult to maintain as the list is updated, and as the rankings change. Masalan; in a nation list, updating the info for a single nation may require changing the rank numbers of many nations. This discourages people from updating the list. If they do update the list, they may not bother to update the rank order. So the list becomes more and more incorrect over time. See lists of country data. QarangCategory:Lists of countries by per capita values va.
Category:Lists of countries |
It is much easier to keep a list in rank order if the numbered rank column (1,2,3) is removed from the table, and then put next to the table in a separate column. See how-to sections below. Just removing or separating the rank column (1,2,3) can greatly ease future updating of the table, whether the table is initially in rank order or alphabetical order.
It can be even easier maintenance and updating in some cases if the list is initially in alphabetical order, especially if the sources and references are also in alphabetical order. Readers can be instructed to use the sort button to order a number column.
Removing a rank column (1,2,3) from a table You can remove the rank column cells quickly. It is much easier now with the table editor in the VisualEditor
. Click on the header in the column you want to delete. An arrow will show up at the top of the column. Click the arrow, and then "delete column".
Kategoriya: qatordagi qatordagi raqamli jadvallar bilan maqolalar Lar borPhabricator threads asking for a way to easily add static row numbers to tables. Qarang.phab:T42618 U orqaga qaytadi.phab:T42634 If a solution is implemented in the MediaWiki software, then it will be much easier to use wide tables, and wide note columns, in tables with row numbers. An integrated static row number column would be very helpful in a wide table initially sorted by region and subregion such as this wider version ning:Qasddan odam o'ldirish darajasi bo'yicha mamlakatlar ro'yxati Versus this .
tor versiyasi
A row number column never has to be updated, except to add more numbers at the end if necessary. Masalan; when adding more nations. This allows any initial sort order for the table. It allows any column to be sorted later via the sort button, and still see the same row numbering.List of U.S. states by incarceration and correctional supervision rate
is an example of a table that needs a separate row number column. Because there are 3 separate columns that are important enough that people want to be able to see the rank order. That can't be done with an integrated rank order column. It can only be done with a static row number column.
New method is much easier
This is a much easier method for adding a fixed row number column to a table.
- The new method uses these templates:Template:Static column begin {{ or its redirect }}
- Rank
- Andoza: End
Andoza: Stol qatori hisoblagichi <!-- -->
Go to those template pages to see the documentation on how to use those templates. Note that you will need to temporarily add nowiki tags, or hidden comment tags , to the {{daraja }} template line at the top of a table if you want to edit the table in the Visual Editor. Qarang Phabricator: .
T245277
Kategoriya: qatordagi qatordagi raqamli jadvallar bilan maqolalarQamoqqa olish darajasi bo'yicha mamlakatlar ro'yxati may or may not need a separate row number column. It depends on whether one believes there is more than one column that people want to see in rank order for. Its editing using the old method is explained in detail at Commons:Convert tables and charts to wiki code or image files (section about list of countries by incarceration rate). Shuningdek qarang:.
Aholi jon boshiga sog'liqni saqlash xarajatlarining umumiy miqdori bo'yicha mamlakatlar ro'yxatiFlag icons are not currently a problem in country lists.
It depends on the current state of the MediaWiki software, and the current state of the flag templates. Sometimes they mess up row alignment more and more as the text size used is smaller and smaller. The row alignment is more and more messed up the farther down one scrolls down the table. At the time this is written the flag icons are formatted in such a way that they are not causing a problem.
Click column heads to sort alphabetically or numerically. O'sish yoki tushish tartibida saralashi mumkin. The row number column on the left sorts independently from the columns to the right of it. Or: "The row number column is static and does not sort." To make it static add
class=unsortable
to the column head for the row numbers.A separate row number column only works when there is only one line per row in the table. So wide tables, or tables with a notes column are problematic. There could be 2 lines in some rows, depending on screen width, and the length of notes. Rows will wrap from being one line to two lines. Decrease your browser width to see. Masalan; see notes column here:Mintaqalar bo'yicha mamlakatlar va qaramliklar ro'yxati <br>
. Wide tables can be narrowed in some cases by using breaks in the header titles:
. Also, the sorting icons can be put in a separate header row.Tables with references within the table are not currently a problem. Reference numbers are in ,yuqori belgi and this may or may not increase the line height of the row. It depends on the current state of the MediaWiki software, and whether it increases line height for rows with references. So a separate row number column may not work, especially when multiple cells in a column have references. The more rows with references, the more the misalignment as one goes down the table. One solution is to point to a notes section below the table. Qarang:Qasddan odam o'ldirish darajasi bo'yicha mamlakatlar ro'yxati
. The notes are in a notes section below the table.Italics within the table are not currently a problem.
It depends on the current state of the MediaWiki software, and whether it changes the line height for rows with italics. Note: Copy separate row number table (1,2,3) from Bu yerga . It is 1 to 250. Use as much as is needed. Shuningdek qarangushbu ro'yxat
of just the numbers.
Example tables. Old method
Here is how to put a main table adjacent to a separate row number table. | ism | ma'lumotlar |
---|---|---|
more data | 273 | 53 |
mushuklar | 65 | 8,492 |
itlar | 1,649 | 548 |
1 |
2 |
3 |
sichqonlar <br>
The two tables are combined by wrapping them within a 3rd table that does not have a border. Look at the wikitext to understand. See examples below. It is not necessary to put text in the header cell above the number column. You can leave it blank, but sortable. Qo'shish so it is not too narrow. You can also choose to leave the number column unsortable. Specify
class=unsortable in the attributes of its header cell. For more info see the section higher up called .
|
|
sichqonlarAlign the multiple headers <br>
across the tables below by adding (multiple times if necessary) to the header cells of the row-number column. See the wikitext for the table below. Shuningdek qarang:List of U.S. states by incarceration and correctional supervision rate va.Qasddan qotillik darajasi bo'yicha mamlakatlar ro'yxati # Mamlakatlar bo'yicha
Those tables have several header rows. |
|
ma'lumotlarmushuklar itlar
sichqonlar
- You can remove the space between the 2 tables qo'shib
|
|
ma'lumotlar mushuklaritlar
sichqonlar With wider tables the rows only line up between the table and the row-number column if all the rows below the headers only use one line each. So it is a good idea to avoid tables that are too wide.
For that reason avoid note columns, too. See the problem in the table below. Increase your text size, or narrow your browser window to see the problem with wider tables such as the one below.
|
|
This does not align the tops of the 2 tables at narrow browser widths.
sichqonlar
less popular Adding CSS for vertical alignment will keep the tops aligned.
For the above table here is the wikitext at the top of the wrapping table, followed by the header wikitext for the row-number column: {||- style=vertical-align:top;|{| class = "wikitable sortable" | -! |-!
|-!
|-| 1 Adding row numbers with Template:Row numbers QarangTemplate:Row numbers for a very fast way to add a column of row numbers to a table. The row numbers are not fixed though as with the previous methods. This method is not affected by screen width as with the method used in the previous section. The row numbers stay aligned with the table rows. Qarang
this page with a column of 300 rows containing _row_count . The column can be copied with Visual Editor into any table. In order to quickly set up any table to useTemplate:Row numbers
. Qarang
this old version | ning | Voyaga etganga to'g'ri keladigan boylik bo'yicha mamlakatlar ro'yxati | |
---|---|---|---|
1 | . It uses the template to add the row numbers. | 273 | 53 |
2 | Qarang | 65 | 8,492 |
3 | Yordam: Jadval | 1,649 | 548 |
and its section at the end on the Visual Editor. It explains how to copy a column from one page to a table on another page.
Remove the template code at the beginning of the table in order to edit the table in Visual Editor. Otherwise, use the wikitext editor. Leave a note on the talk page, and add a hidden note above the table. See wikitext and note of the table below. ismma'lumotlar
more data
mushuklar
itlar |
---|
9 |
12 |
11 |
sichqonlar
Sorting the wikitext of a table
One difficult way to sort the
vikitekst |
---|
12 |
11 |
9 |
itself by a certain column is to use the following 'trick'. You can make an auxiliary sortable table containing the wikitext for the original table, and sort it. You can then replace the original wikitext by this sorted wikitext.Unfortunately this method is anything but quick and easy. The heavy modifications needed make it unsuitable for larger tables, while small tables generally are sorted faster by hand.
Misol: | Original table: | demo |
---|---|---|
Auxiliary table: | ![]() | ![]() |
{|class="wikitable sortable"!demo{|class="wikitable sortable"!header|-||-| 9|-||-|12|-||-|11|}|} | ![]() | ![]() |
Now you can sort the above table, and copy the rendered text to the edit box. After deleting the "header" line, this renders as a new defaultly sorted table: | ![]() | ![]() |
demo | ![]() | ![]() |
Sorting with increase/decrease/steady templates Misol, Without keyWith key olmaBanan gilosDurian To enable sorting of cells with Template:Increase
Template:Decrease yoki Template:Steady $1|$3$2$3 , add a sort key, e.g. {{increase|2}}2, {{decrease|-1}}1 or {{steady|0}}. To fix an existing table, use $1|-$3$2$3 Search and replace $1|0$2
(right icon in the Advanced toolbar) with
Treat search string as a regular expression selected to do the following replacements:
Qidirish
Replace with |
---|
! |
" |
# |
$ |
% |
& |
' |
( |
) |
* |
+ |
, |
- |
. |
/ |
0 |
9 |
: |
; |
< |
= |
> |
? |
@ |
[ |
\ |
] |
^ |
_ |
' |
({{increase)(}})([0-9]*) |
({{decrease)(}})([0-9]*) |
({{steady)(}}) |
Alphabetic sorting order |
data-sort-type:text |
- Sort the following table to see an example of the alphabetic sort order. |
Note that sorting is case-insensitive: the two-character entries such as A1 demonstrate that A and a are at the same position. |
Sinov |
{ |
| |
} |
~ |
— |
A |
Z |
a |
z |
† |
A1
Z1a1
É |
---|
é |
1000000000000000000 |
-1000000000000000000 |
.0000000000000000001 |
-.0000000000000000001 |
É1 |
é1 |
Numerical sorting order examples |
89 123 456 788 |
89,123,456,789 |
14 |
-14 |
11 |
data-sort-type:number |
- Sort the following table to see an example of the numerical sort order. |
12 (?) |
mixed notations |
Sinov |
? |
333 |
1.4285714285714E+17 |
-1.4285714285714E+17 |
1.4285714285714E-13 |
-1.4285714285714E-13 |
-12 (retrograde) |
12 yoki 13 |
v. 12 |
12 (approx.) |
1e10 |
e 9 |
e 80 |
e 70 |
e 600 |
999e9 |
88e80 |
7e270 |
999e-9 |
88e-80 |
7e-270 |
-999e9 |
−999e9 |
-88e80 |
-7e270 |
-999e-9 |
-88e-80 |
-7e-270 |
e3
- {{-e31e3
- e9e80
- e270
- 6e11 (8e11 Shuningdek qarang)Sortname }} – sorting by surname without placing first name and surname in two separate columnsm:Help:Sorting
- – general help page of this functionality (Not Wikipedia specific)Sortable collapsible table
- Template:dts
- orqaga qaytishtahrirlash
)