Difference between EXACT and INTERSECTING LocationMatchingStrategy in google sheets API?

user_9734336 0
Viewed 58

According to google sheets api documentation, LocationMatchingStrategy can be one of EXACT or INTERSECTING.

Determines how this lookup matches the location. If this field is specified as EXACT, only developer metadata associated on the exact location specified is matched. If this field is specified to INTERSECTING, developer metadata associated on intersecting locations is also matched. If left unspecified, this field assumes a default value of INTERSECTING. If this field is specified, a metadataLocation must also be specified.

However, I'm unable to understand this statement. What is "developer metadata associated with exact location"? How this matching works?

google-apps-script google-sheets-api google-sheets
1 Answers

The difference between INSERSECTING and EXACT is clarified in DeveloperMetadataLocationMatchingStrategy:

EXACT_LOCATION: Indicates that a specified location should be matched exactly. For example, if row three were specified as a location this matching strategy would only match developer metadata also associated on row three. Metadata associated on other locations would not be considered.

INTERSECTING_LOCATION: Indicates that a specified location should match that exact location as well as any intersecting locations. For example, if row three were specified as a location this matching strategy would match developer metadata associated on row three as well as metadata associated on locations that intersect row three. If, for instance, there was developer metadata associated on column B, this matching strategy would also match that location because column B intersects row three.

Where the location refers to the DeveloperMetadataLocation specified on the DeveloperMetadataLookup.

user_106120110
Related