Xa usebenza neGoogle Sheets, ungachaza imithetho esekwe kubasebenzisi yokuhlela amaphepha okusebenzela, iikholamu, kunye nemigca ngaphakathi kwespredishithi. Ngelishwa, akukho ndlela yokuthintela ukufikelela ekufundeni. Oku kuya kuba luncedo kakhulu kwiimeko ezininzi, umzekelo, ukubonisa abathengi bakho kuphela amatikiti afanelekileyo kubo, okanye abasebenzi bakho kuphela iiprojekthi abasebenza kuzo.
Esinye isisombululo esinokwenzeka kukudala i-master sheet kwaye usebenzise i-IMPORTRANGE ukufikelela kwidatha ekhethiweyo kuyo kwicala elinye. Ngelishwa, oku kubandakanya umsebenzi omninzi owenziwa ngesandla: ukudala amaphepha amatsha, ukunika iimvume zefayile, ukuphuhlisa nokusebenzisa ifomyula ye-IMPORTRANGE, ukwamkela iimvume, kunye nokuseta ifomathi. Ukuba isakhiwo okanye ifomathi iyatshintsha, oku kufuneka kwenziwe ngesandla kwispredishithi nganye nganye.
Isicatshulwa esilandelayo seGoogle Apps senza oku ngokuzenzekelayo. Ukuba uyenza init () indlela yakanye kwi-mastersheet, onke amakhoboka ayenziwa ngokuzenzekelayo, amalungelo abelwe kunye neefomula kunye nefomathi emiselweyo. Ukuba utshintsho lwedatha kwiphepha eliyintloko, liboniswa ngokuzenzekelayo kwiphepha lezigqila. Ukuba ulwakhiwo lwe-master sheet luyatshintsha, yenza init () kwakhona (amaphepha adlulileyo ahlaziywa ngokuzenzekelayo).
82ba709df04366e65cb3a42f84f19631