@mcp-z/mcp-sheets
    Preparing search index...

    Function cellsFormat

    • Returns {
          config: {
              description: "Apply formatting (colors, borders, fonts, alignment, number formats) to cell ranges without modifying data. Supports batch operations for efficiency. Colors use 0-1 RGB format. Best for creating professional, visually organized spreadsheets.";
              inputSchema: ZodObject<
                  {
                      gid: ZodCoercedString<unknown>;
                      id: ZodString;
                      requests: ZodArray<
                          ZodObject<
                              {
                                  backgroundColor: ZodOptional<
                                      ZodObject<
                                          { blue: ZodNumber; green: ZodNumber; red: ZodNumber },
                                          $strip,
                                      >,
                                  >;
                                  bold: ZodOptional<ZodBoolean>;
                                  borders: ZodOptional<
                                      ZodObject<
                                          { color: ZodObject<(...), (...)>; style: ZodEnum<(...)> },
                                          $strip,
                                      >,
                                  >;
                                  fontSize: ZodOptional<ZodNumber>;
                                  horizontalAlignment: ZodOptional<
                                      ZodEnum<{ CENTER: "CENTER"; LEFT: "LEFT"; RIGHT: "RIGHT" }>,
                                  >;
                                  numberFormat: ZodOptional<
                                      ZodObject<
                                          { pattern: ZodOptional<(...)>; type: ZodEnum<(...)> },
                                          $strip,
                                      >,
                                  >;
                                  range: ZodString;
                                  textColor: ZodOptional<
                                      ZodObject<
                                          { blue: ZodNumber; green: ZodNumber; red: ZodNumber },
                                          $strip,
                                      >,
                                  >;
                              },
                              $strip,
                          >,
                      >;
                  },
                  $strip,
              >;
              outputSchema: ZodObject<
                  {
                      result: ZodDiscriminatedUnion<
                          [
                              ZodObject<
                                  {
                                      failedRanges: ZodOptional<ZodArray<ZodObject<(...), (...)>>>;
                                      gid: ZodString;
                                      id: ZodString;
                                      sheetTitle: ZodString;
                                      sheetUrl: ZodString;
                                      successCount: ZodNumber;
                                      type: ZodLiteral<"success">;
                                  },
                                  $strip,
                              >,
                              ZodObject<{}, $strip>,
                          ],
                          "type",
                      >;
                  },
                  $strip,
              >;
          };
          handler: (
              __namedParameters: {
                  gid: string;
                  id: string;
                  requests: {
                      backgroundColor?: { blue: number; green: number; red: number };
                      bold?: boolean;
                      borders?: {
                          color: { blue: number; green: number; red: number };
                          style: "SOLID" | "DASHED" | "DOTTED";
                      };
                      fontSize?: number;
                      horizontalAlignment?: "LEFT"
                      | "CENTER"
                      | "RIGHT";
                      numberFormat?: {
                          pattern?: string;
                          type: "TEXT" | "NUMBER" | "PERCENT" | "CURRENCY" | "DATE" | "TIME";
                      };
                      range: string;
                      textColor?: { blue: number; green: number; red: number };
                  }[];
              },
              extra: EnrichedExtra,
          ) => Promise<{ [key: string]: unknown }>;
          name: string;
      }