// Logs all the information inside gradient conditional format rules on a sheet.// The below snippet assumes all colors have ColorType.RGB.constsheet=SpreadsheetApp.getActiveSheet();construles=sheet.getConditionalFormatRules();for(leti=0;i < rules.length;i++){constgradient=rules[i].getGradientCondition();constminColor=gradient.getMinColorObject().asRgbColor().asHexString();constminType=gradient.getMinType();constminValue=gradient.getMinValue();constmidColor=gradient.getMidColorObject().asRgbColor().asHexString();constmidType=gradient.getMidType();constmidValue=gradient.getMidValue();constmaxColor=gradient.getMaxColorObject().asRgbColor().asHexString();constmaxType=gradient.getMaxType();constmaxValue=gradient.getMaxValue();Logger.log(`The conditional format gradient information for rule ${i}: MinColor ${minColor}, MinType ${minType}, MinValue ${minValue}, MidColor ${midColor}, MidType ${midType}, MidValue ${midValue}, MaxColor ${maxColor}, MaxType ${maxType}, MaxValue ${maxValue}`);}
[[["易于理解","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"]],["最后更新时间 (UTC):2025-08-05。"],[[["\u003cp\u003eGradient conditions in Google Sheets allow you to apply color scales to cells based on their values, interpolating colors between minimum, midpoint, and maximum points.\u003c/p\u003e\n"],["\u003cp\u003eEach gradient condition is defined by three points (min, mid, max), each having a color, value, and interpolation type.\u003c/p\u003e\n"],["\u003cp\u003eYou can access and manipulate gradient conditions programmatically using Apps Script methods like \u003ccode\u003egetMinColorObject()\u003c/code\u003e, \u003ccode\u003egetMidValue()\u003c/code\u003e, and \u003ccode\u003egetMaxType()\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eDeprecated methods like \u003ccode\u003egetMinColor()\u003c/code\u003e, \u003ccode\u003egetMidColor()\u003c/code\u003e, and \u003ccode\u003egetMaxColor()\u003c/code\u003e have been replaced by object-based alternatives for color retrieval.\u003c/p\u003e\n"]]],["Gradient conditions, within conditional format rules, define cell colors based on a number scale with minimum, midpoint, and maximum values. Each point has a color, value, and interpolation type. Methods like `getMinColorObject()`, `getMidType()`, and `getMaxValue()` retrieve these attributes. Cell content is compared to these values to interpolate and apply a corresponding color. Deprecated methods (`getMinColor()`, `getMidColor()`, `getMaxColor()`) are replaced with `get[Point]ColorObject()`.\n"],null,[]]