The <table:scenario> element defines a scenario for display on a another table. A table represented by a <table:table> element which contains a <table:scenario> child element is called a scenario table.

A scenario are one or more cell ranges of a table whose contents temporarily replaces the contents of the cell ranges in the nearest non-scenario table preceding the scenario table in document order. If multiple scenarios are defined for a cell range, an user may choose between the scenarios. The names of the scenarios are the
same as the names of tables which contain the <table:scenario> elements.

The visibility of a scenario table is controlled by its style. Only one scenario table can be applied per table at the same time.

With minor changes to the last sentence:

The <table:scenario> element defines a scenario for display on a table. A table represented by a <table:table> element which contains a <table:scenario> child element is called a scenario table.
A scenario is one or more cell ranges of a table whose contents temporarily replaces the contents of the cell ranges in the nearest non-scenario table preceding the scenario table in document order. If multiple scenarios are defined for a cell range, an user may choose between the scenarios. The names of the scenarios are the same as the names of tables which contain the <table:scenario> elements.

The visibility of a scenario table is controlled by its style. Only one scenario table can be applied to a table at one time.