Esikhathini esingengakanani esedlule sikutshelile ungayisebenzisa kanjani ngempumelelo i-LibreOffice ukukhiqiza kangcono ngaleli suite lehhovisi i-Ubuntu elisinikeza mahhala. Esikhathini esedlule besikhuluma nge-suite yonke ngokujwayelekile, kepha namhlanje sizokutshela amaqhinga amane eLibreOffice Calc lokho kuzosivumela ukuthi sibe namaspredishithi okhokhelwayo noma okungenani leyo ndlela ezobonakala ngayo kubangani bethu.
Lawa maqhinga akuwona wodwa akhona, maningi futhi kukhona namaqanda e-Easter athile azosivumela ukuthi sidlale ngespredishithi noma simane sihlangane nabathuthukisi bale software.
Amaseli anombandela
ILibreOffice Calc isivumela ukuthi simake amaseli athile ngendlela yokuthi kuya ngempendulo, amanye amaseli enza umsebenzi othile, kungaba yisamba, shintsha umbala wangemuva, abonise umbhalo, njll. sebenzisa amaspredishithi njengamafomu obuchwepheshe noma imibuzo yemibuzo elula ongayikhetha. Ukuze senze lokhu kufanele nje simake iseli bese siya Imenyu -> Ukufomatha okunemibandela. Lapho, kuzoboniswa imenyu enezinketho, izinketho ezinemibandela engu-1 zisivumela ukuthi sikhethe ukuthi yisiphi isimo esizosithuthukisa futhi ku-Conditional 2 imiphumela okwamanje evela.
Vikela ishidi noma incwadi
ILibreOffice Calc iyasivumela vikela amadokhumenti ngokwemvelo ngaphandle kwesidingo sanoma iyiphi isoftware eyengeziwe. Ukuze senze lokhu kufanele nje siye kuMenu-> Protect Document–> Sheet or document. Ewindini sibeka inketho yokuvikela futhi ngezansi sifaka iphasiwedi bese siyayiqinisekisa. Ngemuva kwalokho sicindezela kulungile futhi yilokho kuphela. Manje, ungakhohlwa iphasiwedi ngoba ngeke ibe khona indlela yokuyibuyisa.
Isiphequluli
Leli qhinga ngeke liguqule amaspredishithi ethu abe ngongoti kodwa lizokwenza kuzothuthukisa umkhiqizo wethu ngokuphawulekayo. ILibreOffice Calc isivumela ukuthi sizulazule ngokubonga ngokubheka iphaneli eseceleni elifihlekile. Ukuyikhombisa kufanele nje siye ku-Imenyu -> Buka -> Isiphequluli. Le phaneli ayisibonisi amashidi kuphela kepha nama-macros, ihluzo nezinto ezahlukahlukene ezinamashidi noma imibhalo.
Qopha bese udlala
ILibreOffice Calc iyasivumela qopha yonke imisebenzi yamaspredishithi ethu bese uyiphindaphinda noma nini lapho sifuna khona, okuthile okuthakazelisayo uma sifuna ukukhombisa ukusebenza kwespredishithi noma i-macro ethile. Ukurekhoda kufanele siye kuphela kwimenyu -> Amathuluzi -> AmaMacros -> Qopha amaMacros -> Senza konke okufanele sikwenze bese sicindezela inkinobho ethi «stop recording» -> Songa imacro enegama elithile.
Lapho sifuna ukukhiqiza kabusha lokho okurekhodiwe kufanele siye kuMenu-> Amathuluzi -> Ama-Macros-> Qalisa ama-Macros -> Thatha imakhro erekhodiwe-> Run.
Isiphetho
ILibreOffice Calc ayinayo akukho lutho lokuhalela ezinye izinhlelo zokusebenza zespredishithi njenge-Microsoft's Excel. Le misebenzi iyisampula encane yalokho engakwenza empeleni, kepha kunokunye okuningi. Njengakwezinye izinhlelo zokusebenza zeLibreOffice.