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.- Type: XLS FormatterXLS FormatterA XLS Formatter input port that shall be merged.
- Type: XLS FormatterXLS FormatterA XLS Formatter input port that shall be merged.
- Type: XLS FormatterXLS FormatterA XLS Formatter input port that shall be merged.
- Type: XLS FormatterXLS FormatterA XLS Formatter input port that shall be merged.