Ukwazi i-LibreOffice Tutorial 04: Isingeniso ku-LibreOffice Calc
Kulokhu entsha neyesine isitolimende ochungechungeni lwezincwadi ezibizwa Ukwazi i-LibreOffice, ezinikele ekwazini ngokuningiliziwe okwengeziwe mayelana nokwamanje inguqulo ezinzile (namanje) we I-FreeOffice Office Suite, sizogxila kuhlelo lokusebenza olwaziwa ngokuthi I-LibreOffice Calc.
Futhi njengoba abaningi sebeyazi kakade, I-LibreOffice Calc uhlelo lokusebenza oludalwe ukuthi lube yi- Umphathi wespredishithi Okufanayo. Futhi, ngakho-ke, ekahle ukuqala entsha ispredishithi, isitayela se- I-MS Excel. Ngakho-ke, ngokulandelayo sizobona ukuthi le nguqulo isilethela ini futhi mayelana nokubonwa kwesithombe nezici zobuchwepheshe.
Ukwazi i-LibreOffice - Isifundo 03: Isingeniso kuMlobi we-LibreOffice
Futhi njengenjwayelo, ngaphambi kokuthi singene esihlokweni sanamuhla sokuthi I-LibreOffice Calc, sizoshiya kulabo abathanda izixhumanisi ezilandelayo kwabanye okuthunyelwe kwangaphambilini okuhlobene:
I-LibreOffice Calc: Ukwazi Umphathi Wespredishithi
Iyini i-LibreOffice Calc?
Kulabo abangazi lutho noma okuncane I-LibreOffice Calc Kuhle ukukhumbula kafushane ukuthi, una isici ithuluzi elicebile ukukhohlisa idatha (okungcono kube inombolo) ku-a ispredishithi. Ukuze kukhiqizwe imiphumela ethile, kokubili ngesimo sombhalo nangesimo sezithombe.
Futhi, inamandla okwenza shintsha izenzo, ukuze uguqule kuphela inani ledatha ethile ukuze uthole imiphumela ehlukile. Yikuphi, futhi, okuvumela ukusetshenziswa kwe imisebenzi namafomula ezithuthukisa futhi zithuthukise ukusebenza kwe izibalo eziyinkimbinkimbi mayelana nedatha.
Ngaphezu kwalokho, ifaka phakathi Imisebenzi yesisekelo sedatha, evumela amandla okuhlela, ukugcina nokuhlunga idatha; imisebenzi yehluzo eguqukayo, ngefomethi ye-2D ne-3D; Y imisebenzi ye-macro, okuvame ukuba usizo kakhulu ekurekhodeni nasekuqhubeni imisebenzi ephindaphindwayo.
Futhi kuyaphawuleka ukuthi ibuye ivumele ukusetshenziswa izilimi zokubhala, njenge: LibreOffice Basic, Python, BeanShell kanye neJavaScript. Futhi, unawo womabili amandla okuphatha Amaspredishithi e-Microsoft Excel ezingeni elanelisa kakhulu; njengokungenisa nokuthekelisa amaspredishithi ngamafomethi amaningi, njengale: I-HTML, CSV (ngamafomula noma ngaphandle kwawo), I-dBase, i-PDF ne-PostScript.
Isikhombikubona esibonakalayo kanye nomklamo wohlelo lokusebenza
Njengoba kubonakala esithombeni esilandelayo, lena yamanje isikhombikubona esibonakalayo se-LibreOffice Calc, ngokushesha nje lapho iqalwa:
Uyabona kulo, ngokushesha ngaphansi kwe ibha yesihloko kusuka efasiteleni, i ibha ye amamenyu, bese kuthi indawo yamathuluzi eza ngokuzenzakalelayo. Ngenkathi, ethatha cishe yonke ingxenye emaphakathi yefasitela, i indawo yokusebenza yomsebenzisi, okungukuthi, ispredishithi okufanele kusetshenzwe kuso.
Ekugcineni, ngakwesokudla, kukhona ibha eseceleni eza nezinketho eziningi eziboniswayo. Futhi ekugcineni kwefasitela, ngezansi, njengenjwayelo, yindabuko ibha yesimo.
Njengoba kuboniswe ngezansi, ngamunye ngokwehlukana:
Ibha yesihloko
Ibha yemenyu
Ibha lamathuluzi
Indawo Yokusebenzela yomsebenzisi + Ibha Yefomula
Ibha yecala
Ibha yesimo
"Ngokuzenzakalelayo, i-LibreOffice Calc isebenzisa i-syntax yayo yefomula, eyaziwa ngokuthi I-Calc A1, esikhundleni se-Excel A1 syntax esetshenziswa yi-Microsoft Excel. I-LibreOffice izokwenza ukuhumusha okungenamthungo phakathi kwalezi zinhlobo ezimbili. Kodwa-ke, uma ujwayele i-Excel, kunjalo ungase ufune ukushintsha i-syntax ezenzakalelayo ku-Calc ngokuya ku Amathuluzi > Izinketho > I-LibreOffice Calc > Ifomula nokukhetha I-Excel A1 o I-Excel R1C1 kumenyu yehla phansi I-syntax yefomula". I-Syntax Yefomula / Ukuqalisa 7.2
Ulwazi olwengeziwe mayelana ne-LibreOffice Calc Series 7
Uma usangene Inguqulo ye-LibreOffice 6, futhi ufuna ukuzama i Inguqulo ye-7, sikumema ukuthi uyizame ngokulandela i inqubo elandelayo Mayelana nawe I-GNU / Linux. Noma uma ufuna nje ukumazi ngokufunda, chofoza lapha.
Isifingqo
Kafushane, kulesi sitolimende sesine se Ukwazi i-LibreOffice cishe I-LibreOffice Calc, singaqhubeka siqinisekisa okusha nokuwusizo izinguquko ngaphakathi kwayo. Ukuze uphathe futhi uzuze okwengeziwe nangcono, yabo amakhono nezici zamanje, ukuze sithuthukise izinhlelo zethu isipiliyoni somsebenzisi ngaye.
Uma ukuthandile lokhu okuthunyelwe, qiniseka ukuthi uyaphawula ngakho futhi wabelane ngakho nabanye. Futhi khumbula, vakashela yethu «ikhasi lasekhaya» ukuhlola izindaba eziningi, kanye nokujoyina isiteshi sethu esisemthethweni se- I-Telegram ye DesdeLinux, ENtshonalanga iqembu ukuze uthole ulwazi olwengeziwe ngesihloko sanamuhla.