In this logging you can spot the useful source property, which has the following properties/methods (found using for( i in e.source)):getOwnergetKeyremoveNamedRangerevealColumngetSheetPermissionsdeleteSheetgetViewersunhideRowaddEditorsgetSpreadsheetTimeZoneinsertRowBeforegetSheetIdsetFrozenRowssetSpreadsheetLocalegetSpreadsheetLocalegetIdcopyhideColumngetActiveRangeaddMenutoastsetColumnWidthgetLastColumngetAsinsertColumnsAftersetSheetPermissionssetActiveSheetgetBlobremoveMenusortgetRangegetRangeByNamegetColumnWidthhideRowinputBoxremoveViewerfindSheetByNameinsertImageautoResizeColumnsetNamedRangegetSheetByNamesetActiveCellinsertSheetisWritablesetSpreadsheetTimeZonegetNumSheetssetFrozenColumnsgetSheetProtectionduplicateActiveSheetdeleteRowisAnonymousWriteisAnonymousViewfindSheetinsertRowAfteraddEditorgetNameunhideColumnsetRowHeightaddViewersrenameshowsetActiveRangegetFrozenRowssetAnonymousAccessaddCollaboratorsetActiveSelectiongetSheetValuesdeleteActiveSheetremoveCollaboratorgetDataRangeaddCollaboratorsdeleteRowsdeleteColumntoStringisReadableremoveEditorsetNameinsertColumnsBeforemoveActiveSheetgetSheetsgetChangesappendRowgetSheetNamegetActiveSelectioninsertRowsBeforeinsertColumnAftergetActiveCellgetActiveSheetgetEditorsfindgetRowHeightgetFormUrlgetFrozenColumnsupdateMenumsgBoxinsertColumnBeforegetUrlgetLastRowinsertRowsAfterrenameActiveSheetsetSheetProtectiondeleteColumnsaddViewergetCollaboratorsrevealRow 这篇关于如何使用 OnChange() 触发器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
07-29 15:04
查看更多