XLS Format Merger

The XLS Format Merger node combines two or more XLS formatting instruction sets (i.e. ports) to one.

This node can be used to combine formatting instructions set for different sheets (using the XLS Sheet Selector node) prior to the XLS Formatter (apply) node. When applied to the same sheet, properties are merged at the lowest detail level (e.g. cell A1's font formatted as bold merged with A1 font italic yields bold and italic). Thereby, the upper input port overwrites a lower one in case of conflicting information (e.g. two different font colors for the same cell). In case of overlapping cell merge ranges, this node fails. Be aware that when merging the default sheet and a named sheet, this can cause the XLS Formatter (apply) node to fail later, if both of these point to the same XLS sheet.

Input ports

1. Type: XLS Formatter
   XLS Formatter
   A XLS Formatter input port that shall be merged.
2. Type: XLS Formatter
   XLS Formatter
   A XLS Formatter input port that shall be merged.

Output ports

1. Type: XLS Formatter
   XLS Formatter
   The XLS Formatter output port with the combined formatting instructions of all input ports.

input (Dynamic Inport)

A XLS Formatter input port that shall be merged.

1. Type: XLS Formatter