|
A rubutun da na gabata na koya muku shigo da fayil din musanya bayanai a madaidaicin tsarin rubutu. A yau zan wakilci jerin bayanai masu alaƙa guda uku a kan maƙasudin watsawa ɗaya. |
Abu na farko da zamu bayyana a fili, don zama mai saurin aiki tare da wannan shirin, shine ƙarin bayanan da muke wasa da su. Gaskiya ne cewa zamu iya zaɓar jerin a cikin zane, amma idan kuna da ƙwayoyin 1000 a kowane shafi, kamar yadda lamarin yake, kun ƙare rubutu da farko.
Daga baya zamu fahimci cewa zamu iya zana bayanan da sauri ta hanyar zaɓar ginshiƙan da ake magana kafin ƙaddamar da kayan aikin graphing, amma saboda koyarwar zamu tsallake wannan ɓangaren.
1. Sanya bayanan
Anan zaku iya ganin yadda na shirya ginshiƙai tare da taken kansu. Na kuma raba takardar a kwance don ganin bayanan a kowane lokaci (hagu) yayin da bangaren da zan saka jadawalin ma ana samunsa (dama).
Manufata ita ce ƙirƙirar hoto mai nau'in XY wanda zanyi amfani da quadrants 3:
- A (X> 0, Y> 0) Zan shirya shafi Y tare da X.
- A cikin (X <0, Y> 0) Zan wakilta Y a kan X-1.
- A (X> 0, Y <0) zan wakilci Y-1 da X.
2. «Zane-zane» kayan aiki
Samun dama daga sandar kayan aiki ko 'Saka' menu, yana ba da damar ƙirƙirar Ginshiƙai, Bars, sassa, Lines, Watsawa, da sauransu.
A halin da nake ciki, zan ƙirƙiri zancen watsawa na XY tare da layuka masu laushi, saboda yawancin maki da ke cikin shirin na.
3. Matsakaicin Bayani
Idan muka latsa 'na gaba', mayen zai bamu damar zabar "zangon bayanai" wanda zamuyi aiki da shi. Kamar yadda nayi bayani a baya, zamu iya zaban yankuna na bayanan bayanan mu wadanda muke son tsarawa. Wannan zangon bayanan na iya ƙunsar sassan da yawa na takardar aiki ɗaya. Don sauƙaƙawa za mu tsallake wannan matakin (ba shi da mahimmanci don ƙirƙirar hoto).
4. Jerin Bayanai
Jadawalinmu zai wakilta ta layuka kowane ɗayan jerin bayanan da aka bayyana a wannan matakin.
A halin da nake ciki, na kira su a, b da c, biyo bayan umarnin yan hudu da na ambata a sama.
Don zaɓar kewayon da ake so na ƙimar X ko Y, za mu iya danna akwatin a hannun dama, wanda zai rage akwatin maganganu kuma ya ba mu damar zaɓi akwatunan da hannu.
Don kar a sami ɗaukaka ta ƙananan ƙwayoyin, za mu tantance shi da hannu yana bin nomenclature:
$ sheetname. $ shafi na $ farawa cell: $ shafi $ karshen cell
A game da fayil na Calc ((.ods)), bayanan suna cikin takardar mai suna «UsemosLinux», ƙimomin X da Y sune ƙwayoyin 3 zuwa 1002 na shafi K da J bi da bi.
5. Abubuwan zane
Aƙarshe, a cikin wannan matakin ƙarshe zamu iya daidaita yanayin ƙirar hoto. Kamar duk abin da aka yi har yanzu, ana iya canza shi daga baya.
6. Maimaitawa
Anan muna da hotonmu.
Kodayake Libreoffice ya ci gaba sosai idan aka kwatanta shi da wanda ya gabace shi OpenOffice, amma kula da zane-zane har yanzu wani abu ne da za a iya inganta shi (kuma wannan ya riga ya fi shi kyau). Ganin cikakken jahilcina, zan sanya shi zuwa ga Calc nuni: layin shuɗi yana da ɗan haske, amma ana saurin warware shi da zarar mun daidaita girman jadawalin:
Jadawalin dole ne ya zama mai saukin fahimta, don haka zan canza fasalin gatarin. Don yin kowane gyara, kawai danna kan abin da muke son canzawa, ya zama duka jadawalin, jerin bayanai, gatari ko almara.
A ƙarshe, Ina fitar da jadawalin don adana shi a waje da maƙunsar bayanan kuma zan iya amfani da shi a cikin wasu takardu. Anan yana da mahimmanci don daidaita girman da ƙudurin hoton daidai, amma don wannan karatun ya riga ya kasance.
ƙarshe
Awannan zamanin dole ne inyi gwagwarmaya da manyan maƙunsar bayanai na Office 2013. A matsayina na mai ƙaunata ga Free Software Ina amfani da damar don aiki tare da Calc ba kamar da ba. Libreoffice babban zaɓi ne, koda tare da duk wadatar sa. Kada ku yi jinkirin koya don aiki tare da shi.
Bayan loda fayilolin Ofishina na 2013 zuwa gare shi, nayi matukar mamakin farin ciki, nesa da FUD wanda aka sakashi akan sa. Gaskiya ne cewa wasu siffofin da masu amfani da Excel ke jin daɗi suna nesa da baya, amma don daidaitaccen amfani da maƙunsar rubutu muna da Calc wani zaɓi na kyauta, kyauta kuma koyaushe ana samun sa a danna don DUK tsarin mu.
Ana iya amfani da Macros har abada (ya fito daga OpenOffice). Matsalar ita ce OpenOffice tana aiki tare da BASIC nata wanda ya sha bamban da MS Visual Basic, don haka akwai wasu abubuwan da suka bambanta a tsakaninsu.
Ya kamata ku sani cewa Ina son waɗannan nau'ikan labaran akan shafukan yanar gizo na Linux. Yana da amfani sosai fiye da "harshen wuta", banda wannan rubutun naku a bayyane yake kuma a taƙaice. Gaisuwa.
Kai kuma kun riga kun gwada samfurin Clone na China na M $ Office a cikin Linux (aƙalla a cikin Ubuntu) shin yana da kyau ga masu amfani da ofishi na ci gaba ko kuwa wani nau'in aikace-aikacen ofishin Linux ne kawai ???
http://www.omgubuntu.co.uk/2013/05/microsoft-office-clone-wps-updates-interface-improves
Ban yi aiki tare da LibreOffice ba na dogon lokaci, amma lokacin da na yi, sai na daina amfani da shi, saboda ni'imar Excel, saboda batun macros na sirri ... shin kun gyara wannan batun ko kuwa har yanzu ba a iya amfani da shi?
http://www.educadictos.com/b/%C2%BFhay-vida-despues-de-la-hoja-de-calculo/
Godiya gare ku 😉
Za'a iya "saka" tebur a cikin shafi ta hanyoyi da yawa, wanda yasa kowane ɗayan daban. Shin kun gwada liƙa wannan bayanin a cikin fayil ɗin rubutu sannan shigo da shi azaman .csv ko makamancin haka? Koyarwar da zan danganta a farkon wannan rubutun tana bin tsari makamancin wanda nayi don samowa kaina kundin laburare yan shekaru da suka gabata 😉
Idan bai muku aiki ba, ku same ni ta imel kuma za mu ga takamaiman lamarinku 😉
Cool ^. ^ Mun gode da karatun.
Tunda da alama kuna aiki da dubunnan ginshikai kamar ni, Ina so inyi amfani da wannan damar in tambaye ku.
A halin yanzu ina amfani da MS, saboda ban sami mafita a Calc ba.
A cikin aikina na kwafa kwafin tebur daga shafukan kwastan, wanda nake buɗewa daga Mai bincike, kuma liƙa su a cikin MS Office, Excel ya san wurin da teburin yake kuma na bar su cikin tsari daidai da na asali.
Lokacin da nayi kokarin yinshi daga Chrome zuwa Calc, baya kwafin oda, ma'ana, ya bayyana a cikin kwayar halitta guda. yayin da nake son tsari na asali ba tare da tsari ba.
Da yake aiki ne na maimaitawa tare da tebur da yawa, ba zan iya gyara kwayar halitta ta tantanin halitta ba, shin kun san wata mafita ga wannan?
Ba buƙatar karatu bane, yana share aikin watanni da yawa a bayan gida. Ka tuna da haka, a cikin dukkan kamfanonin da nayi aiki, an yi amfani da MS Excel, a sigar daban-daban, kuma aikina makonnin farko, koyaushe shine ƙirƙirar macros na kaina don ceton kaina gwargwadon aikin da zan iya yi a nan gaba .
Ba na ƙi canza maƙunsar bayanai, Ina son LibreOffice Calc (fiye da na Openoffice), ya fi na "ba za a sake yin aiki ba don abin da na riga na yi" ... Idan daidaito ya kasance duka, da ina da Excel dauka ba komai.
Ka'idar Kayayyaki harshe ne na mallaki, don haka cikakken jituwa ba zai iya isa samfurin GPL ba.
Damn Microsoft!
A da, ya fi gwada duk abin da na kama ta ta hanyar ƙungiya ... a yau na sami kwanciyar hankali da zaɓina kuma ba na son gwadawa, na fi son koyon yadda zan yi amfani da abin da nake da shi.
Tabbas, idan na sami dacewa ba zan jinkirta gaya maku "yaya kuke ba". Kwanakin baya sun tsara madadin Google Docs tare da java a cikin 24h ... xD
Mai jaruntaka shit MovieMaker ... ra'ayin ba shi da kyau, kuma lokacin da yake aiki, yana da kyau ... matsalar ita ce ... "lokacin da yake aiki."
Masu albarka lokacin da kuke aiki tare da shirye-shiryen su, la'ana idan baku yi ba. Banda shine MovieMaker, koyaushe tsine. xD
Ina tsammanin matsalar ba ta cikin ƙwanƙwasa idan ba a cikin Chrome gwada ƙoƙari iri ɗaya ba amma daga Firefox!
Macros macros da calc macros suna da alama suna da yare daban-daban kodayake kamar abin ba'a ne, ya kamata kuyi ƙoƙarin ƙirƙirar ayyukan macro daga ƙirar ɗaya kuma kada ku shigo da fitattun macros ta wannan hanyar da zaku san cewa suna yiwuwa a kowane shiri / ofis daki.
Yayin da ake kirga layin linzami daga wani yanki mai warwatsewa, wani lokacin sai ku tilasta layin ya bi ta asalin, ana iya yin hakan? Na tuna cewa a cikin MSOffice abu ne mai yiwuwa amma ba zan iya samun zaɓi a Libreoffice ba.
Ya yi nesa da abin da nake yi, amma idan zan iya zan sa masa ido. 😉
Godiya ga post. Abinda har yanzu yake bani matukar takaici a cikin Open da LibreOffice shine rashin ingancin layin su da kayan aiki masu lankwasa bisa ga jekadan watsawa da aka gabatar anan. Waɗannan sune fannonin ci gaba waɗanda nake tsammanin waɗannan ɗakunan ofisoshin suna da jan aiki a gaba idan aka kwatanta da Microsoft Excel. Na ga cewa suna mai da hankali ga manufofinsu game da ƙarancin haɓaka ƙirar aiki, ɗayan ko wani aiki, wasu ci gaban bug, wanda ina tsammanin kyakkyawa ne. Amma sun yi watsi da mahimman fasalolin ci gaba waɗanda ke saita sautin. Abubuwan Ci gaba na Solver, Teburin Pivot, Layi na yau da kullun don zane-zane, Tsarin tsari na amfani da sanduna, alamu, da sauransu tsakanin sauran batutuwa masu ci gaba. Abin da na lura shi ne cewa suna saki da sakin sifofin tare da ƙananan canje-canje amma a can ƙasa abu ɗaya ne. Ba ku ganin cuku a kan toast kamar yadda suke faɗa a ƙasata. Ina son kayan aikin kyauta amma saboda sana'ata a matsayin injiniya da kuma yadda aka dauke ni a matsayin babban mai amfani da Excel, ban canza zuwa wadannan rukunin ofis din ba saboda an bar su sosai a bangaren ci gaba.
kyau sosai