[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["필요한 정보가 없음","missingTheInformationINeed","thumb-down"],["너무 복잡함/단계 수가 너무 많음","tooComplicatedTooManySteps","thumb-down"],["오래됨","outOfDate","thumb-down"],["번역 문제","translationIssue","thumb-down"],["샘플/코드 문제","samplesCodeIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-07-26(UTC)"],[[["\u003cp\u003eThe \u003ccode\u003eSlicer\u003c/code\u003e class allows you to programmatically control slicers in Google Sheets, enabling you to filter data in ranges, charts, and pivot tables without collaboration.\u003c/p\u003e\n"],["\u003cp\u003eYou can access and modify existing slicers or create new ones using the provided methods, such as setting the data range, background color, title, and position.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eSlicer\u003c/code\u003e class offers various methods for customizing the slicer's appearance, including setting the background color, title alignment, and text style.\u003c/p\u003e\n"],["\u003cp\u003eTo use the \u003ccode\u003eSlicer\u003c/code\u003e class effectively, you will need to authorize your script with the necessary scopes to access and modify spreadsheet data.\u003c/p\u003e\n"],["\u003cp\u003eSeveral methods are available for interacting with the slicer's filter criteria, allowing you to retrieve, set, and manipulate the filtering conditions applied to the data.\u003c/p\u003e\n"]]],["Slicers filter ranges, charts, and pivot tables. Key actions include: retrieving and modifying slicer properties like background color, column position, filter criteria, data range, and title. Slicers can be positioned and have their applicability to pivot tables set. You can also manage the title's horizontal alignment and text style. Slicers are created using `Sheet.insertSlicer`. The method to remove a slicer is `remove()`. The old method to obtain background colors is deprecated and should be replaced by `getBackgroundColorObject()`.\n"],null,[]]