Auto Fill Strings

SpreadJS can fill string values by copying the selected values or by generating a string series. A string series is generated when SpreadJS detects a numeric part in the source value and increments that numeric part during the fill operation.

For example, SpreadJS can fill strings that contain only numbers, strings with a number at the end, and strings with a number at the beginning. If the selected values do not form a supported series pattern, SpreadJS copies the values in the same order.

Strings that contain numbers at the beginning and strings that do not form a numeric series can also be filled based on the detected pattern.

String Series Behavior

When filling a string series, SpreadJS detects numeric parts in the source values. A numeric part can contain half-width digits (0 to 9), full-width digits (０ to ９), or a supported mix of both.

The following table shows common string series patterns.

When a single string value is copied after drag fill, users can open the fill options menu and select Fill Series to generate a series.

Full-Width Digits in String Series

String series can include full-width decimal digits (０ to ９). During series detection, SpreadJS treats full-width digits as numeric digits, equivalent to half-width digits (0 to 9).

This recognition is always enabled and is not limited to CJK cultures. Full-width and half-width digits can also be mixed within the same numeric token. SpreadJS parses the combined token as one number and preserves the digit-width pattern from the source value when generating the filled values.

The following table shows examples of string series that include full-width digits.

Culture-specific string patterns, such as CJK text-number-text patterns and linker patterns, still depend on the active culture.

Using Code

You can also fill a string series programmatically by using the fillAuto method.

The following code sample fills a string series that contains full-width digits.

const sheet = spread.getActiveSheet();

sheet.setValue(0, 0, "a１");

sheet.fillAuto(
    new GC.Spread.Sheets.Range(0, 0, 1, 1),
    new GC.Spread.Sheets.Range(0, 0, 4, 1),
    {
        fillType: GC.Spread.Sheets.Fill.FillType.auto,
        series: GC.Spread.Sheets.Fill.FillSeries.column,
        fillDirection: GC.Spread.Sheets.Fill.FillDirection.down
    }
);

// Result:
// a１
// a２
// a３
// a４