Function BuildCopyRequests

internal/sheetsvalidation/copy.go:32–178

(
	source, destination *sheets.GridRange,
	transpose bool,
	spans []Span,
	options ...CopyOptions,
)

}

func BuildCopyRequests(
	source, destination *sheets.GridRange,
	transpose bool,
	spans []Span,
	options ...CopyOptions,
) ([]*sheets.Request, error) {
	if source == nil || destination == nil ||
		source.EndRowIndex <= source.StartRowIndex || source.EndColumnIndex <= source.StartColumnIndex ||
		destination.EndRowIndex <= destination.StartRowIndex || destination.EndColumnIndex <= destination.StartColumnIndex {
		return nil, nil
	}

	destination = EffectiveCopyDestination(source, destination, transpose)
	sourceSpans := RelevantSourceSpans(source, spans)
	ordinarySourceRanges := SubtractSpans(source, sourceSpans)
	destinationSpan, hasDestinationTable := FirstIntersectingSpan(destination, spans)

	opts := CopyOptions{}
	if len(options) > 0 {
		opts = options[0]
	}

	if hasDestinationTable && len(ordinarySourceRanges) > 0 {
		if !opts.OrdinarySourceValidationKnown {
			return nil, invalidf(
				"copying validation into table column %d in table %s requires a table-column source",
				destinationSpan.ColumnIndex+1,
				destinationSpan.TableID,
			)
		}

		for _, candidate := range spans {
			if spanIntersects(destination, candidate) &&
				ordinaryValidationMapsToSpan(
					source,
					destination,
					transpose,
					opts.OrdinaryValidatedCells,
					ordinarySourceRanges,
					candidate,
				) {
				return nil, invalidf(
					"copying ordinary cell validation into table column %d in table %s is not supported",
					candidate.ColumnIndex+1,
					candidate.TableID,
				)
			}
		}
	}

	if len(sourceSpans) == 0 && !hasDestinationTable {
		return nil, nil
	}

	merged := []copySegment{}

	if len(sourceSpans) > 0 {
		segments, err := buildCopySegments(source, destination, transpose, sourceSpans)