Gnobelix

@MikeW, Thanks for the reply. I found a solution to my problem. The solution: Enter the following formula in Excel. =IF(NUMBER(A3:A12);SUM(A3:A12);"") and not instead of the total I don't know if the formula is translated correctly into English. The German formula is (=IF(ANZAHL(A3:A12);SUMME(A3:A12);"") Cheers

Hello everyone, I have a question about data merging in Publisher. I have created an Excel sheet where number of pieces, weights, etc., are entered. At the end of the columns, there is a formula for summing up, providing, for example, the total quantity. In columns with no values, Excel typically outputs a sum of zero, which can be hidden. However, in Publisher, the hidden values are displayed as zeros. My question is: is there a way in the Publisher to hide these zero values? Thanks in advance. Cheers

Thanks for the explanation. Cheers

I think the layer (pexels-lumn-1028600) needs to be rasterized, then Inpainting should work. Cheers

Hallo Alexander, blende die Lineale ein (Ansicht – Lineale einblenden), oben links mit einem Rechtsklick auf die Einheiten klicken, mm auswählen. Das Panel Transformation zeigt jetzt mm an. Cheers

Hello @BP101782, In fact, it looks very different. My first thought, check the color profiles. The message issued was only output in V2 for me. Maybe Serif employees have an explanation. Cheers

Hello @BP101782, welcome to this forum. Have you tried the Affinity 2 trial in the past? That would explain the message, "The file contains functionality from a later version of Affinity." Normally, files from V1 are opened in V2 as a copy and displayed correctly. It is impossible to determine from a distance why the file is not opening correctly. Can you please upload a sample file of V1 with a detailed description of what the difference is between V1 and V2? Cheers

Waited a long time, but now it's here, the spiral tool.👍👍 Initial tests with the new tool are promising. Thanks to the Serif team. Cheers

No problems here, like with @Return on Windows 11 with a Nvidia graphics card GTX 1050 TI. SO not a particularly powerful graphics card. Is the graphics driver up to date? Cheers

I have, on Windows 11 merge your data, all without any problems. (Sheet: YearA-Pentecost) Cheers

Hello @GatoL0c0, Welcome to this forum. I had a similar problem, I formatted the date in Excel user defined. DD.MM.YYYY (in German TT.MM.JJJJ) I hope it helps. Cheers

Hello Pete, I think you need to set the vector brush to the overlay blend mode. Cheers

Hello all, A small bug in all three beta versions (2.2.0.1986) When I use the pen tool and want to change the stroke width with the slider, the stroke width values are not displayed. Cheers

Many Thanks for the explanation. Cheers

Hello into, unfortunately, I only have the file for Publisher Beta left, I deleted the others a little prematurely. The Excel file only has fantasy names, but the same structure as the original file. Cheers Test.afpub Abfrage Kartenausgabe LFV Rückgabe-2023-1.xlsx

Hello everyone, I have a question about Affinity Publisher. I'm using a database, from which some data is exported to Excel. The Excel table is used for data merging in Publisher. Certain data should only be output once, for example, the year, the number of cards, etc. Other data such as name, first name, place of residence, etc., will be output as a list on the pages. I've designed the layout on the master page. Fields that are to be output only once are also on the master page, while all other data will be output on the pages. In the preview, everything looks as desired. However, when I try to print or export the file, then I receive the following warning messages. No Data Sours covers the Page where Field "Jahr" is used. What am I doing wrong? If I ignore the warning messages, everything is output as expected. Cheers

Hallo Sabrina, willkommen in diesem Forum. Um ein Foto in Designer zu bearbeiten, musst du zur Pixel-Persona wechseln. Erstelle eine Auswahl, die du bearbeiten möchtest. Dann gehe zur Menüleiste Ebene Neue Anpassung, dort werden alle verfügbaren Anpassungen angezeigt. Ich hoffe, das hilft. Cheers

Hi everyone, Same here, as described by @Dennison. With a difference, this corrects not itself when the file is closed and re-opened. Cheers

Hallo @Wernyco, Ich denke, hier solltest du fündig werden. Gimic läuft auf Windows 11, ohne Probleme. (Photo 2.1.1 und Photo Beta 2.2) Cheers

Hello @Zlobenia, Just an idea, it could be that the feather of the selection tool is not set to 0 pixels. Cheers

Hello everyone. I can confirm the problem as cgidesign described it. This problem is not new, it was also reported in version 1 as far as I can remember. I use a Huion Inspiroy 1060P. In all other programs, such as Krita, Photoshop, etc., the pen works perfectly. There is another problem with the high precision. Draw a line with the brush, undo this line with CTRL, one point remains visible. (where the brush was applied) Cheers

Hello @MarkWBD export your created graphic as a PNG file with a transparent background. Create a new identity brush and in the Properties panel set the desired parameters. Cheers Test-1.afbrushes

Hello AnaDia, This is not a bug, the function is simply missing. Only Serif can answer why this is so. Cheers

I don't know the changes made to Brightness, Levels-Adjustment and Shadows, but I suspect that this increases the noise. By applying unsharp masking with factor 4, the noise is amplified even more. My tip: first denoising and then sharpening. Cheers

Hello Walt, Thanks for the information. Cheers