Beta 2.0.3.1670.
In Excel:
The Origine sheet shows the values and Excel formulas used vertically; the Fusion sheet is used for input.
In Affinity Publisher:
To get the formula in Excel, click in Excel on the value in the Excel value column. In the Excel Number Format bar, go to the Custom menu, and copy the type.
excel-data.mp4
The numeric formula 0 should produce the value 12 for the entry 12,345, but it produces the value 12,345.
The monetary formula _-* # ##0.00 €_-;-* # ##0.00 €_-;_-* "-"? €_-;_-@_- produces a space in front of the number that should not appear in Affinity Publisher.
The personal time formula [h] "h" mm "min" ss "s";@ should produce the value 296 h 16 min 48 s, but it produces the value 8 h 16 min 48 s.
source.xlsx
Excel.afpub