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

Gnobelix

Members
  • Posts

    948
  • Joined

  • Last visited

Posts posted by Gnobelix

  1. 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

  2. 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

     

     

  3. 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

    mm.png

  4. 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

  5. 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

     

  6. 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

    Unbenannt.png

  7. 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

  8. 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

  9. 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

    Anpassung.png

×
×
  • 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.