Jump to content
You must now use your email address to sign in [click for more info] ×

Data merge manager


Recommended Posts

Beta 2.0.3.1670.

excel.png.f61f6f2ec62daeefdd37ba9dca5344cf.png

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.

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

Edited by Pyanepsion
Explanation on how to obtain the Excel formulas

6 cœurs, 12 processus - Windows 11 pro - 4K - DirectX 12 - Suite universelle Affinity (Affinity  Publisher, Affinity Designer, Affinity Photo).

Mais je vous le demande, peut-on imaginer une police sans sérifs ?

Link to comment
Share on other sites

@anto,

It does seem that Libre Office Calc (is it the same with Open Office Calc?) can pretty much load an Excel file, but it doesn't know how to convert that original XLSX file to... change nothing, and then it produces a corrupted file.

Affinity Publisher is not responsible for the malfunction of Libre|Open Office Calc.

The Excel file I provided was created from Microsoft Office Professional 2021 and loads correctly.

😃That's good! We can concentrate on solving the 3 formulas above.

6 cœurs, 12 processus - Windows 11 pro - 4K - DirectX 12 - Suite universelle Affinity (Affinity  Publisher, Affinity Designer, Affinity Photo).

Mais je vous le demande, peut-on imaginer une police sans sérifs ?

Link to comment
Share on other sites

If the original Excel file works correctly, but the Libre Office Calc Excel export 2 does not, and the Open Office Calc export 2 does not, it means that these two free suites are buggy.

(But… Since the Mac version of Affinity Publisher knows how to fix these bugs in these two free suites, it would be nice if the Windows version did too. However, in my humble opinion, this is another report.)

6 cœurs, 12 processus - Windows 11 pro - 4K - DirectX 12 - Suite universelle Affinity (Affinity  Publisher, Affinity Designer, Affinity Photo).

Mais je vous le demande, peut-on imaginer une police sans sérifs ?

Link to comment
Share on other sites

I did not find any regression either. It's just that the consequences are disastrous, because the values displayed in Affinity Publisher don't correspond to those calculated, and they are difficult to detect on simple rereading when they are buried in a lot of other figures. Not for the end customer.

6 cœurs, 12 processus - Windows 11 pro - 4K - DirectX 12 - Suite universelle Affinity (Affinity  Publisher, Affinity Designer, Affinity Photo).

Mais je vous le demande, peut-on imaginer une police sans sérifs ?

Link to comment
Share on other sites

  • 2 months later...
  • Staff

The issue "Some custom formulas aren't importing correctly" (REF: AFB-7027) has now been fixed by the developers.
This fix is included in build 2.1.0.1709 (or later) which is already available as a customer beta and will be included in the next release.
Customer beta builds are announced here and you can participate by following these instructions.

If you still experience this problem once you are using that build version (or later) please make a new thread referencing this one.

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.