/
XLSPLAIN output has cells with wrong format.

XLSPLAIN output has cells with wrong format.

Owned by martinajindrova
Jan 15, 2025

KB-20250115-01

Version

XFRX 22.5

Symptoms

Cells that are filled according to a text field from a report with a dynamic format have the wrong format, such as color, font name, font style, etc.

Cause

  • Text field in report has defined dynamic format expression(s).
  • Used XFRX#LISTENER.
  • Output is one from list: XLS, XLSPLAIN, NATIVE_FXLSX, NATIVE_PFXLSX, NATIVE_FODS, NATIVE_PFODS

XFRX#LISTENER creates a unique identifier for each unique format combination, but if the format has not been changed, the default identifier has not been set.

Workaround

None.