ILibreOffice Calc: Ungayakha Kanjani Ishadi Lokuhlakaza

Kokuthunyelwe kwangaphambilini ngikufundisile ngenisa ifayela lokushintshana idatha ngefomethi yombhalo ocacile. Namuhla ngizomela uchungechunge lwemininingwane ehlobene emithathu kusakhiwo esifanayo sokusabalalisa.

Into yokuqala okuzofanele sicacise ngayo, ukuze sisheshe sisebenzise lolu hlelo, ukwandiswa kwedatha esidlala ngayo. Kuyiqiniso ukuthi singalukhetha lolu chungechunge ngemidwebo, kepha uma unamaseli ayi-1000 kukholamu ngayinye, njengoba kunjalo kimi, ugcina ngokubhala kuqala.

Sizobona kamuva ukuthi singakwazi ukufaka idatha ngokushesha okukhulu ngokukhetha amakholomu okukhulunywa ngawo ngaphambi kokuqalisa ithuluzi lokufaka igrafu, kodwa ngenxa yesifundo sizokweqa le ngxenye.

1. Faka idatha

Lapha ungabona ukuthi ngilungiselele kanjani amakholomu ngenhloko yawo. Ngiphinde ngahlukanisa ishidi ngokuvundlile ukubona idatha ngaso sonke isikhathi (kwesobunxele) ngenkathi isigaba engizofaka kuso igrafu naso sitholakala (kwesokudla).

Inhloso yami ukudala igrafu yohlobo lwe-XY lapho ngizosebenzisa khona ama-quadrants ama-3:

• Ku (X> 0, Y> 0) ngizohlela ikholomu Y kuqhathaniswa no-X.
• Ku (X <0, Y> 0) ngizomela u-Y kuqhathaniswa no-X-1.
• Ku (X> 0, Y <0) ngizomela u-Y-1 uma kuqhathaniswa no-X.

2. «Imidwebo» ithuluzi

Ukutholakala kubha yamathuluzi noma kumenyu ethi 'Faka', kusiza ukwenziwa kwamakholomu, amabha, imikhakha, imigqa, ukuhlakazeka, njll.

Endabeni yami, ngizokwakha isiza sokusabalalisa i-XY ngemigqa ebushelelezi, ngokunikezwa inani elikhulu lamaphoyinti akhona kusakhiwo sami.

3. Idatha Ibanga

Uma sichofoza ku-'landelayo ', iwizard isivumela ukuthi sikhethe "ibanga ledatha" esizosebenza ngalo. Njengoba ngishilo ekuqaleni, singakhetha kuqala izifunda zedatha yethu esifuna ukuyihlela. Le banga ledatha lingaqukatha izigaba eziningi zeshidi lokusebenzela elifanayo. Ukuze kube lula sizokweqa lesi sinyathelo (akubalulekile ukudala igrafu).

4. Uchungechunge lweDatha

Igrafu yethu izomela ngomugqa ngamunye ochungechungeni lwedatha oluchazwe kulesi sinyathelo.

Endabeni yami, ngibabize ngo-a, b no-c, ngokulandela i-oda lama-quadrants engishilo ngenhla.

Ukukhetha ububanzi obufunwayo bamanani we-X noma we-Y, singachofoza ibhokisi elingakwesokudla, elizonciphisa ibhokisi lengxoxo futhi lisivumele ukuthi sikhethe amabhokisi ngesandla.

Ukuze singabi naphakade ngokuncipha kwamaseli, sizokucacisa ngokwenza ngokulandela igama lesibizo:

$ sheetname. $ column $ start cell: $ column $ end cell

Endabeni yefayela lami le-Calc (.ods), idatha iseshidini elibizwa nge- «UsemosLinux», amanani we-X no-Y angamaseli 3 kuye ku-1002 kukholamu K no-J ngokulandelana.

5. Izici zezithombe

Ekugcineni, kulesi sinyathelo sokugcina singalungisa i-aesthetics yomdwebo. Njengakho konke okwenziwe kuze kube manje, kungashintshwa ngokuhamba kwesikhathi.

6. Ukuphinda uthinte

Lapha sinegrafu yethu.

Yize iLibreoffice ithuthuke kakhulu uma iqhathaniswa ne-OpenOffice eyandulelayo, ukwelashwa kwemidwebo kuseyinto engathuthukiswa (futhi lokho sekuvele kungcono kakhulu kunalokho ebikunakho). Ngokunaka ukungazi kwami ​​okuphelele, ngizokusho kusibonisi seCalc: ulayini oluhlaza okwesibhakabhaka ufiphele ngandlela thile, kepha uxazululwa masinyane ngokushesha nje lapho silungisa usayizi wegrafu:

Igrafu kufanele ibe enembile kakhulu, ngakho-ke ngizoshintsha ifomethi yezimbazo. Ukwenza noma yikuphi ukulungiswa, mane uchofoze entweni esifuna ukuyiguqula, kungaba yigrafu yonke, uchungechunge lwedatha, izimbazo noma inganekwane.

Ekugcineni, ngithumela igrafu ukuyigcina ngaphandle kwespredishithi futhi ngikwazi ukuyisebenzisa kweminye imibhalo. Lapha kubalulekile ukuthi ulungise usayizi nokulungiswa kwesithombe kahle, kepha kulokhu kufundiswa sekuvele kukhona.

Isiphetho

Kulezi zinsuku kufanele ngilwe namaspredishithi amakhulu we-Office 2013. Njengomthandi omuhle weFree Software ngisebenzisa ithuba lokusebenza noCalc ngendlela engakaze yenzeke. ILibreoffice iyindlela enhle enkulu, noma ngabe kukhona okubi ngayo. Unganqikazi ukufunda ukusebenza nayo.

Ngemuva kokulayisha amafayela wami we-Office 2013 kuwo, ngimangele kakhulu, kude kakhulu ne-FUD ekhishwe kuyo. Kuyiqiniso ukuthi ezinye izici abasebenzisi be-Excel abaphambili abazijabulelayo zisemuva kakhulu, kepha ekusetshenzisweni okujwayelekile kwespredishithi esinayo eCalc enye indlela yamahhala, yamahhala futhi etholakala ngokuchofoza KONKE izinhlelo zethu.