[Publisher Data Merge]

34 minutes ago, MikeW said:

No, there's no function to hide zeros...

A couple things. One is just to F/R in Excel.

Another is to treat the zeros as blank text using the formula that sums the values. Something like:

=""&VLOOKUP(A3,C:D,2,FALSE)

Adjust as needed for your sum formula. The important bit are the empty quotation marks and the ampersand at the beginning of the formula. I haven't tested against APub.

A note. While Excel can hide zeros, they are still there. Which is why APub is displaying them.

@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

[Publisher Data Merge]

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

 

 

[Inpainting brush bug when some FX functions applied]

5 minutes ago, Ron P. said:

No, I tried that before I last posted. The Pixel layer needs to be at the top of the Layer stack, if the OP is using a blank pixel layer for removing items.

Thanks for the explanation.

 

Cheers

[Inpainting brush bug when some FX functions applied]

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

 

Cheers

[Change pt in mm in panel group transformation]

13 minutes ago, flying_2000 said:

Hello,

ich benutzze Publisher 2 und möchte in dem Panel "transformation" von pt auf mm Angaben wechseln, so wie es in Publisher 1 möglich war.  Dazu finde ich jedoch keone Einstellungsmöglichkeit. Ich nutze mm Angaben durchweg für alle Felder und Bildgrößen. Kann mir jemand diese sicherlich ganz simplew Frage beantworten?

Herztlichen Dank
Alexander

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

[V1 Files to V2 Files?]

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

[V1 Files to V2 Files?]

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

[Spiral Tool]

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

[FX very slow rendering on Windows AFPub - AFDesigner]

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

[APub Template causes Data Merge Manager Crash]

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

Cheers

[Date from Data Merge varies CSV vs XLS]

22 hours ago, GatoL0c0 said:

I've have this weird bug when doing a data merge in V2.2.

If I try importing data from an XLS with a date, instead of displaying for example, 10/13/2023, it displays one day behind 10/12/2023. When I import the same file saved as a CSV, the data imports fine.

I'm on PC Windows 10 22H2 with the full Affinity Suite 2.2. I have experienced this bug in all prior versions of Affinity. I'll continue to used CSV instead of XLS but it's strange that the data won't merge correctly unless I use a CSV.

 

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

 

[Vector brush on PNG with transparency]

29 minutes ago, P e t e said:

Hi

Designer 2.2, Win10

I have a PNG dragged into designer which has transparency.

Using the Vector brush tool (I think!), I could paint a solid colour in selected transparent areas and the brush wouldn't touch the non-transparent areas. 2 hours ago. Now I can't do it again(!)

I *think* it was the vector brush tool. It is the same PNG image with transparency.

There must be an option I have inadvertantly selected/deslected or maybe it was a different tool (don't think so)

#goingmad

any help please, thanks

Pete

Hello Pete,

I think you need to set the vector brush to the overlay blend mode.

Cheers

[A small bug in all three beta versions (2.2.0.1986)]

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

[Question about Publisher (Vesrion 1 or Version 2)]

41 minutes ago, anto said:

You are doing everything right. This is a message from the master page because the data source is deleted after the data merge. If you want to make sure, add the data source again and the message will disappear.

Many Thanks for the explanation.

 

Cheers

[Question about Publisher (Vesrion 1 or Version 2)]

4 hours ago, anto said:

Can you attach the excel file as well as Publisher (only example, not original)? Or at least show screenshots with layers.

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

[Question about Publisher (Vesrion 1 or Version 2)]

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

[Affinity Designer Foto bearbeiten]

1 hour ago, Sabrina Sunnys said:

hallo zusammen! ich versuche, im affinity designer ein foto zu bearbeiten. gibt es eine funktion, wo der kontrast bzw. die helligkeit innerhalb vom bild nur bei gewissen stellen angepasst werden kann? das ganze bild ist mir klar, aber nur stellenweise anpassung habe ich bisher nicht herausgefunden. 

danke für eure hilfe! 

herzlich, sabrina

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

[Cannot click and select with Move Tool]

Hi everyone,

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

 

Cheers

[G'MIC version to download for Windows 10?]

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

[Why is my program antialiasing selections when it shouldnt be?]

Hello @Zlobenia,

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

 

Cheers

[APh 2.1 - not respecting right click on pen when in Windows Ink mode]

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

[Problem creating custom brush]

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

[2.1.0 develop persona - curves tool]

15 hours ago, AnaDia said:

I just started using the curves tool a little bit more. Within the develop persona I'm now missing the option to use the curser keys for fine movements of the nodes. Is this feature missing here or is this a bug in the develop persona? It works great for the curves tool in the photo persona.

 

Hello AnaDia,

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

 

Cheers

[sharpen live layer created a reticulation with dots]

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

[Problems with the dictionary.]

13 hours ago, walt.farrell said:

That is the folder where you would install additional language dictionaries if you need them.

Words that you tell Publisher to Learn are stored (on Windows) in the dictionary.propcol file in the Common folder for your username. E.g., with MSIX look at %USERPROFILE%\.affinity\Common\2.0 (Beta)\user\dictionary.propcol but for EXE/MSI it would be %AppData%\Affinity\Common\2.0 (Beta)\user\dictionary.propcol

Hello Walt,

Thanks for the information.

 

Cheers